def item_delete(request, num_iid): top_session = request.session['top_session'] if 'top_session' in request.session else False t = loader.get_template('templates/finish_op.html') if top_session: sql = "delete from taobao_items where num_iid=%s" result = store.execute(sql, num_iid) if result > 0: item_del_method = 'taobao.item.delete' res_data = call_taobao_api(item_del_method, num_iid=num_iid, session=top_session) res_dict = read_taobao_response(res_data) c = Context({ 'BACK_URL': SHOP_DETAIL_URL, 'finish_status': "成功" }) return HttpResponse(t.render(c)) else: c = Context({ 'BACK_URL': SHOP_DETAIL_URL, 'finish_status': "失败" }) return HttpResponse(t.render(c)) else: t = loader.get_template('templates/jump_taobao_signup.html') c = Context({ 'CALLBACK_URL': CALLBACK_URL, }) return HttpResponse(t.render(c))
def get_by_username(cls, user_name): r = store.execute("select tid from taobao_trades where user_name=%s", user_name) if r: tids = [] for item in r: tids.append(item[0]) return cls.gets(tids) return []
def gets_by_username(cls, user_name): r = store.execute("select num_iid from taobao_items where user_name=%s", user_name) if r: num_iids = [] for item in r: num_iids.append(item[0]) return cls.gets(num_iids) return []
def gets_by_username(cls, user_name): r = store.execute("select cid from taobao_seller_cat where user_name=%s", user_name) if r: cids = [] for item in r: cids.append(item[0]) return cls.gets(cids) return []
def taobao_trades_insert(store_list): sql_del = "delete from taobao_trades where user_name=%s" user_name = store_list[0][-1] res_del = store.execute(sql_del, user_name) sql_insert = "insert into taobao_trades value(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" res_insert = store.executemany(sql_insert, store_list) if res_insert == len(store_list): return True else: return False
def get(cls, num_iid): r = store.execute("select * from taobao_items where num_iid=%s", num_iid) if r: return TaobaoItem(*r[0]) return False
def get(cls, user_name): r = store.execute("select * from taobao_shop where user_name=%s", user_name) if r: return TaobaoShop(*r[0]) return False
def get_by_name(cls, user_name): r = store.execute("select * from taobao_user where user_name=%s", user_name) if r: return TaobaoUser(*r[0]) return False
def get(cls, tid): r = store.execute("select tid,num,num_iid,status,title,buyer_name,trade_type,price,point_fee,create_time,pay_time,end_time,payment,consign_time,buyer_message,post_fee from taobao_trades where tid=%s", tid) if r: return TaobaoTrade(*r[0]) return False
def get(cls, user_id): r = store.execute("select * from taobao_user where user_id=%s", user_id) if r: return TaobaoUser(*r[0]) return False
def get(cls, cid): r = store.execute("select cid,parent_cid,name,sort_order,cat_type,pic_url from taobao_seller_cat where cid=%s", cid) if r: return TaobaoSellerCat(*r[0]) return False