Exemplos de read_all em Python

Exemplo n.º 1

Arquivo: assets_helper.py Projeto: 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

Exemplo n.º 2

Arquivo: assets_helper.py Projeto: 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

Exemplo n.º 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()]

Exemplo n.º 4

Arquivo: assets_helper.py Projeto: 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()]