Metadata-Version: 2.2
Name: sqlitelib
Version: 1.0.4
Summary: A sqlite lib that encapsulate common sqlite operations
Home-page: https://github.com/kejun91/sqlitelib
Author: Jun Ke
Author-email: kejun91@gmail.com
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
License-File: LICENSE
Dynamic: author
Dynamic: author-email
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: requires-python
Dynamic: summary

# 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:

```bash
pip install sqlitelib
```

## Usage
```python
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)
```
