py-simple-db-utils

Some python abstractions to make simple database operations easier.

Declare your db dictionary as follows:

{
    'DB_HOST': 'address',
    'DB_PORT': 3306,
    'DB': 'db',
    'DB_USER: 'user',
    'DB_PASS: 'pass'
}

SimpleDictWriter Example Usage:

    writer = SimpleDictWriter(db)
    writer.write_dict("myTable", {'id':1234,'value':'mydata'}, commit=True)

SimpleDictReader Example Usage:

    reader = SimpleDictReader(db)
    reader.read_dict("table_name")

Disclaimer: This is currently a work in progress, and it only supports MySQL. Postgres support is possible with minor changes.