创建测试数据库并用假数据填充：fake2db
fake2db可用于创建测试数据库并用假数据填充。
使用最流行的模式（AFAIK）来生成假的，但有效的数据填充数据库，用于测试目的。目前支持的SQLite，MySQL和PostgreSQL，MongoDB。
Installation
The installation through pypi also retrieves 'requirements'. Which are : fake-factory, pymongo, psycopg2
pip install fake2db
non-PYPI included REQUIREMENT
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
Optional - if you are going to use mysql
mysql connector is needed for mysql db generation:
Usage
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
