SQL Module - Revision history

CG: Text replacement - "syntaxhighlight" to "pre"

2023-12-01T16:39:41Z

Text replacement - "syntaxhighlight" to "pre"

CG: Text replacement - "" to ""

2023-12-01T16:34:55Z

Text replacement - "</syntaxhighlight>" to "</pre>"

CG: Text replacement - "" to "

2023-12-01T16:30:22Z

Text replacement - "<syntaxhighlight lang="xquery">" to "<pre lang='xquery'>"

Andy Bunce: sql:connect sig remove br add options

2023-07-03T11:25:24Z

sql:connect sig remove br add options

CG at 14:56, 9 March 2023

2023-03-09T14:56:28Z

CG at 14:09, 9 March 2023

2023-03-09T14:09:27Z

CG: Text replacement - "'''Signatures'''" to "'''Signature'''"

2023-03-09T13:07:56Z

Text replacement - "'''Signatures'''" to "'''Signature'''"

CG at 11:08, 9 March 2023

2023-03-09T11:08:13Z

CG at 13:54, 26 January 2023

2023-01-26T13:54:16Z

CG: /* sql:connect */

2022-08-10T14:45:36Z

sql:connect

@@ Line 180: / Line 180: @@
 The result may look like:
-<syntaxhighlight lang="xml">
+<pre lang="xml">
 <sql:row xmlns:sql="http://basex.org/modules/sql">
    <sql:column name="cof_name">French_Roast</sql:column>

@@ Line 47: / Line 47: @@
 <pre lang='xquery'>
 sql:connect('dbc:sqlserver://DBServer', map { 'autocommit': true() })
-</syntaxhighlight>
+</pre>
 |}
@@ Line 94: / Line 94: @@
    }+
 }?
-</syntaxhighlight>
+</pre>
 With {{Code|$options}}, the following parameter can be set:
 * {{Code|timeout}}: query execution will be interrupted after the specified number of seconds.
@@ Line 176: / Line 176: @@
 let $id := sql:connect("jdbc:postgresql://localhost:5432/coffeehouse")
 return sql:execute($id, "SELECT * FROM coffees WHERE price < 10")
-</syntaxhighlight>
+</pre>
 The result may look like:
@@ Line 195: / Line 195: @@
    <sql:column name="total">14</sql:column>
 </sql:row>
-</syntaxhighlight>
+</pre>
 ==Prepared Statements==
@@ Line 213: / Line 213: @@
 (: Execute prepared statement :)
 return sql:execute-prepared($prep, $params)
-</syntaxhighlight>
+</pre>
 ==SQLite==
@@ Line 235: / Line 235: @@
    sql:execute($conn, "select * from person")
+)
-</syntaxhighlight>
+</pre>
 =Errors=

@@ Line 45: / Line 45: @@
 | '''Examples'''
 |Connects to an SQL Server and sets autocommit to {{Code|true}}:
-<syntaxhighlight lang="xquery">
+<pre lang='xquery'>
 sql:connect('dbc:sqlserver://DBServer', map { 'autocommit': true() })
 </syntaxhighlight>
@@ Line 85: / Line 85: @@
 | '''Summary'''
 | This function executes a prepared statement with the specified {{Code|$id}}. The output format is identical to {{Function||sql:execute}}. The optional parameter {{Code|$params}} is an element {{Code|<sql:parameters/>}} representing the parameters for a prepared statement along with their types and values. The following schema shall be used:<br/ >
