Execute a query in a SQLite-type database.

sqlite_query_executor.py

#!/usr/bin/env python3
import sqlite3
import typing

def execute_db_query(db_filename: str, query: str, parameters: tuple=()) \
                    -> typing.Any:
    """Execute a query in a SQLite-type database.
    
    Args:
        db_filename: string with the name of the SQLite file.
        query: strig with the SQL query.
        parameters: tupla with the query parameters.

    Returns:
        a tuple of data in case of SELECT queries or an integer with the number of affected rows.

    Use:
        query      = "INSERT INTO contacts VALUES (NULL, ?, ?);"
        parameters = (namefield, numfield)
        result     = execute_db_query(query, parameters)
    """
    with sqlite3.connect(db_filename) as conn:
        cursor       = conn.cursor()
        query_result = cursor.execute(query, parameters)
        conn.commit()
    return query_result