Skip site navigation (1) Skip section navigation (2)

pgAdmin III commit: Database Designer (milestone 1 of GSoC 2011)

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin III commit: Database Designer (milestone 1 of GSoC 2011)
Date: 2011-06-27 07:07:52
Message-ID: 201106270707.p5R77qjP063376@gothos.postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
Database Designer (milestone 1 of GSoC 2011)

This patch adds the database designer. This new tool helps users to create
their databases' schema. Lots of things still need to be implemented, but the
raw features are in.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=a8c26ad9f988e1948ffd8d6d3032560ceb437aaa
Author: Luis Ochoa <ziul1979(at)gmail(dot)com>

Modified Files
--------------
pgadmin/Makefile.am                                |    1 +
pgadmin/dd/dditems/figures/ddColumnFigure.cpp      |  458 +++++
pgadmin/dd/dditems/figures/ddColumnKindIcon.cpp    |  418 +++++
pgadmin/dd/dditems/figures/ddColumnOptionIcon.cpp  |  127 ++
.../dd/dditems/figures/ddRelationshipFigure.cpp    |  822 +++++++++
pgadmin/dd/dditems/figures/ddRelationshipItem.cpp  |  112 ++
.../dd/dditems/figures/ddRelationshipTerminal.cpp  |  154 ++
pgadmin/dd/dditems/figures/ddTableFigure.cpp       | 1030 +++++++++++
.../dd/dditems/figures/ddTextTableItemFigure.cpp   |  529 ++++++
pgadmin/dd/dditems/figures/module.mk               |   23 +
.../dd/dditems/handles/ddAddColButtonHandle.cpp    |   78 +
pgadmin/dd/dditems/handles/ddAddFkButtonHandle.cpp |   71 +
.../dditems/handles/ddMinMaxTableButtonHandle.cpp  |   68 +
.../dditems/handles/ddRemoveTableButtonHandle.cpp  |   75 +
pgadmin/dd/dditems/handles/ddScrollBarHandle.cpp   |  127 ++
.../dd/dditems/handles/ddSouthTableSizeHandle.cpp  |   92 +
pgadmin/dd/dditems/handles/module.mk               |   21 +
pgadmin/dd/dditems/locators/ddAddColLocator.cpp    |   41 +
pgadmin/dd/dditems/locators/ddAddFkLocator.cpp     |   41 +
.../dd/dditems/locators/ddMinMaxTableLocator.cpp   |   44 +
.../dd/dditems/locators/ddRemoveTableLocator.cpp   |   44 +
.../dditems/locators/ddScrollBarTableLocator.cpp   |   45 +
.../dd/dditems/locators/ddTableBottomLocator.cpp   |   45 +
pgadmin/dd/dditems/locators/module.mk              |   21 +
pgadmin/dd/dditems/module.mk                       |   19 +
pgadmin/dd/dditems/tools/ddColumnFigureTool.cpp    |  130 ++
pgadmin/dd/dditems/tools/ddColumnTextTool.cpp      |   84 +
pgadmin/dd/dditems/tools/module.mk                 |   17 +
.../dditems/utilities/ddPrecisionScaleDialog.cpp   |  204 +++
.../dd/dditems/utilities/ddSelectKindFksDialog.cpp |  299 ++++
pgadmin/dd/dditems/utilities/ddTableNameDialog.cpp |  229 +++
pgadmin/dd/dditems/utilities/module.mk             |   17 +
pgadmin/dd/ddmodel/ddDatabaseDesign.cpp            |  197 +++
pgadmin/dd/ddmodel/ddDrawingEditor.cpp             |   78 +
pgadmin/dd/ddmodel/ddDrawingView.cpp               |  131 ++
pgadmin/dd/ddmodel/ddTextEditor.cpp                |   64 +
pgadmin/dd/ddmodel/module.mk                       |   19 +
pgadmin/dd/module.mk                               |   18 +
pgadmin/dd/wxhotdraw/connectors/module.mk          |   19 +
.../wxhotdraw/connectors/wxhdChopBoxConnector.cpp  |   81 +
pgadmin/dd/wxhotdraw/connectors/wxhdIConnector.cpp |   66 +
.../wxhotdraw/connectors/wxhdLocatorConnector.cpp  |   60 +
.../connectors/wxhdStickyRectangleConnector.cpp    |   72 +
.../wxhotdraw/figures/defaultAttributes/module.mk  |   19 +
.../defaultAttributes/wxhdFillAttribute.cpp        |   45 +
.../defaultAttributes/wxhdFontAttribute.cpp        |   43 +
.../defaultAttributes/wxhdFontColorAttribute.cpp   |   38 +
.../defaultAttributes/wxhdLineAttribute.cpp        |   43 +
pgadmin/dd/wxhotdraw/figures/module.mk             |   30 +
.../dd/wxhotdraw/figures/wxhdAbstractFigure.cpp    |  134 ++
.../wxhotdraw/figures/wxhdAbstractMenuFigure.cpp   |   59 +
pgadmin/dd/wxhotdraw/figures/wxhdAttribute.cpp     |   34 +
.../dd/wxhotdraw/figures/wxhdAttributeFigure.cpp   |   95 +
pgadmin/dd/wxhotdraw/figures/wxhdBitmapFigure.cpp  |   61 +
.../dd/wxhotdraw/figures/wxhdCompositeFigure.cpp   |  229 +++
.../dd/wxhotdraw/figures/wxhdIConnectionFigure.cpp |   23 +
pgadmin/dd/wxhotdraw/figures/wxhdIFigure.cpp       |  171 ++
.../dd/wxhotdraw/figures/wxhdLineConnection.cpp    |  270 +++
pgadmin/dd/wxhotdraw/figures/wxhdLineTerminal.cpp  |   59 +
.../dd/wxhotdraw/figures/wxhdPolyLineFigure.cpp    |  355 ++++
.../dd/wxhotdraw/figures/wxhdRectangleFigure.cpp   |   52 +
.../dd/wxhotdraw/figures/wxhdSimpleTextFigure.cpp  |  138 ++
pgadmin/dd/wxhotdraw/handles/module.mk             |   23 +
pgadmin/dd/wxhotdraw/handles/wxhdButtonHandle.cpp  |   72 +
.../handles/wxhdChangeConnectionEndHandle.cpp      |   65 +
.../handles/wxhdChangeConnectionHandle.cpp         |  111 ++
.../handles/wxhdChangeConnectionStartHandle.cpp    |   65 +
pgadmin/dd/wxhotdraw/handles/wxhdIHandle.cpp       |   47 +
.../wxhotdraw/handles/wxhdLineConnectionHandle.cpp |   45 +
pgadmin/dd/wxhotdraw/handles/wxhdLocatorHandle.cpp |   53 +
.../dd/wxhotdraw/handles/wxhdPolyLineHandle.cpp    |   77 +
pgadmin/dd/wxhotdraw/locators/module.mk            |   17 +
pgadmin/dd/wxhotdraw/locators/wxhdILocator.cpp     |   27 +
.../dd/wxhotdraw/locators/wxhdPolyLineLocator.cpp  |   49 +
pgadmin/dd/wxhotdraw/main/module.mk                |   18 +
pgadmin/dd/wxhotdraw/main/wxhdDrawing.cpp          |  142 ++
pgadmin/dd/wxhotdraw/main/wxhdDrawingEditor.cpp    |   87 +
pgadmin/dd/wxhotdraw/main/wxhdDrawingView.cpp      |  541 ++++++
pgadmin/dd/wxhotdraw/module.mk                     |   21 +
pgadmin/dd/wxhotdraw/tools/module.mk               |   30 +
pgadmin/dd/wxhotdraw/tools/wxhdAbstractTool.cpp    |   66 +
pgadmin/dd/wxhotdraw/tools/wxhdCanvasMenuTool.cpp  |   83 +
.../dd/wxhotdraw/tools/wxhdCompositeFigureTool.cpp |  121 ++
.../wxhotdraw/tools/wxhdConnectionCreationTool.cpp |  137 ++
pgadmin/dd/wxhotdraw/tools/wxhdCreationTool.cpp    |   70 +
.../dd/wxhotdraw/tools/wxhdDragCreationTool.cpp    |   35 +
pgadmin/dd/wxhotdraw/tools/wxhdDragTrackerTool.cpp |  101 ++
pgadmin/dd/wxhotdraw/tools/wxhdFigureTool.cpp      |  101 ++
.../dd/wxhotdraw/tools/wxhdHandleTrackerTool.cpp   |   46 +
pgadmin/dd/wxhotdraw/tools/wxhdITool.cpp           |   94 +
pgadmin/dd/wxhotdraw/tools/wxhdMenuTool.cpp        |   75 +
.../dd/wxhotdraw/tools/wxhdPolyLineFigureTool.cpp  |   53 +
pgadmin/dd/wxhotdraw/tools/wxhdSelectAreaTool.cpp  |  124 ++
pgadmin/dd/wxhotdraw/tools/wxhdSelectionTool.cpp   |  160 ++
pgadmin/dd/wxhotdraw/tools/wxhdSimpleTextTool.cpp  |  140 ++
pgadmin/dd/wxhotdraw/utilities/module.mk           |   22 +
.../dd/wxhotdraw/utilities/wxhdArrayCollection.cpp |  221 +++
pgadmin/dd/wxhotdraw/utilities/wxhdCollection.cpp  |  111 ++
pgadmin/dd/wxhotdraw/utilities/wxhdGeometry.cpp    |  180 ++
pgadmin/dd/wxhotdraw/utilities/wxhdKeyEvent.cpp    |   36 +
pgadmin/dd/wxhotdraw/utilities/wxhdMouseEvent.cpp  |   99 ++
pgadmin/dd/wxhotdraw/utilities/wxhdPoint.cpp       |   38 +
pgadmin/dd/wxhotdraw/utilities/wxhdRect.cpp        |   83 +
pgadmin/dlg/dlgForeignDataWrapper.cpp              |    2 +-
pgadmin/dlg/dlgForeignServer.cpp                   |    2 +-
pgadmin/dlg/dlgUserMapping.cpp                     |    2 +-
pgadmin/frm/frmDatabaseDesigner.cpp                |  298 ++++
pgadmin/frm/frmMain.cpp                            |    3 +
pgadmin/frm/module.mk                              |    1 +
pgadmin/include/ctl/xh_ctlcolourpicker.h           |    2 +-
.../include/dd/dditems/figures/ddColumnFigure.h    |   91 +
.../include/dd/dditems/figures/ddColumnKindIcon.h  |   70 +
.../dd/dditems/figures/ddColumnOptionIcon.h        |   54 +
.../dd/dditems/figures/ddRelationshipFigure.h      |  105 ++
.../dd/dditems/figures/ddRelationshipItem.h        |   46 +
.../dd/dditems/figures/ddRelationshipTerminal.h    |   34 +
pgadmin/include/dd/dditems/figures/ddTableFigure.h |  121 ++
.../dd/dditems/figures/ddTextTableItemFigure.h     |   84 +
pgadmin/include/dd/dditems/figures/module.mk       |   22 +
.../dd/dditems/handles/ddAddColButtonHandle.h      |   33 +
.../dd/dditems/handles/ddAddFkButtonHandle.h       |   33 +
.../dd/dditems/handles/ddMinMaxTableButtonHandle.h |   35 +
.../dd/dditems/handles/ddRemoveTableButtonHandle.h |   33 +
.../include/dd/dditems/handles/ddScrollBarHandle.h |   46 +
.../dd/dditems/handles/ddSouthTableSizeHandle.h    |   36 +
pgadmin/include/dd/dditems/handles/module.mk       |   21 +
.../include/dd/dditems/locators/ddAddColLocator.h  |   30 +
.../include/dd/dditems/locators/ddAddFkLocator.h   |   30 +
.../dd/dditems/locators/ddMinMaxTableLocator.h     |   30 +
.../dd/dditems/locators/ddRemoveTableLocator.h     |   30 +
.../dd/dditems/locators/ddScrollBarTableLocator.h  |   31 +
.../dd/dditems/locators/ddTableBottomLocator.h     |   31 +
pgadmin/include/dd/dditems/locators/module.mk      |   21 +
pgadmin/include/dd/dditems/module.mk               |   19 +
.../include/dd/dditems/tools/ddColumnFigureTool.h  |   34 +
.../include/dd/dditems/tools/ddColumnTextTool.h    |   33 +
pgadmin/include/dd/dditems/tools/module.mk         |   17 +
pgadmin/include/dd/dditems/utilities/ddDataType.h  |   61 +
.../dd/dditems/utilities/ddPrecisionScaleDialog.h  |   91 +
.../dd/dditems/utilities/ddSelectKindFksDialog.h   |   98 +
.../dd/dditems/utilities/ddTableNameDialog.h       |  102 ++
pgadmin/include/dd/dditems/utilities/module.mk     |   19 +
pgadmin/include/dd/ddmodel/ddDatabaseDesign.h      |   44 +
pgadmin/include/dd/ddmodel/ddDrawingEditor.h       |   36 +
pgadmin/include/dd/ddmodel/ddDrawingView.h         |   25 +
pgadmin/include/dd/ddmodel/ddTextEditor.h          |   35 +
pgadmin/include/dd/ddmodel/module.mk               |   19 +
pgadmin/include/dd/module.mk                       |   18 +
pgadmin/include/dd/wxhotdraw/connectors/module.mk  |   19 +
.../dd/wxhotdraw/connectors/wxhdChopBoxConnector.h |   33 +
.../dd/wxhotdraw/connectors/wxhdIConnector.h       |   41 +
.../dd/wxhotdraw/connectors/wxhdLocatorConnector.h |   40 +
.../connectors/wxhdStickyRectangleConnector.h      |   42 +
.../wxhotdraw/figures/defaultAttributes/module.mk  |   19 +
.../figures/defaultAttributes/wxhdFillAttribute.h  |   27 +
.../figures/defaultAttributes/wxhdFontAttribute.h  |   27 +
.../defaultAttributes/wxhdFontColorAttribute.h     |   29 +
.../figures/defaultAttributes/wxhdLineAttribute.h  |   27 +
pgadmin/include/dd/wxhotdraw/figures/module.mk     |   30 +
.../dd/wxhotdraw/figures/wxhdAbstractFigure.h      |   50 +
.../dd/wxhotdraw/figures/wxhdAbstractMenuFigure.h  |   37 +
.../include/dd/wxhotdraw/figures/wxhdAttribute.h   |   23 +
.../dd/wxhotdraw/figures/wxhdAttributeFigure.h     |   55 +
.../dd/wxhotdraw/figures/wxhdBitmapFigure.h        |   34 +
.../dd/wxhotdraw/figures/wxhdCompositeFigure.h     |   42 +
.../dd/wxhotdraw/figures/wxhdIConnectionFigure.h   |   55 +
pgadmin/include/dd/wxhotdraw/figures/wxhdIFigure.h |   63 +
.../dd/wxhotdraw/figures/wxhdLineConnection.h      |   62 +
.../dd/wxhotdraw/figures/wxhdLineTerminal.h        |   31 +
.../dd/wxhotdraw/figures/wxhdPolyLineFigure.h      |   67 +
.../dd/wxhotdraw/figures/wxhdRectangleFigure.h     |   35 +
.../dd/wxhotdraw/figures/wxhdSimpleTextFigure.h    |   50 +
pgadmin/include/dd/wxhotdraw/handles/module.mk     |   23 +
.../dd/wxhotdraw/handles/wxhdButtonHandle.h        |   41 +
.../handles/wxhdChangeConnectionEndHandle.h        |   30 +
.../wxhotdraw/handles/wxhdChangeConnectionHandle.h |   44 +
.../handles/wxhdChangeConnectionStartHandle.h      |   30 +
pgadmin/include/dd/wxhotdraw/handles/wxhdIHandle.h |   48 +
.../wxhotdraw/handles/wxhdLineConnectionHandle.h   |   25 +
.../dd/wxhotdraw/handles/wxhdLocatorHandle.h       |   39 +
.../dd/wxhotdraw/handles/wxhdPolyLineHandle.h      |   40 +
pgadmin/include/dd/wxhotdraw/locators/module.mk    |   17 +
.../include/dd/wxhotdraw/locators/wxhdILocator.h   |   32 +
.../dd/wxhotdraw/locators/wxhdPolyLineLocator.h    |   31 +
pgadmin/include/dd/wxhotdraw/main/module.mk        |   19 +
pgadmin/include/dd/wxhotdraw/main/wxhdDrawing.h    |   42 +
.../include/dd/wxhotdraw/main/wxhdDrawingEditor.h  |   38 +
.../include/dd/wxhotdraw/main/wxhdDrawingView.h    |  114 ++
pgadmin/include/dd/wxhotdraw/main/wxhdObject.h     |   19 +
pgadmin/include/dd/wxhotdraw/module.mk             |   21 +
pgadmin/include/dd/wxhotdraw/tools/module.mk       |   30 +
.../include/dd/wxhotdraw/tools/wxhdAbstractTool.h  |   42 +
.../dd/wxhotdraw/tools/wxhdCanvasMenuTool.h        |   35 +
.../dd/wxhotdraw/tools/wxhdCompositeFigureTool.h   |   34 +
.../wxhotdraw/tools/wxhdConnectionCreationTool.h   |   38 +
.../include/dd/wxhotdraw/tools/wxhdCreationTool.h  |   36 +
.../dd/wxhotdraw/tools/wxhdDragCreationTool.h      |   26 +
.../dd/wxhotdraw/tools/wxhdDragTrackerTool.h       |   43 +
.../include/dd/wxhotdraw/tools/wxhdFigureTool.h    |   38 +
.../dd/wxhotdraw/tools/wxhdHandleTrackerTool.h     |   40 +
pgadmin/include/dd/wxhotdraw/tools/wxhdITool.h     |   42 +
pgadmin/include/dd/wxhotdraw/tools/wxhdMenuTool.h  |   36 +
.../dd/wxhotdraw/tools/wxhdPolyLineFigureTool.h    |   27 +
.../dd/wxhotdraw/tools/wxhdSelectAreaTool.h        |   38 +
.../include/dd/wxhotdraw/tools/wxhdSelectionTool.h |   37 +
.../dd/wxhotdraw/tools/wxhdSimpleTextTool.h        |   43 +
pgadmin/include/dd/wxhotdraw/utilities/module.mk   |   23 +
.../dd/wxhotdraw/utilities/wxhdArrayCollection.h   |   74 +
.../dd/wxhotdraw/utilities/wxhdCollection.h        |   43 +
.../dd/wxhotdraw/utilities/wxhdCollectionBase.h    |   54 +
.../include/dd/wxhotdraw/utilities/wxhdGeometry.h  |   37 +
.../include/dd/wxhotdraw/utilities/wxhdKeyEvent.h  |   30 +
.../dd/wxhotdraw/utilities/wxhdMouseEvent.h        |   43 +
pgadmin/include/dd/wxhotdraw/utilities/wxhdPoint.h |   23 +
pgadmin/include/dd/wxhotdraw/utilities/wxhdRect.h  |   34 +
pgadmin/include/dlg/dlgForeignDataWrapper.h        |    2 +-
pgadmin/include/dlg/dlgForeignServer.h             |    2 +-
pgadmin/include/dlg/dlgUserMapping.h               |    2 +-
pgadmin/include/frm/frmDatabaseDesigner.h          |   67 +
pgadmin/include/frm/menu.h                         |    4 +
pgadmin/include/images/ddAddColumn.png             |  Bin 0 -> 165 bytes
pgadmin/include/images/ddAddColumnCursor.png       |  Bin 0 -> 612 bytes
pgadmin/include/images/ddAddForeignKey.png         |  Bin 0 -> 173 bytes
pgadmin/include/images/ddDeleteTableCursor.png     |  Bin 0 -> 937 bytes
pgadmin/include/images/ddDown.png                  |  Bin 0 -> 291 bytes
pgadmin/include/images/ddMaximizeTable.png         |  Bin 0 -> 162 bytes
pgadmin/include/images/ddMinMaxCursor.png          |  Bin 0 -> 1569 bytes
pgadmin/include/images/ddMinimizeTable.png         |  Bin 0 -> 159 bytes
pgadmin/include/images/ddRelationshipCursor.png    |  Bin 0 -> 611 bytes
pgadmin/include/images/ddRemoveColumn.png          |  Bin 0 -> 151 bytes
pgadmin/include/images/ddRemoveColumnCursor.png    |  Bin 0 -> 751 bytes
pgadmin/include/images/ddRemoveTable.png           |  Bin 0 -> 178 bytes
pgadmin/include/images/ddRemoveTable2.png          |  Bin 0 -> 759 bytes
pgadmin/include/images/ddUp.png                    |  Bin 0 -> 278 bytes
pgadmin/include/images/ddcancel.png                |  Bin 0 -> 485 bytes
pgadmin/include/images/ddforeignkey.png            |  Bin 0 -> 329 bytes
pgadmin/include/images/ddforeignkeyfromuk.png      |  Bin 0 -> 355 bytes
pgadmin/include/images/ddforeignkeyuniquekey.png   |  Bin 0 -> 361 bytes
.../include/images/ddforeignkeyuniquekeyfromuk.png |  Bin 0 -> 377 bytes
pgadmin/include/images/ddmodel-32.png              |  Bin 0 -> 640 bytes
pgadmin/include/images/ddnotnull.png               |  Bin 0 -> 176 bytes
pgadmin/include/images/ddnull.png                  |  Bin 0 -> 169 bytes
pgadmin/include/images/ddprimaryforeignkey.png     |  Bin 0 -> 367 bytes
.../include/images/ddprimaryforeignkeyfromuk.png   |  Bin 0 -> 386 bytes
pgadmin/include/images/ddprimarykey.png            |  Bin 0 -> 344 bytes
pgadmin/include/images/ddprimarykeyuniquekey.png   |  Bin 0 -> 361 bytes
pgadmin/include/images/ddunique.png                |  Bin 0 -> 241 bytes
pgadmin/include/images/module.mk                   |   14 +
pgadmin/include/ogl/module.mk                      |    2 +-
pgadmin/include/schema/pgForeignDataWrapper.h      |    2 +-
pgadmin/include/schema/pgForeignServer.h           |    2 +-
pgadmin/include/schema/pgUserMapping.h             |    2 +-
pgadmin/include/utils/registry.h                   |    2 +-
pgadmin/ogl/module.mk                              |    2 +-
pgadmin/pgAdmin3.cpp                               |   94 +-
pgadmin/pgAdmin3.vcproj                            | 1850 ++++++++++++++++----
pgadmin/schema/pgForeignDataWrapper.cpp            |    2 +-
pgadmin/schema/pgForeignServer.cpp                 |    2 +-
pgadmin/schema/pgUserMapping.cpp                   |    2 +-
259 files changed, 18089 insertions(+), 404 deletions(-)

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2011-06-27 07:09:36
Subject: Re: First test of the Database Designer
Previous:From: Guillaume LelargeDate: 2011-06-27 06:36:04
Subject: Re: pgAdmin III commit: Rename "Replication" to "Slony Replication"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group