11.1 Session Objects and Functions

Session

The syntax for this object shown in EBNF is:

Session
    ::= '.getSchema(' StringLiteral ')'
        | '.getSchemas()'
        | '.createSchema(' StringLiteral ')'
        | '.dropSchema(' StringLiteral ')'
        | '.getDefaultSchema()'
        | '.startTransaction()'
        | '.commit()'
        | '.rollback()'
        | '.setSavepoint()'                    
        | '.setSavepoint(' StringLiteral ')'
        | '.releaseSavePoint(' StringLiteral ')'
        | '.rollbackTo(' StringLiteral ')'
        | '.close()'
        | SqlExecute

Figure 11.1 Session

SqlExecute

The syntax for this function shown in EBNF is:

SqlExecute
    ::= '.sql(' SqlStatementStr ')'
        ( '.bind(' Literal (',' Literal)* ')')*
        ( '.execute()' )?

Figure 11.2 SqlExecute

SQLPlaceholderValues

The syntax for this function shown in EBNF is:

SQLPlaceholderValues
  ::= '{' SQLPlaceholderName ':' ( SQLLiteral ) '}'

Figure 11.3 SQLPlaceholderValues

SQLPlaceholderName

The syntax for this function shown in EBNF is:

SQLPlaceholderName
  ::= '?'

Figure 11.4 SQLPlaceholderName

SQLLiteral

The syntax for this function shown in EBNF is:

SQLLiteral
  ::= '"' StringLiteral '"' | Number | Document

Figure 11.5 SQLLiteral