pylite

Intract with sqlite3 in python as simple as it can be.

Install

pip install pylite

Tips

Import pylite :

from pylite import Pylite

Create a new database or open an existing database :

db = Pylite('dbname')

Add a table :

db.add_table('table_name',column1='datatype',column2='datatype',...,columnN='datatype')

Insert data :

db.insert('table_name','column1_value','column2_value',...,'columnN_value')

Remove items :

db.remove('table_name','condition')

Retrieve items :

db.get_items('table_name','condition')

Get all tables name :

db.get_tables()

Execute your sqlite queries:

db.query('your query')

Close connection :

db.close_connection()