GrayLib::cSQLConfigCmd Class Reference

#include <cSQLConfig.h>

Inheritance diagram for GrayLib::cSQLConfigCmd:

Public Types
enum	CMDFLG_TYPE { CMDFLG_MSSQL = 0 , CMDFLG_MySQL = 0x08 , CMDFLG_DateWrap = 0x10 }

Public Member Functions
	cSQLConfigCmd (UINT uCmdFlags=CMDFLG_MSSQL)
bool	isConvertEscapes () const noexcept
bool	isUseLIMITCommand () const noexcept
bool	isDateWrap () const noexcept
cStringA	GetSQLTypeName (const cSQLColumnInfo &f) const
bool	ConvertEscapeQuotes (cStringA &a_cs) const

Public Attributes
UINT	m_uCmdFlags
	These flags effect how a command might be built. options supported (or not) by drivers. More...

Detailed Description

What type of relational DB is this ? e.g. SQLite, MySQL, MSSQL, Excel, etc. (maybe Oracle, PostgreSQL, HSQLDB, Presto, Impala) What SQL commands are allowed by the target database connection? How to code them. https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

Member Enumeration Documentation

CMDFLG_TYPE

enum GrayLib::cSQLConfigCmd::CMDFLG_TYPE

Config flags for the db connection.

Enumerator
CMDFLG_MSSQL	default to a SQL style that works for M$SQL
CMDFLG_MySQL	Use MySQL/SQLite style extensions else M$SQL or Oracle ?
CMDFLG_DateWrap	Allow {ts'X'} wrapper for the date.

Constructor & Destructor Documentation

cSQLConfigCmd()

GrayLib::cSQLConfigCmd::cSQLConfigCmd ( UINT  uCmdFlags = CMDFLG_MSSQL )

inline

Member Function Documentation

ConvertEscapeQuotes()

bool GrayLib::cSQLConfigCmd::ConvertEscapeQuotes

(

cStringA &

a_cs

)

const

Convert quotes based on what db I'm attached to.

Note

look for any chars out of range ?!!!

GetSQLTypeName()

cStringA GrayLib::cSQLConfigCmd::GetSQLTypeName

(

const cSQLColumnInfo &

f

)

const

Get the type name from the ColumnInfo

Returns

a SQL type string from the cSQLColumnInfo.

isConvertEscapes()

bool GrayLib::cSQLConfigCmd::isConvertEscapes ( ) const

inlinenoexcept

I need to convert escapes manually?

Returns

true = MySQL/SQLite, false = MSSQL (does it for me)

isDateWrap()

bool GrayLib::cSQLConfigCmd::isDateWrap ( ) const

inlinenoexcept

isUseLIMITCommand()

bool GrayLib::cSQLConfigCmd::isUseLIMITCommand ( ) const

inlinenoexcept

Returns

true = MySQL/SQLite, false = MSSQL (has 'TOP' command)

Member Data Documentation

m_uCmdFlags

UINT GrayLib::cSQLConfigCmd::m_uCmdFlags

These flags effect how a command might be built. options supported (or not) by drivers.

---

The documentation for this class was generated from the following files:

• c:/Dennis/Source/Gray/GrayLib/include/Sql/cSQLConfig.h
• c:/Dennis/Source/Gray/GrayLib/src/Sql/cSQLConfig.cpp