Back to Seed Clases

Gda

Classes

Interfaces

Structs

Unions

Enums

GObject.Object
parent-child marker Gda.Connection

Class Gda.Connection

Import line:	Gda = imports.gi.Gda;
GIR File:	Gda-4.0.gir
C documentation:	GdaConnection
Class :	Connection
Implements:	Gda.Lockable
Extends:	GObject.Object
	Show / Hide Inherited methods, properties and signals

Properties
Properties		Defined By
	auth_string : String	Gda.Connection
	cnc_string : String	Gda.Connection
	dsn : String	Gda.Connection
	is_wrapper : Boolean	Gda.Connection
	meta_store : Gda.MetaStore	Gda.Connection
	monitor_wrapped_in_mainloop : Boolean	Gda.Connection
	object : GObject.Object read only	Gda.Connection
	options : Gda.ConnectionOptions	Gda.Connection
	priv : Gda.ConnectionPrivate read only	Gda.Connection
	provider : Gda.ServerProvider	Gda.Connection
	thread_owner : void*	Gda.Connection

Methods / Constructors
Method / Constructor		Defined By
	new Gda.Connection (Object *properties) Create a new Gda.Connection Create a new Gda.Connection Parameters: Object properties*
	Gda.Connection.open_from_dsn (String *dsn, String auth_string, ConnectionOptions options) : Gda.Connection This function is the way of opening database connections with libgda, using a pre-defined data source (DSN), see gda_config_define_dsn() for more information about how to define a DSN. This function is the way of opening database connections with libgda, using a pre-defined data source (DSN), see gda_config_define_dsn() for more information about how to define a DSN. If you don't want to define a DSN, it is possible to use gda_connection_open_from_string() instead of this method. (if <username> and/or <password> are provided, and auth_string* is NULL, then these username and passwords will be used). Note that if provided, <username> and <password> must be encoded as per RFC 1738, see gda_rfc1738_encode() for more information. The auth_string can contain the authentication information for the server to accept the connection. It is a string containing semi-colon seperated named value, usually like "USERNAME=...;PASSWORD=..." where the ... are replaced by actual values. Note that each name and value must be encoded as per RFC 1738, see gda_rfc1738_encode() for more information. The actual named parameters required depend on the provider being used, and that list is available as the auth_params member of the GdaProviderInfo structure for each installed provider (use gda_config_get_provider_info() to get it). Also one can use the "gda-sql-4.0 -L" command to list the possible named parameters. Parameters: String dsn Required (not null) String auth_string Required (not null) Gda.ConnectionOptions options Required (not null) Returns: Gda.Connection	Gda.Connection
	Gda.Connection.open_from_string (String *provider_name, String cnc_string, String auth_string, ConnectionOptions options) : Gda.Connection Opens a connection given a provider ID and a connection string. Opens a connection given a provider ID and a connection string. This allows applications to open connections without having to create a data source (DSN) in the configuration. The format of cnc_string* is similar to PostgreSQL and MySQL connection strings. It is a semicolumn-separated series of <key>=<value> pairs, where each key and value are encoded as per RFC 1738, see gda_rfc1738_encode() for more information. The possible keys depend on the provider, the "gda-sql-4.0 -L" command can be used to list the actual keys for each installed database provider. For example the connection string to open an SQLite connection to a database file named "my_data.db" in the current directory would be "DB_DIR=.;DB_NAME=my_data". The cnc_string string must have the following format: "[<provider>://][<username>[:<password>]@]<connection_params>" (if <username> and/or <password> are provided, and auth_string is NULL, then these username and passwords will be used, and if <provider> is provided and provider_name is NULL then this provider will be used). Note that if provided, <username>, <password> and <provider> must be encoded as per RFC 1738, see gda_rfc1738_encode() for more information. The auth_string must contain the authentication information for the server to accept the connection. It is a string containing semi-colon seperated named values, usually like "USERNAME=...;PASSWORD=..." where the ... are replaced by actual values. Note that each name and value must be encoded as per RFC 1738, see gda_rfc1738_encode() for more information. The actual named parameters required depend on the provider being used, and that list is available as the auth_params member of the GdaProviderInfo structure for each installed provider (use gda_config_get_provider_info() to get it). Similarly to the format of the connection string, use the "gda-sql-4.0 -L" command to list the possible named parameters. Additionally, it is possible to have the connection string respect the "<provider_name>://<real cnc string>" format, in which case the provider name and the real connection string will be extracted from that string (note that if provider_name is not NULL then it will still be used as the provider ID). Parameters: String provider_name Required (not null) String cnc_string Required (not null) String auth_string Required (not null) Gda.ConnectionOptions options Required (not null) Returns: Gda.Connection	Gda.Connection
	Gda.Connection.open_sqlite (String *directory, String filename, Boolean auto_unlink) : Gda.Connection Opens an SQLite connection even if the SQLite provider is not installed, to be used by database providers which need a temporary database to store some information. Opens an SQLite connection even if the SQLite provider is not installed, to be used by database providers which need a temporary database to store some information. Parameters: String directory* Required (not null) String filename Required (not null) Boolean auto_unlink Required (not null) Returns: Gda.Connection	Gda.Connection
	Gda.Connection.string_split (String *string, Array out_cnc_params, Array out_provider, Array out_username, Array out_password) : none Parameters: String string* Required (not null) Array out_cnc_params Required (not null) Array out_provider Required (not null) Array out_username Required (not null) Array out_password Required (not null) Returns: none	Gda.Connection
	add_event (ConnectionEvent *event) : none Adds an event to the given connection. Adds an event to the given connection. This function is usually called by providers, to inform clients of events that happened during some operation. As soon as a provider (or a client, it does not matter) calls this function with an event* object which is an error, the connection object emits the "error" signal, to which clients can connect to be informed of events. Parameters: Gda.ConnectionEvent event Required (not null) is stored internally, so you don't need to unref it. Returns: none	Gda.Connection
	add_prepared_statement (Statement *gda_stmt, PStmt prepared_stmt) : none Declares that prepared_stmt* is a prepared statement object associated to gda_stmt within the connection (meaning the connection increments the reference counter of prepared_stmt). Declares that prepared_stmt is a prepared statement object associated to gda_stmt within the connection (meaning the connection increments the reference counter of prepared_stmt). If gda_stmt changes or is destroyed, the the association will be lost and the connection will lose the reference it has on prepared_stmt. Parameters: Gda.Statement gda_stmt Required (not null) Gda.PStmt prepared_stmt Required (not null) Returns: none	Gda.Connection
	add_savepoint (String *name) : Boolean Adds a SAVEPOINT named name. Adds a SAVEPOINT named name. Parameters: String name* name of the savepoint to add Returns: Boolean	Gda.Connection
	async_cancel (Number *task_id) : Boolean Requests that a task be cancelled. Requests that a task be cancelled. This operation may of may not have any effect depending on the task's status, even if it returns TRUE. If it returns FALSE, then the task has not been cancelled. Parameters: Number task_id* Required (not null) Returns: Boolean	Gda.Connection
	async_fetch_result (Number *task_id, Object out_values) : GObject.Object Use this method to obtain the result of the execution of a statement which has been executed asynchronously by calling gda_connection_async_statement_execute(). Use this method to obtain the result of the execution of a statement which has been executed asynchronously by calling gda_connection_async_statement_execute(). This function is non locking and will return NULL* (and no error will be set) if the statement has not been executed yet. If the statement has been executed, this method returns the same value as gda_connection_statement_execute() would have if the statement had been executed synchronously. Parameters: Number task_id Required (not null) Object out_values Gda.Set last_insert_row Returns: GObject.Object	Gda.Connection
	async_statement_execute (Statement *stmt, Set params, StatementModelUsage model_usage, Array col_types, Boolean need_last_insert_row) : Number This method is similar to gda_connection_statement_execute() but is asynchronous as it method returns immediately with a task ID. This method is similar to gda_connection_statement_execute() but is asynchronous as it method returns immediately with a task ID. It's up to the caller to use gda_connection_async_fetch_result() regularly to check if the statement's execution is finished. It is possible to call the method several times to request several statements to be executed asynchronously, the statements will be executed in the order in which they were requested. The parameters, if present, are copied and can be discarded or modified before the statement is actually executed. The stmt* object is not copied but simply referenced (for performance reasons), and if it is modified before it is actually executed, then its execution will not occur. It is however safe to call g_object_unref() on it if it's not needed anymore. The execution failure of any statement has no impact on the execution of other statements except for example if the connection has a transaction started and the failure invalidates the transaction (as decided by the database server). but any other error) Parameters: Gda.Statement stmt Required (not null) Gda.Set params , or NULL Gda.StatementModelUsage model_usage Required (not null) Array col_types an array of GType to request each returned GdaDataModel's column's GType, terminated with the G_TYPE_NONE Boolean need_last_insert_row Required (not null) Returns: Number	Gda.Connection
	batch_execute (Batch *batch, Set params, StatementModelUsage model_usage) : Array Executes all the statements contained in batch* (in the order in which they were added to batch), and returns a list of GObject objects, at most one GObject for each statement; see gda_connection_statement_execute() for details about the returned objects. Executes all the statements contained in batch (in the order in which they were added to batch), and returns a list of GObject objects, at most one GObject for each statement; see gda_connection_statement_execute() for details about the returned objects. If one of the statement fails, then none of the subsequent statement will be executed, and the method returns the list of GObject created by the correct execution of the previous statements. If a transaction is required, then it should be started before calling this method. Parameters: Gda.Batch batch Required (not null) Gda.Set params , or NULL Gda.StatementModelUsage model_usage Required (not null) will be used, as a GdaStatementModelUsage enum Returns: Array a new list of GObject objects	Gda.Connection
	begin_transaction (String *name, TransactionIsolation level) : Boolean Starts a transaction on the data source, identified by the Before starting a transaction, you can check whether the underlying provider does support transactions or not by using the gda_connection_supports_feature() function. Starts a transaction on the data source, identified by the Before starting a transaction, you can check whether the underlying provider does support transactions or not by using the gda_connection_supports_feature() function. otherwise. Parameters: String name* the name of the transation to start, or NULL Gda.TransactionIsolation level Required (not null) Returns: Boolean	Gda.Connection
	clear_events_list () : none This function lets you clear the list of GdaConnectionEvent's of the given connection. This function lets you clear the list of GdaConnectionEvent's of the given connection. Returns: none	Gda.Connection
	close () : none Closes the connection to the underlying data source, but first emits the "conn-to-close" signal. Closes the connection to the underlying data source, but first emits the "conn-to-close" signal. Returns: none	Gda.Connection
	close_no_warning () : none Closes the connection to the underlying data source, without emiting any warning signal. Closes the connection to the underlying data source, without emiting any warning signal. Returns: none	Gda.Connection
	commit_transaction (String *name) : Boolean Commits the given transaction to the backend database. Commits the given transaction to the backend database. You need to call gda_connection_begin_transaction() first. FALSE* otherwise. Parameters: String name the name of the transation to commit, or NULL Returns: Boolean	Gda.Connection
	create_operation (ServerOperationType *type, Set options) : Gda.ServerOperation Creates a new GdaServerOperation* object which can be modified in order to perform the type type of action. Creates a new GdaServerOperation object which can be modified in order to perform the type type of action. It is a wrapper around the gda_server_provider_create_operation() method. of operation or if an error occurred Parameters: Gda.ServerOperationType type Required (not null) Gda.Set options an optional list of parameters Returns: Gda.ServerOperation	Gda.Connection
	create_parser () : Gda.SqlParser Creates a new parser object able to parse the SQL dialect understood by cnc. Creates a new parser object able to parse the SQL dialect understood by cnc. If the GdaServerProvider object internally used by cnc does not have its own parser, then NULL is returned, and a general SQL parser can be obtained using gda_sql_parser_new(). Returns: Gda.SqlParser	Gda.Connection
	del_prepared_statement (Statement *gda_stmt) : none gda_connection_add_prepared_statement() does. gda_connection_add_prepared_statement() does. Parameters: Gda.Statement gda_stmt* Required (not null) Returns: none	Gda.Connection
	delete_savepoint (String *name) : Boolean Delete the SAVEPOINT named name* when not used anymore. Delete the SAVEPOINT named name when not used anymore. Parameters: String name name of the savepoint to delete Returns: Boolean	Gda.Connection
	get_authentication () : String Gets the user name used to open this connection. Gets the user name used to open this connection. Returns: String	Gda.Connection
	get_cnc_string () : String Gets the connection string used to open this connection. Gets the connection string used to open this connection. The connection string is the string sent over to the underlying database provider, which describes the parameters to be used to open a connection on the underlying data source. Returns: String	Gda.Connection
	get_dsn () : String to. to. Returns: String	Gda.Connection
	get_events () : Array Retrieves a list of the last errors occurred during the connection. Retrieves a list of the last errors occurred during the connection. The returned list is chronologically ordered such as that the most recent event is the GdaConnectionEvent of the first node. Returns: Array	Gda.Connection
	get_meta_store () : Gda.MetaStore Get or initializes the GdaMetaStore associated to cnc Get or initializes the GdaMetaStore associated to cnc Returns: Gda.MetaStore	Gda.Connection
	get_meta_store_data_v (ConnectionMetaType *meta_type, Array filters) : Gda.DataModel see gda_connection_get_meta_store_data* for freeing the returned model using g_object_unref(). see gda_connection_get_meta_store_data for freeing the returned model using g_object_unref(). Parameters: Gda.ConnectionMetaType meta_type Required (not null) Array filters Required (not null) a GList of GdaHolder objects Returns: Gda.DataModel	Gda.Connection
	get_options () : Gda.ConnectionOptions Gets the GdaConnectionOptions used to open this connection. Gets the GdaConnectionOptions used to open this connection. Returns: Gda.ConnectionOptions	Gda.Connection
	get_prepared_statement (Statement *gda_stmt) : Gda.PStmt Retrieves a pointer to an object representing a prepared statement for gda_stmt* within cnc. Retrieves a pointer to an object representing a prepared statement for gda_stmt within cnc. The association must have been done using gda_connection_add_prepared_statement(). Parameters: Gda.Statement gda_stmt Required (not null) Returns: Gda.PStmt the prepared statement, or NULL if no association exists	Gda.Connection
	get_provider () : Gda.ServerProvider Gets a pointer to the GdaServerProvider object used to access the database Gets a pointer to the GdaServerProvider object used to access the database Returns: Gda.ServerProvider	Gda.Connection
	get_provider_name () : String Gets the name (identifier) of the database provider used by cnc Gets the name (identifier) of the database provider used by cnc Returns: String	Gda.Connection
	get_transaction_status () : Gda.TransactionStatus Get the status of cnc regarding transactions. Get the status of cnc regarding transactions. The returned object should not be modified or destroyed; however it may be modified or destroyed by the connection itself. If NULL is returned, then no transaction has been associated with cnc Returns: Gda.TransactionStatus a GdaTransactionStatus object, or NULL	Gda.Connection
	is_opened () : Boolean Checks whether a connection is open or not. Checks whether a connection is open or not. Returns: Boolean	Gda.Connection
	lock () : none Returns: none	Gda.Lockable
	open () : Boolean Tries to open the connection. Tries to open the connection. Returns: Boolean	Gda.Connection
	perform_operation (ServerOperation op) : Boolean Performs the operation described by op (which should have been created using gda_connection_create_operation()). Performs the operation described by op (which should have been created using gda_connection_create_operation()). It is a wrapper around the gda_server_provider_perform_operation() method. Parameters: Gda.ServerOperation op Required (not null) Returns: Boolean	Gda.Connection
	quote_sql_identifier (String id) : String Use this method to get a correctly quoted (if necessary) SQL identifier which can be used in SQL statements, from id. Use this method to get a correctly quoted (if necessary) SQL identifier which can be used in SQL statements, from id. If id is already correctly quoted for cnc, then a copy of id may be returned. This method may add double quotes (or other characters) around id: if id is a reserved SQL keyword (such as SELECT, INSERT, ...) if id contains non allowed characters such as spaces, or if it starts with a digit in any other event as necessary for cnc, depending on the the options passed when opening the cnc connection, and specifically the GDA_CONNECTION_OPTIONS_SQL_IDENTIFIERS_CASE_SENSITIVE option. One can safely pass an already quoted id to this method, either with quoting characters allowed by cnc or using the double quote (") character. Parameters: String id Required (not null) Returns: String once not needed anymore	Gda.Connection
	repetitive_statement_execute (RepetitiveStatement *rstmt, StatementModelUsage model_usage, Array col_types, Boolean stop_on_error) : Array Executes the statement upon which rstmt* is built. Executes the statement upon which rstmt is built. Note that as several statements can actually be executed by this method, it is recommended to be within a transaction. If error is not NULL and stop_on_error is FALSE, then it may contain the last error which occurred. represent), one for each actual execution of the statement upon which rstmt is built. If stop_on_error is FALSE, then the list may contain some NULL pointers which refer to statements which failed to execute. Parameters: Gda.RepetitiveStatement rstmt Required (not null) Gda.StatementModelUsage model_usage Required (not null) Array col_types for more information Boolean stop_on_error Required (not null) Returns: Array for more information about what they	Gda.Connection
	rollback_savepoint (String *name) : Boolean Rollback all the modifications made after the SAVEPOINT named name. Rollback all the modifications made after the SAVEPOINT named name. Parameters: String name* name of the savepoint to rollback to Returns: Boolean	Gda.Connection
	rollback_transaction (String *name) : Boolean Rollbacks the given transaction. Rollbacks the given transaction. This means that all changes made to the underlying data source since the last call to gda_connection_begin_transaction() or gda_connection_commit_transaction() will be discarded. Parameters: String name* the name of the transation to commit, or NULL Returns: Boolean	Gda.Connection
	statement_execute (Statement *stmt, Set params, StatementModelUsage model_usage, Object out_values) : GObject.Object Executes stmt. Executes stmt. As stmt* can, by desing (and if not abused), contain only one SQL statement, the return object will either be: a GdaDataSelect object (which is also a GdaDataModel) if stmt is a SELECT statement (usually a GDA_SQL_STATEMENT_SELECT, see GdaSqlStatementType) containing the results of the SELECT. The resulting data model is by default read only, but modifications can be enabled, see the GdaDataSelect's documentation for more information. a GdaSet for any other SQL statement which correctly executed. In this case (if the provider supports it), then the GdaSet may contain value holders named: a (gint) GdaHolder named "IMPACTED_ROWS" a (GObject) GdaHolder named "EVENT" which contains a GdaConnectionEvent If last_insert_row is not NULL and stmt is an INSERT statement, then it will contain (if the provider used by cnc supports it) a new GdaSet object composed of value holders named "+<column number>" starting at column 0 which contain the actual inserted values. For example if a table is composed of an 'id' column which is auto incremented and a 'name' column then the execution of a "INSERT INTO mytable (name) VALUES ('joe')" query will return a GdaSet with two holders: one with the '+0' ID which may for example contain 1 (note that its "name" property should be "id") one with the '+1' ID which will contain 'joe' (note that its "name" property should be "name") This method may fail with a GDA_SERVER_PROVIDER_ERROR domain error (see the GdaServerProviderError error codes). be executed and this method will return NULL. invalid parameters, then the statement can't be executed and this method will return NULL, unless the invalid parameters and if model_usage has the GDA_STATEMENT_MODEL_ALLOW_NOPARAM flag, then the returned data model will contain no row but will have all the correct columns (even though some of the columns might report as GDA_TYPE_NULL). In this case, if (after this method call) any of params' parameters change then the resulting data model will re-run itself, see the GdaDataSelect's auto-reset property for more information. GDA_STATEMENT_MODEL_CURSOR_FORWARD flags, then the default will be to return a random access data model transaction will have been started by the database provider, and it's up to the caller to close the transaction (which will then be locked) once all the blob ressources have been liberated (when the returned data model is destroyed). See the section about Binary large objects (BLOBs) for more information. Also see the provider's limitations, and the Advanced GdaDataSelect usage sections. Parameters: Gda.Statement stmt Required (not null) Gda.Set params , or NULL Gda.StatementModelUsage model_usage Required (not null) Object out_values Gda.Set last_insert_row Returns: GObject.Object	Gda.Connection
	statement_execute_non_select (Statement *stmt, Set params, Object out_values) : Number Executes a non-selection statement on the given connection. Executes a non-selection statement on the given connection. The gda_execute_non_select_command() method can be easier to use if one prefers to use some SQL directly. This function returns the number of rows affected by the execution of stmt, or -1 if an error occurred, or -2 if the connection's provider does not return the number of rows affected. This function is just a convenience function around the gda_connection_statement_execute() function. See the documentation of the gda_connection_statement_execute() for information about the params* list of parameters. See gda_connection_statement_execute() form more information about last_insert_row. Parameters: Gda.Statement stmt Required (not null) Gda.Set params , or NULL Object out_values Gda.Set last_insert_row Returns: Number or -1 or -2	Gda.Connection
	statement_execute_select (Statement *stmt, Set params) : Gda.DataModel Executes a selection command on the given connection. Executes a selection command on the given connection. The gda_execute_select_command() method can be easier to use if one prefers to use some SQL directly. This function returns a GdaDataModel* resulting from the SELECT statement, or NULL if an error occurred. This function is just a convenience function around the gda_connection_statement_execute() function. See the documentation of the gda_connection_statement_execute() for information about the params list of parameters. data source, or NULL if an error occurred Parameters: Gda.Statement stmt Required (not null) Gda.Set params , or NULL Returns: Gda.DataModel	Gda.Connection
	statement_execute_select_full (Statement *stmt, Set params, StatementModelUsage model_usage, Array col_types) : Gda.DataModel value. value. Any value left to 0 will make the database provider determine the real GType. col_types* can also be NULL if no column type is specified. Executes a selection command on the given connection. This function returns a GdaDataModel resulting from the SELECT statement, or NULL if an error occurred. This function is just a convenience function around the gda_connection_statement_execute() function. See the documentation of the gda_connection_statement_execute() for information about the params list of parameters. data source, or NULL if an error occurred Parameters: Gda.Statement stmt Required (not null) Gda.Set params , or NULL Gda.StatementModelUsage model_usage Required (not null) Array col_types an array of GType to request each returned GdaDataModel's column's GType, terminated with the G_TYPE_NONE Returns: Gda.DataModel	Gda.Connection
	statement_prepare (Statement *stmt) : Boolean Ask the database accessed through the cnc* connection to prepare the usage of stmt. Ask the database accessed through the cnc connection to prepare the usage of stmt. This is only useful if stmt will be used more than once (however some database providers may always prepare statements before executing them). This function is also useful to make sure stmt is fully understood by the database before actually executing it. Note however that it is also possible that gda_connection_statement_prepare() fails when gda_connection_statement_execute() does not fail (this will usually be the case with statements such as tablename::string"]]> because database usually don't allow variables to be used in place of a table name). Parameters: Gda.Statement stmt Required (not null) Returns: Boolean	Gda.Connection
	statement_to_sql (Statement *stmt, Set params, StatementSqlFlag flags, Object out_values) : String Renders stmt* as an SQL statement, adapted to the SQL dialect used by cnc Renders stmt as an SQL statement, adapted to the SQL dialect used by cnc Parameters: Gda.Statement stmt Required (not null) Gda.Set params , or NULL Gda.StatementSqlFlag flags Required (not null) Object out_values Array params_used Returns: String	Gda.Connection
	supports_feature (ConnectionFeature *feature) : Boolean Asks the underlying provider for if a specific feature is supported. Asks the underlying provider for if a specific feature is supported. Parameters: Gda.ConnectionFeature feature* Required (not null) Returns: Boolean	Gda.Connection
	trylock () : Boolean Returns: Boolean	Gda.Lockable
	unlock () : none Returns: none	Gda.Lockable
	update_meta_store (MetaContext *context) : Boolean Updates cnc's associated GdaMetaStore. Updates cnc's associated GdaMetaStore. If context* is not NULL, then only the parts described by explanations follow: In order to keep the meta store's contents in a consistent state, the update process involves updating the contents of all the tables related to one where the contents change. For example the "_columns" table (which lists all the columns of a table) depends on the "_tables" table (which lists all the tables in a schema), so if a row is added, removed or modified in the "_tables", then the "_columns" table's contents needs to be updated as well regarding that row. If context is NULL, then the update process will simply overwrite any data that was present in all the meta store's tables with new (up to date) data even if nothing has changed, without having to build the tables' dependency tree. This is the recommended way of proceeding when dealing with a meta store which might be outdated. On the other hand, if context is not NULL, then a tree of the dependencies has to be built (depending on context may be useful for example in the following situations: One knows that a database object has changed (for example a table created), and may use the context to request that only the information about that table be updated One is only interrested in the list of views, and may request that only the information about views may be updated When context is not NULL, and contains specified SQL identifiers (for example the "table_name" of the "_tables" table), then each SQL identifier has to match the convention the GdaMetaStore has adopted regarding case sensitivity, using gda_connection_quote_sql_identifier() or gda_meta_store_sql_identifier_quote(). see the meta data section about SQL identifiers for more information, and the documentation about the gda_sql_identifier_quote() function which will be most useful. Note however that usually more information will be updated than strictly requested by the context argument. For more information, see the Database structure section, and the Update the meta data about a table howto. Parameters: Gda.MetaContext context description of which part of cnc's associated GdaMetaStore should be updated, or NULL Returns: Boolean	Gda.Connection
	value_to_sql_string (Value *from) : String Parameters: GObject.Value from* Required (not null) Returns: String	Gda.Connection

Events - usage syntax: this.signals.EVENTNAME.connect( Function )
Event		Defined By
	conn_closed (Connection *self) : none Parameters: Gda.Connection self* Returns: {none}	Gda.Connection
	conn_opened (Connection *self) : none Parameters: Gda.Connection self* Returns: {none}	Gda.Connection
	conn_to_close (Connection *self) : none Parameters: Gda.Connection self* Returns: {none}	Gda.Connection
	dsn_changed (Connection *self) : none Parameters: Gda.Connection self* Returns: {none}	Gda.Connection
	error (Connection *self, ConnectionEvent object) : none Parameters: Gda.Connection self* Gda.ConnectionEvent object Returns: {none}	Gda.Connection
	transaction_status_changed (Connection *self) : none Parameters: Gda.Connection self* Returns: {none}	Gda.Connection

Used by These Methods / Signals / Properties
Class / Namespace	Method / Signal / Properties
Gda Method	Gda.completion_list_get (Connection *cnc, String sql, Number start, Number end*) : Array
Gda Method	Gda.compute_dml_statements (Connection *cnc, Statement select_stmt, Boolean require_pk, Statement insert_stmt, Statement update_stmt, Statement delete_stmt*) : Boolean
Gda Method	Gda.compute_unique_table_row_condition_with_cnc (Connection *cnc, SqlStatementSelect stsel, MetaTable mtable, Boolean require_pk*) : Gda.SqlExpr
Gda Method	Gda.delete_row_from_table (Connection *cnc, String table, String condition_column_name, Value condition_value*) : Boolean
Gda Method	Gda.execute_non_select_command (Connection *cnc, String sql*) : Number
Gda Method	Gda.execute_select_command (Connection *cnc, String sql*) : Gda.DataModel
Gda Method	Gda.insert_row_into_table_v (Connection *cnc, String table, Array col_names, Array values*) : Boolean
Gda Method	Gda.prepare_drop_table (Connection *cnc, String table_name*) : Gda.ServerOperation
Gda Method	Gda.sql_identifier_quote (String id, Connection *cnc, ServerProvider prov, Boolean meta_store_convention, Boolean force_quotes*) : String
Gda Method	Gda.update_row_in_table_v (Connection *cnc, String table, String condition_column_name, Value condition_value, Array col_names, Array values*) : Boolean
Gda.DataSelect Property	connection : Gda.Connection
Gda.DataSelect Method	get_connection () : Gda.Connection
Gda.HandlerString Method	new Gda.HandlerString.with_provider (ServerProvider *prov, Connection cnc*) : Gda.HandlerString Create a new Gda.HandlerString
Gda.MetaStore Property	cnc : Gda.Connection
Gda.MetaStore Method	Gda.MetaStore.sql_identifier_quote (String id, Connection *cnc*) : String
Gda.MetaStore Method	get_internal_connection () : Gda.Connection
Gda.ServerOperation Property	connection : Gda.Connection
Gda.ServerProvider Method	get_server_version (Connection *cnc*) : String
Gda.ServerProvider Method	supports_feature (Connection *cnc, ConnectionFeature feature*) : Boolean
Gda.ServerProvider Method	get_data_handler_g_type (Connection *cnc, Number for_type*) : Gda.DataHandler
Gda.ServerProvider Method	get_data_handler_dbms (Connection *cnc, String for_type*) : Gda.DataHandler
Gda.ServerProvider Method	string_to_value (Connection *cnc, String string, Number preferred_type, Array dbms_type*) : GObject.Value
Gda.ServerProvider Method	value_to_sql_string (Connection *cnc, Value from*) : String
Gda.ServerProvider Method	get_default_dbms_type (Connection *cnc, Number type*) : String
Gda.ServerProvider Method	escape_string (Connection *cnc, String str*) : String
Gda.ServerProvider Method	unescape_string (Connection *cnc, String str*) : String
Gda.ServerProvider Method	supports_operation (Connection *cnc, ServerOperationType type, Set options*) : Boolean
Gda.ServerProvider Method	create_operation (Connection *cnc, ServerOperationType type, Set options*) : Gda.ServerOperation
Gda.ServerProvider Method	render_operation (Connection *cnc*, ServerOperation op) : String
Gda.ServerProvider Method	perform_operation (Connection *cnc*, ServerOperation op) : Boolean
Gda.ServerProvider Method	create_parser (Connection *cnc*) : Gda.SqlParser
Gda.ServerProvider Method	perform_operation_default (Connection *cnc*, ServerOperation op) : Boolean
Gda.ServerProvider Method	get_data_handler_default (Connection *cnc, Number type, String dbms_type*) : Gda.DataHandler
Gda.ServerProvider Method	handler_find (Connection *cnc, Number g_type, String dbms_type*) : Gda.DataHandler
Gda.ServerProvider Method	handler_declare (DataHandler dh, Connection *cnc, Number g_type, String dbms_type*) : none
Gda.SqlStatement Method	check_validity (Connection *cnc*) : Boolean
Gda.SqlStatement Method	normalize (Connection *cnc*) : Boolean
Gda.Statement Signal	checked (Statement *self, Connection object*, Boolean p0) : none
Gda.Statement Method	to_sql_extended (Connection *cnc, Set params, StatementSqlFlag flags, Object out_values) : String Renders stmt* as an SQL statement, with some control on how it is rendered.
Gda.Statement Method	check_validity (Connection *cnc) : Boolean If cnc* is not NULL then checks that every object (table, field, function) used in stmt actually exists in cnc's database If cnc is NULL, then cleans anything related to cnc in stmt.
Gda.Statement Method	normalize (Connection *cnc) : Boolean "Normalizes" some parts of stmt*, see gda_sql_statement_normalize() for more information.
Gda.TreeMgrColumns Property	connection : Gda.Connection
Gda.TreeMgrColumns Method	new Gda.TreeMgrColumns.c_new (Connection *cnc, String schema, String table_name*) : Gda.TreeMgrColumns Create a new Gda.TreeMgrColumns
Gda.TreeMgrSchemas Property	connection : Gda.Connection
Gda.TreeMgrSchemas Method	new Gda.TreeMgrSchemas.c_new (Connection *cnc*) : Gda.TreeMgrSchemas Create a new Gda.TreeMgrSchemas
Gda.TreeMgrSelect Property	connection : Gda.Connection
Gda.TreeMgrSelect Method	new Gda.TreeMgrSelect.c_new (Connection *cnc, Statement stmt, Set params*) : Gda.TreeMgrSelect Create a new Gda.TreeMgrSelect
Gda.TreeMgrTables Property	connection : Gda.Connection
Gda.TreeMgrTables Method	new Gda.TreeMgrTables.c_new (Connection *cnc, String schema*) : Gda.TreeMgrTables Create a new Gda.TreeMgrTables
Gda.XaTransaction Method	register_connection (Connection *cnc, String branch*) : Boolean
Gda.XaTransaction Method	unregister_connection (Connection *cnc*) : none

Un-official Seed Documentation

Gda

Classes

Interfaces

Structs

Unions

Enums

Class Gda.Connection