Automatic Code generation for Database interface function
Posted: Wed Jul 16, 2008 1:56 am
Greetings,
The GUI development provides a lot of features to speed up the development process, but not so on a comparable level for (or using) the Database.
I have a DB with 15 main tables and about 40+ lookup-tables that should be displayed via drop-down-boxes or pop-up selection interfaces within corresponding (table specific) insert/edit interfaces.
A LOT OF these functionality (i.e. the code for the db related functions or commands) can be automatically generated via a code generation wizard and then manually further processed/manipulated.
There are 4 basic (CRUD) operations: Create, Read (single record, multiple records), Update and Delete.
Each table could be considered as a class (or shared library) with the above CRUD methods derived from templates and derived from names used in the table/columns -- template based error messages can be included in each of these classes as well. The template engine generatinig these functions could use additional information from the DDL provided by the DB, which would guarantee a clean, consistent start for the database interface function development. These function could then easily been used for drop-down boxes, data grids or buttons within the GUI.
This will certainly SAVE a huge amount of development time and would generate a code base which is much better/consistent than via a tedious and labor-intensive hand-coding.
I hope my feature request finds broad support and doesn't require too much effort/time to be realized.
Maybe this is something that one of the tool wizards in this community can do and sell it for a few bucks -- Please, but me on your list as your 1st customer
Best,
Frank
The GUI development provides a lot of features to speed up the development process, but not so on a comparable level for (or using) the Database.
I have a DB with 15 main tables and about 40+ lookup-tables that should be displayed via drop-down-boxes or pop-up selection interfaces within corresponding (table specific) insert/edit interfaces.
A LOT OF these functionality (i.e. the code for the db related functions or commands) can be automatically generated via a code generation wizard and then manually further processed/manipulated.
There are 4 basic (CRUD) operations: Create, Read (single record, multiple records), Update and Delete.
Each table could be considered as a class (or shared library) with the above CRUD methods derived from templates and derived from names used in the table/columns -- template based error messages can be included in each of these classes as well. The template engine generatinig these functions could use additional information from the DDL provided by the DB, which would guarantee a clean, consistent start for the database interface function development. These function could then easily been used for drop-down boxes, data grids or buttons within the GUI.
This will certainly SAVE a huge amount of development time and would generate a code base which is much better/consistent than via a tedious and labor-intensive hand-coding.
I hope my feature request finds broad support and doesn't require too much effort/time to be realized.
Maybe this is something that one of the tool wizards in this community can do and sell it for a few bucks -- Please, but me on your list as your 1st customer
Best,
Frank