Welcome | Get started | Dive into Lino | Contribute | Topics | Reference | More
Presences¶
This page is a tested document and the following instructions are used for initialization:
>>> from lino import startup
>>> startup('lino_book.projects.roger.settings.doctests')
>>> from lino.api.doctest import *
>>> settings.SITE.site_config.pupil_guestrole
GuestRole #1 ('Participant')
Filtering courses by their start/end date¶
The parameter panel of most courses tables has two fields Period from and until. Here are some usage examples.
>>> kwargs = dict(column_names="id line weekdays_text start_date end_date")
All courses that were active already before March 2014:
>>> pv = dict(end_date=i2d(20140301))
>>> rt.show(rt.models.courses.Courses, param_values=pv, **kwargs)
==== ================================ ============== ============ ==========
ID Activity line When Start date End Date
---- -------------------------------- -------------- ------------ ----------
22 MED (Finding your inner peace) Every Monday 19/09/2013
24 Yoga Every Monday 08/11/2013
25 Yoga Every Friday 08/11/2013
==== ================================ ============== ============ ==========
All activities that were still active after 20140807. This
includes all activities which have no end_date and those whose
end_date is after 20140807.
>>> pv = dict(start_date=i2d(20140807))
>>> rt.show(rt.models.courses.Activities, param_values=pv, **kwargs)
==== ================================ ======================= ============ ============
ID Activity line When Start date End Date
---- -------------------------------- ----------------------- ------------ ------------
26 Europe Every month 19/06/2015 21/06/2015
1 Europe 14/08/2014-20/08/2014 14/08/2014 20/08/2014
3 comp (First Steps) Every Monday 18/03/2014
4 comp (First Steps) Every Wednesday 18/03/2014
5 comp (First Steps) Every Friday 18/03/2014
6 WWW (Internet for beginners) Every Monday 24/10/2014
7 WWW (Internet for beginners) Every Wednesday 24/10/2014
8 WWW (Internet for beginners) Every Friday 24/10/2014
9 BT (Belly dancing) Every Wednesday 28/03/2014
10 FG (Functional gymnastics) Every Monday 04/10/2014
11 FG (Functional gymnastics) Every Monday 04/10/2014
12 Rücken (Swimming) Every Monday 11/07/2015
13 Rücken (Swimming) Every Monday 11/07/2015
14 Rücken (Swimming) Every Tuesday 11/07/2015
15 Rücken (Swimming) Every Tuesday 11/07/2015
16 Rücken (Swimming) Every Thursday 11/07/2015
17 Rücken (Swimming) Every Thursday 11/07/2015
18 SV (Self-defence) Every Friday 03/03/2015
19 SV (Self-defence) Every Friday 03/03/2015
20 GLQ (GuoLin-Qigong) Every Monday 16/07/2014
21 GLQ (GuoLin-Qigong) Every Friday 16/07/2014
22 MED (Finding your inner peace) Every Monday 19/09/2013
23 MED (Finding your inner peace) Every Friday 01/02/2015
24 Yoga Every Monday 08/11/2013
25 Yoga Every Friday 08/11/2013
==== ================================ ======================= ============ ============
Courses which were active on at least one day of the period between 20140303 and 20140422:
>>> pv = dict(start_date=i2d(20140303), end_date=i2d(20140422))
>>> rt.show(rt.models.courses.Activities, param_values=pv, **kwargs)
==== ================================ ================= ============ ==========
ID Activity line When Start date End Date
---- -------------------------------- ----------------- ------------ ----------
3 comp (First Steps) Every Monday 18/03/2014
4 comp (First Steps) Every Wednesday 18/03/2014
5 comp (First Steps) Every Friday 18/03/2014
9 BT (Belly dancing) Every Wednesday 28/03/2014
22 MED (Finding your inner peace) Every Monday 19/09/2013
24 Yoga Every Monday 08/11/2013
25 Yoga Every Friday 08/11/2013
==== ================================ ================= ============ ==========