使用

# !/usr/bin/python
# -*-coding:utf-8-*-
# @Author: 刘楠
# @Time: 2019/12/3 9:05
# @File    : order.py

import peewee
from peewee import *
from datetime import *
from decimal import *

db = MySQLDatabase('cis_prod', user='root', password='root',
                   host='localhost', port=3306)

db.connect()


class Order_info(Model):

    order_id = BigIntegerField(primary_key=True) 
#这里要手动指定主键peewee默认使用id字段来做主键，我的表中没有id这个字段
    order_no = CharField()
    check_code = CharField()
    order_name = CharField()
    cost_total_amount = DecimalField(constraints=[SQL("DEFAULT 0.00")])
    total_amount = DecimalField(constraints=[SQL("DEFAULT 0.00")])
    total_qty = IntegerField()
    order_status = IntegerField()
    pay_status = IntegerField()
    pay_time = DateTimeField()
    refund_status = IntegerField()
    refund_time = DateTimeField()
    cancel_reason = CharField()
    discount_amount = DecimalField(constraints=[SQL("DEFAULT 0.00")])
    pay_amount = DecimalField(constraints=[SQL("DEFAULT 0.00")])
    deliver_time = DateTimeField()
    pay_type_id = IntegerField()
    pay_type_name = CharField()
    shop_id = IntegerField()
    shop_name = CharField()
    pay_way = CharField()
    flow_trade_no = CharField()
    pay_channel_code = CharField()

    class Meta:
        database = db
#定义方法
    def selectList(self):
        return Order_info.select()
#
# for order in Order_info.select():
#     print(
#         order.order_id,
#         order.order_no,
#         order.check_code,
#         order.order_name,
#         order.cost_total_amount,
#         order.total_amount,
#         order.total_qty,
#         order.order_status,
#         order.pay_status,
#         order.pay_time,
#         order.refund_status,
#         order.refund_time,
#         order.cancel_reason,
#         order.discount_amount,
#         order.deliver_time,
#         order.pay_type_id,
#         order.pay_type_name,
#         order.shop_id,
#         order.shop_name,
#         order.pay_way,
#         order.flow_trade_no,
#         order.pay_channel_code
#     )

# orders = Order_info()
#
# for order in orders.selectList():
#     print(
#         order.order_id,
#         order.order_no,
#         order.check_code,
#         order.order_name,
#         order.cost_total_amount,
#         order.total_amount,
#         order.total_qty,
#         order.order_status,
#         order.pay_status,
#         order.pay_time,
#         order.refund_status,
#         order.refund_time,
#         order.cancel_reason,
#         order.discount_amount,
#         order.deliver_time,
#         order.pay_type_id,
#         order.pay_type_name,
#         order.shop_id,
#         order.shop_name,
#         order.pay_way,
#         order.flow_trade_no,
#         order.pay_channel_code
#     )