provides the FreeTDS-specific implementation of the SqlUtil::AbstractTable interface More...

Inheritance diagram for FreetdsSqlUtil::FreetdsTable:

Public Member Methods
string	getColumnSqlName (string col)
	returns the column name for use in SQL strings; subclasses can return a special string in case the column name is a reserved word

list	getColumnSqlNames (softlist cols)
	returns a list of column names for use in SQL strings; subclasses can process the argument list in case a column name is a reserved word

string	getSchemaName ()
	returns the schema name

string	getSqlName ()
	returns the name of the table to be used in SQL (with a possible qualifiers for schema, etc)

*string	getTablespaceName ()
	returns the data filegroup name for the table or NOTHING if none is known

code	getUpsertClosure (hash< auto > row, int upsert_strategy=UpsertAuto, *hash opt)
	returns a closure for performing upserts; if the underlying dataserver supports an optimized `MERGE` statement (Microsoft SQL Server 2008+), the upsert_strategy argument is ignored and a closure using a merge statement is returned, otherwise the standard upsert closure is returned according to SqlUtil::AbstractTable::getUpsertClosure()

bool	hasArrayBind ()
	returns False because the freetds driver does not support array binds / bulk DML operations

Public Attributes
const	FreetdsCopMap = ...
	column operator specializations for FreeTDS

const	FreetdsIopMap = ...
	a hash of default value operator descriptions for FreeTDS

const	FreetdsOpMap = ...
	where operator specializations for FreeTDS

const	FreetdsSelectOptions = ...
	select options supported by FreetdsSqlUtil

const	FreetdsTableDescriptionHashOptions = AbstractTable::TableDescriptionHashOptions
	equal to SqlUtil::AbstractTable::TableDescriptionHashOptions

const	FreetdsTruncDate = ...
	Map SqlUtil::cop_trunc_date() constants to FreeTDS internal masks.

const	FreetdsTypeMap = ...
	maps postgresql type names to type configurations

const	FreetdsUopMap = ...
	a hash of default update operator definitions for FreeTDS

bool	is_sybase
	sybase flag

const	MsQoreTypeMap = ...
	maps qore type names to MS SQL Server type names

const	MsSqlServerTableHints = ...
	query hints

const	QoreTypeMap = ...
	maps qore type names to DB type names

bool	ss_has_merge = False
	"has merge" flag for SQL server

bool	ss_has_sequences = False
	"has sequences" flag for SQL server

const	SybaseQoreTypeMap = QoreTypeMap
	maps qore type names to Sybase/SAP type names

Private Member Methods
	clearImpl ()
	clears FreeTDS-specific table information

bool	constraintsLinkedToIndexesImpl ()
	returns True if the database links constraints to indexes (ie dropping the constraint drops the index, etc)

	copyImpl (AbstractTable old)
	db-specific copy actions

	doSelectLimitOnlyUnlockedImpl (reference< string > sql, reference< list > args, *hash qh)
	processes a string for use in SQL select statements when there is a "limit" argument, but no "orderby" or "offset" arguments

	doSelectOrderByWithOffsetSqlUnlockedImpl (reference< string > sql, reference< list > args, hash qh, hash jch, hash ch, hash psch, list coll)
	processes a string for use in SQL select statements when there is an "order by" and "offset" argument

hash	getColumnOperatorMapImpl ()
	returns the column operator map for this object

string	getCreateSqlImpl (list l)
	returns a string that can be used to create the table in the database

string	getCreateTableSqlImpl (*hash opt)
	returns a string that can be used to create the table in the database

hash	getInsertOperatorMap ()
	returns the insert operator map for this object

AbstractDataProviderType	getNumericTypeImpl (string native_type, bool nullable, *hash< auto > options)
	returns the type for number / numeric columns for the database so that data conversions can be handled properly

hash	getRawUpdateOperatorMap ()
	returns the raw (default) update operator map for this object

AbstractSavepointHelper	getSavepointHelperImpl (*string savepoint)
	get DB-specific savepoint helper More...

hash	getSelectOptions ()
	returns the select options for this driver

*string	getSqlValueImpl (auto v)
	returns a string for use in SQL queries representing the DB-specific value of the argument; returns NOTHING if the type cannot be converted to an SQL string

hash	getWhereOperatorMap ()
	returns the "where" operator map for this object

bool	supportsTablespacesImpl ()
	returns True if the database support tablespaces

auto	tryExecArgsImpl (string sql, *softlist< auto > args)
	tries to execute a command so that if an error occurs the current transaction status is not lost

auto	tryExecRawImpl (string sql, *softlist< auto > args)
	tries to execute a command so that if an error occurs the current transaction status is not lost

bool	uniqueIndexCreatesConstraintImpl ()
	returns True if the database automatically creates a unique constraint when a unique index is created (ex: mysql)

Private Attributes
string	default_schema = "dbo"
	the default schema for the user

*string	filegroup
	filegroup name for the table, if known

string	schema
	schema name for the table

Functions	triggerFunctions
	contains any trigger functions supporting triggers on the table

Detailed Description

provides the FreeTDS-specific implementation of the SqlUtil::AbstractTable interface

Member Function Documentation

◆ getSavepointHelperImpl()

AbstractSavepointHelper FreetdsSqlUtil::FreetdsTable::getSavepointHelperImpl ( *string savepoint )

privatevirtual

get DB-specific savepoint helper

Parameters

savepoint the savepoint string, if not given a unique savepoint string will be generated

Since: SqlUtil 1.6

Implements SqlUtil::AbstractTable.

Public Member Methods

Public Attributes

Private Member Methods

Private Attributes

Detailed Description

Member Function Documentation

◆ getSavepointHelperImpl()