]> git.saurik.com Git - wxWidgets.git/blob - samples/db/dbtest.h
by default the ctrl accepts keyboard input now (why wouldn't it?)
[wxWidgets.git] / samples / db / dbtest.h
1 ///////////////////////////////////////////////////////////////////////////////
2 // Name: dbtest.h
3 // Purpose: wxWindows database demo app
4 // Author: George Tasker
5 // Modified by:
6 // Created: 1998
7 // RCS-ID: $Id$
8 // Copyright: (c) 1998 Remstar International, Inc.
9 // Licence: wxWindows licence
10 ///////////////////////////////////////////////////////////////////////////////
11
12 #ifdef __GNUG__
13 #pragma interface "dbtest.h"
14 #endif
15
16 #include <wx/string.h>
17 #include <wx/dbtable.h>
18
19 enum DialogModes {mView,mCreate,mEdit,mSearch};
20
21 // ID for the menu quit command
22 #define FILE_CREATE 100
23 #define FILE_EXIT 199
24 #define EDIT_PARAMETERS 200
25 #define ABOUT_DEMO 300
26
27
28 // Name of the table to be created/opened
29 const char CONTACT_TABLE_NAME[] = "contacts";
30
31 // Nuber of columns in the above table
32 const int CONTACT_NO_COLS = 12; // 0-11
33
34 // Global structure for holding ODBC connection information
35 struct DbStuff DbConnectInf;
36
37 enum Language {langENGLISH, langFRENCH, langGERMAN, langSPANISH, langOTHER};
38
39 // Forward class declarations
40 class CeditorDlg;
41 class CparameterDlg;
42
43 #ifdef __WXGTK__
44 const char paramFilename[] = "../database.cfg";
45 #else
46 const char paramFilename[] = "database.cfg";
47 #endif
48
49
50 /*
51 * This class contains the actual data members that are used for transferring
52 * data back and forth from the database to the program.
53 *
54 * NOTE: The object described in this class is just for example purposes, and has no
55 * real meaning other than to show each type of field being used by the database
56 */
57 class CstructContact : public wxObject
58 {
59 public:
60 char Name[ 50+1 ]; // Contact's name
61 char Addr1[ 50+1 ];
62 char Addr2[ 50+1 ];
63 char City[ 25+1 ];
64 char State[ 25+1 ];
65 char PostalCode[ 15+1 ];
66 char Country[ 20+1 ];
67 TIMESTAMP_STRUCT JoinDate; // Date on which this person joined the wxWindows project
68 Language NativeLanguage; // Enumerated type indicating person's native language
69 bool IsDeveloper; // Is this person a developer for wxWindows, or just a subscriber
70 int Contributions; // Something to show off an integer field
71 ULONG LinesOfCode; // Something to show off a 'long' field
72 }; // CstructContact
73
74
75 //
76 // NOTE: Ccontact inherits wxTable, which gives access to all the database functionality
77 //
78 class Ccontact : public wxTable, public CstructContact
79 {
80 private:
81 bool freeDbConn;
82 void SetupColumns();
83
84 public:
85 wxString whereStr;
86 wxString qryWhereStr; // Where string returned from the query dialog
87
88 Ccontact(wxDB *pwxDB=NULL);
89 ~Ccontact();
90
91 void Initialize();
92 bool CreateIndexes(void);
93 bool FetchByName(char *name);
94
95 }; // Ccontact class definition
96
97
98 typedef struct Cparameters
99 {
100 // The length of these strings were arbitrarily picked, and are
101 // dependent on the OS and database engine you will be using.
102 char ODBCSource[100+1];
103 char UserName[25+1];
104 char Password[25+1];
105 } Cparameters;
106
107
108 // Define a new application type
109 class DatabaseDemoApp: public wxApp
110 {
111 public:
112 Cparameters params;
113 bool OnInit();
114 }; // DatabaseDemoApp
115
116 DECLARE_APP(DatabaseDemoApp)
117
118 // Define a new frame type
119 class DatabaseDemoFrame: public wxFrame
120 {
121 private:
122 CeditorDlg *pEditorDlg;
123 CparameterDlg *pParamDlg;
124
125 public:
126 DatabaseDemoFrame(wxFrame *frame, const wxString& title, const wxPoint& pos, const wxSize& sz);
127
128 void OnCloseWindow(wxCloseEvent& event);
129 void OnCreate(wxCommandEvent& event);
130 void OnExit(wxCommandEvent& event);
131 void OnEditParameters(wxCommandEvent& event);
132 void OnAbout(wxCommandEvent& event);
133
134 void CreateDataTable();
135 void BuildEditorDialog();
136 void BuildParameterDialog(wxWindow *parent);
137
138 DECLARE_EVENT_TABLE()
139 }; // DatabaseDemoFrame
140
141
142
143 // *************************** CeditorDlg ***************************
144
145 class CeditorDlg : public wxPanel
146 {
147 private:
148 bool widgetPtrsSet;
149 wxString saveName;
150
151 // Pointers to all widgets on the dialog
152 wxButton *pCreateBtn, *pEditBtn, *pDeleteBtn, *pCopyBtn, *pSaveBtn, *pCancelBtn;
153 wxButton *pPrevBtn, *pNextBtn, *pQueryBtn, *pResetBtn, *pDoneBtn, *pHelpBtn;
154 wxButton *pNameListBtn;
155 wxTextCtrl *pNameTxt, *pAddress1Txt, *pAddress2Txt,*pCityTxt, *pStateTxt, *pCountryTxt,*pPostalCodeTxt;
156 wxStaticText *pNameMsg, *pAddress1Msg, *pAddress2Msg,*pCityMsg, *pStateMsg, *pCountryMsg,*pPostalCodeMsg;
157 wxTextCtrl *pJoinDateTxt,*pContribTxt, *pLinesTxt;
158 wxStaticText *pJoinDateMsg,*pContribMsg, *pLinesMsg;
159 wxRadioBox *pDeveloperRadio;
160 wxChoice *pNativeLangChoice;
161 wxStaticText *pNativeLangMsg;
162
163 public:
164 enum DialogModes mode;
165 Ccontact *Contact; // this is the table object that will be being manipulated
166
167 CeditorDlg(wxWindow *parent);
168 bool OnClose(void);
169 void OnButton( wxCommandEvent &event );
170 void OnCommand(wxWindow& win, wxCommandEvent& event);
171 void OnActivate(bool) {}; // necessary for hot keys
172
173 void FieldsEditable();
174 void SetMode(enum DialogModes m);
175 bool PutData();
176 bool GetData();
177 bool Save();
178 bool GetNextRec();
179 bool GetPrevRec();
180 bool GetRec(char *whereStr);
181
182 DECLARE_EVENT_TABLE()
183 }; // CeditorDlg
184
185 #define EDITOR_DIALOG 199
186
187 // Editor dialog control ids
188 #define EDITOR_DIALOG_FN_GROUP 200
189 #define EDITOR_DIALOG_SEARCH_GROUP 201
190 #define EDITOR_DIALOG_CREATE 202
191 #define EDITOR_DIALOG_EDIT 203
192 #define EDITOR_DIALOG_DELETE 204
193 #define EDITOR_DIALOG_COPY 205
194 #define EDITOR_DIALOG_SAVE 206
195 #define EDITOR_DIALOG_CANCEL 207
196 #define EDITOR_DIALOG_PREV 208
197 #define EDITOR_DIALOG_NEXT 209
198 #define EDITOR_DIALOG_QUERY 211
199 #define EDITOR_DIALOG_RESET 212
200 #define EDITOR_DIALOG_NAME_MSG 213
201 #define EDITOR_DIALOG_NAME_TEXT 214
202 #define EDITOR_DIALOG_LOOKUP 215
203 #define EDITOR_DIALOG_ADDRESS1_MSG 216
204 #define EDITOR_DIALOG_ADDRESS1_TEXT 217
205 #define EDITOR_DIALOG_ADDRESS2_MSG 218
206 #define EDITOR_DIALOG_ADDRESS2_TEXT 219
207 #define EDITOR_DIALOG_CITY_MSG 220
208 #define EDITOR_DIALOG_CITY_TEXT 221
209 #define EDITOR_DIALOG_COUNTRY_MSG 222
210 #define EDITOR_DIALOG_COUNTRY_TEXT 223
211 #define EDITOR_DIALOG_POSTAL_MSG 224
212 #define EDITOR_DIALOG_POSTAL_TEXT 225
213 #define EDITOR_DIALOG_LANG_MSG 226
214 #define EDITOR_DIALOG_LANG_CHOICE 227
215 #define EDITOR_DIALOG_DATE_MSG 228
216 #define EDITOR_DIALOG_DATE_TEXT 229
217 #define EDITOR_DIALOG_CONTRIB_MSG 230
218 #define EDITOR_DIALOG_CONTRIB_TEXT 231
219 #define EDITOR_DIALOG_LINES_MSG 232
220 #define EDITOR_DIALOG_LINES_TEXT 233
221 #define EDITOR_DIALOG_STATE_MSG 234
222 #define EDITOR_DIALOG_STATE_TEXT 235
223 #define EDITOR_DIALOG_DEVELOPER 236
224 #define EDITOR_DIALOG_JOIN_MSG 237
225 #define EDITOR_DIALOG_JOIN_TEXT 238
226
227 // *************************** CparameterDlg ***************************
228
229 class CparameterDlg : public wxDialog
230 {
231 private:
232 bool widgetPtrsSet;
233 enum DialogModes mode;
234 bool saved;
235 Cparameters savedParamSettings;
236
237 // Pointers to all widgets on the dialog
238 wxStaticText *pParamODBCSourceMsg;
239 wxListBox *pParamODBCSourceList;
240 wxStaticText *pParamUserNameMsg, *pParamPasswordMsg;
241 wxTextCtrl *pParamUserNameTxt, *pParamPasswordTxt;
242 wxButton *pParamSaveBtn, *pParamCancelBtn;
243
244 public:
245 CparameterDlg(wxWindow *parent);
246 bool OnClose(void);
247 void OnCommand(wxWindow& win, wxCommandEvent& event);
248 void OnActivate(bool) {}; // necessary for hot keys
249
250 bool PutData();
251 bool GetData();
252 bool Save();
253 void FillDataSourceList();
254
255 }; // CparameterDlg
256
257 #define PARAMETER_DIALOG 400
258
259 // Parameter dialog control ids
260 #define PARAMETER_DIALOG_SOURCE_MSG 401
261 #define PARAMETER_DIALOG_SOURCE_LISTBOX 402
262 #define PARAMETER_DIALOG_NAME_MSG 403
263 #define PARAMETER_DIALOG_NAME_TEXT 404
264 #define PARAMETER_DIALOG_PASSWORD_MSG 405
265 #define PARAMETER_DIALOG_PASSWORD_TEXT 406
266 #define PARAMETER_DIALOG_SAVE 407
267 #define PARAMETER_DIALOG_CANCEL 408
268
269 // *************************** CqueryDlg ***************************
270
271
272 // QUERY DIALOG
273 enum qryOp
274 {
275 qryOpEQ,
276 qryOpLT,
277 qryOpGT,
278 qryOpLE,
279 qryOpGE,
280 qryOpBEGINS,
281 qryOpCONTAINS,
282 qryOpLIKE,
283 qryOpBETWEEN
284 };
285
286
287 // Query strings
288 char * const langQRY_EQ = "column = column | value";
289 char * const langQRY_LT = "column < column | value";
290 char * const langQRY_GT = "column > column | value";
291 char * const langQRY_LE = "column <= column | value";
292 char * const langQRY_GE = "column >= column | value";
293 char * const langQRY_BEGINS = "columns that BEGIN with the string entered";
294 char * const langQRY_CONTAINS = "columns that CONTAIN the string entered";
295 char * const langQRY_LIKE = "% matches 0 or more of any char; _ matches 1 char";
296 char * const langQRY_BETWEEN = "column BETWEEN value AND value";
297
298
299 class CqueryDlg : public wxDialog
300 {
301 private:
302 CcolInf *colInf; // Column inf. returned by db->GetColumns()
303 wxTable *dbTable;
304 char *masterTableName;
305 char *pWhere; // A pointer to the storage for the resulting where clause
306 wxDB *pDB;
307
308 public:
309 bool widgetPtrsSet;
310
311 // Widget pointers
312 wxStaticText *pQueryCol1Msg;
313 wxChoice *pQueryCol1Choice;
314 wxStaticText *pQueryNotMsg;
315 wxCheckBox *pQueryNotCheck;
316 wxStaticText *pQueryOperatorMsg;
317 wxChoice *pQueryOperatorChoice;
318 wxStaticText *pQueryCol2Msg;
319 wxChoice *pQueryCol2Choice;
320 wxStaticText *pQueryValue1Msg;
321 wxTextCtrl *pQueryValue1Txt;
322 wxStaticText *pQueryValue2Msg;
323 wxTextCtrl *pQueryValue2Txt;
324 wxStaticText *pQuerySqlWhereMsg;
325 wxTextCtrl *pQuerySqlWhereMtxt;
326 wxButton *pQueryAddBtn;
327 wxButton *pQueryAndBtn;
328 wxButton *pQueryOrBtn;
329 wxButton *pQueryLParenBtn;
330 wxButton *pQueryRParenBtn;
331 wxButton *pQueryDoneBtn;
332 wxButton *pQueryClearBtn;
333 wxButton *pQueryCountBtn;
334 wxButton *pQueryHelpBtn;
335 wxStaticBox *pQueryHintGrp;
336 wxStaticText *pQueryHintMsg;
337
338 wxTextCtrl *pFocusTxt;
339
340 CqueryDlg(wxWindow *parent, wxDB *pDb, char *tblName[], char *pWhereArg);
341
342 void OnButton( wxCommandEvent &event );
343 void OnCommand(wxWindow& win, wxCommandEvent& event);
344 bool OnClose();
345 void OnActivate(bool) {}; // necessary for hot keys
346
347 // bool SetWidgetPtrs();
348 void AppendToWhere(char *s);
349 void ProcessAddBtn();
350 void ProcessCountBtn();
351 bool ValidateWhereClause();
352
353 DECLARE_EVENT_TABLE()
354 }; // CqueryDlg
355
356 #define QUERY_DIALOG 300
357
358 // Parameter dialog control ids
359 #define QUERY_DIALOG_COL_MSG 301
360 #define QUERY_DIALOG_COL_CHOICE 302
361 #define QUERY_DIALOG_NOT_MSG 303
362 #define QUERY_DIALOG_NOT_CHECKBOX 304
363 #define QUERY_DIALOG_OP_MSG 305
364 #define QUERY_DIALOG_OP_CHOICE 306
365 #define QUERY_DIALOG_COL2_MSG 307
366 #define QUERY_DIALOG_COL2_CHOICE 308
367 #define QUERY_DIALOG_WHERE_MSG 309
368 #define QUERY_DIALOG_WHERE_TEXT 310
369 #define QUERY_DIALOG_ADD 311
370 #define QUERY_DIALOG_AND 312
371 #define QUERY_DIALOG_OR 313
372 #define QUERY_DIALOG_LPAREN 314
373 #define QUERY_DIALOG_RPAREN 315
374 #define QUERY_DIALOG_DONE 316
375 #define QUERY_DIALOG_CLEAR 317
376 #define QUERY_DIALOG_COUNT 318
377 #define QUERY_DIALOG_VALUE1_MSG 319
378 #define QUERY_DIALOG_VALUE1_TEXT 320
379 #define QUERY_DIALOG_VALUE2_MSG 321
380 #define QUERY_DIALOG_VALUE2_TEXT 322
381 #define QUERY_DIALOG_HINT_GROUP 323
382 #define QUERY_DIALOG_HINT_MSG 324
383