init_user.py

import sqlite3
import hashlib
import os
import pickle

# create a ramdom salt
salt = os.urandom(16)

# endcode password with mixxing salt
original_data = "admin".encode('utf-8')
data_with_salt = salt + original_data
hasher = hashlib.sha256()
hasher.update(data_with_salt)
encode_pass = hasher.digest()

#store password
conn = sqlite3.connect('user.db')
cursor = conn.cursor()
query_history = []
cursor.execute('''drop table if exists users''')
cursor.execute('''create table if not exists users (
                    username text primary key,
                    password BLOB,
                    salt BLOB,
                    current_db text,
                    query_history BLOB)''')
cursor.execute('''insert into users
                    values("admin",?,?,"",?)''',(encode_pass,salt,pickle.dumps(query_history),))
conn.commit()
conn.close()