def create(conn, asset): """ Create a database record for an asset. Returns the asset. Asset's is_active field is updated before returning. """ if 'is_active' in asset: asset.pop('is_active') with db.commit(conn) as c: c.execute(queries.create(asset.keys()), asset.values()) asset.update({'is_active': is_active(asset)}) return asset
def create_multiple(conn, assets): """ Create a database record for each asset. Returns asset list. Asset's is_active field is updated before returning. """ with db.commit(conn) as c: for asset in assets: if 'is_active' in asset: asset.pop('is_active') c.execute(queries.create(asset.keys()), asset.values()) asset.update({'is_active': is_active(asset)}) return assets