Function insert_record

24-class-metaprog/persistent/dblib.py:118–127

(table_name: str, data: dict[str, Any])

def insert_record(table_name: str, data: dict[str, Any]) -> int:
    check_identifier(table_name)
    con = get_connection()
    placeholders = ', '.join(['?'] * len(data))
    sql = f'INSERT INTO {table_name} VALUES (NULL, {placeholders})'
    cursor = con.execute(sql, tuple(data.values()))
    pk = cursor.lastrowid
    con.commit()
    cursor.close()
    return pk


def fetch_record(table_name: str, pk: int) -> sqlite3.Row: