def find_future_by_user(user): return ( Session.query(Appointment) .filter( and_( Appointment.start_dt > util.yesterday(), or_(Appointment.creator == user, Appointment.assigned == user), ) ) .order_by(Appointment.start_dt.asc(), Appointment.start_time.asc()) .all() )
from pvscore.tests import TestController, secure from pvscore.model.crm.appointment import Appointment import pvscore.lib.util as util # T pvscore.tests.controllers.test_crm_appointment YESTERDAY = util.yesterday() TODAY = util.today() TOMORROW = util.tomorrow() class TestCrmAppointment(TestController): @secure def test_show_new(self): R = self.get("/crm/appointment/new") assert R.status_int == 200 R.mustcontain("New Appointment") f = R.forms["frm_appointment"] self.assertEqual(f["title"].value, "") def _create_new(self): # create the appointment and ensure he's editable. R = self.get("/crm/appointment/new") assert R.status_int == 200 R.mustcontain("New Appointment") f = R.forms["frm_appointment"] self.assertEqual(f["appointment_id"].value, "") f.set("title", "Test Appointment") f.set("phone", "9041234567") f.set("description", "Test Description") f.set("start_dt", util.format_date(TOMORROW))