brennen
/
bpb-kit
1
0
Fork 0
Code Issues 0 Pull Requests 1 Releases 0 Wiki Activity
Dotfiles, utilities, and other apparatus.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
905 Commits
6 Branches
6.8 MiB
Branch: main
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'main'
${ noResults }
bpb-kit/home/bin/notes-log-index

10 lines
220 B
Raw Permalink Normal View History

bin/notes-log-index Just a quick index of logs, for the moment.
3 years ago
​
​
​
​
​
notes-log-index: a log is a page with a datetime ...rather than something which happens to be in log/. In practice this now includes diary entries.
2 years ago
​
bin/notes-log-index Just a quick index of logs, for the moment.
3 years ago
​
 
  1. #!/bin/bash
  2. 

  3. sqlite3 "$HOME/notes/metadata.db" <<SQL
  4. .mode list
  5. .separator ' - '
  6. SELECT '~/notes/vimwiki/' || page, title FROM pages
  7.   -- WHERE page LIKE 'log/%'
  8.   WHERE datetime IS NOT NULL
  9.   ORDER BY datetime DESC
  10. SQL