Python list_db_objects Examples

Example #1

File: resource.py Project: gvancuts/SmartHome-Demo

def list_resource(session=None, **filters):
    """
    :param session:
    :param filters:
    :return: list blocks
    """
    return utils.list_db_objects(session, Resource, **filters)

Example #2

File: fan.py Project: wanghongjuan/SmartHome-Demo

def get_fan_by_time(session, start_time, end_time):
    return utils.list_db_objects(session,
                                 Fan,
                                 created_at={
                                     'ge': str(start_time),
                                     'le': str(end_time)
                                 })

Example #3

File: resource.py Project: briandbl/SmartHome-Demo

def list_resource(session=None, **filters):
    """
    :param session:
    :param filters:
    :return: list blocks
    """
    return utils.list_db_objects(session, Resource, **filters)

Example #4

File: fan.py Project: 01org/SmartHome-Demo

def _get_fan(session, gateway_id, uuid, order_by=[], limit=None, **kwargs):
    if isinstance(uuid, basestring):
        ids = {'eq': uuid}
    elif isinstance(uuid, list):
        ids = {'in': uuid}
    else:
        raise exception.InvalidParameter('parameter uuid format are not supported.')
    return \
        utils.list_db_objects(session, Fan, order_by=order_by, limit=limit, gateway_id=gateway_id, uuid=ids, **kwargs)

Example #5

def _get_history(session, gateway_id, uuid, order_by=[], limit=None, **kwargs):
    if isinstance(uuid, basestring):
        ids = {'eq': uuid}
    elif isinstance(uuid, list):
        ids = {'in': uuid}
    else:
        raise exception.InvalidParameter('parameter uuid format are not supported.')
    return \
        utils.list_db_objects(session, SmsHistroy, order_by=order_by, limit=limit, gateway_id=gateway_id, uuid=ids, **kwargs)

Example #6

def _get_fan(session, resource_id, order_by=[], limit=None, **kwargs):
    if isinstance(resource_id, int):
        resource_ids = {'eq': resource_id}
    elif isinstance(resource_id, list):
        resource_ids = {'in': resource_id}
    else:
        raise exception.InvalidParameter('parameter resource id format are not supported.')
    return \
        utils.list_db_objects(session, Fan, order_by=order_by, limit=limit, resource_id=resource_ids, **kwargs)

Example #7

File: buzzer.py Project: 01org/SmartHome-Demo

def _get_buzzer(session, gateway_id, uuid, order_by=[], limit=None, **kwargs):
    if isinstance(uuid, basestring):
        ids = {"eq": uuid}
    elif isinstance(uuid, list):
        ids = {"in": uuid}
    else:
        raise exception.InvalidParameter("parameter uuid format are not supported.")
    return utils.list_db_objects(
        session, Buzzer, order_by=order_by, limit=limit, gateway_id=gateway_id, uuid=ids, **kwargs
    )

Example #8

File: actual_weather.py Project: zhuyawen/SmartHome-Demo

def get_weather_by_date(session, start_time, end_time, **kwargs):
    date_range = {'ge': str(start_time), 'le': str(end_time)}
    return utils.list_db_objects(session, ActualWeather, publish_date=date_range, **kwargs)

Example #9

File: predicted_power.py Project: gvancuts/SmartHome-Demo

def get_power_by_date(session, start_time, end_time, **kwargs):
    date_range = {'ge': str(start_time), 'le': str(end_time)}
    return utils.list_db_objects(session, PredictedPower, publish_date=date_range, **kwargs) 

Example #10

File: actual_power.py Project: zhuyawen/SmartHome-Demo

def get_power_by_date(session, start_time, end_time, **kwargs):
    date_range = {'ge': str(start_time), 'le': str(end_time)}
    return utils.list_db_objects(session,
                                 ActualPower,
                                 collect_date=date_range,
                                 **kwargs)

Example #11

def get_power_by_date(session, start_time, end_time, **kwargs):
    date_range = {'ge': str(start_time), 'le': str(end_time)}
    return utils.list_db_objects(session,
                                 PredictedPower,
                                 publish_date=date_range,
                                 **kwargs)

Example #12

def get_power(session, **kwargs):
    return utils.list_db_objects(session, PredictedPower, **kwargs)

Example #13

def get_all_types(session):
    return utils.list_db_objects(session, SensorType)

Example #14

File: actual_weather.py Project: gvancuts/SmartHome-Demo

def get_weather_by_date(session, start_time, end_time, **kwargs):
    date_range={'ge': str(start_time), 'le': str(end_time)}
    return utils.list_db_objects(session, ActualWeather, publish_date=date_range, **kwargs) 

Example #15

File: gateway.py Project: zhuyawen/SmartHome-Demo

def list_gateways(session, **kwargs):
    return utils.list_db_objects(session, Gateway, **kwargs)

Example #16

File: sensor_group.py Project: zhuyawen/SmartHome-Demo

def get_all_groups(session, gateway_id):
    return utils.list_db_objects(session, SensorGroup, gateway_id=gateway_id)

Example #17

File: predicted_power.py Project: gvancuts/SmartHome-Demo

def get_power(session, **kwargs):
    return utils.list_db_objects(session, PredictedPower, **kwargs)

Example #18

def get_all_user_names(session):
    users = utils.list_db_objects(session, User, exception_when_missing=False, status=True)
    u_list = [u.username for u in users if u.username]
    return set(u_list)

Example #19

File: gateway.py Project: 01org/SmartHome-Demo

def list_gateways(session, **kwargs):
    return utils.list_db_objects(session, Gateway, **kwargs)

Example #20

def get_user_phone_by_gateway(session, gateway_id, exception_when_missing=True):
    users = utils.list_db_objects(session, User, exception_when_missing=exception_when_missing, gateway_id=gateway_id)
    return [u.phone for u in users]

Example #21

File: fan.py Project: gvancuts/SmartHome-Demo

def get_fan_by_time(session, start_time, end_time):
    return utils.list_db_objects(session, Fan, created_at={'ge': str(start_time), 'le': str(end_time)})

Example #22

File: actual_power.py Project: gvancuts/SmartHome-Demo

def get_power_by_date(session, start_time, end_time, **kwargs):
    date_range={'ge': str(start_time), 'le': str(end_time)}
    return utils.list_db_objects(session, ActualPower, collect_date=date_range, **kwargs)