Paul Batcheloradded keywords page25802576 years agoHistory
25 lines · 646 B · Text
RawDownload
(defn mkpage []  (var db (sqlite3/open "keys.db"))  (var keys       (sqlite3/eval        db        (string         "SELECT DISTINCT(keyword) from keywords "         "WHERE keyword is NOT '' "         "ORDER by keyword ASC;")))   (each k keys    (var pages         (sqlite3/eval          db          (string "SELECT DISTINCT(page) FROM keywords where keyword is '"                  (k "keyword") "';")))    (org     (string      (string/replace-all "_" "_" (k "keyword")) ": "))    (ref ((pages 0) "page"))    (for i 1 (length pages)      (org ", ")      (ref ((pages i) "page")))    (org "\n"))  (sqlite3/close db))

Keyboard shortcuts

General

Show keyboard shortcuts
?
Focus the current search
/

Issues and pull requests

Open filters
f

Issues, pull requests and Inbox

Select next item
j↓
Select previous item
k↑
Open selected item
Enter
Dismiss filters or clear selection
Esc

Repository code

Go to file
t