def set_rate(self, r):
try:
r = float(r)
except ValueError:
fprintf('Rates must be provided in the form of a number.',
file=sys.stderr)
sys.exit()
self.rate = r
db.update(lambda c: c.execute("""
UPDATE invoice SET rate=? WHERE rowid=?
""", (self.rate, self.rowid)))
def _timer_db_update(self):
""" Set the timer on the database to match
the timer of this object
"""
db.update(lambda c: c.execute("""
UPDATE user SET timer_running=?, timer_start=?, timer_total=?
WHERE rowid=?
""", (int(self.timer_running), self.timer_start,
self.timer_total, self.rowid
)
))
def test_update(self):
invoice_id = db.insert_invoice('Cool Project', 20.0, 1.0)
db.update(lambda c_: c_.execute('UPDATE invoice SET rate=? WHERE rowid=?', (40.0, invoice_id)))
self.c.execute('SELECT * FROM invoice WHERE rowid=?', (invoice_id,))
self.assertEqual(self.c.fetchall(), [('Cool Project', 40.0, 1.0)])
def set_active_invoice(self, rowid):
self.active_invoice_rowid = rowid
db.update(lambda c: c.execute("""
UPDATE user SET active_invoice=? WHERE rowid=?
""", (self.active_invoice_rowid, self.rowid)))
def set_rounding(self, r):
self.rounding = r
db.update(lambda c: c.execute("""
UPDATE user SET rounding=? WHERE rowid=?
""", (self.rounding, self.rowid)))
def set_rate(self, r):
self.rate = r
db.update(lambda c: c.execute("""
UPDATE user SET rate=? WHERE rowid=?
""", (self.rate, self.rowid)))