sqliteclosedhelper 1.0.1

Sqlite helper module

#SQLITECLOSEDHELPER

Description: This library helps you to manage your sqlite database easily without any query

How to install?

pip install sqliteclosedhelper

###How to use ?

####Creating a database file

from sqliteclosedhelper import *
db=DB("filename.db")

####Creating a table

db.createTable(tablename="books",fields={"id":TEXT+PRIMARY,"name":TEXT,"price":INTEGER}) #creates a table if not created

####Insert a field

db.insert(tablename="books",data={"id":"a1x","name":"Book1","price":100})

####Updating a field

db.update(tablename="books",data={"price":120},where={"id":"a1x","name":"Book1"},whattype=AND)

####Get a field

print(db.get(tablename="books",where={"name":"Book1","price":120},whattype=AND))

####Delete a field

db.delete("books",where={"name":"Book1","price":120},whattype=AND)

####Delete all field

db.deleteAll("books")

####Get all field

print(db.getAll("books"))