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
|
//////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////
//
// copyright : (C) 2014 Eran Ifrah
// file name : MySqlDbAdapter.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 MYSQLDBADAPTER_H
#define MYSQLDBADAPTER_H
#ifdef DBL_USE_MYSQL
#include <wx/dblayer/include/MysqlDatabaseLayer.h>
#endif
#include <wx/dblayer/include/DatabaseLayer.h>
#include <wx/dynarray.h>
#include "IDbAdapter.h" // Base class: IDbAdapter
#include "IDbType.h"
#include "MySqlType.h"
class MySqlDbAdapter : public IDbAdapter {
public:
MySqlDbAdapter();
MySqlDbAdapter(const wxString& serverName, const wxString& userName, const wxString& password);
~MySqlDbAdapter();
virtual bool GetColumns(Table* pTab);
virtual void GetDatabases(DbConnection* dbCon);
virtual void GetTables(Database* db, bool includeViews);
virtual void GetViews(Database* db);
virtual IDbAdapter* Clone();
virtual bool CanConnect();
virtual bool IsConnected();
virtual void CloseConnection();
virtual DatabaseLayerPtr GetDatabaseLayer(const wxString& dbName);
virtual wxString GetUseDb(const wxString& dbName);
virtual wxString GetDefaultSelect(const wxString& dbName, const wxString& tableName);
virtual wxString GetDefaultSelect(const wxString& cols, const wxString& dbName, const wxString& tableName);
virtual wxString GetCreateTableSql(Table* tab, bool dropTable);
virtual wxString GetCreateViewSql(View* view, bool dropView);
virtual wxString GetAlterTableConstraintSql(Table* tab);
virtual wxString GetCreateDatabaseSql(const wxString& dbName);
virtual wxString GetDropTableSql(Table* pTab);
virtual wxString GetDropViewSql(View* pView);
virtual wxString GetDropDatabaseSql(Database* pDb);
virtual IDbType* GetDbTypeByName(const wxString& typeName);
virtual wxArrayString* GetDbTypes();
virtual IDbType* GetDbTypeByUniversalName(IDbType::UNIVERSAL_TYPE type);
virtual void ConvertTable(Table* pTab);
virtual IDbType* ConvertType(IDbType* pType);
protected:
IDbType* parseTypeString(const wxString& typeString);
wxString m_serverName;
wxString m_userName;
wxString m_password;
DatabaseLayer* m_pDbLayer;
};
#endif // MYSQLDBADAPTER_H
|
