![]() |
Qore DbDataProvider Module Reference
2.0
|
The database data provider class, provides tables as children. More...
Inherits AbstractDataProvider.
Public Member Methods | |
| beginTransaction () | |
| Begins a transaction in the datasource. More... | |
| commit () | |
| Commits any transaction in progress in the datasource. More... | |
| constructor (*hash< auto > options) | |
| Creates the object from constructor options. | |
| constructor (AbstractDatabase db) | |
| creates the object | |
| constructor (AbstractDatasource ds, *hash< auto > opts) | |
| creates the object | |
| *string | getDesc () |
| Returns the data provider description. | |
| string | getName () |
| Returns the data provider name. | |
| hash< auto > | makeTableDesc (string name, hash< string, AbstractDataField > fields, *hash< auto > opts) |
| Returns a table description hash from a field description. More... | |
| rollback () | |
| Rolls back any transaction in progress in the datasource. More... | |
Static Public Member Methods | |
| static hash< GenericColumnInfo > | getColumnDesc (AbstractDatabase db, AbstractDataField field, *hash< auto > opts) |
| Returns a column description hash for a field. | |
| static AbstractDatasource | getDatasource (AbstractDatasource ds) |
| Returns the given AbstractDatasource object. | |
| static AbstractDatasource | getDatasource (string ds_string) |
| Returns an AbstractDatasource object from the given string. | |
| static *hash< string, AbstractDataField > | getRecordTypeFromDescribeHash (hash< auto > describe_hash) |
| Returns the record type description from a describe hash. More... | |
| static AbstractTable | getTable (AbstractDatasource ds, string table_string) |
| Returns an AbstractTable object from the given datasource and table arguments. | |
| static AbstractTable | getTable (string ds_string, string table_string) |
| Returns an AbstractTable object from the given datasource and table strings. | |
| static | setDatasourceLookup (code datasource_lookup) |
| Sets the datasource lookup. | |
| static | setTableLookup (code table_lookup) |
| Sets the table lookup. | |
Public Attributes | |
| const | ChildCreateOptions = ... |
| Child provider creation options. | |
| const | ConstructorOptions = ... |
| Constructor options. | |
| const | ProviderInfo = ... |
| Provider info. | |
| const | SearchOptions = ... |
| Search options. | |
Private Member Methods | |
| AbstractDataProvider | createChildProviderImpl (string name, hash< string, AbstractDataField > fields, *hash< auto > child_create_options) |
| Creates a new child data provider and returns it after adding as a child. More... | |
| deleteChildProviderImpl (string name, *hash< auto > child_delete_options) | |
| Deletes a child data provider. More... | |
| *AbstractDataProvider | getChildProviderImpl (string name) |
| Returns the given child provider or NOTHING if the given child is unknown. More... | |
| *list< string > | getChildProviderNamesImpl () |
| Returns a list of child data provider names, if any. More... | |
| *hash< string, AbstractDataField > | getRecordTypeImpl (*hash< auto > search_options) |
| Returns the description of the record type, if any. More... | |
| hash< DataProviderInfo > | getStaticInfoImpl () |
| Returns data provider static info. | |
| AbstractDataProviderBulkRecordInterface | searchRecordsBulkImpl (int block_size=1000, *hash< auto > where_cond, *hash< auto > search_options) |
| Returns an iterator for zero or more records matching the search options. More... | |
| AbstractDataProviderRecordIterator | searchRecordsImpl (*hash< auto > where_cond, *hash< auto > search_options) |
| Returns an iterator for zero or more records matching the search options. More... | |
Private Attributes | |
| AbstractDatabase | db |
| The database object. | |
Static Private Attributes | |
| static *code | datasource_lookup |
| Lookup to get an abstract datasource from a name. | |
| static *code | table_lookup |
| Lookup to get an abstract table from a datasource and a name. | |
The database data provider class, provides tables as children.
| DbDataProvider::DbDataProvider::beginTransaction | ( | ) |
| DbDataProvider::DbDataProvider::commit | ( | ) |
Commits any transaction in progress in the datasource.
|
private |
Creates a new child data provider and returns it after adding as a child.
| name | the name of the new child data provider |
| fields | the fields for the new child data provider |
| child_create_options | the options for creating the new child data provider |
|
private |
Deletes a child data provider.
| name | the name of the new child data provider |
| child_delete_options | the options for deleting a child data provider |
| DELETE-CHILD-PROVIDER-ERROR | error dropping the child data provider |
|
private |
Returns a list of child data provider names, if any.
|
static |
Returns the record type description from a describe hash.
| describe_hash | a hash as returned by AbstractSQLStatement::describe() |
|
private |
Returns the description of the record type, if any.
| search_options | to be included and processed by validateSearchOptions() if recordRequiresSearchOptions() is True for this provider, otherwise any value provided in this argument is ignored |
| hash<auto> DbDataProvider::DbDataProvider::makeTableDesc | ( | string | name, |
| hash< string, AbstractDataField > | fields, | ||
| *hash< auto > | opts | ||
| ) |
Returns a table description hash from a field description.
| TABLE-DESC-ERROR | error in table description |
| DbDataProvider::DbDataProvider::rollback | ( | ) |
Rolls back any transaction in progress in the datasource.
|
private |
Returns an iterator for zero or more records matching the search options.
| block_size | the number of records in a read block; must be a positive number |
| where_cond | the search criteria after processing by processFieldValues() |
| search_options | the search options after processing by validateSearchOptions() |
| INVALID-BLOCK-SIZE | the block size must be a positive number |
| INVALID-OPERATION | the data provider does not support reading |
|
private |
Returns an iterator for zero or more records matching the search options.
| where_cond | the search criteria |
| search_options | the search options after processing by validateSearchOptions() |