Click here to Skip to main content
15,880,967 members
Articles / Database Development / SQL Server

PostgreSQL/libpqxx Class Generator

Rate me:
Please Sign up or sign in to vote.
4.87/5 (15 votes)
18 Aug 200627 min read 82.5K   1.9K   37  
Automated generation of PostgreSQL data transfer classes.
// Microsoft Visual C++ generated resource script.
//
#include "resource.h"

#define APSTUDIO_READONLY_SYMBOLS
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 2 resource.
//
#include "atlres.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 ""atlres.h""\r\n"
    "\0"
END

3 TEXTINCLUDE 
BEGIN
    "CREATEPROCESS_MANIFEST_RESOURCE_ID RT_MANIFEST ""res\\\\pgpqgen.exe.manifest""\r\n"
    "\0"
END

#endif    // APSTUDIO_INVOKED

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


/////////////////////////////////////////////////////////////////////////////
// English (Australia) resources

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

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

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

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

#ifdef APSTUDIO_INVOKED
GUIDELINES DESIGNINFO 
BEGIN
    IDD_CONNECT, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 297
        TOPMARGIN, 7
        BOTTOMMARGIN, 210
    END

    IDD_TABLES, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 297
        TOPMARGIN, 7
        BOTTOMMARGIN, 210
    END

    IDD_TARGET, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 297
        TOPMARGIN, 7
        BOTTOMMARGIN, 210
    END

    IDD_GENERATE, DIALOG
    BEGIN
        LEFTMARGIN, 7
        RIGHTMARGIN, 297
        TOPMARGIN, 7
        BOTTOMMARGIN, 210
    END
END
#endif    // APSTUDIO_INVOKED


/////////////////////////////////////////////////////////////////////////////
//
// Accelerator
//

IDR_MAINFRAME ACCELERATORS 
BEGIN
    "N",            ID_FILE_NEW,            VIRTKEY, CONTROL
    "O",            ID_FILE_OPEN,           VIRTKEY, CONTROL
    "S",            ID_FILE_SAVE,           VIRTKEY, CONTROL
    "P",            ID_FILE_PRINT,          VIRTKEY, CONTROL
    "Z",            ID_EDIT_UNDO,           VIRTKEY, CONTROL
    "X",            ID_EDIT_CUT,            VIRTKEY, CONTROL
    "C",            ID_EDIT_COPY,           VIRTKEY, CONTROL
    "V",            ID_EDIT_PASTE,          VIRTKEY, CONTROL
    VK_BACK,        ID_EDIT_UNDO,           VIRTKEY, ALT
    VK_DELETE,      ID_EDIT_CUT,            VIRTKEY, SHIFT
    VK_INSERT,      ID_EDIT_COPY,           VIRTKEY, CONTROL
    VK_INSERT,      ID_EDIT_PASTE,          VIRTKEY, SHIFT
    VK_F6,          ID_NEXT_PANE,           VIRTKEY 
    VK_F6,          ID_PREV_PANE,           VIRTKEY, SHIFT
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 0x2L
 FILESUBTYPE 0x0L
BEGIN
    BLOCK "StringFileInfo"
    BEGIN
        BLOCK "0c0904b0"
        BEGIN
            VALUE "FileDescription", "pgqpgen"
            VALUE "FileVersion", "1, 0, 0, 1"
            VALUE "InternalName", "TEST1"
            VALUE "LegalCopyright", "Copyright 2004"
            VALUE "OriginalFilename", "pgpqgen.exe"
            VALUE "ProductName", "pgpqgen"
            VALUE "ProductVersion", "1, 0, 0, 1"
        END
    END
    BLOCK "VarFileInfo"
    BEGIN
        VALUE "Translation", 0xc09, 1200
    END
END


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

IDD_CONNECT DIALOGEX 0, 0, 304, 217
STYLE DS_SETFONT | DS_MODALFRAME | DS_FIXEDSYS | WS_POPUP | WS_CAPTION | 
    WS_SYSMENU
CAPTION "libpqxx Class Generator - Connect"
FONT 8, "MS Shell Dlg", 400, 0, 0x1
BEGIN
    CONTROL         203,IDC_STATIC,"Static",SS_BITMAP,0,0,40,217
    LTEXT           "This program generates classes that will allow you to access data stored in a PostgreSQL database. Note that you must link to the libpqxx library (http://gborg.postgresql.org/project/libpqxx/projdisplay.php).",
                    IDC_STATIC,50,0,244,26
    LTEXT           "Enter enough information to connect to your database:",
                    IDC_STATIC,50,48,178,8
    RTEXT           "&Server:",IDC_STATIC,50,67,36,8
    EDITTEXT        IDC_SERVER,91,65,212,14,ES_AUTOHSCROLL
    RTEXT           "&Port:",IDC_STATIC,50,84,36,8
    EDITTEXT        IDC_PORT,91,82,40,14,ES_AUTOHSCROLL
    RTEXT           "&Database:",IDC_STATIC,50,101,36,8
    EDITTEXT        IDC_DATABASE,91,99,212,14,ES_AUTOHSCROLL
    RTEXT           "S&chema:",IDC_STATIC,50,118,36,8
    EDITTEXT        IDC_SCHEMA,91,116,212,14,ES_AUTOHSCROLL
    RTEXT           "&Username:",IDC_STATIC,49,135,36,8
    EDITTEXT        IDC_USERNAME,91,133,212,14,ES_AUTOHSCROLL
    RTEXT           "&Password:",IDC_STATIC,49,151,36,8
    EDITTEXT        IDC_PASSWORD,91,150,212,14,ES_PASSWORD | ES_AUTOHSCROLL
    LTEXT           "libpqxx depends on libpq (which comes with PostgreSQL).",
                    IDC_STATIC,50,32,244,8
