Manage your sqlite database very easy (like django) ...

eSQL | SQLite manager

Manage your SQLite like django models.

See full documention here.

Example:

import eSQL

eSQL.connect("database.db")

class User(eSQL.Model):
    id = eSQL.IntegerField(primary_key=True, not_null=True)
    name = eSQL.TextField(not_null=True)

eSQL.migrate()
# ...

Installion

pip3 install eSQL

After install eSQL, import that to test:

>>> import eSQL
>>> eSQL.__version__
...

get started

Can using eSQL like django.

connect to database

First step import that and connect to database.

import eSQL

eSQL.connect("database.db")

create models

always you need tables in database, define tables with eSQL.Model:

class Users(eSQL.Model):
    id = eSQL.IntegerField(primary_key=True, not_null=True)
    name = eSQL.TextField(not_null=True)
    username = eSQL.CharField(max_length=150)
    password = eSQL.CharField(max_length=20)

Note1: if variables starts with _, model ignore that.

Note2: if variable named objects, model ignore that.

migrate tables in database

Use eSQL.migrate():

eSQL.migrate()

Can use eSQL.sqlmigrate() to get sql statement:

__sql = eSQL.sqlmigrate()
print(__sql)

Learn More

Learn more here.

drop, insert, delete, select, transaction, ...

Owner
aWolver
My name is Ali ...! Make any kind of tools i need :\
aWolver
Similar Resources

TinyDB is a lightweight document oriented database optimized for your happiness :)

TinyDB is a lightweight document oriented database optimized for your happiness :)

Quick Links Example Code Supported Python Versions Documentation Changelog Extensions Contributing Introduction TinyDB is a lightweight document orien

Nov 30, 2022

Python object-oriented database

ZODB, a Python object-oriented database ZODB provides an object-oriented database for Python that provides a high-degree of transparency. ZODB runs on

Dec 2, 2022

LightDB is a lightweight JSON Database for Python

LightDB What is this? LightDB is a lightweight JSON Database for Python that allows you to quickly and easily write data to a file Installing pip3 ins

Oct 1, 2022

A simple GUI that interacts with a database to keep track of a collection of US coins.

CoinCollectorGUI A simple gui designed to interact with a database. The goal of the database is to make keeping track of collected coins simple. The G

Nov 9, 2021

Makes google's political ad database actually useful

Making Google's political ad transparency library suck less This is a series of scripts that takes Google's political ad transparency data and makes t

Apr 28, 2022

MyReplitDB - the most simplistic and easiest wrapper to use for replit's database system.

MyReplitDB is the most simplistic and easiest wrapper to use for replit's database system. Installing You can install it from the PyPI Or y

Jul 3, 2022

A Simple , ☁️ Lightweight , 💪 Efficent JSON based database for 🐍 Python.

A Simple , ☁️ Lightweight ,  💪 Efficent JSON based database for 🐍 Python.

A Simple, Lightweight, Efficent JSON based DataBase for Python The current stable version is v1.6.1 pip install pysondb==1.6.1 Support the project her

Nov 27, 2022

Decentralised graph database management system

Decentralised graph database management system To get started clone the repo, and run the command below. python3 database.py Now, create a new termina

Apr 18, 2022

A Persistent Embedded Graph Database for Python

A Persistent Embedded Graph Database for Python

Cog - Embedded Graph Database for Python cogdb.io New release: 2.0.5! Installing Cog pip install cogdb Cog is a persistent embedded graph database im

Nov 21, 2022
Related tags
Python function to extract all the rows from a SQLite database file while iterating over its bytes, such as while downloading it

Python function to extract all the rows from a SQLite database file while iterating over its bytes, such as while downloading it

Nov 9, 2022
A very simple document database

DockieDb A simple in-memory document database. Installation Build the Wheel Fork or clone this repository and run python setup.py bdist_wheel in the r

Jan 16, 2022
AWS Tags As A Database is a Python library using AWS Tags as a Key-Value database.

AWS Tags As A Database is a Python library using AWS Tags as a Key-Value database. This database is completely free* ??

Nov 25, 2022
Mongita is to MongoDB as SQLite is to SQL
Mongita is to MongoDB as SQLite is to SQL

Mongita is a lightweight embedded document database that implements a commonly-used subset of the MongoDB/PyMongo interface. Mongita differs from MongoDB in that instead of being a server, Mongita is a self-contained Python library. Mongita can be configured to store its documents either on disk or in memory.

Nov 25, 2022
Python function to query SQLite files stored on S3

sqlite-s3-query Python function to query a SQLite file stored on S3. It uses multiple HTTP range requests per query to avoid downloading the entire fi

Nov 21, 2022
Tools for analyzing Git history using SQLite

git-history Tools for analyzing Git history using SQLite Installation Install this tool using pip: $ pip install git-history Usage This tool can be r

Nov 29, 2022
ClutterDB - Extremely simple JSON database made for infrequent changes which behaves like a dict

extremely simple JSON database made for infrequent changes which behaves like a dict this was made for ClutterBot

Jan 12, 2022
Shelf DB is a tiny document database for Python to stores documents or JSON-like data
Shelf DB is a tiny document database for Python to stores documents or JSON-like data

Shelf DB Introduction Shelf DB is a tiny document database for Python to stores documents or JSON-like data. Get it $ pip install shelfdb shelfquery S

Nov 3, 2022
TelegramDB - A library which uses your telegram account as a database for your projects

TelegramDB A library which uses your telegram account as a database for your projects. Basic Usage from pyrogram import Client from telegram import Te

Nov 22, 2022
Elara DB is an easy to use, lightweight NoSQL database that can also be used as a fast in-memory cache.
Elara DB is an easy to use, lightweight NoSQL database that can also be used as a fast in-memory cache.

Elara DB is an easy to use, lightweight NoSQL database written for python that can also be used as a fast in-memory cache for JSON-serializable data. Includes various methods and features to manipulate data structures in-memory, protect database files and export data.

Nov 9, 2022