MSSQLDatabase.h

Go to the documentation of this file.

#pragma once

namespace AppSecInc
{
        namespace Databases
        {
                namespace MSSQL
                {
            class MSSQLDatabase : public AppSecInc::Databases::ODBC::ODBCDatabase
                        {
            private:
                std::list<MSSQLDatabaseFileSpec> _filespecs;
                std::list<std::wstring> _database_options;
                std::wstring _database_collate;
                std::wstring _database_purpose;
                AppSecInc::Databases::ODBC::ODBCConnection _connection;
                std::wstring _connection_string;
                std::wstring _database_name;
                MSSQLDatabase& operator=(const MSSQLDatabase&);
            public:
                const std::wstring GetName() const { return _database_name; }
                void SetName(const std::wstring& value) { _database_name = value; }
                const std::wstring GetCollate() const { return _database_collate; }
                void SetCollate(const std::wstring& value) { _database_collate = value; }
                const std::wstring GetPurpose() const { return _database_purpose; }
                void SetPurpose(const std::wstring& value) { _database_purpose = value; }
                const std::list<MSSQLDatabaseFileSpec>& GetFileSpecs() const { return _filespecs; }
                void AddFileSpec(const MSSQLDatabaseFileSpec& value) { _filespecs.push_back(value); }
                const std::list<std::wstring>& GetOptions() const { return _database_options; }
                void AddOption(const std::wstring& value) { _database_options.push_back(value); }
                AppSecInc::Databases::ODBC::ODBCConnection& GetConnection() { return _connection; }
                const AppSecInc::Databases::ODBC::ODBCConnection& GetConnection() const { return _connection; }
                        public:
                MSSQLDatabase();
                MSSQLDatabase(const AppSecInc::Databases::ODBC::ODBCConnectionInfo& connectioninfo);
                void Create();
                bool Exists();
                void Connect();
                void Disconnect();
                void Drop();
                void CreateIfNotExists();
                void DropIfExists();
                                ~MSSQLDatabase();
                std::wstring GetCreateQuery() const;
                                std::vector<std::wstring> GetOptionQueries() const;
                std::wstring GetDropQuery() const;
                std::wstring GetExistsQuery() const;
                std::wstring GetNotExistsQuery() const;
                MSXML2::IXMLDOMNodePtr Save(AppSecInc::Xml::XmlDocument& xmldoc, MSXML2::IXMLDOMNodePtr parent) const;
                void Load(AppSecInc::Xml::XmlDocument& xmldoc, MSXML2::IXMLDOMNodePtr root);
                        };
                }
        }
}