Qorus Integration Engine®  4.0.3.p1_git
QorusSystemSqlutilService Class Reference

the main sqlutil service class More...

Inheritance diagram for QorusSystemSqlutilService:
QorusSystemService

Private:Internal Member Methods

 init ()
 initalizes the system sqlutil service
 
*hash< auto > select (string ds, string table, *hash< auto > sh)
 executes the select method on the given datasource and table and returns the result More...
 
*list< auto > select_rows (string ds, string table, *hash< auto > sh)
 executes the selectRows method on the given datasource and table and returns the result More...
 

Static Private:Internal Member Methods

static *hash< auto > select_row (string ds, string table, *hash< auto > sh)
 executes the selectRow method on the given datasource and table and returns the result More...
 
static int insert (string ds, string table, softlist< auto > rl)
 executes the insert method on the given datasource and table with the given data and returns the number of rows inserted in a single transaction More...
 
static int insert_from_select (string ds, string table, list< auto > cols, string source_table, hash< auto > sh)
 executes the insertFromSelect method on the given datasource and table and returns the result More...
 
static int update (string ds, string table, hash< auto > set, *hash< auto > cond)
 executes the update method on the given datasource and table with the given data and returns the number of rows updated in a single transaction More...
 
static hash< auto > upsert (string ds, string table, softlist< auto > rows, int upsert_strategy=AbstractTable::UpsertAuto, *hash< auto > opt)
 executes the upsertFromIterator() method on the given datasource and table with the given input data and returns a hash giving the result of the upsert operation More...
 
static int del (string ds, string table, *hash< auto > cond)
 executes the delete method on the given datasource and table with the given data and returns the number of rows deleted in a single transaction More...
 
static nothing truncate_table (string ds, string table)
 executes the truncate method on the given datasource and table More...
 
static *hash< auto > align_schema (string ds, hash< auto > schema_template, *hash< auto > opt)
 aligns a schema with the given template and returns a hash with two keys: "info": a list of informational strings about the result of processing, and "sql": a list of the SQL executed More...
 
static *hash< auto > drop_schema (string ds, hash< auto > schema_template, *hash< auto > opt)
 drops the given schema and returns a hash with two keys: "info": a list of informational strings about the result of processing, and "sql": a list of the SQL executed More...
 
static *hash< auto > align_table (string ds, string table_name, hash< auto > table_template, *hash< auto > opt)
 aligns a schema with the given template and returns a hash with two keys: "info": a list of informational strings about the result of processing, and "sql": a list of the SQL executed More...
 
static *hash< auto > drop_table (string ds, string table, *hash< auto > opt)
 drops the listed table and returns information about the operation executed More...
 
static list< auto > list_functions (string ds)
 returns a list of strings giving the names of all functions in the given datasource More...
 
static list< auto > list_procedures (string ds)
 returns a list of strings giving the names of all procedures in the given datasource More...
 
static list< auto > list_sequences (string ds)
 returns a list of strings giving the names of all sequences in the given datasource More...
 
static list< auto > list_tables (string ds)
 returns a list of strings giving the names of all tables in the given datasource More...
 
static list< auto > list_views (string ds)
 returns a list of strings giving the names of all views in the given datasource More...
 
static *string get_table_ddl (string ds, string table, *hash< auto > opt)
 returns the DDL for a table or NOTHING if the object does not exist or is not accessible More...
 
static list< auto > get_sequence_ddl (string ds, string name, *hash opt)
 returns the DDL for a sequence or NOTHING if the object does not exist or is not accessible More...
 
static list< auto > get_function_ddl (string ds, string name, *hash< auto > opt)
 returns the DDL for a function or NOTHING if the object does not exist or is not accessible More...
 
static list< auto > get_procedure_ddl (string ds, string name, *hash< auto > opt)
 returns the DDL for a stored procedure or NOTHING if the object does not exist or is not accessible More...
 
static list< auto > get_view_ddl (string ds, string name, *hash< auto > opt)
 returns the DDL for a view or NOTHING if the object does not exist or is not accessible More...
 
static auto exec_sql (string ds, string sql)
 executes SQL in the given datasource with option arguments and returns a hash of the results More...
 
static auto exec_raw_sql (string ds, string sql)
 executes raw SQL in the given datasource and returns a hash of the results More...
 

Additional Inherited Members

- Public Member Methods inherited from QorusSystemService
 constructor ()
 initializes the info service
 
