Metadata-Version: 2.1
Name: sqliteclosedhelper
Version: 1.0.2
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"))
```


