On Tue, Dec 21, 2010 at 1:32 AM, Neil D'Souza <neil.xavier.dsouza@xxxxxxxxx> wrote: > You can have a look at my project on sourceforge: > http://sourceforge.net/projects/proghelp builds applications with PG as a > backend automatically. It uses a modified create table sql grammar as an > input. > > 1. It automatically generates stored procedures to insert and retrieve data > 2. a database api layer to access the data in C++ > 3. a user interface using the Wt C++ library > i. search keys marked in the input file automatically become search > keys in the user interface which correctly invoke the generated stored > procedures. > ii. Foreign key references automatically become dialog boxes. > iii. Any search keys in the referenced tables become will become search > keys in the dialog box - again with correct invocations. > iv. Any tables marked as "references multi" in the input file > automatically become master details tables - using a tabview widget for > details tables. The details tables automatically use the primary key from > the master table to do their inserts/retrieval of data from the system. > > 4. Random data for testing. > 5. scripts to create tables in topological order (when there are foreign key > references the referenced tables are output first, for the master/details > tables the master tables are output first), and drop tables and stored > procedures ( when you want to prevent clutter). All the scripts are > collected in a unified script generator to save you the trouble of running > them individually. > 6. Automatic creation of authorization and authentication modules - with > fine grained control on view, add, edit and view summary. > > The input file is about 200 lines, the generated code is about 15,000 lines > of c++, and about 12,000 lines of stored procedures. > > Whats not yet implemented > > 1. Paging of records. > 2. Automatic edit for records. > 3. Currently the search is properly implemented for varchar fields, need to > fix it for dates and int/float data > 4. A better random data generator. > 5. god knows what else > > > You can see a sample application developed using the code generator here: > > http://173.230.133.34:8080/ > > User logins and passwords are below. > > user_login_code | user_login_name | user_password | employee_code > -----------------+-----------------+---------------+--------------- > 1 | zenond | zenond123 | 1 > 2 | atuld | atul123 | 2 > 3 | michaeld | michael123 | 3 > 4 | nxd | nxd123 | 4 > 5 | veerad | veerad123 | 5 > 6 | chanchud | chanchud123 | 6 > 7 | wilburd | wilburd123 | 7 > 8 | abhishekc | abhishekc123 | 8 > > If it crashes - please mail me and I will restart it. > > Kind Regards, > Neil interesting project. do you have any documentation describing how it works? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
