1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
//////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////
//
// copyright : (C) 2014 The CodeLite Team
// file name : IDbAdapter.h
//
// -------------------------------------------------------------------------
// A
// _____ _ _ _ _
// / __ \ | | | | (_) |
// | / \/ ___ __| | ___| | _| |_ ___
// | | / _ \ / _ |/ _ \ | | | __/ _ )
// | \__/\ (_) | (_| | __/ |___| | || __/
// \____/\___/ \__,_|\___\_____/_|\__\___|
//
// F i l e
//
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
//
//////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////
#ifndef IDBADAPTER_H
#define IDBADAPTER_H
#include <wx/wx.h>
#include "smart_ptr.h"
#include <wx/dynarray.h>
#include <wx/dblayer/include/DatabaseLayer.h>
#include "IDbType.h"
//#include "columncol.h"
//#include "tablecol.h"
//#include "databasecol.h"
class DbConnection;
class Database;
class Table;
class View;
class IDbType;
typedef SmartPtr<DatabaseLayer> DatabaseLayerPtr;
/*! \brief Basic virtual class for creating universal interface between different database servers. */
class IDbAdapter
{
public:
enum TYPE {
atUNKNOWN = 0,
atSQLITE,
atMYSQL,
atPOSTGRES
};
IDbAdapter() {}
virtual ~IDbAdapter() {}
/*! \brief Return opened DatabaseLayer for selected database. If dbName is empty, DatabaseLayer will be opend without defalut database. */
virtual DatabaseLayerPtr GetDatabaseLayer(const wxString& dbName) = 0;
/*! \brief Return true if dbAdapter is connected. DEPRECATED!!! */
virtual bool IsConnected() = 0;
/*! \brief Clone DbAdapter and return new object */
virtual IDbAdapter* Clone() = 0;
/*! \brief Return true if adapter settings are set and adapter can connect to the database */
virtual bool CanConnect() = 0;
/*! \brief Function connect databases to the DbConnection */
virtual void GetDatabases(DbConnection* dbCon) = 0;
/*! \brief Function connect tables to the Database */
virtual void GetTables(Database* db, bool includeViews) = 0;
/*! \brief Function connect views to the Database */
virtual void GetViews(Database* db) = 0;
/*! \brief Function connect columns to the DBETable */
virtual bool GetColumns(Table* pTab) = 0;
/*! \brief Return wxString with USE DB statement for dbName */
virtual wxString GetUseDb(const wxString& dbName) = 0;
/*! \brief Return wxString with defalut SELECT for defined table and db */
virtual wxString GetDefaultSelect(const wxString& dbName, const wxString& tableName) = 0;
virtual wxString GetDefaultSelect(const wxString& cols, const wxString& dbName, const wxString& tableName) = 0;
/*! \brief Return Create table sql statement */
virtual wxString GetCreateTableSql(Table* tab, bool dropTable) = 0;
/*! \brief Return Create view sql statement */
virtual wxString GetCreateViewSql(View* view, bool dropView) = 0;
/*! \brief Return Create update table SQL statement for adding constraints */
virtual wxString GetAlterTableConstraintSql(Table* tab) = 0;
/*! \brief Return Create database SQL statement. */
virtual wxString GetCreateDatabaseSql(const wxString& dbName) = 0;
/*! \brief Return Drop table SQL statement. */
virtual wxString GetDropTableSql(Table* pTab) = 0;
/*! \brief Return Drop view SQL statement. */
virtual wxString GetDropViewSql(View* pView) = 0;
/*! \brief Return Drop database SQL statement. */
virtual wxString GetDropDatabaseSql(Database* pDb) = 0;
virtual void CloseConnection() = 0;
/*! \brief Return IDbType by name string */
virtual IDbType* GetDbTypeByName(const wxString& typeName) = 0;
/*! \brief Return IDbType by name universal name */
virtual IDbType* GetDbTypeByUniversalName(IDbType::UNIVERSAL_TYPE type) = 0;
/*! \brief Return wxArrayString of possible db types */
virtual wxArrayString* GetDbTypes () = 0;
/*! \brief Convert IDbType to the special db type. (!!! Old type is deleted !!!) */
virtual IDbType* ConvertType (IDbType* pType) = 0;
/*! \brief Return wxArrayString of possible db types */
virtual void ConvertTable(Table* pTab) = 0;
const TYPE& GetAdapterType() const {
return m_adapterType;
}
protected:
TYPE m_adapterType;
};
#endif // IDBADAPTER_H
|
