lazarus_sqldb library
SQL datasets and connections: a Dart port of the Free Pascal sqldb
unit (TSQLQuery, TSQLConnection) plus the HTTP database gateway.
Classes
- LazarusDbDriver
- Interface of the database gateway used by TWapSQLConnection.
- LazarusDbResult
- Rows and affected-row count returned by the database gateway.
- TBlobBuffer
- Cached contents of a blob field.
- TBufBlobField
- Reference to a cached blob in a record buffer.
- TConnectionDef
- Describes a connection type that TSQLConnector can create.
- TCustomBufDataset
-
A dataset that keeps its records in memory (FPC
TBufDataset). - TCustomSQLQuery
- Base of TSQLQuery.
- TCustomSQLScript
- Base of SQL scripts made of several statements.
- TCustomSQLStatement
- Base of statements that return no rows.
- TFormatSettings
- Number and date formats used when converting values to text.
- TQueryRef
- A mutable TSQLQuery reference.
- TQuerySQLStatement
- The statement used internally by a TCustomSQLQuery.
- TServerIndexDefs
- Index definitions read from the server.
- TSQLConnection
-
A connection to a SQL database (FPC
TSQLConnection). - TSQLConnector
- A TSQLConnection that picks its connection type by name.
- TSQLCursor
- A prepared statement and its result rows.
- TSQLDBFieldDef
- A TFieldDef for a SQL result column.
- TSQLDBFieldDefs
- The TSQLDBFieldDefs of a SQL result.
- TSQLDBParam
- A TParam of a SQL statement.
- TSQLDBParams
- The TSQLDBParams of a SQL statement.
- TSQLHandle
- Base of connection-specific statement handles.
- TSqlObjectIdentifier
- A schema-qualified SQL object name.
- TSqlObjectIdentifierList
- A list of TSqlObjectIdentifiers.
- TSQLQuery
-
A dataset filled by a SQL query (FPC
TSQLQuery); what WML<dbquery>creates. - TSQLScript
- Runs a script of several SQL statements.
- TSQLSequence
- Fills a field from a database sequence when records are inserted.
- TSQLStatement
- A SQL statement that returns no rows (INSERT / UPDATE / DELETE).
- TSQLStatementInfo
- Information about a parsed SQL statement.
- TSQLTransaction
- A transaction of a TSQLConnection.
- TWapCursor
- A TSQLCursor for the HTTP database gateway.
- TWapSQLConnection
- A TSQLConnection that sends SQL to the WapForm HTTP database gateway.
- TWapTransactionHandle
- Transaction handle for the HTTP database gateway.
- WapDb
-
HTTP client of the WapForm database gateway (
/query,/exec). - WapDbBridgeDriver
- The adapter: wires WapDb's HTTP calls into the LazarusDbDriver that TWapSQLConnection expects. TWapSQLConnection is constructed with a const WapDbBridgeDriver() injected.
Enums
- TCommitRollbackAction
- What happens to open datasets on commit or rollback.
- TConnInfoType
- Kind of information requested about a connection.
- TConnOption
- Capabilities of a connection type.
- TDBEventType
- Kind of event written to a connection's log.
- TSchemaType
- Kind of schema information requested from a connection.
- TSQLConnectionOption
- Options of a TSQLConnection.
- TSQLQueryOption
- Options of a TSQLQuery.
- TSQLSequenceApplyEvent
- When a TSQLSequence assigns its next value.
- TSQLTransactionOption
- Options of a TSQLTransaction.
- TStatementType
- Kind of SQL statement: select, insert, update, delete….
Extensions
Constants
- backtickQuotes → const TQuoteChars
- cpNONE → const int
- defaultMacroChar → const String
- doubleQuotes → const TQuoteChars
- kWapSqlLog → const bool
- The HTTP client for the backend gateway. The SQL diagnostic-output switch. Set to true while debugging save issues, and every SQL statement sent, with its parameters, is printed to the console. Recommended to leave off normally, to avoid excessive output.
- logAllEvents → const TDBEventTypes
- logAllEventsExtra → const TDBEventTypes
- singleQuotes → const TQuoteChars
- statementTokens → const TQuoteChars
- tSchemaObjectNames → const TQuoteChars
Properties
- globalDBLogHook ↔ TDBLogNotifyEvent?
-
getter/setter pair
Functions
-
defaultSQLFormatSettings(
) → TFormatSettings -
doneDefs(
) → void -
getConnectionDef(
String connectorName) → TConnectionDef? -
getConnectionList(
TStrings list) → void -
quotedStr(
String s) → String -
registerConnection(
TConnectionDefClass def) → void -
timeIntervalToString(
DateTime time) → String -
unRegisterConnection(
String connectionName) → void -
unRegisterConnectionDef(
TConnectionDefClass def) → void
Typedefs
- PBufBlobField = TBufBlobField
- TConnectionDefClass = TConnectionDef Function()
-
TConnOptions
= Set<
TConnOption> -
TDBEventTypes
= Set<
TDBEventType> - TDBLogNotifyEvent = void Function(TSQLConnection sender, TDBEventType eventType, String msg)
- TFieldDefsClass = TFieldDefs Function(TDataSet? aDataSet)
- TLibraryLoadFunction = int Function(String s)
- TLibraryUnLoadFunction = void Function()
-
TQuoteChars
= List<
String> - TRowsCount = int
- TSQLConnectionClass = TSQLConnection Function(TComponent? aOwner)
-
TSQLConnectionOptions
= Set<
TSQLConnectionOption> -
TSQLQueryOptions
= Set<
TSQLQueryOption> - TSQLScriptDirectiveEvent = void Function(Object sender, String directive, String argument, TBoolRef stopExecution)
- TSQLScriptExceptionEvent = void Function(Object sender, TStrings theStatement, Object theException, TBoolRef continueExecution)
-
TSQLTransactionOptions
= Set<
TSQLTransactionOption>
Exceptions / Errors
- ESQLDatabaseError
- An EDatabaseError reported by the database server.