peewee 动态添加model属性

原创
2019/08/16 14:49
阅读数 360
import logging

#
# from playhouse.pool import PooledMySQLDatabase
#
#
# db = PooledMySQLDatabase(Config.DB_NAME, user=Config.DB_USER,
#                          password=Config.DB_PASSWORD, host=Config.DB_HOST,
#                          port=Config.DB_PORT, threadlocals=True, max_connections=Config.DB_POOL_MAX_CONNECTIONS,
#                          stale_timeout=Config.DB_POOL_STALE_TIMEOUT)
from datetime import datetime

from playhouse.migrate import *

from config.config import database as dbconfig

db = MySQLDatabase(
    host=dbconfig['host'],
    user=dbconfig['user'],
    passwd=dbconfig['password'],
    database=dbconfig['database'],
    port=dbconfig['port'])

logging.basicConfig(level=logging.INFO,
                    format='%(asctime)s -%(name)s-%(levelname)s-%(module)s|%(funcName)s-%(lineno)d:%(message)s',
                    datefmt='%Y-%m-%d %H:%M:%S %p', filename='./structure_right_package_ids.log')
logger = logging.getLogger(__name__)

db = MySQLDatabase(dbconfig['database'], user=dbconfig['user'], passwd=dbconfig['password'])


class BaseModel(Model):
    class Meta:
        database = db


class User(BaseModel):
    # username = CharField(max_length=20)
    # email = CharField()
    # password = CharField()
    # reg_date = DateTimeField(default=datetime.now())

    class Meta:
        table_alias = 'user'


def save_user():
    User._meta.add_field('password', CharField(max_length=20))
    User._meta.add_field('username', CharField(max_length=20))
    User._meta.add_field('email', CharField(max_length=20))
    User._meta.add_field('reg_date', DateTimeField(default=datetime.now()))
    u = User(username='zhanghai', email='hai@gmail.com', password='1111')
    u.save()
展开阅读全文
加载中
点击引领话题📣 发布并加入讨论🔥
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部