import sqlite3
import hashlib
 
db = sqlite3.connect('test.db')
cursor = db.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT unique, password TEXT)''')
 
def add_user(name, passw):
    cursor.execute('''INSERT INTO users(name, password) VALUES(?,?)''', (name, hashlib.md5(passw).hexdigest()))
    db.commit()
 
def authoriz(name, passw):
    if cursor.execute('''SELECT password FROM users WHERE name=?''', (name,)).fetchone() == (hashlib.md5(passw).hexdigest(),): return True
 
add_user('terabayt', 'qwerty')
if authoriz('terabayt', 'qwerty'):
    print('Authorization ok!')
else: print(':(')