ddl generate

I have a client who needs help designing the listed classes. The goal will be to read the views collection and generate ddl for the views. The views are not database views. The first step would be to finish the class definition. 1. Create a type for data types. Add the data type to the constructor for the create. 2. Add methods for AddColumn, DeleteColumn, UpdateColumn 3. Add methods for AddView, DeleteView, UpdateView. 4. Generate ddl. It will be used against a firebird database, so testing should be done against firebird. The ddl should have methods for reading the field level data types as this will be used to populate a property editor. 5. Determine if tstringlist are best used for the collections of columns, views, ect... I do not need an interface to drive these classes. You can just create scripts to test or write code. The ddl should be output to a text box for viewing. /////////////////////////////////////////////////////////////////////////////////////// Type TTemplateColumn = Class(TObject) Private Public Dirty: boolean; ColName: String; //visible column name, not the data field name. DataFieldName: String; //column name of the data field. DataType: String; //need to create a type definition for datatypes. //beyond the datatype, depending on the datatype, we need to have properties //for each datatype, ex: text would have properties for length, required, ect... //not sure if this would be a seperate class. TextLength: integer; ColumnModified: boolean; end; Type TTemplateView = Class(TObject) Private Public Name: String; Dirty: Boolean; Columns: TStringList; //list of columns. DDL: TString; Constructor Create(); end; Type TTemplateViews = Class(TObject) Private Public Views: TStringList; View collection. AddView; DeleteView; end;

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

98/xp

Delphi Engineering MySQL PHP Software Architecture Software Testing

Project ID: #3053586

About the project