[python] peewee基础总结

1. 引入包和数据库

from peewee import *
db = SqliteDatabase('data.db')

2. 定义基础模型

class BaseModel(Model):
    created_date = DateTimeField(default=datetime.now, null=True)
    class Meta:
        database = db

class ShopInfo(BaseModel):
    shopId = IntegerField(verbose_name='店铺Id', null=False, default=-1, index=True)
    keywords = CharField(verbose_name='所有评论的keywords', max_length=50,default='[]', null=True)

3. 加表

db.create_tables([ShopInfo])
db.close()

4. 加字段

from playhouse.migrate import *
migrator = SqliteMigrator(db)

monthCommentCount = CharField(verbose_name='每月的评论数量', max_length=10,null=True)

migrate(
    migrator.add_column('ShopInfo', 'monthCommentCount', monthCommentCount),
)