sqlitelib
sqlitelib
is a Python library that provides an easy-to-use interface for common SQLite database operations. It simplifies database interactions, making it easier to perform tasks like creating tables, inserting records, querying data, and more.
Features
- Connect to SQLite databases
- Create tables
- Insert, update, and delete records
- Query data with flexible options
- Simple and intuitive API
Installation
You can install sqlitelib
using pip:
pip install sqlitelib
Usage
from sqlitelib import SqliteModel, Column, Constraint, DataType
class ExportJob(SqliteModel):
__databasepath__ = 'path/to/db.db'
__tablename__ = 'export_job'
job_type = Column(DataType.TEXT, Constraint.NOT_NULL)
status = Column(DataType.TEXT, Constraint.NOT_NULL)
completed_date = Column(DataType.INTEGER)
export_parameters_json = Column(DataType.TEXT)
description = Column(DataType.TEXT)
directory_path = Column(DataType.TEXT)