SQL Insert Operator Functions

Functions
hash< InsertOperatorInfo >	SqlUtil::iop_seq (string arg)
	returns an InsertOperatorInfo hash for retrieving the value of the given sequence in insert queries
hash< InsertOperatorInfo >	SqlUtil::iop_seq_currval (string arg)
	returns an InsertOperatorInfo hash for retrieving the current value of the given sequence in insert queries
hash< InsertOperatorInfo >	SqlUtil::make_iop (string iop, auto arg)

Detailed Description

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

• iop_seq(): insert the value of a sequence into the column

Function Documentation

iop_seq()

hash< InsertOperatorInfo > SqlUtil::iop_seq

(

string

arg

)

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

Example:

table.insert(("id": id, "ref": iop_seq("xid")));

Parameters

arg	the name of the sequence whose value should be inserted into the column

Returns

an InsertOperatorInfo hash corresponding to the arguments for use in insert queries

iop_seq_currval()

hash< InsertOperatorInfo > SqlUtil::iop_seq_currval

(

string

arg

)

returns an InsertOperatorInfo 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

arg	the name of the sequence whose current value should be inserted into the column

Returns

an InsertOperatorInfo hash corresponding to the arguments for use in insert queries

make_iop()

hash< InsertOperatorInfo > SqlUtil::make_iop	(	string	iop,
		auto	arg )

returns an InsertOperatorInfo hash

Parameters

iop	the value operator (one of SQL Insert Operators)
arg	the argument to the operator

Returns

an InsertOperatorInfo 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