moved XML classes to the core

[wxWidgets.git] / samples / db / dbtest.h

diff --git a/samples/db/dbtest.h b/samples/db/dbtest.h
index 87911415e9ea9e51f374ff13900ebd27ef8d0520..eb5b691081f0829cd0a884f4a23992f9016c2e47 100644 (file)
--- a/samples/db/dbtest.h
+++ b/samples/db/dbtest.h
@@ -9,13 +9,12 @@
 // Licence:     wxWindows licence
 ///////////////////////////////////////////////////////////////////////////////
 
 // Licence:     wxWindows licence
 ///////////////////////////////////////////////////////////////////////////////
 

-#ifdef __GNUG__
+#if defined(__GNUG__) && !defined(__APPLE__)

 #pragma interface "dbtest.h"
 #endif
 
 #pragma interface "dbtest.h"
 #endif
 

-#include <wx/string.h>
-#include <wx/db.h>
-#include <wx/dbtable.h>
+#include "wx/string.h"
+#include "wx/dbtable.h"

 
 enum    DialogModes {mView,mCreate,mEdit,mSearch};
 
 
 enum    DialogModes {mView,mCreate,mEdit,mSearch};
 


@@ -23,9 +22,12 @@ enum    DialogModes {mView,mCreate,mEdit,mSearch};
 #define FILE_CREATE           100
 #define FILE_RECREATE_TABLE   110
 #define FILE_RECREATE_INDEXES 120
 #define FILE_CREATE           100
 #define FILE_RECREATE_TABLE   110
 #define FILE_RECREATE_INDEXES 120

+#if wxUSE_NEW_GRID
+#define FILE_DBGRID_TABLE     130
+#endif

 #define FILE_EXIT             199
 #define EDIT_PARAMETERS       200
 #define FILE_EXIT             199
 #define EDIT_PARAMETERS       200

-#define ABOUT_DEMO            300
+#define HELP_ABOUT            300

 
 // this seems to be missing, Robert Roebling (?)
 #ifndef MAX_PATH
 
 // this seems to be missing, Robert Roebling (?)
 #ifndef MAX_PATH


@@ -39,10 +41,17 @@ enum    DialogModes {mView,mCreate,mEdit,mSearch};
 // Name of the table to be created/opened
 const wxChar     CONTACT_TABLE_NAME[]       = "contacts";
 
 // Name of the table to be created/opened
 const wxChar     CONTACT_TABLE_NAME[]       = "contacts";
 

+
+#define wxODBC_BLOB_EXPERIMENT 1
+

 // Number of columns in the CONTACT table
 // Number of columns in the CONTACT table

+#if wxODBC_BLOB_EXPERIMENT > 0
+const int        CONTACT_NO_COLS            = 13;        // 0-12
+#else

 const int        CONTACT_NO_COLS            = 12;        // 0-11
 const int        CONTACT_NO_COLS            = 12;        // 0-11

+#endif

 
 

-const wxChar     PARAM_FILENAME[]            = "dbtest.cfg";
+const wxChar     PARAM_FILENAME[]           = "dbtest.cfg";

 
 
 enum Language {langENGLISH, langFRENCH, langGERMAN, langSPANISH, langOTHER};
 
 
 enum Language {langENGLISH, langFRENCH, langGERMAN, langSPANISH, langOTHER};


@@ -51,6 +60,12 @@ enum Language {langENGLISH, langFRENCH, langGERMAN, langSPANISH, langOTHER};
 class CeditorDlg;
 class CparameterDlg;
 
 class CeditorDlg;
 class CparameterDlg;
 

+
+// Used for displaying many of the database capabilites
+// and usage statistics on a database connection
+void DisplayDbDiagnostics(wxDb *pDb);
+
+

 //
 // This class contains the actual data members that are used for transferring
 // data back and forth from the database to the program.  
 //
 // This class contains the actual data members that are used for transferring
 // data back and forth from the database to the program.  


@@ -70,6 +85,9 @@ class CstructContact : public wxObject
         wxChar             Country[20+1];
         TIMESTAMP_STRUCT   JoinDate;            // Date on which this person joined the wxWindows project
         Language           NativeLanguage;      // Enumerated type indicating person's native language
         wxChar             Country[20+1];
         TIMESTAMP_STRUCT   JoinDate;            // Date on which this person joined the wxWindows project
         Language           NativeLanguage;      // Enumerated type indicating person's native language

+#if wxODBC_BLOB_EXPERIMENT > 0
+        wxChar             Picture[50000];
+#endif

         bool               IsDeveloper;         // Is this person a developer for wxWindows, or just a subscriber
         UCHAR              Contributions;       // Something to show off an integer field
         ULONG              LinesOfCode;         // Something to show off a 'long' field
         bool               IsDeveloper;         // Is this person a developer for wxWindows, or just a subscriber
         UCHAR              Contributions;       // Something to show off an integer field
         ULONG              LinesOfCode;         // Something to show off a 'long' field


@@ -114,7 +132,7 @@ class Ccontact : public wxDbTable, public CstructContact
 
         // Contains all the index definitions and calls to wxDbTable::CreateIndex()
         // required to create all the indexes we wish to define for this table.
 
         // Contains all the index definitions and calls to wxDbTable::CreateIndex()
         // required to create all the indexes we wish to define for this table.

-        bool                 CreateIndexes(void);
+        bool                 CreateIndexes(bool recreate);

 
         // Since we do not wish to have duplicate code blocks all over our program
         // for a common query/fetch that we will need to do in many places, we
 
         // Since we do not wish to have duplicate code blocks all over our program
         // for a common query/fetch that we will need to do in many places, we


@@ -142,6 +160,7 @@ class DatabaseDemoFrame: public wxFrame
 
     public:
         DatabaseDemoFrame(wxFrame *frame, const wxString& title, const wxPoint& pos, const wxSize& sz);
 
     public:
         DatabaseDemoFrame(wxFrame *frame, const wxString& title, const wxPoint& pos, const wxSize& sz);

+        ~DatabaseDemoFrame();

 
         void    OnCloseWindow(wxCloseEvent& event);
         void    OnCreate(wxCommandEvent& event);
 
         void    OnCloseWindow(wxCloseEvent& event);
         void    OnCreate(wxCommandEvent& event);


@@ -150,7 +169,10 @@ class DatabaseDemoFrame: public wxFrame
         void    OnExit(wxCommandEvent& event);
         void    OnEditParameters(wxCommandEvent& event);
         void    OnAbout(wxCommandEvent& event);
         void    OnExit(wxCommandEvent& event);
         void    OnEditParameters(wxCommandEvent& event);
         void    OnAbout(wxCommandEvent& event);

-
+#if wxUSE_NEW_GRID
+        void    OnDbGridTable( wxCommandEvent& );
+#endif 
+        void    CreateDataTable(bool recreate);

         void    BuildEditorDialog();
         void    BuildParameterDialog(wxWindow *parent);
 
         void    BuildEditorDialog();
         void    BuildParameterDialog(wxWindow *parent);
 


@@ -158,6 +180,25 @@ DECLARE_EVENT_TABLE()
 };  // DatabaseDemoFrame
 
 
 };  // DatabaseDemoFrame
 
 

+#if wxUSE_NEW_GRID
+
+// *************************** DBGridFrame ***************************
+
+class DbGridFrame : public wxFrame
+{
+public:
+    bool     initialized;
+
+    DbGridFrame(wxWindow *parent);
+
+    void     OnCloseWindow(wxCloseEvent& event);
+    bool     Initialize();
+
+    DECLARE_EVENT_TABLE()
+};
+
+#endif
+

 // Define a new application type
 class DatabaseDemoApp: public wxApp
 {
 // Define a new application type
 class DatabaseDemoApp: public wxApp
 {


@@ -203,6 +244,11 @@ class DatabaseDemoApp: public wxApp
         bool             WriteParamFile(Cparameters &params);
 
         void             CreateDataTable(bool recreate);
         bool             WriteParamFile(Cparameters &params);
 
         void             CreateDataTable(bool recreate);

+
+        // Pointer to the wxDbTable instance that is used to manipulate
+        // the data in memory and in the database
+        Ccontact        *Contact;
+

 };  // DatabaseDemoApp
 
 
 };  // DatabaseDemoApp
 
 


@@ -231,6 +277,7 @@ class CeditorDlg : public wxPanel
         wxButton        *pCreateBtn,  *pEditBtn,      *pDeleteBtn,  *pCopyBtn,  *pSaveBtn,  *pCancelBtn;
         wxButton        *pPrevBtn,    *pNextBtn,      *pQueryBtn,   *pResetBtn, *pDoneBtn,  *pHelpBtn;
         wxButton        *pNameListBtn;
         wxButton        *pCreateBtn,  *pEditBtn,      *pDeleteBtn,  *pCopyBtn,  *pSaveBtn,  *pCancelBtn;
         wxButton        *pPrevBtn,    *pNextBtn,      *pQueryBtn,   *pResetBtn, *pDoneBtn,  *pHelpBtn;
         wxButton        *pNameListBtn;

