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 | SQL 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 |
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 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=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"
|
| |
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"
|