 |
 |
 |
 |
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()
- 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
- Advanced GdaDataSelect usage
- 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
- 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
- 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.