1.1 --- a/imiptools/freebusy/database.py Wed Jun 14 00:21:20 2017 +0200
1.2 +++ b/imiptools/freebusy/database.py Wed Jun 14 00:30:32 2017 +0200
1.3 @@ -183,6 +183,27 @@
1.4
1.5 self.cursor.execute(query, values)
1.6
1.7 + def remove_periods_before(self, period):
1.8 +
1.9 + "Remove the entries in the collection before 'period'."
1.10 +
1.11 + end = format_datetime(period.get_start_point())
1.12 +
1.13 + columns, values = [], []
1.14 +
1.15 + if end:
1.16 + columns.append("end <= ?")
1.17 + values.append(end)
1.18 +
1.19 + query, values = self.get_query(
1.20 + "delete from %(table)s :condition" % {
1.21 + "columns" : self.columnlist(self.period_columns),
1.22 + "table" : self.table_name
1.23 + },
1.24 + columns, values)
1.25 +
1.26 + self.cursor.execute(query, values)
1.27 +
1.28 def remove_event_periods(self, uid, recurrenceid=None, participant=None):
1.29
1.30 """