class OrderGoods(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'order_goods'
og_id = db.Column(db.Integer, primary_key=True)
order_id = db.Column(db.Integer, default=0)
goods_id = db.Column(db.Integer, default=0)
goods_name = db.Column(db.String(255), default='')
goods_img = db.Column(db.String(255), default='')
goods_num = db.Column(db.Integer, default=0)
goods_price = db.Column(db.Float, default=0.00)
gs_id = db.Column(db.Integer, default=0)
sku = db.Column(db.String(255), default='')
sku_name = db.Column(db.String(255), default='')
lottery_id = db.Column(db.Integer, default=0)
section_number = db.Column(db.Integer, default=0)
comment_id = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
after_valid_time = db.Column(db.Integer, default=0)
after_num = db.Column(db.Integer, default=0)
def __str__(self):
return "OrderGoods => { \
og_id:%d, order_id:%d, goods_id:%d, goods_name:'%s', goods_img:'%s', \
goods_num:%d, goods_price:%0.2f, gs_id:%d, sku:'%s', sku_name:'%s', \
lottery_id:%d, section_number:%d, comment_id:%d, add_time:%d, after_valid_time:%d, \
after_num:%d}" % (
self.og_id, self.order_id, self.goods_id, self.goods_name, self.goods_img,
self.goods_num, self.goods_price, self.gs_id, self.sku, self.sku_name,
self.lottery_id, self.section_number, self.comment_id, self.add_time, self.after_valid_time,
self.after_num)
__repr__ = __str__
class Adv(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'adv'
adv_id = db.Column(db.Integer, primary_key=True)
ac_id = db.Column(db.Integer, default=0)
adv_img = db.Column(db.String(255), default='')
adv_category = db.Column(db.String(255), default='')
adv_title = db.Column(db.String(255), default='')
adv_title2 = db.Column(db.String(255), default='')
adv_desc = db.Column(db.String(255), default='')
ttype = db.Column(db.Integer, default=0)
tid = db.Column(db.Integer, default=0)
sort_order = db.Column(db.Integer, default=0)
is_show = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Adv => { \
adv_id:%d, ac_id:%d, adv_img:'%s', adv_category:'%s', adv_title:'%s', \
adv_title2:'%s', adv_desc:'%s', ttype:%d, tid:%d, sort_order:%d, \
is_show:%d, add_time:%d}" % (
self.adv_id, self.ac_id, self.adv_img, self.adv_category, self.adv_title,
self.adv_title2, self.adv_desc, self.ttype, self.tid, self.sort_order,
self.is_show, self.add_time)
__repr__ = __str__
class Img(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'img'
img_id = db.Column(db.Integer, primary_key=True)
ic_id = db.Column(db.Integer, default=0)
_img = db.Column(db.String(255), default='')
ic_name = db.Column(db.String(255), default='')
img_title = db.Column(db.String(255), default='')
img_desc = db.Column(db.String(255), default='')
tid = db.Column(db.Integer, default=0)
ttype = db.Column(db.Integer, default=0)
sort_order = db.Column(db.Integer, default=0)
is_display = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Img => { \
img_id:%d, ic_id:%d, _img:'%s', ic_name:'%s', img_title:'%s', \
img_desc:'%s', tid:%d, ttype:%d, sort_order:%d, is_display:%d, \
add_time:%d}" % (
self.img_id, self.ic_id, self._img, self.ic_name, self.img_title,
self.img_desc, self.tid, self.ttype, self.sort_order, self.is_display,
self.add_time)
__repr__ = __str__
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 Question(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'question'
question_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='')
title = db.Column(db.String(255), default='')
content = db.Column(db.Text, default=None)
question_img = db.Column(db.String(255), default='')
qa_id = db.Column(db.Integer, default=0)
answer_data = db.Column(db.Text, default=None)
answer_count = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Question => { \
question_id:%d, uid:%d, nickname:'%s', avatar:'%s', title:'%s', \
content:'%s', question_img:'%s', qa_id:%d, answer_data:'%s', answer_count:%d, \
add_time:%d}" % (self.question_id, self.uid, self.nickname, self.avatar,
self.title, self.content, self.question_img, self.qa_id,
self.answer_data, self.answer_count, 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 LotteryTemplate(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'lottery_template'
lt_id = db.Column(db.Integer, primary_key=True)
section_number = db.Column(db.Integer, default=0)
goods_id = db.Column(db.Integer, default=0)
lottery_name = db.Column(db.String(255), default='')
lottery_desc = db.Column(db.Text, default=None)
lottery_img = db.Column(db.String(255), default='')
lottery_price = db.Column(db.Float, default=0.00)
finish_quantity = db.Column(db.Integer, default=0)
max_quantity = db.Column(db.Integer, default=0)
status = db.Column(db.Integer, default=1)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "LotteryTemplate => { \
lt_id:%d, section_number:%d, goods_id:%d, lottery_name:'%s', lottery_desc:'%s', \
lottery_img:'%s', lottery_price:%0.2f, finish_quantity:%d, max_quantity:%d, status:%d, \
add_time:%d}" % (self.lt_id, self.section_number, self.goods_id,
self.lottery_name, self.lottery_desc, self.lottery_img,
self.lottery_price, self.finish_quantity, self.max_quantity,
self.status, self.add_time)
__repr__ = __str__
class Coupon(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'coupon'
coupon_id = db.Column(db.Integer, primary_key=True)
uid = db.Column(db.Integer, default=0)
cb_id = db.Column(db.Integer, default=0)
coupon_name = db.Column(db.String(255), default='')
coupon_amount = db.Column(db.Float, default=0.00)
begin_time = db.Column(db.Integer, default=0)
end_time = db.Column(db.Integer, default=0)
limit_amount = db.Column(db.Float, default=99999.00)
use_time = db.Column(db.Integer, default=0)
order_id = db.Column(db.Integer, default=0)
is_valid = db.Column(db.Integer, default=0)
limit_goods = db.Column(db.String(255), default='')
limit_goods_name = db.Column(db.String(255), default='')
coupon_from = db.Column(db.String(16), default='')
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Coupon => { \
coupon_id:%d, uid:%d, cb_id:%d, coupon_name:'%s', coupon_amount:%0.2f, \
begin_time:%d, end_time:%d, limit_amount:%0.2f, use_time:%d, order_id:%d, \
is_valid:%d, limit_goods:'%s', limit_goods_name:'%s', coupon_from:'%s', add_time:%d}" % (
self.coupon_id, self.uid, self.cb_id, self.coupon_name,
self.coupon_amount, self.begin_time, self.end_time,
self.limit_amount, self.use_time, self.order_id, self.is_valid,
self.limit_goods, self.limit_goods_name, self.coupon_from,
self.add_time)
__repr__ = __str__
class Comment(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'comment'
comment_id = db.Column(db.Integer, primary_key=True)
parent_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='')
ttype = db.Column(db.Integer, default=0)
tid = db.Column(db.Integer, default=0)
tname = db.Column(db.String(255), default='')
timg = db.Column(db.String(255), default='')
star = db.Column(db.Integer, default=5)
content = db.Column(db.Text, default=None)
img_list = db.Column(db.Text, default=None)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Comment => { \
comment_id:%d, parent_id:%d, uid:%d, nickname:'%s', avatar:'%s', \
ttype:%d, tid:%d, tname:'%s', timg:'%s', star:%d, \
content:'%s', img_list:'%s', add_time:%d}" % (
self.comment_id, self.parent_id, self.uid, self.nickname,
self.avatar, self.ttype, self.tid, self.tname, self.timg,
self.star, self.content, self.img_list, self.add_time)
__repr__ = __str__
class After(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'after'
after_id = db.Column(db.Integer, primary_key=True)
og_id = db.Column(db.Integer, default=0)
order_id = db.Column(db.Integer, default=0)
goods_id = db.Column(db.Integer, default=0)
uid = db.Column(db.Integer, default=0)
after_type = db.Column(db.Integer, default=0)
quantity = db.Column(db.Integer, default=0)
content = db.Column(db.String(255), default='')
img_list = db.Column(db.Text, default=None)
review_content = db.Column(db.String(255), default='')
status = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
update_time = db.Column(db.Integer, default=0)
def __str__(self):
return "After => { \
after_id:%d, og_id:%d, order_id:%d, goods_id:%d, uid:%d, \
after_type:%d, quantity:%d, content:'%s', img_list:'%s', review_content:'%s', \
status:%d, add_time:%d, update_time:%d}" % (
self.after_id, self.og_id, self.order_id, self.goods_id, self.uid,
self.after_type, self.quantity, self.content, self.img_list,
self.review_content, self.status, self.add_time, self.update_time)
__repr__ = __str__
class Goods(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'goods'
goods_id = db.Column(db.Integer, primary_key=True)
kind = db.Column(db.Integer, default=0)
gc_id = db.Column(db.Integer, default=0)
uid = db.Column(db.Integer, default=0)
goods_name = db.Column(db.String(255), default='')
goods_desc = db.Column(db.Text, default=None)
goods_detail = db.Column(db.Text, default=None)
goods_img = db.Column(db.String(255), default='')
is_sale = db.Column(db.Integer, default=0)
market_price = db.Column(db.Float, default=0.00)
goods_price = db.Column(db.Float, default=0.00)
prom_price = db.Column(db.Float, default=0.00)
prom_begin_time = db.Column(db.Integer, default=0)
prom_end_time = db.Column(db.Integer, default=0)
quantity = db.Column(db.Integer, default=0)
is_fresh = db.Column(db.Integer, default=0)
is_free_shipping = db.Column(db.Integer, default=0)
is_return = db.Column(db.Integer, default=0)
sort_order = db.Column(db.Integer, default=0)
sale_count = db.Column(db.Integer, default=0)
is_hot = db.Column(db.Integer, default=0)
is_pre = db.Column(db.Integer, default=0)
is_new = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
goods_attr = db.Column(db.Text, default=None)
def __str__(self):
return "Goods => { \
goods_id:%d, kind:%d, gc_id:%d, uid:%d, goods_name:'%s', \
goods_desc:'%s', goods_detail:'%s', goods_img:'%s', is_sale:%d, market_price:%0.2f, \
goods_price:%0.2f, prom_price:%0.2f, prom_begin_time:%d, prom_end_time:%d, quantity:%d, \
is_fresh:%d, is_free_shipping:%d, is_return:%d, sort_order:%d, sale_count:%d, \
is_hot:%d, is_pre:%d, is_new:%d, add_time:%d, goods_attr:'%s'}" % (
self.goods_id, self.kind, self.gc_id, self.uid, self.goods_name,
self.goods_desc, self.goods_detail, self.goods_img, self.is_sale, self.market_price,
self.goods_price, self.prom_price, self.prom_begin_time, self.prom_end_time, self.quantity,
self.is_fresh, self.is_free_shipping, self.is_return, self.sort_order, self.sale_count,
self.is_hot, self.is_pre, self.is_new, self.add_time, self.goods_attr)
__repr__ = __str__
@staticmethod
def get_info_by_id(goods_id):
goods = db.session.query(Goods.goods_id, Goods.goods_name, Goods.goods_desc,
Goods.is_sale, Goods.market_price, Goods.goods_price,
Goods.prom_price, Goods.prom_begin_time, Goods.prom_end_time,
Goods.quantity, Goods.unit, Goods.uf_id, Goods.florist_img).\
filter(Goods.goods_id == goods_id).first()
return goods
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 AttrGroup(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'attr_group'
ag_id = db.Column(db.Integer, primary_key=True)
ag_name = db.Column(db.String(255), default='')
alias_name = db.Column(db.String(255), default='')
ag_type = db.Column(db.Integer, default=0)
def __str__(self):
return "AttrGroup => { \
ag_id:%d, ag_name:'%s', alias_name:'%s', ag_type:%d}" % (
self.ag_id, self.ag_name, self.alias_name, 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 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 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 User(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user'
uid = db.Column(db.Integer, primary_key=True)
mobile = db.Column(db.String(15), default='')
username = db.Column(db.String(32), default='')
nickname = db.Column(db.String(32), default='')
realname = db.Column(db.String(32), default='')
avatar = db.Column(db.String(128), default='')
gender = db.Column(db.Integer, default=0)
birthday = db.Column(db.Integer, default=0)
mobile_status = db.Column(db.Integer, default=0)
pushtoken = db.Column(db.String(255), default='')
usercode = db.Column(db.String(20), default='')
def __str__(self):
return "User => { \
uid:%d, mobile:'%s', username:'******', nickname:'%s', realname:'%s', \
avatar:'%s', gender:%d, birthday:%d, mobile_status:%d, pushtoken:'%s', \
usercode:'%s'}" % (
self.uid, self.mobile, self.username, self.nickname, self.realname,
self.avatar, self.gender, self.birthday, self.mobile_status, self.pushtoken,
self.usercode)
__repr__ = __str__
class Lottery(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'lottery'
lottery_id = db.Column(db.Integer, primary_key=True)
lt_id = db.Column(db.Integer, default=0)
section_number = db.Column(db.Integer, default=0)
goods_id = db.Column(db.Integer, default=0)
lottery_name = db.Column(db.String(255), default='')
lottery_desc = db.Column(db.Text, default=None)
lottery_img = db.Column(db.String(255), default='')
lottery_price = db.Column(db.Float, default=0.00)
lottery_status = db.Column(db.Integer, default=0)
finish_quantity = db.Column(db.Integer, default=0)
join_quantity = db.Column(db.Integer, default=0)
remain_quantity = db.Column(db.Integer, default=0)
max_quantity = db.Column(db.Integer, default=0)
schedule = db.Column(db.Integer, default=0)
announced_time = db.Column(db.Integer, default=0)
prize_number = db.Column(db.Integer, default=0)
prize_uid = db.Column(db.Integer, default=0)
prize_nickname = db.Column(db.String(32), default='')
prize_avatar = db.Column(db.String(128), default='')
prize_goods_num = db.Column(db.Integer, default=0)
prize_time = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Lottery => { \
lottery_id:%d, lt_id:%d, section_number:%d, goods_id:%d, lottery_name:'%s', \
lottery_desc:'%s', lottery_img:'%s', lottery_price:%0.2f, lottery_status:%d, finish_quantity:%d, \
join_quantity:%d, remain_quantity:%d, max_quantity:%d, schedule:%d, announced_time:%d, \
prize_number:%d, prize_uid:%d, prize_nickname:'%s', prize_avatar:'%s', prize_goods_num:%d, \
prize_time:%d, add_time:%d}" % (
self.lottery_id, self.lt_id, self.section_number, self.goods_id,
self.lottery_name, self.lottery_desc, self.lottery_img,
self.lottery_price, self.lottery_status, self.finish_quantity,
self.join_quantity, self.remain_quantity, self.max_quantity,
self.schedule, self.announced_time, self.prize_number,
self.prize_uid, self.prize_nickname, self.prize_avatar,
self.prize_goods_num, self.prize_time, self.add_time)
__repr__ = __str__
class GoodsSku(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'goods_sku'
gs_id = db.Column(db.Integer, primary_key=True)
goods_id = db.Column(db.Integer, default=0)
sku = db.Column(db.String(255), default='')
sku_name = db.Column(db.String(255), default='')
sku_price = db.Column(db.Float, default=0.00)
sku_quantity = db.Column(db.Integer, default=0)
def __str__(self):
return "GoodsSku => { \
gs_id:%d, goods_id:%d, sku:'%s', sku_name:'%s', sku_price:%0.2f, \
sku_quantity:%d}" % (
self.gs_id, self.goods_id, self.sku, self.sku_name, self.sku_price,
self.sku_quantity)
__repr__ = __str__
class Spec(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'spec'
spec_id = db.Column(db.Integer, primary_key=True)
st_id = db.Column(db.Integer, default=0)
spec_key = db.Column(db.String(255), default='')
spec_value = db.Column(db.String(255), default='')
sort_order = db.Column(db.Integer, default=0)
add_time = db.Column(db.Integer, default=0)
def __str__(self):
return "Spec => { \
spec_id:%d, st_id:%d, spec_key:'%s', spec_value:'%s', sort_order:%d, \
add_time:%d}" % (
self.spec_id, self.st_id, self.spec_key, self.spec_value, self.sort_order,
self.add_time)
__repr__ = __str__
class GoodsAttr(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'goods_attr'
ga_id = db.Column(db.Integer, primary_key=True)
goods_id = db.Column(db.Integer, default=0)
attr_id = db.Column(db.Integer, default=0)
attr_name = db.Column(db.String(255), default='')
ag_id = db.Column(db.Integer, default=0)
ag_name = db.Column(db.String(255), default='')
def __str__(self):
return "GoodsAttr => { \
ga_id:%d, goods_id:%d, attr_id:%d, attr_name:'%s', ag_id:%d, \
ag_name:'%s'}" % (
self.ga_id, self.goods_id, self.attr_id, self.attr_name, self.ag_id,
self.ag_name)
__repr__ = __str__
class UserLocation(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'user_location'
uid = db.Column(db.Integer, primary_key=True)
country = db.Column(db.String(64), default='')
province = db.Column(db.String(64), default='')
city = db.Column(db.String(64), default='')
district = db.Column(db.String(64), default='')
address = db.Column(db.String(128), default='')
longitude = db.Column(db.Float, default=None)
latitude = db.Column(db.Float, default=None)
def __str__(self):
return "UserLocation => { \
uid:%d, country:'%s', province:'%s', city:'%s', district:'%s', \
address:'%s', longitude:%0.2f, latitude:%0.2f}" % (
self.uid, self.country, self.province, self.city, self.district,
self.address, self.longitude, self.latitude)
__repr__ = __str__
class Shipping(db.Model, MyModelService):
__bind_key__ = 'i-shan'
__tablename__ = 'shipping'
shipping_id = db.Column(db.Integer, primary_key=True)
shipping_name = db.Column(db.String(32), default='')
shipping_amount = db.Column(db.Float, default=0.00)
shipping_desc = db.Column(db.String(255), default='')
free_limit_amount = db.Column(db.Float, default=0.00)
tracking_url = db.Column(db.String(255), default='')
shipping_code = db.Column(db.String(20), default='')
is_default = db.Column(db.Integer, default=0)
def __str__(self):
return "Shipping => { \
shipping_id:%d, shipping_name:'%s', shipping_amount:%0.2f, shipping_desc:'%s', free_limit_amount:%0.2f, \
tracking_url:'%s', shipping_code:'%s', is_default:%d}" % (
self.shipping_id, self.shipping_name, self.shipping_amount,
self.shipping_desc, self.free_limit_amount, self.tracking_url,
self.shipping_code, self.is_default)
__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__
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 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 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 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 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 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__
