Create an SQLite function: GUID()

function.py

import sqlite3
import uuid

"""
CREATE TABLE "users" (
	"user_id"	TEXT NOT NULL,
	"user_email"	TEXT NOT NULL UNIQUE,
	"user_password"	TEXT NOT NULL,
	PRIMARY KEY("user_id")
);
"""

user = ["[email protected]", "pass1"]

conn = sqlite3.connect("cruder.db")

def guid():
    return str(uuid.uuid4()).upper()

conn.create_function("GUID", 0, guid)

cur = conn.cursor()
cur.execute("INSERT INTO users (user_id, user_email, user_password) VALUES (GUID(), ?, ?)", user)
conn.commit()

provider.py

import datetime
import hashlib
import uuid

class provider():
    def __init__(self):
        pass

    def id(self):
        return str(uuid.uuid4()).upper()

    def now(self):
        return str(datetime.datetime.now())[0:19]

    def sha256(self, data):
        secret = "seCretKeY"
        return hashlib.sha256((data+secret).encode()).hexdigest().upper()