Part II. API reference

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.