Debian Codegraph @

DatabaseExplorer/ErdPanel.cpp

raw
1 //////////////////////////////////////////////////////////////////////////////
2 //////////////////////////////////////////////////////////////////////////////
3 //
4 // copyright : (C) 2014 Eran Ifrah
5 // file name : ErdPanel.cpp
6 //
7 // -------------------------------------------------------------------------
8 // A
9 // _____ _ _ _ _
10 // / __ \ | | | | (_) |
11 // | / \/ ___ __| | ___| | _| |_ ___
12 // | | / _ \ / _ |/ _ \ | | | __/ _ )
13 // | \__/\ (_) | (_| | __/ |___| | || __/
14 // \____/\___/ \__,_|\___\_____/_|\__\___|
15 //
16 // F i l e
17 //
18 // This program is free software; you can redistribute it and/or modify
19 // it under the terms of the GNU General Public License as published by
20 // the Free Software Foundation; either version 2 of the License, or
21 // (at your option) any later version.
22 //
23 //////////////////////////////////////////////////////////////////////////////
24 //////////////////////////////////////////////////////////////////////////////
25
26 #include "ErdPanel.h"
27 #include "Art.h"
28 #include "databaseexplorer.h"
29 #include "imageexportdialog.h"
30
31 #include <wx/xrc/xmlres.h>
32
33 XS_IMPLEMENT_CLONABLE_CLASS(ErdInfo, xsSerializable)
34
35 ErdInfo::ErdInfo()
36 {
37 m_adapterType = IDbAdapter::atUNKNOWN;
38
39 XS_SERIALIZE_INT(m_adapterType, wxT("adapter_type"));
40 }
41
42 ErdInfo::ErdInfo(const ErdInfo& obj)
43 {
44 m_adapterType = obj.m_adapterType;
45
46 XS_SERIALIZE_INT(m_adapterType, wxT("adapter_type"));
47 }
48
49 ////////////////////////////////////////////////////////////////////////////////
50
51 IMPLEMENT_DYNAMIC_CLASS(ErdPanel, _ErdPanel)
52
53 BEGIN_EVENT_TABLE(ErdPanel, _ErdPanel)
54 EVT_TOOL(XRCID("IDT_OPEN"), ErdPanel::OnLoad)
55 EVT_TOOL(XRCID("IDT_SAVE"), ErdPanel::OnSave)
56 EVT_TOOL(XRCID("IDT_ERD_COMMIT"), ErdPanel::OnCommit)
57 EVT_TOOL(XRCID("IDT_ERD_SAVE_SQL"), ErdPanel::OnSaveSql)
58 EVT_TOOL(XRCID("IDT_ERD_SAVE_IMG"), ErdPanel::OnSaveImg)
59 EVT_TOOL(XRCID("IDT_ERD_ZOOM100"), ErdPanel::OnZoom100)
60 EVT_TOOL(XRCID("IDT_ERD_ZOOMALL"), ErdPanel::OnZoomAll)
61 EVT_TOOL(XRCID("IDT_PRINT"), ErdPanel::OnPrint)
62 EVT_TOOL(XRCID("IDT_PREVIEW"), ErdPanel::OnPreview)
63 EVT_TOOL(XRCID("IDT_COPY"), ErdPanel::OnCopy)
64 EVT_TOOL(XRCID("IDT_CUT"), ErdPanel::OnCut)
65 EVT_TOOL(XRCID("IDT_PASTE"), ErdPanel::OnPaste)
66 EVT_TOOL(XRCID("IDT_UNDO"), ErdPanel::OnUndo)
67 EVT_TOOL(XRCID("IDT_REDO"), ErdPanel::OnRedo)
68 EVT_TOOL(XRCID("IDT_SELECTALL"), ErdPanel::OnSelectAll)
69 EVT_TOOL(XRCID("IDT_ERD_ALIGN_CIRCLE"), ErdPanel::OnAlignCircle)
70 EVT_TOOL(XRCID("IDT_ERD_ALIGN_MESH"), ErdPanel::OnAlignMesh)
71 EVT_TOOL(XRCID("IDT_ERD_ALIGN_VTREE"), ErdPanel::OnAlignVTree)
72 EVT_TOOL(XRCID("IDT_ERD_ALIGN_HTREE"), ErdPanel::OnAlignHTree)
73
74 EVT_UPDATE_UI(XRCID("IDT_COPY"), ErdPanel::OnUpdateCopy)
75 EVT_UPDATE_UI(XRCID("IDT_CUT"), ErdPanel::OnUpdateCut)
76 EVT_UPDATE_UI(XRCID("IDT_PASTE"), ErdPanel::OnUpdatePaste)
77 EVT_UPDATE_UI(XRCID("IDT_UNDO"), ErdPanel::OnUpdateUndo)
78 EVT_UPDATE_UI(XRCID("IDT_REDO"), ErdPanel::OnUpdateRedo)
79 // The following were originally EVT_*_RANGEs, but these won't work with XRCIDs in wx2.9
80 // and only worked by chance in earlier versions: see http://trac.wxwidgets.org/ticket/11431
81 EVT_TOOL(XRCID("IDT_ERD_TOOL"), ErdPanel::OnTool)
82 EVT_TOOL(XRCID("IDT_ERD_TABLE"), ErdPanel::OnTool)
83 EVT_TOOL(XRCID("IDT_ERD_LINE"), ErdPanel::OnTool)
84 EVT_TOOL(XRCID("IDT_ERD_VIEW"), ErdPanel::OnTool)
85
86 EVT_UPDATE_UI(XRCID("IDT_ERD_TOOL"), ErdPanel::OnToolUpdate)
87 EVT_UPDATE_UI(XRCID("IDT_ERD_TABLE"), ErdPanel::OnToolUpdate)
88 EVT_UPDATE_UI(XRCID("IDT_ERD_LINE"), ErdPanel::OnToolUpdate)
89 EVT_UPDATE_UI(XRCID("IDT_ERD_VIEW"), ErdPanel::OnToolUpdate)
90
91 EVT_UPDATE_UI(XRCID("IDT_ERD_COMMIT"), ErdPanel::OnCommitUpdate)
92
93 END_EVENT_TABLE()
94
95 ErdPanel::ErdPanel()
96 : _ErdPanel(NULL)
97 {
98 m_pErdTable = NULL;
99 m_pDbAdapter = NULL;
100 m_pConnections = NULL;
101 }
102
103 ErdPanel::ErdPanel(wxWindow* parent, IDbAdapter* dbAdapter, xsSerializable* pConnections)
104 : _ErdPanel(parent)
105 {
106 m_pErdTable = NULL;
107 m_pDbAdapter = dbAdapter;
108 m_pConnections = pConnections;
109 Init(parent, dbAdapter);
110 }
111
112 ErdPanel::ErdPanel(wxWindow* parent, IDbAdapter* dbAdapter, xsSerializable* pConnections, Table* pTable)
113 : _ErdPanel(parent)
114 {
115 m_pErdTable = NULL;
116 m_pDbAdapter = dbAdapter;
117 m_pConnections = pConnections;
118 Init(parent, dbAdapter);
119 if(pTable) {
120 ErdTable* pErdTab = new ErdTable(pTable);
121 m_diagramManager.AddShape(pErdTab, NULL, wxPoint(10, 10), sfINITIALIZE, sfDONT_SAVE_STATE);
122 pErdTab->UpdateColumns();
123 }
124 }
125
126 ErdPanel::ErdPanel(wxWindow* parent, IDbAdapter* dbAdapter, xsSerializable* pConnections, xsSerializable* pItems)
127 : _ErdPanel(parent)
128 {
129 m_pErdTable = NULL;
130 m_pDbAdapter = dbAdapter;
131 m_pConnections = pConnections;
132 Init(parent, dbAdapter);
133 int i = 10;
134 SerializableList::compatibility_iterator node = pItems->GetFirstChildNode();
135 while(node) {
136 Table* pTable = wxDynamicCast(node->GetData(), Table);
137 if(pTable) {
138 ErdTable* pErdTab = new ErdTable(pTable);
139 m_diagramManager.AddShape(pErdTab, NULL, wxPoint(i, 10), sfINITIALIZE, sfDONT_SAVE_STATE);
140 i += 200;
141 pErdTab->UpdateColumns();
142 }
143 View* pView = wxDynamicCast(node->GetData(), View);
144 if(pView) {
145 ErdView* pErdView = new ErdView(pView);
146 m_diagramManager.AddShape(pErdView, NULL, wxPoint(i, 10), sfINITIALIZE, sfDONT_SAVE_STATE);
147 i += 200;
148 pErdView->UpdateView();
149 }
150 node = node->GetNext();
151 }
152 m_pFrameCanvas->UpdateERD();
153 m_pFrameCanvas->UpdateVirtualSize();
154 }
155
156 ErdPanel::~ErdPanel() { delete m_pDbAdapter; }
157
158 void ErdPanel::Init(wxWindow* parent, IDbAdapter* dbAdapter)
159 {
160
161 SetExtraStyle(wxWS_EX_BLOCK_EVENTS);
162
163 ErdInfo* pInfo = new ErdInfo();
164 pInfo->SetAdapterType(m_pDbAdapter->GetAdapterType());
165 m_diagramManager.SetRootItem(pInfo);
166
167 m_pFrameCanvas = new FrameCanvas(&m_diagramManager, dbAdapter, this, wxID_ANY);
168 GetSizer()->Add( m_pFrameCanvas, 1, wxEXPAND, 5 );
169
170 m_nToolMode = modeDESIGN;
171
172 BitmapLoader* bmpLoader = DatabaseExplorer::GetManager()->GetStdIcons();
173
174 // m_toolBarErd->SetToolBitmapSize(wxSize(16, 16));
175 m_toolBarErd->AddTool(
176 XRCID("IDT_OPEN"), _("Open"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/file_open")), _("Open diagram"));
177 m_toolBarErd->AddTool(
178 XRCID("IDT_SAVE"), _("Save"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/file_save")), _("Save diagram"));
179 m_toolBarErd->AddTool(XRCID("IDT_ERD_SAVE_SQL"), _("Save SQL"), wxBitmap(export_sql_xpm), _("Save SQL"));
180 m_toolBarErd->AddTool(XRCID("IDT_ERD_COMMIT"), _("Commit ERD"), wxBitmap(export_db_xpm), _("Commit ERD"));
181 m_toolBarErd->AddTool(
182 XRCID("IDT_ERD_SAVE_IMG"), _("Export canvas to image"), wxBitmap(export_img_xpm), _("Export canvas to image"));
183 m_toolBarErd->AddSeparator();
184 m_toolBarErd->AddTool(XRCID("IDT_PRINT"), _("Print"), wxBitmap(fileprint_xpm), _("Print diagram"));
185 m_toolBarErd->AddTool(XRCID("IDT_PREVIEW"), _("Preview"), wxBitmap(filepreview_xpm), _("Print preview"));
186 m_toolBarErd->AddSeparator();
187 m_toolBarErd->AddTool(
188 XRCID("IDT_COPY"), _("Copy"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/copy")), _("Copy item"));
189 m_toolBarErd->AddTool(
190 XRCID("IDT_CUT"), _("Cut"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/cut")), _("Cut item"));
191 m_toolBarErd->AddTool(
192 XRCID("IDT_PASTE"), _("Paste"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/paste")), _("Paste item"));
193 m_toolBarErd->AddSeparator();
194 m_toolBarErd->AddTool(
195 XRCID("IDT_UNDO"), _("Undo"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/undo")), _("Undo"));
196 m_toolBarErd->AddTool(
197 XRCID("IDT_REDO"), _("Redo"), bmpLoader->LoadBitmap(wxT("toolbars/16/standard/redo")), _("Redo"));
198 m_toolBarErd->AddSeparator();
199 m_toolBarErd->AddTool(XRCID("IDT_ERD_TOOL"),
200 _("Tool"),
201 wxBitmap(Tool_xpm),
202 wxNullBitmap,
203 wxITEM_RADIO,
204 _("Design tool"),
205 _("Design tool"),
206 NULL);
207 m_toolBarErd->AddTool(XRCID("IDT_ERD_TABLE"),
208 _("DBETable"),
209 bmpLoader->LoadBitmap(wxT("db-explorer/16/table")),
210 wxNullBitmap,
211 wxITEM_RADIO,
212 _("Database table"),
213 _("Database table"),
214 NULL);
215 m_toolBarErd->AddTool(XRCID("IDT_ERD_VIEW"),
216 _("View"),
217 bmpLoader->LoadBitmap(wxT("toolbars/16/search/find")),
218 wxNullBitmap,
219 wxITEM_RADIO,
220 _("Database view"),
221 _("Database view"),
222 NULL);
223 m_toolBarErd->AddTool(XRCID("IDT_ERD_LINE"),
224 _("Constraint 1:N"),
225 bmpLoader->LoadBitmap(wxT("link_editor")),
226 wxNullBitmap,
227 wxITEM_RADIO,
228 _("Foreign key connection"),
229 _("Foreign key connection"),
230 NULL);
231 m_toolBarErd->AddSeparator();
232 m_toolBarErd->AddTool(
233 XRCID("IDT_ERD_ALIGN_CIRCLE"), _("Align into circle"), wxBitmap(AlignCircle_xpm), _("Align into circle"));
234 m_toolBarErd->AddTool(
235 XRCID("IDT_ERD_ALIGN_MESH"), _("Align into mesh"), wxBitmap(AlignMesh_xpm), _("Align into mesh"));
236 m_toolBarErd->AddTool(XRCID("IDT_ERD_ALIGN_VTREE"),
237 _("Align into vertical tree"),
238 wxBitmap(AlignVTree_xpm),
239 _("Align into vertical tree"));
240 m_toolBarErd->AddTool(XRCID("IDT_ERD_ALIGN_HTREE"),
241 _("Align into horizontal tree"),
242 wxBitmap(AlignHTree_xpm),
243 _("Align into horizontal tree"));
244 m_toolBarErd->AddSeparator();
245 m_toolBarErd->AddTool(XRCID("IDT_ERD_ZOOM100"), _("Zoom 100%"), wxBitmap(Zoom100_xpm), _("Zoom 100%"));
246 m_toolBarErd->AddTool(XRCID("IDT_ERD_ZOOMALL"), _("Zoom to all"), wxBitmap(ZoomAll_xpm), _("Zoom to all"));
247 m_toolBarErd->Realize();
248
249 wxAcceleratorEntry entries[4];
250 entries[0].Set(wxACCEL_CTRL, (int)'C', XRCID("IDT_COPY"));
251 entries[1].Set(wxACCEL_CTRL, (int)'X', XRCID("IDT_CUT"));
252 entries[2].Set(wxACCEL_CTRL, (int)'V', XRCID("IDT_PASTE"));
253 entries[3].Set(wxACCEL_CTRL, (int)'A', XRCID("IDT_SELECTALL"));
254 wxAcceleratorTable accel(4, entries);
255 SetAcceleratorTable(accel);
256
257 if (GetSizer()) {
258 GetSizer()->Fit(this);
259 }
260 }
261
262 void ErdPanel::OnTool(wxCommandEvent& event)
263 {
264 if(event.GetId() == XRCID("IDT_ERD_TOOL"))
265 m_nToolMode = modeDESIGN;
266 else if(event.GetId() == XRCID("IDT_ERD_TABLE"))
267 m_nToolMode = modeTABLE;
268 else if(event.GetId() == XRCID("IDT_ERD_LINE"))
269 m_nToolMode = modeLine;
270 else if(event.GetId() == XRCID("IDT_ERD_VIEW"))
271 m_nToolMode = modeVIEW;
272 }
273
274 void ErdPanel::OnToolUpdate(wxUpdateUIEvent& event)
275 {
276 if(event.GetId() == XRCID("IDT_ERD_TOOL"))
277 event.Check(m_nToolMode == modeDESIGN);
278 else if(event.GetId() == XRCID("IDT_ERD_TABLE"))
279 event.Check(m_nToolMode == modeTABLE);
280 else if(event.GetId() == XRCID("IDT_ERD_LINE"))
281 event.Check(m_nToolMode == modeLine);
282 else if(event.GetId() == XRCID("IDT_ERD_VIEW"))
283 event.Check(m_nToolMode == modeVIEW);
284 else
285 event.Skip();
286 }
287
288 void ErdPanel::OnLoad(wxCommandEvent& WXUNUSED(event))
289 {
290 wxFileDialog dlg(this,
291 _("Load canvas from file..."),
292 wxGetCwd(),
293 wxT(""),
294 wxT("ERD Files (*.erd)|*.erd"),
295 wxFD_OPEN | wxFD_FILE_MUST_EXIST);
296
297 if(dlg.ShowModal() == wxID_OK) {
298
299 LoadERD(dlg.GetPath());
300 }
301 }
302
303 void ErdPanel::OnSave(wxCommandEvent& WXUNUSED(event))
304 {
305 wxFileDialog dlg(this,
306 _("Save canvas to file..."),
307 wxGetCwd(),
308 wxT(""),
309 wxT("ERD Files (*.erd)|*.erd"),
310 wxFD_SAVE | wxFD_OVERWRITE_PROMPT);
311
312 if(dlg.ShowModal() == wxID_OK) {
313
314 SaveERD(dlg.GetPath());
315 }
316 }
317
318 void ErdPanel::OnSaveSql(wxCommandEvent& event)
319 {
320 wxFileDialog dlg(this,
321 _("Save SQL create query..."),
322 wxGetCwd(),
323 wxT(""),
324 wxT("SQL Files (*.sql)|*.sql"),
325 wxFD_SAVE | wxFD_OVERWRITE_PROMPT);
326
327 if(dlg.ShowModal() == wxID_OK) {
328 wxTextFile file(dlg.GetPath());
329 if(!file.Exists()) file.Create();
330 file.Open();
331 if(file.IsOpened()) {
332 file.Clear();
333 file.AddLine(wxT("-- SQL script created by DatabaseExplorer "));
334 file.AddLine(wxT(""));
335 file.AddLine(m_pFrameCanvas->GetSqlScript());
336 file.Write(wxTextFileType_None, wxConvUTF8);
337 file.Close();
338 }
339 wxMessageBox(wxString::Format(_("The SQL script has been saved to '%s'."), dlg.GetPath().GetData()),
340 _("DatabaseExplorer"));
341 }
342 }
343
344 void ErdPanel::OnZoom100(wxCommandEvent& event)
345 {
346 m_pFrameCanvas->SetScale(1);
347 m_pFrameCanvas->Refresh(false);
348 }
349
350 void ErdPanel::OnZoomAll(wxCommandEvent& event)
351 {
352 m_pFrameCanvas->SetScaleToViewAll();
353 m_pFrameCanvas->Refresh(false);
354 }
355
356 void ErdPanel::OnPreview(wxCommandEvent& event) { m_pFrameCanvas->PrintPreview(); }
357
358 void ErdPanel::OnPrint(wxCommandEvent& event) { m_pFrameCanvas->Print(); }
359
360 void ErdPanel::OnCopy(wxCommandEvent& event) { m_pFrameCanvas->Copy(); }
361
362 void ErdPanel::OnCut(wxCommandEvent& event) { m_pFrameCanvas->Cut(); }
363
364 void ErdPanel::OnPaste(wxCommandEvent& event)
365 {
366 m_pFrameCanvas->Paste();
367 m_pFrameCanvas->UpdateERD();
368 }
369
370 void ErdPanel::OnUpdateCopy(wxUpdateUIEvent& event) { event.Enable(m_pFrameCanvas->CanCopy()); }
371
372 void ErdPanel::OnUpdateCut(wxUpdateUIEvent& event) { event.Enable(m_pFrameCanvas->CanCut()); }
373
374 void ErdPanel::OnUpdatePaste(wxUpdateUIEvent& event) { event.Enable(m_pFrameCanvas->CanPaste()); }
375
376 void ErdPanel::OnRedo(wxCommandEvent& event)
377 {
378 m_pFrameCanvas->Redo();
379 m_pFrameCanvas->UpdateERD();
380 }
381
382 void ErdPanel::OnUndo(wxCommandEvent& event)
383 {
384 m_pFrameCanvas->Undo();
385 m_pFrameCanvas->UpdateERD();
386 }
387
388 void ErdPanel::OnUpdateRedo(wxUpdateUIEvent& event) { event.Enable(m_pFrameCanvas->CanRedo()); }
389
390 void ErdPanel::OnUpdateUndo(wxUpdateUIEvent& event) { event.Enable(m_pFrameCanvas->CanUndo()); }
391
392 void ErdPanel::OnSaveImg(wxCommandEvent& event)
393 {
394 static wxString prevPath;
395 static wxBitmapType prevType;
396
397 ImageExportDialog dlg(this);
398 dlg.SetPath(prevPath);
399 dlg.SetBitmapType(prevType);
400
401 if(dlg.ShowModal() == wxID_OK) {
402 prevPath = dlg.GetPath();
403 prevType = dlg.GetBitmapType();
404 m_pFrameCanvas->SaveCanvasToImage(dlg.GetPath(), dlg.GetBitmapType(), dlg.GetExportCanvas(), dlg.GetScale());
405 }
406 }
407
408 void ErdPanel::OnAlignCircle(wxCommandEvent& event)
409 {
410 wxSFAutoLayout layout;
411 layout.Layout(m_pFrameCanvas, wxT("Circle"));
412 m_pFrameCanvas->SaveCanvasState();
413 }
414
415 void ErdPanel::OnAlignHTree(wxCommandEvent& event)
416 {
417 wxSFAutoLayout layout;
418 layout.Layout(m_pFrameCanvas, wxT("Horizontal Tree"));
419 m_pFrameCanvas->SaveCanvasState();
420 }
421
422 void ErdPanel::OnAlignMesh(wxCommandEvent& event)
423 {
424 wxSFAutoLayout layout;
425 layout.Layout(m_pFrameCanvas, wxT("Mesh"));
426 m_pFrameCanvas->SaveCanvasState();
427 }
428
429 void ErdPanel::OnAlignVTree(wxCommandEvent& event)
430 {
431 wxSFAutoLayout layout;
432 layout.Layout(m_pFrameCanvas, wxT("Vertical Tree"));
433 m_pFrameCanvas->SaveCanvasState();
434 }
435
436 void ErdPanel::OnCommit(wxCommandEvent& event)
437 {
438 if(m_pConnections) {
439 ErdCommitWizard wizard(this, m_pConnections, m_pFrameCanvas->GetSqlScript());
440 wizard.RunWizard(wizard.GetFirstPage());
441 DatabaseExplorer::GetViewerPanel()->RefreshDbView();
442 }
443 }
444
445 void ErdPanel::OnPageClosing(wxBookCtrlEvent& event)
446 {
447 wxMessageBox(wxT("Event Veto"));
448 event.Veto();
449 }
450
451 bool ErdPanel::LoadERD(const wxString& path)
452 {
453 m_diagramManager.GetRootItem()->RemoveChildren();
454
455 if(m_diagramManager.DeserializeFromXml(path)) {
456 ErdInfo* pInfo = wxDynamicCast(m_diagramManager.GetRootItem(), ErdInfo);
457 if(pInfo && (pInfo->GetAdapterType() == m_pDbAdapter->GetAdapterType())) {
458 m_pFrameCanvas->UpdateERD();
459 m_pFrameCanvas->Refresh();
460
461 return true;
462 } else {
463 m_diagramManager.GetRootItem()->RemoveChildren();
464 wxMessageBox(_("ERD type doesn't match current database adapter."), _("DB Error"), wxICON_ERROR | wxOK);
465
466 m_pFrameCanvas->Refresh();
467
468 return false;
469 }
470 }
471
472 return false;
473 }
474
475 bool ErdPanel::SaveERD(const wxString& path)
476 {
477 if(m_diagramManager.SerializeToXml(path, xsWITH_ROOT)) {
478 wxMessageBox(wxString::Format(_("The chart has been saved to '%s'."), path.c_str()), _("DatabaseExplorer"));
479
480 return true;
481 } else
482 return false;
483 }
484
485 void ErdPanel::OnSelectAll(wxCommandEvent& evt)
486 {
487 m_pFrameCanvas->SelectAll();
488 }
489
490 void ErdPanel::OnCommitUpdate(wxUpdateUIEvent& event)
491 {
492 event.Enable( (m_pDbAdapter != NULL) && m_pDbAdapter->IsConnected() );
493 }