Get account data xquery - Revision history

Admin at 11:00, 24 May 2016

2016-05-24T11:00:35Z

Mligtvoet: added xmldb:encode-uri in db-path

2016-03-31T12:40:02Z

added xmldb:encode-uri in db-path

Mligtvoet at 13:50, 30 October 2015

2015-10-30T13:50:29Z

Mligtvoet at 13:45, 30 October 2015

2015-10-30T13:45:48Z

Mligtvoet: initial setup

2015-10-30T13:41:08Z

initial setup

New page

For exporting usergroup information during an eXist-db this xquery fetches all user groups and meta-information for each user.

To run the xquery below on the server:
{{:run xquery}}

<syntaxhighlight lang="xml" enclose="div">
xquery version "1.0";

declare namespace cfg = "http://exist-db.org/Configuration";

<x>
<users>
{
for $username in sm:list-users()[not(.=('SYSTEM','admin','guest','xis-webservice'))]
return (
<cfg:primary-group user="{$username}" primarygroup="{sm:get-user-primary-group($username)}"/>,
doc(concat('/db/system/security/exist/accounts/',$username,'.xml'))/cfg:account
)
}
</users>
<groups>
{
for $groupname in sm:list-groups()[not(.=('dba','decor','decor-admin','terminology','issues','editor','tools','debug'))]
return
doc(concat('/db/system/security/exist/groups/',$groupname,'.xml'))/cfg:group
}
</groups>
</x>
</syntaxhighlight>

← Older revision		Revision as of 11:00, 24 May 2016
Line 30:		Line 30:

	*Save the output as '''accounts.xml'''. We will need this later on in the import process.		*Save the output as '''accounts.xml'''. We will need this later on in the import process.
		+	[[category:xqueries]]

← Older revision		Revision as of 13:50, 30 October 2015
Line 1:		Line 1:
−	For exporting usergroup information during an eXist-db this xquery fetches all user groups and meta-information for each user.	+	For exporting usergroup information during an eXist-db this xquery fetches all user groups and meta-information for each user. Note that this export will also contain (hashed) passwords for each user.

	To run the xquery below on the server:		To run the xquery below on the server:

← Older revision		Revision as of 13:45, 30 October 2015
Line 28:		Line 28:
	</x>		</x>
	</syntaxhighlight>		</syntaxhighlight>
		+
		+	*Save the output as '''accounts.xml'''. We will need this later on in the import process.

@@ Line 15: / Line 15: @@
      return (
          <cfg:primary-group user="{$username}" primarygroup="{sm:get-user-primary-group($username)}"/>,
-         doc(concat('/db/system/security/exist/accounts/',$username,'.xml'))/cfg:account
+         doc(concat('/db/system/security/exist/accounts/',xmldb:encode-uri($username),'.xml'))/cfg:account
+     )
+}
@@ Line 23: / Line 23: @@
      for $groupname in sm:list-groups()[not(.=('dba','decor','decor-admin','terminology','issues','editor','tools','debug'))]
      return
-         doc(concat('/db/system/security/exist/groups/',$groupname,'.xml'))/cfg:group
+         doc(concat('/db/system/security/exist/groups/',xmldb:encode-uri($groupname),'.xml'))/cfg:group
+}
 </groups>