Qore SqlUtil Module Reference  1.3.2
SQL Insert Operator Functions

Functions

hash SqlUtil::iop_seq (string arg)
 returns a hash for retrieving the value of the given sequence in insert queries More...
 
hash SqlUtil::iop_seq_currval (string arg)
 returns a hash for retrieving the current value of the given sequence in insert queries More...
 
hash SqlUtil::make_iop (string iop, any arg)
 returns a hash with _iop and arg keys More...
 

Detailed Description

These are functions that can be used to give special values in insert queries

Function Documentation

◆ iop_seq()

hash SqlUtil::iop_seq ( string  arg)

returns a hash for retrieving the value of the given sequence in insert queries

Example:
table.insert(("id": id, "ref": iop_seq("xid")));
Parameters
argthe name of the sequence whose value should be inserted into the column
Returns
a value operator description hash corresponding to the arguments for use in insert queries

◆ iop_seq_currval()

hash SqlUtil::iop_seq_currval ( string  arg)

returns a hash for retrieving the current value of the given sequence in insert queries

Example:
table.insert(("id": id, "ref": iop_seq("xid"), "ref2": iop_seq_currval("xid")));
Parameters
argthe name of the sequence whose current value should be inserted into the column
Returns
a value operator description hash corresponding to the arguments for use in insert queries

◆ make_iop()

hash SqlUtil::make_iop ( string  iop,
any  arg 
)

returns a hash with _iop and arg keys

Parameters
iopthe value operator (one of SQL Insert Operators)
argthe argument to the operator
Returns
an insert operator description hash corresponding to the arguments for use as values in insert queries
Note
Normally this function is not called directly, but rather by the other insert operator functions