def init_db(): with app.app_context(): setup_db() with app.open_resource('schema.sql', mode='r') as f: g.db.executescript(f.read()) g._db.commit() close_db(None)
def do_transactions(self, copies, user, product, date=datetime.now(), notes='', price=1.0): """ Add a transaction at a specific date, with optional notes. """ with app.app_context(): streck.models.setup_db() price = product.price() or price for _ in range(copies): g.db.execute('insert into transactions values (null, ?, ?, ?, ?, ?)', [date.isoformat(), user.id(), product.id(), price, notes]) g._db.commit() streck.models.close_db(None)
def do_transactions(self, copies, user, product, date=datetime.now(), notes='', price=1.0): """ Add a transaction at a specific date, with optional notes. """ with app.app_context(): streck.models.setup_db() price = product.price() or price for _ in range(copies): g.db.execute( 'insert into transactions values (null, ?, ?, ?, ?, ?)', [date.isoformat(), user.id(), product.id(), price, notes]) g._db.commit() streck.models.close_db(None)