Feature Request: Automatically populate "Weighted List"

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Feature Request: Automatically populate "Weighted List"

Postby DAndres109@aol.com » Sat May 03, 2008 1:54 pm

Hi,

In some cases, a Check constraint may exists that limits a field to only a handful of values.

Is there any way for the Data Generator to automatically pick up and list these values during these circumstances?

Thanks,

David Andres
DAndres109@aol.com
 
Posts: 14
Joined: Sat May 03, 2008 1:25 am
Location: New York

Postby benhall » Tue May 06, 2008 2:18 pm

Hello,

Thanks for your feedback. You should find that we parse a check constraint and convert it into a regular expression assigned to the column.

Currently, there is no way to assign these values automatically to a weighted list, however I have added a requested into our system to consider for a future release. Out of interest, what would you assign the default 'weight' out these values to be?

Thanks

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby DAndres109@aol.com » Tue May 06, 2008 3:57 pm

Ben,

I agree that there's no "correct" solution to assigning weights. The only thing that comes to mind is if there are 100 or fewer constraints, then at least you can do an average, where the first option is modified to sum up to 100 percent.

What do you think?

David
DAndres109@aol.com
 
Posts: 14
Joined: Sat May 03, 2008 1:25 am
Location: New York

Postby benhall » Tue May 06, 2008 4:54 pm

David,

That was my initial thought as well, thanks for the reply.

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby jnahmias » Tue May 06, 2008 5:47 pm

Not to hijack this request, but it would also be nice to automatically populate a weighted list generator from a foreign key.
jnahmias
 
Posts: 11
Joined: Wed Apr 30, 2008 6:33 pm
Location: NYC

Postby tkdennis » Fri May 16, 2008 3:10 am

I would really like to see a weighted list populated from a foreign key also.
tkdennis
 
Posts: 75
Joined: Fri Feb 29, 2008 1:13 am

Postby benhall » Fri May 16, 2008 4:36 pm

Thanks for the additional comments, I have made a note of all of them for reviewing for a later release.

Thanks

Ben
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests