def syncdb(): from lib.util import find_subclasses from model import db, User, Distribution, Category, Page models = find_subclasses(db.Model) for model in models: if model.table_exists(): model.drop_table() model.create_table() logging.info('created table:%s' % model._meta.db_table) User.create(mobile = 'root', password = User.create_password('111111'), group = 9) Distribution.create(name = '免费配送', price = 0) Distribution.create(name = '上门自提', price = 0) Category.create(name = '积分商品', slug = 'credit', order = 1) Category.create(name = '搭配购买', slug = 'acc', order = 2) Category.create(name = '鸡', slug = 'ji', order = 3) Category.create(name = '鸭', slug = 'ya', order = 4) Category.create(name = '鹅', slug = 'e', order = 5) Category.delete().where(Category.id == 1).execute() Category.delete().where(Category.id == 2).execute() #Category.create(name = '乳脂奶油蛋糕', slug = 'creambutter', order = 6) #Category.create(name = '冰淇淋蛋糕', slug = 'icecream', order = 7) Page.create(name = '菜市优品', slug = 'aboutus', content = '') Page.create(name = '包装展示', slug = 'bzzs', content = '') Page.create(name = '订购说明', slug = 'dgsm', content = '') Page.create(name = '如何收货', slug = 'rhsh', content = '') Page.create(name = '付款方式', slug = 'fkfs', content = '') Page.create(name = '配送范围', slug = 'psfw', content = '') logging.info('superuser - username:root password:111111')
def syncdb(): from lib.util import find_subclasses from model import db, User, Distribution, Category, Page models = find_subclasses(db.Model) for model in models: if model.table_exists(): model.drop_table() model.create_table() logging.info('created table:%s' % model._meta.db_table) User.create(mobile='root', password=User.create_password('111111'), group=9) Distribution.create(name='免费配送', price=0) Distribution.create(name='上门自提', price=0) Category.create(name='积分商品', slug='credit', order=1) Category.create(name='搭配购买', slug='acc', order=2) Category.create(name='鸡', slug='ji', order=3) Category.create(name='鸭', slug='ya', order=4) Category.create(name='鹅', slug='e', order=5) Category.delete().where(Category.id == 1).execute() Category.delete().where(Category.id == 2).execute() #Category.create(name = '乳脂奶油蛋糕', slug = 'creambutter', order = 6) #Category.create(name = '冰淇淋蛋糕', slug = 'icecream', order = 7) Page.create(name='菜市优品', slug='aboutus', content='') Page.create(name='包装展示', slug='bzzs', content='') Page.create(name='订购说明', slug='dgsm', content='') Page.create(name='如何收货', slug='rhsh', content='') Page.create(name='付款方式', slug='fkfs', content='') Page.create(name='配送范围', slug='psfw', content='') logging.info('superuser - username:root password:111111')
def api_category_delete(*, request, category_id): r = web.Response() category = Category(id=category_id) category_result = yield from category.delete() if int(category_id) > 0 and int(category_result) > 0: result = APIResult(1, '', '删除成功') else: result = APIResult(0, '', '删除失败') return jsonResult(r, result)
def get(self, cid): Category.delete().where(Category.id == cid).execute() CategoryAttr.delete().where(CategoryAttr.cid == cid).execute() self.memcachedb.delete('categorys') self.flash(u"分类删除成功") self.redirect("/admin/categorys")