Gazoo - Random Text Generator for ColdFusion
I've had, on multiple occasions, a need for a random generator. That is, some tool that could make any type of data I could think of for filling a database.
For instance, I have a brand new user table with firstname, lastname, email, postalcode.
Well, I'd want to generate 5000 records with typical information into those fields for application testing and development. I've used SQL generators in the past and some clumsy ColdFusion ones, but this Gazoo is new to me!
All you have to do is cfloop cfquery inserts and call whatever function you'd like for each database column.
<cfloop from="1" to="5000" index="x">
<cfquery datasource="#dsn#">
insert into tbl_users(
firstName,
lastName,
email,
postalCode)
values(#randomizer.generateFirstName()#,
#randomizer.generateLastName()#,
#randomizer.generateEmail()#,
#randomizer.generateZipCode()#)
</cfquery>
</cfloop>
<cfquery datasource="#dsn#">
insert into tbl_users(
firstName,
lastName,
email,
postalCode)
values(#randomizer.generateFirstName()#,
#randomizer.generateLastName()#,
#randomizer.generateEmail()#,
#randomizer.generateZipCode()#)
</cfquery>
</cfloop>
There are no comments for this entry.
[Add Comment]