]>
git.saurik.com Git - wxWidgets.git/blob - demos/dbbrowse/dbtree.cpp
1 //----------------------------------------------------------------------------------------
3 // Purpose: Tree with Table and Views, branches show Field information
4 // Author: Mark Johnson
8 // Copyright: (c) Mark Johnson, Berlin Germany
9 // Licence: wxWindows license
10 //----------------------------------------------------------------------------------------
11 //-- all #ifdefs that the whole Project needs. -------------------------------------------
12 //----------------------------------------------------------------------------------------
14 #pragma implementation
17 //----------------------------------------------------------------------------------------
18 // For compilers that support precompilation, includes "wx/wx.h".
19 #include "wx/wxprec.h"
20 //----------------------------------------------------------------------------------------
24 //----------------------------------------------------------------------------------------
28 //----------------------------------------------------------------------------------------
31 //----------------------------------------------------------------------------------------
32 //-- all #includes that every .cpp needs --- 19990807.mj10777 ----------------
33 //----------------------------------------------------------------------------------------
34 #include "std.h" // sorgsam Pflegen !
36 //----------------------------------------------------------------------------------------
37 //-- Global functions --------------------------------------------------------------------
38 //----------------------------------------------------------------------------------------
39 static inline const wxChar
* bool2String ( bool b
)
41 return b
? _T ( "" ) : _T ( "not " );
44 //----------------------------------------------------------------------------------------
45 BEGIN_EVENT_TABLE ( DBTree
, wxTreeCtrl
)
46 EVT_MOTION ( DBTree :: OnMouseMove
)
47 EVT_TREE_SEL_CHANGED ( TREE_CTRL_DB
, DBTree :: OnSelChanged
)
48 EVT_TREE_ITEM_RIGHT_CLICK ( TREE_CTRL_DB
, DBTree :: OnRightSelect
)
49 EVT_MENU ( DATA_SHOW
, DBTree :: OnDBGrid
)
50 EVT_MENU ( DATA_DB
, DBTree :: OnDBClass
)
51 EVT_MENU ( DATA_TABLE
, DBTree :: OnTableClass
)
52 EVT_MENU ( DATA_TABLE_ALL
, DBTree :: OnTableClassAll
)
54 //----------------------------------------------------------------------------------------
55 // DBTree implementation
56 //----------------------------------------------------------------------------------------
57 IMPLEMENT_DYNAMIC_CLASS ( DBTree
, wxTreeCtrl
)
59 //----------------------------------------------------------------------------------------
60 DBTree :: DBTree ( wxWindow
* parent
) : wxTreeCtrl ( parent
)
64 //----------------------------------------------------------------------------------------
65 DBTree :: DBTree ( wxWindow
* parent
, const wxWindowID id
, const wxPoint
& pos
, const wxSize
& size
, long style
)
66 : wxTreeCtrl ( parent
, id
, pos
, size
, style
)
68 const int image_size
= 16 ;
69 // Make an image list containing small icons
70 p_imageListNormal
= new wxImageList ( image_size
, image_size
, TRUE
);
71 // should correspond to TreeIc_xxx enum
72 #if !defined(__WXMSW__)
73 #include "bitmaps/logo.xpm"
74 #include "bitmaps/dsnclose.xpm"
75 #include "bitmaps/dsnopen.xpm"
76 #include "bitmaps/tab.xpm"
77 #include "bitmaps/view.xpm"
78 #include "bitmaps/col.xpm"
79 #include "bitmaps/key.xpm"
80 #include "bitmaps/keyf.xpm"
81 #include "bitmaps/d_open.xpm"
82 #include "bitmaps/d_closed.xpm"
84 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( aLogo
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
85 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( DsnClosed
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
86 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( DsnOpen
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
87 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( TAB
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
88 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( VIEW
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
89 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( COL
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
90 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( KEY
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
91 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( KEYF
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
92 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( DocOpen
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
93 p_imageListNormal
-> Add ( wxBitmap ( wxBitmap ( wxICON ( DocOpen
)). ConvertToImage (). Rescale ( image_size
, image_size
)));
94 SetImageList ( p_imageListNormal
);
100 //----------------------------------------------------------------------------------------
105 // delete (pDoc->db_Br+i_Which);
106 // wxLogMessage("DBTree::~DBTree() - Vor OnCloseDB()");
107 ( pDoc
-> db_Br
+ i_Which
)-> OnCloseDB ( FALSE
);
108 // wxLogMessage("DBTree::~DBTree() - Nach OnCloseDB()");
109 ( pDoc
-> db_Br
+ i_Which
)-> db_BrowserDB
= NULL
;
110 ( pDoc
-> db_Br
+ i_Which
)-> ct_BrowserDB
= NULL
;
111 ( pDoc
-> db_Br
+ i_Which
)-> cl_BrowserDB
= NULL
;
113 delete p_imageListNormal
;
114 if ( popupMenu1
) // If the DSN has no Tables, then no delete should be done !
116 if ( popupMenu1
) // If the DSN has no Tables, then no delete should be done !
120 //----------------------------------------------------------------------------------------
121 #undef TREE_EVENT_HANDLER
123 //----------------------------------------------------------------------------------------
124 int DBTree :: OnPopulate ()
126 wxTreeItemId Root
, Folder
, Docu
, Funkt
;
127 int i
, x
, y
, z
= 0 , TableType
;
128 wxString SQL_TYPE
, DB_TYPE
;
129 SetFont (* pDoc
-> ft_Doc
);
130 //---------------------------------------------------------------------------------------
131 if (( pDoc
-> db_Br
+ i_Which
)-> Initialize ( FALSE
))
135 ct_BrowserDB
= ( pDoc
-> db_Br
+ i_Which
)-> OnGetCatalog ( FALSE
);
137 { // Use the wxDatabase Information
138 Temp0
. Printf ( _T ( " %s - ( %s ) ( %s )" ), s_DSN
. c_str (), ct_BrowserDB
-> catalog
, ct_BrowserDB
-> schema
);
139 Root
= AddRoot ( Temp0
, TreeIc_DsnOpen
, TreeIc_DsnOpen
, new DBTreeData ( _T ( "Root" )));
140 for ( x
= 0 ; x
< ct_BrowserDB
-> numTables
; x
++)
143 TableType
= 0 ; // TABLE = 1 ; VIEW = 2 ; 0 We are not interested in
144 if (! wxStrcmp (( ct_BrowserDB
-> pTableInf
+ x
)-> tableType
, _T ( "TABLE" ))) // only TABLES
146 if (! wxStrcmp (( ct_BrowserDB
-> pTableInf
+ x
)-> tableType
, _T ( "VIEW" ))) // and VIEWS
148 if ( TableType
) // only TABLES or Views
150 Temp1
. Printf ( _T ( "TN( %s " ),( ct_BrowserDB
-> pTableInf
+ x
)-> tableName
);
152 ( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
= ( pDoc
-> db_Br
+ i_Which
)-> OnGetColumns (( ct_BrowserDB
-> pTableInf
+ x
)-> tableName
,( ct_BrowserDB
-> pTableInf
+ x
)-> numCols
, FALSE
);
154 if (( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
)
156 if ( TableType
== 1 ) // Table
158 Temp0
. Printf ( _ ( "Table-Name( %s ) with ( %d )Columns ; Remarks( %s )" ), ( ct_BrowserDB
-> pTableInf
+ x
)-> tableName
,
159 ( ct_BrowserDB
-> pTableInf
+ x
)-> numCols
,( ct_BrowserDB
-> pTableInf
+ x
)-> tableRemarks
);
160 Folder
= AppendItem ( Root
, Temp0
, TreeIc_TAB
, TreeIc_TAB
, new DBTreeData ( Temp1
));
162 if ( TableType
== 2 ) // View
164 Temp0
. Printf ( _ ( "View-Name( %s ) with ( %d )Columns ; Remarks( %s )" ), ( ct_BrowserDB
-> pTableInf
+ x
)-> tableName
,
165 ( ct_BrowserDB
-> pTableInf
+ x
)-> numCols
,( ct_BrowserDB
-> pTableInf
+ x
)-> tableRemarks
);
166 Folder
= AppendItem ( Root
, Temp0
, TreeIc_VIEW
, TreeIc_VIEW
, new DBTreeData ( Temp1
));
168 for ( y
= 0 ; y
<( ct_BrowserDB
-> pTableInf
+ x
)-> numCols
; y
++)
170 Temp1
. Printf ( _T ( "FN( %s " ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> colName
);
171 // Here is where we find out if the Column is a Primary / Foreign Key
172 if ((( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> PkCol
!= 0 ) // Primary Key
174 Temp2
. Printf ( _T ( "( %d ) - %s " ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> PkCol
,(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> colName
);
175 Docu
= AppendItem ( Folder
, Temp2
, TreeIc_KEY
, TreeIc_KEY
, new DBTreeData ( Temp1
));
176 Temp2
= (( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> PkTableName
;
179 Temp2
. Printf ( _ ( "This Primary Key is used in the following Tables : %s " ), Temp2
. c_str ());
180 Funkt
= AppendItem ( Docu
, Temp2
, TreeIc_DocClosed
, TreeIc_DocOpen
, new DBTreeData ( _T ( "KEY" )));
184 if ((( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> FkCol
!= 0 ) // Foreign Key
186 Temp2
. Printf ( _T ( "( %d ) - %s " ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> FkCol
,(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> colName
);
187 Docu
= AppendItem ( Folder
, Temp2
, TreeIc_KEYF
, TreeIc_KEYF
, new DBTreeData ( Temp1
));
188 Temp2
. Printf ( _ ( "This Foreign Key comes from the following Table : %s " ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> FkTableName
);
189 Funkt
= AppendItem ( Docu
, Temp2
, TreeIc_DocClosed
, TreeIc_DocOpen
, new DBTreeData ( _T ( "KEYF" )));
192 Docu
= AppendItem ( Folder
,(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> colName
, TreeIc_COL
, TreeIc_COL
, new DBTreeData ( Temp1
));
194 SQL_TYPE
. Printf ( _T ( "SQL_C_???? ( %d )" ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> sqlDataType
);
195 DB_TYPE
. Printf ( _T ( "DB_DATA_TYPE_???? ( %d )" ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> dbDataType
);
196 for ( i
= 1 ; i
<=( pDoc
-> db_Br
+ i_Which
)-> i_SqlTyp
[ 0 ]; i
++)
198 if ((( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> sqlDataType
== ( pDoc
-> db_Br
+ i_Which
)-> i_SqlTyp
[ i
])
200 SQL_TYPE
. Printf ( _T ( " %s ( %d ) ; " ),( pDoc
-> db_Br
+ i_Which
)-> s_SqlTyp
[ i
]. c_str (),( pDoc
-> db_Br
+ i_Which
)-> i_SqlTyp
[ i
]);
202 } // for (i=1;i<=i_SqlTyp[0];i++)
204 for ( i
= 1 ; i
<=( pDoc
-> db_Br
+ i_Which
)-> i_dbTyp
[ 0 ]; i
++)
206 if ((( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> dbDataType
== ( pDoc
-> db_Br
+ i_Which
)-> i_dbTyp
[ i
])
208 DB_TYPE
. Printf ( _T ( " %s ( %d )" ),( pDoc
-> db_Br
+ i_Which
)-> s_dbTyp
[ i
]. c_str (),( pDoc
-> db_Br
+ i_Which
)-> i_dbTyp
[ i
]);
210 } // for (i=1;i<=i_dbTyp[0];i++)
213 Funkt
= AppendItem ( Docu
, SQL_TYPE
, TreeIc_DocClosed
, TreeIc_DocOpen
, new DBTreeData ( SQL_TYPE
));
214 SQL_TYPE
. Printf ( _T ( " %1 0s %d , %d " ),(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> typeName
,
215 (( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> columnSize
,(( ct_BrowserDB
-> pTableInf
+ x
)-> pColInf
+ y
)-> decimalDigits
);
216 Funkt
= AppendItem ( Docu
, SQL_TYPE
, TreeIc_DocClosed
, TreeIc_DocOpen
, new DBTreeData ( SQL_TYPE
));
217 } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
218 } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
220 Folder
= AppendItem ( Root
, Temp0
, TreeIc_FolderClosed
, TreeIc_FolderOpen
, new DBTreeData ( Temp1
));
224 Temp0
. Printf ( _ ( "-I-> DBTree::OnPopulate( %s ) - Table %6 d (from %d ) has been read." ),( ct_BrowserDB
-> pTableInf
+ x
)-> tableName
, z
, ct_BrowserDB
-> numTables
);
225 pDoc
-> p_MainFrame
-> SetStatusText ( Temp0
, 0 );
228 } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE" or VIEW)
230 // wxLogMessage(_("\n-I-> if ! TABLE or VIEW >%s<"),(ct_BrowserDB->pTableInf+x)->tableType);
231 } // for (x=0;x<ct_BrowserDB->numTables;x++)
232 } // if (ct_BrowserDB)
234 wxLogMessage ( _ ( " \n -E-> DBTree::OnPopulate() : Invalid Catalog Pointer : Failed" ));
236 Temp0
. Printf ( _ ( "-I-> DBTree::OnPopulate() - %6 d Tables have been read. - Time needed : %l d ms" ), z
, sw
. Time ());
238 pDoc
-> p_MainFrame
-> SetStatusText ( Temp0
, 0 );
239 } // if((pDoc->db_Br+i_Which)->Initialize(FALSE))
242 wxLogMessage ( _ ( " \n -E-> DBTree::OnPopulate() : A valid Pointer could not be created : Failed" ));
245 //---------------------------------------------------------------------------------------
247 //---------------------------------------------------------------------------------------
249 popupMenu1
= new wxMenu ( _T ( "" ));
250 popupMenu1
-> Append ( DATA_DB
, _ ( "Make wxDB.cpp/h " ));
251 popupMenu1
-> AppendSeparator ();
252 popupMenu1
-> Append ( DATA_TABLE_ALL
, _ ( "Make all wxTable.cpp/h classes" ));
254 popupMenu2
= new wxMenu ( _T ( "" ));
255 popupMenu2
-> Append ( DATA_SHOW
, _ ( "Show Data" ));
256 popupMenu2
-> AppendSeparator ();
257 popupMenu2
-> Append ( DATA_TABLE
, _ ( "Make wxTable.cpp/h " ));
258 //---------------------------------------------------------------------------------------
260 } // DBTree::OnPopulate()
262 //----------------------------------------------------------------------------------------
263 void DBTree :: OnSelChanged ( wxTreeEvent
& WXUNUSED ( event
))
267 pDoc
-> p_MainFrame
-> SetStatusText ( Temp0
, 0 );
268 // Get the Information that we need
269 wxTreeItemId itemId
= GetSelection ();
270 DBTreeData
* item
= ( DBTreeData
*) GetItemData ( itemId
);
274 Temp1
. Printf ( _T ( " %s " ), item
-> m_desc
. c_str ());
275 //-------------------------------------------------------------------------------------
276 if ( Temp1
. Contains ( _T ( "ODBC-" )))
278 Temp1
= Temp1
. Mid ( 5 , wxSTRING_MAXLEN
);
279 for ( i
= 0 ; i
< pDoc
-> i_DSN
; i
++)
281 if ( Temp1
== ( pDoc
-> p_DSN
+ i
)-> Dsn
)
283 // pDoc->OnChosenDSN(i);
288 //--------------------------------------------------------------------------------------
291 //-------------------------------------------------------------------------------------
293 Temp0.Printf(_("Item '%s': %sselected, %sexpanded, %sbold,"
294 "%u children (%u immediately under this item)."),
295 item->m_desc.c_str(),
296 bool2String(IsSelected(itemId)),
297 bool2String(IsExpanded(itemId)),
298 bool2String(IsBold(itemId)),
299 GetChildrenCount(itemId),
300 GetChildrenCount(itemId));
301 LogBuf.Printf("-I-> DBTree::OnSelChanged - %s",Temp0.c_str());
302 wxLogMessage( "%s", LogBuf.c_str() );
304 //-------------------------------------------------------------------------------------
309 //----------------------------------------------------------------------------------------
310 void DBTree :: OnRightSelect ( wxTreeEvent
& WXUNUSED ( event
))
314 // Get the Information that we need
315 wxTreeItemId itemId
= GetSelection ();
316 DBTreeData
* item
= ( DBTreeData
*) GetItemData ( itemId
);
320 Temp1
. Printf ( _T ( " %s " ), item
-> m_desc
. c_str ());
321 //--------------------------------------------------------------------------------------
322 if (! wxStrcmp ( _T ( "Root" ), Temp1
))
324 PopupMenu ( popupMenu1
, TreePos
. x
, TreePos
. y
);
327 for ( i
= 0 ; i
< ct_BrowserDB
-> numTables
; i
++)
329 Temp2
. Printf ( _T ( "TN( %s " ),( ct_BrowserDB
-> pTableInf
+ i
)-> tableName
);
330 if (! wxStrcmp ( Temp2
, Temp1
))
332 PopupMenu ( popupMenu2
, TreePos
. x
, TreePos
. y
);
336 //--------------------------------------------------------------------------------------
339 //-------------------------------------------------------------------------------------
341 Temp0.Printf(_("Item '%s': %sselected, %sexpanded, %sbold,"
342 "%u children (%u immediately under this item)."),
343 item->m_desc.c_str(),
344 bool2String(IsSelected(itemId)),
345 bool2String(IsExpanded(itemId)),
346 bool2String(IsBold(itemId)),
347 GetChildrenCount(itemId),
348 GetChildrenCount(itemId));
349 LogBuf.Printf("-I-> DBTree::OnSelChanged - %s",Temp0.c_str());
350 wxLogMessage( "%s", LogBuf.c_str() );
352 //-------------------------------------------------------------------------------------
357 //----------------------------------------------------------------------------------------
358 void DBTree :: OnDBGrid ( wxCommandEvent
& WXUNUSED ( event
))
361 // Get the Information that we need
362 wxTreeItemId itemId
= GetSelection ();
363 DBTreeData
* item
= ( DBTreeData
*) GetItemData ( itemId
);
366 Temp1
. Printf ( _T ( " %s " ), item
-> m_desc
. c_str ());
367 for ( i
= 0 ; i
< ct_BrowserDB
-> numTables
; i
++)
369 Temp2
. Printf ( _T ( "TN( %s " ),( ct_BrowserDB
-> pTableInf
+ i
)-> tableName
);
370 if (! wxStrcmp ( Temp2
, Temp1
))
372 // Temp0.Printf("(%d) Here is where a GridCtrl for >%s< will be called! ",i,(ct_BrowserDB->pTableInf+i)->tableName);
373 pDoc
-> OnChosenTbl ( 1 ,( ct_BrowserDB
-> pTableInf
+ i
)-> tableName
);
374 // wxMessageBox(Temp0);
380 //----------------------------------------------------------------------------------------
381 void DBTree :: OnDBClass ( wxCommandEvent
& WXUNUSED ( event
))
384 // Get the Information that we need
385 wxTreeItemId itemId
= GetSelection ();
386 DBTreeData
* item
= ( DBTreeData
*) GetItemData ( itemId
);
389 Temp0
. Printf ( _ ( "Here is where a wxDB Class for > %s < will be made! " ), s_DSN
. c_str ());
394 //----------------------------------------------------------------------------------------
395 void DBTree :: OnTableClass ( wxCommandEvent
& WXUNUSED ( event
))
398 // Get the Information that we need
399 wxTreeItemId itemId
= GetSelection ();
400 DBTreeData
* item
= ( DBTreeData
*) GetItemData ( itemId
);
403 Temp1
. Printf ( _T ( " %s " ), item
-> m_desc
. c_str ());
404 for ( i
= 0 ; i
< ct_BrowserDB
-> numTables
; i
++)
406 Temp2
. Printf ( _T ( "TN( %s " ),( ct_BrowserDB
-> pTableInf
+ i
)-> tableName
);
407 if (! wxStrcmp ( Temp2
, Temp1
))
409 Temp0
. Printf ( _ ( "( %d ) Here is where a wxTable Class for > %s < will be made! " ), i
,( ct_BrowserDB
-> pTableInf
+ i
)-> tableName
);
416 //----------------------------------------------------------------------------------------
417 void DBTree :: OnTableClassAll ( wxCommandEvent
& WXUNUSED ( event
))
420 // Get the Information that we need
421 wxTreeItemId itemId
= GetSelection ();
422 DBTreeData
* item
= ( DBTreeData
*) GetItemData ( itemId
);
425 Temp0
. Printf ( _ ( "Here is where all wxTable Classes in > %s < will be made! " ), s_DSN
. c_str ());
430 //----------------------------------------------------------------------------------------
431 void DBTree :: OnMouseMove ( wxMouseEvent
& event
)
433 TreePos
= event
. GetPosition ();
435 //----------------------------------------------------------------------------------------