Qore MssqlSqlUtilBase Module Reference 1.0
Loading...
Searching...
No Matches
MssqlSqlUtilBase::MssqlDatabase Class Reference

provides the Mssql-specific implementation of the AbstractDatabase interface More...

#include <MssqlSqlUtilBase.qm.dox.h>

Inheritance diagram for MssqlSqlUtilBase::MssqlDatabase:
[legend]

Public Member Methods

int getMaximumPrecision ()
 Returns the maximum precision for numeric or decimal columns. More...
 
bool requiresScale ()
 Returns True if the driver requires a scale to support decimal values in numeric or decimal columns. More...
 

Static Public Member Methods

static string getCreateSql (list l)
 returns a string that can be used to create the schema in the database
 
static bool isSybase (AbstractDatasource ds)
 returns True if the DB is a Sybase database
 
static auto tryExecArgs (AbstractDatasource ds, string sql, *softlist< auto > args)
 tries to execute a command so that if an error occurs the current transaction status is not lost
 
static auto tryExecRaw (AbstractDatasource ds, string sql)
 tries to execute a command so that if an error occurs the current transaction status is not lost
 

Public Attributes

string default_schema = "dbo"
 default schema for user
 
bool is_sybase
 sybase flag
 
const MaxPrecision = 38
 Maximum precision.
 
const MssqlReclaimSpaceOptions = ReclaimSpaceOptions
 Options for reclaimSpace()
 
const MssqlReservedWords = ...
 hash of reserved words
 
const MssqlSchemaDescriptionOptions = AbstractDatabase::SchemaDescriptionOptions
 Mssql-specific schema description keys.
 

Private Member Methods

 computeStatisticsImpl (*hash options)
 compute statistics implementation. See SqlUtil::AbstractDatabase::computeStatistics()
 
string getCreateSqlImpl (list l)
 returns a string that can be used to create the schema in the database
 
softint getCurrentSequenceValueImpl (string name)
 returns the last value issued for the given sequence in the current session
 
softint getNextSequenceValueImpl (string name)
 returns the next value in the given sequence
 
int getPhysicalSizeImpl ()
 SqlUtil::AbstractDatabase::getPhysicalSize()
 
hash getReclaimSpaceOptions ()
 returns driver-specific options to the base abstract class
 
hash getSchemaDescriptionOptions ()
 returns driver-specific options to the base abstract class
 
list< string > listFunctionsImpl ()
 returns a list of string function names in the database More...
 
list< string > listProceduresImpl ()
 since Mssql only supports functions, this method is identical to listFunctionsImpl() More...
 
softlist< string > listTablesImpl ()
 returns a list of string table names in the database
 
bool rebuildIndexImpl (string name, *hash options)
 rebuild index implementation. See SqlUtil::AbstractDatabase::rebuildIndex()
 
 reclaimSpaceImpl (*hash options)
 reclaim space implementation. See SqlUtil::AbstractDatabase::reclaimSpace()
 
bool supportsPackagesImpl ()
 returns True if the database supports packages
 
bool supportsSequencesImpl ()
 returns True if the database supports sequences
 
bool supportsTypesImpl ()
 returns True if the database supports named types
 
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
 

Detailed Description

provides the Mssql-specific implementation of the AbstractDatabase interface

Member Function Documentation

◆ getMaximumPrecision()

int MssqlSqlUtilBase::MssqlDatabase::getMaximumPrecision ( )

Returns the maximum precision for numeric or decimal columns.

Returns
-1 means, no maximum
Since
FreeSqlUtil 1.4.2

◆ listFunctionsImpl()

list< string > MssqlSqlUtilBase::MssqlDatabase::listFunctionsImpl ( )
private

returns a list of string function names in the database

The function names will include arguments in parentheses after the names

Returns
a list of string function names in the database

◆ listProceduresImpl()

list< string > MssqlSqlUtilBase::MssqlDatabase::listProceduresImpl ( )
private

since Mssql only supports functions, this method is identical to listFunctionsImpl()

See also
listFunctionsImpl()

◆ requiresScale()

bool MssqlSqlUtilBase::MssqlDatabase::requiresScale ( )

Returns True if the driver requires a scale to support decimal values in numeric or decimal columns.

Returns
True if the driver requires a scale to support decimal values in numeric or decimal columns
Since
FreeSqlUtil 1.4.2