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))
