peewee 从已经存在的数据库中自动生成Model

pwiz, a model generator

pwiz  is a little script that ships with peewee and is capable of introspecting an existing database and generating model code suitable for interacting with the underlying data. If you have a database already, pwiz can give you a nice boost by generating skeleton code with correct column affinities and foreign keys.

If you install peewee using  setup.py install , pwiz will be installed as a “script” and you can just run:

python -m pwiz -e postgresql -u postgres my_postgres_db

This will print a bunch of models to standard output. So you can do this:

python -m pwiz -e postgresql my_postgres_db > mymodels.py python # <-- fire up an interactive shell

>>> from mymodels import Blog , Entry , Tag , Whatever

>>> print [ blog . name for blog in Blog . select ()]

Option	Meaning	Example
-h	show help
-e	database backend	-e mysql
-H	host to connect to	-H remote.db.server
-p	port to connect on	-p 9001
-u	database user	-u postgres
-P	database password	-P secret
-s	postgres schema	-s public

The following are valid parameters for the engine:

• sqlite
• mysql
• postgresql