semvec/pypi-packages huggingface dataset:
sqliteclosedhelper 1.0.3
Sqlite helper module
License: MIT

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