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__