hpdb 4.0.7

Makes working with existing sql databases super easy

HPDB

Current version: 4.0.7

dbClass

installation

python -m pip install hpdb

usage

settings.ini

[database]
dbhost = myhost.mydomain.com
dbname = database_name
dbuser = database_user
dbpass = secret123

Initializing from ini file

from hpdb import dbClass
db = dbClass.from_inifile('settings.ini')

Initializing directly

db = dbClass(  host, dbname, user, passwd )

SELECT

db.select('users',{'isactive':1} )

LOOKUP SPECIFIC VALUES

db.lookup('users',{'id':15}, ['name', 'active] )

INSERT

db.insert('users', {'name':'john', 'isactive':1})
id = db.last_insert_id()

UPDATE

db.update( 'users', {'name':'john'}, {'active':0})

DELETE

db.delete( 'users', {'name':'john'})

QUERY

db.execute( 'SELECT * FROM users' )

Don't forget to commit when you have an innodb table

db.commit()