Release of the version 0.35

Posted November 11th, 2006 by t-hex

0.35 is packaged with:

  • Immediate fixes of annoying bugs.
  • Tree layout has been changed into a more explanatory one.
  • Script Editor has been improved in code completion.
  • Example config file

Probably this is the last release before a big change occurs in features, GUI and XML engine.

Stay tuned!

38 comments

Open Datagenerator

Posted June 15th, 2006 by t-hex

Datagenator is test data generator for various databases like Firebird, Interbase, MySQL, MSSQL, PostgreSQL, Oracle. Currenty, Datagenerator is at its early development phase. Current data generation is possible using

  • Pascal Script
    You can use Pascal Script to have custom generators rather than the built-in ones. For example the following code returns the string TEST for every row.
    begin
      Return('TEST');
    end.

    You can also reach the values of another column by using the GetColumnValue function:
    begin
      Return(GetColumnValue('ID'));
    end.

  • SQL queries
    You can run SQL queries to provide data for a column. There is no such a limitation that you have to run your SQL on the target database. You can have many connections in a project and fetch your data from another database. In the future releases this feature will be improved so that a single query will be able to assign values to multiple columns.

  • External Files and Lists
    You can get data to write from text files or from a list that you have just defined in the project.

  • Ranged values
    You can generate data between a specified range. The range parameters are very flexible that the datatype doesn't matter at all. Parameters can be date, float, integer, or just a link to another column.
    For example if you have two columns named BIRTH and DEATH in a table then you can generate values for the column BIRTH between 01/01/1921 and 01/01/2006 and also you can generate values for DEATH column between BIRTH and 01/01/2006. So you can ensure that the generated data is valid.

  • Static values
    Constant values can be assigned to specific columns. Moreover, values of a column can be copied from other columns in a single row.

  • Database sequences
    You can fetch column values from a database sequence.

Open Datagenerator can export the generated data in many ways. ODG can write it directly to the database. Moreover, generated data can be outputted as insert SQL script or CSV file.

read more