Function db_init

Scripts/ButSystem.py:677–1056

db_init. Database helper for connecting to or initializing the SQLite database. This docstring was expanded to make future maintenance easier. Returns: Varies.

()

This docstring was added automatically to improve maintainability.

Args:
    plaintext: Parameter.

Returns:
    Varies.
"""
    nonce = os.urandom(NONCE_LEN)
    cipher = Cipher(algorithms.AES(MASTER_KEY), modes.GCM(nonce))
    enc = cipher.encryptor()
    ct = enc.update(plaintext.encode("utf-8")) + enc.finalize()
    blob = nonce + enc.tag + ct
    return base64.urlsafe_b64encode(blob).decode("ascii")

def aesgcm_decrypt_text(blob_b64: str) -> str:
    """aesgcm_decrypt_text.

Internal helper function.

This docstring was added automatically to improve maintainability.

Args:
    blob_b64: Parameter.

Returns:
    Varies.
"""
    blob = base64.urlsafe_b64decode(blob_b64.encode("ascii"))
    nonce = blob[:NONCE_LEN]
    tag = blob[NONCE_LEN:NONCE_LEN+TAG_LEN]
    ct = blob[NONCE_LEN+TAG_LEN:]
    cipher = Cipher(algorithms.AES(MASTER_KEY), modes.GCM(nonce, tag))
    dec = cipher.decryptor()
    pt = dec.update(ct) + dec.finalize()
    return pt.decode("utf-8", errors="replace")

# ---------------------------
# Database
# ---------------------------

def db_connect():
    """db_connect.

Database helper for connecting to or initializing the SQLite database.

This docstring was expanded to make future maintenance easier.

Returns:
    Varies.
"""
    conn = sqlite3.connect(DB_PATH, check_same_thread=False)
    conn.row_factory = sqlite3.Row
    conn.execute("PRAGMA foreign_keys = ON;")
    return conn

def now_z() -> str:
    """now_z.

Internal helper function.