def getReservations2():
from MaKaC.rb_room import RoomBase
Test.dalManager.connect()
resvEx = Factory.newReservation()
resvEx.startDT = datetime( 2006, 12, 01, 10 )
resvEx.endDT = datetime( 2006, 12, 14, 15 )
resvEx.repeatability = 0 # Daily
#ReservationBase.getReservations( \
# roomExample = roomEx,
# resvExample = resvEx,
# available = True )
resv = ReservationBase.getReservations( resvID = 363818 )
print resv
r = Reservation()
r.room = resv.room
r.startDT = datetime( 2006, 10, 13, 8, 30 )
r.endDT = datetime( 2006, 10, 13, 17, 30 )
col = r.getCollisions()
print col
Test.dalManager.disconnect()
def getNumberOfLiveReservations(*args, **kwargs):
""" Documentation in base class. """
location = kwargs.get('location',
Location.getDefaultLocation().friendlyName)
resvEx = Factory.newReservation()
resvEx.isValid = True
return Reservation.countReservations(resvExample=resvEx,
archival=False,
location=location)
def getReservations():
from MaKaC.rb_factory import Factory
dalManager = Factory.getDALManager()
dalManager.connect()
amphitheatre = RoomBase.getRooms( roomName = 'IT AMPHITHEATRE' )
print "All reservations for IT AMPHITHEATRE: %d" % len( amphitheatre.getReservations() )
resvEx = Factory.newReservation()
resvEx.startDT = datetime( 2006, 9, 23, 0 )
resvEx.endDT = datetime( 2006, 9, 30, 23, 59 )
dalManager.disconnect()
def getLiveReservations(self, resvExample=None):
"""
FINAL (not intented to be overriden)
Returns valid, non archival reservations of this room,
meeting specified criteria. Look ReservationBase.getReservations for details.
"""
from MaKaC.rb_factory import Factory
from MaKaC.rb_reservation import ReservationBase
if resvExample is None:
resvExample = Factory.newReservation()
resvExample.isCancelled = False
resvExample.isRejected = False
return ReservationBase.getReservations(resvExample=resvExample, rooms=[self], archival=False)
def getReservations():
from MaKaC.rb_factory import Factory
from datetime import datetime
dalManager = Factory.getDALManager()
dalManager.connect()
amphitheatre = RoomBase.getRooms( roomName = 'IT AMPHITHEATRE' )
print "All reservations for IT AMPHITHEATRE: %d" % len( amphitheatre.getReservations() )
resvEx = Factory.newReservation()
resvEx.startDT = datetime( 2006, 9, 23, 0 )
resvEx.endDT = datetime( 2006, 9, 30, 23, 59 )
reservations = amphitheatre.getLiveReservations( resvExample = resvEx )
dalManager.disconnect()
def getLiveReservations( self, resvExample = None ):
"""
FINAL (not intented to be overriden)
Returns valid, non archival reservations of this room,
meeting specified criteria. Look ReservationBase.getReservations for details.
"""
from MaKaC.rb_factory import Factory
from MaKaC.rb_reservation import ReservationBase
if resvExample == None:
resvExample = Factory.newReservation()
resvExample.isCancelled = False
resvExample.isRejected = False
return ReservationBase.getReservations( resvExample = resvExample,
rooms = [self], archival = False )
def getReservations():
from MaKaC.rb_room import RoomBase
Test.dalManager.connect()
roomEx = Factory.newRoom()
roomEx.name = 'TH AMPHITHEATRE'
resvEx = Factory.newReservation()
resvEx.startDT = datetime( 2006, 12, 01, 10 )
resvEx.endDT = datetime( 2006, 12, 14, 15 )
#resvEx.bookedForName = 'Jean-Jacques Blais'
resvs = ReservationBase.getReservations( resvExample = resvEx, rooms = [roomEx] )
for resv in resvs:
print "============================="
print resv
Test.dalManager.disconnect()
def getNumberOfLiveReservations( *args, **kwargs ):
""" Documentation in base class. """
location = kwargs.get( 'location', Location.getDefaultLocation().friendlyName )
resvEx = Factory.newReservation()
resvEx.isValid = True
return Reservation.countReservations( resvExample = resvEx, archival = False, location = location )
return """At least one roomID must be specified (http://....?r=1,42,14,...)"""
try:
roomIDs = map(lambda x: int(x), roomIDs)
except ValueError:
return """Room IDs must be integers separated by commas (http://....?r=1,42,14,...)"""
if len(roomIDs) > 10:
return "One can only export 10 rooms at most"
#################### process ###################
rooms = []
for roomID in roomIDs:
roomEx = Factory.newRoom()
roomEx.id = roomID
rooms.append(roomEx)
resvEx = Factory.newReservation()
resvEx.isCancelled = False
resvEx.isRejected = False
resvEx.startDT = datetime(sd.year, sd.month, sd.day, 0, 0)
resvEx.endDT = datetime(ed.year, ed.month, ed.day, 23, 59)
resvs = CrossLocationQueries.getReservations(location="CERN", resvExample=resvEx, rooms=rooms)
collisions = []
for resv in resvs:
for p in resv.splitToPeriods(endDT=resvEx.endDT, startDT=resvEx.startDT):
collisions.append(Collision( ( p.startDT, p.endDT ), resv ))
of = params.get("of", "csv")
if of == "xml":
result = createXML(collisions, req)
else:
result = createCSV(collisions, req)
