SQLite

The SQLite query runner allows you to connect to and query SQLite database files. It's lightweight and perfect for local development or small applications.

Configuration

The SQLite query runner requires the following configuration:

{
  "dbpath": "/path/to/your/database.sqlite"
}

Configuration Schema

Parameter	Type	Required	Description
dbpath	String	Yes	The file path to your SQLite database file

Example Usage

from legion_query_runner.query_runner import QueryRunner

# Initialize with SQLite configuration
sqlite_config = {
    "dbpath": "/path/to/your/database.sqlite"
}

# Create a QueryRunner instance
runner = QueryRunner('sqlite', sqlite_config)

# Test connection
runner.test_connection()

# Execute a query
results = runner.run_query("SELECT * FROM users LIMIT 10")

Type Mapping

The SQLite query runner maps SQLite data types to standardized types:

SQLite Type	Legion Type
INTEGER	INTEGER
REAL	FLOAT
FLOAT	FLOAT
NUMERIC	FLOAT
TEXT	STRING
TIMESTAMP	DATETIME
DATETIME	DATETIME
DATE	DATE
BOOLEAN	BOOLEAN

Other types are mapped to STRING by default.

Schema Retrieval

The SQLite query runner extracts schema information using SQLite's system tables and PRAGMA commands:

# Get schema for all tables
schema = runner.get_schema()

# Get columns for a specific table
columns = runner.get_table_columns("users")

# Get column types for a specific table
column_types = runner.get_table_types("users")

Implementation Details

The SQLite query runner uses the native Python sqlite3 library to connect to SQLite databases. It handles query execution, schema retrieval, and type mapping.

It also supports transaction management by automatically committing changes for INSERT/UPDATE/DELETE queries.