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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
|
/*---------------------------------------------------------------------------*/
/* Logiciel de gestion de fichier de base de donnesSQLite */
/*---------------------------------------------------------------------------*/
/* Projet : wxSQLitePlus Version : 0.3.0.0 */
/* Fichier : sqlite3table.h */
/* Auteur : Fred Cailleau-Lepetit Date : 07/07/2007 */
/* email : softinthebox@free.fr Rvision : 07/03/2009 */
/*---------------------------------------------------------------------------*/
/* Copyright (C) Fred Cailleau-Lepetit 2007-2008 */
/* Licence GNU General Public License http://www.fsf.org/copyleft/gpl.html */
/*---------------------------------------------------------------------------*/
/*
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 (version 3).
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
Ce programme est libre, vous pouvez le redistribuer et/ou le modifier
selon les termes de la Licence Publique Gnrale GNU publie par la
Free Software Foundation (version 3).
Ce programme est distribu car potentiellement utile, mais
SANS AUCUNE GARANTIE, ni explicite ni implicite, y compris
les garanties de commercialisation ou d'adaptation dans un but
spcifique. Reportez-vous la Licence Publique Gnrale GNU
pour plus de dtails.
*/
#ifndef _SQLITE3TABLE_H_
#define _SQLITE3TABLE_H_
#if defined(__GNUG__) && !defined(NO_GCC_PRAGMA)
#pragma interface "sqlite3table.h"
#endif
/*---------------------------------------------------------------------------*/
#include <wx/wxsqlite3.h>
#include <wx/grid.h>
#include <wx/dynarray.h>
/*---------------------------------------------------------------------------*/
#ifdef WXMAKINGDLL_WXSQLITE3TABLE
#define WXDLLIMPEXP_SQLITE3TABLE WXEXPORT
#elif defined(WXUSINGDLL_WXSQLITE3TABLE)
#define WXDLLIMPEXP_SQLITE3TABLE WXIMPORT
#else // not making nor using DLL
#define WXDLLIMPEXP_SQLITE3TABLE
#endif
/*---------------------------------------------------------------------------*/
class wxSQLite3TableColumn;
WX_DEFINE_ARRAY(wxSQLite3TableColumn*, wxArraySQLite3TableColumn);
/*---------------------------------------------------------------------------*/
class SQLite3HookForCount : public wxSQLite3Hook
{
public:
virtual void UpdateCallback(wxUpdateType type,
const wxString& database,
const wxString& table,
wxLongLong rowid)
{
wxUnusedVar(database);
wxUnusedVar(table);
wxUnusedVar(rowid);
switch (type)
{
case SQLITE_DELETE:
m_NbRowDeleted++;
break;
case SQLITE_INSERT:
m_NbRowInserted++;
break;
case SQLITE_UPDATE:
m_NbRowUpdated++;
break;
}
}
void Clear()
{
m_NbRowUpdated = m_NbRowDeleted = m_NbRowInserted = 0;
}
int GetNbRowUpdated(){return m_NbRowUpdated;}
int GetNbRowDeleted(){return m_NbRowDeleted;}
int GetNbRowInserted(){return m_NbRowInserted;}
private:
int m_NbRowUpdated;
int m_NbRowDeleted;
int m_NbRowInserted;
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE OddRowsGridCellAttrProvider : public wxGridCellAttrProvider
{
public:
OddRowsGridCellAttrProvider(wxColour colour);
virtual ~OddRowsGridCellAttrProvider();
virtual wxGridCellAttr *GetAttr(int row, int col,
wxGridCellAttr::wxAttrKind kind) const;
private:
wxGridCellAttr *m_attrForOddRows;
wxColour m_OddColour;
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE wxGridEmptyTable : public wxGridTableBase
{
public:
wxGridEmptyTable(){}
int GetNumberRows(){return 0;}
int GetNumberCols(){return 0;}
wxString GetValue(int WXUNUSED(row), int WXUNUSED(col)) {return wxEmptyString;}
void SetValue(int , int , const wxString&) { /* ignore */ }
bool IsEmptyCell(int , int) {return true;}
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE wxGridSQLite3TableBase : public wxGridTableBase
{
public:
wxGridSQLite3TableBase();
virtual ~wxGridSQLite3TableBase();
virtual int GetNumberRows() {return m_NumberRows;}
virtual int GetNumberCols() {return m_NumberCols;}
virtual bool IsEmptyCell(int row, int col);
virtual wxString GetValue(int row, int col);
virtual void SetValue(int row, int col, const wxString& value);
virtual wxString GetColLabelValue(int col);
virtual wxString GetTypeName(int row, int col);
virtual void SetView(wxGrid* grid);
void AdaptColumnsSize();
void SetFloatWidth(int value){m_FloatWidth = value;}
int GetFloatWidth() const {return m_FloatWidth;}
void SetFloatPrecision(int value){m_FloatPrecision = value;}
int GetFloatPrecision() const {return m_FloatPrecision;}
protected:
void Init();
int m_CharWidth;
int m_NumberRows;
int m_NumberCols;
int m_FloatWidth;
int m_FloatPrecision;
wxArraySQLite3TableColumn m_ArrayColumn;
virtual void PopulateArray(wxSQLite3ResultSet* resultSet);
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE wxGridSQLite3Table : public wxGridSQLite3TableBase
{
public:
wxGridSQLite3Table(wxSQLite3ResultSet* resultSet);
wxGridSQLite3Table(wxSQLite3Database* db, const wxString& tablename,
const wxString& base = wxEmptyString);
bool GetBlob(size_t row, size_t col, wxMemoryBuffer*& buffer);
protected:
wxString m_TableName;
wxSQLite3ResultSet GetResultSet(wxSQLite3Database* db,
const wxString& base = wxEmptyString);
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE wxGridTblIndexesTable : public wxGridSQLite3TableBase
{
public:
wxGridTblIndexesTable(wxSQLite3Database* db, const wxString& tablename,
const wxString& base = wxEmptyString);
virtual wxString GetTypeName(int row, int col);
virtual wxString GetValue(int row, int col);
protected:
wxSQLite3ResultSet GetResultSet(wxSQLite3Database* db,
const wxString& tablename,
const wxString& base = wxEmptyString);
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE wxGridTblColumnsTable : public wxGridSQLite3TableBase
{
public:
wxGridTblColumnsTable(wxSQLite3Database* db, const wxString& tablename,
const wxString& base = wxEmptyString);
virtual wxString GetTypeName(int row, int col);
virtual wxString GetValue(int row, int col);
protected:
wxSQLite3ResultSet GetResultSet(wxSQLite3Database* db,
const wxString& tablename,
const wxString& base = wxEmptyString);
};
/*---------------------------------------------------------------------------*/
class WXDLLIMPEXP_SQLITE3TABLE wxGridTriggerTable : public wxGridSQLite3TableBase
{
public:
wxGridTriggerTable(wxSQLite3Database* db, const wxString& tablename,
const wxString& base = wxEmptyString);
protected:
virtual void PopulateArray(wxSQLite3ResultSet* resultSet);
wxSQLite3ResultSet GetResultSet(wxSQLite3Database* db,
const wxString& tablename,
const wxString& base = wxEmptyString);
};
/*---------------------------------------------------------------------------*/
extern wxGridEmptyTable g_EmptyTable;
/*---------------------------------------------------------------------------*/
#endif // _SQLITE3TABLE_H_
|
