semvec/pypi-packages huggingface dataset:
oracle-crud-2021 0.0.2
An simple and easy CRUD to ORACLE
Requires Python: >=3.6

# ORACLE CRUD

### 1 - Import file

from oracle_crud import Db

### 2 - <i>Db([user],[password],[host],[sid],[auto commit])</i>

db = Db('user','user_pass','127.0.0.1','orcl',True)

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

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

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

db.truncate_table('tb_test')

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

db.drop_table('tb_test')

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

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

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

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

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

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

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

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

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

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