filter.py 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631
  1. # This file is part of Radicale - CalDAV and CardDAV server
  2. # Copyright © 2008 Nicolas Kandel
  3. # Copyright © 2008 Pascal Halter
  4. # Copyright © 2008-2015 Guillaume Ayoub
  5. # Copyright © 2017-2021 Unrud <unrud@outlook.com>
  6. # Copyright © 2023-2024 Ray <ray@react0r.com>
  7. # Copyright © 2024-2025 Peter Bieringer <pb@bieringer.de>
  8. #
  9. # This library is free software: you can redistribute it and/or modify
  10. # it under the terms of the GNU General Public License as published by
  11. # the Free Software Foundation, either version 3 of the License, or
  12. # (at your option) any later version.
  13. #
  14. # This library is distributed in the hope that it will be useful,
  15. # but WITHOUT ANY WARRANTY; without even the implied warranty of
  16. # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17. # GNU General Public License for more details.
  18. #
  19. # You should have received a copy of the GNU General Public License
  20. # along with Radicale. If not, see <http://www.gnu.org/licenses/>.
  21. import math
  22. import xml.etree.ElementTree as ET
  23. from datetime import date, datetime, timedelta, timezone
  24. from itertools import chain
  25. from typing import (Callable, Iterable, Iterator, List, Optional, Sequence,
  26. Tuple)
  27. import vobject
  28. from radicale import item, xmlutils
  29. from radicale.log import logger
  30. DAY: timedelta = timedelta(days=1)
  31. SECOND: timedelta = timedelta(seconds=1)
  32. DATETIME_MIN: datetime = datetime.min.replace(tzinfo=timezone.utc)
  33. DATETIME_MAX: datetime = datetime.max.replace(tzinfo=timezone.utc)
  34. TIMESTAMP_MIN: int = math.floor(DATETIME_MIN.timestamp())
  35. TIMESTAMP_MAX: int = math.ceil(DATETIME_MAX.timestamp())
  36. def date_to_datetime(d: date) -> datetime:
  37. """Transform any date to a UTC datetime.
  38. If ``d`` is a datetime without timezone, return as UTC datetime. If ``d``
  39. is already a datetime with timezone, return as is.
  40. """
  41. if not isinstance(d, datetime):
  42. d = datetime.combine(d, datetime.min.time())
  43. if not d.tzinfo:
  44. # NOTE: using vobject's UTC as it wasn't playing well with datetime's.
  45. d = d.replace(tzinfo=vobject.icalendar.utc)
  46. return d
  47. def parse_time_range(time_filter: ET.Element) -> Tuple[datetime, datetime]:
  48. start_text = time_filter.get("start")
  49. end_text = time_filter.get("end")
  50. if start_text:
  51. start = datetime.strptime(
  52. start_text, "%Y%m%dT%H%M%SZ").replace(
  53. tzinfo=timezone.utc)
  54. else:
  55. start = DATETIME_MIN
  56. if end_text:
  57. end = datetime.strptime(
  58. end_text, "%Y%m%dT%H%M%SZ").replace(
  59. tzinfo=timezone.utc)
  60. else:
  61. end = DATETIME_MAX
  62. return start, end
  63. def time_range_timestamps(time_filter: ET.Element) -> Tuple[int, int]:
  64. start, end = parse_time_range(time_filter)
  65. return (math.floor(start.timestamp()), math.ceil(end.timestamp()))
  66. def comp_match(item: "item.Item", filter_: ET.Element, level: int = 0) -> bool:
  67. """Check whether the ``item`` matches the comp ``filter_``.
  68. If ``level`` is ``0``, the filter is applied on the
  69. item's collection. Otherwise, it's applied on the item.
  70. See rfc4791-9.7.1.
  71. """
  72. # TODO: Filtering VFREEBUSY is not implemented
  73. # HACK: the filters are tested separately against all components
  74. name = filter_.get("name", "").upper()
  75. if level == 0:
  76. tag = item.name
  77. elif level == 1:
  78. tag = item.component_name
  79. elif level == 2:
  80. tag = item.component_name
  81. else:
  82. logger.warning(
  83. "Filters with %d levels of comp-filter are not supported", level)
  84. return True
  85. if not tag:
  86. return False
  87. if len(filter_) == 0:
  88. # Point #1 of rfc4791-9.7.1
  89. return name == tag
  90. if len(filter_) == 1:
  91. if filter_[0].tag == xmlutils.make_clark("C:is-not-defined"):
  92. # Point #2 of rfc4791-9.7.1
  93. return name != tag
  94. if (level < 2) and (name != tag):
  95. return False
  96. if ((level == 0 and name != "VCALENDAR") or
  97. (level == 1 and name not in ("VTODO", "VEVENT", "VJOURNAL")) or
  98. (level == 2 and name not in ("VALARM"))):
  99. logger.warning("Filtering %s is not supported", name)
  100. return True
  101. # Point #3 and #4 of rfc4791-9.7.1
  102. trigger = None
  103. if level == 0:
  104. components = [item.vobject_item]
  105. elif level == 1:
  106. components = list(getattr(item.vobject_item, "%s_list" % tag.lower()))
  107. elif level == 2:
  108. components = list(getattr(item.vobject_item, "%s_list" % tag.lower()))
  109. for comp in components:
  110. subcomp = getattr(comp, name.lower(), None)
  111. if not subcomp:
  112. return False
  113. if hasattr(subcomp, "trigger"):
  114. # rfc4791-7.8.5:
  115. trigger = subcomp.trigger.value
  116. for child in filter_:
  117. if child.tag == xmlutils.make_clark("C:prop-filter"):
  118. if not any(prop_match(comp, child, "C")
  119. for comp in components):
  120. return False
  121. elif child.tag == xmlutils.make_clark("C:time-range"):
  122. if not time_range_match(item.vobject_item, filter_[0], tag, trigger):
  123. return False
  124. elif child.tag == xmlutils.make_clark("C:comp-filter"):
  125. if not comp_match(item, child, level=level + 1):
  126. return False
  127. else:
  128. raise ValueError("Unexpected %r in comp-filter" % child.tag)
  129. return True
  130. def prop_match(vobject_item: vobject.base.Component,
  131. filter_: ET.Element, ns: str) -> bool:
  132. """Check whether the ``item`` matches the prop ``filter_``.
  133. See rfc4791-9.7.2 and rfc6352-10.5.1.
  134. """
  135. name = filter_.get("name", "").lower()
  136. if len(filter_) == 0:
  137. # Point #1 of rfc4791-9.7.2
  138. return name in vobject_item.contents
  139. if len(filter_) == 1:
  140. if filter_[0].tag == xmlutils.make_clark("%s:is-not-defined" % ns):
  141. # Point #2 of rfc4791-9.7.2
  142. return name not in vobject_item.contents
  143. if name not in vobject_item.contents:
  144. return False
  145. # Point #3 and #4 of rfc4791-9.7.2
  146. for child in filter_:
  147. if ns == "C" and child.tag == xmlutils.make_clark("C:time-range"):
  148. if not time_range_match(vobject_item, child, name, None):
  149. return False
  150. elif child.tag == xmlutils.make_clark("%s:text-match" % ns):
  151. if not text_match(vobject_item, child, name, ns):
  152. return False
  153. elif child.tag == xmlutils.make_clark("%s:param-filter" % ns):
  154. if not param_filter_match(vobject_item, child, name, ns):
  155. return False
  156. else:
  157. raise ValueError("Unexpected %r in prop-filter" % child.tag)
  158. return True
  159. def time_range_match(vobject_item: vobject.base.Component,
  160. filter_: ET.Element, child_name: str, trigger: datetime | None) -> bool:
  161. """Check whether the component/property ``child_name`` of
  162. ``vobject_item`` matches the time-range ``filter_``."""
  163. # supporting since 3.5.4 now optional trigger (either absolute or relative offset)
  164. if not filter_.get("start") and not filter_.get("end"):
  165. return False
  166. start, end = parse_time_range(filter_)
  167. matched = False
  168. def range_fn(range_start: datetime, range_end: datetime,
  169. is_recurrence: bool) -> bool:
  170. nonlocal matched
  171. if trigger:
  172. # if trigger is given, only check range_start
  173. if isinstance(trigger, timedelta):
  174. # trigger is a offset, apply to range_start
  175. if start < range_start + trigger and range_start + trigger < end:
  176. matched = True
  177. return True
  178. else:
  179. return False
  180. elif isinstance(trigger, datetime):
  181. # trigger is absolute, use instead of range_start
  182. if start < trigger and trigger < end:
  183. matched = True
  184. return True
  185. else:
  186. return False
  187. else:
  188. logger.warning("item/filter/time_range_match/range_fn: unsupported data format of provided trigger=%r", trigger)
  189. return True
  190. if start < range_end and range_start < end:
  191. matched = True
  192. return True
  193. if end < range_start and not is_recurrence:
  194. return True
  195. return False
  196. def infinity_fn(start: datetime) -> bool:
  197. return False
  198. visit_time_ranges(vobject_item, child_name, range_fn, infinity_fn)
  199. return matched
  200. def time_range_fill(vobject_item: vobject.base.Component,
  201. filter_: ET.Element, child_name: str, n: int = 1
  202. ) -> List[Tuple[datetime, datetime]]:
  203. """Create a list of ``n`` occurances from the component/property ``child_name``
  204. of ``vobject_item``."""
  205. if not filter_.get("start") and not filter_.get("end"):
  206. return []
  207. start, end = parse_time_range(filter_)
  208. ranges: List[Tuple[datetime, datetime]] = []
  209. def range_fn(range_start: datetime, range_end: datetime,
  210. is_recurrence: bool) -> bool:
  211. nonlocal ranges
  212. if start < range_end and range_start < end:
  213. ranges.append((range_start, range_end))
  214. if n > 0 and len(ranges) >= n:
  215. return True
  216. if end < range_start and not is_recurrence:
  217. return True
  218. return False
  219. def infinity_fn(range_start: datetime) -> bool:
  220. return False
  221. visit_time_ranges(vobject_item, child_name, range_fn, infinity_fn)
  222. return ranges
  223. def visit_time_ranges(vobject_item: vobject.base.Component, child_name: str,
  224. range_fn: Callable[[datetime, datetime, bool], bool],
  225. infinity_fn: Callable[[datetime], bool]) -> None:
  226. """Visit all time ranges in the component/property ``child_name`` of
  227. `vobject_item`` with visitors ``range_fn`` and ``infinity_fn``.
  228. ``range_fn`` gets called for every time_range with ``start`` and ``end``
  229. datetimes and ``is_recurrence`` as arguments. If the function returns True,
  230. the operation is cancelled.
  231. ``infinity_fn`` gets called when an infinite recurrence rule is detected
  232. with ``start`` datetime as argument. If the function returns True, the
  233. operation is cancelled.
  234. See rfc4791-9.9.
  235. """
  236. # HACK: According to rfc5545-3.8.4.4 a recurrence that is rescheduled
  237. # with Recurrence ID affects the recurrence itself and all following
  238. # recurrences too. This is not respected and client don't seem to bother
  239. # either.
  240. def getrruleset(child: vobject.base.Component, ignore: Sequence[date]
  241. ) -> Tuple[Iterable[date], bool]:
  242. infinite = False
  243. for rrule in child.contents.get("rrule", []):
  244. if (";UNTIL=" not in rrule.value.upper() and
  245. ";COUNT=" not in rrule.value.upper()):
  246. infinite = True
  247. break
  248. if infinite:
  249. for dtstart in child.getrruleset(addRDate=True):
  250. if dtstart in ignore:
  251. continue
  252. if infinity_fn(date_to_datetime(dtstart)):
  253. return (), True
  254. break
  255. return filter(lambda dtstart: dtstart not in ignore,
  256. child.getrruleset(addRDate=True)), False
  257. def get_children(components: Iterable[vobject.base.Component]) -> Iterator[
  258. Tuple[vobject.base.Component, bool, List[date]]]:
  259. main = None
  260. rec_main = None
  261. recurrences = []
  262. for comp in components:
  263. if hasattr(comp, "recurrence_id") and comp.recurrence_id.value:
  264. recurrences.append(comp.recurrence_id.value)
  265. if comp.rruleset:
  266. if comp.rruleset._len is None:
  267. logger.warning("Ignore empty RRULESET in item at RECURRENCE-ID with value '%s' and UID '%s'", comp.recurrence_id.value, comp.uid.value)
  268. else:
  269. # Prevent possible infinite loop
  270. raise ValueError("Overwritten recurrence with RRULESET")
  271. rec_main = comp
  272. yield comp, True, []
  273. else:
  274. if main is not None:
  275. raise ValueError("Multiple main components. Got comp: {}".format(comp))
  276. main = comp
  277. if main is None and len(recurrences) == 1:
  278. main = rec_main
  279. if main is None:
  280. raise ValueError("Main component missing")
  281. yield main, False, recurrences
  282. # Comments give the lines in the tables of the specification
  283. if child_name == "VEVENT":
  284. for child, is_recurrence, recurrences in get_children(
  285. vobject_item.vevent_list):
  286. # TODO: check if there's a timezone
  287. dtstart = child.dtstart.value
  288. if child.rruleset:
  289. dtstarts, infinity = getrruleset(child, recurrences)
  290. if infinity:
  291. return
  292. else:
  293. dtstarts = (dtstart,)
  294. dtend = getattr(child, "dtend", None)
  295. if dtend is not None:
  296. dtend = dtend.value
  297. original_duration = (dtend - dtstart).total_seconds()
  298. dtend = date_to_datetime(dtend)
  299. duration = getattr(child, "duration", None)
  300. if duration is not None:
  301. original_duration = duration = duration.value
  302. for dtstart in dtstarts:
  303. dtstart_is_datetime = isinstance(dtstart, datetime)
  304. dtstart = date_to_datetime(dtstart)
  305. if dtend is not None:
  306. # Line 1
  307. dtend = dtstart + timedelta(seconds=original_duration)
  308. if range_fn(dtstart, dtend, is_recurrence):
  309. return
  310. elif duration is not None:
  311. if original_duration is None:
  312. original_duration = duration.seconds
  313. if duration.seconds > 0:
  314. # Line 2
  315. if range_fn(dtstart, dtstart + duration,
  316. is_recurrence):
  317. return
  318. else:
  319. # Line 3
  320. if range_fn(dtstart, dtstart + SECOND, is_recurrence):
  321. return
  322. elif dtstart_is_datetime:
  323. # Line 4
  324. if range_fn(dtstart, dtstart + SECOND, is_recurrence):
  325. return
  326. else:
  327. # Line 5
  328. if range_fn(dtstart, dtstart + DAY, is_recurrence):
  329. return
  330. elif child_name == "VTODO":
  331. for child, is_recurrence, recurrences in get_children(
  332. vobject_item.vtodo_list):
  333. dtstart = getattr(child, "dtstart", None)
  334. duration = getattr(child, "duration", None)
  335. due = getattr(child, "due", None)
  336. completed = getattr(child, "completed", None)
  337. created = getattr(child, "created", None)
  338. if dtstart is not None:
  339. dtstart = date_to_datetime(dtstart.value)
  340. if duration is not None:
  341. duration = duration.value
  342. if due is not None:
  343. due = date_to_datetime(due.value)
  344. if dtstart is not None:
  345. original_duration = (due - dtstart).total_seconds()
  346. if completed is not None:
  347. completed = date_to_datetime(completed.value)
  348. if created is not None:
  349. created = date_to_datetime(created.value)
  350. original_duration = (completed - created).total_seconds()
  351. elif created is not None:
  352. created = date_to_datetime(created.value)
  353. if child.rruleset:
  354. reference_dates, infinity = getrruleset(child, recurrences)
  355. if infinity:
  356. return
  357. else:
  358. if dtstart is not None:
  359. reference_dates = (dtstart,)
  360. elif due is not None:
  361. reference_dates = (due,)
  362. elif completed is not None:
  363. reference_dates = (completed,)
  364. elif created is not None:
  365. reference_dates = (created,)
  366. else:
  367. # Line 8
  368. if range_fn(DATETIME_MIN, DATETIME_MAX, is_recurrence):
  369. return
  370. reference_dates = ()
  371. for reference_date in reference_dates:
  372. reference_date = date_to_datetime(reference_date)
  373. if dtstart is not None and duration is not None:
  374. # Line 1
  375. if range_fn(reference_date,
  376. reference_date + duration + SECOND,
  377. is_recurrence):
  378. return
  379. if range_fn(reference_date + duration - SECOND,
  380. reference_date + duration + SECOND,
  381. is_recurrence):
  382. return
  383. elif dtstart is not None and due is not None:
  384. # Line 2
  385. due = reference_date + timedelta(seconds=original_duration)
  386. if (range_fn(reference_date, due, is_recurrence) or
  387. range_fn(reference_date,
  388. reference_date + SECOND, is_recurrence) or
  389. range_fn(due - SECOND, due, is_recurrence) or
  390. range_fn(due - SECOND, reference_date + SECOND,
  391. is_recurrence)):
  392. return
  393. elif dtstart is not None:
  394. if range_fn(reference_date, reference_date + SECOND,
  395. is_recurrence):
  396. return
  397. elif due is not None:
  398. # Line 4
  399. if range_fn(reference_date - SECOND, reference_date,
  400. is_recurrence):
  401. return
  402. elif completed is not None and created is not None:
  403. # Line 5
  404. completed = reference_date + timedelta(
  405. seconds=original_duration)
  406. if (range_fn(reference_date - SECOND,
  407. reference_date + SECOND,
  408. is_recurrence) or
  409. range_fn(completed - SECOND, completed + SECOND,
  410. is_recurrence) or
  411. range_fn(reference_date - SECOND,
  412. reference_date + SECOND, is_recurrence) or
  413. range_fn(completed - SECOND, completed + SECOND,
  414. is_recurrence)):
  415. return
  416. elif completed is not None:
  417. # Line 6
  418. if range_fn(reference_date - SECOND,
  419. reference_date + SECOND, is_recurrence):
  420. return
  421. elif created is not None:
  422. # Line 7
  423. if range_fn(reference_date, DATETIME_MAX, is_recurrence):
  424. return
  425. elif child_name == "VJOURNAL":
  426. for child, is_recurrence, recurrences in get_children(
  427. vobject_item.vjournal_list):
  428. dtstart = getattr(child, "dtstart", None)
  429. if dtstart is not None:
  430. dtstart = dtstart.value
  431. if child.rruleset:
  432. dtstarts, infinity = getrruleset(child, recurrences)
  433. if infinity:
  434. return
  435. else:
  436. dtstarts = (dtstart,)
  437. for dtstart in dtstarts:
  438. dtstart_is_datetime = isinstance(dtstart, datetime)
  439. dtstart = date_to_datetime(dtstart)
  440. if dtstart_is_datetime:
  441. # Line 1
  442. if range_fn(dtstart, dtstart + SECOND, is_recurrence):
  443. return
  444. else:
  445. # Line 2
  446. if range_fn(dtstart, dtstart + DAY, is_recurrence):
  447. return
  448. else:
  449. # Match a property
  450. child = getattr(vobject_item, child_name.lower())
  451. if isinstance(child.value, date):
  452. child_is_datetime = isinstance(child.value, datetime)
  453. child = date_to_datetime(child.value)
  454. if child_is_datetime:
  455. range_fn(child, child + SECOND, False)
  456. else:
  457. range_fn(child, child + DAY, False)
  458. def text_match(vobject_item: vobject.base.Component,
  459. filter_: ET.Element, child_name: str, ns: str,
  460. attrib_name: Optional[str] = None) -> bool:
  461. """Check whether the ``item`` matches the text-match ``filter_``.
  462. See rfc4791-9.7.5.
  463. """
  464. # TODO: collations are not supported, but the default ones needed
  465. # for DAV servers are actually pretty useless. Texts are lowered to
  466. # be case-insensitive, almost as the "i;ascii-casemap" value.
  467. text = next(filter_.itertext()).lower()
  468. match_type = "contains"
  469. if ns == "CR":
  470. match_type = filter_.get("match-type", match_type)
  471. def match(value: str) -> bool:
  472. value = value.lower()
  473. if match_type == "equals":
  474. return value == text
  475. if match_type == "contains":
  476. return text in value
  477. if match_type == "starts-with":
  478. return value.startswith(text)
  479. if match_type == "ends-with":
  480. return value.endswith(text)
  481. raise ValueError("Unexpected text-match match-type: %r" % match_type)
  482. children = getattr(vobject_item, "%s_list" % child_name, [])
  483. if attrib_name is not None:
  484. condition = any(
  485. match(attrib) for child in children
  486. for attrib in child.params.get(attrib_name, []))
  487. else:
  488. res = []
  489. for child in children:
  490. # Some filters such as CATEGORIES provide a list in child.value
  491. if type(child.value) is list:
  492. for value in child.value:
  493. res.append(match(value))
  494. else:
  495. res.append(match(child.value))
  496. condition = any(res)
  497. if filter_.get("negate-condition") == "yes":
  498. return not condition
  499. return condition
  500. def param_filter_match(vobject_item: vobject.base.Component,
  501. filter_: ET.Element, parent_name: str, ns: str) -> bool:
  502. """Check whether the ``item`` matches the param-filter ``filter_``.
  503. See rfc4791-9.7.3.
  504. """
  505. name = filter_.get("name", "").upper()
  506. children = getattr(vobject_item, "%s_list" % parent_name, [])
  507. condition = any(name in child.params for child in children)
  508. if len(filter_) > 0:
  509. if filter_[0].tag == xmlutils.make_clark("%s:text-match" % ns):
  510. return condition and text_match(
  511. vobject_item, filter_[0], parent_name, ns, name)
  512. if filter_[0].tag == xmlutils.make_clark("%s:is-not-defined" % ns):
  513. return not condition
  514. return condition
  515. def simplify_prefilters(filters: Iterable[ET.Element], collection_tag: str
  516. ) -> Tuple[Optional[str], int, int, bool]:
  517. """Creates a simplified condition from ``filters``.
  518. Returns a tuple (``tag``, ``start``, ``end``, ``simple``) where ``tag`` is
  519. a string or None (match all) and ``start`` and ``end`` are POSIX
  520. timestamps (as int). ``simple`` is a bool that indicates that ``filters``
  521. and the simplified condition are identical.
  522. """
  523. flat_filters = list(chain.from_iterable(filters))
  524. simple = len(flat_filters) <= 1
  525. for col_filter in flat_filters:
  526. if collection_tag != "VCALENDAR":
  527. simple = False
  528. break
  529. if (col_filter.tag != xmlutils.make_clark("C:comp-filter") or
  530. col_filter.get("name", "").upper() != "VCALENDAR"):
  531. simple = False
  532. continue
  533. simple &= len(col_filter) <= 1
  534. for comp_filter in col_filter:
  535. if comp_filter.tag != xmlutils.make_clark("C:comp-filter"):
  536. simple = False
  537. continue
  538. tag = comp_filter.get("name", "").upper()
  539. if comp_filter.find(
  540. xmlutils.make_clark("C:is-not-defined")) is not None:
  541. simple = False
  542. continue
  543. simple &= len(comp_filter) <= 1
  544. for time_filter in comp_filter:
  545. if tag not in ("VTODO", "VEVENT", "VJOURNAL"):
  546. simple = False
  547. break
  548. if time_filter.tag != xmlutils.make_clark("C:time-range"):
  549. simple = False
  550. continue
  551. start, end = time_range_timestamps(time_filter)
  552. return tag, start, end, simple
  553. return tag, TIMESTAMP_MIN, TIMESTAMP_MAX, simple
  554. return None, TIMESTAMP_MIN, TIMESTAMP_MAX, simple