+        wxButton        *pCatalogBtn, *pDataTypesBtn, *pDbDiagsBtn;

         wxTextCtrl      *pNameTxt,    *pAddress1Txt,  *pAddress2Txt,*pCityTxt,  *pStateTxt, *pCountryTxt,*pPostalCodeTxt;
         wxStaticText    *pNameMsg,    *pAddress1Msg,  *pAddress2Msg,*pCityMsg,  *pStateMsg, *pCountryMsg,*pPostalCodeMsg;
         wxTextCtrl      *pJoinDateTxt,*pContribTxt,   *pLinesTxt;
         wxTextCtrl      *pNameTxt,    *pAddress1Txt,  *pAddress2Txt,*pCityTxt,  *pStateTxt, *pCountryTxt,*pPostalCodeTxt;
         wxStaticText    *pNameMsg,    *pAddress1Msg,  *pAddress2Msg,*pCityMsg,  *pStateMsg, *pCountryMsg,*pPostalCodeMsg;
         wxTextCtrl      *pJoinDateTxt,*pContribTxt,   *pLinesTxt;


@@ -247,10 +294,6 @@ class CeditorDlg : public wxPanel
 
         enum DialogModes mode;
 
 
         enum DialogModes mode;
 

-        // Pointer to the wxDbTable instance that is used to manipulate
-        // the data in memory and in the database
-        Ccontact        *Contact;
-

         CeditorDlg(wxWindow *parent);
 
         void    OnCloseWindow(wxCloseEvent& event);
         CeditorDlg(wxWindow *parent);
 
         void    OnCloseWindow(wxCloseEvent& event);


@@ -330,6 +373,9 @@ DECLARE_EVENT_TABLE()
 #define EDITOR_DIALOG_DEVELOPER         236
 #define EDITOR_DIALOG_JOIN_MSG          237
 #define EDITOR_DIALOG_JOIN_TEXT         238
 #define EDITOR_DIALOG_DEVELOPER         236
 #define EDITOR_DIALOG_JOIN_MSG          237
 #define EDITOR_DIALOG_JOIN_TEXT         238

+#define EDITOR_DIALOG_CATALOG           240
+#define EDITOR_DIALOG_DATATYPES         250
+#define EDITOR_DIALOG_DB_DIAGS          260

 
 // *************************** CparameterDlg ***************************
 
 
 // *************************** CparameterDlg ***************************
 


@@ -514,3 +560,95 @@ DECLARE_EVENT_TABLE()
 #define QUERY_DIALOG_HINT_GROUP         323
 #define QUERY_DIALOG_HINT_MSG           324
 
 #define QUERY_DIALOG_HINT_GROUP         323
 #define QUERY_DIALOG_HINT_MSG           324
 

