Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Include name (not uuid) in /json/timeline/event, because the uuid is not terribly useful.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | ben-json-timeline
Files: files | file ages | folders
SHA3-256:6f0929ce000718c71dbbb307f95d08576b8e12c3f53bd223e05a7509251d6b6c
User & Date: ben 2018-06-20 09:41:27
Context
2018-06-20
10:29
Fix SQL to find name for /json/timeline/event check-in: 2488996f user: ben tags: ben-json-timeline
09:41
Include name (not uuid) in /json/timeline/event, because the uuid is not terribly useful. check-in: 6f0929ce user: ben tags: ben-json-timeline
2018-06-19
10:31
Add /json/timeline/event for access to minimal information about events. check-in: c7607916 user: ben tags: ben-json-timeline
Changes

Changes to src/json_timeline.c.

550
551
552
553
554
555
556
557

558
559
560
561
562
563
564
#if 0
  /* only for testing! */
  cson_object_set(pay, "timelineSql", cson_value_new_string(blob_buffer(&sql),strlen(blob_buffer(&sql))));
#endif
  db_multi_exec("%s", blob_buffer(&sql) /*safe-for-%s*/);
  blob_reset(&sql);
  db_prepare(&q, "SELECT"
             " uuid AS uuid,"

             " mtime AS timestamp,"
#if 0
             " timestampString AS timestampString,"
#endif
             " comment AS comment, "
             " user AS user,"
             " eventType AS eventType"







|
>







550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
#if 0
  /* only for testing! */
  cson_object_set(pay, "timelineSql", cson_value_new_string(blob_buffer(&sql),strlen(blob_buffer(&sql))));
#endif
  db_multi_exec("%s", blob_buffer(&sql) /*safe-for-%s*/);
  blob_reset(&sql);
  db_prepare(&q, "SELECT"
             // uuid is not useful for events
             " substr((SELECT tagname FROM tag AS tn WHERE tn.tagid=tagId AND tagname LIKE 'event-%%'),7) AS name,"
             " mtime AS timestamp,"
#if 0
             " timestampString AS timestampString,"
#endif
             " comment AS comment, "
             " user AS user,"
             " eventType AS eventType"