peewee快速应用

model

model.py文件

from config.config import PG_CONN
from peewee import *
from datetime import datetime
from peewee import SqliteDatabase
database = PostgresqlDatabase('lxc', **PG_CONN)
# database = SqliteDatabase('db.db')
"""
# 数据库配置信息
PG_CONN = {
    'user': 'rhino',
    'password': 'pg$#aHTF',
    'host': '192.168.0.14',
    'port': "35432"
}
"""
class UnknownField(object):
    def __init__(self, *_, **__): pass

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

class FabaoLawsFile(BaseModel):
    query_string = TextField(null=True, verbose_name="查询关键词")
    result_name = TextField(null=True, verbose_name='结果名称')
    file_path = TextField(null=True, verbose_name='文件路径')
    created_time = DateTimeField(default=datetime.now, verbose_name="添加时间")
    update_time = DateTimeField(verbose_name="更新时间", default=datetime.now)

    class Meta:
        table_name = 'public.fabao_laws_file'

调用

表层面

# 导入表模型
from utils.models import TbMeetingSummary
# 删除表
TbMeetingSummary.drop_table()
# 创建表
TbMeetingSummary.create_table()
# 插入数据
TbMeetingSummary.create(major_audit_items=level1_mulu,
                                            audit_item=level2_mulu,
                                            audit_issues=level3_mulu,
                                            dxyj=dxyj,
                                            cfyj=cfyj,
                                            xgyj=xgyj)

其他增删改查操作再搜吧