def read(conn, asset_id=None, keys=FIELDS): """ Fetch one or more assets from the database. Returns a list of dicts or one dict. Assets' is_active field is updated before returning. """ assets = [] mk = mkdict(keys) with db.cursor(conn) as c: if asset_id is None: c.execute(queries.read_all(keys)) else: c.execute(queries.read(keys), [asset_id]) assets = [mk(asset) for asset in c.fetchall()] [asset.update({'is_active': is_active(asset)}) for asset in assets] if asset_id and len(assets): return assets[0] return assets
def read(conn, asset_id=None, keys=FIELDS): """ Fetch one or more assets from the database. Returns a list of dicts or one dict. Assets' is_active field is updated before returning. """ assets = [] mk = mkdict(keys) with db.cursor(conn) as c: if asset_id is None: c.execute(queries.read_all(keys)) else: c.execute(queries.read(keys), [asset_id]) assets = [mk(asset) for asset in c.fetchall()] [asset.update({'is_active': is_active(asset)}) for asset in assets] if asset_id and len(assets): return assets[0] return assets
def get_names_of_assets(conn): with db.cursor(conn) as c: c.execute(queries.read_all([ 'name', ])) return [asset[0] for asset in c.fetchall()]
def get_names_of_assets(conn): with db.cursor(conn) as c: c.execute(queries.read_all(['name', ])) return [asset[0] for asset in c.fetchall()]