gda.sql_statement
Module for [SqlStatement] class
class SqlStatement
Types 1
classSqlStatement : gobject.boxed.Boxed
This structure is the top level structure encapsulating several type of statements.
Methods
gda.types.SqlStatementType stmtType() @property nothrowGet `stmtType` field. Returns: type of statementvoid stmtType(gda.types.SqlStatementType propval) @property nothrowSet `stmtType` field. Params: propval = type of statementvoid checkClean() nothrowCleans any data set by a previous call to [gda.sql_statement.SqlStatement.checkValidity].bool checkStructure()Checks for any error in stmt's structure to make sure the statement is valid (for example a SELECT statement must at least return a column, a DELETE statement must specify which table is targeted)....bool checkValidity(gda.connection.Connection cnc = null)If cnc is not null, then checks that all the database objects referenced in the statement actually exist in the connection's database (for example the table being updated in a UPDATE statement must...bool checkValidityM(gda.meta_struct.MetaStruct mstruct = null)If mstruct is not null, then checks that all the database objects referenced in the statement i actually referenced in mstruct (for example the table being updated in a UPDATE statement must exist ...void compoundSetType(gda.types.SqlStatementCompoundType type) nothrowSpecifies stmt's type of compoundvoid compoundTakeStmt(gda.sql_statement.SqlStatement s) nothrowAdds the `s` sub-statement to the `s`tmt compound statement. `s`'s reference is transferred to `s`tmt (which means `s`tmt is then responsible for freeing it when no longer needed).gda.sql_statement.SqlStatement copy() nothrowCreates a copy of stmt. Returns: a new #GdaSqlStatementvoid deleteTakeTableName(gobject.value.Value value) nothrowSets the name of the table to delete from in stmt. value's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).void insertTakeOnConflict(gobject.value.Value value) nothrowSets the name of the resolution conflict algorithm used by stmt. value's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).void insertTakeSelect(gda.sql_statement.SqlStatement select) nothrowSpecifies a SELECT statement, the values inserted will be the result set of select. select's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer nee...void insertTakeTableName(gobject.value.Value value) nothrowSets the name of the table to insert into in stmt. value's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).bool normalize(gda.connection.Connection cnc = null)"Normalizes" (in place) some parts of stmt, which means stmt may be modified. At the moment any "*" field in a SELECT statement will be replaced by one #GdaSqlSelectField structure for each field i...void transSetIsolLevel(gda.types.TransactionIsolation level) nothrowvoid updateTakeOnConflict(gobject.value.Value value) nothrowSets the name of the resolution conflict algorithm used by stmt. value's ownership is transferred to stmt (which means stmt is then responsible for freeing it when no longer needed).void updateTakeTableName(gobject.value.Value value) nothrowSets the name of the table to delete from in stmt.gda.types.SqlStatementType stringToType(string type) static nothrowConverts a string to a #GdaSqlStatementType value, see also [gda.sql_statement.SqlStatement.typeToString]string typeToString(gda.types.SqlStatementType type) static nothrowConverts a #GdaSqlStatementType to a string, see also [gda.sql_statement.SqlStatement.stringToType]Constructors
this(gda.types.SqlStatementType type)Use this function to create a #GdaSqlStatement of the specified type type.