search

tbayart / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer
0 stars 0 forks source link

Different values for every row when generating multiple rows for an Execution Item #31

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
When generating multiple rows for a single Execution Item it uses the same 
values for every row.

Make it so that it is possible to have unique values per row.

This is possible using the SQL query-generator, but need to be more clear and 
easier to use.

Original issue reported on code.google.com by a03pe...@gmail.com on 8 Jun 2012 at 7:34

GoogleCodeExporter commented 9 years ago 
Possibility.
If we create temporary tables containing the countries, female names etc then 
we can pick up values from those for each row.

This will also require me to rewrite the generators so that the values are 
generated using SQL queries instead.

Original comment by a03pe...@gmail.com on 8 Jun 2012 at 7:40

GoogleCodeExporter commented 9 years ago 
Implemented.

Each row is now generating a set of VALUES for the INSERT query.
Each row will generate values using the generator.
Instead of having a execution counter for each SET and using that counter to 
generate values, each row is now generating values using the 
GenerationNumberSupplier.GetNextNumber() method.

Original comment by a03pe...@gmail.com on 8 Jun 2012 at 10:00