Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix SQL to find name for /json/timeline/event |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | ben-json-timeline |
Files: | files | file ages | folders |
SHA3-256: |
2488996f64d78d5fa7120d0125733909 |
User & Date: | ben 2018-06-20 10:29:41.028 |
Context
2018-06-20
| ||
18:15 | Fixed a C99-ism, removed a couple ancient #if blocks. Re-added uuid to /json/timeline/event output (because it's useful in ways which the event name is not). ... (Closed-Leaf check-in: 57e75eb7 user: stephan tags: ben-json-timeline) | |
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) | |
Changes
Changes to src/json_timeline.c.
︙ | ︙ | |||
551 552 553 554 555 556 557 | /* 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 | | | 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 | /* 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=json_timeline.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" |
︙ | ︙ |