Database Visualization

VGirish

Rate me:

4.60/5 (11 votes)

31 May 20067 min read

82K

2.8K

This article aims to create a simple tool for visualizing database tables and relations, a database map to refer to.

src.zip
- src
  - DBConnectionDlg.cpp
  - DBConnectionDlg.h
  - GenerateCodeDlg.cpp
  - GenerateCodeDlg.h
  - Globals.h
  - ListboxEx.cpp
  - ListboxEx.h
  - msado15.tlh
  - msado15.tli
  - QueryBuilder.clw
  - QueryBuilder.cpp
  - QueryBuilder.dsp
  - QueryBuilder.dsw
  - QueryBuilder.exe
  - QueryBuilder.h
  - QueryBuilder.rc
  - QueryBuilder.sln
  - QueryBuilder.vcproj
  - res
    - default1.bin
    - ListIcons.bmp
    - logo.bmp
    - Manifest
    - msado15.tlh
    - msado15.tli
    - QueryBuilder.ico
    - QueryBuilder.rc2
  - Resource.h
  - SelectColumnsDlg.cpp
  - SelectColumnsDlg.h
  - SelectRelationsDlg.cpp
  - SelectRelationsDlg.h
  - SQLInfoEnumerator.cpp
  - SQLInfoEnumerator.h
  - StdAfx.cpp
  - StdAfx.h
  - Visualization.cpp
  - Visualization.h
  - WinGraphviz.h
wingraphviz.zip
- WinGraphViz
  - dotguide.pdf
  - WinGraphviz.h
  - WinGraphviz_v1.02.20.cab
  - WinGraphviz_v1.02.20.msi
  - WinGraphviz_v1.02.24.cab
  - WinGraphviz_v1.02.24.msi
  - WinGraphviz_v1.02.25s.cab

// Microsoft Visual C++ generated resource script.
//
#include "resource.h"

#define APSTUDIO_READONLY_SYMBOLS
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 2 resource.
//
#include "afxres.h"

/////////////////////////////////////////////////////////////////////////////
#undef APSTUDIO_READONLY_SYMBOLS

/////////////////////////////////////////////////////////////////////////////
// English (U.S.) resources

#if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_ENU)
#ifdef _WIN32
LANGUAGE LANG_ENGLISH, SUBLANG_ENGLISH_US
#pragma code_page(1252)
#endif //_WIN32

#ifdef APSTUDIO_INVOKED
/////////////////////////////////////////////////////////////////////////////
//
// TEXTINCLUDE
//

1 TEXTINCLUDE 
BEGIN
    "resource.h\0"
END

2 TEXTINCLUDE 
BEGIN
    "#include ""afxres.h""\r\n"
    "\0"
END

3 TEXTINCLUDE 
BEGIN
    "#define _AFX_NO_SPLITTER_RESOURCES\r\n"
    "#define _AFX_NO_OLE_RESOURCES\r\n"
    "#define _AFX_NO_TRACKER_RESOURCES\r\n"
    "#define _AFX_NO_PROPERTY_RESOURCES\r\n"
    "\r\n"
    "#if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_ENU)\r\n"
    "#ifdef _WIN32\r\n"
    "LANGUAGE 9, 1\r\n"
    "#pragma code_page(1252)\r\n"
    "#endif //_WIN32\r\n"
    "#include ""res\\QueryBuilder.rc2""  // non-Microsoft Visual C++ edited resources\r\n"
    "#include ""afxres.rc""         // Standard components\r\n"
    "#endif\r\n"
    "\0"
END

#endif    // APSTUDIO_INVOKED


/////////////////////////////////////////////////////////////////////////////
//
// Icon
//

// Icon with lowest ID value placed first to ensure application icon
// remains consistent on all systems.
IDR_MAINFRAME           ICON                    "res\\QueryBuilder.ico"

/////////////////////////////////////////////////////////////////////////////
//
// Dialog
//

IDD_DLG_DB_CONNECTION DIALOGEX 0, 0, 300, 201
STYLE DS_SETFONT | WS_CHILD | WS_CAPTION
CAPTION "Step 1 of 4 : Database connection"
FONT 8, "MS Sans Serif", 0, 0, 0x1
BEGIN
    COMBOBOX        IDC_CMB_SERVERS,101,31,136,127,CBS_DROPDOWNLIST | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    PUSHBUTTON      "Refresh server list",IDC_BTN_REFRESH_SERVER_LIST,130,52,
                    78,14
    LTEXT           "Server",IDC_STATIC,72,33,22,8
    EDITTEXT        IDC_EDITUSERID,101,96,136,12,ES_AUTOHSCROLL
    EDITTEXT        IDC_EDITPASSWORD,101,114,136,12,ES_PASSWORD | 
                    ES_AUTOHSCROLL
    LTEXT           "Password",IDC_STATIC,62,116,32,8
    LTEXT           "User ID",IDC_STATIC,69,98,25,8
    PUSHBUTTON      "Connect to server",IDC_BTN_CONNECT,130,134,78,14
    COMBOBOX        IDC_COMBODATABASES,101,165,136,51,CBS_DROPDOWNLIST | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    LTEXT           "Database",IDC_STATIC,62,167,32,8
    CONTROL         137,IDC_STATIC_WEB_LINK,"Static",SS_BITMAP,0,0,120,10,
                    WS_EX_STATICEDGE
    LTEXT           "Developed by V.Girish",IDC_STATIC,220,193,79,8