+char * const langNO                        = "No";
+char * const langYES                       = "Yes";
+char * const langDBINF_DB_NAME             = "Database Name = ";
+char * const langDBINF_DB_VER              = "Database Version = ";
+char * const langDBINF_DRIVER_NAME         = "Driver Name = ";
+char * const langDBINF_DRIVER_ODBC_VER     = "Driver ODBC Version = ";
+char * const langDBINF_DRIVER_MGR_ODBC_VER = "Driver Manager ODBC Version = ";
+char * const langDBINF_DRIVER_VER          = "Driver Version = ";
+char * const langDBINF_SERVER_NAME         = "Server Name = ";
+char * const langDBINF_FILENAME            = "Filename = ";
+char * const langDBINF_OUTER_JOINS         = "Outer Joins = ";
+char * const langDBINF_STORED_PROC         = "Stored Procedures = ";
+char * const langDBINF_MAX_HDBC            = "Max # of Db connections = ";
+char * const langDBINF_MAX_HSTMT           = "Max # of cursors (per db connection) = ";
+char * const langDBINF_UNLIMITED           = "Unlimited or Unknown"; 
+char * const langDBINF_API_LVL             = "ODBC API conformance level = ";
+char * const langDBINF_CLI_LVL             = "Client (SAG) conformance level = ";
+char * const langDBINF_SQL_LVL             = "SQL conformance level = ";
+char * const langDBINF_COMMIT_BEHAVIOR     = "Commit Behavior = ";
+char * const langDBINF_ROLLBACK_BEHAVIOR   = "Rollback Behavior = ";
+char * const langDBINF_SUPP_NOT_NULL       = "Support NOT NULL clause = ";
+char * const langDBINF_SUPP_IEF            = "Support IEF = ";
+char * const langDBINF_TXN_ISOLATION       = "Transaction Isolation Level (default) = ";
+char * const langDBINF_TXN_ISOLATION_CURR  = "Transaction Isolation Level (current) = ";
+char * const langDBINF_TXN_ISOLATION_OPTS  = "Transaction Isolation Options Available = ";
+char * const langDBINF_FETCH_DIRS          = "Fetch Directions = ";
+char * const langDBINF_LOCK_TYPES          = "Lock Types (SQLSetPos) = ";
+char * const langDBINF_POS_OPERS           = "Position Operations (SQLSetPos) = ";
+char * const langDBINF_POS_STMTS           = "Position Statements = ";
+char * const langDBINF_SCROLL_CONCURR      = "Concurrency Options (scrollable cursors) = ";
+char * const langDBINF_SCROLL_OPTS         = "Scroll Options (scrollable cursors) = ";
+char * const langDBINF_STATIC_SENS         = "Static Sensitivity = ";
+char * const langDBINF_TXN_CAPABLE         = "Transaction Support = ";
+char * const langDBINF_LOGIN_TIMEOUT       = "Login Timeout = ";
+char * const langDBINF_NONE                = "None";
+char * const langDBINF_LEVEL1              = "Level 1";
+char * const langDBINF_LEVEL2              = "Level 2";
+char * const langDBINF_NOT_COMPLIANT       = "Not Compliant";
+char * const langDBINF_COMPLIANT           = "Compliant";
+char * const langDBINF_MIN_GRAMMAR         = "Minimum Grammer";
+char * const langDBINF_CORE_GRAMMAR        = "Core Grammer";
+char * const langDBINF_EXT_GRAMMAR         = "Extended Grammer";
+char * const langDBINF_DELETE_CURSORS      = "Delete cursors";
+char * const langDBINF_CLOSE_CURSORS       = "Close cursors";
+char * const langDBINF_PRESERVE_CURSORS    = "Preserve cursors";
+char * const langDBINF_READ_UNCOMMITTED    = "Read Uncommitted";
+char * const langDBINF_READ_COMMITTED      = "Read Committed";
+char * const langDBINF_REPEATABLE_READ     = "Repeatable Read";
+char * const langDBINF_SERIALIZABLE        = "Serializable";
+char * const langDBINF_VERSIONING          = "Versioning";
+char * const langDBINF_NEXT                = "Next";
+char * const langDBINF_PREV                = "Prev";
+char * const langDBINF_FIRST               = "First";
+char * const langDBINF_LAST                = "Last";
+char * const langDBINF_ABSOLUTE            = "Absolute";
+char * const langDBINF_RELATIVE            = "Relative";
+char * const langDBINF_RESUME              = "Resume";
+char * const langDBINF_BOOKMARK            = "Bookmark";
+char * const langDBINF_NO_CHANGE           = "No Change";
+char * const langDBINF_EXCLUSIVE           = "Exclusive";
+char * const langDBINF_UNLOCK              = "Unlock";
+char * const langDBINF_POSITION            = "Position";
+char * const langDBINF_REFRESH             = "Refresh";
+char * const langDBINF_UPD                 = "Upd";
+char * const langDBINF_DEL                 = "Del";
+char * const langDBINF_ADD                 = "Add";
+char * const langDBINF_POS_DEL             = "Pos Delete";
+char * const langDBINF_POS_UPD             = "Pos Update";
+char * const langDBINF_SELECT_FOR_UPD      = "Select For Update";
+char * const langDBINF_READ_ONLY           = "Read Only";
+char * const langDBINF_LOCK                = "Lock";
+char * const langDBINF_OPT_ROWVER          = "Opt. Rowver";
+char * const langDBINF_OPT_VALUES          = "Opt. Values";
+char * const langDBINF_FWD_ONLY            = "Fwd Only";
+char * const langDBINF_STATIC              = "Static";
+char * const langDBINF_KEYSET_DRIVEN       = "Keyset Driven";
+char * const langDBINF_DYNAMIC             = "Dynamic";
+char * const langDBINF_MIXED               = "Mixed";
+char * const langDBINF_ADDITIONS           = "Additions";
+char * const langDBINF_DELETIONS           = "Deletions";
+char * const langDBINF_UPDATES             = "Updates";
+char * const langDBINF_DML_ONLY            = "DML Only";
+char * const langDBINF_DDL_COMMIT          = "DDL Commit";
+char * const langDBINF_DDL_IGNORE          = "DDL Ignore";
+char * const langDBINF_DDL_AND_DML         = "DDL and DML";
+char * const langDBINF_ORACLE_BANNER       = ">>> ORACLE STATISTICS AND TUNING INFORMATION <<<";
+char * const langDBINF_DB_BLOCK_GETS       = "DB block gets";
+char * const langDBINF_CONSISTENT_GETS     = "Consistent gets";
+char * const langDBINF_PHYSICAL_READS      = "Physical reads";
+char * const langDBINF_CACHE_HIT_RATIO     = "Cache hit ratio";
+char * const langDBINF_TABLESPACE_IO       = "TABLESPACE I/O LEVELS";
+char * const langDBINF_PHYSICAL_WRITES     = "Physical writes";