cx-notes/tests/02-database.py

import sys
import pathlib
import sqlmodel

file = pathlib.Path(__file__)
directory = file.parent
import_root = directory.parent

sys.path.append(str(import_root))

from assets import user
from assets import user_validator
from assets import users_manager

database = sqlmodel.create_engine("sqlite:///database.db")
connection = sqlmodel.SQLModel.metadata.create_all(database)
manager = users_manager(connection)

first_user = user()

user.nick = "First"
user.secret = "Secret"

print("User created, registering...")

manager.register(user)

print("Registered, trying to log in...")

check = manager.login("First", "Secret")