Qore Programming Language Reference Manual 1.19.2
Loading...
Searching...
No Matches
QC_AbstractDatasource.dox.h
1
2namespace Qore {
4namespace SQL {
6
11
12public:
14
23abstract nothing beginTransaction();
24
25public:
27
32abstract nothing commit();
33
34public:
36
43
44public:
46
56abstract auto exec(string sql, ...);
57
58public:
60
74abstract auto execRaw(string sql);
75
76public:
78
87abstract auto getClientVersion();
88
89public:
91
100abstract hash<auto> getConfigHash();
101
102public:
104
113abstract string getConfigString();
114
115public:
117
126abstract *string getDBEncoding();
127
128public:
130
137abstract *string getDBName();
138
139public:
141
150abstract string getDriverName();
151
152public:
154
168
169public:
171
178abstract *string getHostName();
179
180public:
182
189abstract *string getOSEncoding();
190
191public:
193
203auto getOption(string opt);
204
205public:
207
219hash<auto> getOptionHash();
220
221public:
223
230abstract *string getPassword();
231
232public:
234
241abstract *int getPort();
242
243public:
245
254
255public:
257
266abstract auto getServerVersion();
267
268public:
270
277abstract *string getUserName();
278
279public:
281
288abstract bool inTransaction();
289
290public:
292
297abstract nothing rollback();
298
299public:
301
324abstract auto select(string sql, ...);
325
326public:
328
347abstract auto selectRow(string sql, ...);
348
349public:
351
373abstract auto selectRows(string sql, ...);
374
375public:
377
389abstract auto vexec(string sql, *softlist<auto> vargs);
390
391public:
393
417abstract auto vselect(string sql, *softlist<auto> vargs);
418
419public:
421
440abstract auto vselectRow(string sql, *softlist<auto> vargs);
441
442public:
444
469abstract auto vselectRows(string sql, *softlist<auto> vargs);
470};
471}
472}
This class defines an abstract interface for database access, inherited by both the Datasource and Da...
Definition: QC_AbstractDatasource.dox.h:10
auto getOption(string opt)
Returns the current value for the given option.
abstract *string getDBName()
Returns the database name parameter as a string or NOTHING if none is set.
abstract string getDriverName()
Returns the name of the driver used for the object.
bool currentThreadInTransaction()
Should return True if the current thread is in a transaction with this object, must be re-implemented...
abstract *string getHostName()
Returns the hostname parameter as a string or NOTHING if none is set.
abstract *int getPort()
Gets the port number that will be used for the next connection to the server.
string getDriverRealName()
Returns the real DB driver name if supported by the driver, otherwise the Qore driver name.
abstract auto select(string sql,...)
Executes an SQL select statement on the server and (normally) returns the result as a hash (column na...
abstract hash< auto > getConfigHash()
Returns a datasource hash describing the configuration of the current object.
abstract auto vexec(string sql, *softlist< auto > vargs)
Executes an SQL command on the server and returns either the integer row count (for example,...
abstract auto selectRow(string sql,...)
Executes an SQL select statement on the server and returns the first row as a hash (the column values...
abstract auto exec(string sql,...)
Executes an SQL command on the server and returns either the integer row count (for example,...
abstract string getConfigString()
Returns a string giving the configuration of the current object in a format that can be parsed by par...
abstract auto vselectRow(string sql, *softlist< auto > vargs)
Executes a select statement on the server and returns the first row as a hash (column names and value...
abstract nothing commit()
Commits the current transaction and releases any thread resources associated with the transaction.
abstract auto execRaw(string sql)
Executes an SQL command on the server and returns either the row count (for example,...
hash< auto > getOptionHash()
Returns the valid options for the driver associated with the AbstractDatasource with descriptions and...
abstract *string getOSEncoding()
Returns the Qore character encoding name for the object as a string or NOTHING if none is set.
abstract nothing beginTransaction()
Manually signals the start of transaction management on the AbstractDatasource.
abstract auto vselect(string sql, *softlist< auto > vargs)
Executes a select statement on the server and returns the results in a hash (column names) of lists (...
abstract *string getPassword()
Returns the password parameter as a string or NOTHING if none is set.
abstract bool inTransaction()
Returns True if a transaction is currently in progress.
abstract nothing rollback()
Rolls the current transaction back and releases any thread resources associated with the transaction.
abstract auto getServerVersion()
Returns the driver-specific server version data for the current connection.
abstract auto getClientVersion()
Retrieves the driver-specific client library version information.
abstract *string getDBEncoding()
Retrieves the database-specific charset set encoding for the object.
abstract *string getUserName()
Returns the username parameter as a string or NOTHING if none is set.
abstract auto selectRows(string sql,...)
Executes an SQL select statement on the server and returns the result as a list (rows) of hashes (the...
AbstractSQLStatement getSQLStatement()
Returns an AbstractSQLStatement object based on the current database connection object.
abstract auto vselectRows(string sql, *softlist< auto > vargs)
Executes a select statement on the server and returns the results in a list (rows) of hashes (column ...
This class defines an abstract interface for the SQLStatement class.
Definition: QC_AbstractSQLStatement.dox.h:11
Qore namespace.
Definition: QC_AbstractSmartLock.dox.h:2