[MonetDB-users] mapi and xquery
Hi there,
I'm trying to figure out how to use mapi to do an xquery. I have been able to shred documents (using MIL), but mapi with xquery is giving me trouble.
Looking at the implementation of MapiClient, I see the following piece of code which appears relevant:
/* xquery options are passed via the command string (becomes first line of query) */ char *c = command ? command : XQuerydefaultMode; char *t = strstr(c, "timing-") ? "" : mark ? "timing-" : ""; char *d = strstr(c, "debug-") ? "" : trace ? "debug-" : ""; char *m = strstr(c, "-mapi") ? "" : "-mapi";
command = (char*) malloc(strlen(c) + 20); sprintf(command, "%s%s%s%s\n", t, d, c, m);
as well as this code:
if (command) { /* special code for XQuery: prepend command to query */ hdl = mapi_query_prep(mid); CHECK_RESULT(mid, hdl, buf, break); mapi_query_part(hdl, command, strlen(command));
what exactly is going on here? The logic is rather opaque... Is there some minimal code example somewhere out there that shows how to do an xquery using mapi?
Regards,
Martijn
XQuery works a bit different: on the first line you send the options, then after that the query follows.
An example of JdbcClient using it: % JdbcClient -lxquery -p45789 -Xdebug Connection warning: database specifier not supported on this server (mserver_xquery), protocol version 4 Welcome to the MonetDB interactive JDBC terminal! Type \q to quit, \h for a list of available commands auto commit mode: on monetdb-> 1 + <foo>1</foo>; +--------------------------------------------------------------+ | xml | +==============================================================+ | 2.000000 | +--------------------------------------------------------------+ 1 row
monetdb-> % cat monet_1120328168519.log RX 1120328168521: 19 RX 1120328168521: ::mserver_xquery:4
TX 1120328168522: monetdb:monetdb:xquery:blocked
TX 1120328168522: � RX 1120328168523: � RX 1120328168523: new block: 3 bytes RX 1120328168563: read chunk: 3 bytes, left: 0 bytes RX 1120328168564:
TX 1120328171821: write block: 29 bytes TX 1120328171821: xml-seq-mapi 1 + <foo>1</foo> TX 1120328171822: zero block (flush) RX 1120328171822: zero block (flush) RX 1120328171914: new block: 151 bytes RX 1120328171914: read chunk: 151 bytes, left: 0 bytes RX 1120328171914: #- # 3 # querytype # xquery_result, xquery_result # table_name # xml # name # varchar # type # 60 # length # 1 # tuplecount # 1 # id [ "2.000000" ]
The important aspect for you here is the part: TX 1120328171821: xml-seq-mapi 1 + <foo>1</foo>
the newline is what separates the options from the actual query. You probably want to use another query mode though, because xml-seq-mapi generates the headers and tuple format, so the JDBC driver can deal with it.
Martijn Faassen wrote:
Hi there,
I'm trying to figure out how to use mapi to do an xquery. I have been able to shred documents (using MIL), but mapi with xquery is giving me trouble.
Looking at the implementation of MapiClient, I see the following piece of code which appears relevant:
/* xquery options are passed via the command string (becomes first line of query) */ char *c = command ? command : XQuerydefaultMode; char *t = strstr(c, "timing-") ? "" : mark ? "timing-" :""; char *d = strstr(c, "debug-") ? "" : trace ? "debug-" : ""; char *m = strstr(c, "-mapi") ? "" : "-mapi";
command = (char*) malloc(strlen(c) + 20); sprintf(command, "%s%s%s%s\n", t, d, c, m);as well as this code:
if (command) { /* special code for XQuery: prepend command to query */ hdl = mapi_query_prep(mid); CHECK_RESULT(mid, hdl, buf, break); mapi_query_part(hdl, command, strlen(command));what exactly is going on here? The logic is rather opaque... Is there some minimal code example somewhere out there that shows how to do an xquery using mapi?
Regards,
Martijn
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Fabian wrote:
XQuery works a bit different: on the first line you send the options, then after that the query follows.
[snip]
The important aspect for you here is the part: TX 1120328171821: xml-seq-mapi 1 + <foo>1</foo>
the newline is what separates the options from the actual query. You probably want to use another query mode though, because xml-seq-mapi generates the headers and tuple format, so the JDBC driver can deal with it.
Thanks for the info. How can I find out more about what query modes exist and what they do? I don't quite understand what the headers and tuples format is about, for instance.
Regards,
Martijn
Martijn Faassen wrote:
Thanks for the info. How can I find out more about what query modes exist and what they do? I don't quite understand what the headers and tuples format is about, for instance.
The mode (first line) is interpreted in compiler/compile.c (function pf_compile_MonetDB) of the pathfinder repository. The various output modes are implemented in runtime/serialize.mx. The function createWsContext takes the mode there and translates it in an internal code. The function seqHeadStart does start you off finding out whatever is outputted.
participants (2)
-
Fabian -
Martijn Faassen