def test_query(self): invoice_id = db.insert_invoice('Cool Project', 20.0, 1.0) commit_id = db.insert_commit('Did a thing', 1405184155, 2.0, invoice_id) self.assertEqual(db.query_user(1), (0.0, 0.25, 0, 0, 0, 0)) self.assertEqual(db.query_invoice(1), ('Cool Project', 20.0, 1.0)) self.assertEqual(db.query_invoice('Cool Project'), ('Cool Project', 20.0, 1.0, 1)) self.assertEqual(db.query_commit(1), ('Did a thing', 1405184155, 2.0, invoice_id)) self.assertEqual(db.query_invoice_commit_meta(1), [('Did a thing', 1405184155, 2.0, invoice_id)])
def access(cls, rowid): commit = db.query_commit(rowid) return cls(commit[0], commit[2], commit[3], commit[1], rowid, False)