In Progress

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

Skills: Delphi, Engineering, MySQL, PHP, Software Architecture, Software Testing

See more: types of software testing, software testing types, php source code testing software name, collections etc, best php editor, i need help designing a form, generate client, Firebird, string integer, datatype, generate ddl class, delphi text program, types views, editor delphi, property data collection, property editor, php scripts create populate database, finish class, delphi client, delphi string, add form delphi, delphi firebird create database, code generate code php form, write reading test, text box editor

About the Employer:
( 358 reviews ) United States

Project ID: #3053586

Awarded to:

vw997435vw

See private message.

$55.25 USD in 15 days
(8 Reviews)
2.8