Generate fake but valid data filled databases for test purposes using most popular patterns(AFAIK).
Current support is sqlite, mysql, postgresql, mongodb.
The installation through pypi also retrieves 'requirements'. Which are : fake-factory, pymongo, psycopg2
pip install fake2db
For psycopg2 to install you need pg_config in your system.
On Mac, the solution is to install postgresql:
brew install postgresql
On CentOS, the solution is to install postgresql-devel:
sudo yum install postgresql-devel
mysql connector is needed for mysql db generation:
It is as follows, at this point in time, fake2db accepts rows and db argument. --rows argument is pretty clear... --db argument takes 4 possible options : sqlite, mysql, postgresql, mongodb --name argument is OPTIONAL. When it is absent fake2db will name db's randomly.
fake2db --rows 200 --db sqlite
> fake2db --rows 1500 --db postgresql --name test_database_postgre
##### Sample output - sqlite ![Screenshot](https://raw.github.com/emirozer/fake2db/master/docs/fake2db_example_sqlite.png)
#### TODO * Add more DB types * Fix db patterns / add more