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()