Qorus Integration Engine® Enterprise Edition 6.1.0_prod
|
system sqlutil service More...
Inherits QorusSystemService.
Public Member Methods | |
select (string ds, string table, *hash< auto > sh) | |
select service method More... | |
select_rows (string ds, string table, *hash< auto > sh) | |
select_rows service method More... | |
select_row (string ds, string table, *hash< auto > sh) | |
select_row service method More... | |
int | insert (string ds, string table, softlist< auto > rl) |
insert service method More... | |
int | insert_from_select (string ds, string table, list< auto > cols, string source_table, hash< auto > sh) |
insert_from_select service method More... | |
int | update (string ds, string table, hash< auto > set, *hash< auto > cond) |
update service method More... | |
int | upsert_row (string ds, string table, hash< auto > row, int upsert_strategy=AbstractTable::UpsertAuto, *hash< auto > opt) |
upsert_row service method More... | |
upsert (string ds, string table, softlist< auto > rows, int upsert_strategy=AbstractTable::UpsertAuto, *hash< auto > opt) | |
upsert service method More... | |
int | del (string ds, string table, *hash< auto > cond) |
del service method More... | |
nothing | truncate_table (string ds, string table) |
truncate_table service method More... | |
align_schema (string ds, hash< auto > schema_template, *hash< auto > opt) | |
align_schema service method More... | |
drop_schema (string ds, hash< auto > schema_template, *hash< auto > opt) | |
drop_schema service method More... | |
align_table (string ds, string table_name, hash< auto > table_template, *hash< auto > opt) | |
align_table service method More... | |
drop_table (string ds, string table, *hash< auto > opt) | |
drop_table service method More... | |
list_functions (string ds) | |
list_functions service method More... | |
list_procedures (string ds) | |
list_procedures service method More... | |
list_sequences (string ds) | |
list_sequences service method More... | |
list_tables (string ds) | |
list_tables service method More... | |
bool | exists_table (string ds, string table) |
exists_table service method More... | |
list_views (string ds) | |
list_views service method More... | |
string | get_table_ddl (string ds, string table, *hash< auto > opt) |
get_table_ddl service method More... | |
get_sequence_ddl (string ds, string name, *hash opt) | |
get_sequence_ddl service method More... | |
get_function_ddl (string ds, string name, *hash< auto > opt) | |
get_function_ddl service method More... | |
get_procedure_ddl (string ds, string name, *hash< auto > opt) | |
get_procedure_ddl service method More... | |
get_view_ddl (string ds, string name, *hash< auto > opt) | |
get_view_ddl service method More... | |
auto | exec_sql (string ds, string sql) |
exec_sql service method More... | |
auto | exec_raw_sql (string ds, string sql) |
exec_raw_sql service method More... | |
describe_table (string ds, string table) | |
describe_table service method More... | |
describe_query (string ds, string sql) | |
describe_query service method More... | |
Static Public Member Methods | |
static | init () |
init service method | |
system sqlutil service
|
inline |
align_schema service method
ds | the datasource name of the schema to align |
schema_template | a schema template hash; see SqlUtil::AbstractDatabase::getAlignSql() for more information |
opt | a schema alignment option hash; see SqlUtil::AbstractDatabase::getAlignSql() for more information |
"info"
: a list of informational strings about the result of processing"sql"
: a list of the SQL executedAn implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
align_table service method
ds | the datasource name of the schema where the table will be aligned |
table_name | the name of the table to align |
table_template | a table description hash; see SqlUtil::AbstractTable::getAlignSql() for more information |
opt | a table alignment hash; see SqlUtil::AbstractTable::getAlignSql() for more information |
"info"
: a list of informational strings about the result of processing"sql"
: a list of the SQL executedAn implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
del service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
describe_query service method
ds | the name of the datasource |
sql | the select statement to describe |
... | any bind arguments to the select statement |
|
inline |
describe_table service method
ds | the name of the datasource |
table | the name of the table |
native_type
(string): the native DB typeqore_type
(*string): the equivalent Qore type, if knownsize
(int): the size of the column, if relevantnullable
(bool): if the column can hold NULL
valuesdef_val
(*string): the default value code for the column, if anycomment
(*string): any comment on the column
|
inline |
drop_schema service method
ds | the datasource name of the schema to drop |
schema_template | a schema template hash; see SqlUtil::AbstractDatabase::getDropSchemaSql() for more information |
opt | a schema drop option hash; see SqlUtil::AbstractDatabase::getDropSchemaSql() for more information |
"info"
: a list of informational strings about the result of processing"sql"
: a list of the SQL executedAn implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
drop_table service method
ds | the datasource the table resides in |
table | the name of the table to drop |
opt | options for the drop operation (see SqlUtil::AbstractTable::getDropSql()) |
"info"
: one or more informative strings about the SQL operations executed"sql"
: one or more DDL strings giving the actual SQL DDL commands executedAn implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
exec_raw_sql service method
ds | the name of the datasource |
sql | the SQL to execute |
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
exec_sql service method
ds | the name of the datasource |
sql | the SQL to execute |
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
exists_table service method
|
inline |
get_function_ddl service method
|
inline |
get_procedure_ddl service method
|
inline |
get_sequence_ddl service method
|
inline |
get_table_ddl service method
|
inline |
get_view_ddl service method
|
inline |
insert service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
insert_from_select service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
list_functions service method
|
inline |
list_procedures service method
|
inline |
list_sequences service method
|
inline |
list_tables service method
|
inline |
list_views service method
|
inline |
select service method
|
inline |
select_row service method
|
inline |
select_rows service method
|
inline |
truncate_table service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
update service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
|
inline |
upsert service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
ds | the datasource name |
table | the table name |
rows | the row data to insert |
upsert_strategy | see Upsert Strategy Codes for possible values for the upsert strategy |
opt | a hash of options for the upsert operation; see SqlUtil::AbstractTable::UpsertOptions for common options; each driver can support additional driver-specific options |
"inserted"
: the number of rows inserted"verified"
: the number of rows updated unconditionally; note that this key is returned with all upsert strategy codes other than SqlUtil::AbstractTable::UpsertSelectFirst instead of "updated"
"updated"
: the number of rows updated; note that this key is only returned if upsert_strategy is SqlUtil::AbstractTable::UpsertSelectFirst, otherwise updated rows are reported as "verified"
since rows are updated unconditionally with other the upsert strategy codes"unchanged"
: the number of rows unchanged; this key can only be returned if upsert_strategy is SqlUtil::AbstractTable::UpsertSelectFirst, SqlUtil::AbstractTable::UpsertInsertOnly, or SqlUtil::AbstractTable::UpsertUpdateOnly"deleted"
: the number of rows deleted; this can only be returned if upsert option delete_others
is True
|
inline |
upsert_row service method
An implicit commit is made on the datasource if no persistent remote transaction is in progress and no errors occur executing the method; see Transaction Management with the sqlutil Service for more information on persistent remote transactions.
ds | the datasource name |
table | the table name |
row | a hash representing the row to insert or update |
upsert_strategy | see Upsert Strategy Codes for possible values for the upsert strategy |
opt | a hash of options for the upsert operation; see SqlUtil::AbstractTable::UpsertOptions for common options; each driver can support additional driver-specific options |