def search_movables_objects(pattern): db_wrapper = DBWrapper() objects = db_wrapper.fetch_all( Q.SEARCH_MOVABLES.replace('PATTERN', pattern.strip().lower())) db_wrapper.dispose() return map(converters.convert_movable, objects)
def get_all_immobiles_objects(): db_wrapper = DBWrapper() immobiles = db_wrapper.fetch_all(Q.SELECT_ALL_IMMOBILES) db_wrapper.dispose() return map(converters.convert_immobile, immobiles)
def get_all_location_points(): db_wrapper = DBWrapper() lps = db_wrapper.fetch_all(Q.SELECT_ALL_LOCATION_POINTS) db_wrapper.dispose() return map(converters.convert_point, lps)
def get_all_location_points_for(id): points = () db_wrapper = DBWrapper() points = db_wrapper.fetch_all(Q.LOCATION_POINTS_FOR % id) db_wrapper.dispose() return map(converters.convert_point, points)
def get_all_movable_types(): db_wrapper = DBWrapper() movable_types = db_wrapper.fetch_all(Q.SELECT_ALL_MOVABLE_TYPES) db_wrapper.dispose() return map(converters.convert_movable_type, movable_types)
def search_movables_objects(pattern): db_wrapper = DBWrapper() objects = db_wrapper.fetch_all(Q.SEARCH_MOVABLES.replace('PATTERN', pattern.strip().lower())) db_wrapper.dispose() return map(converters.convert_movable, objects)