sqliteframe
package
SQLiteFrame is a lightweight, zero-dependency ORM for SQLite in Python.
SQLiteFrame is an SQLite ORM for python, designed to be as lightweight, intuitive, and simple to use as possible. It is designed to closely mimic SQL syntax whilst remaining as pythonic as possible to save developers valuable time (and brain cells) when interacting with SQLite databases, by building reusable SQLite query objects using method-chaining, and abstracting away SQLite's connection and cursor system with a single context manager.
Sub-Packages
entity
A subpackage containing the logic behind tables and table columns.
foreign_key
A subpackage containing all foreign key logic, for linking tables in relational databases.
join
A subpackage containing logic for SQL statements that include JOIN clauses.
order_by
A subpackage containing logic for SQL statements that include ORDER BY clauses.
parameterized
A subpackage containing logic for parameterized queries.
pragma
A subpackage containing logic for SQLite PRAGMA commands.
result
A subpackage containing logic for the results of any executed SQL statements.
statements
A subpackage containing the logic behind each of the core statements that can be executed in SQLiteFrame.
suggested_schema
A subpackage containing logic for suggesting schemas for working with already-created SQLite databases.
types
A subpackage containing all the data type logic for SQLiteFrame, including conversions between Python and SQLite types.
where
A subpackage containing logic for SQL statements that include WHERE clauses.
wildcards
A simple subpackage containing each of the wildcards that can be used when building SQL statements.
Modules
database
A module containing the logic behind database connections and execution.
Source
"""
SQLiteFrame is a lightweight, zero-dependency ORM for SQLite in Python.
SQLiteFrame is an SQLite ORM for python, designed to be as lightweight, intuitive, and simple to use as possible.
It is designed to closely mimic SQL syntax whilst remaining as pythonic as possible
to save developers valuable time (and brain cells) when interacting with SQLite databases,
by building reusable SQLite query objects using method-chaining, and abstracting away
SQLite's connection and cursor system with a single context manager.
"""
from .database import Database
from .entity import table
from .types import Integer, String, Type, Boolean, Date, Time, Blob, Float, Types
from .wildcards import Wildcards
from .foreign_key import ForeignKey, Restraints as FKRestraints
from .result import Result
from .join import JoinTypes
from .order_by import OrderTypes
from .statements import Pragma
from .pragma import PragmaTypes, PragmaStatements
from .suggested_schema import SuggestedSchema
from .parameterized import Parameterized