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