cgi.scm (55708B)
1 ; Copyright (c) 2026, Natacha Porté 2 ; 3 ; Permission to use, copy, modify, and distribute this software for any 4 ; purpose with or without fee is hereby granted, provided that the above 5 ; copyright notice and this permission notice appear in all copies. 6 ; 7 ; THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES 8 ; WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF 9 ; MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR 10 ; ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES 11 ; WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN 12 ; ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF 13 ; OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. 14 15 (import 16 (chicken file posix) 17 (chicken io) 18 (chicken process-context) 19 (chicken sort) 20 (chicken string) 21 (chicken time) 22 (chicken time posix) 23 comparse 24 openssl ; must be above http-client 25 http-client 26 lowdown 27 message-digest-byte-vector 28 rss 29 sha256-primitive 30 sql-de-lite 31 sxml-serializer) 32 33 (define sha-256 (sha256-primitive)) 34 (define css-style #<<END-OF-CSS 35 * { box-sizing: border-box; } 36 h1 { text-align: center; } 37 nav ul { display: flex; justify-content: space-evenly; align-items: center; list-style-type: none; margin: 2ex 0; padding: 0; } 38 pre { overflow: auto; } 39 .form-body { overflow: auto; } 40 .bad-post { background: #fcc; } 41 .marked-post { background: #ccf; } 42 .locked-post { background: #cff; } 43 .protected-post { background: #cfc; } 44 form { 45 position: relative; 46 margin: 1rex 0; 47 display: grid; 48 gap: 0.5rex; 49 transition: all 0.5s ease-in; 50 } 51 .sidenote { 52 position: absolute; 53 top: 1ex; right: 1ex; 54 margin: 0; 55 opacity: 0.6; 56 } 57 .lsub { width: 4.5rem; height: 3rem; } 58 .rsub { width: 4.5rem; height: 3rem; } 59 input[type=url],input[type=text] { display: block; width: 100%; } 60 textarea { display: block; max-width: 100%; } 61 .tag-list { column-width: 10rem; column-gap: 1rem; } 62 .tag-list label { display: block; } 63 span.ptime { font-size: 80%; } 64 span.section { font-size: 80%; } 65 a.section { font-size: 80%; } 66 span.title { font-weight: bold; display: block; } 67 span.taglist { font-weight: bold; font-size: 80%; } 68 span.hashid { font-size: 90%; opacity: 0.6; } 69 @media (min-width: 60rem) { 70 form { 71 grid-template-columns: 5rem 1fr 5rem; 72 align-items: center; 73 } 74 75 .form-body { grid-column: 2; } 76 .lsub { grid-column: 1; justify-self: start; } 77 .rsub { grid-column: 3; justify-self: end; } 78 } 79 @media (max-width: 59.9rem) { 80 form { 81 grid-template-columns: 1fr 1fr; 82 grid-template-areas: "c c" "l r"; 83 } 84 85 .form-body { grid-area: c; } 86 .lsub { grid-area: l; justify-self: start; } 87 .rsub { grid-area: r; justify-self: end; } 88 #load-new input, #load-new svg { grid-area: c; } 89 } 90 91 #load-new { text-align: center; grid-template-columns: auto; } 92 #load-new input { width: 4.5rem; height: 3rem; margin: auto; } 93 #load-new svg { width: 4.5rem; height: 3rem; margin: auto; fill: #494949; } 94 #load-new svg { display: none; } 95 #load-new.htmx-request svg { display: block; } 96 .htmx-request input { display: none; } 97 98 body { background: #F0ECE0; color: #000000; } 99 form { background: #FFFFFF; } 100 a:link { color: #007FBF; } 101 a:visited { color: #003F7F; } 102 a:hover { background: #007FBF; color: #F0E8E0; } 103 104 @media (prefers-color-scheme: dark) { 105 body { background: #103c48; color: #adbcbc; } 106 form { background: #184956; color: #cad8d9; } 107 a:link { color: #4695f7; } 108 a:visited { color: #af88eb; } 109 a:hover { background: #4695f7; color: #103c48; } 110 .bad-post { background: #783946; } 111 .marked-post { background: #1849a6; } 112 .locked-post { background: #189999; } 113 .protected-post { background: #189956; } 114 #load-new svg { fill: #cad8d9; } 115 } 116 END-OF-CSS 117 ) 118 119 (define content-length 120 (let ((ct (get-environment-variable "CONTENT_LENGTH"))) 121 (if ct (string->number ct) 0))) 122 (define input-text (read-string content-length)) 123 (define url-hdigit 124 (any-of (preceded-by (is #\0) (result 0)) 125 (preceded-by (is #\1) (result 1)) 126 (preceded-by (is #\2) (result 2)) 127 (preceded-by (is #\3) (result 3)) 128 (preceded-by (is #\4) (result 4)) 129 (preceded-by (is #\5) (result 5)) 130 (preceded-by (is #\6) (result 6)) 131 (preceded-by (is #\7) (result 7)) 132 (preceded-by (is #\8) (result 8)) 133 (preceded-by (is #\9) (result 9)) 134 (preceded-by (is #\a) (result 10)) 135 (preceded-by (is #\A) (result 10)) 136 (preceded-by (is #\b) (result 11)) 137 (preceded-by (is #\B) (result 11)) 138 (preceded-by (is #\c) (result 12)) 139 (preceded-by (is #\C) (result 12)) 140 (preceded-by (is #\d) (result 13)) 141 (preceded-by (is #\D) (result 13)) 142 (preceded-by (is #\e) (result 14)) 143 (preceded-by (is #\E) (result 14)) 144 (preceded-by (is #\f) (result 15)) 145 (preceded-by (is #\F) (result 15)))) 146 (define url-percent-escape 147 (sequence* ((_ (is #\%)) 148 (h url-hdigit) 149 (l url-hdigit)) 150 (result (integer->char (+ (* 16 h) l))))) 151 (define url-value-char 152 (any-of url-percent-escape 153 (preceded-by (is #\+) (result #\space)) 154 item)) 155 (define url-value 156 (as-string 157 (any-of (repeated url-value-char until: (is #\&)) 158 (repeated url-value-char)))) 159 (define url-key 160 (as-string (repeated item until: (is #\=)))) 161 (define url-kv-pair 162 (sequence* ((k url-key) 163 (_ (is #\=)) 164 (v url-value)) 165 (result (cons k (string-translate v "\r"))))) 166 (define url-kv-pairs 167 (sequence* ((h url-kv-pair) 168 (t (zero-or-more (preceded-by (is #\&) url-kv-pair)))) 169 (result (cons h t)))) 170 (define url-query 171 (any-of (preceded-by (is #\?) url-kv-pairs) 172 (result '()))) 173 (define url-extra-query 174 (any-of (preceded-by (is #\&) url-kv-pairs) 175 (result '()))) 176 (define input-list 177 (if (string=? input-text "") '() (parse url-kv-pairs input-text))) 178 (define (input-var name) 179 (alist-ref name input-list string=?)) 180 (define (optional-input-var name fallback) 181 (let ((val (input-var name))) 182 (if val val fallback))) 183 (define (required-input-var name) 184 (let ((val (input-var name))) 185 (if val val (bad-input (conc "missing " name))))) 186 187 (define-constant default-n 100) 188 (define (q-limit-offset q) 189 (let* ((ns (alist-ref "n" q string=?)) 190 (nn (if ns (string->number ns) #f)) 191 (n (if (and nn (positive? nn)) nn default-n)) 192 (ps (alist-ref "p" q string=?)) 193 (pn (if ps (string->number ps) #f)) 194 (p (if (and pn (positive? pn)) pn 1))) 195 (list (add1 n) (* n (sub1 p))))) 196 (define (np-limit-offset l o) 197 (let ((n (sub1 l))) 198 (cons n (add1 (quotient o n))))) 199 200 (define start-html 201 "Content-Type: text/html\r\n\r\n<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">") 202 203 (define (html-output form) 204 (write-string start-html) 205 (serialize-sxml form 206 method: 'html 207 output: (current-output-port))) 208 209 (define (htmx-output form) 210 (write-string "Content-Type: text/html\r\n\r\n") 211 (serialize-sxml form 212 method: 'html 213 output: (current-output-port))) 214 215 (define (debug-output) 216 (html-output 217 `(html 218 (head (title "Variable dump")) 219 (body (h1 "Variable dump") 220 (p "Current directory: " ,(current-directory)) 221 (table 222 ,@(map 223 (lambda (pair) 224 `(tr (td ,(car pair)) (td ,(cdr pair)))) 225 (get-environment-variables))) 226 (h2 "Inputs") 227 (pre (code ,input-text)) 228 (table 229 ,@(map 230 (lambda (p) `(tr (td ,(car p)) (td ,(car p)))) 231 input-list)))))) 232 233 (define (die msg) 234 (write-string "Status: 500\r\n") 235 (when msg 236 (write-string "Content-Type: text/plain\r\n\r\n") 237 (write-string msg)) 238 (exit 1)) 239 (define (bad-input msg) 240 (write-string "Status: 400\r\n") 241 (when msg 242 (write-string "Content-Type: text/plain\r\n\r\n") 243 (write-string msg)) 244 (exit 0)) 245 246 (define parse-number 247 (one-or-more (in #\0 #\1 #\2 #\3 #\4 #\5 #\6 #\7 #\8 #\9))) 248 249 250 (define root (get-environment-variable "DOCUMENT_ROOT")) 251 (when (not root) 252 (die "Missing $DOCUMENT_ROOT")) 253 (define db-name (get-environment-variable "IENS_DB")) 254 (when (not db-name) 255 (die "Missing $IENS_DB")) 256 (define feed-root 257 (let ((raw (get-environment-variable "FEED_ROOT"))) 258 (cond 259 ((or (not raw) (zero? (string-length raw))) "") 260 ((eqv? #\/ (string-ref raw (sub1 (string-length raw)))) raw) 261 (else (string-append raw "/"))))) 262 263 (define db (open-database db-name)) 264 (exec (sql/transient db "PRAGMA foreign_keys = ON; 265 PRAGMA journal_mode = WAL; 266 PRAGMA synchronous = NORMAL; 267 PRAGMA busy_timeout = 5000;")) 268 (set-busy-handler! db (busy-timeout 10000)) 269 270 (include "common.scm") 271 272 (unless (= 8 (db-version)) 273 (die "Unexpectad database version")) 274 275 276 (define (clean-up) 277 (let* ((span (get-config "gruik-clean"))) 278 (when (number? span) 279 (exec 280 (sql db "DELETE FROM gruik 281 WHERE mark < 0 AND mtime < ?1 282 AND (lastseen IS NULL OR lastseen < ?1);") 283 (- (current-seconds) span))))) 284 285 (define (redirect location) 286 (write-string "Status: 302\r\nLocation: ") 287 (write-string (get-config/default "gruik-host" "")) 288 (write-string (get-config/default "gruik-prefix" "")) 289 (write-string location) 290 (write-string "\r\n\r\n")) 291 292 (define (auto-descr id) 293 (let ((row (query fetch-row 294 (sql db 295 (if (positive? id) 296 "SELECT section,url,comment_url FROM gruik 297 WHERE id=? AND COALESCE(description,'')='';" 298 "SELECT section,url,section_url FROM entry 299 WHERE protected=0 AND id=? 300 AND COALESCE(description,'')='';")) 301 (abs id)))) 302 (unless (null? row) 303 (let* ((section (car row)) 304 (url (cadr row)) 305 (dbcomm (caddr row)) 306 (comm (if (or (null? dbcomm) (string=? dbcomm "")) 307 (comment-link section url) 308 dbcomm))) 309 (if comm 310 (exec 311 (sql db 312 (if (positive? id) 313 "UPDATE gruik 314 SET description=?, 315 notes=trim(notes||char(10)||?,char(10)), 316 comment_url=? 317 WHERE id=? AND COALESCE(description,'')='';" 318 "UPDATE entry 319 SET description=?, 320 notes=trim(notes||char(10)||?,char(10)), 321 source_url=? 322 WHERE protected=0 AND id=? AND COALESCE(description,'')='';")) 323 (conc " + [](" url ")\n(via [" section "](" comm ") sur #gcufeed)") 324 comm 325 comm 326 (abs id)) 327 (exec 328 (sql db 329 (if (positive? id) 330 "UPDATE gruik SET description=? 331 WHERE id=? AND COALESCE(description,'')='';" 332 "UPDATE entry SET description=? 333 WHERE protected=0 AND id=? AND COALESCE(description,'')='';")) 334 (conc " + [](" url ")\n(via " section " sur #gcufeed)") 335 (abs id))))))) 336 337 (define (output-log-counts) 338 (let ((ne (query fetch-value 339 (sql db "SELECT COUNT(*) FROM entry WHERE protected=0;"))) 340 (ng (query fetch-value 341 (sql db "SELECT COUNT(*) FROM gruik WHERE mark>0;")))) 342 (write-line (conc (rfc-3339 (current-seconds)) "\t" ne "\t" ng)))) 343 (define (log-counts) 344 (let ((fname (get-environment-variable "NLOG"))) 345 (when fname 346 (with-output-to-file fname output-log-counts #:append #:text)))) 347 348 (define (spinner-bar x y height beg) 349 `(rect (@ (x ,x) (y ,y) (width 15) (height ,height) (rx 6)) 350 (animate (@ (attributeName height) (begin ,beg) (dur "1s") 351 (values "120;110;100;90;80;70;60;50;40;140;120") 352 (calcMode linear) (repeatCount indefinite))) 353 (animate (@ (attributeName y) (begin ,beg) (dur "1s") 354 (values "10;15;20;25;30;35;40;45;50;0;10") 355 (calcMode linear) (repeatCount indefinite))))) 356 (define (spinner-symbol) 357 `(svg (@ (style "display: none") (xmlns "http://www.w3.org/2000/svg")) 358 (symbol (@ (id "spinner") (viewBox "0 0 135 140")) 359 ,(spinner-bar 0 10 120 "0.5s") 360 ,(spinner-bar 30 10 120 "0.25s") 361 ,(spinner-bar 60 0 140 "0s") 362 ,(spinner-bar 90 10 120 "0.25s") 363 ,(spinner-bar 120 10 120 "0.5s")))) 364 (define (spinner-ref) 365 `(svg (@ (class spinner)) (use (@ (href "#spinner")) ""))) 366 367 (define (post-p-fragment id ptime mtime section title url comm-url tags) 368 `(p 369 (span (@ (class "ptime") (title ,(rfc-3339 mtime))) ,ptime) 370 ,(if (null? comm-url) 371 `(span (@ (class "section")) ,section) 372 `(a (@ (href ,comm-url) (class "section")) ,section)) 373 ,@(if (or (null? tags) (string=? tags "")) '() 374 `((span (@ (class "taglist")) ,tags))) 375 (span (@ (class "title")) ,title) 376 (a (@ (href ,url)) ,url) 377 (span (@ (class "hashid") (title ,id)) 378 "#" ,(substring (message-digest-string sha-256 url) 0 8)))) 379 380 (define (domain-counts url) 381 (and-let* ((i1 (substring-index "://" url)) 382 (i2 (substring-index "/" url (+ i1 3))) 383 (s (substring url i1 (add1 i2))) 384 (domain (substring url (+ i1 3) i2))) 385 (list domain 386 (query fetch-value 387 (sql db "SELECT COUNT(*) FROM entry WHERE instr(url,?)>0") s) 388 (query fetch-value 389 (sql db "SELECT COUNT(*) FROM gruik 390 WHERE mark>=0 AND instr(url,?)>0") s)))) 391 392 (define (edit-post-fragment id ptime mtime section title url comm-url mark notes description tags) 393 `(form (@ (method "POST") (action "do-edit") 394 (id ,(conc "post-" id)) (class "edit-post") 395 (hx-swap "outerHTML") (hx-post "xdo-edit")) 396 (input (@ (type "submit") (name "submit") (class lsub) (value "Edit"))) 397 (div (@ (class "form-body")) 398 ,(post-p-fragment id ptime mtime section title url comm-url tags) 399 ,@(let ((counts (domain-counts url))) 400 (if (and counts (positive? (+ (cadr counts) (caddr counts) -1))) 401 `((p "Entries and gruiks from " 402 (a (@ (href ,(conc "domains/" (car counts)))) 403 ,(car counts)) 404 ,(conc ": " (cadr counts) "+" (caddr counts)))) 405 '())) 406 (p (label "URL:" 407 (input (@ (type "url") (name "url") (value ,url))))) 408 ,(if (positive? id) 409 `(p ,(conc "Mark: " mark) 410 (label (input (@ (type radio) (name mark) (value 0))) "Unmark") 411 (label (input (@ (type radio) (name mark) (value 1) (checked))) 412 "Keep") 413 (label (input (@ (type radio) (name mark) (value 2))) "Lock") 414 (label (input (@ (type radio) (name mark) (value 3))) "Protect")) 415 `(p (label "Protected: " 416 (input (@ (type checkbox) (name protected) (value yes) 417 ,@(if (zero? mark) '() '((checked)))))))) 418 (pre (code ,notes)) 419 ,@(if (null? comm-url) 420 `((p (label (input (@ (type checkbox) (name retry-comm) (value y))) 421 "Retry fetching comment URL"))) 422 '()) 423 (p (label "Comment URL:" 424 (input (@ (type "url") (name "commenturl") (value ,comm-url))))) 425 (p (label "Append to notes:" 426 (textarea (@ (name "notes") (cols 80) (rows 5)) ""))) 427 (p (label "Description:" 428 (textarea (@ (name "description") (cols 80) (rows 12)) ,description))) 429 (fieldset (legend "Tags") 430 (details (@ (class tag-list)) (summary "Tags") 431 ,@(query 432 (map-rows* 433 (lambda (tid name checked) 434 `(label 435 (input (@ (type checkbox) (name tags) (value ,tid) 436 ,@(if (= 0 checked) '() '((checked))))) 437 ,name))) 438 (sql db 439 (if (positive? id) 440 "SELECT id,name, 441 EXISTS (SELECT * FROM gruik_tags 442 WHERE gruik_id=? AND tag_id = tag.id) 443 FROM tag;" 444 "SELECT id,name, 445 EXISTS (SELECT * FROM tagrel 446 WHERE url_id=? AND tag_id = tag.id) 447 FROM tag;")) 448 (abs id))))) 449 (input (@ (type "hidden") (name "id") (value ,id))) 450 (input (@ (type "submit") (name "submit") (class rsub) (value "Cancel"))))) 451 452 (define (edit-post-fragment* id) 453 (query 454 (map-rows* edit-post-fragment) 455 (sql db 456 (if (positive? id) 457 "SELECT gruik.id,ptime,mtime,section,title,url,comment_url,mark, 458 notes,description,group_concat('#'||name,' ') 459 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 460 LEFT OUTER JOIN tag ON tag_id=tag.id 461 WHERE gruik.id=? GROUP BY gruik.id;" 462 "SELECT -entry.id, 463 strftime('%Y.%m.%d %H:%M:%S', ctime, 'unixepoch') AS ptime, 464 mtime,COALESCE(source, 'Untracked Ien'), 465 COALESCE(title, ''), url, source_url, protected, 466 notes, description, group_concat('#'||name, ' ') 467 FROM entry LEFT OUTER JOIN tagrel ON url_id=entry.id 468 LEFT OUTER JOIN tag ON tag_id=tag.id 469 WHERE entry.id=? GROUP BY url_id;")) 470 (abs id))) 471 472 (define (db-edit) 473 (let ((id (string->number (required-input-var "id"))) 474 (comm-url (input-var "commenturl")) 475 (main-url (input-var "url")) 476 (retry-comm (input-var "retry-comm"))) 477 (when (string=? "Edit" (required-input-var "submit")) 478 (exec 479 (sql/transient db 480 (if (positive? id) 481 "UPDATE gruik SET mtime=?,notes=trim(notes||char(10)||?,char(10)), 482 description=?,mark=?,comment_url=?, 483 url=COALESCE(?,url) 484 WHERE (mark=1 OR mark=2) AND id=?;" 485 "UPDATE entry SET mtime=?,notes=trim(notes||char(10)||?,char(10)), 486 description=?,protected=?,source_url=?, 487 url=COALESCE(?,url) 488 WHERE protected=0 AND id=?;")) 489 (current-seconds) 490 (required-input-var "notes") 491 (if retry-comm "" (required-input-var "description")) 492 (if (positive? id) (string->number (required-input-var "mark")) 0) 493 (if (and comm-url (not (string=? comm-url ""))) comm-url '()) 494 (if (and main-url (not (string=? main-url ""))) main-url '()) 495 (abs id)) 496 (when retry-comm (auto-descr id)) 497 (let* ((n-tags (query fetch-value (sql db "SELECT MAX(id) FROM tag"))) 498 (tags (make-vector (+ 1 n-tags) 0)) 499 (add-tag (sql db 500 (if (positive? id) 501 "INSERT INTO gruik_tags(gruik_id,tag_id) 502 VALUES (?,?);" 503 "INSERT INTO tagrel(url_id,tag_id) 504 VALUES (?,?);"))) 505 (del-tag (sql db 506 (if (positive? id) 507 "DELETE FROM gruik_tags 508 WHERE gruik_id=? AND tag_id=?;" 509 "DELETE FROM tagrel 510 WHERE url_id=? AND tag_id=?;")))) 511 (let loop ((var input-list)) 512 (unless (null? var) 513 (when (string=? (caar var) "tags") 514 (vector-set! tags (string->number (cdar var)) 1)) 515 (loop (cdr var)))) 516 (query 517 (for-each-row* 518 (lambda (tid) (vector-set! tags tid (- (vector-ref tags tid) 1)))) 519 (sql db 520 (if (positive? id) 521 "SELECT tag_id FROM gruik_tags WHERE gruik_id=?;" 522 "SELECT tag_id FROM tagrel WHERE url_id=?;")) 523 (abs id)) 524 (let loop ((tid n-tags)) 525 (unless (= 0 tid) 526 (case (vector-ref tags tid) 527 ((1) (exec add-tag (abs id) tid)) 528 ((-1) (exec del-tag (abs id) tid))) 529 (loop (- tid 1)))))) 530 id)) 531 532 (define (post-fragment-id id) 533 (if (positive? id) (conc "post-" id) (conc "entry" id))) 534 535 (define (post-fragment id mark ptime mtime section title url comm-url tags . details) 536 (let* ((data (case mark 537 ((0) '("unmarked" "unmarked" "Mark" "Delete")) 538 ((1) '("marked" "marked" "Edit" "Unmark")) 539 ((2) '("locked" "locked" "Push" "Edit")) 540 ((3) '("locked" "protected" "Push" "Edit")) 541 ((10) '("ien" "locked" "Protect" "Edit")) 542 ((11) '("ien" "protected" #f "Unprotect")) 543 (else `("undelete" "bad" "Restore" ,(if (<= -5 mark 0) 544 "Hide" #f))))) 545 (action (car data)) 546 (class (cadr data)) 547 (llabel (caddr data)) 548 (rlabel (cadddr data))) 549 `(form (@ (method "POST") (action ,(conc "do-" action)) 550 (id ,(post-fragment-id id)) 551 (class ,(conc class "-post")) 552 (hx-swap "outerHTML") (hx-post ,(conc "xdo-" action))) 553 ,@(if (or llabel rlabel) 554 `((input (@ (type "hidden") (name "id") (value ,id)))) 555 '()) 556 ,@(if llabel 557 `((input (@ (type "submit") (name "submit") 558 (class lsub) (value ,llabel)))) 559 '()) 560 (div (@ (class "form-body")) 561 ,(post-p-fragment id ptime mtime section title url comm-url tags) 562 ,@(if (or (null? details) (string=? (car details) "")) 563 '() `((pre (code ,(car details)))))) 564 ,@(if rlabel 565 `(,@(if (<= -5 mark -1) 566 `((input (@ (type "hidden") (name "from") (value ,mark)))) 567 '()) 568 (input (@ (type "submit") (name "submit") 569 (class rsub) (value ,rlabel)))) 570 '())))) 571 572 (define (post-htmx id) 573 (htmx-output 574 (query 575 (map-rows* post-fragment) 576 (sql db 577 (if (positive? id) 578 "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 579 group_concat('#'||name,' ') 580 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 581 LEFT OUTER JOIN tag ON tag_id=tag.id 582 WHERE gruik.id=? GROUP BY gruik.id;" 583 "SELECT -entry.id,(CASE WHEN protected=0 THEN 10 ELSE 11 END), 584 strftime('%Y.%m.%d %H:%M:%S',ctime,'unixepoch') AS ptime, 585 mtime,COALESCE(source,'Untracked Ien'), 586 COALESCE(title,''),url,source_url, 587 group_concat('#'||name,' ') 588 FROM entry LEFT OUTER JOIN tagrel ON url_id=entry.id 589 LEFT OUTER JOIN tag ON tag_id=tag.id 590 WHERE entry.id=? GROUP BY entry.id;")) 591 (abs id)))) 592 593 (define (gruik-list-items row->fragment q args) 594 (let ((items (apply query (map-rows* row->fragment) (sql db q) args)) 595 (np (if (or (null? args) (null? (cdr args))) 596 #f 597 (let loop ((a (car args)) (b (cadr args)) (rest (cddr args))) 598 (if (null? rest) 599 (np-limit-offset a b) 600 (loop b (car rest) (cdr rest))))))) 601 (if (and np (or (> (cdr np) 1) (> (length items) (car np)))) 602 (let* ((n-part (if (= (car np) default-n) "" (conc "n=" (car np) "&"))) 603 (p-btn (lambda (cl p) 604 `(button (@ (type "submit") (class ,cl) 605 (name "p") (value ,p)) 606 ,(conc "Page " p)))) 607 (nav `(form (@ (method "GET")) 608 ,@(if (> (cdr np) 1) 609 (list (p-btn "lsub" (sub1 (cdr np)))) 610 '()) 611 (div (@ (class "form-body")) 612 ,@(if (= (car np) default-n) 613 '() 614 `((input (@ (type "hidden") (name "n") 615 (value ,(car np)))))) 616 (p (@ (style "text-align: center")) 617 ,(conc "Page " (cdr np)))) 618 ,@(if (> (length items) (car np)) 619 (list (p-btn "rsub" (add1 (cdr np)))) 620 '())))) 621 (append (list nav) items (list nav))) 622 items))) 623 (define (gruik-list-view title row->fragment footer q . args) 624 (html-output 625 `(html 626 (head 627 (base (@ (href ,(conc (get-config/default "gruik-prefix" "") "/")))) 628 (meta (@ (charset "utf-8"))) 629 (meta (@ (name "viewport") 630 (content "width=device-width, initial-scale=1"))) 631 (meta (@ (name "color-scheme") (content "light dark"))) 632 (title ,title) 633 (script (@ (src "https://cdn.jsdelivr.net/npm/htmx.org@2.0.8/dist/htmx.min.js")) "") 634 (script "\ 635 const beforeUnloadHandler = (event) => { 636 if (document.getElementsByClassName(\"edit-post\").length > 0) { 637 event.preventDefault(); 638 event.returnValue=true; 639 } 640 }; 641 window.addEventListener(\"beforeunload\", beforeUnloadHandler); 642 ") 643 (style ,css-style)) 644 (body 645 ,(spinner-symbol) 646 (h1 ,title) 647 (nav (ul 648 (li (a (@ (href "./")) "Latest gruiks")) 649 (li (a (@ (href "deleted")) "Deleted gruiks")) 650 (li (a (@ (href "search")) "Search forms")) 651 (li (a (@ (href "no-comm")) "Sourceless gruiks")))) 652 ,@(gruik-list-items row->fragment q args) 653 ,@footer)))) 654 655 (define (new-fragment) 656 (clean-up) 657 (let* ((last-id (string->number (required-input-var "last-id"))) 658 (last-time (string->number (required-input-var "last-time"))) 659 (n-new 0) 660 (n-upd 0) 661 (n-del 0) 662 (frags (query 663 (map-rows* 664 (lambda (id mark ptime mtime section title url comm-url tags) 665 (let ((base (post-fragment id mark ptime mtime section 666 title url comm-url tags))) 667 (cond 668 ((> id last-id) 669 (set! n-new (add1 n-new)) 670 base) 671 ((>= mark -5) 672 (set! n-upd (add1 n-upd)) 673 `(form (@ (hx-swap-oob "true") ,@(cdadr base)) 674 ,@(cddr base))) 675 (else 676 (set! n-del (add1 n-del)) 677 `(form (@ (hx-swap-oob "delete") 678 (id ,(post-fragment-id id))) 679 "")))))) 680 (sql db "SELECT gruik.id,mark,ptime,mtime,section,title,url, 681 comment_url,group_concat('#'||name,' ') 682 FROM gruik LEFT OUTER JOIN gruik_tags 683 ON gruik_id=gruik.id 684 LEFT OUTER JOIN tag ON tag_id=tag.id 685 WHERE mtime > ? AND (gruik.id <= ? OR mark >= -5) 686 GROUP BY gruik.id;") 687 last-time last-id)) 688 (btn (if (null? frags) "Recheck" "More"))) 689 (htmx-output 690 `(,@frags 691 (form (@ (method GET) (action "new") (id "load-new") 692 (hx-swap "outerHTML") (hx-post "x-new")) 693 ,@(if (positive? (+ n-new n-upd n-del)) 694 `((p (@ (class sidenote)) 695 ,(if (positive? n-new) (conc "+" n-new) "") 696 ,(if (positive? n-upd) (conc "~" n-upd) "") 697 ,(if (positive? n-del) (conc "−" n-del) ""))) 698 '()) 699 ,(spinner-ref) 700 (input (@ (type "hidden") (name "last-time") 701 (value ,(current-seconds)))) 702 (input (@ (type "hidden") (name "last-id") (value 703 ,(query fetch-value (sql db "SELECT MAX(id) FROM gruik;"))))) 704 (input (@ (type "submit") (name "submit") (value ,btn)))) 705 )))) 706 707 (define (new-view) 708 (redirect "/")) 709 710 (define (deleted-view limit-offset) 711 (clean-up) 712 (gruik-list-view 713 "Deleted gruiks" 714 post-fragment 715 '() 716 "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 717 group_concat('#'||name,' ') 718 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 719 LEFT OUTER JOIN tag ON tag_id=tag.id 720 WHERE mark < 0 GROUP BY gruik.id ORDER BY mtime DESC LIMIT ? OFFSET ?;" 721 (car limit-offset) 722 (cadr limit-offset))) 723 724 (define (edit-view id) 725 (let ((title (conc (if (positive? id) "Gruik #" "Ien #") (abs id)))) 726 (html-output 727 `(html 728 (head 729 (base (@ (href ,(conc (get-config/default "gruik-prefix" "") "/")))) 730 (meta (@ (charset "utf-8"))) 731 (meta (@ (name "viewport") 732 (content "width=device-width, initial-scale=1"))) 733 (meta (@ (name "color-scheme") (content "light dark"))) 734 (title ,title) 735 (script (@ (src "https://cdn.jsdelivr.net/npm/htmx.org@2.0.8/dist/htmx.min.js")) "") 736 (style ,css-style)) 737 (body 738 ,(spinner-symbol) 739 (h1 ,title) 740 ,@(edit-post-fragment* id)))))) 741 742 (define (feed-view id) 743 (let ((row (query fetch-row 744 (sql/transient db "SELECT mtime,title,url,selector 745 FROM feed WHERE id=?;") 746 id))) 747 (if (null? row) 748 (write-string "Status: 404\r\n\r\n") 749 (let ((mtime (car row)) 750 (title (cadr row)) 751 (self-url (caddr row)) 752 (selector (cadddr row))) 753 (write-string "Content-Type: application/atom+xml\r\n\r\n") 754 (write-feed mtime title self-url (feed-rows selector)))))) 755 756 (define (main-view) 757 (clean-up) 758 (gruik-list-view 759 "Latest gruiks" 760 post-fragment 761 `((form (@ (method GET) (action "new") (id "load-new") 762 (hx-swap "outerHTML") (hx-post "x-new")) 763 ,(spinner-ref) 764 (input (@ (type "hidden") (name "last-time") 765 (value ,(current-seconds)))) 766 (input (@ (type "hidden") (name "last-id") (value 767 ,(query fetch-value (sql db "SELECT MAX(id) FROM gruik;"))))) 768 (input (@ (type "submit") (name "submit") (value "Load"))))) 769 "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 770 group_concat('#'||name,' ') 771 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 772 LEFT OUTER JOIN tag ON tag_id=tag.id 773 WHERE mark >= -5 GROUP BY gruik.id;")) 774 775 (define (view-domain-search q limit-offset) 776 (gruik-list-view 777 (conc "Domain " q) 778 post-fragment 779 '() 780 "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 781 group_concat('#'||name,' '),COALESCE(description,notes) 782 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 783 LEFT OUTER JOIN tag ON tag_id=tag.id 784 WHERE instr(url,?1)>0 GROUP BY gruik.id 785 UNION ALL 786 SELECT -entry.id,(CASE WHEN protected=0 THEN 10 ELSE 11 END), 787 strftime('%Y.%m.%d %H:%M:%S',ctime,'unixepoch') AS ptime, 788 mtime,COALESCE(source,'Untracked Ien'), 789 COALESCE(title,''),url,source_url, 790 group_concat('#'||name,' '),COALESCE(description,notes) 791 FROM entry LEFT OUTER JOIN tagrel ON url_id=entry.id 792 LEFT OUTER JOIN tag ON tag_id=tag.id 793 WHERE instr(url,?1)>0 GROUP BY url_id 794 ORDER BY mtime DESC LIMIT ?2 OFFSET ?3" 795 (conc "://" q "/") 796 (car limit-offset) 797 (cadr limit-offset))) 798 799 (define (view-no-comm) 800 (clean-up) 801 (gruik-list-view 802 "Marked gruiks without comment URL" 803 post-fragment 804 '() 805 "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 806 group_concat('#'||name,' ') 807 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 808 LEFT OUTER JOIN tag ON tag_id=tag.id 809 WHERE mark >= 1 AND COALESCE(comment_url,'') = '' GROUP BY gruik.id;")) 810 811 (define (view-search) 812 (html-output 813 `(html 814 (head 815 (base (@ (href ,(conc (get-config/default "gruik-prefix" "") "/")))) 816 (meta (@ (charset "utf-8"))) 817 (meta (@ (name "viewport") 818 (content "width=device-width, initial-scale=1"))) 819 (meta (@ (name "color-scheme") (content "light dark"))) 820 (title "Search Forms") 821 (style ,css-style)) 822 (body 823 (h1 "Search Forms") 824 (nav (ul 825 (li (a (@ (href "./")) "Latest gruiks")) 826 (li (a (@ (href "deleted")) "Deleted gruiks")) 827 (li (a (@ (href "search")) "Search forms")) 828 (li (a (@ (href "no-comm")) "Sourceless gruiks")))) 829 (h2 "Any Field") 830 (form (@ (method "GET") (action "search")) 831 (div (@ (class "form-body")) 832 (input (@ (type "text") (name "glob") (placeholder "*glob*"))))) 833 (form (@ (method "GET") (action "search")) 834 (div (@ (class "form-body")) 835 (input (@ (type "text") (name "like") (placeholder "%like%"))))) 836 (form (@ (method "GET") (action "search")) 837 (div (@ (class "form-body")) 838 (input (@ (type "text") (name "regexp") 839 (placeholder "^reg.*exp$"))))) 840 (h2 "Description") 841 (form (@ (method "GET") (action "description")) 842 (div (@ (class "form-body")) 843 (input (@ (type "text") (name "glob") (placeholder "*glob*"))))) 844 (form (@ (method "GET") (action "description")) 845 (div (@ (class "form-body")) 846 (input (@ (type "text") (name "like") (placeholder "%like%"))))) 847 (form (@ (method "GET") (action "description")) 848 (div (@ (class "form-body")) 849 (input (@ (type "text") (name "regexp") 850 (placeholder "^reg.*exp$"))))) 851 (h2 "Notes") 852 (form (@ (method "GET") (action "notes")) 853 (div (@ (class "form-body")) 854 (input (@ (type "text") (name "glob") (placeholder "*glob*"))))) 855 (form (@ (method "GET") (action "notes")) 856 (div (@ (class "form-body")) 857 (input (@ (type "text") (name "like") (placeholder "%like%"))))) 858 (form (@ (method "GET") (action "notes")) 859 (div (@ (class "form-body")) 860 (input (@ (type "text") (name "regexp") 861 (placeholder "^reg.*exp$"))))) 862 (h2 "Title") 863 (form (@ (method "GET") (action "title")) 864 (div (@ (class "form-body")) 865 (input (@ (type "text") (name "glob") (placeholder "*glob*"))))) 866 (form (@ (method "GET") (action "title")) 867 (div (@ (class "form-body")) 868 (input (@ (type "text") (name "like") (placeholder "%like%"))))) 869 (form (@ (method "GET") (action "title")) 870 (div (@ (class "form-body")) 871 (input (@ (type "text") (name "regexp") 872 (placeholder "^reg.*exp$"))))) 873 (h2 "URL") 874 (form (@ (method "GET") (action "url")) 875 (div (@ (class "form-body")) 876 (input (@ (type "text") (name "glob") (placeholder "*glob*"))))) 877 (form (@ (method "GET") (action "url")) 878 (div (@ (class "form-body")) 879 (input (@ (type "text") (name "like") (placeholder "%like%"))))) 880 (form (@ (method "GET") (action "url")) 881 (div (@ (class "form-body")) 882 (input (@ (type "text") (name "regexp") 883 (placeholder "^reg.*exp$"))))))))) 884 885 (define (view-search-field fi op q mmark limit-offset) 886 (let ((title (if (string=? fi "any") 887 (conc "Gruiks " op " " q) 888 (conc "Gruiks with " fi " " op " " q))) 889 (wh-op (if (string=? fi "any") 890 (conc "(description " op " ?1 OR notes " op 891 " ?1 OR title " op " ?1 OR url " op " ?1)") 892 (conc fi " " op " ?1"))) 893 (wh-mm (conc " AND mark >= -" (if mmark mmark 0)))) 894 (gruik-list-view 895 title 896 post-fragment 897 '() 898 (conc "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 899 group_concat('#'||name,' '),COALESCE(description,notes) 900 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 901 LEFT OUTER JOIN tag ON tag_id=tag.id 902 WHERE " wh-op wh-mm " GROUP BY gruik.id 903 UNION ALL 904 SELECT -entry.id,(CASE WHEN protected=0 THEN 10 ELSE 11 END), 905 strftime('%Y-%m-%d %H:%M:%S',ctime,'unixepoch') AS ptime, 906 mtime,COALESCE(source,'Untracked Ien'), 907 COALESCE(title,''),url,source_url, 908 group_concat('#'||name,' '),COALESCE(description,notes) 909 FROM entry LEFT OUTER JOIN tagrel ON url_id=entry.id 910 LEFT OUTER JOIN tag ON tag_id=tag.id 911 WHERE " wh-op " GROUP BY url_id 912 ORDER BY mtime DESC LIMIT ?2 OFFSET ?3;") 913 q 914 (car limit-offset) 915 (cadr limit-offset)))) 916 917 (define (view-selection id limit-offset) 918 (let ((row (query fetch-row 919 (sql/transient db "SELECT name,text 920 FROM selector WHERE id=?;") 921 id))) 922 (if (null? row) 923 (write-string "Status: 404\r\n\r\n") 924 (gruik-list-view 925 (conc "Selection #" id ": " (car row)) 926 post-fragment 927 '() 928 (conc 929 "SELECT -entry.id,(CASE WHEN protected=0 THEN 10 ELSE 11 END), 930 strftime('%Y.%m.%d %H:%M:%S',ctime,'unixepoch') AS ptime, 931 mtime,COALESCE(source,'Untracked Ien'), 932 COALESCE(title,''),url,source_url, 933 group_concat('#'||name,' '),COALESCE(description,notes) 934 FROM entry LEFT OUTER JOIN tagrel ON url_id=entry.id 935 LEFT OUTER JOIN tag ON tag_id=tag.id " 936 (cadr row) 937 " GROUP BY url_id ORDER BY mtime DESC LIMIT ? OFFSET ?") 938 (car limit-offset) 939 (cadr limit-offset))))) 940 941 (define (view-tag tag limit-offset) 942 (let ((row (query fetch-row 943 (sql/transient db "SELECT id,name 944 FROM tag WHERE name=?;") 945 tag))) 946 (if (null? row) 947 (write-string "Status: 404\r\n\r\n") 948 (gruik-list-view 949 (conc "Tag " (cadr row)) 950 post-fragment 951 '() 952 "SELECT gruik.id,mark,ptime,mtime,section,title,url,comment_url, 953 group_concat('#'||name,' '),COALESCE(description,notes) 954 FROM gruik LEFT OUTER JOIN gruik_tags ON gruik_id=gruik.id 955 LEFT OUTER JOIN tag ON tag_id=tag.id 956 WHERE gruik.id IN (SELECT gruik_id FROM gruik_tags WHERE tag_id=?1) 957 GROUP BY gruik.id 958 UNION ALL 959 SELECT -entry.id,(CASE WHEN protected=0 THEN 10 ELSE 11 END), 960 strftime('%Y.%m.%d %H:%M:%S',ctime,'unixepoch') AS ptime, 961 mtime,COALESCE(source,'Untracked Ien'), 962 COALESCE(title,''),url,source_url, 963 group_concat('#'||name,' '),COALESCE(description,notes) 964 FROM entry LEFT OUTER JOIN tagrel ON url_id=entry.id 965 LEFT OUTER JOIN tag ON tag_id=tag.id 966 WHERE entry.id IN (SELECT url_id FROM tagrel WHERE tag_id=?1) 967 GROUP BY url_id ORDER BY mtime DESC LIMIT ?2 OFFSET ?3" 968 (car row) 969 (car limit-offset) 970 (cadr limit-offset))))) 971 972 (define (db-push-gruik id) 973 (with-transaction db 974 (lambda () 975 (exec 976 (sql db "INSERT INTO entry(url,type,description,notes, 977 title,source,source_url, 978 ctime,mtime,ptime,protected) 979 SELECT url, 980 CASE WHEN description IS NULL THEN NULL 981 WHEN substr(description,1,1)='<' THEN 'html' 982 WHEN substr(description,1,3)=' - ' 983 OR substr(description,1,3)=' + ' 984 THEN 'markdown-li' 985 ELSE 'text' END, 986 trim(description,char(10))||char(10), 987 trim(notes,char(10))||char(10), 988 title,section,comment_url, 989 stime,?, 990 CASE WHEN mark>=3 THEN ? ELSE NULL END, 991 CASE WHEN mark>=3 THEN 1 ELSE 0 END 992 FROM gruik 993 WHERE id=?;") 994 (current-seconds) 995 (current-seconds) 996 id) 997 (exec 998 (sql db "INSERT OR IGNORE INTO tagrel(url_id,tag_id) 999 SELECT entry.id,tag_id 1000 FROM gruik_tags LEFT OUTER JOIN gruik ON gruik_id=gruik.id 1001 LEFT OUTER JOIN entry ON gruik.url=entry.url 1002 WHERE gruik_id=?;") 1003 id) 1004 (db-set-mark id 2 -10) 1005 (db-set-mark id 3 -10))) 1006 (log-counts)) 1007 1008 (define (db-set-mark id old-v new-v) 1009 (exec (sql db "UPDATE gruik SET mtime=?, mark=?, stime=COALESCE(stime,?) 1010 WHERE mark=? AND id=?;") 1011 (current-seconds) 1012 new-v 1013 (if (= 1 new-v) (current-seconds) '()) 1014 old-v 1015 id)) 1016 1017 (define (db-set-protected id old-p new-p) 1018 (exec (sql db "UPDATE entry SET mtime=?, ptime=?, protected=? 1019 WHERE protected=? AND id=?;") 1020 (current-seconds) 1021 (if (zero? new-p) '() (current-seconds)) 1022 new-p 1023 old-p 1024 (- id))) 1025 1026 (define (db-sel-count id text name) 1027 (list id text name 1028 (query fetch-value 1029 (sql db (string-append "SELECT COUNT(id) FROM entry " text ";"))))) 1030 (define (db-sel-counts) 1031 (query (map-rows* db-sel-count) 1032 (sql db "SELECT id,text,name FROM selector ORDER BY id DESC;"))) 1033 (define (diff-sel-counts before after) 1034 (let loop ((rest-before before) (rest-after after) (acc '())) 1035 (cond 1036 ((and (null? rest-before) (null? rest-after)) acc) 1037 ((null? rest-before) 1038 (loop rest-before 1039 (cdr rest-after) 1040 (cons (list 0 (conc "extra after: " (cadar rest-after)) 0 0) 1041 acc))) 1042 ((null? rest-after) 1043 (loop (cdr rest-before) 1044 rest-after 1045 (cons (list 0 (conc "extra before: " (cadar rest-before)) 0 0) 1046 acc))) 1047 ((not (= (caar rest-before) (caar rest-after))) 1048 (loop (cdr rest-before) 1049 (cdr rest-after) 1050 (cons (list 0 1051 (conc "id mismatch: " 1052 (caar rest-before) " / " (caar rest-after)) 1053 0 0) 1054 acc))) 1055 ((not (string=? (cadar rest-before) (cadar rest-after))) 1056 (loop (cdr rest-before) 1057 (cdr rest-after) 1058 (cons (list 0 1059 (conc "text mismatch: " 1060 (cadar rest-before) " / " (cadar rest-after)) 1061 0 0) 1062 acc))) 1063 ((not (string=? (caddar rest-before) (caddar rest-after))) 1064 (loop (cdr rest-before) 1065 (cdr rest-after) 1066 (cons (list 0 1067 (conc "name mismatch: " 1068 (caddar rest-before) " / " (caddar rest-after)) 1069 0 0) 1070 acc))) 1071 (else 1072 (let ((n-before (car (cdddar rest-before))) 1073 (n-after (car (cdddar rest-after)))) 1074 (loop (cdr rest-before) 1075 (cdr rest-after) 1076 (if (= n-before n-after) 1077 acc 1078 (cons (list (caar rest-before) 1079 (cadar rest-before) 1080 (caddar rest-before) 1081 n-after 1082 (- n-after n-before)) 1083 acc)))))))) 1084 (define (fragment-diff-sel-counts before after) 1085 (let ((diff (diff-sel-counts before after))) 1086 (if (null? diff) '() 1087 `((table 1088 ,@(map (lambda (line) 1089 `(tr (td (a (@ (href ,(conc "selection/" (car line)))) 1090 ,(conc "Selection #" (car line)))) 1091 (td (@ (title ,(list-ref line 1))) ,(list-ref line 2)) 1092 (td ,(->string (list-ref line 3))) 1093 (td ,(conc (if (positive? (list-ref line 4)) "(+" "(") 1094 (list-ref line 4) ")")))) 1095 diff)))))) 1096 1097 (define (feed-sig-base) 1098 (query (map-rows (lambda (row) (append row (build-signature (caddr row))))) 1099 (sql db "SELECT id,title,selector FROM feed WHERE active=1;"))) 1100 (define (linked-ien n) 1101 `(a (@ (href ,(conc "ien/" n))) ,(conc "item #" n))) 1102 (define (fragment-sig-diff id title diff) 1103 `((p ,(conc "Feed #" id ": " title)) 1104 (ul ,@(map (lambda (hunk) (cond 1105 ((eqv? (car hunk) 'add) 1106 `(li "added " ,(linked-ien (cadr hunk)) 1107 ,(conc " at " (rfc-3339 (caddr hunk))))) 1108 ((eqv? (car hunk) 'del) 1109 `(li "removed " ,(linked-ien (cadr hunk)) 1110 ,(conc " at " (rfc-3339 (caddr hunk))))) 1111 ((eqv? (car hunk) 'chg) 1112 `(li "updated " ,(linked-ien (cadr hunk)) 1113 ,(conc " from " (rfc-3339 (caddr hunk)) 1114 " to " (rfc-3339 (cadddr hunk))))) 1115 (else `(li ,(conc "malformed hunk: " hunk))))) 1116 diff)))) 1117 (define (update-feed id) 1118 (exec (sql/transient db "UPDATE feed SET mtime=? WHERE id=?;") 1119 (current-seconds) 1120 id) 1121 (query (for-each-row* 1122 (lambda (filename mtime title self-url selector) 1123 (let ((rows (feed-rows selector))) 1124 (unless (null? rows) 1125 (with-output-to-file (string-append feed-root filename) 1126 (lambda () 1127 (write-feed 1128 (if (null? mtime) (list-ref (car rows) 7) mtime) 1129 title 1130 self-url 1131 rows))))))) 1132 (sql/transient db 1133 "SELECT filename,mtime,title,url,selector FROM feed WHERE id=?;") 1134 id)) 1135 (define (fragment-diff-feed* base-sig) 1136 (let ((id (car base-sig)) 1137 (title (cadr base-sig)) 1138 (selector (caddr base-sig)) 1139 (old-sig (cdddr base-sig))) 1140 (let ((diff (diff-signature old-sig (build-signature selector)))) 1141 (if (null? diff) 1142 '() 1143 (begin 1144 (update-feed id) 1145 (fragment-sig-diff id title diff)))))) 1146 (define (fragment-diff-feed base-sigs) 1147 (join (map fragment-diff-feed* base-sigs))) 1148 1149 (define (fragment-push-report frag-diff-sel frag-diff-sig) 1150 (if (and (null? frag-diff-sel) (null? frag-diff-sig)) 1151 '() 1152 `(form 1153 (div (@ (class "form-body")) ,@frag-diff-sel ,@frag-diff-sig) 1154 (button (@ (class rsub) (onclick "this.closest('form').remove()")) 1155 "Dismiss")))) 1156 1157 (define (htmx-push-gruik id) 1158 (let ((before (db-sel-counts)) 1159 (base-sigs (feed-sig-base))) 1160 (db-push-gruik id) 1161 (htmx-output 1162 (fragment-push-report 1163 (fragment-diff-sel-counts before (db-sel-counts)) 1164 (fragment-diff-feed base-sigs))))) 1165 1166 (define (xdo-edit) 1167 (let ((id (db-edit))) 1168 (post-htmx id))) 1169 1170 (define (do-ien htmx?) 1171 (let ((id (string->number (required-input-var "id"))) 1172 (submit (required-input-var "submit"))) 1173 (cond 1174 ((positive? id) (bad-input "bad value for id")) 1175 ((string=? submit "Edit") 1176 (if htmx? (htmx-output (edit-post-fragment* id)) 1177 (redirect (conc "/ien/" (- id))))) 1178 ((string=? submit "Protect") 1179 (db-set-protected id 0 1) 1180 (if htmx? (post-htmx id) 1181 (redirect (conc "/ien/" (- id))))) 1182 ((string=? submit "Unprotect") 1183 (db-set-protected id 1 0) 1184 (if htmx? (post-htmx id) 1185 (redirect (conc "/ien/" (- id))))) 1186 (else (bad-input "bad value for submit"))))) 1187 1188 (define (do-locked htmx?) 1189 (let ((id (string->number (required-input-var "id"))) 1190 (submit (required-input-var "submit"))) 1191 (cond 1192 ((string=? submit "Push") 1193 (if htmx? (htmx-push-gruik id) 1194 (begin (db-push-gruik id) (redirect "/")))) 1195 ((string=? submit "Edit") 1196 (if htmx? (htmx-output (edit-post-fragment* id)) 1197 (redirect (conc "/gruik/" id)))) 1198 (else (bad-input "bad value for submit"))))) 1199 1200 (define (do-marked htmx?) 1201 (let ((id (string->number (required-input-var "id"))) 1202 (submit (required-input-var "submit"))) 1203 (cond 1204 ((string=? submit "Edit") 1205 (if htmx? (htmx-output (edit-post-fragment* id)) 1206 (redirect (conc "/gruik/" id)))) 1207 ((string=? submit "Unmark") 1208 (db-set-mark id 1 0) 1209 (log-counts) 1210 (if htmx? (post-htmx id) (redirect "/"))) 1211 (else (bad-input "bad value for submit"))))) 1212 1213 (define (do-undelete htmx?) 1214 (let ((id (string->number (required-input-var "id"))) 1215 (oldmark (string->number (optional-input-var "from" ""))) 1216 (submit (required-input-var "submit"))) 1217 (cond 1218 ((and oldmark (<= -5 oldmark -1)) 1219 (cond 1220 ((string=? submit "Restore") 1221 (db-set-mark id oldmark 0) 1222 (if htmx? (post-htmx id) 1223 (redirect (conc "/gruik/" id)))) 1224 ((string=? submit "Hide") 1225 (db-set-mark id oldmark -10) 1226 (if htmx? (htmx-output '()) (redirect "/"))) 1227 (else (bad-input "bad value for submit")))) 1228 ((string=? submit "Restore") 1229 (db-set-mark id -10 0) 1230 (if htmx? (htmx-output '()) (redirect "/"))) 1231 (else (bad-input "bad value for submit"))))) 1232 1233 (define (do-unmarked htmx?) 1234 (let ((id (string->number (required-input-var "id"))) 1235 (submit (required-input-var "submit"))) 1236 (cond 1237 ((string=? submit "Mark") 1238 (db-set-mark id 0 1) 1239 (log-counts) 1240 (auto-descr id) 1241 (if htmx? (post-htmx id) (redirect "/"))) 1242 ((string=? submit "Delete") 1243 (db-set-mark id 0 -10) 1244 (if htmx? (htmx-output '()) (redirect "/"))) 1245 (else (bad-input "bad value for submit"))))) 1246 1247 (define route-xdo-edit 1248 (preceded-by (any-of (char-seq "xdo-edit") 1249 (char-seq "gruik/xdo-edit") 1250 (char-seq "ien/xdo-edit")) 1251 (result xdo-edit))) 1252 (define route-do-ien 1253 (sequence* ((x? (maybe (is #\x))) 1254 (_ (char-seq "do-ien"))) 1255 (result (lambda () (do-ien x?))))) 1256 (define route-do-locked 1257 (sequence* ((x? (maybe (is #\x))) 1258 (_ (char-seq "do-locked"))) 1259 (result (lambda () (do-locked x?))))) 1260 (define route-do-marked 1261 (sequence* ((x? (maybe (is #\x))) 1262 (_ (char-seq "do-marked"))) 1263 (result (lambda () (do-marked x?))))) 1264 (define route-do-undelete 1265 (sequence* ((x? (maybe (is #\x))) 1266 (_ (char-seq "do-undelete"))) 1267 (result (lambda () (do-undelete x?))))) 1268 (define route-do-unmarked 1269 (sequence* ((x? (maybe (is #\x))) 1270 (_ (char-seq "do-unmarked"))) 1271 (result (lambda () (do-unmarked x?))))) 1272 (define route-deleted 1273 (sequence* ((_ (char-seq "deleted")) 1274 (lo url-query)) 1275 (result (lambda () (deleted-view (q-limit-offset lo)))))) 1276 (define route-feed 1277 (sequence* ((_ (char-seq "feed/")) 1278 (id (as-string parse-number)) 1279 (_ (char-seq ".atom"))) 1280 (result (lambda () (feed-view (string->number id)))))) 1281 (define route-new 1282 (preceded-by (char-seq "new") 1283 (result new-view))) 1284 (define route-x-new 1285 (preceded-by (char-seq "x-new") 1286 (result new-fragment))) 1287 (define route-no-comm 1288 (preceded-by (char-seq "no-comm") 1289 (result view-no-comm))) 1290 (define route-search 1291 (preceded-by (char-seq "search") 1292 (result view-search))) 1293 (define route-search-any-field 1294 (sequence* ((_ (char-seq "search?")) 1295 (op (any-of (char-seq "glob") 1296 (char-seq "like") 1297 (char-seq "regexp"))) 1298 (_ (is #\=)) 1299 (q url-value) 1300 (m (maybe 1301 (as-string (preceded-by (char-seq "&m=") parse-number)))) 1302 (lo url-extra-query)) 1303 (result (lambda () (view-search-field "any" op q m (q-limit-offset lo)))))) 1304 (define route-search-domain 1305 (sequence* ((_ (char-seq "domains/")) 1306 (q (as-string (repeated item))) 1307 (lo url-query)) 1308 (result (lambda () (view-domain-search q (q-limit-offset lo)))))) 1309 (define route-search-field 1310 (sequence* ((fi (any-of (char-seq "description") 1311 (char-seq "notes") 1312 (char-seq "title") 1313 (char-seq "url"))) 1314 (_ (is #\?)) 1315 (op (any-of (char-seq "glob") 1316 (char-seq "like") 1317 (char-seq "regexp"))) 1318 (_ (is #\=)) 1319 (q url-value) 1320 (m (maybe 1321 (as-string (preceded-by (char-seq "&m=") parse-number)))) 1322 (lo url-extra-query)) 1323 (result (lambda () (view-search-field fi op q m (q-limit-offset lo)))))) 1324 (define route-selection 1325 (sequence* ((_ (char-seq "selection/")) 1326 (id (as-string parse-number)) 1327 (lo url-query)) 1328 (result (lambda () (view-selection (string->number id) 1329 (q-limit-offset lo)))))) 1330 (define route-tag 1331 (sequence* ((_ (char-seq "tag/")) 1332 (tag (as-string (repeated item until: (is #\?)))) 1333 (q url-query)) 1334 (result (lambda () (view-tag tag (q-limit-offset q)))))) 1335 (define route-edit-gruik 1336 (sequence* ((_ (char-seq "gruik/")) 1337 (id (as-string parse-number))) 1338 (result (lambda () (edit-view (string->number id)))))) 1339 (define route-edit-ien 1340 (sequence* ((_ (char-seq "ien/")) 1341 (id (as-string parse-number))) 1342 (result (lambda () (edit-view (- (string->number id))))))) 1343 (define route-main (result main-view)) 1344 (define route-ok 1345 (preceded-by (char-seq "ok") 1346 (result (lambda () 1347 (write-string "Content-Type: text/plain\r\n\r\nOK\n"))))) 1348 1349 (define router 1350 (preceded-by (char-seq (get-config/default "gruik-prefix" "")) 1351 (is #\/) 1352 (apply any-of 1353 (map (lambda (p) (followed-by p end-of-input)) 1354 (list route-do-ien 1355 route-do-locked 1356 route-do-marked 1357 route-do-undelete 1358 route-do-unmarked 1359 route-xdo-edit 1360 route-deleted 1361 route-edit-gruik 1362 route-edit-ien 1363 route-feed 1364 route-main 1365 route-ok 1366 route-new 1367 route-no-comm 1368 route-search 1369 route-search-any-field 1370 route-search-domain 1371 route-search-field 1372 route-selection 1373 route-tag 1374 route-x-new))))) 1375 1376 (let* ((uri (get-environment-variable "REQUEST_URI")) 1377 (_ (if uri uri (die "Missing $REQUEST_URI"))) 1378 (fn (parse router uri))) 1379 (if fn 1380 (fn) 1381 (debug-output)))