Hi Ben,
> Is it possible to change the query-statement in such a way that the
> results are added to MariaBases/<DB-schema>/<table-name>?
If I get you right, you would like to read your tabular MariaDB data
via SQL select statements and add the contents to your new BaseX
database, right?
You might want to do something as follows:
sql:init('org.mariadb.jdbc.Driver'),
(: connect to the database, read table contents :)
let $db := '<DB-name>'
let $table := 'Mdw_Wens'
let $con := sql:connect(
'jdbc:mariadb://localhost:3306/' || $db,
'<user>', '<password>'
)
let $rows := sql:execute($con, 'select * from ' || $table)
(: create new document with transformed table contents :)
let $doc := element { $table } {
for $row in $rows
return element row {
for $col in $row/sql:column
return element { $col/@name } { $col/data() }
}
}
(: add new document to your BaseX database :)
return db:add($db, $doc, $table || '.xml')
Could you give us little examples for <DB-name>, <DB-schema> and <table-name> ?
Best,
Christian
