$darkmode
Qore Programming Language Reference Manual 1.19.2
QC_AbstractDatasource.dox.h
1 namespace Qore {
4 namespace SQL {
6 
11 
12 public:
14 
23 abstract nothing beginTransaction();
24 
25 public:
27 
32 abstract nothing commit();
33 
34 public:
36 
43 
44 public:
46 
56 abstract auto exec(string sql, ...);
57 
58 public:
60 
74 abstract auto execRaw(string sql);
75 
76 public:
78 
87 abstract auto getClientVersion();
88 
89 public:
91 
100 abstract hash<auto> getConfigHash();
101 
102 public:
104 
113 abstract string getConfigString();
114 
115 public:
117 
126 abstract *string getDBEncoding();
127 
128 public:
130 
137 abstract *string getDBName();
138 
139 public:
141 
150 abstract string getDriverName();
151 
152 public:
154 
168 
169 public:
171 
178 abstract *string getHostName();
179 
180 public:
182 
189 abstract *string getOSEncoding();
190 
191 public:
193 
203 auto getOption(string opt);
204 
205 public:
207 
219 hash<auto> getOptionHash();
220 
221 public:
223 
230 abstract *string getPassword();
231 
232 public:
234 
241 abstract *int getPort();
242 
243 public:
245 
254 
255 public:
257 
266 abstract auto getServerVersion();
267 
268 public:
270 
277 abstract *string getUserName();
278 
279 public:
281 
288 abstract bool inTransaction();
289 
290 public:
292 
297 abstract nothing rollback();
298 
299 public:
301 
324 abstract auto select(string sql, ...);
325 
326 public:
328 
347 abstract auto selectRow(string sql, ...);
348 
349 public:
351 
373 abstract auto selectRows(string sql, ...);
374 
375 public:
377 
389 abstract auto vexec(string sql, *softlist<auto> vargs);
390 
391 public:
393 
417 abstract auto vselect(string sql, *softlist<auto> vargs);
418 
419 public:
421 
440 abstract auto vselectRow(string sql, *softlist<auto> vargs);
441 
442 public:
444 
469 abstract 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 hash< auto > getConfigHash()
Returns a datasource hash describing the configuration of the current object.
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 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,...
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.
hash< auto > getOptionHash()
Returns the valid options for the driver associated with the AbstractDatasource with descriptions and...
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_AbstractBidirectionalIterator.dox.h:2