Table of Contents
- HOWTO for common tasks
- Open a connection
- Define a data source (DSN)
- Build statements without using a parser
- INSERT INTO customers (e, f, g) VALUES (##p1::string, 15, 'joe')
- SELECT people.firstname AS person, people.lastname, "date" AS birthdate, age FROM people
- SELECT c."date", name AS person FROM "select" AS c INNER JOIN orders USING (id)
- UPDATE products set ref='A0E''FESP' WHERE id = 14
- DELETE FROM items WHERE id = ##theid::int
- SELECT myfunc (a, 5, 'Joe') FROM mytable
- SELECT name FROM master WHERE id IN (SELECT id FROM subdata)
- INSERT INTO customers (e, f, g) SELECT id, name, location FROM subdate
- SELECT id, name FROM subdata1 UNION SELECT ident, lastname FROM subdata2
- SELECT CASE tag WHEN 'Alpha' THEN 1 WHEN 'Bravo' THEN 2 WHEN 'Charlie' THEN 3 ELSE 0 END FROM data
- SELECT product_id, name, sum (4 * 5 * price * 1.200000) FROM invoice_lines
- SELECT id, name, adress, cntry_id, countries.name FROM customers INNER JOIN countries ON (countries.id = cntry_id)
- Execute a SELECT command
- Modify the result of a SELECT command
- Execute an INSERT, UPDATE or DELETE command
- Get the last inserted row
- Execute a DDL command
- Get information about a table's columns
- Update the meta data about a table
- Validate a DML statement
- Control value's assignment to various objects
- Add your own data to a GdaMetaStore
- Object Hierarchy
- Initialization and configuration
-
Library initialization — Library initialization and information
-
Configuration — Access/Management of libgda configuration
- Configuring Libgda with environment variables
- Connections & commands
-
GdaConnection — A connection to a database
-
GdaSqlParser — SQL parser
-
GdaSqlBuilder — Factory object for statements
-
GdaStatement — Single SQL statement
-
GdaRepetitiveStatement — Execute the same statement several times with different values
-
GdaBatch — Multiple SQL statements grouped together.
-
GdaHolder — Container for a single GValue
-
GdaSet — Container for several values
-
GdaConnectionEvent — Any event which has occurred on a GdaConnection
-
GdaTransactionStatus — Keeps track of the transaction status of a connection
-
GdaXaTransaction — Distributed transaction manager
- Description of the data model returned by gda_connection_get_meta_store_data()
- GDA_CONNECTION_META_NAMESPACES
- GDA_CONNECTION_META_TYPES
- GDA_CONNECTION_META_TABLES
- GDA_CONNECTION_META_VIEWS
- GDA_CONNECTION_META_FIELDS
- GDA_CONNECTION_META_INDEXES
- Virtual connections
-
GdaVirtualProvider — Base class for all virtual provider objects
-
GdaVproviderDataModel — Virtual provider for connections based on a list of GdaDataModel
-
GdaVproviderHub — Virtual provider for connections based on other connection
-
GdaVirtualConnection — Base class for all virtual connection objects
-
GdaVconnectionDataModel — Virtual connection based on a list of GdaDataModel
-
GdaVconnectionHub — Virtual connection which bind together connections
-
GdaLdapConnection — LDAP connection objects
- Data handling
-
A single Value — Assorted functions for dealing with GValue values
- Custom data validation
- GdaHolder controls
- GdaSet controls
- GdaDataProxy controls
- Advanced GdaDataSelect usage
- Automatic re-run of the SELECT statement
- Invalid parameters
-
Blobs — Binary data and BLOBs handling
-
GdaDataModel — Data model interface
-
GdaDataSelect — Base class for data models returned by the execution of a SELECT statement
-
GdaDataModel columns — Management of GdaDataModel column attributes
-
GdaDataModelIter — Data model iterator
-
GdaDataModelImport — Importing data from a string or a file
-
GdaDataPivot — A data model for data summarisation
-
GdaDataAccessWrapper — Offers a random access on top of a cursor-only access data model
-
GdaDataModelArray — An implementation of GdaDataModel based on a GArray
-
GdaRow — Individual row of a GdaDataModelArray object
-
GdaDataModelLdap — GdaDataModel to extract LDAP information
-
GdaDataModelBdb — GdaDataModel to access Berkeley DB database contents
-
GdaDataModelDir — GdaDataModel to list files in filesystem
-
GdaDataProxy — Proxy to hold modifications for any GdaDataModel, providing the GdaDataModel interface itself
-
GdaDataComparator — Simple data model's contents comparison
- Implementing your own data model
- Virtual methods
- Signalling changes
- Trees
-
GdaTree — A tree-structure
-
GdaTreeManager — Base class for all the tree managers
-
GdaTreeNode — A node in a GdaTree
-
GdaTreeMgrLabel — A tree manager which creates a single node
-
GdaTreeMgrSelect — A tree manager which creates a node for each row resulting from the execution of a SELECT statement
-
GdaTreeMgrSchemas — A tree manager which creates a node for each schema in a database
-
GdaTreeMgrTables — A tree manager which creates a node for each table in a schema
-
GdaTreeMgrColumns — A tree manager which creates a node for each column of a table
-
GdaTreeMgrLdap — A tree manager which creates a node for each child entry of an LDAP entry
- Data conversions
-
GdaDataHandler — Interface which provides data handling (conversions) capabilities
-
GdaHanderString — Default handler for string values
-
GdaHanderBoolean — Default handler for boolean values
-
GdaHanderTime — Default handler for time values
-
GdaHanderNumerical — Default handler for numeric values
-
GdaHanderBin — Default handler for binary values
-
GdaHanderType — Default handler for GType values
- Dictionary - metadata
- Setup
- Adding custom data
- Database structure
- Data types
- SQL identifiers
- Short and full names
- Declared foreign keys
- Individual table description
-
GdaMetaStore — Dictionary object
-
GdaMetaStruct — In memory representation of some database objects
- Data definition (DDL) queries
-
GdaServerOperation — Handles any DDL query in an abstract way
-
GdaServerOperation: individual nodes — Getting information about parts (nodes) composing a path
-
GdaServerOperation: sequences — Manipulating sequences
- User interface API reference
-
Library initialization — Library initialization and information
-
GdauiLogin — Connection opening widget
-
GdauiProviderSelector — Select a database provider from a combo box
-
GdauiDataSelector — Selecting data in a GdaDataModel
-
GdauiDataProxy — Displaying and modifying data in a GdaDataProxy
-
GdauiBasicForm — Form widget mapping the values contained in a GdaSet
-
GdauiForm — Form widget to manipulate data in a GdaDataModel, with decorations
-
GdauiRawForm — Form widget to manipulate data in a GdaDataModel
-
GdauiGrid — Grid widget to manipulate data in a GdaDataModel, with decorations
-
GdauiRawGrid — Grid widget to manipulate data in a GdaDataModel
-
GdauiCombo — Combo box to choose from the contents of a GdaDataModel
-
GdauiCloud — Cloud widget
-
GdauiRtEditor — Rich text editor which uses a subset of the txt2tags markup.
-
UI plugins — Plugin to customize dana entry widgets and call renderers in tree views
-
GdauiDataEntry — Data entry widget
-
GdauiDataStore — Bridge between a GdaDataModel and a GtkTreeModel
-
GdauiDataFilter — Entrer rules to filter the rows in a GdauiDataProxy
-
GdauiDataProxyInfo — Shows information & actions about a GdauiDataProxy widget
-
GdauiServerOperation — Enter information to perform a DDL query
-
GdauiTreeStore — Bridge between a GdaTree and a GtkTreeModel
-
UI Utility functions — Set of UI related functions
- Multi threading
-
GdaMutex — Recursive mutex implementation
-
GdaLockable — Interface for locking objects in a multi threaded environment
-
GdaThreadWrapper — Execute functions in a sub thread
- Miscellaneous
-
Utility functions — Utility functions
-
Logging — Log functions
-
Attributes manager — Manager for lists of attributes
The following sections describe the API available for GDA applications.
