def load(self, year, month):
"""load calendar with data from database"""
#temp = models.EventCalendar.objects.filter(owner=self.owner,
# year=year, month=month)
temp = models.EventCalendar.objects.all()
if temp: # either 1 record or no record , check models.py
if len(temp) == 1:
self.db_cal = temp[0]
else:
for cale in temp:
if cale.owner == self.owner:
self.db_cal = cale
self.db_events = models.RunningNight.objects.filter(cal=self.db_cal,
date__year=year, date__month=month)
self.curr = eventCalBase.monthCalendar(self.db_cal.id,
self.owner, year, month)
for db_e in self.db_events:
e = eventCalBase.event(id=db_e.id, name=db_e.name, date=db_e.date,
end=db_e.end, cars=db_e.cars, descr=db_e.descr, evtype=db_e.evtype)
self.curr.addEvent(e, db_e.date.day)
else:
self.curr = eventCalBase.monthCalendar(None, self.owner,
year, month)
def load(self, year, month):
"""load calendar with data from database"""
temp = models.EventCalendar.objects.filter(owner=self.owner,
year=year, month=month)
if temp: # either 1 record or no record , check models.py
self.db_cal = temp[0]
self.db_events = models.Event.objects.filter(cal=self.db_cal,
when__year=year, when__month=month)
self.curr = eventCalBase.monthCalendar(self.db_cal.id,
self.owner, year, month)
for db_e in self.db_events:
e = eventCalBase.event(db_e.id, db_e.name, db_e.when,
db_e.desc)
self.curr.addEvent(e, db_e.when.day)
else:
self.curr = eventCalBase.monthCalendar(None, self.owner,
year, month)
def load(self, year, month):
"""load calendar with data from database"""
temp = filter_samples(0,month,year,0)
if temp: # either 1 record or no record , check models.py
self.db_cal = temp[0]
if self.area == 0:
self.db_events = filter_samples(0,month,year,self.area)
else:
self.db_events = filter_samples(0,month,year,self.area)
self.curr = eventCalBase.monthCalendar(self, year, month)
#put events to map a month
for db_e in self.db_events:
e = eventCalBase.event(db_e.id, db_e.taken_by,db_e.date_taken, db_e.sampling_point)
self.curr.addEvent(e, db_e.date_taken.day)
else:
self.curr = eventCalBase.monthCalendar(None,
year, month)
def load(self, year, month):
"""load calendar with data from database"""
temp = models.EventCalendar.objects.filter(owner=self.owner,
year=year,
month=month)
if temp: # either 1 record or no record , check models.py
self.db_cal = temp[0]
self.db_events = models.Event.objects.filter(cal=self.db_cal,
when__year=year,
when__month=month)
self.curr = eventCalBase.monthCalendar(self.db_cal.id, self.owner,
year, month)
for db_e in self.db_events:
e = eventCalBase.event(db_e.id, db_e.name, db_e.when,
db_e.desc)
self.curr.addEvent(e, db_e.when.day)
else:
self.curr = eventCalBase.monthCalendar(None, self.owner, year,
month)
def load(self, year, month):
"""load calendar with data from database"""
temp = Sample.objects.filter(date_taken__year=year, date_taken__month=month)
if temp: # either 1 record or no record , check models.py
self.db_cal = temp[0]
if self.area == 0:
self.db_events = Sample.objects.filter(date_taken__year=year, date_taken__month=month)
else:
a = Sample.objects.filter(date_taken__year=year, date_taken__month=month)
self.db_events = a.filter(sampling_point__wqmarea = self.area)
self.curr = eventCalBase.monthCalendar(self, year, month)
#put events to map a month
for db_e in self.db_events:
e = eventCalBase.event(db_e.id, db_e.taken_by,db_e.date_taken, db_e.sampling_point)
self.curr.addEvent(e, db_e.date_taken.day)
else:
self.curr = eventCalBase.monthCalendar(None,
year, month)
def setUp(self):
self.emsg = 'Expect %s, got %s'
self.now = datetime.datetime.now()
self.cal = eventCalBase.monthCalendar(1, 'someone', self.now.year,
self.now.month)
def setUp(self):
self.emsg = 'Expect %s, got %s'
self.now = datetime.datetime.now()
self.cal = eventCalBase.monthCalendar(1, 'someone', self.now.year,
self.now.month)
