cSQLConfig.h

Go to the documentation of this file.

//
//
 
#ifndef _INC_cSQLConfig_H
#define _INC_cSQLConfig_H
#ifndef NO_PRAGMA_ONCE
#pragma once
#endif
 
#include "../GrayLibBase.h"
#include "../Variant/cVariantType.h"
#include "GrayCore/include/cString.h"
#include "GrayCore/include/cIniMap.h"
 
namespace GrayLib
{
        typedef INT16 SQL_TYPE_t;               
        static const SQL_TYPE_t k_SQL_TYPE_NULL = 0;
 
#ifdef _WIN64
        typedef UINT64 SQL_SCALE_t;                     // AKA SQLULEN
#else
        typedef unsigned long SQL_SCALE_t;      // AKA SQLULEN
#endif
 
        struct cSQLColumnInfo
        {
 
                cStringA m_strName;                     
                SQL_TYPE_t m_nSQLType;                  
                SQL_SCALE_t m_nScale;                   
                INT16 m_nPrecision;                             
                bool m_bNullability;                    
 
                VARTYPE_TYPE m_eVarType;                
 
                void SetClear() noexcept
                {
                        m_strName = "";
                        m_nSQLType = 0;
                        m_nScale = 0;
                        m_nPrecision = 0;
                        m_bNullability = false;
                        m_eVarType = VARTYPE_NoType;
                }
        };
 
        class GRAYLIB_LINK cSQLConfigCmd
        {
 
        public:
                enum CMDFLG_TYPE
                {
                        // CMDFLG_ReadOnly = 0x02,              //!< TODO like MFC
                        // CMDFLG_CursorLib = 0x04,     //!< TODO like MFC
                        CMDFLG_MSSQL = 0,               
                        CMDFLG_MySQL = 0x08,                    
                        CMDFLG_DateWrap = 0x10,         
                };
 
        public:
                UINT m_uCmdFlags;       
 
        public:
                cSQLConfigCmd(UINT uCmdFlags = CMDFLG_MSSQL)
                        : m_uCmdFlags(uCmdFlags)
                {
                }
                bool isConvertEscapes() const noexcept
                {
                        return m_uCmdFlags & CMDFLG_MySQL;
                }
                bool isUseLIMITCommand() const noexcept
                {
                        return m_uCmdFlags & CMDFLG_MySQL;
                }
                bool isDateWrap() const noexcept
                {
                        // Allow {ts'X'} wrapper for the date.
                        return m_uCmdFlags & CMDFLG_DateWrap;
                }
 
                cStringA GetSQLTypeName(const cSQLColumnInfo& f) const;
                bool ConvertEscapeQuotes(cStringA& a_cs) const;
        };
 
        class GRAYLIB_LINK cSQLConfigDB : public cSQLConfigCmd
        {
 
        public:
                bool m_bPopulated;                              
                bool m_bAutoCommit;
                bool m_bSupportsTransactions;   
                cStringA m_sDatabaseName;               
                cStringA m_sDataSourceName;     
 
        public:
                cSQLConfigDB()
                        : m_bPopulated(false)
                        , m_bAutoCommit(true)
                        , m_bSupportsTransactions(true)
                {
                }
 
                void Clear()
                {
                        m_bPopulated = false;
                        m_bAutoCommit = true;
                        m_sDatabaseName.Empty(); // reset at each open
                        m_sDataSourceName.Empty();
                }
 
                cStringA get_DatabaseName() const
                {
                        if (m_sDatabaseName.IsEmpty())
                        {
                                return "Database";
                        }
                        return m_sDatabaseName;
                }
                cStringA get_DataSourceName() const
                {
                        if (m_sDataSourceName.IsEmpty()) // not using a DSN is OK.
                        {
                                return get_DatabaseName();
                        }
                        return m_sDataSourceName;
                }
 
                bool get_SupportsTransactions() const
                {
                        return m_bSupportsTransactions;
                }
 
                bool get_AutoCommit() const
                {
                        return m_bAutoCommit;
                }
                void put_AutoCommit(bool bAutoCommit) // makes all transactions COMMIT immediately
                {
                        m_bAutoCommit = bAutoCommit;
                }
        };
}
 
#endif