END

IDD_DLG_SELECT_COLUMNS DIALOGEX 0, 0, 300, 201
STYLE DS_SETFONT | WS_CHILD | WS_CAPTION
CAPTION "Step 2 of 4 : Select the required columns from the required tables"

FONT 8, "MS Sans Serif", 0, 0, 0x1
BEGIN
    COMBOBOX        IDC_COMBO_TABLE,35,34,106,121,CBS_DROPDOWNLIST | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_COLUMN,183,34,106,121,CBS_DROPDOWNLIST | 
                    WS_VSCROLL | WS_TABSTOP
    PUSHBUTTON      "Add column to list",IDC_BTN_ADD_COLUMN,35,61,82,14
    LISTBOX         IDC_LIST_SELECTED_COLUMNS,7,98,286,87,
                    LBS_NOINTEGRALHEIGHT | NOT WS_BORDER | WS_VSCROLL | 
                    WS_HSCROLL | WS_TABSTOP,WS_EX_STATICEDGE
    PUSHBUTTON      "Clear All",IDC_BTN_CLEAR_ALL_SEL_COLUMNS,236,61,53,14
    LTEXT           "Table",IDC_STATIC,11,36,19,8
    LTEXT           "Column",IDC_STATIC,155,36,24,8
    CONTROL         137,IDC_STATIC_WEB_LINK,"Static",SS_BITMAP,0,0,120,11,
                    WS_EX_STATICEDGE
    CONTROL         "",IDC_BTN_LIST_BUDDY,"Button",BS_OWNERDRAW | WS_TABSTOP,
                    7,85,286,14,WS_EX_STATICEDGE
    LTEXT           "Developed by V.Girish",IDC_STATIC,220,193,79,8
END

IDD_DLG_SELECT_RELATIONS DIALOGEX 0, 0, 300, 201
STYLE DS_SETFONT | WS_CHILD | WS_CAPTION
CAPTION "Step 3 of 4 : Select the relationships and order them properly"
FONT 8, "MS Sans Serif", 0, 0, 0x1
BEGIN
    COMBOBOX        IDC_COMBO_TABLE_ONE,41,26,96,121,CBS_DROPDOWNLIST | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_TABLE_TWO,192,26,96,121,CBS_DROPDOWNLIST | 
                    CBS_SORT | WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_COLUMN_ONE,41,42,96,121,CBS_DROPDOWNLIST | 
                    WS_VSCROLL | WS_TABSTOP
    COMBOBOX        IDC_COMBO_COLUMN_TWO,192,42,96,121,CBS_DROPDOWNLIST | 
                    WS_VSCROLL | WS_TABSTOP
    PUSHBUTTON      "Add Relation",IDC_BTN_ADD_RELATION,41,61,82,14
    LISTBOX         IDC_LIST_RELATIONS,7,98,286,87,LBS_NOINTEGRALHEIGHT | 
                    NOT WS_BORDER | WS_VSCROLL | WS_HSCROLL | WS_TABSTOP,
                    WS_EX_STATICEDGE
    PUSHBUTTON      "Clear All",IDC_BTN_CLEAR_ALL_RELATIONS,235,61,53,14
    LTEXT           "Table 1",IDC_STATIC,14,28,25,8
    LTEXT           "Table 2",IDC_STATIC,164,28,25,8
    LTEXT           "Column 1",IDC_STATIC,9,44,30,8
    LTEXT           "Column 2",IDC_STATIC,159,44,30,8
    CONTROL         137,IDC_STATIC_WEB_LINK,"Static",SS_BITMAP,0,0,120,10,
                    WS_EX_STATICEDGE
    CONTROL         "",IDC_BTN_LIST_BUDDY,"Button",BS_OWNERDRAW | WS_TABSTOP,
                    7,85,286,14,WS_EX_STATICEDGE
    LTEXT           "Developed by V.Girish",IDC_STATIC,220,193,79,8
END

