James John – Software Engineer

Python-SiDB: A Less Query SQLite Database Library

SiDB – A Simple Database Library for sqlite3, after writing similar thing for PHP MySQL, since I use Python too I decided to build for it too for my easier coding.

After building and seeing how helpful it is, I decided to share.

What Does SiDB do?

Usage

Import SiDB

from SiDB import SiDB

db = SiDB( 'database.db' )

Inserting to Database

db.insert( 'table_name', { 'col1': 'value1', 'col2' : 24, 'col3' : 'value2' } )

This will insert to the table table_name with those values for each column

Updating Table

As we can insert, we easily can update too. Below is an example of updating a table

db.update( 'table_name', { 'col1' : 'new_value1', 'col2' : 'new_value3' }, { 'col3' : 'value2' } )

This will update the columns col1, col2 to new values where col3 is equal to value2. When the third parameter is not provided, it updates the whole row of the table

Deleting Table

Same as update, but has to delete row(s)

db.delete( 'table_name', { 'col1' : 'new_value1' } )

That deletes a row that matches where col1 = new_value1. When the second parameter is not provided, it drops the whole rows in a table

Check If Table Exists

print( db.table_exists( 'table_name' ) )

Drop Table

db.drop_table( 'table_name' )

Rename Table

db.rename_table( 'table_name', 'new_name' )

Creating Table

This is a bit the complex part but gonna make it easy

db.create_table( 'table_name', { 
	'ID' : { 
		'type' : 'INT', 'allow_null' : False, 'primary_key' : True 
		}, 
	'name' : { 
		'type' : 'TEXT' 
		}, 
	'phone' : { 
		'unique' : True, 'type' : 'INT' 
	},
	'date' : {
		'type' : 'DATETIME',
		'default' : 'CURRENT_TIMESTAMP'
	}
})

Above we are creating a table with the name “table_name” and columns ID, name, phone and date. These keys must have a dict value and these are list of available keys

And their values can be valid SQL Syntax.

As it extends the sqlite3.Connection class, other sqlite3 methods are still available if you wish to use them.

Get on GitHub

This is all for now, hope it helps…

James John

Software Engineer