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 //----------------------------------------------------------------------------------------
12 // For compilers that support precompilation, includes "wx/wx.h".
13 #include "wx/wxprec.h"
14 //----------------------------------------------------------------------------------------
18 //----------------------------------------------------------------------------------------
22 //----------------------------------------------------------------------------------------
25 //----------------------------------------------------------------------------------------
26 //-- all #includes that every .cpp needs --- 19990807.mj10777 ----------------
27 //----------------------------------------------------------------------------------------
28 #include "std.h" // sorgsam Pflegen !
30 //----------------------------------------------------------------------------------------
31 //-- Global functions --------------------------------------------------------------------
32 //----------------------------------------------------------------------------------------
33 static inline const wxChar
*bool2String(bool b
)
35 return b
? wxEmptyString
: _T("not ");
38 //----------------------------------------------------------------------------------------
39 BEGIN_EVENT_TABLE(DBTree
, wxTreeCtrl
)
40 EVT_MOTION (DBTree::OnMouseMove
)
41 EVT_TREE_SEL_CHANGED(TREE_CTRL_DB
, DBTree::OnSelChanged
)
42 EVT_TREE_ITEM_RIGHT_CLICK(TREE_CTRL_DB
,DBTree::OnRightSelect
)
43 EVT_MENU(DATA_SHOW
,DBTree::OnDBGrid
)
44 EVT_MENU(DATA_DB
,DBTree::OnDBClass
)
45 EVT_MENU(DATA_TABLE
,DBTree::OnTableClass
)
46 EVT_MENU(DATA_TABLE_ALL
,DBTree::OnTableClassAll
)
48 //----------------------------------------------------------------------------------------
49 // DBTree implementation
50 //----------------------------------------------------------------------------------------
51 IMPLEMENT_DYNAMIC_CLASS(DBTree
, wxTreeCtrl
)
53 //----------------------------------------------------------------------------------------
54 DBTree::DBTree(wxWindow
*parent
) : wxTreeCtrl(parent
)
58 //----------------------------------------------------------------------------------------
59 DBTree::DBTree(wxWindow
*parent
, const wxWindowID id
,const wxPoint
& pos
, const wxSize
& size
, long style
)
60 : wxTreeCtrl(parent
, id
, pos
, size
, style
)
62 const int image_size
= 16;
63 // Make an image list containing small icons
64 p_imageListNormal
= new wxImageList(image_size
, image_size
, true);
65 // should correspond to TreeIc_xxx enum
66 #if !defined(__WXMSW__)
67 #include "bitmaps/logo.xpm"
68 #include "bitmaps/dsnclose.xpm"
69 #include "bitmaps/dsnopen.xpm"
70 #include "bitmaps/tab.xpm"
71 #include "bitmaps/view.xpm"
72 #include "bitmaps/col.xpm"
73 #include "bitmaps/key.xpm"
74 #include "bitmaps/keyf.xpm"
75 #include "bitmaps/d_open.xpm"
76 #include "bitmaps/d_closed.xpm"
78 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(aLogo
)).ConvertToImage().Rescale(image_size
, image_size
)));
79 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(DsnClosed
)).ConvertToImage().Rescale(image_size
, image_size
)));
80 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(DsnOpen
)).ConvertToImage().Rescale(image_size
, image_size
)));
81 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(TAB
)).ConvertToImage().Rescale(image_size
, image_size
)));
82 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(VIEW
)).ConvertToImage().Rescale(image_size
, image_size
)));
83 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(COL
)).ConvertToImage().Rescale(image_size
, image_size
)));
84 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(KEY
)).ConvertToImage().Rescale(image_size
, image_size
)));
85 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(KEYF
)).ConvertToImage().Rescale(image_size
, image_size
)));
86 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(DocOpen
)).ConvertToImage().Rescale(image_size
, image_size
)));
87 p_imageListNormal
->Add(wxBitmap(wxBitmap(wxICON(DocOpen
)).ConvertToImage().Rescale(image_size
, image_size
)));
88 SetImageList(p_imageListNormal
);
94 //----------------------------------------------------------------------------------------
99 // delete (pDoc->db_Br+i_Which);
100 // wxLogMessage("DBTree::~DBTree() - Vor OnCloseDB()");
101 (pDoc
->db_Br
+i_Which
)->OnCloseDB(false);
102 // wxLogMessage("DBTree::~DBTree() - Nach OnCloseDB()");
103 (pDoc
->db_Br
+i_Which
)->db_BrowserDB
= NULL
;
104 (pDoc
->db_Br
+i_Which
)->ct_BrowserDB
= NULL
;
105 (pDoc
->db_Br
+i_Which
)->cl_BrowserDB
= NULL
;
107 delete p_imageListNormal
;
108 if (popupMenu1
) // If the DSN has no Tables, then no delete should be done !
110 if (popupMenu1
) // If the DSN has no Tables, then no delete should be done !
114 //----------------------------------------------------------------------------------------
115 #undef TREE_EVENT_HANDLER
117 //----------------------------------------------------------------------------------------
118 int DBTree::OnPopulate()
120 wxTreeItemId Root
, Folder
, Docu
, Funkt
;
121 int i
,x
,y
,z
=0, TableType
;
122 wxString SQL_TYPE
, DB_TYPE
;
123 SetFont(* pDoc
->ft_Doc
);
124 //---------------------------------------------------------------------------------------
125 if ((pDoc
->db_Br
+i_Which
)->Initialize(false))
129 ct_BrowserDB
= (pDoc
->db_Br
+i_Which
)->OnGetCatalog(false);
131 { // Use the wxDatabase Information
132 Temp0
.Printf(_T("%s - (%s) (%s)"), s_DSN
.c_str(),ct_BrowserDB
->catalog
, ct_BrowserDB
->schema
);
133 Root
= AddRoot(Temp0
,TreeIc_DsnOpen
,TreeIc_DsnOpen
,new DBTreeData(_T("Root")));
134 for (x
=0;x
<ct_BrowserDB
->numTables
;x
++)
137 TableType
= 0; // TABLE = 1 ; VIEW = 2 ; 0 We are not interested in
138 if (!wxStrcmp((ct_BrowserDB
->pTableInf
+x
)->tableType
,_T("TABLE"))) // only TABLES
140 if (!wxStrcmp((ct_BrowserDB
->pTableInf
+x
)->tableType
,_T("VIEW"))) // and VIEWS
142 if (TableType
) // only TABLES or Views
144 Temp1
.Printf(_T("TN(%s"),(ct_BrowserDB
->pTableInf
+x
)->tableName
);
146 (ct_BrowserDB
->pTableInf
+x
)->pColInf
= (pDoc
->db_Br
+i_Which
)->OnGetColumns((ct_BrowserDB
->pTableInf
+x
)->tableName
,(ct_BrowserDB
->pTableInf
+x
)->numCols
,false);
148 if ((ct_BrowserDB
->pTableInf
+x
)->pColInf
)
150 if (TableType
== 1) // Table
152 Temp0
.Printf(_("Table-Name(%s) with (%d)Columns ; Remarks(%s)"), (ct_BrowserDB
->pTableInf
+x
)->tableName
,
153 (ct_BrowserDB
->pTableInf
+x
)->numCols
,(ct_BrowserDB
->pTableInf
+x
)->tableRemarks
);
154 Folder
= AppendItem(Root
,Temp0
,TreeIc_TAB
,TreeIc_TAB
, new DBTreeData(Temp1
));
156 if (TableType
== 2) // View
158 Temp0
.Printf(_("View-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_VIEW
,TreeIc_VIEW
, new DBTreeData(Temp1
));
162 for (y
=0;y
<(ct_BrowserDB
->pTableInf
+x
)->numCols
;y
++)
164 Temp1
.Printf(_T("FN(%s"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->colName
);
165 // Here is where we find out if the Column is a Primary / Foreign Key
166 if (((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->PkCol
!= 0) // Primary Key
168 Temp2
.Printf(_T("(%d) - %s"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->PkCol
,((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->colName
);
169 Docu
= AppendItem(Folder
,Temp2
,TreeIc_KEY
,TreeIc_KEY
,new DBTreeData(Temp1
));
170 Temp2
= ((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->PkTableName
;
173 Temp2
.Printf(_("This Primary Key is used in the following Tables : %s"),Temp2
.c_str());
174 Funkt
= AppendItem(Docu
,Temp2
,TreeIc_DocClosed
,TreeIc_DocOpen
,new DBTreeData(_T("KEY")));
178 if (((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->FkCol
!= 0) // Foreign Key
180 Temp2
.Printf(_T("(%d) - %s"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->FkCol
,((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->colName
);
181 Docu
= AppendItem(Folder
,Temp2
,TreeIc_KEYF
,TreeIc_KEYF
,new DBTreeData(Temp1
));
182 Temp2
.Printf(_("This Foreign Key comes from the following Table : %s"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->FkTableName
);
183 Funkt
= AppendItem(Docu
,Temp2
,TreeIc_DocClosed
,TreeIc_DocOpen
,new DBTreeData(_T("KEYF")));
186 Docu
= AppendItem(Folder
,((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->colName
,TreeIc_COL
,TreeIc_COL
,new DBTreeData(Temp1
));
188 SQL_TYPE
.Printf(_T("SQL_C_???? (%d)"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->sqlDataType
);
189 DB_TYPE
.Printf(_T("DB_DATA_TYPE_???? (%d)"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->dbDataType
);
190 for (i
=1;i
<=(pDoc
->db_Br
+i_Which
)->i_SqlTyp
[0];i
++)
192 if (((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->sqlDataType
== (pDoc
->db_Br
+i_Which
)->i_SqlTyp
[i
])
194 SQL_TYPE
.Printf(_T("%s(%d) ; "),(pDoc
->db_Br
+i_Which
)->s_SqlTyp
[i
].c_str(),(pDoc
->db_Br
+i_Which
)->i_SqlTyp
[i
]);
196 } // for (i=1;i<=i_SqlTyp[0];i++)
198 for (i
=1;i
<=(pDoc
->db_Br
+i_Which
)->i_dbTyp
[0];i
++)
200 if (((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->dbDataType
== (pDoc
->db_Br
+i_Which
)->i_dbTyp
[i
])
202 DB_TYPE
.Printf(_T("%s(%d)"),(pDoc
->db_Br
+i_Which
)->s_dbTyp
[i
].c_str(),(pDoc
->db_Br
+i_Which
)->i_dbTyp
[i
]);
204 } // for (i=1;i<=i_dbTyp[0];i++)
207 Funkt
= AppendItem(Docu
,SQL_TYPE
,TreeIc_DocClosed
,TreeIc_DocOpen
,new DBTreeData(SQL_TYPE
));
208 SQL_TYPE
.Printf(_T("%10s %d,%d"),((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->typeName
,
209 ((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->columnLength
,((ct_BrowserDB
->pTableInf
+x
)->pColInf
+y
)->decimalDigits
);
210 Funkt
= AppendItem(Docu
,SQL_TYPE
,TreeIc_DocClosed
,TreeIc_DocOpen
,new DBTreeData(SQL_TYPE
));
211 } // for (y=0;y<(ct_BrowserDB->pTableInf+x)->numCols;y++)
212 } // if ((ct_BrowserDB->pTableInf+x)->pColInf)
214 Folder
= AppendItem(Root
,Temp0
,TreeIc_FolderClosed
,TreeIc_FolderOpen
, new DBTreeData(Temp1
));
219 Temp0
.Printf(_("-I-> DBTree::OnPopulate(%s) - Table %6d (from %d) has been read."),(ct_BrowserDB
->pTableInf
+x
)->tableName
,z
,ct_BrowserDB
->numTables
);
220 pDoc
->p_MainFrame
->SetStatusText(Temp0
, 0);
221 #endif // wxUSE_STATUSBAR
224 } // if ((ct_BrowserDB->pTableInf+x)->tableType == "TABLE" or VIEW)
226 // wxLogMessage(_("\n-I-> if ! TABLE or VIEW >%s<"),(ct_BrowserDB->pTableInf+x)->tableType);
227 } // for (x=0;x<ct_BrowserDB->numTables;x++)
228 } // if (ct_BrowserDB)
230 wxLogMessage(_("\n-E-> DBTree::OnPopulate() : Invalid Catalog Pointer : Failed"));
232 Temp0
.Printf(_("-I-> DBTree::OnPopulate() - %6d Tables have been read. - Time needed : %ld ms"),z
,sw
.Time());
235 pDoc
->p_MainFrame
->SetStatusText(Temp0
, 0);
236 #endif // wxUSE_STATUSBAR
237 } // if((pDoc->db_Br+i_Which)->Initialize(false))
240 wxLogMessage(_("\n-E-> DBTree::OnPopulate() : A valid Pointer could not be created : Failed"));
243 //---------------------------------------------------------------------------------------
245 //---------------------------------------------------------------------------------------
247 popupMenu1
= new wxMenu
;
248 popupMenu1
->Append(DATA_DB
, _("Make wxDB.cpp/h "));
249 popupMenu1
->AppendSeparator();
250 popupMenu1
->Append(DATA_TABLE_ALL
, _("Make all wxTable.cpp/h classes"));
252 popupMenu2
= new wxMenu
;
253 popupMenu2
->Append(DATA_SHOW
, _("Show Data"));
254 popupMenu2
->AppendSeparator();
255 popupMenu2
->Append(DATA_TABLE
, _("Make wxTable.cpp/h "));
256 //---------------------------------------------------------------------------------------
258 } // DBTree::OnPopulate()
260 //----------------------------------------------------------------------------------------
261 void DBTree::OnSelChanged(wxTreeEvent
& WXUNUSED(event
))
266 pDoc
->p_MainFrame
->SetStatusText(Temp0
,0);
267 #endif // wxUSE_STATUSBAR
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 //----------------------------------------------------------------------------------------