END

IDD_TABLES DIALOGEX 0, 0, 304, 217
STYLE DS_SETFONT | DS_MODALFRAME | DS_FIXEDSYS | WS_POPUP | WS_CAPTION | 
    WS_SYSMENU
FONT 8, "MS Shell Dlg", 400, 0, 0x1
BEGIN
    CONTROL         203,IDC_STATIC,"Static",SS_BITMAP,0,0,40,217
    LTEXT           "Select the tables and view that you want to have classes generated. Alter the class and file names as you require.",
                    IDC_STATIC,50,0,253,18
    CONTROL         "",IDC_TABLES,"SysListView32",LVS_REPORT | 
                    LVS_SHOWSELALWAYS | LVS_ALIGNLEFT | LVS_NOCOLUMNHEADER | 
                    WS_BORDER | WS_TABSTOP,50,21,123,125
    PUSHBUTTON      "&Tick All",IDC_TICKALL,69,150,50,14
    PUSHBUTTON      "&Untick All",IDC_TICKNONE,123,150,50,14
    RTEXT           "&Base Class:",IDC_STATIC,50,171,40,8
    EDITTEXT        IDC_BASECLASS,93,169,80,14,ES_AUTOHSCROLL
    RTEXT           "RS &Class:",IDC_STATIC,50,188,40,8
    EDITTEXT        IDC_CLASSNAME,93,186,80,14,ES_AUTOHSCROLL
    RTEXT           "&Header:",IDC_STATIC,50,205,40,8
    EDITTEXT        IDC_FILENAME,93,203,80,14,ES_AUTOHSCROLL
    GROUPBOX        "C&olumns",IDC_STATIC,180,17,123,200
    CONTROL         "",IDC_COLUMNS,"SysListView32",LVS_REPORT | 
                    LVS_SHOWSELALWAYS | LVS_ALIGNLEFT | LVS_NOCOLUMNHEADER | 
                    WS_BORDER | WS_TABSTOP,189,31,106,114
    RTEXT           "&PG Type:",IDC_STATIC,185,165,34,8
    EDITTEXT        IDC_PGTYPE,223,163,72,14,ES_AUTOHSCROLL | ES_READONLY
    RTEXT           "RS &Name:",IDC_STATIC,185,182,34,8
    EDITTEXT        IDC_RSNAME,223,180,72,14,ES_AUTOHSCROLL
    RTEXT           "RS &Type:",IDC_STATIC,185,199,34,8
    COMBOBOX        IDC_RSTYPE,223,198,72,80,CBS_DROPDOWNLIST | CBS_SORT | 
                    WS_VSCROLL | WS_TABSTOP
    CONTROL         "Index",IDC_INDEX,"Button",BS_AUTOCHECKBOX | WS_TABSTOP,
                    224,150,35,10
END

IDD_TARGET DIALOGEX 0, 0, 304, 217
STYLE DS_SETFONT | DS_MODALFRAME | DS_FIXEDSYS | WS_POPUP | WS_CAPTION | 
    WS_SYSMENU
CAPTION "libpqxx Class Generator - Preferences"
FONT 8, "MS Shell Dlg", 400, 0, 0x1
BEGIN
    CONTROL         203,IDC_STATIC,"Static",SS_BITMAP,0,0,40,217
    LTEXT           "&Target Directory:",IDC_STATIC,50,2,57,8
    EDITTEXT        IDC_TARGET,108,0,195,14,ES_AUTOHSCROLL
    CONTROL         "Generate class names with ""&C"" prefix",IDC_PREFIX,
                    "Button",BS_AUTOCHECKBOX | WS_TABSTOP,108,20,134,10
    CONTROL         "Generate &non-recordset base classes",IDC_GENBASE,
                    "Button",BS_AUTOCHECKBOX | WS_TABSTOP,108,34,135,10
    CONTROL         "Drop trailing &S from base class name",IDC_DROPS,"Button",
                    BS_AUTOCHECKBOX | WS_TABSTOP,108,48,131,10
END

IDD_GENERATE DIALOGEX 0, 0, 304, 217
STYLE DS_SETFONT | DS_MODALFRAME | DS_FIXEDSYS | WS_POPUP | WS_CAPTION | 
    WS_SYSMENU
