////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////// // // copyright : (C) 2014 Eran Ifrah // file name : FrameCanvas.cpp // // ------------------------------------------------------------------------- // A // _____ _ _ _ _ // / __ \ | | | | (_) | // | / \/ ___ __| | ___| | _| |_ ___ // | | / _ \ / _ |/ _ \ | | | __/ _ ) // | \__/\ (_) | (_| | __/ |___| | || __/ // \____/\___/ \__,_|\___\_____/_|\__\___| // // F i l e // // This program is free software; you can redistribute it and/or modify // it under the terms of the GNU General Public License as published by // the Free Software Foundation; either version 2 of the License, or // (at your option) any later version. // ////////////////////////////////////////////////////////////////////////////// ////////////////////////////////////////////////////////////////////////////// #include "CreateForeignKey.h" #include "FrameCanvas.h" #include "ErdTable.h" #include "ErdView.h" #include FrameCanvas::FrameCanvas(wxSFDiagramManager* manager,IDbAdapter* dbAdapter, wxPanel* parentPanel, wxWindowID id): wxSFShapeCanvas(manager, parentPanel, id, wxDefaultPosition, wxDefaultSize, wxHSCROLL | wxVSCROLL | wxSTATIC_BORDER) { m_pParentPanel = (ErdPanel*) parentPanel; m_pDbAdapter = dbAdapter; GetHistoryManager().SetMode(wxSFCanvasHistory::histUSE_SERIALIZATION); GetHistoryManager().SetHistoryDepth(20); AddStyle(sfsGRADIENT_BACKGROUND); SetGradientFrom( wxColour(230, 230, 230) ); SetGradientTo( wxColour(255, 255, 255) ); SetHoverColour( wxColour(200, 200, 200) ); AddStyle(sfsGRID_USE); AddStyle(sfsGRID_SHOW); SetGridLineMult( 10 ); #ifdef __WXMSW__ SetGridStyle( wxDOT ); #else SetGridStyle( wxSHORT_DASH ); #endif AddStyle(sfsPROCESS_MOUSEWHEEL); SetMinScale(0.2); SetMaxScale(2); GetDiagramManager()->ClearAcceptedShapes(); GetDiagramManager()->AcceptShape(wxT("All")); SaveCanvasState(); } FrameCanvas::~FrameCanvas() { } void FrameCanvas::UpdateERD() { ShapeList lstShapes; GetDiagramManager()->GetShapes( CLASSINFO(ErdTable), lstShapes ); for( ShapeList::iterator it = lstShapes.begin(); it != lstShapes.end(); ++it ) { ((ErdTable*)*it)->UpdateColumns(); } lstShapes.Clear(); GetDiagramManager()->GetShapes( CLASSINFO(ErdView), lstShapes ); for( ShapeList::iterator it = lstShapes.begin(); it != lstShapes.end(); ++it ) { ((ErdView*)*it)->UpdateView(); } UpdateVirtualSize(); Refresh( false ); } void FrameCanvas::OnConnectionFinished(wxSFLineShape* connection) { m_pParentPanel->SetToolMode(ErdPanel::modeDESIGN); return; } void FrameCanvas::OnLeftDown(wxMouseEvent& event) { wxSFShapeBase* pShape = NULL; switch(m_pParentPanel->GetToolMode()) { case ErdPanel::modeTABLE: { pShape = GetDiagramManager()->AddShape(new ErdTable(), NULL, event.GetPosition(), sfINITIALIZE, sfDONT_SAVE_STATE); if (pShape) { pShape->AcceptConnection(wxT("All")); pShape->AcceptSrcNeighbour(wxT("All")); pShape->AcceptTrgNeighbour(wxT("All")); Table* tab = new Table(); tab->SetName(wxT("NewTable")); pShape->SetUserData(tab); ((ErdTable*)pShape)->UpdateColumns(); pShape->Refresh(); SaveCanvasState(); } } break; case ErdPanel::modeLine: { if (GetMode() == modeREADY) { ErdTable* pTab = wxDynamicCast(GetShapeUnderCursor()->GetGrandParentShape(), ErdTable); if (pTab){ wxSFTextShape* pText = wxDynamicCast(GetShapeUnderCursor(),wxSFTextShape); if (pText) { m_srcCol = pText->GetText().substr(3); } else m_srcCol = wxT(""); StartInteractiveConnection(CLASSINFO(wxSFOrthoLineShape), event.GetPosition()); } } else wxSFShapeCanvas::OnLeftDown(event); } break; case ErdPanel::modeVIEW: { pShape = GetDiagramManager()->AddShape(new ErdView(), NULL, event.GetPosition(), sfINITIALIZE, sfDONT_SAVE_STATE); if (pShape) { pShape->AcceptConnection(wxT("All")); pShape->AcceptSrcNeighbour(wxT("All")); pShape->AcceptTrgNeighbour(wxT("All")); View* view = new View(); view->SetName(_("New view")); view->SetSelect(wxT("SELECT * FROM table")); pShape->SetUserData(view); ((ErdView*)pShape)->UpdateView(); pShape->Refresh(); SaveCanvasState(); } } break; default: // do default actions wxSFShapeCanvas::OnLeftDown(event); } if( pShape ) { if(!event.ControlDown()) { m_pParentPanel->SetToolMode(ErdPanel::modeDESIGN); } } } void FrameCanvas::OnRightDown(wxMouseEvent& event) { wxSFShapeCanvas::OnRightDown(event); m_mousePos = event.GetPosition(); wxMenu mnu; mnu.Connect(wxEVT_COMMAND_MENU_SELECTED, (wxObjectEventFunction)&FrameCanvas::OnPopupClick, NULL, this); mnu.Append(XRCID("IDR_POPUP_COPY"), _("Copy"))->Enable(CanCopy()); mnu.Append(XRCID("IDR_POPUP_CUT"), _("Cut"))->Enable(CanCut()); mnu.Append(XRCID("IDR_POPUP_PASTE"), _("Paste"))->Enable(CanPaste()); mnu.AppendSeparator(); mnu.Append(XRCID("IDR_POPUP_NEW_TABLE"), _("Add new ERD table")); mnu.Append(XRCID("IDR_POPUP_NEW_VIEW"), _("Add new ERD view")); mnu.AppendSeparator(); mnu.Append(XRCID("IDR_POPUP_FULL_SQL"), _("Copy diagram SQL to the clipboard")); m_pSelectedShape = GetShapeUnderCursor(); if (m_pSelectedShape) { ErdTable* table = wxDynamicCast(m_pSelectedShape->GetGrandParentShape(), ErdTable); if (table) { //mnu.AppendSeparator(); //mnu.Append(XRCID("IDR_POPUP_MI1"), _("Add column to table")); mnu.AppendSeparator(); mnu.Append(XRCID("IDR_POPUP_NEW_KEY"), _("Create foreign key for table")); mnu.Append(XRCID("IDR_POPUP_MI3"), _("Create view for table")); mnu.AppendSeparator(); mnu.Append(XRCID("IDR_POPUP_MI2"), _("Copy table SQL to the clipboard")); } } PopupMenu(&mnu); } void FrameCanvas::OnKeyDown(wxKeyEvent& event) { wxSFShapeCanvas::OnKeyDown(event); event.Skip(); } void FrameCanvas::OnPopupClick(wxCommandEvent &evt) { //void *data=static_cast(evt.GetEventObject())->GetClientData(); if (evt.GetId() == XRCID("IDR_POPUP_MI1")) { ErdTable* table = wxDynamicCast(m_pSelectedShape->GetGrandParentShape(), ErdTable); if (table) { table->AddColumn(_("newcol"),m_pDbAdapter->GetDbTypeByUniversalName(IDbType::dbtTYPE_INT)); table->UpdateColumns(); table->Refresh(); SaveCanvasState(); } }else if (evt.GetId() == XRCID("IDR_POPUP_MI2")) { bool dropTable = ( wxMessageBox( _("Add drop table statement?"),_("SQL export"),wxYES_NO ) == wxYES ); if (wxTheClipboard->Open()) { ErdTable* table = wxDynamicCast(m_pSelectedShape->GetGrandParentShape(), ErdTable); if (table) { wxTheClipboard->SetData(new wxTextDataObject(m_pDbAdapter->GetCreateTableSql(table->GetTable(), dropTable))); } wxTheClipboard->Close(); wxMessageBox( _("SQL command has been copied to the clipboard."), _("SQL export"), wxICON_INFORMATION | wxOK ); } }else if (evt.GetId() == XRCID("IDR_POPUP_MI3")) { ErdTable* table = wxDynamicCast(m_pSelectedShape->GetGrandParentShape(), ErdTable); if (table) { Table* pTab = table->GetTable(); wxPoint point(round(table->GetAbsolutePosition().x), round(table->GetAbsolutePosition().y)); point.x = table->GetRectSize().x + 10; ErdView* pView = (ErdView*) GetDiagramManager()->AddShape(new ErdView(), NULL, point, sfINITIALIZE, sfDONT_SAVE_STATE); if (pView) { View* view = new View(); view->SetName(pTab->GetName()+wxT("VW")); view->SetParentName(pTab->GetParentName()); view->SetSelect(m_pDbAdapter->GetDefaultSelect(pTab->GetParentName(),pTab->GetName())); pView->SetUserData(view); pView->UpdateView(); pView->Refresh(); SaveCanvasState(); } } }else if (evt.GetId() == XRCID("IDR_POPUP_COPY")){ Copy(); }else if (evt.GetId() == XRCID("IDR_POPUP_CUT")){ Cut(); }else if (evt.GetId() == XRCID("IDR_POPUP_PASTE")){ Paste(); UpdateERD(); }else if (evt.GetId() == XRCID("IDR_POPUP_NEW_TABLE")){ wxSFShapeBase* pShape = GetDiagramManager()->AddShape(new ErdTable(), NULL, m_mousePos, sfINITIALIZE, sfDONT_SAVE_STATE); //pShape = GetDiagramManager()->AddShape(CLASSINFO(wxSFRoundRectShape), event.GetPosition(), sfDONT_SAVE_STATE); if (pShape) { pShape->AcceptConnection(wxT("All")); pShape->AcceptSrcNeighbour(wxT("All")); pShape->AcceptTrgNeighbour(wxT("All")); Table* tab = new Table(); tab->SetName(wxT("NewTable")); pShape->SetUserData(tab); ((ErdTable*)pShape)->UpdateColumns(); pShape->Refresh(); SaveCanvasState(); } }else if (evt.GetId() == XRCID("IDR_POPUP_NEW_VIEW")){ wxSFShapeBase* pShape = GetDiagramManager()->AddShape(new ErdView(), NULL, m_mousePos, sfINITIALIZE, sfDONT_SAVE_STATE); if (pShape) { pShape->AcceptConnection(wxT("All")); pShape->AcceptSrcNeighbour(wxT("All")); pShape->AcceptTrgNeighbour(wxT("All")); View* view = new View(); view->SetName(wxT("New view")); view->SetSelect(wxT("SELECT * FROM table")); pShape->SetUserData(view); ((ErdView*)pShape)->UpdateView(); pShape->Refresh(); SaveCanvasState(); } }else if (evt.GetId() == XRCID("IDR_POPUP_NEW_KEY")){ if (GetMode() == modeREADY) { wxSFTextShape* pText = wxDynamicCast(m_pSelectedShape,wxSFTextShape); if (pText) { m_srcCol = pText->GetText().substr(3); } else m_srcCol = wxT(""); StartInteractiveConnection(CLASSINFO(wxSFOrthoLineShape), m_mousePos); } }else if (evt.GetId() == XRCID("IDR_POPUP_FULL_SQL")) { if (wxTheClipboard->Open()) { wxTheClipboard->SetData(new wxTextDataObject(GetSqlScript())); wxTheClipboard->Close(); wxMessageBox( _("SQL command has been copied to the clipboard."), _("SQL export"), wxICON_INFORMATION | wxOK ); } } } void FrameCanvas::OnLeftDoubleClick(wxMouseEvent& event) { wxSFShapeBase* sp = GetShapeUnderCursor(); if (sp) { ErdTable* table = wxDynamicCast(sp->GetGrandParentShape(),ErdTable); if (table) { if (table->GetTable() ) { TableSettings settingDialog(this, m_pDbAdapter, table->GetTable(), (wxSFDiagramManager*)table->GetParentManager()); settingDialog.ShowModal(); table->UpdateColumns(); Refresh(false); SaveCanvasState(); } } ErdView* view = wxDynamicCast(sp->GetGrandParentShape(), ErdView); if (view) { if (view->GetView()) { ViewSettings settingDialog(this,m_pDbAdapter); settingDialog.SetView(view->GetView(),(wxSFDiagramManager*) view->GetParentManager() ); settingDialog.ShowModal(); view->UpdateView(); Refresh(false); SaveCanvasState(); } } } wxSFShapeCanvas::OnLeftDoubleClick(event); } void FrameCanvas::OnDrop(wxCoord x, wxCoord y, wxDragResult def, const ShapeList& dropped) { ShapeList::compatibility_iterator node = dropped.GetFirst(); dndTableShape* dndTab = NULL; wxSFShapeBase* pShape = NULL; while( node ) { dndTab = wxDynamicCast(node->GetData(),dndTableShape); node = node->GetNext(); } if (dndTab) { if (dndTab->GetUserData()->IsKindOf(CLASSINFO(Table))) { m_pDbAdapter->ConvertTable((Table*) dndTab->GetUserData()); pShape = GetDiagramManager()->AddShape(new ErdTable((Table* ) dndTab->GetUserData()), NULL, wxPoint( x,y), sfINITIALIZE, sfDONT_SAVE_STATE); } if (dndTab->GetUserData()->IsKindOf(CLASSINFO(View))) { pShape = GetDiagramManager()->AddShape(new ErdView((View* ) dndTab->GetUserData()), NULL, wxPoint( x,y), sfINITIALIZE, sfDONT_SAVE_STATE); } if (pShape) { pShape->AcceptConnection(wxT("All")); pShape->AcceptSrcNeighbour(wxT("All")); pShape->AcceptTrgNeighbour(wxT("All")); //pShape->Update(); SaveCanvasState(); } dndTab->SetUserData(NULL); GetDiagramManager()->RemoveShape(dndTab); } else { SaveCanvasState(); } UpdateERD(); } wxString FrameCanvas::GetSqlScript() { wxString retStr = wxT(""); ShapeList lstShapes; GetDiagramManager()->GetShapes( CLASSINFO(ErdTable), lstShapes ); ShapeList::compatibility_iterator node = lstShapes.GetFirst(); while( node ) { ErdTable* tab = wxDynamicCast(node->GetData(),ErdTable); if (tab) { retStr.append(m_pDbAdapter->GetCreateTableSql(tab->GetTable(),true)); } node = node->GetNext(); } lstShapes.Clear(); GetDiagramManager()->GetShapes( CLASSINFO(ErdView), lstShapes ); node = lstShapes.GetFirst(); while( node ) { ErdView* view = wxDynamicCast(node->GetData(),ErdView); if (view) { retStr.append(m_pDbAdapter->GetCreateViewSql(view->GetView(),true)); } node = node->GetNext(); } lstShapes.Clear(); GetDiagramManager()->GetShapes( CLASSINFO(ErdTable), lstShapes ); node = lstShapes.GetFirst(); while( node ) { ErdTable* tab = wxDynamicCast(node->GetData(),ErdTable); if (tab) { retStr.append(m_pDbAdapter->GetAlterTableConstraintSql(tab->GetTable())); } node = node->GetNext(); } return retStr; } wxSFShapeCanvas::PRECONNECTIONFINISHEDSTATE FrameCanvas::OnPreConnectionFinished(wxSFLineShape* connection) { wxSFTextShape* pText = wxDynamicCast(GetShapeUnderCursor(), wxSFTextShape); if (pText) { m_dstCol = pText->GetText().substr(3); } ErdTable *pSrcT = wxDynamicCast(GetDiagramManager()->GetItem(connection->GetSrcShapeId()),ErdTable); ErdTable *pTrgT = wxDynamicCast(GetDiagramManager()->GetItem(connection->GetTrgShapeId()),ErdTable); if( pSrcT && pTrgT ) { CreateForeignKey dlg(this, pSrcT, pTrgT, m_srcCol, m_dstCol); dlg.ShowModal(); } m_pParentPanel->SetToolMode(ErdPanel::modeDESIGN); return pfsFAILED_AND_CANCEL_LINE; } void FrameCanvas::OnPaste(const ShapeList& pasted) { ShapeList::compatibility_iterator node = pasted.GetFirst(); while( node ) { ErdTable* tab = wxDynamicCast(node->GetData(), ErdTable); if (tab) m_pDbAdapter->ConvertTable(tab->GetTable()); node = node->GetNext(); } wxSFShapeCanvas::OnPaste(pasted); }