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