def check_connect(): try: where = 'telegram = %s' % 12345 menu = connect_mysql.select('users', where, *['telegram']) except Exception as e: print('e', e) connect_mysql.open() return True
def select_last_street(telegram): check_connect() water = "'water'" where = 'telegram = %s and goods = %s ORDER BY order_number DESC LIMIT 1;' % ( telegram, water) return connect_mysql.select( 'basket', where, *[ 'order_number', 'telegram', 'name', 'phone', 'goods', 'amount', 'sum', 'street' ])
def select_user(telegram): check_connect() where = 'telegram = %s' % telegram return connect_mysql.select('users', where, *['telegram', 'name', 'phone'])
def select_menu(telegram): check_connect() where = 'telegram = %s' % telegram return connect_mysql.select('menu', where, *['telegram', 'message_id', 'text', 'index'])
def check_user(telegram): check_connect() where = 'telegram = %s' % telegram return connect_mysql.select('users', where, *['telegram'])
def select_contactID(telegram): check_connect() where = 'telegram = %s' % telegram return connect_mysql.select('users', where, *['contact_id']).get('contact_id')
def get_message_db(telegram): conditional_query = "telegram = %s" result = connect_mysql.select("message", conditional_query, *["message_id"], **{'telegram': telegram}) return result
def get_branch_db(telegram): conditional_query = "telegram = %s" result = connect_mysql.select("branches", conditional_query, *["branch"], **{'telegram': telegram}) return result