softlist getOrderInfoFromKey (string name, string version, softstring key, softstring value)
 returns order instance info from user order key (params: workflowname, workflowversion, keyname, value)
 
*list getWorkflowListFromWorkflowKey (string workflow, softstring key, softstring value)
 returns order instance info from the workflow name, key, and value More...
 
hash getAllInfoFromOrderKey (string name, string version, softstring key, softstring value)
 returns all information about a workflow from a user order key (params: workflowname, workflowversion, keyname, value)
 
deprecated *hash getWorkflowMetadata ()
 gets workflow metadata (optional params: list of IDs), returns: hash of workflow metadata keyed by name and then version: COMPAT VERSION with fake flow information (removed in Qorus v2); use getWorkflowMetadata2() instead More...
 
*hash getWorkflowMetadata2 ()
 gets workflow metadata (optional params: list of IDs), returns: hash of workflow metadata keyed by name and then version More...
 
*hash getWorkflowMetadataFromName (string name, *string ver)
 gets workflow metadata from name and version (params: name, optional: version), returns: hash of workflow metadata keyed by name and then version: COMPAT VERSION with fake flow information; use getWorkflowMetadataFromName2() instead More...
 
*hash getWorkflowMetadataFromName2 (string name, *string ver)
 gets workflow metadata from name and version (params: name, optional: version), returns: hash of workflow metadata keyed by name and then version, new version without flows (removed in Qorus v2) More...
 
*hash getFunctionInstance (softint fiid, *softdate date)
 retrieves function data from the function_instanceid (params: function_instanceid), returns: hash of function data keyed by name and then version
 
*hash getFunctionInstanceFromName (string name, *string ver)
 retrieves function data from the name and optionally the version (params: name, [version]), returns: hash of function data keyed by name and then version
 
*hash getServiceMethod2 (softint mid, *softdate date)
 retrieves method data from the service_methodid (params: service_methodid), returns: hash of method data More...
 
*hash getServiceMethod (softint mid, *softdate date)
 retrieves method data from the service_methodid (params: service_methodid), returns: hash of method data More...
 
*list getWorkflowInstanceList (*softlist workflowid, *softdate date=now() - 1D, any stati, softint rownum=OptionHelper::getOption("row-limit"))
 gets a list of workflow instance ids (not more than 100 by default, can be overridden with the 4th argument), params: workflowid (single value, list, or NOTHING), date, [statuses, num rows]
 
list getWorkflowInstances (*softlist wfids, *list statuses, *softdate modified, softint rownum=OptionHelper::getOption("row-limit"), *int offset, *softlist sort, *softlist wfiids, *softbool desc, *date minstarted, *date maxstarted)
 gets a list of workflow instance ids; this is the safe and preferred variant of this method More...
 
deprecated list getWorkflowInstances (softint workflowid, *string condition, int rownum=OptionHelper::getOption("row-limit"))
 gets a list of workflow instance ids, params: workflowid, condition, number of rows (100 default) More...
 
*list getWorkflowInstancesByKeyValue (softlist val, *softstring key, *softlist wfids, *softlist statuses, *date modified, softint rownum=OptionHelper::getOption("row-limit"), *int offset, *softlist sort, *softlist wfiids, *softbool desc, *date minstarted, *date maxstarted)
 retrieves workflow instances from a key value and optional key name
 
*list searchWorkflowInstances (*hash h)
 searches for workflow order instances according to a hash More...
 
list getWorkflowInstanceOverview (list wfilist)
 return the Workflow Instance Overview info, PARAMS: list(hash("ID",[optional: "date"])), RETURN: list(hash(info))
 
list getStepInstanceList (softint wfiId)
 gets a list of step instances, params: workflowinstanceid
 
list getErrorInstanceList (softint workflowInstanceId, *softint stepId, *softint ind)
 gets a list of error instances, params: workflowInstanceId, [stepId, ind]
 
list getErrorInstanceListByWFIID (softint workflowInstanceId, *softint stepId)
 gets a list of error instances, params: workflowInstanceId, [stepId]
 
*hash< auto > getClass (softint classid, *softdate date)
 retrieves class data from a classid; returns: hash of class data keyed by name and then version
 
*hash getStepMetadata ()
 gets step metadata (optional params: list of IDs), returns: hash of step metadata information keyed by name and then version
 
