def login(res_path): if res_path=="/login.html": with open('static'+res_path,'rb') as r_file: respone_content = r_file.read() return respone_content else: re_data = re.findall(r"\/login\?(.*)", res_path) data_list = re_data[0].split("&") data_dict = dict([data_list[0].split("="), data_list[1].split("=")]) username = data_dict["username"] password = data_dict["password"] print(">>>>>>>>>>>",username,password) # 用户填写的数据不全的时候 if not all([username, password]): print("用户请求的数据不完成") respone_content=index("/nothings.html") return respone_content result=db.get_info(username,password) if result: respone_content=index("/index.html") return respone_content else: db.insert_info((username, password)) print("注册成功------" + username + "------" + password) respone_content = index("/registered.html") return respone_content
def GET(self): int_id = web.input().IntID kwargs = db.get_info(int_id) timings = self.calcYAR(kwargs) self.calcPed(kwargs, timings) render = web.template.render("templates") return render.output(kwargs, timings)
def alarm_contact_info_email_post(): """ Generate email with link to confirm. :return: """ # TODO: Authenticate Isadore Instance # TODO: Limit number of times can confirm? # TODO: Confirm expire date? # TODO: Implement info = db.get_info(email=email) oneday = datetime.timedelta(days=1) if info["email_verify"]: last_try_date = info["email_verify"]["last_try"] if datetime.datetime.now() - last_try_date < oneday: abort(400) confirm_code = hashlib.sha1() confirm_code.update(os.urandom(24)) confirm_code = confirm_code.hexdigest() email_verify = {"last_try": datetime.datetime.now(), "confirm_code": confirm_code} db.update_info(info_update=email_verify, email=email) urlparams = urllib.urlencode({"email": email, "confirm_code": email_verify["confirm_code"]}) msgtxt = twiml_messages.email_verify_txt % (urlparams, email_verify(["confirm_code"])) msghtml = twiml_messages.email_verify_html % (urlparams, urlparams, email_verify["confirm_code"]) messaging.sendEmail(toemail=email, fromemail='*****@*****.**', messageTXT=msgtxt, messageHTML=msghtml) return ('Sent', 204)
def showInfo(): # 取个人信息 glo_userID = glo.get_value('glo_userID') glo_identity = glo.get_value('glo_identity') # logger.info("<全局变量> glo_userID:"+glo_userID+" glo_identity:"+glo_identity) db_info = db.get_info(glo_userID, glo_identity) logger.info("<数据库传回> " + str(db_info)) return render_template('myinfo.html', identity=glo_identity, info=db_info)
def get_action(maze_id, action_id): world = db.get_world(maze_id) if action_id > world.client_counter: world.client_counter = action_id db.save_world(maze_id, world) info = db.get_info(maze_id, action_id) print "GETTING", maze_id, action_id return info
def get_action(maze_id,action_id): world = db.get_world(maze_id) if action_id > world.client_counter: world.client_counter = action_id db.save_world(maze_id, world) info = db.get_info(maze_id, action_id) print "GETTING", maze_id, action_id return info
def actions(bot, update): global add_adm # print(add_adm) if add_adm: if update.message.text == '/cancel': add_adm = False else: for row in db.get_info(): if row[1] == update.message.text: admins.add_message(row[0], row[1]) update.message.reply_text(str(update.message.text) + ' теперь админ.') add_adm = False return update.message.reply_text('Неправильный username.') global del_adm if del_adm: if update.message.text == '/cancel': del_adm = False else: for row in db.get_info(): if row[1] == update.message.text: if update.message.text != 'kirr_ya': admins.del_message(row[0], row[1]) del_adm = False update.message.reply_text(str(update.message.text) + ' теперь НЕ админ.') return update.message.reply_text('Неправильный username.') global broad if broad: if update.message.text == '/cancel': broad = False else: for row in db.get_info(): try: bot.send_message(row[0], update.message.text) except: pass broad = False
def index(): user_name = request.form.get('uname') password = request.form.get('psw') login_success = False if user_name: results = db.get_info(user_name, password) login_success = bool(results) if login_success: return render_template('result.html', results=results) else: return render_template('index.html', user_name=user_name)
def lk(lktype, username, pwd, fields="", result_text="", additional=""): return ''' <div hidden="true" id="card" class="lk-card"> <h1>Personal page</h1><br> <p id="''' + lktype + '''" username="******" cookie="''' + pwd + '''"></p> <p>Hello, ''' + db.get_info( username, 'fullname') + '''! That's your personal employee page.</p> <form id="select_from_employee_table" method="post"> <p>Please check if information in your personal card is correct. Following information is available: ''' + fields + '''</p> <p><input type=text name=field placeholder="What do you want to search"> <p><input type=submit value=Search> <p id="main_text">''' + result_text + '''</p> </form>''' + additional + '''
def alarm_contact_confirm_sms_put(): """ Confirm phone that was done through SMS. :return: """ # TODO: Authenticate Isadore Instance # TODO: Limit number of times can confirm? # TODO: Confirm expire date? info = db.get_info(phone=phone) oneday = datetime.timedelta(days=1) if info["phone_verify"] and info["phone_verify"]["last_try"] < oneday: verify_key = request.form.get("confirm_code") if info["phone_verify"]["confirm_code"] == verify_key: db.set_verified(phone=phone) return ('Verified', 204) abort(400)
def alarm_contact_info_confirm_voice(): """ Generate confirm code and send call voice phone number. :return: """ # TODO: Authenticate Isadore Instance # TODO: Limit number of times can confirm? # TODO: Confirm expire date? # TODO: Implement info = db.get_info(phone=phone) oneday = datetime.timedelta(days=1) if info["phone_verify"]: last_try_date = info["phone_verify"]["last_try"] if datetime.datetime.now() - last_try_date < oneday: abort(400) phone_verify = {"last_try": datetime.datetime.now(), "confirm_code": None} db.update_info(info_update=phone_verify, phone=phone) messaging.makeCall(phone, 'https://alarms.example.com/alarm_contact_info_phone/confirm/voice2') return ('Sent', 204)
def start(bot, update): # print(update) # print(update.message.chat.id) user_id = update.message.chat.id username = update.message.chat.username update.message.reply_text( "Держи свой чек-лист:\ndrive.google.com/fsjsdfjsjfkjs\n\n" + "Телеграм-канал, где Инна делится инсайтами по финансовой грамотности:\n\n" + "t.me/test_channel12312") flag = False for row in db.get_info(): if row[0] == user_id: flag = True if not flag: db.add_message(int(user_id), username)
def alarm_contact_confirm_sms_post(): """ Generate confirm code and send out confirm sms message. :return: """ # TODO: Authenticate Isadore Instance # TODO: Limit number of times can confirm? # TODO: Confirm expire date? # TODO: Implement info = db.get_info(phone=phone) oneday = datetime.timedelta(days=1) if info["phone_verify"]: last_try_date = info["phone_verify"]["last_try"] if datetime.datetime.now() - last_try_date < oneday: abort(400) phone_verify = {"last_try": datetime.datetime.now(), "confirm_code": random.randint(100000, 999999)} db.update_info(info_update=phone_verify, phone=phone) msg = twiml_messages.sms_verify % (phone_verify["confirm_code"]) messaging.sendTxt(phone, msg) return ('Sent', 204)
def get_text_messages(message): s = message.text if s == "🔥 Номера": bot.send_message(message.chat.id, "Пожалуйста, выберете для каких целей вы хотите арендовать номер", reply_markup=num()) elif s == "🆘 Правила": bot.send_message(message.chat.id, "1. Главное:\n1.1 Мы продаем номера, без инструкций к их использованию. Вся ответственность после покупки номеров только на вас.\n1.2 Если комментарий при оплате был указан неверно, администрация имеет полное право не делать замену\n1.3 Администрация оставляет за собой право вносить любые изменения и дополнения в Правила, без предупреждения!\n1.4 Администрация вправе обнулить ваш лицевой счет.\n\nФОРМА ОБРАЩЕНИЯ\n1) Переписка с ботом + скрины переписки + скрин оплаты\n2) Предоставляйте видеозапись проверки номера с момента покупки в магазине и проверки на офф.сайте сервиса, который купили. Видео должно быть одно и цельное. ( ОБЯЗАТЕЛЬНО ) Отклонения от формы будут игнорироваться!!!", reply_markup=menu()) elif s == "💰 Баланс": b = db.get_balance(message.chat.id) s = int(b) if int(b) == float(b) else float(b) bot.send_message(message.chat.id, "Ваш баланс: " + str(s) + 'р.', reply_markup=balance()) bot.register_next_step_handler(message, money) elif s == '💩 Помощь': bot.send_message(message.chat.id, 'Обратитесь к @freddy_support ', reply_markup=menu()) elif s == "↪ В главное меню ↩": bot.send_message(message.chat.id, "Вы в главном меню", reply_markup=menu()) elif s == "💼 Мой профиль": lst = db.get_info(message.chat.id) bot.send_message(message.chat.id, 'id: {}\nКоличество заказов: {}шт. \nСумма всех ваших покупок: {}р.'.format(message.chat.id, len(lst), sum(lst))) else: bot.send_message(message.chat.id, 'Воспользуйтесь клавиатурой', reply_markup=menu())
def found_result(username, text): return text + " found for user " + username + ": " + str( db.get_info(username, text))
def GET(self): int_id = web.input().IntID kwargs = db.get_info(int_id) location = db.get_info()["location"] render = web.template.render("templates", globals={"map": map, "str": str, "zip": zip}) return render.intersection(kwargs, location)
def GET(self): render = web.template.render("templates") location = db.get_info()["location"] or "Unknown" return render.home(location)
def users_list(bot, update): if check_for_admin(bot, update): for row in db.get_info(): update.message.reply_text(row)
def alarm_contact_info(): # TODO: Authenticate info = db.get_info(email=email) return responseJSON(info[1])
# some_file.py import sys # insert at 1, 0 is the script path (or '' in REPL) sys.path.insert(1, '/home/thelyolya/source/insecure/src/py') import db db.initialize_db("/home/thelyolya/source/insecure/test/test.db") fields = db.get_available_fields_list() signums = db.get_all_signums_list() for user in signums: for field in fields: print(db.get_info(user, field)) print(db.get_info("demo", """ * FROM employee -- """))
def alarm_contact_info(): # TODO: Authenticate Isadore instance info = db.get_info(phone=phone) return responseJSON(info[1])