def region(bot, update):
query = "SELECT lang, region FROM users WHERE user_id = %s"
extract = database.query_r(query, update.message.from_user.id, one=True)
lang = extract[0]
region = extract[1]
text = get_lang.get_string(lang, "choose_region")
reply_markup = keyboards.private_region_kb(lang, region)
update.message.reply_text(text=text, reply_markup=reply_markup)
def set_private_region(bot, query):
region = query.data.split(":")[1]
query_db = "UPDATE users SET region = %s WHERE user_id = %s RETURNING lang"
extract = database.query_wr(query_db, region, query.from_user.id, one=True)
lang = extract[0]
query.answer()
try:
query.message.edit_reply_markup(
reply_markup=keyboards.private_region_kb(lang, region))
except TelegramError as e:
if str(e) != "Message is not modified": print(e)
def private_region(bot, query):
query.answer()
query_db = "SELECT lang, region FROM users WHERE user_id = %s"
extract = database.query_r(query_db, query.from_user.id, one=True)
lang = extract[0]
region = extract[1]
text = get_lang.get_string(lang, "choose_region")
reply_markup = keyboards.private_region_kb(lang, region)
try:
query.edit_message_text(text=text, reply_markup=reply_markup)
except TelegramError as e:
if str(e) != "Message is not modified": print(e)
def first_start(bot, update):
user_id = update.message.from_user.id
query = """
SELECT 1
FROM USERS
WHERE user_id = %s
FETCH FIRST 1 ROW ONLY
"""
extract = database.query_r(query, user_id, one=True)
if extract is None: # this is the first time the user starts the bot
# send region choose
guessed_lang = utils.guessed_user_lang(bot, update)
text = get_lang.get_string(guessed_lang, "choose_region")
reply_markup = keyboards.private_region_kb(guessed_lang, guessed_lang)
update.message.reply_text(text=text, reply_markup=reply_markup)