class User(Model):
# 定义表名，要和数据库表名一致
__table__ = 's_user'
# 设置字段对应的类型，字段名和类型需要和数据库中数据类型一致
id = IntegerField(primary_key=True, default=None)
s_username = StringField()
s_pwd = StringField()
s_gender = IntegerField()
s_age = IntegerField()
class Comment(Model):
__table__ = 'comments'
id = IntegerField(primary_key=True, default=None)
user_id = IntegerField()
content = StringField()
create_time = FloatField(default=time.time())
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True,default=nextId(),ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
password = StringField(ddl='varchar(50)')
admin = IntegerField(default=0) #是否为管理员0-普通，1-admin
email = StringField(ddl="varchar(50)")
image = StringField(ddl="varchar(500)")
created_at =FloatField(default=time.time)#创建时间
class Sale(Model):
__table__ = 'sale'
id = StringField(primary_key=True)
no = StringField()
customer_no = StringField()
customer_name = StringField()
goods_no = StringField()
goods_name = StringField()
goods_guige = StringField()
goods_unit = StringField()
quantity = FloatField()
price = FloatField()
money = FloatField()
aprice_before = FloatField()
aprice_after = FloatField()
creater = StringField()
creater_name = StringField()
createtime = IntegerField()
class Provider(Model):
__table__ = 'provider'
id = StringField(primary_key=True)
no = StringField()
name = StringField()
code = StringField()
shuiwu = StringField()
person = StringField()
phone = StringField()
mobile = StringField()
address = StringField()
email = StringField()
url = StringField()
postcode = StringField()
fax = StringField()
comment = StringField()
creater = StringField()
createtime = IntegerField()
class User(Model):
__table__ = 'user'
id = IntegerField(primary_key=True)
name = StringField()
cnname = StringField()
password = StringField(ddl='varchar(50)')
class User(Model):
__table__ = 'user'
id = IntegerField(primary_key=True)
name = StringField()