database.go (view raw)
1//
2// Copyright (c) 2019 Ted Unangst <tedu@tedunangst.com>
3//
4// Permission to use, copy, modify, and distribute this software for any
5// purpose with or without fee is hereby granted, provided that the above
6// copyright notice and this permission notice appear in all copies.
7//
8// THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
9// WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
10// MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
11// ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
12// WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
13// ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
14// OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
15
16package main
17
18import (
19 "bytes"
20 "crypto/sha512"
21 "database/sql"
22 "encoding/json"
23 _ "embed"
24 "fmt"
25 "html/template"
26 "sort"
27 "strconv"
28 "strings"
29 "sync"
30 "time"
31
32 "humungus.tedunangst.com/r/webs/cache"
33 "humungus.tedunangst.com/r/webs/httpsig"
34 "humungus.tedunangst.com/r/webs/login"
35 "humungus.tedunangst.com/r/webs/mz"
36)
37
38//go:embed schema.sql
39var sqlSchema string
40
41func userfromrow(row *sql.Row) (*WhatAbout, error) {
42 user := new(WhatAbout)
43 var seckey, options string
44 err := row.Scan(&user.ID, &user.Name, &user.Display, &user.About, &user.Key, &seckey, &options)
45 if err == nil {
46 user.SecKey, _, err = httpsig.DecodeKey(seckey)
47 }
48 if err != nil {
49 return nil, err
50 }
51 if user.ID > 0 {
52 user.URL = fmt.Sprintf("https://%s/%s/%s", serverName, userSep, user.Name)
53 err = unjsonify(options, &user.Options)
54 if err != nil {
55 elog.Printf("error processing user options: %s", err)
56 }
57 } else {
58 user.URL = fmt.Sprintf("https://%s/%s", serverName, user.Name)
59 }
60 if user.Options.Reaction == "" {
61 user.Options.Reaction = "none"
62 }
63
64 return user, nil
65}
66
67var somenamedusers = cache.New(cache.Options{Filler: func(name string) (*WhatAbout, bool) {
68 row := stmtUserByName.QueryRow(name)
69 user, err := userfromrow(row)
70 if err != nil {
71 return nil, false
72 }
73 var marker mz.Marker
74 marker.HashLinker = ontoreplacer
75 marker.AtLinker = attoreplacer
76 user.HTAbout = template.HTML(marker.Mark(user.About))
77 user.Onts = marker.HashTags
78 return user, true
79}})
80
81var somenumberedusers = cache.New(cache.Options{Filler: func(userid int64) (*WhatAbout, bool) {
82 row := stmtUserByNumber.QueryRow(userid)
83 user, err := userfromrow(row)
84 if err != nil {
85 return nil, false
86 }
87 // don't touch attoreplacer, which introduces a loop
88 // finger -> getjunk -> keys -> users
89 return user, true
90}})
91
92func getserveruser() *WhatAbout {
93 var user *WhatAbout
94 ok := somenumberedusers.Get(serverUID, &user)
95 if !ok {
96 elog.Panicf("lost server user")
97 }
98 return user
99}
100
101func butwhatabout(name string) (*WhatAbout, error) {
102 var user *WhatAbout
103 ok := somenamedusers.Get(name, &user)
104 if !ok {
105 return nil, fmt.Errorf("no user: %s", name)
106 }
107 return user, nil
108}
109
110var honkerinvalidator cache.Invalidator
111
112func gethonkers(userid int64) []*Honker {
113 rows, err := stmtHonkers.Query(userid)
114 if err != nil {
115 elog.Printf("error querying honkers: %s", err)
116 return nil
117 }
118 defer rows.Close()
119 var honkers []*Honker
120 for rows.Next() {
121 h := new(Honker)
122 var combos, meta string
123 err = rows.Scan(&h.ID, &h.UserID, &h.Name, &h.XID, &h.Flavor, &combos, &meta)
124 if err == nil {
125 err = unjsonify(meta, &h.Meta)
126 }
127 if err != nil {
128 elog.Printf("error scanning honker: %s", err)
129 continue
130 }
131 h.Combos = strings.Split(strings.TrimSpace(combos), " ")
132 honkers = append(honkers, h)
133 }
134 return honkers
135}
136
137func getdubs(userid int64) []*Honker {
138 rows, err := stmtDubbers.Query(userid)
139 return dubsfromrows(rows, err)
140}
141
142func getnameddubs(userid int64, name string) []*Honker {
143 rows, err := stmtNamedDubbers.Query(userid, name)
144 return dubsfromrows(rows, err)
145}
146
147func dubsfromrows(rows *sql.Rows, err error) []*Honker {
148 if err != nil {
149 elog.Printf("error querying dubs: %s", err)
150 return nil
151 }
152 defer rows.Close()
153 var honkers []*Honker
154 for rows.Next() {
155 h := new(Honker)
156 err = rows.Scan(&h.ID, &h.UserID, &h.Name, &h.XID, &h.Flavor)
157 if err != nil {
158 elog.Printf("error scanning honker: %s", err)
159 return nil
160 }
161 honkers = append(honkers, h)
162 }
163 return honkers
164}
165
166func allusers() []login.UserInfo {
167 var users []login.UserInfo
168 rows, _ := opendatabase().Query("select userid, username from users where userid > 0")
169 defer rows.Close()
170 for rows.Next() {
171 var u login.UserInfo
172 rows.Scan(&u.UserID, &u.Username)
173 users = append(users, u)
174 }
175 return users
176}
177
178func getxonk(userid int64, xid string) *Honk {
179 row := stmtOneXonk.QueryRow(userid, xid)
180 return scanhonk(row)
181}
182
183func getbonk(userid int64, xid string) *Honk {
184 row := stmtOneBonk.QueryRow(userid, xid)
185 return scanhonk(row)
186}
187
188func getpublichonks() []*Honk {
189 dt := time.Now().Add(-7 * 24 * time.Hour).UTC().Format(dbtimeformat)
190 rows, err := stmtPublicHonks.Query(dt, 100)
191 return getsomehonks(rows, err)
192}
193func geteventhonks(userid int64) []*Honk {
194 rows, err := stmtEventHonks.Query(userid, 25)
195 honks := getsomehonks(rows, err)
196 sort.Slice(honks, func(i, j int) bool {
197 var t1, t2 time.Time
198 if honks[i].Time == nil {
199 t1 = honks[i].Date
200 } else {
201 t1 = honks[i].Time.StartTime
202 }
203 if honks[j].Time == nil {
204 t2 = honks[j].Date
205 } else {
206 t2 = honks[j].Time.StartTime
207 }
208 return t1.After(t2)
209 })
210 now := time.Now().Add(-24 * time.Hour)
211 for i, h := range honks {
212 t := h.Date
213 if tm := h.Time; tm != nil {
214 t = tm.StartTime
215 }
216 if t.Before(now) {
217 honks = honks[:i]
218 break
219 }
220 }
221 reversehonks(honks)
222 return honks
223}
224func gethonksbyuser(name string, includeprivate bool, wanted int64) []*Honk {
225 dt := time.Now().Add(-7 * 24 * time.Hour).UTC().Format(dbtimeformat)
226 limit := 50
227 whofore := 2
228 if includeprivate {
229 whofore = 3
230 }
231 rows, err := stmtUserHonks.Query(wanted, whofore, name, dt, limit)
232 return getsomehonks(rows, err)
233}
234func gethonksforuser(userid int64, wanted int64) []*Honk {
235 dt := time.Now().Add(-7 * 24 * time.Hour).UTC().Format(dbtimeformat)
236 rows, err := stmtHonksForUser.Query(wanted, userid, dt, userid, userid)
237 return getsomehonks(rows, err)
238}
239func gethonksforuserfirstclass(userid int64, wanted int64) []*Honk {
240 dt := time.Now().Add(-7 * 24 * time.Hour).UTC().Format(dbtimeformat)
241 rows, err := stmtHonksForUserFirstClass.Query(wanted, userid, dt, userid, userid)
242 return getsomehonks(rows, err)
243}
244
245func gethonksforme(userid int64, wanted int64) []*Honk {
246 dt := time.Now().Add(-7 * 24 * time.Hour).UTC().Format(dbtimeformat)
247 rows, err := stmtHonksForMe.Query(wanted, userid, dt, userid)
248 return getsomehonks(rows, err)
249}
250func gethonksfromlongago(userid int64, wanted int64) []*Honk {
251 now := time.Now()
252 var honks []*Honk
253 for i := 1; i <= 3; i++ {
254 dt := time.Date(now.Year()-i, now.Month(), now.Day(), now.Hour(), now.Minute(),
255 now.Second(), 0, now.Location())
256 dt1 := dt.Add(-36 * time.Hour).UTC().Format(dbtimeformat)
257 dt2 := dt.Add(12 * time.Hour).UTC().Format(dbtimeformat)
258 rows, err := stmtHonksFromLongAgo.Query(wanted, userid, dt1, dt2, userid)
259 honks = append(honks, getsomehonks(rows, err)...)
260 }
261 return honks
262}
263func getsavedhonks(userid int64, wanted int64) []*Honk {
264 rows, err := stmtHonksISaved.Query(wanted, userid)
265 return getsomehonks(rows, err)
266}
267func gethonksbyhonker(userid int64, honker string, wanted int64) []*Honk {
268 rows, err := stmtHonksByHonker.Query(wanted, userid, honker, userid)
269 return getsomehonks(rows, err)
270}
271func gethonksbyxonker(userid int64, xonker string, wanted int64) []*Honk {
272 rows, err := stmtHonksByXonker.Query(wanted, userid, xonker, xonker, userid)
273 return getsomehonks(rows, err)
274}
275func gethonksbycombo(userid int64, combo string, wanted int64) []*Honk {
276 combo = "% " + combo + " %"
277 rows, err := stmtHonksByCombo.Query(wanted, userid, userid, combo, userid, wanted, userid, combo, userid)
278 return getsomehonks(rows, err)
279}
280func gethonksbyconvoy(userid int64, convoy string, wanted int64) []*Honk {
281 rows, err := stmtHonksByConvoy.Query(wanted, userid, userid, convoy)
282 honks := getsomehonks(rows, err)
283 return honks
284}
285func gethonksbysearch(userid int64, q string, wanted int64) []*Honk {
286 var queries []string
287 var params []interface{}
288 queries = append(queries, "honks.honkid > ?")
289 params = append(params, wanted)
290 queries = append(queries, "honks.userid = ?")
291 params = append(params, userid)
292
293 terms := strings.Split(q, " ")
294 for _, t := range terms {
295 if t == "" {
296 continue
297 }
298 negate := " "
299 if t[0] == '-' {
300 t = t[1:]
301 negate = " not "
302 }
303 if t == "" {
304 continue
305 }
306 if strings.HasPrefix(t, "site:") {
307 site := t[5:]
308 site = "%" + site + "%"
309 queries = append(queries, "xid"+negate+"like ?")
310 params = append(params, site)
311 continue
312 }
313 if strings.HasPrefix(t, "honker:") {
314 honker := t[7:]
315 xid := fullname(honker, userid)
316 if xid != "" {
317 honker = xid
318 }
319 queries = append(queries, negate+"(honks.honker = ? or honks.oonker = ?)")
320 params = append(params, honker)
321 params = append(params, honker)
322 continue
323 }
324 t = "%" + t + "%"
325 queries = append(queries, "noise"+negate+"like ?")
326 params = append(params, t)
327 }
328
329 selecthonks := "select honks.honkid, honks.userid, username, what, honker, oonker, honks.xid, rid, dt, url, audience, noise, precis, format, convoy, whofore, flags from honks join users on honks.userid = users.userid "
330 where := "where " + strings.Join(queries, " and ")
331 butnotthose := " and convoy not in (select name from zonkers where userid = ? and wherefore = 'zonvoy' order by zonkerid desc limit 100)"
332 limit := " order by honks.honkid desc limit 250"
333 params = append(params, userid)
334 rows, err := opendatabase().Query(selecthonks+where+butnotthose+limit, params...)
335 honks := getsomehonks(rows, err)
336 return honks
337}
338func gethonksbyontology(userid int64, name string, wanted int64) []*Honk {
339 rows, err := stmtHonksByOntology.Query(wanted, name, userid, userid)
340 honks := getsomehonks(rows, err)
341 return honks
342}
343
344func reversehonks(honks []*Honk) {
345 for i, j := 0, len(honks)-1; i < j; i, j = i+1, j-1 {
346 honks[i], honks[j] = honks[j], honks[i]
347 }
348}
349
350func getsomehonks(rows *sql.Rows, err error) []*Honk {
351 if err != nil {
352 elog.Printf("error querying honks: %s", err)
353 return nil
354 }
355 defer rows.Close()
356 var honks []*Honk
357 for rows.Next() {
358 h := scanhonk(rows)
359 if h != nil {
360 honks = append(honks, h)
361 }
362 }
363 rows.Close()
364 donksforhonks(honks)
365 return honks
366}
367
368type RowLike interface {
369 Scan(dest ...interface{}) error
370}
371
372func scanhonk(row RowLike) *Honk {
373 h := new(Honk)
374 var dt, aud string
375 err := row.Scan(&h.ID, &h.UserID, &h.Username, &h.What, &h.Honker, &h.Oonker, &h.XID, &h.RID,
376 &dt, &h.URL, &aud, &h.Noise, &h.Precis, &h.Format, &h.Convoy, &h.Whofore, &h.Flags)
377 if err != nil {
378 if err != sql.ErrNoRows {
379 elog.Printf("error scanning honk: %s", err)
380 }
381 return nil
382 }
383 h.Date, _ = time.Parse(dbtimeformat, dt)
384 h.Audience = strings.Split(aud, " ")
385 h.Public = loudandproud(h.Audience)
386 return h
387}
388
389func donksforhonks(honks []*Honk) {
390 db := opendatabase()
391 var ids []string
392 hmap := make(map[int64]*Honk)
393 for _, h := range honks {
394 ids = append(ids, fmt.Sprintf("%d", h.ID))
395 hmap[h.ID] = h
396 }
397 idset := strings.Join(ids, ",")
398 // grab donks
399 q := fmt.Sprintf("select honkid, donks.fileid, xid, name, description, url, media, local from donks join filemeta on donks.fileid = filemeta.fileid where honkid in (%s)", idset)
400 rows, err := db.Query(q)
401 if err != nil {
402 elog.Printf("error querying donks: %s", err)
403 return
404 }
405 defer rows.Close()
406 for rows.Next() {
407 var hid int64
408 d := new(Donk)
409 err = rows.Scan(&hid, &d.FileID, &d.XID, &d.Name, &d.Desc, &d.URL, &d.Media, &d.Local)
410 if err != nil {
411 elog.Printf("error scanning donk: %s", err)
412 continue
413 }
414 d.External = !strings.HasPrefix(d.URL, serverPrefix)
415 h := hmap[hid]
416 h.Donks = append(h.Donks, d)
417 }
418 rows.Close()
419
420 // grab onts
421 q = fmt.Sprintf("select honkid, ontology from onts where honkid in (%s)", idset)
422 rows, err = db.Query(q)
423 if err != nil {
424 elog.Printf("error querying onts: %s", err)
425 return
426 }
427 defer rows.Close()
428 for rows.Next() {
429 var hid int64
430 var o string
431 err = rows.Scan(&hid, &o)
432 if err != nil {
433 elog.Printf("error scanning donk: %s", err)
434 continue
435 }
436 h := hmap[hid]
437 h.Onts = append(h.Onts, o)
438 }
439 rows.Close()
440
441 // grab meta
442 q = fmt.Sprintf("select honkid, genus, json from honkmeta where honkid in (%s)", idset)
443 rows, err = db.Query(q)
444 if err != nil {
445 elog.Printf("error querying honkmeta: %s", err)
446 return
447 }
448 defer rows.Close()
449 for rows.Next() {
450 var hid int64
451 var genus, j string
452 err = rows.Scan(&hid, &genus, &j)
453 if err != nil {
454 elog.Printf("error scanning honkmeta: %s", err)
455 continue
456 }
457 h := hmap[hid]
458 switch genus {
459 case "place":
460 p := new(Place)
461 err = unjsonify(j, p)
462 if err != nil {
463 elog.Printf("error parsing place: %s", err)
464 continue
465 }
466 h.Place = p
467 case "time":
468 t := new(Time)
469 err = unjsonify(j, t)
470 if err != nil {
471 elog.Printf("error parsing time: %s", err)
472 continue
473 }
474 h.Time = t
475 case "mentions":
476 err = unjsonify(j, &h.Mentions)
477 if err != nil {
478 elog.Printf("error parsing mentions: %s", err)
479 continue
480 }
481 case "badonks":
482 err = unjsonify(j, &h.Badonks)
483 if err != nil {
484 elog.Printf("error parsing badonks: %s", err)
485 continue
486 }
487 case "wonkles":
488 h.Wonkles = j
489 case "guesses":
490 h.Guesses = template.HTML(j)
491 case "oldrev":
492 default:
493 elog.Printf("unknown meta genus: %s", genus)
494 }
495 }
496 rows.Close()
497}
498
499func donksforchonks(chonks []*Chonk) {
500 db := opendatabase()
501 var ids []string
502 chmap := make(map[int64]*Chonk)
503 for _, ch := range chonks {
504 ids = append(ids, fmt.Sprintf("%d", ch.ID))
505 chmap[ch.ID] = ch
506 }
507 idset := strings.Join(ids, ",")
508 // grab donks
509 q := fmt.Sprintf("select chonkid, donks.fileid, xid, name, description, url, media, local from donks join filemeta on donks.fileid = filemeta.fileid where chonkid in (%s)", idset)
510 rows, err := db.Query(q)
511 if err != nil {
512 elog.Printf("error querying donks: %s", err)
513 return
514 }
515 defer rows.Close()
516 for rows.Next() {
517 var chid int64
518 d := new(Donk)
519 err = rows.Scan(&chid, &d.FileID, &d.XID, &d.Name, &d.Desc, &d.URL, &d.Media, &d.Local)
520 if err != nil {
521 elog.Printf("error scanning donk: %s", err)
522 continue
523 }
524 ch := chmap[chid]
525 ch.Donks = append(ch.Donks, d)
526 }
527}
528
529func savefile(name string, desc string, url string, media string, local bool, data []byte) (int64, error) {
530 fileid, _, err := savefileandxid(name, desc, url, media, local, data)
531 return fileid, err
532}
533
534func hashfiledata(data []byte) string {
535 h := sha512.New512_256()
536 h.Write(data)
537 return fmt.Sprintf("%x", h.Sum(nil))
538}
539
540func savefileandxid(name string, desc string, url string, media string, local bool, data []byte) (int64, string, error) {
541 var xid string
542 if local {
543 hash := hashfiledata(data)
544 row := stmtCheckFileData.QueryRow(hash)
545 err := row.Scan(&xid)
546 if err == sql.ErrNoRows {
547 xid = xfiltrate()
548 switch media {
549 case "image/png":
550 xid += ".png"
551 case "image/jpeg":
552 xid += ".jpg"
553 case "application/pdf":
554 xid += ".pdf"
555 case "text/plain":
556 xid += ".txt"
557 }
558 _, err = stmtSaveFileData.Exec(xid, media, hash, data)
559 if err != nil {
560 return 0, "", err
561 }
562 } else if err != nil {
563 elog.Printf("error checking file hash: %s", err)
564 return 0, "", err
565 }
566 if url == "" {
567 url = fmt.Sprintf("https://%s/d/%s", serverName, xid)
568 }
569 }
570
571 res, err := stmtSaveFile.Exec(xid, name, desc, url, media, local)
572 if err != nil {
573 return 0, "", err
574 }
575 fileid, _ := res.LastInsertId()
576 return fileid, xid, nil
577}
578
579func finddonk(url string) *Donk {
580 donk := new(Donk)
581 row := stmtFindFile.QueryRow(url)
582 err := row.Scan(&donk.FileID, &donk.XID)
583 if err == nil {
584 return donk
585 }
586 if err != sql.ErrNoRows {
587 elog.Printf("error finding file: %s", err)
588 }
589 return nil
590}
591
592func savechonk(ch *Chonk) error {
593 dt := ch.Date.UTC().Format(dbtimeformat)
594 db := opendatabase()
595 tx, err := db.Begin()
596 if err != nil {
597 elog.Printf("can't begin tx: %s", err)
598 return err
599 }
600
601 res, err := tx.Stmt(stmtSaveChonk).Exec(ch.UserID, ch.XID, ch.Who, ch.Target, dt, ch.Noise, ch.Format)
602 if err == nil {
603 ch.ID, _ = res.LastInsertId()
604 for _, d := range ch.Donks {
605 _, err := tx.Stmt(stmtSaveDonk).Exec(-1, ch.ID, d.FileID)
606 if err != nil {
607 elog.Printf("error saving donk: %s", err)
608 break
609 }
610 }
611 chatplusone(tx, ch.UserID)
612 err = tx.Commit()
613 } else {
614 tx.Rollback()
615 }
616 return err
617}
618
619func chatplusone(tx *sql.Tx, userid int64) {
620 var user *WhatAbout
621 ok := somenumberedusers.Get(userid, &user)
622 if !ok {
623 return
624 }
625 options := user.Options
626 options.ChatCount += 1
627 j, err := jsonify(options)
628 if err == nil {
629 _, err = tx.Exec("update users set options = ? where username = ?", j, user.Name)
630 }
631 if err != nil {
632 elog.Printf("error plussing chat: %s", err)
633 }
634 somenamedusers.Clear(user.Name)
635 somenumberedusers.Clear(user.ID)
636}
637
638func chatnewnone(userid int64) {
639 var user *WhatAbout
640 ok := somenumberedusers.Get(userid, &user)
641 if !ok || user.Options.ChatCount == 0 {
642 return
643 }
644 options := user.Options
645 options.ChatCount = 0
646 j, err := jsonify(options)
647 if err == nil {
648 db := opendatabase()
649 _, err = db.Exec("update users set options = ? where username = ?", j, user.Name)
650 }
651 if err != nil {
652 elog.Printf("error noneing chat: %s", err)
653 }
654 somenamedusers.Clear(user.Name)
655 somenumberedusers.Clear(user.ID)
656}
657
658func meplusone(tx *sql.Tx, userid int64) {
659 var user *WhatAbout
660 ok := somenumberedusers.Get(userid, &user)
661 if !ok {
662 return
663 }
664 options := user.Options
665 options.MeCount += 1
666 j, err := jsonify(options)
667 if err == nil {
668 _, err = tx.Exec("update users set options = ? where username = ?", j, user.Name)
669 }
670 if err != nil {
671 elog.Printf("error plussing me: %s", err)
672 }
673 somenamedusers.Clear(user.Name)
674 somenumberedusers.Clear(user.ID)
675}
676
677func menewnone(userid int64) {
678 var user *WhatAbout
679 ok := somenumberedusers.Get(userid, &user)
680 if !ok || user.Options.MeCount == 0 {
681 return
682 }
683 options := user.Options
684 options.MeCount = 0
685 j, err := jsonify(options)
686 if err == nil {
687 db := opendatabase()
688 _, err = db.Exec("update users set options = ? where username = ?", j, user.Name)
689 }
690 if err != nil {
691 elog.Printf("error noneing me: %s", err)
692 }
693 somenamedusers.Clear(user.Name)
694 somenumberedusers.Clear(user.ID)
695}
696
697func loadchatter(userid int64) []*Chatter {
698 duedt := time.Now().Add(-3 * 24 * time.Hour).UTC().Format(dbtimeformat)
699 rows, err := stmtLoadChonks.Query(userid, duedt)
700 if err != nil {
701 elog.Printf("error loading chonks: %s", err)
702 return nil
703 }
704 defer rows.Close()
705 chonks := make(map[string][]*Chonk)
706 var allchonks []*Chonk
707 for rows.Next() {
708 ch := new(Chonk)
709 var dt string
710 err = rows.Scan(&ch.ID, &ch.UserID, &ch.XID, &ch.Who, &ch.Target, &dt, &ch.Noise, &ch.Format)
711 if err != nil {
712 elog.Printf("error scanning chonk: %s", err)
713 continue
714 }
715 ch.Date, _ = time.Parse(dbtimeformat, dt)
716 chonks[ch.Target] = append(chonks[ch.Target], ch)
717 allchonks = append(allchonks, ch)
718 }
719 donksforchonks(allchonks)
720 rows.Close()
721 rows, err = stmtGetChatters.Query(userid)
722 if err != nil {
723 elog.Printf("error getting chatters: %s", err)
724 return nil
725 }
726 for rows.Next() {
727 var target string
728 err = rows.Scan(&target)
729 if err != nil {
730 elog.Printf("error scanning chatter: %s", target)
731 continue
732 }
733 if _, ok := chonks[target]; !ok {
734 chonks[target] = []*Chonk{}
735
736 }
737 }
738 var chatter []*Chatter
739 for target, chonks := range chonks {
740 chatter = append(chatter, &Chatter{
741 Target: target,
742 Chonks: chonks,
743 })
744 }
745 sort.Slice(chatter, func(i, j int) bool {
746 a, b := chatter[i], chatter[j]
747 if len(a.Chonks) == 0 || len(b.Chonks) == 0 {
748 if len(a.Chonks) == len(b.Chonks) {
749 return a.Target < b.Target
750 }
751 return len(a.Chonks) > len(b.Chonks)
752 }
753 return a.Chonks[len(a.Chonks)-1].Date.After(b.Chonks[len(b.Chonks)-1].Date)
754 })
755
756 return chatter
757}
758
759func savehonk(h *Honk) error {
760 dt := h.Date.UTC().Format(dbtimeformat)
761 aud := strings.Join(h.Audience, " ")
762
763 db := opendatabase()
764 tx, err := db.Begin()
765 if err != nil {
766 elog.Printf("can't begin tx: %s", err)
767 return err
768 }
769
770 res, err := tx.Stmt(stmtSaveHonk).Exec(h.UserID, h.What, h.Honker, h.XID, h.RID, dt, h.URL,
771 aud, h.Noise, h.Convoy, h.Whofore, h.Format, h.Precis,
772 h.Oonker, h.Flags)
773 if err == nil {
774 h.ID, _ = res.LastInsertId()
775 err = saveextras(tx, h)
776 }
777 if err == nil {
778 if h.Whofore == 1 {
779 meplusone(tx, h.UserID)
780 }
781 err = tx.Commit()
782 } else {
783 tx.Rollback()
784 }
785 if err != nil {
786 elog.Printf("error saving honk: %s", err)
787 }
788 honkhonkline()
789 return err
790}
791
792func updatehonk(h *Honk) error {
793 old := getxonk(h.UserID, h.XID)
794 oldrev := OldRevision{Precis: old.Precis, Noise: old.Noise}
795 dt := h.Date.UTC().Format(dbtimeformat)
796
797 db := opendatabase()
798 tx, err := db.Begin()
799 if err != nil {
800 elog.Printf("can't begin tx: %s", err)
801 return err
802 }
803
804 err = deleteextras(tx, h.ID, false)
805 if err == nil {
806 _, err = tx.Stmt(stmtUpdateHonk).Exec(h.Precis, h.Noise, h.Format, h.Whofore, dt, h.ID)
807 }
808 if err == nil {
809 err = saveextras(tx, h)
810 }
811 if err == nil {
812 var j string
813 j, err = jsonify(&oldrev)
814 if err == nil {
815 _, err = tx.Stmt(stmtSaveMeta).Exec(old.ID, "oldrev", j)
816 }
817 if err != nil {
818 elog.Printf("error saving oldrev: %s", err)
819 }
820 }
821 if err == nil {
822 err = tx.Commit()
823 } else {
824 tx.Rollback()
825 }
826 if err != nil {
827 elog.Printf("error updating honk %d: %s", h.ID, err)
828 }
829 return err
830}
831
832func deletehonk(honkid int64) error {
833 db := opendatabase()
834 tx, err := db.Begin()
835 if err != nil {
836 elog.Printf("can't begin tx: %s", err)
837 return err
838 }
839
840 err = deleteextras(tx, honkid, true)
841 if err == nil {
842 _, err = tx.Stmt(stmtDeleteHonk).Exec(honkid)
843 }
844 if err == nil {
845 err = tx.Commit()
846 } else {
847 tx.Rollback()
848 }
849 if err != nil {
850 elog.Printf("error deleting honk %d: %s", honkid, err)
851 }
852 return err
853}
854
855func saveextras(tx *sql.Tx, h *Honk) error {
856 for _, d := range h.Donks {
857 _, err := tx.Stmt(stmtSaveDonk).Exec(h.ID, -1, d.FileID)
858 if err != nil {
859 elog.Printf("error saving donk: %s", err)
860 return err
861 }
862 }
863 for _, o := range h.Onts {
864 _, err := tx.Stmt(stmtSaveOnt).Exec(strings.ToLower(o), h.ID)
865 if err != nil {
866 elog.Printf("error saving ont: %s", err)
867 return err
868 }
869 }
870 if p := h.Place; p != nil {
871 j, err := jsonify(p)
872 if err == nil {
873 _, err = tx.Stmt(stmtSaveMeta).Exec(h.ID, "place", j)
874 }
875 if err != nil {
876 elog.Printf("error saving place: %s", err)
877 return err
878 }
879 }
880 if t := h.Time; t != nil {
881 j, err := jsonify(t)
882 if err == nil {
883 _, err = tx.Stmt(stmtSaveMeta).Exec(h.ID, "time", j)
884 }
885 if err != nil {
886 elog.Printf("error saving time: %s", err)
887 return err
888 }
889 }
890 if m := h.Mentions; len(m) > 0 {
891 j, err := jsonify(m)
892 if err == nil {
893 _, err = tx.Stmt(stmtSaveMeta).Exec(h.ID, "mentions", j)
894 }
895 if err != nil {
896 elog.Printf("error saving mentions: %s", err)
897 return err
898 }
899 }
900 if w := h.Wonkles; w != "" {
901 _, err := tx.Stmt(stmtSaveMeta).Exec(h.ID, "wonkles", w)
902 if err != nil {
903 elog.Printf("error saving wonkles: %s", err)
904 return err
905 }
906 }
907 if g := h.Guesses; g != "" {
908 _, err := tx.Stmt(stmtSaveMeta).Exec(h.ID, "guesses", g)
909 if err != nil {
910 elog.Printf("error saving guesses: %s", err)
911 return err
912 }
913 }
914 return nil
915}
916
917var baxonker sync.Mutex
918
919func addreaction(user *WhatAbout, xid string, who, react string) {
920 baxonker.Lock()
921 defer baxonker.Unlock()
922 h := getxonk(user.ID, xid)
923 if h == nil {
924 return
925 }
926 h.Badonks = append(h.Badonks, Badonk{Who: who, What: react})
927 j, _ := jsonify(h.Badonks)
928 db := opendatabase()
929 tx, _ := db.Begin()
930 _, _ = tx.Stmt(stmtDeleteOneMeta).Exec(h.ID, "badonks")
931 _, _ = tx.Stmt(stmtSaveMeta).Exec(h.ID, "badonks", j)
932 tx.Commit()
933}
934
935func deleteextras(tx *sql.Tx, honkid int64, everything bool) error {
936 _, err := tx.Stmt(stmtDeleteDonks).Exec(honkid)
937 if err != nil {
938 return err
939 }
940 _, err = tx.Stmt(stmtDeleteOnts).Exec(honkid)
941 if err != nil {
942 return err
943 }
944 if everything {
945 _, err = tx.Stmt(stmtDeleteAllMeta).Exec(honkid)
946 } else {
947 _, err = tx.Stmt(stmtDeleteSomeMeta).Exec(honkid)
948 }
949 if err != nil {
950 return err
951 }
952 return nil
953}
954
955func jsonify(what interface{}) (string, error) {
956 var buf bytes.Buffer
957 e := json.NewEncoder(&buf)
958 e.SetEscapeHTML(false)
959 e.SetIndent("", "")
960 err := e.Encode(what)
961 return buf.String(), err
962}
963
964func unjsonify(s string, dest interface{}) error {
965 d := json.NewDecoder(strings.NewReader(s))
966 err := d.Decode(dest)
967 return err
968}
969
970func getxonker(what, flav string) string {
971 var res string
972 row := stmtGetXonker.QueryRow(what, flav)
973 row.Scan(&res)
974 return res
975}
976
977func savexonker(what, value, flav, when string) {
978 stmtSaveXonker.Exec(what, value, flav, when)
979}
980
981func savehonker(user *WhatAbout, url, name, flavor, combos, mj string) error {
982 var owner string
983 if url[0] == '#' {
984 flavor = "peep"
985 if name == "" {
986 name = url[1:]
987 }
988 owner = url
989 } else {
990 info, err := investigate(url)
991 if err != nil {
992 ilog.Printf("failed to investigate honker: %s", err)
993 return err
994 }
995 url = info.XID
996 if name == "" {
997 name = info.Name
998 }
999 owner = info.Owner
1000 }
1001
1002 var x string
1003 db := opendatabase()
1004 row := db.QueryRow("select xid from honkers where xid = ? and userid = ? and flavor in ('sub', 'unsub', 'peep')", url, user.ID)
1005 err := row.Scan(&x)
1006 if err != sql.ErrNoRows {
1007 if err != nil {
1008 elog.Printf("honker scan err: %s", err)
1009 } else {
1010 err = fmt.Errorf("it seems you are already subscribed to them")
1011 }
1012 return err
1013 }
1014
1015 res, err := stmtSaveHonker.Exec(user.ID, name, url, flavor, combos, owner, mj)
1016 if err != nil {
1017 elog.Print(err)
1018 return err
1019 }
1020 honkerid, _ := res.LastInsertId()
1021 if flavor == "presub" {
1022 followyou(user, honkerid)
1023 }
1024 return nil
1025}
1026
1027func cleanupdb(arg string) {
1028 db := opendatabase()
1029 days, err := strconv.Atoi(arg)
1030 var sqlargs []interface{}
1031 var where string
1032 if err != nil {
1033 honker := arg
1034 expdate := time.Now().Add(-3 * 24 * time.Hour).UTC().Format(dbtimeformat)
1035 where = "dt < ? and honker = ?"
1036 sqlargs = append(sqlargs, expdate)
1037 sqlargs = append(sqlargs, honker)
1038 } else {
1039 expdate := time.Now().Add(-time.Duration(days) * 24 * time.Hour).UTC().Format(dbtimeformat)
1040 where = "dt < ? and convoy not in (select convoy from honks where flags & 4 or whofore = 2 or whofore = 3)"
1041 sqlargs = append(sqlargs, expdate)
1042 }
1043 doordie(db, "delete from honks where flags & 4 = 0 and whofore = 0 and "+where, sqlargs...)
1044 doordie(db, "delete from donks where honkid > 0 and honkid not in (select honkid from honks)")
1045 doordie(db, "delete from onts where honkid not in (select honkid from honks)")
1046 doordie(db, "delete from honkmeta where honkid not in (select honkid from honks)")
1047
1048 doordie(db, "delete from filemeta where fileid not in (select fileid from donks)")
1049 for _, u := range allusers() {
1050 doordie(db, "delete from zonkers where userid = ? and wherefore = 'zonvoy' and zonkerid < (select zonkerid from zonkers where userid = ? and wherefore = 'zonvoy' order by zonkerid desc limit 1 offset 200)", u.UserID, u.UserID)
1051 }
1052
1053 filexids := make(map[string]bool)
1054 blobdb := openblobdb()
1055 rows, err := blobdb.Query("select xid from filedata")
1056 if err != nil {
1057 elog.Fatal(err)
1058 }
1059 for rows.Next() {
1060 var xid string
1061 err = rows.Scan(&xid)
1062 if err != nil {
1063 elog.Fatal(err)
1064 }
1065 filexids[xid] = true
1066 }
1067 rows.Close()
1068 rows, err = db.Query("select xid from filemeta")
1069 for rows.Next() {
1070 var xid string
1071 err = rows.Scan(&xid)
1072 if err != nil {
1073 elog.Fatal(err)
1074 }
1075 delete(filexids, xid)
1076 }
1077 rows.Close()
1078 tx, err := blobdb.Begin()
1079 if err != nil {
1080 elog.Fatal(err)
1081 }
1082 for xid, _ := range filexids {
1083 _, err = tx.Exec("delete from filedata where xid = ?", xid)
1084 if err != nil {
1085 elog.Fatal(err)
1086 }
1087 }
1088 err = tx.Commit()
1089 if err != nil {
1090 elog.Fatal(err)
1091 }
1092}
1093
1094var stmtHonkers, stmtDubbers, stmtNamedDubbers, stmtSaveHonker, stmtUpdateFlavor, stmtUpdateHonker *sql.Stmt
1095var stmtDeleteHonker *sql.Stmt
1096var stmtAnyXonk, stmtOneXonk, stmtPublicHonks, stmtUserHonks, stmtHonksByCombo, stmtHonksByConvoy *sql.Stmt
1097var stmtHonksByOntology, stmtHonksForUser, stmtHonksForMe, stmtSaveDub, stmtHonksByXonker *sql.Stmt
1098var stmtHonksFromLongAgo *sql.Stmt
1099var stmtHonksByHonker, stmtSaveHonk, stmtUserByName, stmtUserByNumber *sql.Stmt
1100var stmtEventHonks, stmtOneBonk, stmtFindZonk, stmtFindXonk, stmtSaveDonk *sql.Stmt
1101var stmtFindFile, stmtGetFileData, stmtSaveFileData, stmtSaveFile *sql.Stmt
1102var stmtCheckFileData *sql.Stmt
1103var stmtAddDoover, stmtGetDoovers, stmtLoadDoover, stmtZapDoover, stmtOneHonker *sql.Stmt
1104var stmtUntagged, stmtDeleteHonk, stmtDeleteDonks, stmtDeleteOnts, stmtSaveZonker *sql.Stmt
1105var stmtGetZonkers, stmtRecentHonkers, stmtGetXonker, stmtSaveXonker, stmtDeleteXonker, stmtDeleteOldXonkers *sql.Stmt
1106var stmtAllOnts, stmtSaveOnt, stmtUpdateFlags, stmtClearFlags *sql.Stmt
1107var stmtHonksForUserFirstClass *sql.Stmt
1108var stmtSaveMeta, stmtDeleteAllMeta, stmtDeleteOneMeta, stmtDeleteSomeMeta, stmtUpdateHonk *sql.Stmt
1109var stmtHonksISaved, stmtGetFilters, stmtSaveFilter, stmtDeleteFilter *sql.Stmt
1110var stmtGetTracks *sql.Stmt
1111var stmtSaveChonk, stmtLoadChonks, stmtGetChatters *sql.Stmt
1112
1113func preparetodie(db *sql.DB, s string) *sql.Stmt {
1114 stmt, err := db.Prepare(s)
1115 if err != nil {
1116 elog.Fatalf("error %s: %s", err, s)
1117 }
1118 return stmt
1119}
1120
1121func prepareStatements(db *sql.DB) {
1122 stmtHonkers = preparetodie(db, "select honkerid, userid, name, xid, flavor, combos, meta from honkers where userid = ? and (flavor = 'presub' or flavor = 'sub' or flavor = 'peep' or flavor = 'unsub') order by name")
1123 stmtSaveHonker = preparetodie(db, "insert into honkers (userid, name, xid, flavor, combos, owner, meta, folxid) values (?, ?, ?, ?, ?, ?, ?, '')")
1124 stmtUpdateFlavor = preparetodie(db, "update honkers set flavor = ?, folxid = ? where userid = ? and name = ? and xid = ? and flavor = ?")
1125 stmtUpdateHonker = preparetodie(db, "update honkers set name = ?, combos = ?, meta = ? where honkerid = ? and userid = ?")
1126 stmtDeleteHonker = preparetodie(db, "delete from honkers where honkerid = ?")
1127 stmtOneHonker = preparetodie(db, "select xid from honkers where name = ? and userid = ?")
1128 stmtDubbers = preparetodie(db, "select honkerid, userid, name, xid, flavor from honkers where userid = ? and flavor = 'dub'")
1129 stmtNamedDubbers = preparetodie(db, "select honkerid, userid, name, xid, flavor from honkers where userid = ? and name = ? and flavor = 'dub'")
1130
1131 selecthonks := "select honks.honkid, honks.userid, username, what, honker, oonker, honks.xid, rid, dt, url, audience, noise, precis, format, convoy, whofore, flags from honks join users on honks.userid = users.userid "
1132 limit := " order by honks.honkid desc limit 250"
1133 smalllimit := " order by honks.honkid desc limit ?"
1134 butnotthose := " and convoy not in (select name from zonkers where userid = ? and wherefore = 'zonvoy' order by zonkerid desc limit 100)"
1135 stmtOneXonk = preparetodie(db, selecthonks+"where honks.userid = ? and xid = ?")
1136 stmtAnyXonk = preparetodie(db, selecthonks+"where xid = ? order by honks.honkid asc")
1137 stmtOneBonk = preparetodie(db, selecthonks+"where honks.userid = ? and xid = ? and what = 'bonk' and whofore = 2")
1138 stmtPublicHonks = preparetodie(db, selecthonks+"where whofore = 2 and dt > ?"+smalllimit)
1139 stmtEventHonks = preparetodie(db, selecthonks+"where (whofore = 2 or honks.userid = ?) and what = 'event'"+smalllimit)
1140 stmtUserHonks = preparetodie(db, selecthonks+"where honks.honkid > ? and (whofore = 2 or whofore = ?) and username = ? and dt > ?"+smalllimit)
1141 myhonkers := " and honker in (select xid from honkers where userid = ? and (flavor = 'sub' or flavor = 'peep' or flavor = 'presub') and combos not like '% - %')"
1142 stmtHonksForUser = preparetodie(db, selecthonks+"where honks.honkid > ? and honks.userid = ? and dt > ?"+myhonkers+butnotthose+limit)
1143 stmtHonksForUserFirstClass = preparetodie(db, selecthonks+"where honks.honkid > ? and honks.userid = ? and dt > ? and (what <> 'tonk')"+myhonkers+butnotthose+limit)
1144 stmtHonksForMe = preparetodie(db, selecthonks+"where honks.honkid > ? and honks.userid = ? and dt > ? and whofore = 1"+butnotthose+limit)
1145 stmtHonksFromLongAgo = preparetodie(db, selecthonks+"where honks.honkid > ? and honks.userid = ? and dt > ? and dt < ? and whofore = 2"+butnotthose+limit)
1146 stmtHonksISaved = preparetodie(db, selecthonks+"where honks.honkid > ? and honks.userid = ? and flags & 4 order by honks.honkid desc")
1147 stmtHonksByHonker = preparetodie(db, selecthonks+"join honkers on (honkers.xid = honks.honker or honkers.xid = honks.oonker) where honks.honkid > ? and honks.userid = ? and honkers.name = ?"+butnotthose+limit)
1148 stmtHonksByXonker = preparetodie(db, selecthonks+" where honks.honkid > ? and honks.userid = ? and (honker = ? or oonker = ?)"+butnotthose+limit)
1149 stmtHonksByCombo = preparetodie(db, selecthonks+" where honks.honkid > ? and honks.userid = ? and honks.honker in (select xid from honkers where honkers.userid = ? and honkers.combos like ?) "+butnotthose+" union "+selecthonks+"join onts on honks.honkid = onts.honkid where honks.honkid > ? and honks.userid = ? and onts.ontology in (select xid from honkers where combos like ?)"+butnotthose+limit)
1150 stmtHonksByConvoy = preparetodie(db, selecthonks+"where honks.honkid > ? and (honks.userid = ? or (? = -1 and whofore = 2)) and convoy = ?"+limit)
1151 stmtHonksByOntology = preparetodie(db, selecthonks+"join onts on honks.honkid = onts.honkid where honks.honkid > ? and onts.ontology = ? and (honks.userid = ? or (? = -1 and honks.whofore = 2))"+limit)
1152
1153 stmtSaveMeta = preparetodie(db, "insert into honkmeta (honkid, genus, json) values (?, ?, ?)")
1154 stmtDeleteAllMeta = preparetodie(db, "delete from honkmeta where honkid = ?")
1155 stmtDeleteSomeMeta = preparetodie(db, "delete from honkmeta where honkid = ? and genus not in ('oldrev')")
1156 stmtDeleteOneMeta = preparetodie(db, "delete from honkmeta where honkid = ? and genus = ?")
1157 stmtSaveHonk = preparetodie(db, "insert into honks (userid, what, honker, xid, rid, dt, url, audience, noise, convoy, whofore, format, precis, oonker, flags) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
1158 stmtDeleteHonk = preparetodie(db, "delete from honks where honkid = ?")
1159 stmtUpdateHonk = preparetodie(db, "update honks set precis = ?, noise = ?, format = ?, whofore = ?, dt = ? where honkid = ?")
1160 stmtSaveOnt = preparetodie(db, "insert into onts (ontology, honkid) values (?, ?)")
1161 stmtDeleteOnts = preparetodie(db, "delete from onts where honkid = ?")
1162 stmtSaveDonk = preparetodie(db, "insert into donks (honkid, chonkid, fileid) values (?, ?, ?)")
1163 stmtDeleteDonks = preparetodie(db, "delete from donks where honkid = ?")
1164 stmtSaveFile = preparetodie(db, "insert into filemeta (xid, name, description, url, media, local) values (?, ?, ?, ?, ?, ?)")
1165 blobdb := openblobdb()
1166 stmtSaveFileData = preparetodie(blobdb, "insert into filedata (xid, media, hash, content) values (?, ?, ?, ?)")
1167 stmtCheckFileData = preparetodie(blobdb, "select xid from filedata where hash = ?")
1168 stmtGetFileData = preparetodie(blobdb, "select media, content from filedata where xid = ?")
1169 stmtFindXonk = preparetodie(db, "select honkid from honks where userid = ? and xid = ?")
1170 stmtFindFile = preparetodie(db, "select fileid, xid from filemeta where url = ? and local = 1")
1171 stmtUserByName = preparetodie(db, "select userid, username, displayname, about, pubkey, seckey, options from users where username = ? and userid > 0")
1172 stmtUserByNumber = preparetodie(db, "select userid, username, displayname, about, pubkey, seckey, options from users where userid = ?")
1173 stmtSaveDub = preparetodie(db, "insert into honkers (userid, name, xid, flavor, combos, owner, meta, folxid) values (?, ?, ?, ?, '', '', '', ?)")
1174 stmtAddDoover = preparetodie(db, "insert into doovers (dt, tries, userid, rcpt, msg) values (?, ?, ?, ?, ?)")
1175 stmtGetDoovers = preparetodie(db, "select dooverid, dt from doovers")
1176 stmtLoadDoover = preparetodie(db, "select tries, userid, rcpt, msg from doovers where dooverid = ?")
1177 stmtZapDoover = preparetodie(db, "delete from doovers where dooverid = ?")
1178 stmtUntagged = preparetodie(db, "select xid, rid, flags from (select honkid, xid, rid, flags from honks where userid = ? order by honkid desc limit 10000) order by honkid asc")
1179 stmtFindZonk = preparetodie(db, "select zonkerid from zonkers where userid = ? and name = ? and wherefore = 'zonk'")
1180 stmtGetZonkers = preparetodie(db, "select zonkerid, name, wherefore from zonkers where userid = ? and wherefore <> 'zonk'")
1181 stmtSaveZonker = preparetodie(db, "insert into zonkers (userid, name, wherefore) values (?, ?, ?)")
1182 stmtGetXonker = preparetodie(db, "select info from xonkers where name = ? and flavor = ?")
1183 stmtSaveXonker = preparetodie(db, "insert into xonkers (name, info, flavor, dt) values (?, ?, ?, ?)")
1184 stmtDeleteXonker = preparetodie(db, "delete from xonkers where name = ? and flavor = ? and dt < ?")
1185 stmtDeleteOldXonkers = preparetodie(db, "delete from xonkers where flavor = ? and dt < ?")
1186 stmtRecentHonkers = preparetodie(db, "select distinct(honker) from honks where userid = ? and honker not in (select xid from honkers where userid = ? and flavor = 'sub') order by honkid desc limit 100")
1187 stmtUpdateFlags = preparetodie(db, "update honks set flags = flags | ? where honkid = ?")
1188 stmtClearFlags = preparetodie(db, "update honks set flags = flags & ~ ? where honkid = ?")
1189 stmtAllOnts = preparetodie(db, "select ontology, count(ontology) from onts join honks on onts.honkid = honks.honkid where (honks.userid = ? or honks.whofore = 2) group by ontology")
1190 stmtGetFilters = preparetodie(db, "select hfcsid, json from hfcs where userid = ?")
1191 stmtSaveFilter = preparetodie(db, "insert into hfcs (userid, json) values (?, ?)")
1192 stmtDeleteFilter = preparetodie(db, "delete from hfcs where userid = ? and hfcsid = ?")
1193 stmtGetTracks = preparetodie(db, "select fetches from tracks where xid = ?")
1194 stmtSaveChonk = preparetodie(db, "insert into chonks (userid, xid, who, target, dt, noise, format) values (?, ?, ?, ?, ?, ?, ?)")
1195 stmtLoadChonks = preparetodie(db, "select chonkid, userid, xid, who, target, dt, noise, format from chonks where userid = ? and dt > ? order by chonkid asc")
1196 stmtGetChatters = preparetodie(db, "select distinct(target) from chonks where userid = ?")
1197}