def query(): setting = sql.init_setting() if request.method == 'GET': if 'ADSUSERID' in request.cookies: uid = request.cookies.get('ADSUSERID') data = sql.init_user(uid) return render_template('query.html', is_signup=True, data=data, setting=setting) else: return redirect(url_for('info')) elif request.method == 'POST': uid = uuid.uuid4().hex.upper() result = request.form.to_dict() if not any(isBlank(value) for value in result.values()): sql.add_user(uid, result['name'], result['tel'], result['mail'], result['province'], result['category'], result['score'], result['school']) data = sql.init_user(uid) resp = make_response(redirect(url_for('query'))) resp.set_cookie('ADSUSERID', uid, max_age=60 * 60 * 24 * 365) # Max age is 365 days. return resp else: return json.dumps({ 'message': 'fail', 'error_code': '2001', 'error_desc': 'String is blank' }) return "success"
def main(): TOKEN = get_token() API = auth(TOKEN) lapssh = User('stupport', API) print(lapssh.groups_get()) target_id = get_target(API) target = User(target_id, API) get_age(target) # получаем возраст цели if not target.city: # уточняем город цели get_city(target) base_users = get_match_users( target, API) # получаем список найденных пользователей get_top3_photos(base_users, API) # сопоставляем три фотограифи sorted_users = reversed(sorted( base_users, key=operator.attrgetter('kpi'))) # сортируем по весам # - - - П Р А В К И - - - if sql.get_db_status() == False: db = False # проверка доступности БД else: db = True sql.delete_tables() # удаляем старые таблицы sql.create_db(target.id) # создаем новые таблицы for i in sorted_users: temp = i.show_result() # print(temp) temp_json = json.dumps(temp) if db: sql.add_user(i.id, i.kpi, temp_json) # отправляем все, что нашли в БД else: file_base.add_user(i.id, i.kpi, temp_json) # отправляем все, что нашли в файл show_results(db) # выводим результат
def test_users(self): sql.create_table_users() sql.add_user("Joe", "Bob", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo") sql.add_user("Jim", "Greg", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo") users = sql.get_users() self.assertEqual(2, len(users)) self.assertEqual("Joe", users[0].first_name) self.assertEqual("*****@*****.**", users[1].email) user = sql.get_user(1) # print(user) self.assertEqual("Joe", user.first_name) user = sql.get_user(2) self.assertEqual("Greg", user.last_name) user = sql.get_user(10) self.assertIsNone(None) sql.update_user("Jeff", "Kwok", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo", "1") user = sql.get_user(1) # print(user) self.assertEqual("*****@*****.**", user.email) self.assertEqual("jeff's farm", user.f_name) # print(user.p_number) sql.delete_table_users()
def getusername(update, context): 'save username and id' username = update.effective_message.text.strip() sql.add_user(update.effective_user.id, username) message = "Next up is Authorization. I need permissions to see what you're listening to." button = InlineKeyboardMarkup([[InlineKeyboardButton(text="Authorize", url=authlink)]]) update.effective_message.reply_text(message, reply_markup=button) return ConversationHandler.END
def register(self): name = input("Please enter your name - ") age = int(input("How old are you? ")) password = input("Please enter your password - ") sql.add_user(name, age, password, self.get_new_acct_no()) print("Successfully created account \n")
def test_offered_items_produce(self): sql.create_table_users() sql.add_user("Ana", "Elias", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo") sql.create_table_offered_items_produce() sql.add_produce_item_by_user_id("1", "Carrots", "Bag", "2019-01-01", "Seed", "True", "True", "Fertilzier", "pestocide", "90", "True", "90", "100", "80", "75", "0", "500", "2019-03-01", "Calgary", "Helllllooooo", "Pending Approval") sql.add_produce_item_by_user_id("1", "Cabbage", "Head", "2019-01-01", "Seed", "True", "True", "Fertilzier", "pestocide", "90", "True", "90", "100", "80", "75", "0", "500", "2019-03-01", "Calgary", "Helllllooooo", "Pending Approval") sql.add_user("Larry", "Lemi", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo") sql.add_produce_item_by_user_id("2", "Wheat", "Bunch", "2019-01-01", "Seed", "True", "True", "Fertilzier", "pestocide", "90", "True", "90", "100", "80", "75", "0", "500", "2019-03-01", "Calgary", "Helllllooooo", "Sold") offered_items = sql.get_offered_items_produce_by_id(2) # print(offered_items) self.assertEqual("Sold", offered_items[0].Status) self.assertEqual("Wheat", offered_items[0].Product_name) offered_items_detail = sql.get_offered_items_produce_details_by_id(2) # print(offered_items_detail) self.assertEqual("Cabbage", offered_items_detail.Product_name) all_offered_items = sql.get_all_offered_items_produce() # print(all_offered_items) self.assertEqual(3, len(all_offered_items)) sql.update_offered_items_produce_detail( "2", "Beat", "Head", "2019-01-01", "Seed", "True", "True", "Fertilzier", "pestocide", "90", "True", "90", "100", "80", "75", "0", "500", "2019-03-01", "Calgary", "Helllllooooo", "Pending Approval", "1") offered_items_detail = sql.get_offered_items_produce_details_by_id(1) # print(offered_items_detail) self.assertEqual("Beat", offered_items_detail.Product_name) sql.delete_table_offered_items_produce() sql.delete_table_users()
def test_offered_items_livestock(self): sql.create_table_users() sql.add_user("Ana", "Elias", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo") sql.create_table_offered_items_livestock() sql.add_livestock_item_by_user_id( "1", "Beef", "Angus", "True", "2019-03-01", "12345", "678", "500", "600", "1", "2019-02-01", "Grass", "Alfa", "Barley", "2019-03-05", "600", "800", "1", "Hellllooooo", "1000", "2019-04-05", "Calgary", "Pending Approval") sql.add_livestock_item_by_user_id( "1", "Beef", "Birkshire", "True", "2019-03-02", "12345", "678", "500", "600", "1", "2019-02-01", "Grass", "Alfa", "Barley", "2019-03-05", "600", "800", "1", "Hellllooooo", "1000", "2019-04-05", "Calgary", "Pending Approval") sql.add_user("Larry", "Lemi", "123-456-7890", "890-123-4567", "*****@*****.**", "jeff's farm", "calgary", "southern alberta", "TRUE", "TRUE", "TRUE", "2018-09-01", "livestock", "5", "none", "none", "none", "none", "none", "none", "none", "none", "none", "none", "hellllooooo") sql.add_livestock_item_by_user_id( "2", "Chicken", "Birkshire", "True", "2019-03-02", "12345", "678", "500", "600", "1", "2019-02-01", "Grass", "Alfa", "Barley", "2019-03-05", "600", "800", "1", "Hellllooooo", "1000", "2019-04-05", "Calgary", "Sold") offered_items = sql.get_offered_items_livestock_by_id(2) # print(offered_items) self.assertEqual("Sold", offered_items[0].Status) self.assertEqual("Chicken", offered_items[0].Product_name) offered_items_detail = sql.get_offered_items_livestock_details_by_id(2) # print(offered_items_detail) self.assertEqual("Birkshire", offered_items_detail.Breed) all_offered_items = sql.get_all_offered_items_livestock() print(all_offered_items) self.assertEqual(3, len(all_offered_items)) sql.update_offered_items_livestock_detail( "1", "Beef", "Birkshire", "True", "2019-03-02", "12345", "678", "500", "600", "1", "2019-02-01", "Grass", "Alfa", "Barley", "2019-03-05", "600", "800", "1", "Hellllooooo", "1000", "2019-04-05", "Calgary", "Pending Approval", "1") offered_items_detail = sql.get_offered_items_livestock_details_by_id(1) # print(offered_items_detail) self.assertEqual("Beef", offered_items_detail.Product_name) sql.delete_table_offered_items_livestock() sql.delete_table_users()
def add_user(username, password): add_success = sql.add_user(username,password) if(add_success): return page_view("validSign", name=username) else: return page_view("invalidSign", reason="Username taken")
error_mess = '<span class="alert alert-danger" id="error">All fields must be completed <a title="Close" id="errorMess"><b>X</b></a></span>' if form.getvalue('newuser') is not None: email = form.getvalue('newemail') password = form.getvalue('newpassword') role = form.getvalue('newrole') group = form.getvalue('newgroupuser') new_user = form.getvalue('newusername') page = form.getvalue('page') activeuser = form.getvalue('activeuser') role_id = sql.get_role_id_by_name(role) if sql.check_group(group, role_id): if funct.is_admin(level=role_id): if sql.add_user(new_user, email, password, role, group, activeuser): from jinja2 import Environment, FileSystemLoader env = Environment(loader=FileSystemLoader('templates/')) template = env.get_template('ajax/new_user.html') template = template.render(users=sql.select_users(user=new_user), groups=sql.select_groups(), page=page, roles=sql.select_roles()) print(template) funct.logging('a new user '+new_user, ' has created ', haproxywi=1, login=1) else: funct.logging(new_user, ' tried to privilege escalation', haproxywi=1, login=1) if form.getvalue('userdel') is not None:
def start_handler(message): user_id = message.from_user.id db.add_user(user_id, message.from_user.username) bot.send_message(user_id, menu_message.format(*get_rates()), reply_markup=menu_markup)
async def send_welcome(message): await bot.send_message(message.chat.id, config.welcome_message) sql.add_user(c, message.from_user) conn.commit()