*hash getTreeWithWorkflowInstance (softint workflowinstanceid, softbool full=False, softbool compat=True)
 retrieves tree view like structure that contains specific instanceid (params: workflowinstanceid)
 
*hash getWFIAllInfo (softint workflowInstanceID, *softdate lastModifiedDate, softbool compat=True, softbool with_sensitive_data=False)
 Retrieves all workflow instance info (params: workflowInstanceID, [lastModifiedDate]; output hash keys: InstanceInfo, OrderInfo, StepInstances, ErrorInstances, LastModified. More...
 
*hash getWFIInstanceInfo (softint workflowInstanceID, *softdate lastModifiedDate, softbool compat=True)
 Retrieves only workflow instance info (params: workflowInstanceID, [lastModifiedDate]; output hash keys: InstanceInfo, LastModified. More...
 
*hash getWFIOrderInfo (softint workflowInstanceID, *softdate lastModifiedDate, softbool compat=True, softbool with_sensitive_data=False)
 Retrieves workflow instances order info (params: workflowInstanceID, [lastModifiedDate]; output hash keys: OrderInfo, LastModified. More...
 
*hash getWFIStepInstances (softint workflowInstanceID, *softdate lastModifiedDate, softbool compat=False)
 Retrieves all step info for workflow instance (params: workflowInstanceID, [lastModifiedDate]; output hash keys: StepInstances, LastModified.
 
*hash getWFIErrorInstances (softint workflowInstanceID, *softdate lastModifiedDate, softbool compat=True)
 gets workflow instance error info (params: workflowInstanceID, [lastModifiedDate]; output hash keys: ErrorInstances, LastModified
 
*list getWorkflowInstanceListFromWorkflowNameAndKeyValue (string name, softstring val)
 retrieves workflow instances from a workflow name and a key value, returns a list of workflow instance IDs
 
*list getWorkflowInstanceListFromWorkflowNameVersionAndKeyValue (string name, string version, softstring val)
 retrieves workflow instances from a workflow name, version, and key value, returns a list of workflow instance IDs
 
*list getWorkflowInstanceListFromKeyValue (softstring val)
 retrieves workflow instances from a key value only, returns a list of workflow instance IDs
 
list getOrderInfoList (string name, softstring key, softstring value)
 returns order info from a workflow name and an order key and value (params: workflowname, keyname, value)
 
*list< auto > searchOrderKeys (hash params)
 returns a list of workflow instance info matching the input criteria More...
 
softlist searchWorkflowErrors (hash h)
 returns a list of matching errors for the input criteria More...
 
*list searchReleases (*hash params)
 returns release info More...
 
*list searchSessions (*hash params)
 returns information about application sessions More...
 
*hash getUnpostedEvents (*softlist ids, *softdate lastmod=now() - 6M, softint rownum=OptionHelper::getOption("row-limit"), *int offset)
 returns a hash of event type names with lists of unposted events for each, params: event ID(s), [last modified date] More...
 
*hash getUnpostedEventsFromName (string eventname, *softdate lastmod)
 returns a hash of event type names with lists of unposted events for each, params: event type name, [last modified date] More...
 
list searchEvents (*hash h)
 returns workflow synchronization event information More...
 
*hash getJobMetadata ()
 retrieves job metadata (optional params: list of job ids), returns: job info keyed by name More...
 
*hash getJobMetadataFromName (string name)
 retrieves job metadata from the name, returns: job info keyed by name More...
 
list getJobList ()
 retrieves a list of all jobs without the code field More...
 
*hash getJobStatus (softint jiid)
 returns NOTHING if the job instance ID is not valid or a hash giving job instance status corresponding to the job instance ID passed as an argument More...
 
*list getJobInstanceList (any jobid, *softdate date=now() - 1D, any stati, softint rownum=OptionHelper::getOption("row-limit"))
 gets a list of job instance ids (not more than 100 by default, can be overridden with the 4th argument), params: jobid (single value or list), date, [statuses, num rows] More...
 
*list getJobInstances (*softlist jobids, *softlist statuses, *softdate modified, softint rownum=OptionHelper::getOption("row-limit"), *softint offset, *softlist sort, *softlist jiids, *softbool desc, *softbool full)
 gets a list of job instance ids, params: jobid, condition, number of rows (100 default) More...
 
softlist getOrderInstanceNotes (softint wfiid, *int count)
 gets a list of order instance notes More...
 
list< hash< SlaEventInfo > > searchSlaEvents (*hash h)
 searches for SLA events according to the given criteria and returns a list of results More...
 
softlist< hash< SlaPerformanceInfo > > getSlaPerformance (*hash h)
 searches for SLA events according to the given criteria and returns a list of results More...
 
- Static Public Member Methods inherited from QorusSystemService
static deprecated *hash getWorkflowStatus (softint id)
 returns workflow instance status from workflow_instanceid: COMPAT VERSION with fake flow and flow_instance information (removed in Qorus v2); use getWorkflowStatus2() instead More...
 
static *hash getWorkflowStatus2 (softstring wfiid)
 returns workflow order data instance status from the workflow_instanceid More...
 
static *hash getOrderInfo (softstring wfiid)
 returns order instance info from workflow_instanceid
 
static *list getOrderInfoFromExternalID (softstring id)
 returns order instance info from external_order_instanceid
 
static softlist getOrdersFromKey (softstring key, softstring value)
 returns order instance info from the key and value
 
static *hash< auto > getWorkflowOverview (softdate date=now() - 1D, *softlist wfids, softbool useSqlCache=True, softbool with_deprecated=True)
 gets workflow overview, params: [date, [workflowids]]: If no date is given, default = last 24 hours More...
 
static *hash getWorkflowOverviewFromName (softdate date=now() - 1D, *string name, *string version, softbool useSqlCache=True, softbool with_deprecated=True)
 gets workflow overview, params: [date, [name, [version]]]: If no date is given, default = last 24 hours More...
 
static *list getWorkflowSummaryOverview (softdate date=now() - 1D, softbool useSqlCache=True, softbool with_deprecated=True)
 gets system overview, params: [date]: If no date is given, default = last 24 hours More...
 
static *hash getServiceMetadata ()
 retrieves service metadata (optional params: list of service ids), returns: service info keyed by name. NOTE: if no list is given, only the latest version of each service will be returned
 
static *hash getServiceMetadataFromName (string type, string name, *string ver)
 retrieves service metadata from the type, name and optional version (params: type, name, [version]), returns: service info keyed by name. NOTE: if no version is given, only the latest version will be returned
 
static list getLibraryMetadata ()
 retrieves function library information as a list of hashes with the keys name, function_instanceid
 
static *hash getClassFromName (string name, *string ver)
 retrieves class data from the class name and optional version (params: name, [version]), returns: hash of class data keyed by name and then version
 
static *hash getConstant (softint constantid, *softdate date)
 retrieves constant data from the constantid (params: constantid), returns: hash of constant data keyed by name and then version
 
static *hash getConstantFromName (string name, *string ver)
 retrieves constant data from the constant name and optional version (params: name, [version]), returns: hash of constant data keyed by name and then version
 
static *hash getWFIOrderKeysOnly (softint workflowInstanceID)
 Retrieves only order keys for workflow instance params: workflowInstanceID; output: hash.
 
static *list getWorkflowProcessingSummary (hash h)
 returns a summary of workflow processing for the given time period and optional workflow ID(s) More...
 
static *list getStepProcessingSummary (hash h)
 returns a summary of step processing for the given time period and optional step ID(s) More...
 
static *hash getJobOverview (softdate date=now() - 1D, any jobids, bool useSqlCache=True)
 gets job overview, params: [date, [jobids]]: If no date is given, default = last 24 hours More...
 
static *hash getJobOverviewFromName (softdate date=now() - 1D, *string name, bool useSqlCache=True)
 gets job overview, params: [date, [name]]: If no date is given, default = last 24 hours More...
 

Detailed Description

the main sqlutil service class

Member Function Documentation

◆ align_schema()

static *hash<auto> QorusSystemSqlutilService::align_schema ( string  ds,
hash< auto >  schema_template,
*hash< auto >  opt 
)
inlinestaticprivate:internal

aligns a schema with the given template and returns a hash with two keys: "info": a list of informational strings about the result of processing, and "sql": a list of the SQL executed

Parameters
dsthe datasource name of the schema to align
schema_templatea schema template hash; see SqlUtil::AbstractDatabase::getAlignSql() for more information
opta schema alignment option hash; see SqlUtil::AbstractDatabase::getAlignSql() for more information
Returns
a hash with two keys:
  • "info": a list of informational strings about the result of processing
  • "sql": a list of the SQL executed

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ align_table()

static *hash<auto> QorusSystemSqlutilService::align_table ( string  ds,
string  table_name,
hash< auto >  table_template,
*hash< auto >  opt 
)
inlinestaticprivate:internal

aligns a schema with the given template and returns a hash with two keys: "info": a list of informational strings about the result of processing, and "sql": a list of the SQL executed

Parameters
dsthe datasource name of the schema where the table will be aligned
table_namethe name of the table to align
table_templatea table description hash; see SqlUtil::AbstractTable::getAlignSql() for more information
opta table alignment hash; see SqlUtil::AbstractTable::getAlignSql() for more information
Returns
a hash with two keys:
  • "info": a list of informational strings about the result of processing
  • "sql": a list of the SQL executed

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ del()

static int QorusSystemSqlutilService::del ( string  ds,
string  table,
*hash< auto >  cond 
)
inlinestaticprivate:internal

executes the delete method on the given datasource and table with the given data and returns the number of rows deleted in a single transaction

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ drop_schema()

static *hash<auto> QorusSystemSqlutilService::drop_schema ( string  ds,
hash< auto >  schema_template,
*hash< auto >  opt 
)
inlinestaticprivate:internal

drops the given schema and returns a hash with two keys: "info": a list of informational strings about the result of processing, and "sql": a list of the SQL executed

Parameters
dsthe datasource name of the schema to drop
schema_templatea schema template hash; see SqlUtil::AbstractDatabase::getDropSchemaSql() for more information
opta schema drop option hash; see SqlUtil::AbstractDatabase::getDropSchemaSql() for more information
Returns
a hash with two keys:
  • "info": a list of informational strings about the result of processing
  • "sql": a list of the SQL executed

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ drop_table()

static *hash<auto> QorusSystemSqlutilService::drop_table ( string  ds,
string  table,
*hash< auto >  opt 
)
inlinestaticprivate:internal

drops the listed table and returns information about the operation executed

Parameters
dsthe datasource the table resides in
tablethe name of the table to drop
optoptions for the drop operation (see SqlUtil::AbstractTable::getDropSql())
Returns
a hash with the following keys:
  • "info": one or more informative strings about the SQL operations executed
  • "sql": one or more DDL strings giving the actual SQL DDL commands executed

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ exec_raw_sql()

static auto QorusSystemSqlutilService::exec_raw_sql ( string  ds,
string  sql 
)
inlinestaticprivate:internal

executes raw SQL in the given datasource and returns a hash of the results

Example:
string sql = "begin my_proc(); end;"
hash<auto> h = omqservice.system.sqlutil.exec_raw_sql("omquser", sql);
Parameters
dsthe name of the datasource
sqlthe 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.

Returns
The return value depends on the DBI driver; normally, for commands with placeholders, a hash is returned holding the values acquired from executing the SQL statement. For all other commands, normally an integer row count is returned. However, some DBI drivers also allow select statements to be executed through this interface, which would also return a hash (column names) of lists (values for each column). See Qore::SQL::AbstractDatasource::execRaw() as a reference.
Note
requires permission DATASOURCE-CONTROL or both SQLUTIL-READ and SQLUTIL-WRITE

◆ exec_sql()

static auto QorusSystemSqlutilService::exec_sql ( string  ds,
string  sql 
)
inlinestaticprivate:internal

executes SQL in the given datasource with option arguments and returns a hash of the results

Example:
string sql = "begin my_proc(%v, %v, :result); end;"
hash<auto> h = omqservice.system.sqlutil.exec_sql("omquser", sql, arg1, arg2, Type::Int);
Parameters
dsthe name of the datasource
sqlthe SQL to execute
Returns
The return value depends on the DBI driver; normally, for commands with placeholders, a hash is returned holding the values acquired from executing the SQL statement. For all other commands, normally an integer row count is returned. However, some DBI drivers also allow select statements to be executed through this interface, which would also return a hash (column names) of lists (values for each column). See Qore::SQL::AbstractDatasource::exec() as a reference.

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.

Note
requires permission DATASOURCE-CONTROL or both SQLUTIL-READ and SQLUTIL-WRITE

◆ get_function_ddl()

static list<auto> QorusSystemSqlutilService::get_function_ddl ( string  ds,
string  name,
*hash< auto >  opt 
)
inlinestaticprivate:internal

returns the DDL for a function or NOTHING if the object does not exist or is not accessible

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ get_procedure_ddl()

static list<auto> QorusSystemSqlutilService::get_procedure_ddl ( string  ds,
string  name,
*hash< auto >  opt 
)
inlinestaticprivate:internal

returns the DDL for a stored procedure or NOTHING if the object does not exist or is not accessible

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ get_sequence_ddl()

static list<auto> QorusSystemSqlutilService::get_sequence_ddl ( string  ds,
string  name,
*hash  opt 
)
inlinestaticprivate:internal

returns the DDL for a sequence or NOTHING if the object does not exist or is not accessible

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ get_table_ddl()

static *string QorusSystemSqlutilService::get_table_ddl ( string  ds,
string  table,
*hash< auto >  opt 
)
inlinestaticprivate:internal

returns the DDL for a table or NOTHING if the object does not exist or is not accessible

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ get_view_ddl()

static list<auto> QorusSystemSqlutilService::get_view_ddl ( string  ds,
string  name,
*hash< auto >  opt 
)
inlinestaticprivate:internal

returns the DDL for a view or NOTHING if the object does not exist or is not accessible

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ insert()

static int QorusSystemSqlutilService::insert ( string  ds,
string  table,
softlist< auto >  rl 
)
inlinestaticprivate:internal

executes the insert method on the given datasource and table with the given data and returns the number of rows inserted in a single transaction

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ insert_from_select()

static int QorusSystemSqlutilService::insert_from_select ( string  ds,
string  table,
list< auto >  cols,
string  source_table,
hash< auto >  sh 
)
inlinestaticprivate:internal

executes the insertFromSelect method on the given datasource and table and returns the result

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.

Note
requires permission DATASOURCE-CONTROL or (SQLUTIL-READ and SQLUTIL-WRITE)

◆ list_functions()

static list<auto> QorusSystemSqlutilService::list_functions ( string  ds)
inlinestaticprivate:internal

returns a list of strings giving the names of all functions in the given datasource

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ list_procedures()

static list<auto> QorusSystemSqlutilService::list_procedures ( string  ds)
inlinestaticprivate:internal

returns a list of strings giving the names of all procedures in the given datasource

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ list_sequences()

static list<auto> QorusSystemSqlutilService::list_sequences ( string  ds)
inlinestaticprivate:internal

returns a list of strings giving the names of all sequences in the given datasource

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ list_tables()

static list<auto> QorusSystemSqlutilService::list_tables ( string  ds)
inlinestaticprivate:internal

returns a list of strings giving the names of all tables in the given datasource

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ list_views()

static list<auto> QorusSystemSqlutilService::list_views ( string  ds)
inlinestaticprivate:internal

returns a list of strings giving the names of all views in the given datasource

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ select()

*hash<auto> QorusSystemSqlutilService::select ( string  ds,
string  table,
*hash< auto >  sh 
)
inlineprivate:internal

executes the select method on the given datasource and table and returns the result

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ select_row()

static *hash<auto> QorusSystemSqlutilService::select_row ( string  ds,
string  table,
*hash< auto >  sh 
)
inlinestaticprivate:internal

executes the selectRow method on the given datasource and table and returns the result

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ select_rows()

*list<auto> QorusSystemSqlutilService::select_rows ( string  ds,
string  table,
*hash< auto >  sh 
)
inlineprivate:internal

executes the selectRows method on the given datasource and table and returns the result

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-READ

◆ truncate_table()

static nothing QorusSystemSqlutilService::truncate_table ( string  ds,
string  table 
)
inlinestaticprivate:internal

executes the truncate method on the given datasource and table

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ update()

static int QorusSystemSqlutilService::update ( string  ds,
string  table,
hash< auto >  set,
*hash< auto >  cond 
)
inlinestaticprivate:internal

executes the update method on the given datasource and table with the given data and returns the number of rows updated in a single transaction

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

◆ upsert()

static hash<auto> QorusSystemSqlutilService::upsert ( string  ds,
string  table,
softlist< auto >  rows,
int  upsert_strategy = AbstractTable::UpsertAuto,
*hash< auto >  opt 
)
inlinestaticprivate:internal

executes the upsertFromIterator() method on the given datasource and table with the given input data and returns a hash giving the result of the upsert operation

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.

Note
requires permission DATASOURCE-CONTROL or SQLUTIL-WRITE

The documentation for this class was generated from the following file: