One of the great things I love about peewee is it’s ability to generate a Python database model from an existing database:
C:\Users\joel\git>python -m pwiz -e mysql -u root -P vagrant -H 127.0.0.1 -p 13306 test_1 -t coa
from peewee import *
database = MySQLDatabase('test_1', **{'host': '127.0.0.1', 'password': 'va
grant', 'port': 13306, 'user': 'root'})
class UnknownField(object):
pass
class BaseModel(Model):
class Meta:
database = database
class Coa(BaseModel):
account = CharField(db_column='Account', null=True)
accountno = CharField(db_column='AccountNo', null=True)
activestatus = CharField(db_column='ActiveStatus', null=True)
banknonote = CharField(db_column='BankNoNote', null=True)
job = IntegerField(db_column='job_id', null=True)
code = CharField(db_column='Code', null=True)
description = CharField(db_column='Description', null=True)
taxline = CharField(db_column='TaxLine', null=True)
type = CharField(db_column='Type', null=True)
class Meta:
db_table = 'coa'