gda.data_select
Module for [DataSelect] class
Types 4
Methods
DataSelect self()Returns `this`, for use in `with` statements.DataSelectGidBuilder builder()Get builder for [gda.data_select.DataSelect] Returns: New builder objectbool autoReset() @propertyvoid autoReset(bool propval) @propertygda.connection.Connection connection() @propertygda.statement.Statement deleteStmt() @propertyvoid deleteStmt(gda.statement.Statement propval) @propertygda.set.Set execParams() @propertydouble executionDelay() @propertyGet `executionDelay` property. Returns: This property stores the execution delay which has been necessary to obtain the datavoid executionDelay(double propval) @propertySet `executionDelay` property. Params: propval = This property stores the execution delay which has been necessary to obtain the datagda.statement.Statement insertStmt() @propertyvoid insertStmt(gda.statement.Statement propval) @propertyuint modelUsage() @propertygda.pstmt.PStmt preparedStmt() @propertyvoid preparedStmt(gda.pstmt.PStmt propval) @propertygda.statement.Statement selectStmt() @propertybool storeAllRows() @propertyvoid storeAllRows(bool propval) @propertygda.statement.Statement updateStmt() @propertyvoid updateStmt(gda.statement.Statement propval) @propertybool computeColumnsAttributes()Computes correct attributes for each of model's columns, which includes the "NOT NULL" attribute, the default value, the precision and scale for numeric values. Returns: TRUE if no error occurred T...bool computeModificationStatements()Makes model try to compute INSERT, UPDATE and DELETE statements to be used when modifying model's contents. Note: any modification statement set using [gda.data_select.DataSelect.setModificationSta...bool computeModificationStatementsExt(gda.types.DataSelectConditionType condType)Makes model try to compute INSERT, UPDATE and DELETE statements to be used when modifying model's contents. Note: any modification statement set using [gda.data_select.DataSelect.setModificationSta...bool computeRowSelectionCondition()Offers the same features as [gda.data_select.DataSelect.setRowSelectionCondition] but the expression is computed from the meta data associated to the connection being used when model was created.gda.connection.Connection getConnection()Get a pointer to the #GdaConnection object which was used when model was created (and which may be used internally by model). Returns: a pointer to the #GdaConnection, or nullbool prepareForOffline()Use this method to make sure all the data contained in the data model are stored on the client side (and that no subsquent call to the server will be necessary to access that data), at the cost of ...bool rerun()Requests that model be re-run to have an updated result. If an error occurs, then model will not be changed. Returns: true if no error occurred Throws: [DataSelectException]bool setModificationStatement(gda.statement.Statement modStmt)Informs model that it should allow modifications to the data in some columns and some rows using mod_stmt to propagate those modifications into the database.bool setModificationStatementSql(string sql)Offers the same feature as [gda.data_select.DataSelect.setModificationStatement] but using an SQL statement.bool setRowSelectionConditionSql(string sqlWhere)Specifies the SQL condition corresponding to the WHERE part of a SELECT statement which would return only 1 row (the expression of the primary key).classDataSelectGidBuilderImpl(T) : gobject.object.ObjectWrapGidBuilderImpl!T, gda.data_model.DataModelGidBuilderImpl!T
Methods
T autoReset(bool propval)T connection(gda.connection.Connection propval)T deleteStmt(gda.statement.Statement propval)T execParams(gda.set.Set propval)T executionDelay(double propval)Set `executionDelay` property. Params: propval = This property stores the execution delay which has been necessary to obtain the data Returns: Builder instance for fluent chainingT insertStmt(gda.statement.Statement propval)T modelUsage(uint propval)T preparedStmt(gda.pstmt.PStmt propval)T storeAllRows(bool propval)T updateStmt(gda.statement.Statement propval)Fluent builder for [gda.data_select.DataSelect]
Methods
classDataSelectException : ErrorWrap