pylite 0.1.0

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

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()