Metadata-Version: 2.1
Name: sqliteclosedhelper
Version: 1.0.1
Summary: Sqlite helper module
Home-page: https://github.com/wisdomrider/sqliteclosedhelper-python
Author: wisdomrider
Author-email: avishekzone@gmail.com
License: MIT
Platform: UNKNOWN
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.7
Description-Content-Type: text/markdown

#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"))
```


