semvec/pypi-packages huggingface dataset:
SQLITE3-CRUD-2021 0.0.1
An simple and easy CRUD to SQLITE3
Requires Python: >=3.6

# SQLITE3 CRUD

### 1 - Import file

from sqlite3_crud import Db

### 2 - <i>Db([local database])</i>

db = Db('database.db')

### 3 - <i>db.create_database([database])</i>

db.create_database(db)

### 4 - <i>db.create_table([table],[columns type parameters])</i>

db.create_table('tb_test', 'id integer primary key autoincrement, name text, status integer')

### 5 - <i>db.truncate_table([table])</i>

db.truncate_table('tb_test')

### 6 - <i>db.drop_table([table])</i>

db.drop_table('tb_test')

### 7 - <i>db.insert([table],[columns],[values])</i>

db.insert('tb_test', 'name,status', '"Joe Climb",0')

### 8 - <i>db.update([table],[set],[where])</i>

db.update('tb_test', 'name = "Joe Caruzo", status = 0', 'status = 1')

### 9 - <i>db.delete([table],[where])</i>

db.delete('tb_test','id = 1, status = 0')

### 10 - <i>db.select([table],[columns],[where],[groupby],[orderby])</i>

print(db.select('tb_test','name,count(*)','id > 0, status != 0', 'name', 'name asc'))

### 11 - <i>db.sql([query])</i>

print(db.sql('select * from tb_test '))