#!/bin/bash
|
|
|
|
sqlite3 "$HOME/notes/metadata.db" <<SQL
|
|
.mode list
|
|
.separator ' - '
|
|
SELECT '~/notes/vimwiki/' || page, title FROM pages
|
|
-- WHERE page LIKE 'log/%'
|
|
WHERE datetime IS NOT NULL
|
|
ORDER BY datetime DESC
|
|
SQL
|