#!/usr/bin/env python3
import pyinputplus
import settings
import os
try:
    conn = pymysql.connect(
        user=str(settings.user),
        password=str(settings.password),
        host=str(settings.host),
        port=settings.port,
        database=str(settings.database)
    )
except Exception as e:  # print error message when Exception occurs
    print(f"Error connecting to MariaDB Platform: {e}")
    sys.exit(1)
cur = conn.cursor()
if os.path.exists('/home/uzer/PycharmProjects/pythonProject/data.txt'):
   print("File exists")
else:
   username = pyinputplus.inputEmail('Username (must be existing email): ', limit=3)
   cur.execute('SELECT * FROM database WHERE userID = "' + str(username) + '"')
   bas = cur.fetchone()
   print(str(bas[5]))

 Traceback (most recent call last):
  File "./script.py", line , in <module>
    print(str(bas[5]))
TypeError: 'NoneType' object is not subscriptable

  
username = pyinputplus.inputEmail('Username (must be existing email): ', limit=3)
print('username', repr(username))
cur.execute('SELECT * FROM database WHERE userID = "' + str(username) + '"')
bas = cur.fetchone()
print('bas', repr(bas))
print(str(bas[5]))

 Username (must be existing email): tezt@t.com
username 'tezt@t.com'
bas None
 Traceback (most recent call last):
  File "./script.py", line , in <module>
    print(str(bas[5]))
TypeError: 'NoneType' object is not subscriptable

 cur = conn.cursor()

  
cur.execute('SELECT * FROM database')
res = cur.fetchone()
print('res', repr(res))

  
cur.execute('SELECT userID FROM database')
res = cur.fetchone()
print('res', repr(res))

 Username (must be existing email): dsd@w.de
res (1, 'uzer1@domain.com', '54f914d30e9197941df33a3d822ae8464461b6e1', 950, 14, '90:0e:b3:32:64:74', '', '')

 res ('uzer1@domain.com',)

  
cur.execute('SELECT * FROM database WHERE userID = %s', (username,))

uzer1@domain.com

 res (1, 'uzer1@domain.com', '54f914d30e9197941df33a3d822ae8464461b6e1', 950, 14, '90:0e:b3:32:64:74', '', '')

 res None