def initializeRoomBookingDB(location, force=False): """ Modifies Indico main database. - location list Creates necessary branches in room booking database. - rooms branch - bookings branch - several indexes """ indicoRoot = MaKaC.common.DBMgr.getInstance().getDBConnection().root() root = DALManagerCERN().getRoot() # 1. Location ----------------------------------------------------------- initialLocation = Location(location, FactoryCERN) if force or not indicoRoot.has_key('RoomBookingLocationList'): indicoRoot['RoomBookingLocationList'] = [initialLocation] if force or not indicoRoot.has_key('DefaultRoomBookingLocation'): indicoRoot['DefaultRoomBookingLocation'] = location # 2. Rooms & Bookings --------------------------------------------------- # Create rooms branch if force or not root.has_key('Rooms'): root['Rooms'] = IOBTree() # Create reservations branch if force or not root.has_key('Reservations'): root['Reservations'] = IOBTree() # Create blocking branch if force or not root.has_key('RoomBlocking'): root['RoomBlocking'] = OOBTree() root['RoomBlocking']['Blockings'] = IOBTree() root['RoomBlocking']['Indexes'] = OOBTree() root['RoomBlocking']['Indexes']['OwnerBlockings'] = OOBTree() root['RoomBlocking']['Indexes']['DayBlockings'] = CalendarDayIndex() root['RoomBlocking']['Indexes']['RoomBlockings'] = OOBTree() # Create indexes if force or not root.has_key('RoomReservationsIndex'): root['RoomReservationsIndex'] = OOBTree() if force or not root.has_key('UserReservationsIndex'): root['UserReservationsIndex'] = OOBTree() if force or not root.has_key('DayReservationsIndex'): root['DayReservationsIndex'] = OOBTree() if force or not root.has_key('RoomDayReservationsIndex'): root['RoomDayReservationsIndex'] = OOBTree() # Create possible equipment branch if force or not root.has_key('EquipmentList'): root['EquipmentList'] = {} # update Catalog with new rb indexes Catalog.updateDB() DALManagerCERN().commit()
def initializeRoomBookingDB(location, force=False): """ Modifies Indico main database. - location list Creates necessary branches in room booking database. - rooms branch - bookings branch - several indexes """ indicoRoot = MaKaC.common.DBMgr.getInstance().getDBConnection().root() root = DALManagerCERN().getRoot() # 1. Location ----------------------------------------------------------- initialLocation = Location(location, FactoryCERN) if force or not indicoRoot.has_key("RoomBookingLocationList"): indicoRoot["RoomBookingLocationList"] = [initialLocation] if force or not indicoRoot.has_key("DefaultRoomBookingLocation"): indicoRoot["DefaultRoomBookingLocation"] = location # 2. Rooms & Bookings --------------------------------------------------- # Create rooms branch if force or not root.has_key("Rooms"): root["Rooms"] = IOBTree() # Create reservations branch if force or not root.has_key("Reservations"): root["Reservations"] = IOBTree() # Create blocking branch if force or not root.has_key("RoomBlocking"): root["RoomBlocking"] = OOBTree() root["RoomBlocking"]["Blockings"] = IOBTree() root["RoomBlocking"]["Indexes"] = OOBTree() root["RoomBlocking"]["Indexes"]["OwnerBlockings"] = OOBTree() root["RoomBlocking"]["Indexes"]["DayBlockings"] = CalendarDayIndex() root["RoomBlocking"]["Indexes"]["RoomBlockings"] = OOBTree() # Create indexes if force or not root.has_key("RoomReservationsIndex"): root["RoomReservationsIndex"] = OOBTree() if force or not root.has_key("UserReservationsIndex"): root["UserReservationsIndex"] = OOBTree() if force or not root.has_key("DayReservationsIndex"): root["DayReservationsIndex"] = OOBTree() if force or not root.has_key("RoomDayReservationsIndex"): root["RoomDayReservationsIndex"] = OOBTree() # Create possible equipment branch if force or not root.has_key("EquipmentList"): root["EquipmentList"] = {} # update Catalog with new rb indexes Catalog.updateDB() DALManagerCERN().commit()
def initializeRoomBookingDB( location, force = False ): """ Modifies Indico main database. - location list Creates necessary branches in room booking database. - rooms branch - bookings branch - several indexes """ indicoRoot = MaKaC.common.DBMgr.getInstance().getDBConnection().root() root = DALManagerCERN().root # 1. Location ----------------------------------------------------------- initialLocation = Location( location, FactoryCERN ) if force or not indicoRoot.has_key( 'RoomBookingLocationList' ): indicoRoot['RoomBookingLocationList'] = [ initialLocation ] print "Locations branch created (Indico db)" if force or not indicoRoot.has_key( 'DefaultRoomBookingLocation' ): indicoRoot['DefaultRoomBookingLocation'] = location print "Default location set to " + location # 2. Rooms & Bookings --------------------------------------------------- # Create rooms branch if force or not root.has_key( 'Rooms' ): root['Rooms'] = IOBTree() print "Rooms branch created" # Create reservations branch if force or not root.has_key( 'Reservations' ): root['Reservations'] = IOBTree() print "Reservations branch created" # Create indexes if force or not root.has_key( 'RoomReservationsIndex' ): root['RoomReservationsIndex'] = OOBTree() print "Room => Reservations Index branch created" if force or not root.has_key( 'UserReservationsIndex' ): root['UserReservationsIndex'] = OOBTree() print "User => Reservations Index branch created" if force or not root.has_key( 'DayReservationsIndex' ): root['DayReservationsIndex'] = OOBTree() print "Day => Reservations Index branch created" # Create possible equipment branch if force or not root.has_key( 'EquipmentList' ): root['EquipmentList'] = {} print "Equipment branch created" AvatarHolder().invalidateRoomManagerIdList() print "Cached list of room managers invalidated" DALManagerCERN().commit()
def initializeRoomBookingDB(location, force=False): """ Modifies Indico main database. - location list Creates necessary branches in room booking database. - rooms branch - bookings branch - several indexes """ indicoRoot = MaKaC.common.DBMgr.getInstance().getDBConnection().root() root = DALManagerCERN().root # 1. Location ----------------------------------------------------------- initialLocation = Location(location, FactoryCERN) if force or not indicoRoot.has_key('RoomBookingLocationList'): indicoRoot['RoomBookingLocationList'] = [initialLocation] print "Locations branch created (Indico db)" if force or not indicoRoot.has_key('DefaultRoomBookingLocation'): indicoRoot['DefaultRoomBookingLocation'] = location print "Default location set to " + location # 2. Rooms & Bookings --------------------------------------------------- # Create rooms branch if force or not root.has_key('Rooms'): root['Rooms'] = IOBTree() print "Rooms branch created" # Create reservations branch if force or not root.has_key('Reservations'): root['Reservations'] = IOBTree() print "Reservations branch created" # Create indexes if force or not root.has_key('RoomReservationsIndex'): root['RoomReservationsIndex'] = OOBTree() print "Room => Reservations Index branch created" if force or not root.has_key('UserReservationsIndex'): root['UserReservationsIndex'] = OOBTree() print "User => Reservations Index branch created" if force or not root.has_key('DayReservationsIndex'): root['DayReservationsIndex'] = OOBTree() print "Day => Reservations Index branch created" # Create possible equipment branch if force or not root.has_key('EquipmentList'): root['EquipmentList'] = {} print "Equipment branch created" AvatarHolder().invalidateRoomManagerIdList() print "Cached list of room managers invalidated" DALManagerCERN().commit()