Sqlite for LibreOffice on Windows

>>> from sql_util import SqlCtx
>>> from pathlib import Path
>>> cs = Path.home() / "Documents/test.db"

# Creating a Connection to a SQLite Database
>>> with SqlCtx(cs) as db:
...     print(db.connection.total_changes)
... 
0

# Creating a table in the database
>>> with SqlCtx(cs) as db:
...     _ = db.cursor.execute("CREATE TABLE fish (name TEXT, species TEXT, tank_number INTEGER)")
... 


# Adding Data to the SQLite Database
>>> with SqlCtx(cs) as db:
...     with db.connection:
...         _ = db.cursor.execute("INSERT INTO fish VALUES ('Sammy', 'shark', 1)")
...         _ = db.cursor.execute("INSERT INTO fish VALUES ('Jamie', 'cuttlefish', 7)")
...     print(db.connection.total_changes)
... 
2

# Reading Data from the SQLite Database
>>> with SqlCtx(cs) as db:
...     rows = db.cursor.execute("SELECT name, species, tank_number FROM fish").fetchall()
...     for row in rows:
...         for key in row.keys():
...             print(f"{key} = {row[key]}")
... 
name = Sammy
species = shark
tank_number = 1
name = Jamie
species = cuttlefish
tank_number = 7

>>> with SqlCtx(cs) as db:
...     target_fish_name = "Jamie"
...     rows = db.cursor.execute(
...         "SELECT name, species, tank_number FROM fish WHERE name = ?",
...         (target_fish_name,),
...     ).fetchall()
...     for row in rows:
...         for key in row.keys():
...             print(f"{key} = {row[key]}")
... 
name = Jamie
species = cuttlefish
tank_number = 7


# Modifying Data in the SQLite Database
>>> with SqlCtx(cs) as db:
...     new_tank_number = 2
...     moved_fish_name = "Sammy"
...     with db.connection:
...         _ = db.cursor.execute("UPDATE fish SET tank_number = ? WHERE name = ?", (new_tank_number, moved_fish_name))
...         rows = db.cursor.execute("SELECT name, species, tank_number FROM fish").fetchall()
...         for row in rows:
...             for key in row.keys():
...                 print(f"{key} = {row[key]}")
... 
name = Sammy
species = shark
tank_number = 2
name = Jamie
species = cuttlefish
tank_number = 7


# Deleting Data from the SQLite Database
>>> with SqlCtx(cs) as db:
...     target_fish_name = "Sammy"
...     with db.connection:
...         _= db.cursor.execute("DELETE FROM fish WHERE name = ?", (target_fish_name,))
...         rows = db.cursor.execute("SELECT name, species, tank_number FROM fish").fetchall()
...         for row in rows:
...             for key in row.keys():
...                 print(f"{key} = {row[key]}")
... 
name = Jamie
species = cuttlefish
tank_number = 7