Qore Programming Language Reference Manual 1.19.2
Loading...
Searching...
No Matches
QC_AbstractSQLStatement.dox.h
1
2namespace Qore {
4namespace SQL {
6
12
13public:
15
23abstract bool active();
24
25public:
27
38abstract int affectedRows();
39
40public:
42
47abstract nothing beginTransaction();
48
49public:
51
76abstract nothing bind( ...);
77
78public:
80
106abstract nothing bindArgs(softlist<auto> vargs);
107
108public:
110
134abstract nothing bindPlaceholders( ...);
135
136public:
138
163abstract nothing bindPlaceholdersArgs(softlist<auto> vargs);
164
165public:
167
192abstract nothing bindValues( ...);
193
194public:
196
220abstract nothing bindValuesArgs(softlist<auto> vargs);
221
222public:
224
229abstract nothing close();
230
231public:
233
240abstract nothing commit();
241
242public:
244
252
253public:
255
274abstract nothing define();
275
276public:
278
285abstract hash<auto> describe();
286
287public:
289
315abstract nothing exec( ...);
316
317public:
319
346abstract nothing execArgs(softlist<auto> vargs);
347
348public:
350
367abstract hash<auto> fetchColumns(softint rows = -1);
368
369public:
371
386abstract *hash<auto> fetchRow();
387
388public:
390
407abstract list<auto> fetchRows(softint rows = -1);
408
409public:
411
422abstract hash<auto> getOutput();
423
424public:
426
437abstract hash<auto> getOutputRows();
438
439public:
441
448abstract *string getSQL();
449
450public:
452
469abstract *hash<auto> getValue();
470
471public:
473
477abstract auto memberGate(string member);
478
479public:
481
496abstract bool next();
497
498public:
500
511abstract nothing prepare(string sql, ...);
512
513public:
515
526abstract nothing prepareRaw(string sql);
527
528public:
530
537abstract nothing rollback();
538
539public:
541
549abstract bool valid();
550};
551}
552}
This class defines an abstract interface for iterators.
Definition: QC_AbstractIterator.dox.h:10
This class defines an abstract interface for the SQLStatement class.
Definition: QC_AbstractSQLStatement.dox.h:11
abstract nothing bindPlaceholders(...)
Binds placeholder buffer specifications to buffers defined in AbstractSQLStatement::prepare()
abstract nothing prepareRaw(string sql)
Saves an SQL statement that will be prepared and executed later.
abstract hash< auto > getOutput()
Retrieves output buffers as a hash; result sets will be returned as hashes of lists.
abstract nothing exec(...)
Executes the bound statement with any bound buffers, also optionally allows binding placeholder buffe...
abstract hash< auto > describe()
Describes columns in the statement result.
abstract nothing close()
Closes the statement if it is open, however this method does not release the connection or transactio...
abstract bool next()
Increments the row pointer when retrieving rows from a select statement; returns True if there is a r...
abstract hash< auto > getOutputRows()
Retrieves output buffers as a hash; result sets will be returned as lists of hashes.
abstract nothing prepare(string sql,...)
Saves an SQL statement that will be prepared and executed later, along with optional arguments.
abstract nothing beginTransaction()
Manually starts a transaction and allocates a connection or grabs the transaction lock according to t...
abstract nothing bindPlaceholdersArgs(softlist< auto > vargs)
Binds placeholder buffer specifications given as a list in the single argument to the method to buffe...
abstract nothing bind(...)
Binds placeholder buffer specifications and values to buffers defined in AbstractSQLStatement::prepar...
abstract auto memberGate(string member)
Returns the value of the given column for the current row.
abstract nothing commit()
Commits the transaction, releases the connection or the transaction lock according to the object used...
abstract nothing define()
Performs an explicit define operation on the SQLStatement.
abstract *hash< auto > fetchRow()
Retrieves the current row as a hash where the keys are the column names and the values are the column...
abstract *hash< auto > getValue()
Retrieves the current row as a hash where the keys are the column names and the values are the column...
abstract *string getSQL()
Returns the current SQL string set with the call to AbstractSQLStatement::prepare() or AbstractSQLSta...
abstract bool active()
Returns True if the object is currently active and has a connection or transaction lock allocated to ...
abstract list< auto > fetchRows(softint rows=-1)
Retrieves a block of rows as a list of hashes with the maximum number of rows determined by the argum...
abstract nothing execArgs(softlist< auto > vargs)
Executes the bound statement with any bound buffers, also optionally allows binding placeholder buffe...
abstract bool valid()
returns True if the object is currently pointing at a valid element, False if not (use when iterating...
abstract hash< auto > fetchColumns(softint rows=-1)
Retrieves a block of rows as a hash of lists with the maximum number of rows determined by the argume...
abstract nothing rollback()
Closes the SQLStatement, performs a transaction rollback, and releases the connection or the transact...
abstract nothing bindValues(...)
Binds values to value buffer specifications to buffers defined in AbstractSQLStatement::prepare()
abstract nothing bindValuesArgs(softlist< auto > vargs)
Binds values to value buffer specifications given as a list in the single argument to the method to v...
abstract nothing bindArgs(softlist< auto > vargs)
Binds placeholder buffer specifications and values given as a list in the single argument to the meth...
abstract int affectedRows()
Returns the number of rows affected by the last call to AbstractSQLStatement::exec()
abstract bool currentThreadInTransaction()
Returns True if the current thread is in a transaction (i.e. holds the transaction lock),...
Qore namespace.
Definition: QC_AbstractSmartLock.dox.h:2