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

how to store a result in a database?
by thufir 20 Feb '20

20 Feb '20

While I can certainly output the result to a file, and then add to a database, how would I actually send the result directly to a database? xquery version "3.0"; <xml> { for $line in db:open("people.json")//text() return if (matches($line, "[0-9]")) then <data>{$line}</data> else <record>{$line}</record> } </xml> Currently I'm running it like so: thufir@dur:~/flwor/people.json$ thufir@dur:~/flwor/people.json$ basex all.xq > all.xml thufir@dur:~/flwor/people.json$ thufir@dur:~/flwor/people.json$ basex BaseX 9.0.1 [Standalone] Try 'help' to get more information. > > create database people.all Database 'people.all' created in 234.74 ms. > > set parser xml PARSER: xml > > add all.xml Resource(s) added in 377.43 ms. > > exit Have fun. thufir@dur:~/flwor/people.json$ but that's a bit cumbersome. thanks, Thufir

3 3

empty tags when grouping with tumbling window?
by thufir 20 Feb '20

20 Feb '20

I found (another) wrinkle to parsing this data because blank lines seem to cause a problem with the grouping. The grouping should "use a tumbling window which starts with any line not containing any ASCII digit (the name of the person) followed by any line containing at least one ASCII digit (i.e. the data lines)": current output: <xml> <person> <name>joe</name> <data>phone1</data> <data>phone2</data> <data>phone3</data> <data>sue</data> <data/> <data>cell4</data> <data/> <data>home5</data> <data/> <data>ph3</data> </person> <person> <name>alice</name> <data>atrib6</data> <data>x7</data> <data>y9</data> <data>z10</data> </person> </xml> where "joe" and "sue" have been put into the same person tag. desired output, more like: <?xml version="1.0" encoding="UTF-8"?> <xml> <person> <name>joe</name> <data>phone1</data> <data>phone2</data> <data>phone3</data> </person> <person> <name>sue</name> <data>cell4</data> <data>home5</data> </person> <person> <name>alice</name> <data>atrib6</data> <data>x7</data> <data>y9</data> <data>z10</data> </person> </xml> xquery: xquery version "3.0"; declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization"; declare option output:method 'xml'; declare option output:indent 'yes'; declare variable $input := <text> <line>people</line> <line>joe</line> <line>phone1</line> <line>phone2</line> <line>phone3</line> <line>sue</line> <line/> <line>cell4</line> <line/> <line>home5</line> <line/> <line>ph3</line> <line>alice</line> <line>atrib6</line> <line>x7</line> <line>y9</line> <line>z10</line> </text>; <xml> { for tumbling window $person in $input//line start $name next $data when matches($name, '^[^0-9]+$') and matches($data, '[0-9]') return <person> { <name>{ data($name) }</name>, tail($person) ! <data>{data()}</data> } </person> } </xml> Provided the grouping is correct that would be the main goal. Unfortunately, don't fully understand how the tumbling window works as of yet, so reviewing that section of a text book. see also: https://stackoverflow.com/q/60237739/262852 thanks, Thufir

1 0

increment a variable only when a conditional is true?
by thufir 20 Feb '20

20 Feb '20

How can I increment the x variable only when numerical is false? (I've been reading how xquery isn't iterative...) current output: <xml> <person id="1" x="0" numerical="false">people</person> <person id="2" x="0" numerical="false">joe</person> <person id="3" x="0" numerical="true">phone1</person> <person id="4" x="0" numerical="true">phone2</person> <person id="5" x="0" numerical="true">phone3</person> <person id="6" x="0" numerical="false">sue</person> <person id="7" x="0" numerical="true">cell4</person> <person id="8" x="0" numerical="true">home5</person> <person id="9" x="0" numerical="false">alice</person> <person id="10" x="0" numerical="true">atrib6</person> <person id="11" x="0" numerical="true">x7</person> <person id="12" x="0" numerical="true">y9</person> <person id="13" x="0" numerical="true">z10</person> </xml> desired output: <xml> <person id="1" x="1" numerical="false">people</person> <person id="2" x="2" numerical="false">joe</person> <person id="3" x="2" numerical="true">phone1</person> <person id="4" x="2" numerical="true">phone2</person> ... </xml> Maybe with a second xquery? Here's the first: xquery version "3.0"; <xml> { variable $x:=0; for $line in db:open("foo.txt")//text() count $id return if (matches($line, "[0-9]")) then <person id='{$id}' x='{$x}' numerical="true">{$line}</person> else <person id='{$id}' x='{$x}' numerical="false">{$line}</person> } </xml> where I'm trying to use attributes because I'm not sure how to conditionally nest tags. But, this is interesting. Not quite sure on syntax to set and then conditionally increment $x, however. thanks, Thufir

3 7

how to nest tags using a conditional
by thufir 19 Feb '20

19 Feb '20

How can I start a new "record" and then nest tags in that record? but I'm getting output like: <xml> <record> if (matches($line, "[0-9]")) then <data>people</data> else <name>people</name> </record> <record> if (matches($line, "[0-9]")) then <data>joe</data> else <name>joe</name> </record> .. wheras I just want output like: <record> <name>joe</name> <data>123</data> </record> the query: xquery version "3.0"; <xml> { for $line in db:open("foo.txt")//text() return <record> if (matches($line, "[0-9]")) then <data>{$line}</data> else <name>{$line}</name> </record> } </xml> I think it's a matter of using the () and {} correctly. Pardon, yes, I'm literally reading a book on this, still trying to understand the syntax. thanks, Thufir

2 2

Restore original lay-out
by Ben Engbers 18 Feb '20

18 Feb '20

Hi, I don't know how ;( but somehow I managed to change the layout for the GUI. Now I have the Result-panel in top of the Info-panel. How can I restore the original lay-out (Result to bottom-left and Info to bottom-right)? Cheers, Ben

2 1

How to export or query JSON as an array?
by thufir 17 Feb '20

17 Feb '20

Using Java, I can add JSON easily enough. But how can I get that data back as a JSONArray, or even just a List of JSONObject? https://stackoverflow.com/q/60268157/262852 which is the same question, of course. thanks, Thufir

1 1

How to programatically add JSON?
by thufir 16 Feb '20

16 Feb '20

I know I've gone around on this before, but looking to import data directly from Java. I've set the parser to "json", am only adding JSONObject string data, and not JSONArray, but am getting "resource not found": https://stackoverflow.com/questions/60250724/ What does it mean "resource not found"? The data is certainly valid, because the following will import JSON the fine, in fact it even imports the array: let $database := "blgdfmbljm" for $name in file:list('.', false(), '*.json') let $file := file:read-text($name) let $json := json:parse($file) return db:add($database, $json, $name) dummy data: [{"0":"","1":"z10","2":"y9","3":"x7","4":"atrib6","name":"alice"},{"0":"home5","1":"cell4","name":"sue"},{"0":"phone3","1":"phone2","2":"phone1","name":"joe"},{"name":"people"}] So, I guess a two-fold question: how to import a JSONArray with Java, and how to even know what resource isn't found. Doesn't seem likely to be the JSONObject as I've inspected it just prior to invoking Add. thanks, Thufir

1 0

POJO for import?
by thufir 16 Feb '20

16 Feb '20

I'm looking at the Java examples, but how would I add a POJO, or collection of POJO's, to BaseX? Jaxb looks to certainly be an option to serialize to XML, but what would be some alternate approaches? thanks, Thufir

1 0

how to export to CSV?
by thufir 16 Feb '20

16 Feb '20

What I'm trying to export to, CSV: joe,phone1,phone2,phone3, sue,cell4 ,home5,, alice,atrib6,x7,y9,z10 What needs to be done so that it can be exported to CSV: <ul> <li>joe</li> <ul>phone1</ul> <ul>phone2</ul> <ul>phone3</ul> <li>sue</li> <ul>cell4</ul> <ul>home5</ul> <li>alice</li> <ul>atrib6</ul> <ul>x7</ul> <ul>y9</ul> <ul>z10</ul> </ul> But not sure how to get from the above list, which I can rewrite as XML, to something which BaseX can then export as the desired CSV. I know that it has to be wrapped in <csv> and that <record> is used, as well. Something like: <csv> <record> <Name>Huber</Name> <First_Name>Sepp</First_Name> <Address>Hauptstraße 13</Address> <City>93547 Hintertupfing</City> </record> </csv> is what I see in the documentation, but not sure how to get there. thanks, Thufir

3 4

Flat XML fods database
by thufir 14 Feb '20

14 Feb '20

Hi all, I've loaded a .fods file from Libre Office into BaseX and am looking to identify bold cells. This is totally off-topic to BaseX itself, but does anyone have experience in working with .fods files? thanks, Thufir

3 4