Qore Programming Language Reference Manual 2.2.0
Loading...
Searching...
No Matches
QC_AbstractSQLStatement.dox.h
1
2namespace Qore {
4namespace SQL {
6
12
13public:
15
24
25public:
27
39
40public:
42
48
49public:
51
77
78public:
80
107
108public:
110
135
136public:
138
164
165public:
167
193
194public:
196
221
222public:
224
230
231public:
233
241
242public:
244
252
253public:
255
275
276public:
278
286
287public:
289
316
317public:
319
347
348public:
350
368
369public:
371
387
388public:
390
408
409public:
411
423
424public:
426
438
439public:
441
449
450public:
452
470
471public:
473
478
479public:
481
497
498public:
500
512
513public:
515
527
528public:
530
538
539public:
541
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),...
list< auto > list(...)
Returns a list of the arguments passed at the top level.
Qore namespace.
Definition QC_AbstractSmartLock.dox.h:2