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 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 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_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_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_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)
