TSqlDatabase

Abstract base class for connections to databases that can be queried using SQL statements.

Inheritance

Level	Ancestor	Description
1	TObject	Ultimate ancestor in a class hierarchy
2	TSqlStatementExecutor	Abstract base class for a facility that executes a `TSqlStatement`
3	TSqlDatabase

Source

Sql.Database.pas (43)

Description

A TSqlDatabase instance represents a connection to one specific database in a Database Management System (DBMS). The database can be queried using Query which accepts a TSqlStatement. A TSqlDatabase seldomly is instantiated directly. Usually it is constructed by a TSqlDatabaseConnector which also performs the necessary initialization, finalization and embellishment of the database connection.

Methods

Scope	Visibility	Result	Name	Description
Instance	protected	TSqlConnectionSettings	GetConnectionSettings()
Instance	protected	TBoolean	GetCouldConnect()
Instance	public		Execute(Statement: TSqlStatement)
Instance	public		Flush()
Instance	public	TSqlResult	Query(Statement: TSqlStatement; ResultMethod: TSqlQueryResultMethod)	Executes `Statement` and returns its `TSqlResult` if any, `nil` otherwise.
Instance	public	TSqlResult	QuerySingleRow(Statement: TSqlStatement)	Executes `Statement` and returns its `TSqlResult` while ensuring exactly one row is in the result.
Instance	public	TSqlPreparedStatement	Prepare(Statement: TSqlStatement)
Instance	public	TSqlTransaction	StartTransaction()
Instance	public		EndTransaction(Transaction: TSqlTransaction)
Instance	public	TInteger	ConnectionIdentifier()
Instance	public	TInteger	InsertId()
Instance	public	TInteger	NumberOfAffectedRows()
Instance	public	TInteger	Insert(Statement: TSqlStatement)
Instance	public	TBoolean	Exists(Statement: TSqlResultSetStatement)
Instance	public	TInteger	SelectOrInsert(Table: TObject; Columns: array of TSqlTableColumn; Row: TSqlRow)
Instance	public	TDecimal	SelectDecimal(Statement: TSqlResultSetStatement)
Instance	public	TDecimal	SelectDecimalWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TDecimal)
Instance	public	TInteger	SelectInteger(Statement: TSqlResultSetStatement)
Instance	public	TInteger	SelectIntegerWithDefault(Statement: TSqlResultSetStatement)
Instance	public	TInteger	SelectIntegerWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TInteger)
Instance	public	TText	SelectText(Statement: TSqlResultSetStatement)
Instance	public	TText	SelectTextWithDefault(Statement: TSqlResultSetStatement)
Instance	public	TText	SelectTextWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TText)
Instance	public	TBoolean	SelectBoolean(Statement: TSqlResultSetStatement)
Instance	public	TBoolean	SelectBooleanWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TBoolean)
Instance	public	TFloatingPoint64	SelectFloatingPoint(Statement: TSqlResultSetStatement)
Instance	public	TFloatingPoint64	SelectFloatingPointWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TFloatingPoint64)
Instance	public	TGregorianDate	SelectDate(Statement: TSqlResultSetStatement)
Instance	public	TGregorianInstant	SelectInstant(Statement: TSqlResultSetStatement)
Instance	public	TRgbColor	SelectColor(Statement: TSqlResultSetStatement)
Instance	public	TRgbColor	SelectColorWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TRgbColor)
Instance	public	TUuid	SelectUuid(Statement: TSqlResultSetStatement)
Instance	public	TUuid	SelectUuidWithDefault(Statement: TSqlResultSetStatement; DefaultValue: TUuid)
Instance	public	TInputStream	SelectStream(Statement: TSqlStatement)
Instance	public	TBoolean	IsAlive()
Instance	public	TPositiveInteger32	IdleTime()
Instance	public	TBoolean	UserExists(Name: TText)
Instance	public	TBoolean	TableExists(Name: TText)
Instance	public	TBoolean	TableHasConstraint(Table: TText; Constraint: TText)
Instance	public	TObject	CreateTableDefinition(SchemaName: TText; TableName: TText)
Instance	public	TObject	GetSystemInformation()
Instance	public	TSqlDatabase	Embellish()