-<syntaxhighlight lang="xquery">
+<pre lang='xquery'>
 element sql:parameters {
    element sql:parameter {
@@ Line 173: / Line 173: @@
 A simple select statement can be executed as follows:
-<syntaxhighlight lang="xquery">
+<pre lang='xquery'>
 let $id := sql:connect("jdbc:postgresql://localhost:5432/coffeehouse")
 return sql:execute($id, "SELECT * FROM coffees WHERE price < 10")
@@ Line 201: / Line 201: @@
 A prepared select statement can be executed in the following way:
-<syntaxhighlight lang="xquery">
+<pre lang='xquery'>
 (: Establish a connection :)
 let $conn := sql:connect("jdbc:postgresql://localhost:5432/coffeehouse")
@@ Line 219: / Line 219: @@
 The following expression demonstrates how SQLite can be addressed with the [https://bitbucket.org/xerial/sqlite-jdbc/ Xerial SQLite JDBC driver]:
-<syntaxhighlight lang="xquery">
+<pre lang='xquery'>
 (: Initialize driver :)
 sql:init("org.sqlite.JDBC"),

@@ Line 33: / Line 33: @@
 | width='120' | '''Signature'''
 |<pre>sql:connect(
-   $url  as xs:string
+   $url        as xs:string,
-) as xs:anyURI<br/ >{{Func</pre>
+  $options    as map(*)?    := map { }
 |- valign="top"
 | '''Summary'''

@@ Line 57: / Line 57: @@
    $id         as xs:anyURI,
    $statement  as xs:string,
-   $options    as map(*)?    := ()
+   $options    as map(*)?    := map { }
 ) as item()*</pre>
 |- valign="top"
@@ Line 79: / Line 79: @@
    $id       as xs:anyURI,
    $params   as element(sql:parameters),
-   $options  as map(*)?                  := ()
+   $options  as map(*)?                  := map { }
 ) as item()*</pre>
 |- valign="top"

@@ Line 13: / Line 13: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:init(
    $class  as xs:string
@@ Line 31: / Line 31: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:connect(
    $url  as xs:string
@@ Line 53: / Line 53: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:execute(
    $id         as xs:anyURI
@@ Line 75: / Line 75: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:execute-prepared(
    $id       as xs:anyURI
@@ Line 105: / Line 105: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:prepare(
    $id         as xs:anyURI
@@ Line 122: / Line 122: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:commit(
    $id  as xs:anyURI
@@ Line 138: / Line 138: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:rollback(
    $id  as xs:anyURI
@@ Line 154: / Line 154: @@
 {| width='100%'
 |- valign="top"
-| width='120' | '''Signatures'''
+| width='120' | '''Signature'''
 |<pre>sql:close(
    $id  as xs:anyURI

@@ Line 24: / Line 24: @@
 ==sql:connect==
 {| width='100%'
 |- valign="top"
 | width='120' | '''Signatures'''
-|{{Func|sql:connect|$url as xs:string|xs:anyURI}}<br/ >{{Func|sql:connect|$url as xs:string, $username as xs:string, $password as xs:string|xs:anyURI}}<br/ >{{Func|sql:connect|$url as xs:string, $username as xs:string, $password as xs:string, $options as map(*)?|xs:anyURI}}<br/ >
+|{{Func|sql:connect|$url as xs:string|xs:anyURI}}<br/ >{{Func|sql:connect|$url as xs:string, $username as xs:string?, $password as xs:string?|xs:anyURI}}<br/ >{{Func|sql:connect|$url as xs:string, $username as xs:string?, $password as xs:string?, $options as map(*)?|xs:anyURI}}<br/ >
 |- valign="top"
 | '''Summary'''
-|This function establishes a connection to a relational database and returns a connection id. The parameter {{Code|$url}} is the URL of the database and shall be of the form: {{Code|jdbc:<driver name>:[//<server>[/<database>]]}}. If {{Code|$username}} and {{Code|$password}} are specified, they are used as credentials for connecting to the database. The {{Code|$options}} parameter can be used to set connection options.
+|This function establishes a connection to a relational database and returns a connection id. The parameter {{Code|$url}} is the URL of the database and shall be of the form: {{Code|jdbc:<driver name>:[//<server>[/<database>]]}}. Values specified for {{Code|$username}} and {{Code|$password}} are used as credentials for connecting to the database. The {{Code|$options}} parameter can be used to set connection options.
 |- valign="top"
 | '''Errors'''
@@ Line 242: / Line 244: @@
 =Changelog=
 ;Version 9.6