IDD_DLG_GENERATE_CODE DIALOGEX 0, 0, 300, 201
STYLE DS_SETFONT | WS_CHILD | WS_CAPTION
CAPTION "Step 4 of 4 : Generate the SQL script and the Visualization"
FONT 8, "MS Sans Serif", 0, 0, 0x1
BEGIN
    PUSHBUTTON      "Generate Diagram ...",IDC_BTN_CREATE_DIAGRAM,48,92,87,
                    14
    LTEXT           "Comments",IDC_STATIC,48,24,34,8
    EDITTEXT        IDC_EDIT_COMMENTS,48,36,207,12,ES_AUTOHSCROLL
    CONTROL         "Show Generated Query File",IDC_CHECK_SHOW_QUERY,"Button",
                    BS_AUTOCHECKBOX | WS_TABSTOP,143,66,103,10
    CONTROL         "Show Generated Diagram",IDC_CHECK_SHOW_DIAGRAM,"Button",
                    BS_AUTOCHECKBOX | WS_TABSTOP,143,94,97,10
    CONTROL         137,IDC_STATIC_WEB_LINK,"Static",SS_BITMAP,0,0,101,11,
                    WS_EX_STATICEDGE
    COMBOBOX        IDC_COMBO_IMAGE_FORMAT,90,140,45,69,CBS_DROPDOWNLIST | 
                    WS_VSCROLL | WS_TABSTOP
    LTEXT           "Image Type",IDC_STATIC,48,142,38,8
    GROUPBOX        "Image Options",IDC_STATIC,7,124,286,62
    CONTROL         "Show Relationship Labels",IDC_CHECK_SHOW_LABELS,"Button",
                    BS_AUTOCHECKBOX | WS_TABSTOP,48,167,97,10
    PUSHBUTTON      "Generate Query",IDC_BTN_CREATE_QUERY,48,64,87,14
    LTEXT           "Developed by V.Girish",IDC_STATIC,220,193,79,8
END


/////////////////////////////////////////////////////////////////////////////
//
// Version
//

VS_VERSION_INFO VERSIONINFO
 FILEVERSION 1,0,0,1
 PRODUCTVERSION 1,0,0,1
 FILEFLAGSMASK 0x3fL
#ifdef _DEBUG
 FILEFLAGS 0x1L
#else
 FILEFLAGS 0x0L
#endif
 FILEOS 0x4L
 FILETYPE 0x1L
 FILESUBTYPE 0x0L
BEGIN
    BLOCK "StringFileInfo"
    BEGIN
        BLOCK "040904B0"
        BEGIN
            VALUE "FileDescription", "QueryBuilder MFC Application"
            VALUE "FileVersion", "1, 0, 0, 1"
            VALUE "InternalName", "QueryBuilder"
            VALUE "LegalCopyright", "Copyright (C) 2006"
            VALUE "OriginalFilename", "QueryBuilder.EXE"
            VALUE "ProductName", "QueryBuilder Application"
            VALUE "ProductVersion", "1, 0, 0, 1"
        END
    END
    BLOCK "VarFileInfo"
    BEGIN
        VALUE "Translation", 0x409, 1200
    END
END


/////////////////////////////////////////////////////////////////////////////
//
// DESIGNINFO
//

#ifdef APSTUDIO_INVOKED
GUIDELINES DESIGNINFO 
BEGIN
    IDD_DLG_DB_CONNECTION, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 293
        TOPMARGIN, 7
        BOTTOMMARGIN, 194
    END

    IDD_DLG_SELECT_COLUMNS, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 293
        TOPMARGIN, 7
        BOTTOMMARGIN, 194
    END

    IDD_DLG_SELECT_RELATIONS, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 293
        TOPMARGIN, 7
        BOTTOMMARGIN, 194
    END

    IDD_DLG_GENERATE_CODE, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 293
        TOPMARGIN, 7
        BOTTOMMARGIN, 194
    END
END
#endif    // APSTUDIO_INVOKED


/////////////////////////////////////////////////////////////////////////////
//
// Dialog Info
//

IDD_DLG_GENERATE_CODE DLGINIT
BEGIN
    IDC_COMBO_IMAGE_FORMAT, 0x403, 4, 0
0x504a, 0x0047, 
    IDC_COMBO_IMAGE_FORMAT, 0x403, 4, 0
0x5653, 0x0047, 
    IDC_COMBO_IMAGE_FORMAT, 0x403, 4, 0
0x4e50, 0x0047, 
    IDC_COMBO_IMAGE_FORMAT, 0x403, 4, 0
0x4947, 0x0046, 
    IDC_COMBO_IMAGE_FORMAT, 0x403, 4, 0
0x4d45, 0x0046, 
    0
END


/////////////////////////////////////////////////////////////////////////////
//
// Bitmap
//

IDB_BMP_LOGO            BITMAP                  "res\\logo.bmp"
IDB_BMP_LIST_ICONS      BITMAP                  "res\\ListIcons.bmp"
#endif    // English (U.S.) resources
/////////////////////////////////////////////////////////////////////////////



#ifndef APSTUDIO_INVOKED
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 3 resource.
//
#define _AFX_NO_SPLITTER_RESOURCES
#define _AFX_NO_OLE_RESOURCES
#define _AFX_NO_TRACKER_RESOURCES
#define _AFX_NO_PROPERTY_RESOURCES

#if !defined(AFX_RESOURCE_DLL) || defined(AFX_TARG_ENU)
#ifdef _WIN32
LANGUAGE 9, 1
#pragma code_page(1252)
#endif //_WIN32
#include "res\QueryBuilder.rc2"  // non-Microsoft Visual C++ edited resources
#include "afxres.rc"         // Standard components
#endif

/////////////////////////////////////////////////////////////////////////////
#endif    // not APSTUDIO_INVOKED

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By

VGirish

Founder

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Database Visualization

License

Comments and Discussions