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: |
6f0929ce000718c71dbbb307f95d0857 |
| 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"
|