Generate country-specific, real-life testdata and import directly to DB or export to SQL, CSV, PHParray or JSON
Unique features of MySQL Datagenerator (besides many other features):1. Preview of examplevalues that will be generated.
2. Your local databases are automatically scanned.
3. Import directly into the database (rollback last import possible) or generate sql, PHP array, JSON or CSV. I intentionally set the limit to 300, when you want more rows, just click the export button several times.. (if you wish you can change the limit in the code to a higher amount)
4. It handles primary keys, autoincrement, unique keys and foreign keys, also multicolumns.
5. Countryspecific data for real localized values (USA, Great Britain, Netherlands, Germany and France).
6. Many real-life predefined options such as surnames, firstnames, streets, postalcodes, emailaddresses, states, provences, Bundesländer, countries, telephonenumbers, url’s, md5, screenresolutions, colorcodes, mimetypes, fileextensions, filenames, IP addresses, INET_ATON, months, dates, years, timestamps, times, GPS coordinates, Lorem Pixel etc….
7. For maximum flexibility you can add own options, set ranges and set advanced configoptions.
- Application in English, Dutch or German
- No installation required
- Tested with PHP 5.2.6 on Windows Vista (XAMPP 1.6.7), PHP 5.3.2 on Windows 7, PHP 5.4.16 on Windows XP (XAMPP 1.8.2) and PHP 5.4.16 on Ubuntu 9.0.4 (XAMPP 1.8.2) and on a Mac (MAMP)
- Tested with Firefox 22.0, Chrome 28, Safari 5.1.7 and Opera 15.0
- Tested with personal databases and the MySQL example databases `sakila-schema` and `world_innodb`.
Requirements
You need to have a local Apache webserver with PHP, phpMyAdmin and MySQL installed. The easiest way to do this is to install XAMPP (free software). (http://www.apachefriends.org/en/xampp.html)
Support and updates are free!
Testing your application or website gets exciting with this datagenerator !
demo here: http://screencast.com/t/8FFmAh6M0Wh
Working on
solutions for specific problems with tables which have columns which are multicolumn primary keys and at the same time multicolumn foreign keys. I know, it’s not very common, but i came across it and i want to make that possible too. Before i used 500 values of the linked foreign table, but sometimes that is not enough. So it wil be possible to make that 1000 or runtime_dbcheck. Runtime_dbcheck will do a search in the database instead of the SESSION with 500 values (or 1000)Updates
update1 (aug. 2013):fixed a few bugs with float, unique keys and special characters
added 2 new output types: php array and JSON
textual output now appear in dialog instead of in new browsertab
update2 (oct. 2013):
added France for countryspecific data
added lorem pixel, GPS as new custom options
added 1 new output type: CSV
added basic checks if ranges are correct (matching the chosen custom option) while typing
update3 (oct. 2013):
fixed an error with unique keys and multicolumn primary keys
improved the success rate of dbimport to almost 100%
fixed a bug with lorem pixel
you can set the pre-selected items of the datatypes-combo now in config.php
update4 (oct. 2013):
multi-column foreign keys are now processed and handled as multi-columns
expanded ranges and rangechecks
update5 (nov. 2013):
improved output to PHP array, JSON and CSV
added possibility to rollback (undo) the last db import
added possibility to change tables selection when opening a saved file
added possibility to set a preferred enumvalue
added new constants in config.php
update 6 (nov 2013):
Added possibility to link a column to another (of the same table or another table). The targetcolumn will get the same value as the sourcecolumn.
update 7 (dec 2013):
Now colorcodes are randomly processed instead of using a predefined array with colorcodes
Now a foreign-key field is not visible in the ‘same_as’ combo when you want to select a value for the field that is actually the referenced field of that foreign-key.
No comments:
Post a Comment