1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
package database
import (
"database/sql"
"log"
"time"
_ "github.com/mattn/go-sqlite3"
)
type GuestbookEntry struct {
ID string `json:"id"`
Name string `json:"name"`
Message string `json:"message"`
CreatedAt time.Time `json:"created_at"`
}
func GetGuestbookEntries(db *sql.DB) ([]GuestbookEntry, error) {
log.Println("getting guest_book entries")
rows, err := db.Query("SELECT * FROM guest_book ORDER BY created_at DESC LIMIT 200")
if err != nil {
return nil, err
}
defer rows.Close()
var entries []GuestbookEntry
for rows.Next() {
var entry GuestbookEntry
err := rows.Scan(&entry.ID, &entry.Name, &entry.Message, &entry.CreatedAt)
if err != nil {
return nil, err
}
entries = append(entries, entry)
}
return entries, nil
}
func SaveGuestbookEntry(db *sql.DB, entry *GuestbookEntry) (*GuestbookEntry, error) {
log.Println("saving guest_book entry", entry.ID)
entry.CreatedAt = time.Now()
_, err := db.Exec("INSERT OR REPLACE INTO guest_book (id, name, message, created_at) VALUES (?, ?, ?, ?)", entry.ID, entry.Name, entry.Message, entry.CreatedAt)
if err != nil {
return nil, err
}
return entry, nil
}
|
