def wrapper(*args, **kw):
location_name = getattr(request, request_attribute).get(parameter_name, None)
location = Location.find_first(name=location_name)
if not location:
raise NotFound(_('There is no location named: {0}').format(location_name))
setattr(args[0], attribute_name, location)
return f(*args, **kw)
def _checkParams(self):
self._with_kpi = request.args.get('withKPI', type=bool)
self._actionSucceeded = request.args.get('actionSucceeded', default=False, type=bool)
location_name = request.view_args.get('locationId')
self._location = Location.find_first(name=location_name)
if not self._location:
raise IndicoError('Unknown Location: {0}'.format(location_name))
def _checkParams(self):
self._locationName = request.form.get('newLocationName').strip()
if not self._locationName:
raise FormValuesError(_('Location name may not be empty'))
if '/' in self._locationName:
raise FormValuesError(_('Location name may not contain slashes'))
if Location.find_first(name=self._locationName):
raise FormValuesError(_('Location "{0}" already exists').format(self._locationName))
def _process_args(self):
self._locationName = request.form.get('newLocationName').strip()
if not self._locationName:
raise BadRequest(_('Location name may not be empty'))
if '/' in self._locationName:
raise BadRequest(_('Location name may not contain slashes'))
if Location.find_first(name=self._locationName):
raise BadRequest(_('Location "{0}" already exists').format(self._locationName))
def wrapper(*args, **kw):
if not args:
raise IndicoError(_('Wrong usage of location decorator'))
location_name = getattr(request, request_attribute).get(parameter_name, None)
location = Location.find_first(name=location_name)
if not location:
raise NotFoundError(_('There is no location named: {0}').format(location_name))
setattr(args[0], attribute_name, location)
return f(*args, **kw)
def export_roomName(self, aw):
loc = Location.find_first(name=self._location)
if loc is None:
return
search_str = '%{}%'.format(self._room_name)
rooms_data = Room.get_with_data('vc_equipment', 'non_vc_equipment',
filters=[Room.location_id == loc.id, Room.name.ilike(search_str)])
for result in rooms_data:
yield _serializable_room(result)
def wrapper(*args, **kw):
if not args:
raise IndicoError(_("Wrong usage of location decorator"))
location_name = getattr(request, request_attribute).get(parameter_name, None)
location = Location.find_first(name=location_name)
if not location:
raise NotFoundError(_("There is no location named: {0}").format(location_name))
setattr(args[0], attribute_name, location)
return f(*args, **kw)
def export_roomName(self, user):
loc = Location.find_first(name=self._location)
if loc is None:
return
search_str = '%{}%'.format(self._room_name)
rooms_data = Room.get_with_data(filters=[
Room.location_id == loc.id,
or_(Room.name.ilike(search_str), Room.verbose_name.ilike(
search_str))
])
for result in rooms_data:
yield _serializable_room(result)
def export_roomName(self, user):
loc = Location.find_first(name=self._location)
if loc is None:
return
search_str = '%{}%'.format(self._room_name)
rooms_data = Room.get_with_data(
filters=[
Room.location_id == loc.id,
or_(Room.name.ilike(search_str),
Room.verbose_name.ilike(search_str))
])
for result in rooms_data:
yield _serializable_room(result)
def export_roomName(self, aw):
loc = Location.find_first(name=self._location)
if loc is None:
return
search_str = '%{}%'.format(self._room_name)
rooms_data = Room.get_with_data(
'vc_equipment', 'non_vc_equipment', filters=[
Room.location_id == loc.id,
or_((Room.building + '-' + Room.floor + '-' + Room.number).ilike(search_str),
Room.name.ilike(search_str))
])
for result in rooms_data:
yield _serializable_room(result)
def _checkParams(self):
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
self._new_attr = None
attr_title = request.form.get('newCustomAttributeName', default='').strip()
if attr_title:
attr_name = attr_title.replace(' ', '-').lower()
if self._location.get_attribute_by_name(attr_name):
raise FormValuesError(_('There is already an attribute named: {0}').format(attr_name))
self._new_attr = RoomAttribute(name=attr_name, title=attr_title, type='str',
is_required=request.form.get('newCustomAttributeIsRequired') == 'on',
is_hidden=request.form.get('newCustomAttributeIsHidden') == 'on')
def _checkParams(self):
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
self._new_attr = None
attr_title = request.form.get('newCustomAttributeName', default='').strip()
if attr_title:
attr_name = attr_title.replace(' ', '-').lower()
if self._location.get_attribute_by_name(attr_name):
raise FormValuesError(_('There is already an attribute named: {0}').format(attr_name))
self._new_attr = RoomAttribute(name=attr_name, title=attr_title, type='str',
is_required=request.form.get('newCustomAttributeIsRequired') == 'on',
is_hidden=request.form.get('newCustomAttributeIsHidden') == 'on')
def export_room(self, user):
loc = Location.find_first(name=self._location)
if loc is None:
return
# Retrieve rooms
rooms_data = list(Room.get_with_data(filters=[Room.id.in_(self._ids), Room.location_id == loc.id]))
# Retrieve reservations
reservations = None
if self._detail == 'reservations':
reservations = OrderedMultiDict(_export_reservations(self, True, False, [
Reservation.room_id.in_(x['room'].id for x in rooms_data)
]))
for result in rooms_data:
yield _serializable_room(result, reservations)
def export_room(self, user):
loc = Location.find_first(name=self._location)
if loc is None:
return
# Retrieve rooms
rooms_data = list(Room.get_with_data(filters=[Room.id.in_(self._ids), Room.location_id == loc.id]))
# Retrieve reservations
reservations = None
if self._detail == 'reservations':
reservations = OrderedMultiDict(_export_reservations(self, True, False, [
Reservation.room_id.in_(x['room'].id for x in rooms_data)
]))
for result in rooms_data:
yield _serializable_room(result, reservations)
def _checkParams(self):
self._location = Location.find_first(name=self._param('location'))
aspect_data = self._param('aspect')
try:
zoom_level = int(aspect_data.get('zoom_level', '0'))
except ValueError:
zoom_level = 0
self._aspect = Aspect(
name=aspect_data.get('name', ''),
center_latitude=aspect_data.get('center_latitude', ''),
center_longitude=aspect_data.get('center_longitude', ''),
zoom_level=zoom_level,
top_left_latitude=aspect_data.get('top_left_latitude', ''),
top_left_longitude=aspect_data.get('top_left_longitude', ''),
bottom_right_latitude=aspect_data.get('bottom_right_latitude', ''),
bottom_right_longitude=aspect_data.get('bottom_right_longitude',
''))
self._default_on_startup = aspect_data.get('DefaultOnStartup', False)
def _checkParams(self):
self._location = Location.find_first(name=self._param('location'))
aspect_data = self._param('aspect')
try:
zoom_level = int(aspect_data.get('zoom_level', '0'))
except ValueError:
zoom_level = 0
self._aspect = Aspect(
name=aspect_data.get('name', ''),
center_latitude=aspect_data.get('center_latitude', ''),
center_longitude=aspect_data.get('center_longitude', ''),
zoom_level=zoom_level,
top_left_latitude=aspect_data.get('top_left_latitude', ''),
top_left_longitude=aspect_data.get('top_left_longitude', ''),
bottom_right_latitude=aspect_data.get('bottom_right_latitude', ''),
bottom_right_longitude=aspect_data.get('bottom_right_longitude', '')
)
self._default_on_startup = aspect_data.get('DefaultOnStartup', False)
def _checkParams(self, param):
self._eq = request.form.get(param)
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
def _checkParams(self):
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
self._attr = request.args.get('removeCustomAttributeName', '')
def migrate_rooms(self):
eq = defaultdict(set)
vc = defaultdict(set)
for old_room_id, old_room in self.rb_root["Rooms"].iteritems():
eq[old_room._locationName].update(e for e in old_room._equipment.split("`") if e)
vc[old_room._locationName].update(e for e in getattr(old_room, "avaibleVC", []) if e)
print cformat("%{white!}migrating equipment")
for name, eqs in eq.iteritems():
l = Location.find_first(name=name)
if l is None:
print cformat("%{yellow!}*** WARNING")
print cformat(
"%{{yellow!}}***%{{reset}} Location '{}' does not exist. Skipped equipment: {}".format(name, eqs)
)
continue
l.equipment_types.extend(EquipmentType(name=x) for x in eqs)
print cformat("- [%{cyan}{}%{reset}] {}").format(name, eqs)
db.session.add(l)
db.session.commit()
print
print cformat("%{white!}migrating vc equipment")
for name, vcs in vc.iteritems():
l = Location.find_first(name=name)
if l is None:
print cformat("%{yellow!}*** WARNING")
print cformat(
"%{{yellow!}}***%{{reset}} Location '{}' does not exist. Skipped VC equipment: {}".format(name, vcs)
)
continue
pvc = l.get_equipment_by_name("Video conference")
for vc_name in vcs:
req = EquipmentType(name=vc_name)
req.parent = pvc
l.equipment_types.append(req)
print cformat("- [%{cyan}{}%{reset}] {}").format(name, req.name)
db.session.add(l)
db.session.commit()
print
print cformat("%{white!}migrating rooms")
for old_room_id, old_room in self.rb_root["Rooms"].iteritems():
l = Location.find_first(name=old_room._locationName)
if l is None:
print cformat("%{yellow!}*** WARNING")
print cformat(
"%{{yellow!}}***%{{reset}} Location '{}' does not exist. Skipped room '{}'".format(
old_room._locationName, old_room.id
)
)
continue
r = Room(
id=old_room_id,
name=convert_to_unicode((old_room._name or "").strip() or generate_name(old_room)),
site=convert_to_unicode(old_room.site),
division=convert_to_unicode(old_room.division),
building=convert_to_unicode(old_room.building),
floor=convert_to_unicode(old_room.floor),
number=convert_to_unicode(old_room.roomNr),
notification_before_days=(
(old_room.resvStartNotificationBefore or None)
if getattr(old_room, "resvStartNotification", False)
else None
),
notification_for_responsible=getattr(old_room, "resvNotificationToResponsible", False),
notification_for_assistance=getattr(old_room, "resvNotificationAssistance", False),
reservations_need_confirmation=old_room.resvsNeedConfirmation,
telephone=convert_to_unicode(getattr(old_room, "telephone", None)),
key_location=convert_to_unicode(getattr(old_room, "whereIsKey", None)),
capacity=getattr(old_room, "capacity", None),
surface_area=getattr(old_room, "surfaceArea", None),
latitude=getattr(old_room, "latitude", None),
longitude=getattr(old_room, "longitude", None),
comments=convert_to_unicode(getattr(old_room, "comments", None)),
owner_id=self.merged_avatars.get(old_room.responsibleId, old_room.responsibleId),
is_active=old_room.isActive,
is_reservable=old_room.isReservable,
max_advance_days=int(old_room.maxAdvanceDays) if getattr(old_room, "maxAdvanceDays", None) else None,
)
print cformat("- [%{cyan}{}%{reset}] %{grey!}{:4}%{reset} %{green!}{}%{reset}").format(
l.name, r.id, r.name
)
for old_bookable_time in getattr(old_room, "_dailyBookablePeriods", []):
r.bookable_hours.append(
BookableHours(start_time=old_bookable_time._startTime, end_time=old_bookable_time._endTime)
)
print cformat(" %{blue!}Bookable:%{reset} {}").format(r.bookable_hours[-1])
for old_nonbookable_date in getattr(old_room, "_nonBookableDates", []):
r.nonbookable_periods.append(
NonBookablePeriod(start_dt=old_nonbookable_date._startDate, end_dt=old_nonbookable_date._endDate)
)
print cformat(" %{blue!}Nonbookable:%{reset} {}").format(r.nonbookable_periods[-1])
if self.photo_path:
try:
with open(
os.path.join(self.photo_path, "large_photos", get_canonical_name_of(old_room) + ".jpg"), "rb"
) as f:
large_photo = f.read()
except Exception:
large_photo = None
try:
with open(
os.path.join(self.photo_path, "small_photos", get_canonical_name_of(old_room) + ".jpg"), "rb"
) as f:
small_photo = f.read()
except Exception:
small_photo = None
if large_photo and small_photo:
r.photo = Photo(data=large_photo, thumbnail=small_photo)
print cformat(" %{blue!}Photos")
new_eq = []
for old_equipment in ifilter(None, old_room._equipment.split("`") + old_room.avaibleVC):
room_eq = l.get_equipment_by_name(old_equipment)
new_eq.append(room_eq)
r.available_equipment.append(room_eq)
if new_eq:
print cformat(" %{blue!}Equipment:%{reset} {}").format(", ".join(sorted(x.name for x in new_eq)))
for attr_name, value in getattr(old_room, "customAtts", {}).iteritems():
value = convert_to_unicode(value)
if not value or ("Simba" in attr_name and value == u"Error: unknown mailing list"):
continue
attr_name = attribute_map.get(attr_name, attr_name).replace(" ", "-").lower()
ca = l.get_attribute_by_name(attr_name)
if not ca:
print cformat(" %{blue!}Attribute:%{reset} {} %{red!}not found").format(attr_name)
continue
attr = RoomAttributeAssociation()
attr.value = value
attr.attribute = ca
r.attributes.append(attr)
print cformat(" %{blue!}Attribute:%{reset} {} = {}").format(attr.attribute.title, attr.value)
l.rooms.append(r)
db.session.add(l)
print
db.session.commit()
def _checkParams(self):
self._location = Location.find_first(name=self._param('location'))
def _checkParams(self):
self._location = Location.find_first(name=self._param('location'))
def migrate_rooms(self):
eq = defaultdict(set)
vc = defaultdict(set)
for old_room_id, old_room in self.rb_root['Rooms'].iteritems():
eq[old_room._locationName].update(
e for e in old_room._equipment.split('`') if e)
vc[old_room._locationName].update(
e for e in getattr(old_room, 'avaibleVC', []) if e)
print cformat('%{white!}migrating equipment')
for name, eqs in eq.iteritems():
l = Location.find_first(name=name)
if l is None:
print cformat('%{yellow!}*** WARNING')
print cformat(
"%{{yellow!}}***%{{reset}} Location '{}' does not exist. Skipped equipment: {}"
.format(name, eqs))
continue
l.equipment_types.extend(EquipmentType(name=x) for x in eqs)
print cformat('- [%{cyan}{}%{reset}] {}').format(name, eqs)
db.session.add(l)
db.session.commit()
print
print cformat('%{white!}migrating vc equipment')
for name, vcs in vc.iteritems():
l = Location.find_first(name=name)
if l is None:
print cformat('%{yellow!}*** WARNING')
print cformat(
"%{{yellow!}}***%{{reset}} Location '{}' does not exist. Skipped VC equipment: {}"
.format(name, vcs))
continue
pvc = l.get_equipment_by_name('Video conference')
for vc_name in vcs:
req = EquipmentType(name=vc_name)
req.parent = pvc
l.equipment_types.append(req)
print cformat('- [%{cyan}{}%{reset}] {}').format(
name, req.name)
db.session.add(l)
db.session.commit()
print
print cformat('%{white!}migrating rooms')
for old_room_id, old_room in self.rb_root['Rooms'].iteritems():
l = Location.find_first(name=old_room._locationName)
if l is None:
print cformat('%{yellow!}*** WARNING')
print cformat(
"%{{yellow!}}***%{{reset}} Location '{}' does not exist. Skipped room '{}'"
.format(old_room._locationName, old_room.id))
continue
r = Room(
id=old_room_id,
name=convert_to_unicode((old_room._name or '').strip()
or generate_name(old_room)),
site=convert_to_unicode(old_room.site),
division=convert_to_unicode(old_room.division),
building=convert_to_unicode(old_room.building),
floor=convert_to_unicode(old_room.floor),
number=convert_to_unicode(old_room.roomNr),
notification_before_days=((
old_room.resvStartNotificationBefore or None) if getattr(
old_room, 'resvStartNotification', False) else None),
notification_for_responsible=getattr(
old_room, 'resvNotificationToResponsible', False),
notification_for_assistance=getattr(
old_room, 'resvNotificationAssistance', False),
reservations_need_confirmation=old_room.resvsNeedConfirmation,
telephone=convert_to_unicode(
getattr(old_room, 'telephone', None)),
key_location=convert_to_unicode(
getattr(old_room, 'whereIsKey', None)),
capacity=getattr(old_room, 'capacity', None),
surface_area=getattr(old_room, 'surfaceArea', None),
latitude=getattr(old_room, 'latitude', None),
longitude=getattr(old_room, 'longitude', None),
comments=convert_to_unicode(getattr(old_room, 'comments',
None)),
owner_id=self.merged_avatars.get(old_room.responsibleId,
old_room.responsibleId),
is_active=old_room.isActive,
is_reservable=old_room.isReservable,
max_advance_days=int(old_room.maxAdvanceDays) if getattr(
old_room, 'maxAdvanceDays', None) else None)
print cformat(
'- [%{cyan}{}%{reset}] %{grey!}{:4}%{reset} %{green!}{}%{reset}'
).format(l.name, r.id, r.name)
for old_bookable_time in getattr(old_room, '_dailyBookablePeriods',
[]):
r.bookable_hours.append(
BookableHours(start_time=old_bookable_time._startTime,
end_time=old_bookable_time._endTime))
print cformat(' %{blue!}Bookable:%{reset} {}').format(
r.bookable_hours[-1])
for old_nonbookable_date in getattr(old_room, '_nonBookableDates',
[]):
r.nonbookable_periods.append(
NonBookablePeriod(start_dt=old_nonbookable_date._startDate,
end_dt=old_nonbookable_date._endDate))
print cformat(' %{blue!}Nonbookable:%{reset} {}').format(
r.nonbookable_periods[-1])
if self.photo_path:
try:
with open(
os.path.join(
self.photo_path, 'large_photos',
get_canonical_name_of(old_room) + '.jpg'),
'rb') as f:
large_photo = f.read()
except Exception:
large_photo = None
try:
with open(
os.path.join(
self.photo_path, 'small_photos',
get_canonical_name_of(old_room) + '.jpg'),
'rb') as f:
small_photo = f.read()
except Exception:
small_photo = None
if large_photo and small_photo:
r.photo = Photo(data=large_photo, thumbnail=small_photo)
print cformat(' %{blue!}Photos')
new_eq = []
for old_equipment in ifilter(
None,
old_room._equipment.split('`') + old_room.avaibleVC):
room_eq = l.get_equipment_by_name(old_equipment)
new_eq.append(room_eq)
r.available_equipment.append(room_eq)
if new_eq:
print cformat(' %{blue!}Equipment:%{reset} {}').format(
', '.join(sorted(x.name for x in new_eq)))
for attr_name, value in getattr(old_room, 'customAtts',
{}).iteritems():
value = convert_to_unicode(value)
if not value or ('Simba' in attr_name
and value == u'Error: unknown mailing list'):
continue
attr_name = attribute_map.get(attr_name,
attr_name).replace(' ',
'-').lower()
ca = l.get_attribute_by_name(attr_name)
if not ca:
print cformat(
' %{blue!}Attribute:%{reset} {} %{red!}not found'
).format(attr_name)
continue
attr = RoomAttributeAssociation()
attr.value = value
attr.attribute = ca
r.attributes.append(attr)
print cformat(' %{blue!}Attribute:%{reset} {} = {}').format(
attr.attribute.title, attr.value)
l.rooms.append(r)
db.session.add(l)
print
db.session.commit()
def _checkParams(self, param):
self._eq = request.form.get(param)
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
def _process_args(self):
self._eq = request.form.get(self.PARAM)
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
def _process_args(self):
self._location = Location.find_first(name=self._param('location'))
def _process_args(self):
self._location = Location.find_first(name=self._param('location'))
def _checkParams(self):
name = request.view_args.get('locationId')
self._location = Location.find_first(name=name)
if not self._location:
raise IndicoError(_('Unknown Location: {0}').format(name))
self._attr = request.args.get('removeCustomAttributeName', '')
def migrate_rooms(rb_root, photo_path, avatar_id_map):
eq = defaultdict(set)
vc = defaultdict(set)
for old_room_id, old_room in rb_root['Rooms'].iteritems():
eq[old_room._locationName].update(e for e in old_room._equipment.split('`') if e)
vc[old_room._locationName].update(e for e in getattr(old_room, 'avaibleVC', []) if e)
print cformat('%{white!}migrating equipment')
for name, eqs in eq.iteritems():
l = Location.find_first(name=name)
l.equipment_types.extend(EquipmentType(name=x) for x in eqs)
print cformat('- [%{cyan}{}%{reset}] {}').format(name, eqs)
db.session.add(l)
db.session.commit()
print
print cformat('%{white!}migrating vc equipment')
for name, vcs in vc.iteritems():
l = Location.find_first(name=name)
pvc = l.get_equipment_by_name('Video conference')
for vc_name in vcs:
req = EquipmentType(name=vc_name)
req.parent = pvc
l.equipment_types.append(req)
print cformat('- [%{cyan}{}%{reset}] {}').format(name, req.name)
db.session.add(l)
db.session.commit()
print
print cformat('%{white!}migrating rooms')
for old_room_id, old_room in rb_root['Rooms'].iteritems():
l = Location.find_first(name=old_room._locationName)
r = Room(
id=old_room_id,
name=convert_to_unicode((old_room._name or '').strip() or generate_name(old_room)),
site=convert_to_unicode(old_room.site),
division=convert_to_unicode(old_room.division),
building=convert_to_unicode(old_room.building),
floor=convert_to_unicode(old_room.floor),
number=convert_to_unicode(old_room.roomNr),
notification_before_days=((old_room.resvStartNotificationBefore or None)
if getattr(old_room, 'resvStartNotification', False)
else None),
notification_for_responsible=getattr(old_room, 'resvNotificationToResponsible', False),
notification_for_assistance=getattr(old_room, 'resvNotificationAssistance', False),
reservations_need_confirmation=old_room.resvsNeedConfirmation,
telephone=old_room.telephone,
key_location=convert_to_unicode(old_room.whereIsKey),
capacity=old_room.capacity,
surface_area=getattr(old_room, 'surfaceArea', None),
latitude=getattr(old_room, 'latitude', None),
longitude=getattr(old_room, 'longitude', None),
comments=convert_to_unicode(old_room.comments),
owner_id=avatar_id_map.get(old_room.responsibleId, old_room.responsibleId),
is_active=old_room.isActive,
is_reservable=old_room.isReservable,
max_advance_days=int(old_room.maxAdvanceDays) if getattr(old_room, 'maxAdvanceDays', None) else None
)
print cformat('- [%{cyan}{}%{reset}] %{grey!}{:4}%{reset} %{green!}{}%{reset}').format(l.name, r.id, r.name)
for old_bookable_time in getattr(old_room, '_dailyBookablePeriods', []):
r.bookable_hours.append(
BookableHours(
start_time=old_bookable_time._startTime,
end_time=old_bookable_time._endTime
)
)
print cformat(' %{blue!}Bookable:%{reset} {}').format(r.bookable_hours[-1])
for old_nonbookable_date in getattr(old_room, '_nonBookableDates', []):
r.nonbookable_periods.append(
NonBookablePeriod(
start_dt=old_nonbookable_date._startDate,
end_dt=old_nonbookable_date._endDate
)
)
print cformat(' %{blue!}Nonbookable:%{reset} {}').format(r.nonbookable_periods[-1])
if photo_path:
try:
with open(os.path.join(photo_path, 'large_photos',
get_canonical_name_of(old_room) + '.jpg'), 'rb') as f:
large_photo = f.read()
except Exception:
large_photo = None
try:
with open(os.path.join(photo_path, 'small_photos',
get_canonical_name_of(old_room) + '.jpg'), 'rb') as f:
small_photo = f.read()
except Exception:
small_photo = None
if large_photo and small_photo:
r.photo = Photo(data=large_photo, thumbnail=small_photo)
print cformat(' %{blue!}Photos')
new_eq = []
for old_equipment in ifilter(None, old_room._equipment.split('`') + old_room.avaibleVC):
room_eq = l.get_equipment_by_name(old_equipment)
new_eq.append(room_eq)
r.available_equipment.append(room_eq)
if new_eq:
print cformat(' %{blue!}Equipment:%{reset} {}').format(', '.join(sorted(x.name for x in new_eq)))
for attr_name, value in getattr(old_room, 'customAtts', {}).iteritems():
value = convert_to_unicode(value)
if not value or ('Simba' in attr_name and value == u'Error: unknown mailing list'):
continue
attr_name = attribute_map.get(attr_name, attr_name).replace(' ', '-').lower()
ca = l.get_attribute_by_name(attr_name)
if not ca:
print cformat(' %{blue!}Attribute:%{reset} {} %{red!}not found').format(attr_name)
continue
attr = RoomAttributeAssociation()
attr.value = value
attr.attribute = ca
r.attributes.append(attr)
print cformat(' %{blue!}Attribute:%{reset} {} = {}').format(attr.attribute.title, attr.value)
l.rooms.append(r)
db.session.add(l)
print
db.session.commit()
