Object Oriented DB Interactions

[datasundae]

Currently I use xlrd xlwr with psycopg2 to move transaction records in and out of spreadsheets and postgres. That works but I am interested in learning OOP and it seemed like I could incorporate OOP in my current work. My question to the forum is whether or not that really makes sense practically?

My idea is to create a transaction class:

class transaction:

with attributes that map to the column headings for each spreadsheet. So each transaction would have a date transaction.date(), amount transaction.amount(), account transaction.account() and so forth. Further, I could create methods such as selects, inserts and updates which would retrieve, create and modify those transaction records.