January 2013 - BaseX-Talk - mailman.uni-konstanz.de

BaseX 7.5 Update - Soft-Files.com
by Soft-Files Team 14 Jan '13

14 Jan '13

Dear Developer, Your product BaseX 7.5 has been updated. Your product review page is located at: http://www.soft-files.com/basex_72311.html. Sincerely, The Soft-Files Team

1 0

Re: [basex-talk] data visualisation from BaseX
by pw＠themail.co.uk 13 Jan '13

13 Jan '13

Following my last posting I have rebuilt the database using 36 rather than 12 collections and it seems to perform better. I hope you now have a better chance of accessing the datasets. Peter Hello List http://www.semantechs.co.uk/ has so much data in a BaseX database (of course). How best to visualise? Any ideas of which libraries would be the best fit to develop a restxq front end to this dataset? [the server isn't very performant, so apologies if its slow/stopped. I'd appreciate your suggestions nonetheless] Cheers Peter

1 0

DB backup not backing up images saved as raw files
by France Baril 11 Jan '13

11 Jan '13

Hi, How would I get around that issue? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

4 5

Query slow via PHP
by Mayer, Jonathan 11 Jan '13

11 Jan '13

Hi, Hope you can help a very novice basex/xquery user! I have the following query to get the complete XML of the "Links.xml" document in the "project" collection. for $doc in collection('project') where matches(document-uri($doc), '^Links.xml') return $doc When running this command in basex on linux it completes in around 2.5 seconds (acceptable speed given the size of the XML file) but when I run it via PHP using the client from the website, it takes around 15 seconds: $session = new Session("localhost", $host, $username, $password); $input = "for \$doc in collection('project') where matches(document-uri(\$doc), '^Links.xml') return \$doc"; $query = $session->query($input); $xml = $query->execute(); Any idea why it might take so long, or whether rewriting my query in a different way would speed up the response? Thanks, Jon.

7 13

data visualisation from BaseX
by pw＠themail.co.uk 11 Jan '13

11 Jan '13

Hello List http://www.semantechs.co.uk/ has so much data in a BaseX database (of course). How best to visualise? Any ideas of which libraries would be the best fit to develop a restxq front end to this dataset? [the server isn't very performant, so apologies if its slow/stopped. I'd appreciate your suggestions nonetheless] Cheers Peter

1 0

Concurrent Query Execution
by happy somani 10 Jan '13

10 Jan '13

Hey Guys, I was trying a scenario out today and wanted to see if I could query two different databases in parallel. I tried out using the code attached and found that while one of the program was trying to write data to a database the other program waits for the write to the database to finish before it could read data from a database. I am attaching the code in this email and here are the steps that you would need to take to reproduce this issue. 1. Run the UploadFileTest class. (This class is trying to create a db using a large xml file) 2. Run the GetData class (This class is trying to read from a small database called sam. The sam database is being created in this program). I would appreciate if somebody could help me in setting up this concurrent query execution framework or if I have been doing something in the wrong way. Thanks. -- Regards Happy

3 3

XQuery update: updating inside a closure & how to modify a node and insert it in a DB
by Daniel Kvasnička 10 Jan '13

10 Jan '13

Hi folks, I'm trying to implement a secure RESTXQ service like this: declare %rest:path("api/users/init") %restxq:PUT("{$data}") %output:method("text") function page:init-user($data) { sec:secure(function() { let $profile := json:parse-ml(convert:binary-to-string($data)) return ( insert node attribute id { sec:get-current-user-id() } into $profile, insert node $profile as last into db:open("db")/s:root ) }) }; And I have two problems: - when executing it like this, inside of a closure, nothing happens. No modifications of the database and no errors (%updating missing) either - which is weird. Is this construct supported in 7.5? - when I remove the sec:secure call and leave only the rest (adding %updating to the declaration) the second insert runs but the first one doesn't - the node is saved without a "id" attribute. Does this have something to do with the PUL order? (http://docs.basex.org/wiki/Update#Example) Thanks for your hints! I feel like I'm overlooking something obvious... Daniel -- danielkvasnicka.net

4 9

example .basexperm files please
by pw＠themail.co.uk 09 Jan '13

09 Jan '13

hello list are there any examples of .basexperm files for use with the WAR distribution or the httpserver? what form are the global permissions described for each user? [i.e. 0777, or -rwxrwxrwx, or some other form] Is the separator a space or a tab? [does it matter?] thanks Pete

3 3

Either db:replace() or I had too much to drink this XMas
by France Baril 08 Jan '13

08 Jan '13

Hi, I am having issues with updating functions in BaseX 7.5 (official release). When I update a document, its content is updated with the content of another document. I even perform the db:optimized in a separate function after a forward to ensure that the db:replace is in fact completed before indexes are optimized. * * To replicate: you'll need a db named 'en-us' with the 3 following documents (file names don't matter): <menu id="devicehelp"/> <menu id="smbonly"/> <menu id="ptt-help"/> Then use these functions: * * *declare* %rest:path("/admin/refresh-menu-headings") %rest:GET %rest:query-param("menu-id", "{$menu-id}", "devicehelp") *updating* *function* *admin:refresh-menu-headings*(*$menu-id* *as ** xs:string*){ (:Get the content:) *let* *$raw-menu* := *app:open-db*('en-us')/*menu*[*@id* = *$menu-id* ] (:Get the file location:) *let* *$menu-uri* := *substring-after*(*$raw-menu*/*base-uri*(), 'en-us/') (:Copy the content:) *let* *$menu* := *$raw-menu* * (:Output the content in a file to ensure you have the right one:)* * **let* *$debug* := *file:write*('debug-ouch.xml', *document*{*$menu* }) (:Output the file uri to ensure you have the right one:) *let* *$debug-uri* := *file:write*('debug-uri.xml', *$menu-uri*) (:Replace the content of the file with the same content that was outputted in debug-ouch:) *return *(*db:replace*('en-us', *$menu-uri*, *$menu*), *db:output*(<restxq:forward> /restxq/admin/success/heading-refresh</restxq:forward>)) }; *declare* %rest:path('/admin/success/heading-refresh') *updating* *function* *admin:success-heading-refresh*(){ *let **$result* := <html *xmlns*=*"http://www.w3.org/1999/xhtml"*> <head><title>Add headings to menu topicrefs </title></head> <body> <h2>Add headings to menu topicrefs</h2> <ul> <li *style*=*"color:green"*>Menus were updated successfully.</li> </ul> </body> </html> *return *(*db:optimize*('en-us'), *db:output*(*$result*)) RESULT: The result after optimize if your query for a list of the /menu/data(@id) should be devicehelp, smbonly, ptt-help, but it's ptt-help, smbonly, ptt-help. debug-ouch.xml shows the correct content (content of menu devicehelp), debug-uri shows the right file path (path of menu ptt-help), yet the content of menu with @id devicehelp gets replaced by the content of menu with @id=ptt-help after db:replace. Note: If I use db:optimize('en-us', true()), I get 'unexpected error: 0' -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 6

Request for UPDINDEX option setting via BaseX GUI
by France Baril 05 Jan '13

05 Jan '13

Hi, I could not find how to set the UPDINDEX option to true() in the BaseX Gui. I also looked in .basexgui. Can you tell me where it is, or may I submit a request to include it. I could write a script, but it's so much easier to get my users to import content with the GUI. Best regards, France -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 1