class GoodsCategory(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'goods_category'
gc_id = db.Column(db.Integer, primary_key=True)
category_name = db.Column(db.String(255), default='')
parent_id = db.Column(db.Integer, default=0)
node_chain = db.Column(db.String(255), default='')
category_img = db.Column(db.String(255), default='')
brief = db.Column(db.Text, default=None)
sort_order = db.Column(db.Integer, default=0)
status = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "GoodsCategory => { \
gc_id:%d, category_name:'%s', parent_id:%d, node_chain:'%s', category_img:'%s', \
brief:'%s', sort_order:%d, status:%d, add_time:%d}" % (
self.gc_id, self.category_name, self.parent_id, self.node_chain, self.category_img,
self.brief, self.sort_order, self.status, self.add_time)
__repr__ = __str__
@staticmethod
def get_goods_cat_list(gc_id=0):
"""获取子分类列表"""
return GoodsCategory.query.filter(GoodsCategory.parent_id == gc_id).all()
class Attr(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'attr'
attr_id = db.Column(db.Integer, primary_key=True)
attr_name = db.Column(db.String(255), default='')
ag_id = db.Column(db.Integer, default=0)
def __str__(self):
return "Attr => { \
attr_id:%d, attr_name:'%s', ag_id:%d}" % (
self.attr_id, self.attr_name, self.ag_id)
__repr__ = __str__
class SpecTemplate(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'spec_template'
st_id = db.Column(db.Integer, primary_key=True)
st_name = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "SpecTemplate => { \
st_id:%d, st_name:'%s', add_time:%d}" % (
self.st_id, self.st_name, self.add_time)
__repr__ = __str__
class Role(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'role'
role_id = db.Column(db.Integer, primary_key=True)
role_name = db.Column(db.String(255), default='')
desc = db.Column(db.String(255), default='')
def __str__(self):
return "Role => { \
role_id:%d, role_name:'%s', desc:'%s'}" % (
self.role_id, self.role_name, self.desc)
__repr__ = __str__
class LotteryNumberPool(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'lottery_number_pool'
lnp_id = db.Column(db.Integer, primary_key=True)
lottery_id = db.Column(db.Integer, default=0)
lottery_number = db.Column(db.Integer, default=0)
def __str__(self):
return "LotteryNumberPool => { \
lnp_id:%d, lottery_id:%d, lottery_number:%d}" % (self.lnp_id, self.lottery_id,
self.lottery_number)
__repr__ = __str__
class ImgCategory(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'img_category'
ic_id = db.Column(db.Integer, primary_key=True)
ic_name = db.Column(db.String(32), default='')
add_time = db.Column(db.Integer, default=None)
def __str__(self):
return "ImgCategory => { \
ic_id:%d, ic_name:'%s', add_time:%d}" % (
self.ic_id, self.ic_name, self.add_time)
__repr__ = __str__
class AttrGroupInCategory(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'attr_group_in_category'
agic_id = db.Column(db.Integer, primary_key=True)
gc_id = db.Column(db.Integer, default=0)
ag_id = db.Column(db.Integer, default=0)
ag_type = db.Column(db.Integer, default=0)
def __str__(self):
return "AttrGroupInCategory => { \
agic_id:%d, gc_id:%d, ag_id:%d, ag_type:%d}" % (
self.agic_id, self.gc_id, self.ag_id, self.ag_type)
__repr__ = __str__
class SysSetting(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'sys_setting'
ss_id = db.Column(db.Integer, primary_key=True)
key = db.Column(db.String(225), default='')
value = db.Column(db.String(225), default='')
desc = db.Column(db.String(225), default='')
def __str__(self):
return "SysSetting => { \
ss_id:%d, key:'%s', value:'%s', desc:'%s'}" % (
self.ss_id, self.key, self.value, self.desc)
__repr__ = __str__
class AfterStep(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'after_step'
as_id = db.Column(db.Integer, primary_key=True)
after_id = db.Column(db.Integer, default=0)
step_status = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "AfterStep => { \
as_id:%d, after_id:%d, step_status:%d, add_time:%d}" % (
self.as_id, self.after_id, self.step_status, self.add_time)
__repr__ = __str__
class UserTroy(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_troy'
uid = db.Column(db.Integer, primary_key=True)
password = db.Column(db.String(255), default='')
cookies_obj = db.Column(db.Text, default=None)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserTroy => { \
uid:%d, password:'******', cookies_obj:'%s', add_time:%d}" % (
self.uid, self.password, self.cookies_obj, self.add_time)
__repr__ = __str__
class UserPassword(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_password'
uid = db.Column(db.Integer, primary_key=True)
password = db.Column(db.String(64), default='')
salt = db.Column(db.String(32), default='')
type = db.Column(db.Integer, primary_key=True)
def __str__(self):
return "UserPassword => { \
uid:%d, password:'******', salt:'%s', type:%d}" % (
self.uid, self.password, self.salt, self.type)
__repr__ = __str__
class UserCheckHistory(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_check_history'
uch_id = db.Column(db.Integer, primary_key=True)
mobile = db.Column(db.String(15), default='')
code = db.Column(db.String(6), default='')
check_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserCheckHistory => { \
uch_id:%d, mobile:'%s', code:'%s', check_time:%d}" % (
self.uch_id, self.mobile, self.code, self.check_time)
__repr__ = __str__
class UserAdmin(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_admin'
id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
role_id = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserAdmin => { \
id:%d, uid:%d, role_id:%d, add_time:%d}" % (
self.id, self.uid, self.role_id, self.add_time)
__repr__ = __str__
class UserLastTime(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_last_time'
ult_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
last_type = db.Column(db.Integer, default=0)
last_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserLastTime => { \
ult_id:%d, uid:%d, last_type:%d, last_time:%d}" % (
self.ult_id, self.uid, self.last_type, self.last_time)
__repr__ = __str__
class UserAccount(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_account'
uid = db.Column(db.Integer, primary_key=True)
balance = db.Column(db.Float, default=0.00)
add_time = db.Column(db.Integer, default=0)
update_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserAccount => { \
uid:%d, balance:%0.2f, add_time:%d, update_time:%d}" % (
self.uid, self.balance, self.add_time, self.update_time)
__repr__ = __str__
class RolePermission(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'role_permission'
rp_id = db.Column(db.Integer, primary_key=True)
role_id = db.Column(db.Integer, default=0)
permission_id = db.Column(db.Integer, default=0)
menu_type = db.Column(db.Integer, default=0)
endpoint_list = db.Column(db.Text, default=None)
def __str__(self):
return "RolePermission => { \
rp_id:%d, role_id:%d, permission_id:%d, menu_type:%d, endpoint_list:'%s'}" % (
self.rp_id, self.role_id, self.permission_id, self.menu_type, self.endpoint_list)
__repr__ = __str__
class QuestionGallery(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'question_gallery'
qg_id = db.Column(db.Integer, primary_key=True)
ttype = db.Column(db.Integer, default=0)
tid = db.Column(db.Integer, default=0)
img = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "QuestionGallery => { \
qg_id:%d, ttype:%d, tid:%d, img:'%s', add_time:%d}" % (
self.qg_id, self.ttype, self.tid, self.img, self.add_time)
__repr__ = __str__
class UserBillTitle(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_bill_title'
ubt_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
bill_title = db.Column(db.String(64), default='')
is_default = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserBillTitle => { \
ubt_id:%d, uid:%d, bill_title:'%s', is_default:%d, add_time:%d}" % (
self.ubt_id, self.uid, self.bill_title, self.is_default, self.add_time)
__repr__ = __str__
class NewsGoods(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'news_goods'
ng_id = db.Column(db.Integer, primary_key=True)
news_id = db.Column(db.Integer, default=0)
goods_id = db.Column(db.Integer, default=0)
extend = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "NewsGoods => { \
ng_id:%d, news_id:%d, goods_id:%d, extend:'%s', add_time:%d}" % (
self.ng_id, self.news_id, self.goods_id, self.extend,
self.add_time)
__repr__ = __str__
class Permission(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'permission'
permission_id = db.Column(db.Integer, primary_key=True)
parent_id = db.Column(db.Integer, default=0)
endpoint = db.Column(db.String(255), default='')
endpoint_name = db.Column(db.String(255), default='')
endpoint_icon = db.Column(db.String(255), default='')
endpoint_list = db.Column(db.Text, default=None)
sort_order = db.Column(db.Integer, default=0)
def __str__(self):
return "Permission => { \
permission_id:%d, parent_id:%d, endpoint:'%s', endpoint_name:'%s', endpoint_icon:'%s', \
endpoint_list:'%s', sort_order:%d}" % (self.permission_id, self.parent_id,
self.endpoint, self.endpoint_name,
self.endpoint_icon, self.endpoint_list,
self.sort_order)
__repr__ = __str__
@staticmethod
def get_child_list(id=0):
"""获取子菜单列表"""
permission_child_list = Permission.query.filter(Permission.parent_id == id).\
order_by(Permission.sort_order.desc()).all()
return permission_child_list
class OrderTranIndex(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'order_tran_index'
tran_id = db.Column(db.Integer, primary_key=True)
def __str__(self):
return "OrderTranIndex => { \
tran_id:%d}" % (
self.tran_id)
__repr__ = __str__
class SysRegion(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'sys_region'
region_id = db.Column(db.Integer, primary_key=True)
parent_id = db.Column(db.Integer, default=0)
region_name = db.Column(db.String(120), default='')
region_type = db.Column(db.Integer, default=2)
agency_id = db.Column(db.Integer, default=0)
def __str__(self):
return "SysRegion => { \
region_id:%d, parent_id:%d, region_name:'%s', region_type:%d, agency_id:%d}" % (
self.region_id, self.parent_id, self.region_name, self.region_type, self.agency_id)
__repr__ = __str__
@staticmethod
def get_children_region_list(region_id=0):
"""获取子地区列表"""
return SysRegion.query.filter(SysRegion.parent_id == region_id).all()
class GoodsGallery(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'goods_gallery'
gg_id = db.Column(db.Integer, primary_key=True)
goods_id = db.Column(db.Integer, default=0)
img = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "GoodsGallery => { \
gg_id:%d, goods_id:%d, img:'%s', add_time:%d}" % (
self.gg_id, self.goods_id, self.img, self.add_time)
__repr__ = __str__
@staticmethod
def list_by_goods_id(goods_id):
""" 根据商品ID获取相册列表 """
gallery_list = db.session.query(GoodsGallery.img).\
filter(GoodsGallery.goods_id == goods_id).all()
return gallery_list
class UserAccountDetail(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_account_detail'
uad_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
prev_balance = db.Column(db.Float, default=0.00)
balance = db.Column(db.Float, default=0.00)
amount = db.Column(db.Float, default=0.00)
in_or_out = db.Column(db.Integer, default=0)
action = db.Column(db.Integer, default=0)
remark_for_user = db.Column(db.String(255), default='')
remark_for_sys = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserAccountDetail => { \
uad_id:%d, uid:%d, prev_balance:%0.2f, balance:%0.2f, amount:%0.2f, \
in_or_out:%d, action:%d, remark_for_user:'******', remark_for_sys:'%s', add_time:%d}" % (
self.uad_id, self.uid, self.prev_balance, self.balance, self.amount,
self.in_or_out, self.action, self.remark_for_user, self.remark_for_sys, self.add_time)
__repr__ = __str__
class UserAddress(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_address'
ua_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
name = db.Column(db.String(32), default='')
mobile = db.Column(db.String(15), default='')
province = db.Column(db.String(32), default='')
city = db.Column(db.String(32), default='')
district = db.Column(db.String(32), default='')
address = db.Column(db.String(255), default='')
zip = db.Column(db.String(8), default='')
is_default = db.Column(db.Integer, default=0)
def __str__(self):
return "UserAddress => { \
ua_id:%d, uid:%d, name:'%s', mobile:'%s', province:'%s', \
city:'%s', district:'%s', address:'%s', zip:'%s', is_default:%d}" % (
self.ua_id, self.uid, self.name, self.mobile, self.province,
self.city, self.district, self.address, self.zip, self.is_default)
__repr__ = __str__
class QuestionAnswer(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'question_answer'
qa_id = db.Column(db.Integer, primary_key=True)
question_id = db.Column(db.Integer, default=0)
uid = db.Column(db.Integer, default=0)
nickname = db.Column(db.String(32), default='')
avatar = db.Column(db.String(128), default='')
content = db.Column(db.Text, default=None)
answer_img = db.Column(db.String(255), default='')
agree_count = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "QuestionAnswer => { \
qa_id:%d, question_id:%d, uid:%d, nickname:'%s', avatar:'%s', \
content:'%s', answer_img:'%s', agree_count:%d, add_time:%d}" % (
self.qa_id, self.question_id, self.uid, self.nickname, self.avatar,
self.content, self.answer_img, self.agree_count, self.add_time)
__repr__ = __str__
class GoodsColumn(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'goods_column'
gc_id = db.Column(db.Integer, primary_key=True)
column_name = db.Column(db.String(255), default='')
parent_id = db.Column(db.Integer, default=0)
node_chain = db.Column(db.String(255), default='')
column_img = db.Column(db.String(255), default='')
brief = db.Column(db.Text, default=None)
sort_order = db.Column(db.Integer, default=0)
status = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "GoodsColumn => { \
gc_id:%d, column_name:'%s', parent_id:%d, node_chain:'%s', column_img:'%s', \
brief:'%s', sort_order:%d, status:%d, add_time:%d}" % (
self.gc_id, self.column_name, self.parent_id, self.node_chain, self.column_img,
self.brief, self.sort_order, self.status, self.add_time)
__repr__ = __str__
class UserDevice(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_device'
ud_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
device_id = db.Column(db.String(64), default=None)
device_name = db.Column(db.String(64), default='')
device_vendor = db.Column(db.String(64), default='')
device_os = db.Column(db.String(16), default='')
device_os_version = db.Column(db.String(16), default='')
device_model = db.Column(db.String(32), default='')
app_version = db.Column(db.String(255), default='')
def __str__(self):
return "UserDevice => { \
ud_id:%d, uid:%d, device_id:'%s', device_name:'%s', device_vendor:'%s', \
device_os:'%s', device_os_version:'%s', device_model:'%s', app_version:'%s'}" % (
self.ud_id, self.uid, self.device_id, self.device_name, self.device_vendor,
self.device_os, self.device_os_version, self.device_model, self.app_version)
__repr__ = __str__
class OrderTran(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'order_tran'
tran_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
pay_amount = db.Column(db.Float, default=0.00)
pay_status = db.Column(db.Integer, default=0)
paid_time = db.Column(db.Integer, default=0)
pay_tran_id = db.Column(db.String(32), default='')
pay_method = db.Column(db.String(16), default='')
order_id_list = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "OrderTran => { \
tran_id:%d, uid:%d, pay_amount:%0.2f, pay_status:%d, paid_time:%d, \
pay_tran_id:'%s', pay_method:'%s', order_id_list:'%s', add_time:%d}" % (
self.tran_id, self.uid, self.pay_amount, self.pay_status, self.paid_time,
self.pay_tran_id, self.pay_method, self.order_id_list, self.add_time)
__repr__ = __str__
class UserLike(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_like'
ul_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
nickname = db.Column(db.String(32), default='')
avatar = db.Column(db.String(128), default='')
desc = db.Column(db.String(255), default='')
like_type = db.Column(db.Integer, default=0)
like_id = db.Column(db.Integer, default=0)
like_name = db.Column(db.String(255), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "UserLike => { \
ul_id:%d, uid:%d, nickname:'%s', avatar:'%s', desc:'%s', \
like_type:%d, like_id:%d, like_name:'%s', add_time:%d}" % (
self.ul_id, self.uid, self.nickname, self.avatar, self.desc,
self.like_type, self.like_id, self.like_name, self.add_time)
__repr__ = __str__
