Table of Contents
- Foreword about abstraction
- SQL identifiers
- Binary large objects (BLOBs)
- 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
- 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
-
Libgda Initialization
-
Configuration
- Configuring Libgda with environment variables
- Connections & commands
-
Convenience functions
-
GdaConnection
-
GdaSqlParser
-
GdaSqlBuilder
-
GdaStatement
-
GdaRepetitiveStatement
-
GdaBatch
-
GdaHolder
-
GdaSet
-
GdaConnectionEvent
-
GdaTransactionStatus
-
GdaXaTransaction
- 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
-
GdaVproviderDataModel
-
GdaVproviderHub
-
GdaVirtualConnection
-
GdaVconnectionDataModel
-
GdaVconnectionHub
- Data handling
-
Gda Value
- Custom data validation
- GdaHolder controls
- GdaSet controls
- GdaDataProxy controls
- Advanced GdaDataSelect usage
- Automatic re-run of the SELECT statement
- Invalid parameters
-
GdaBlobOp
-
GdaDataModel
-
GdaDataSelect
-
GdaColumn
-
GdaDataModelIter
-
GdaDataModelImport
-
GdaDataAccessWrapper
-
GdaDataModelArray
-
GdaRow
-
GdaDataModelBdb
-
GdaDataModelDir
-
GdaDataProxy
-
GdaDataComparator
- Trees
-
GdaTree
-
GdaTreeManager
-
GdaTreeNode
-
GdaTreeMgrLabel
-
GdaTreeMgrSelect
-
GdaTreeMgrSchemas
-
GdaTreeMgrTables
-
GdaTreeMgrColumns
- Data conversions
-
Default Data handlers
-
GdaHandlerString
-
GdaHandlerBoolean
-
GdaHandlerTime
-
GdaHandlerNumerical
-
GdaHandlerBin
-
GdaHandlerType
- Dictionary - metadata
- Setup
- Adding custom data
- Database structure
- Data types
- SQL identifiers
- Short and full names
- Declared foreign keys
- Individual table description
-
GdaMetaStore
-
GdaMetaStruct
- Data definition (DDL) queries
-
GdaServerOperation
-
GdaServerOperation individual nodes
-
GdaServerOperation sequences
- User interface API reference
-
LibgdaUI Initialization
-
GdauiLogin
-
GdauiProviderSelector
-
GdauiDataSelector
-
GdauiDataProxy
-
GdauiBasicForm
-
GdauiForm
-
GdauiRawForm
-
GdauiGrid
-
GdauiRawGrid
-
GdauiCombo
-
GdauiCloud
-
GdauiRtEditor
-
UI plugins
-
GdauiDataEntry
-
GdauiDataStore
-
GdauiDataFilter
-
GdauiDataProxyInfo
-
GdauiServerOperation
-
GdauiTreeStore
-
UI Utility functions
- Multi threading
-
GdaMutex
-
GdaLockable
-
GdaThreadWrapper
- Miscellaneous
-
Utility functions
-
Logging
-
Attributes manager
The following sections describe the API available for GDA applications.