EasySQL

Custom SQLite helper class simplifying table creation, dictionary insertion, queries, and row deletions.

Methods

def create_table(table_name: str, columns: dict)

Creates a database table using column name keys and data type definition values.

def insert_to_table(table_name: str, values: dict)

Inserts a record using a dictionary mapping column names to row values.

def get_table_values(table_name: str) -> list

Queries and returns all rows from the specified table.

def delete_from_table(table_name: str, conditions: dict)

Deletes matching records using dictionary WHERE conditions.

Usage Example

PYTHON

from inpsPyPI import EasySQL

db = EasySQL("app_db")
db.create_table("users", {"id": "INTEGER PRIMARY KEY", "name": "TEXT"})
db.insert_to_table("users", {"id": 1, "name": "Alice"})
rows = db.get_table_values("users")