rowhouse 1.0.2

Install

pip install rowhouse

Basic Usage

from rowhouse import Connection
db = Connnection('pgsql://localhost/mydatabase')

# Run some SQL
row = db.fetchone('SELECT * FROM users WHERE username = %s', ('mreynolds',))
print('Name = ' + row['fullname'])

for row in db.fetchiter('SELECT * FROM users'):
    print('User: ' + row['fullname'])

db.begin()
db.execute('CREATE TABLE groups (...)')
db.execute('INSERT INTO groups VALUES (%s, %s)', ('firefly', 'mreynolds'))
db.commit()

# Some convenient helpers
with db.transaction():
    row = db.findone('users', username='mreynolds')
    db.update('users', {
        'role': 'captain'
    }, id=row['id'])
    newrow = db.insert('users', {
        'fullname': 'Zoe Washburne',
        'username': 'zwashburne',
        'role': 'first_mate'
    })

To Do

• [x] Implement find* methods

• [x] Implement insert/update/delete/upsert methods

• [x] Add tests and CI

• [x] Add packaging and publish to pypi

• [ ] More configurability - constructor, setters, etc

• [ ] Simple model support - little more than classes with a Connection baked in and some convenience methods