CAPTION "libpqxx Class Generator - Class File Generation"
FONT 8, "MS Shell Dlg", 400, 0, 0x1
BEGIN
    CONTROL         203,IDC_STATIC,"Static",SS_BITMAP,0,0,40,217
    LTEXT           "Please wait while your classes are generated ...",
                    IDC_STATIC,50,0,253,8
    EDITTEXT        IDC_GENLOG,50,11,253,206,ES_MULTILINE | ES_AUTOVSCROLL | 
                    ES_AUTOHSCROLL | ES_READONLY | WS_VSCROLL
END


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

IDB_BANNER              BITMAP                  "res\\banner.bmp"

/////////////////////////////////////////////////////////////////////////////
//
// String Table
//

STRINGTABLE 
BEGIN
    IDR_MAINFRAME           "pgpqgen"
    IDS_REGKEY_SETTINGS     "SOFTWARE\\Pagaros Pty Limited\\pgpqgen"
END

STRINGTABLE 
BEGIN
    ID_FILE_NEW             "Create a new document\nNew"
    ID_FILE_OPEN            "Open an existing document\nOpen"
    ID_FILE_CLOSE           "Close the active document\nClose"
    ID_FILE_SAVE            "Save the active document\nSave"
    ID_FILE_SAVE_AS         "Save the active document with a new name\nSave As"
    ID_FILE_PAGE_SETUP      "Change the printing options\nPage Setup"
    ID_FILE_PRINT_SETUP     "Change the printer and printing options\nPrint Setup"
    ID_FILE_PRINT           "Print the active document\nPrint"
    ID_FILE_PRINT_PREVIEW   "Display full pages\nPrint Preview"
END

STRINGTABLE 
BEGIN
    ID_APP_ABOUT            "Display program information, version number and copyright\nAbout"
    ID_APP_EXIT             "Quit the application; prompts to save documents\nExit"
END

STRINGTABLE 
BEGIN
    ID_NEXT_PANE            "Switch to the next window pane\nNext Pane"
    ID_PREV_PANE            "Switch back to the previous window pane\nPrevious Pane"
END

STRINGTABLE 
BEGIN
    ID_WINDOW_NEW           "Open another window for the active document\nNew Window"
    ID_WINDOW_ARRANGE       "Arrange icons at the bottom of the window\nArrange Icons"
    ID_WINDOW_CASCADE       "Arrange windows so they overlap\nCascade Windows"
    ID_WINDOW_TILE_HORZ     "Arrange windows as non-overlapping tiles\nTile Windows"
    ID_WINDOW_TILE_VERT     "Arrange windows as non-overlapping tiles\nTile Windows"
    ID_WINDOW_SPLIT         "Split the active window into panes\nSplit"
END

STRINGTABLE 
BEGIN
    ID_EDIT_CLEAR           "Erase the selection\nErase"
    ID_EDIT_CLEAR_ALL       "Erase everything\nErase All"
    ID_EDIT_COPY            "Copy the selection and put it on the Clipboard\nCopy"
    ID_EDIT_CUT             "Cut the selection and put it on the Clipboard\nCut"
    ID_EDIT_FIND            "Find the specified text\nFind"
    ID_EDIT_PASTE           "Insert Clipboard contents\nPaste"
    ID_EDIT_REPEAT          "Repeat the last action\nRepeat"
    ID_EDIT_REPLACE         "Replace specific text with different text\nReplace"
    ID_EDIT_SELECT_ALL      "Select the entire document\nSelect All"
    ID_EDIT_UNDO            "Undo the last action\nUndo"
    ID_EDIT_REDO            "Redo the previously undone action\nRedo"
END

STRINGTABLE 
BEGIN
    ATL_IDS_SCSIZE          "Change the window size"
    ATL_IDS_SCMOVE          "Change the window position"
    ATL_IDS_SCMINIMIZE      "Reduce the window to an icon"
    ATL_IDS_SCMAXIMIZE      "Enlarge the window to full size"
    ATL_IDS_SCNEXTWINDOW    "Switch to the next document window"
    ATL_IDS_SCPREVWINDOW    "Switch to the previous document window"
    ATL_IDS_SCCLOSE         "Close the active window and prompts to save the documents"
END

STRINGTABLE 
BEGIN
    ATL_IDS_SCRESTORE       "Restore the window to normal size"
    ATL_IDS_SCTASKLIST      "Activate Task List"
    ATL_IDS_MDICHILD        "Activate this window"
END

STRINGTABLE 
BEGIN
    ATL_IDS_IDLEMESSAGE     "Ready"
END

STRINGTABLE 
BEGIN
    ATL_IDS_MRU_FILE        "Open this document"
END

#endif    // English (Australia) resources
/////////////////////////////////////////////////////////////////////////////



#ifndef APSTUDIO_INVOKED
/////////////////////////////////////////////////////////////////////////////
//
// Generated from the TEXTINCLUDE 3 resource.
//
CREATEPROCESS_MANIFEST_RESOURCE_ID RT_MANIFEST "res\\pgpqgen.exe.manifest"

/////////////////////////////////////////////////////////////////////////////
#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
Australia Australia
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions