Login   Register  
PHP Classes
elePHPant
Icontem

DB Populator: Populate a MySQL database with random data

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-08-05 (4 years ago) RSS 2.0 feedStarStarStarStar 68%Total: 844 All time: 3,813 This week: 1,382Up
Version License PHP version Categories  
db-populator 1.0.0BSD License5.0PHP 5, Databases, Testing
Description Author  

This class can be used to populate a MySQL database with random data.

It can scan the list of tables and fields of a MySQL database and generate SQL INSERT statements that will fill the tables with records with random data.

The class tries to populate each record field with values that seem appropriate based on the field name.

Then it can either execute the generated SQL statements or save them to a file.

Innovation Award  
PHP Programming Innovation award winner
September 2010
Winner


Prize: One copy of the Zend Studio
When you need to test database applications it is convenient to test them with different values in the database records.

This class helps testing database applications by filling table records with random data in different record fields which can be used to test the application with different combinations of values.

Manuel Lemos
Picture of Rafael Jaques
Name: Rafael Jaques <contact>
Classes: 1 package by
Country: Brazil Brazil
Age: 25
All time rank: 2343166 in Brazil Brazil
Week rank: 1770 Up138 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

  Files folder image Files  
File Role Description
Plain text file dbpopulator.class.php Class A class to populate your MySQL
Accessible without login Plain text file example.php Example Example of usage
Plain text file LICENSE Lic. BSD License
Accessible without login Plain text file README Doc. Purpose, HowTo and Customising
Plain text file TODO Data TODO list

 Version Control Unique User Downloads Download Rankings  
 0%Total:844All time:3,813
 This week:0This week:1,382Up
User Ratings User Comments (1)  
 All time
Utility:85%StarStarStarStarStar
Consistency:90%StarStarStarStarStar
Documentation:80%StarStarStarStarStar
Examples:90%StarStarStarStarStar
Tests:-
Videos:-
Overall:68%StarStarStarStar
Rank:297