def update():
if not session:
return redirect('/')
if request.method=="POST":
user_dict={k:v[0] for k,v in dict(request.form).items()}
print user_dict
if user_dict.has_key('oldpasswd'):
username=session['username']
data1={}
data1['username']=username
field=['id','username','name','password','phone','email','role','status']
result=utils.get_one(table,field,data1)
if user_dict['oldpasswd']==result['msg']['password']:
info={}
field=['id','password']
info['id']=result['msg']['id']
info['password']=user_dict['newpasswd']
util.WriteLog("update_psswd","/tmp/info.log").info("update_passwd:%s"%session['username'])
data=utils.update(table,field,info)
return json.dumps(data)
else:
result={'code':1,'msg':'oldpasswd is error'}
util.WriteLog('update_passwd','/tmp/error.log').error("update_password:%s"%session['username'])
return json.dumps(result)
else:
field=[]
util.WriteLog("update","/tmp/info.log").info("update:%s"%session['username'])
data=utils.update(table,field,user_dict)
return json.dumps(data)
def modpwd():
data = {k: v[0] for k, v in dict(request.form).items()}
if 'password' in data.keys():
if not data['password'] or not data['newpassword'] or not data[
'renewpassword']:
errmsg = 'password can not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
else:
if not data['newpassword'] or not data['renewpassword']:
errmsg = 'password can not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
try:
condition = [
"{}='{}'".format('password', v[0]) for k, v in data.items()
if k == 'newpassword'
]
id = session.get('id')
if session.get('role') == 1:
utils.update('user', condition, data['id'])
return json.dumps({'code': '0', 'result': 'modify completed!'})
else:
if data['password'] == utils.get_one('user', fields,
data)['password']:
utils.update('user', condition, data['id'])
return json.dumps({'code': '0', 'result': 'modify completed!'})
return json.dumps({'code': '1', 'errmsg': 'wrong old password'})
except:
errmsg = "modify failed"
return json.dumps({'code': '1', 'errmsg': errmsg})
def user():
if not session:
return redirect('/')
username = session['username']
user_dict = {'username': username}
result = utils.get_one(table, field, user_dict)
return render_template('list.html', res=session, result=result['msg'])
def main():
logging.basicConfig(
format=
'%(asctime)s,%(msecs)d %(levelname)-8s [%(filename)s:%(lineno)d] %(message)s',
datefmt='%Y-%m-%d:%H:%M:%S',
level=logging.DEBUG)
people = utils.get_all(BASE_URL + "people")
people.sort(key=lambda x: len(x['films']), reverse=True)
people = people[:9]
people.sort(key=lambda x: int(x['height']), reverse=True)
try:
with open(DEFAULT_FILENAME, "w", newline="") as csvfile:
writer = csv.writer(csvfile, quoting=csv.QUOTE_MINIMAL)
writer.writerow(["name", "species", "height", "appearances"])
for char in people:
writer.writerow([
char['name'],
utils.get_one(char['species'][0])['name'], char['height'],
len(char['films'])
])
upload_status = utils.send_file_to_url(PASTEBIN, DEFAULT_FILENAME)
finally:
os.remove(DEFAULT_FILENAME)
if upload_status:
print("File uploaded successfully!")
else:
print("File upload unsuccessful...")
def user():
if not session:
return redirect("/")
username=session['username']
user_dict={'username':username}
util.WriteLog("getone","/tmp/info.log").info('get_one:%s'%session['username'])
result=utils.get_one(table,field,user_dict)
return render_template('list.html',res=session,result=result['msg'])
def cabinet_info():
if not session:
return redirect('/')
uid = request.args.get('id')
data = {'id': uid}
result = utils.get_one(cab_table, cab_field, data)
if result['code'] == 0:
result = result['msg']
return json.dumps(result)
def userinfo():
if not session:
return redirect('/')
if request.method == 'GET':
uid = request.args.get('id')
data = {'id': uid}
result = utils.get_one(table, field, data)
if result['code'] == 0:
result = result['msg']
return json.dumps(result)
def parse(self, response):
hxs = HtmlXPathSelector(response)
h_area_array = hxs.select('//body/div[@class="bodyBG"]/div[@class="warp"]/div[@class="main"]/div[@class="content"]/div[@class="general"]/map[@id="Map2"]/area')
for h_area in h_area_array:
url = get_one(h_area.select('@href').extract())
if len(url) > 4 and url[:4] == 'http':
print 'url ' + url
yield Request(url = url, callback = self.parse_goods)
if debug:
break
def idc_info():
if not session:
return redirect('/')
uid = request.args.get('id')
data = {'id': uid}
util.WriteLog("idc_info").info("idc_info:%s" % session['username'])
result = utils.get_one(idc_table, idc_field, data)
if result['code'] == 0:
result = result['msg']
return json.dumps(result)
def process_category_name(self, item, hxs):
origin_category_name = utils.get_one(hxs.select('//body/div[@class="singlecolumnminwidth"]/header/div[@id="navbar"]/div[@id="nav-bar-outer"]/div[@id="nav-bar-inner"]/ul[@id="nav-subnav"]/li[@class="nav-subnav-item nav-category-button"]/a/text()').extract())
category_name = utils.get_zseckill_cateogry_name(origin_category_name)
if not item.has_key('title'):
title = 'unknown'
else:
title = item['title']
log.msg('origin_category_name ' + origin_category_name + ' category_name ' + category_name + ' title ' + title + ' url ' + item['link'], level = log.DEBUG)
item['origin_category_name'] = origin_category_name
item['category_name'] = category_name
def userinfo():
if not session:
return redirect('/')
uid=request.args.get('id')
data={'id':uid}
result=utils.get_one(table,field,data)
util.WriteLog("userinfo","/tmp/info.log").info("userinfo:%s"%session['username'])
if result['code']==0:
data=result['msg']
return json.dumps(data)
def jobdetail():
# if session:
# return redirect("/")
if request.method=="GET":
id=request.args.get("id")
data={}
data['id']=int(id)
result=utils.get_one(table,field,data)
result['msg']['apply_date']=str(result['msg']['apply_date'])
result['msg']['dela_time']=str(result['msg']['dela_time'])
print "result-->",result
return json.dumps(result)
def reg():
if request.method=='POST':
user_dict={k:v[0] for k,v in dict(request.form).items()}
field=['username','name','password','phone','email','role','status']
res=utils.get_one(table,field,user_dict)
if res['code']==0:
result=utils.insert(table,field,user_dict)
util.WriteLog("register","/tmp/info.log").info("register:%s"%user_dict["username"])
return json.dumps(result)
else:
result={'code':1,'msg':'register username is already exists'}
util.WriteLog("register","/tmp/error.log").info("register:%s"%result['msg'])
return json.dumps(result)
return render_template('reg.html')
def reg():
if request.method == 'POST':
user_dict = {k: v[0] for k, v in dict(request.form).items()}
field = [
'username', 'name', 'password', 'phone', 'email', 'role', 'status'
]
user = utils.get_one(table, field, user_dict)
if user['code'] == 1:
result = utils.insert(table, field, user_dict)
return json.dumps(result)
else:
result = {'code': 1, 'msg': 'username is error '}
return json.dumps(result)
return render_template("reg.html")
def server_info():
if not session:
return redirect('/')
uid = request.args.get('id')
data = {'id': uid}
util.WriteLog("server_info").info("server_info:%s" % session['username'])
result = utils.get_one(server_table, server_field, data)
server = utils.list(cab_table, cab_field)
server_list = server['msg']
if result['code'] == 0:
result = result['msg']
return render_template("server_update.html",
res=session,
result=result,
server=server_list)
def cabinet_info():
if not session:
return redirect('/')
uid = request.args.get('id')
data = {'id': uid}
util.WriteLog("cabinet_info").info("cabinet_info:%s" % session['username'])
result = utils.get_one(cab_table, cab_field, data)
idc = utils.list(idc_table, idc_field)
idc_list = idc['msg']
if result['code'] == 0:
result = result['msg']
return render_template("cabinet_update.html",
res=session,
result=result,
idc=idc_list)
def login():
if request.method == 'POST':
user_dict = {k: v[0] for k, v in dict(request.form).items()}
user = utils.get_one(table, field, user_dict)
if user['code'] == 0 and user_dict['password'] == user['msg'][
'password']:
if user['msg']['status'] == 0:
session['username'] = user_dict['username']
session['role'] = user['msg']['role']
data = user
return json.dumps(data)
else:
data = {'code': 1, 'msg': 'username is locking'}
return json.dumps(data)
else:
data = {'code': 1, 'msg': 'username or password is error'}
return json.dumps(data)
return render_template("login.html")
def login():
if request.method=='POST':
user_dict={k:v[0] for k,v in dict(request.form).items()}
user=utils.get_one(table,field,user_dict)
if user['code']==0 and user_dict['password']==user['msg']['password']:
if user['msg']['status']==0:
session['username']=user_dict['username']
session['role']=user['msg']['role']
util.WriteLog("login","/tmp/info.log").info('login:%s'%session['username'])
return json.dumps(user)
else:
data={'code':1,'msg':'username is locking'}
util.WriteLog("login_error","/tmp/error.log").error('login_error:%s'%data['msg'])
return json.dump(data)
else:
data={'code':1,'msg':'username or password is error'}
util.WriteLog("login_error","/tmp/error.log").error('login_error:%s'%data['msg'])
return json.dumps(data)
return render_template("login.html")
def login():
if request.method == 'POST':
user_dict = {k: v[0] for k, v in dict(request.form).items()}
#uid=request.args.get('id')
#user_dict={'id':uid}
user = utils.get_one(table, field, user_dict)
#return json.dumps(data)
if user['code'] == 0 and user_dict['password'] == user['msg'][
'password']:
session['username'] = user_dict['username']
session['role'] = user['msg']['role']
data = user
return json.dumps(data)
else:
data = {'code': 1, 'msg': 'username or password is error'}
return json.dumps(data)
#result={}
return render_template("login.html")
def login():
if request.method == 'GET':
return render_template('login.html')
else:
data = {k: v[0] for k, v in dict(request.form).items()}
user = utils.get_one('user', fields, data)
print(data)
print(user)
if not data.get('name') or not data.get('password'):
errmsg = 'name or password not be null'
return json.dumps({'code': '1', 'errmsg': errmsg})
elif data['name'] == user['name'] and data['password'] == user[
'password']:
session['name'] = user['name']
session['role'] = user['role']
session['id'] = user['id']
return json.dumps({'code': '0', 'result': 'login success'})
else:
errmsg = 'name or password wrong'
return json.dumps({'code': '1', 'errmsg': errmsg})
def userinfo():
uid=request.args.get('id')
result=utils.get_one(User,user_list,uid)
print result
return render_template("update.html",result=result)
def parse(self, response):
hxs = HtmlXPathSelector(response)
h_div = get_one(hxs.select('//body/div[@id="bodydiv"]/div[@class="main_content"]/div/div[@class="left_cont"]/div[@id="msnew"]/div[@class="msnew_infobar"]'))
xpath_list_div = [
['start_time_str', 'div[@class="msnew_infotitle"]/p[@class="msinfotitle_left02"]/text()', 'strip', None],
['from_time', 'span[@class="CountDown"]/@fr', 'int', None],
['to_time', 'span[@class="CountDown"]/@to', 'int', None],
]
if not h_div:
self.log('no page to parse', level = log.WARNING)
return
attr_dict = get_attr(xpath_list_div, h_div)
start_time_str = str(datetime.datetime.now().date()) + " " + attr_dict['start_time_str']
print 'start_time_str ' + start_time_str.encode('utf8')
display_time_begin = int(datetime.datetime.strptime(start_time_str, "%Y-%m-%d %H:%M:%S").strftime("%s"))
print 'display_time_begin ' + str(display_time_begin)
cost_seconds = ((attr_dict['to_time'] - attr_dict['from_time']) / 1000)
print 'cost_seconds ' + str(cost_seconds)
display_time_end = display_time_begin + cost_seconds
print 'display_time_end ' + str(display_time_end)
h_li_array = hxs.select('//body/div[@id="bodydiv"]/div[@class="main_content"]/div/div[@class="left_cont"]/div[@id="msnew"]/div[@class="msnew_infobar"]/ul[@id="ms_tuanlist"]/li')
print "len " + str(len(h_li_array))
xpath_list = [
['img_url', 'div[@class="pic"]/a/img/@src', 'string', None],
['title', 'div[@class="info"]/span/a[@target="_blank"]/@title', 'string', None],
['url', 'div[@class="info"]/span/a[@target="_blank"]/@href', 'string', None],
['origin_price', 'div[@class="info"]/span[@class="gray6"]/text()', 'get_float_str_to_fen', None],
['current_price', 'div[@class="info"]/span[@class="redf16"]/text()', 'get_float_str_to_fen', None],
['sale_info', 'div[@class="info"]/span[@class="red94"]/text()', 'string', None],
]
ret_items = []
for h_li in h_li_array:
attr_dict = get_attr(xpath_list, h_li)
if attr_dict['url'][0] == '/':
attr_dict['url'] = 'http://tuan.vancl.com' + attr_dict['url']
limit = get_num(attr_dict['sale_info'].split(' ')[0])
left = get_num(attr_dict['sale_info'].split(' ')[1])
sale = limit - left
print 'limit ' + str(limit) + " left " + str(left)
prod = VanclMiaoshaItem()
prod['link'] = attr_dict['url']
prod['id'] = hashlib.md5(prod['link']).hexdigest().upper()
prod['title'] = attr_dict['title']
prod['img'] = attr_dict['img_url']
prod['ori_price'] = attr_dict['origin_price']
prod['cur_price'] = attr_dict['current_price']
prod['discount'] = get_discount(attr_dict['origin_price'], attr_dict['current_price'])
#TODO
prod['stat'] = utils.BEGIN
prod['sale'] = sale
prod['sale_percent'] = sale * 100 / limit
prod['display_time_begin'] = display_time_begin
prod['display_time_end'] = display_time_end
#prod['actual_time_begin'] = start_time
#prod['actual_time_end'] = start_time
prod['limit'] = limit
prod['source'] = self.display_name
ret_items.append(prod)
return ret_items
