Qore SqlUtil Module Reference
1.5.2
|
Functions | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_inner (AbstractTable table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for standard inner joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_inner (Table table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for standard inner joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_inner (string table_name, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for standard inner joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_inner (string ta, AbstractTable table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_inner (string ta, Table table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_inner_alias (string ta, string table_name, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_left (AbstractTable table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for left outer joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_left (Table table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for left outer joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_left (string table_name, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for left outer joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_left (string ta, AbstractTable table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_left (string ta, Table table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_left_alias (string ta, string table_name, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_right (AbstractTable table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for right outer joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_right (Table table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for right outer joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_right (string table_name, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for right outer joins with the given arguments More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_right (string ta, AbstractTable table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_right (string ta, Table table, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::join_right_alias (string ta, string table_name, *string alias, *hash jcols, *hash cond, *hash< auto > opt) |
returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::make_jop (string jop, AbstractTable table, *string alias, *hash jcols, *hash cond, *string ta, *hash< auto > opt) |
returns hash keyed with the table name assigned to a JoinOperatorInfo hash More... | |
hash< string, hash< JoinOperatorInfo > > | SqlUtil::make_jop (string jop, string table_name, *string alias, *hash jcols, *hash cond, *string ta, *hash< auto > opt) |
returns a hash keyed with the table name assigned to a JoinOperatorInfo hash More... | |
These are functions that can be used in the join argument in a select option hash:
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_inner | ( | AbstractTable | table, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for standard inner joins with the given arguments
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_inner | ( | Table | table, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for standard inner joins with the given arguments
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_inner | ( | string | table_name, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for standard inner joins with the given arguments
table_name | the table to join with; table will be subject to deferred resolution |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_inner | ( | string | ta, |
AbstractTable | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_inner | ( | string | ta, |
Table | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_inner_alias | ( | string | ta, |
string | table_name, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for standard inner joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table_name | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_left | ( | AbstractTable | table, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for left outer joins with the given arguments
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_left | ( | Table | table, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for left outer joins with the given arguments
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_left | ( | string | table_name, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for left outer joins with the given arguments
table_name | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_left | ( | string | ta, |
AbstractTable | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_left | ( | string | ta, |
Table | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_left_alias | ( | string | ta, |
string | table_name, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for left outer joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table_name | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_right | ( | AbstractTable | table, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for right outer joins with the given arguments
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_right | ( | Table | table, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for right outer joins with the given arguments
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_right | ( | string | table_name, |
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for right outer joins with the given arguments
table_name | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_right | ( | string | ta, |
AbstractTable | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_right | ( | string | ta, |
Table | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::join_right_alias | ( | string | ta, |
string | table_name, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*hash< auto > | opt | ||
) |
returns a hash for right outer joins with the given arguments for use when joining with a table other than the primary table
ta | the table name or alias of the other table to join with when not joining with the primary table |
table_name | the table to join with |
alias | the alias for table in the query |
jcols | the columns to use for the join, the keys will be columns in the source table and the values are columns in the table argument; if this argument is NOTHING, then if there is any foreign key in one table pointing to the primary key of the other table, then this information is automatically assumed as the join condition; a foreign constraint in the current table to the primary key in table will be used first if it exists |
cond | additional conditions for the join clause for the table argument; see Where Clauses for more information |
opt | optional join options (for example, to specify a partition for the join if supported) |
hash<string, hash<JoinOperatorInfo> > SqlUtil::make_jop | ( | string | jop, |
AbstractTable | table, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*string | ta, | ||
*hash< auto > | opt | ||
) |
returns hash keyed with the table name assigned to a JoinOperatorInfo hash
hash<string, hash<JoinOperatorInfo> > SqlUtil::make_jop | ( | string | jop, |
string | table_name, | ||
*string | alias, | ||
*hash | jcols, | ||
*hash | cond, | ||
*string | ta, | ||
*hash< auto > | opt | ||
) |
returns a hash keyed with the table name assigned to a JoinOperatorInfo hash
This version is used for deferred table resolution at join time