Python read_all Exemples

Exemple #1

Fichier : assets_helper.py Projet : tomvleeuwen/screenly-ose

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

Exemple #2

Fichier : assets_helper.py Projet : zeronop/screenly-ose

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

Exemple #3

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()]

Exemple #4

Fichier : assets_helper.py Projet : vpetersson/screenly-ose

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()]