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
