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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87

package dal

import (
	"time"
)

type Account struct {
	Id              int
	CreatedAt       time.Time
	UserUrl         string // https://rss-parrot.net/u/taiwantrailsandtales.com
	Handle          string // taiwantrailsandtales.com
	FeedName        string // taiwan trails and tales | a guide to get you out of the city and into the hills
	FeedSummary     string // Taiwan Trails and Tales is a one-stop shop for everything Taiwan hiking related. Here you can find information about hundreds of hiking trails in Taiwan, as well as all the details you need to know about how and when to visit.
	SiteUrl         string // https://taiwantrailsandtales.com
	FeedUrl         string // https://taiwantrailsandtales.com/feed
	FeedLastUpdated time.Time
	NextCheckDue    time.Time
	PubKey          string
	ProfileImageUrl string
	HeaderImageUrl  string
	// Polling state; only loaded by GetAccountToCheck.
	FeedEtag         string // ETag of the last 200 response, sent as If-None-Match
	FeedLastModified string // Last-Modified of the last 200 response, sent as If-Modified-Since
	FetchFailures    int    // consecutive failed checks, for backoff
}

type Mention struct {
	StatusIdUrl string
	UserInfo    *FollowerInfo
}

type FeedPost struct {
	PostGuidHash int64
	PostTime     time.Time
	Link         string
	Title        string
	Description  string
}

// FeedItem statuses: see scripts/create-08.sql.
const (
	ItemDue       = 0 // to be tooted once its post_time has come
	ItemPublished = 1 // tooted, or stored without broadcasting when followed
	ItemSkipped   = 2 // never to be tooted
)

// FeedItem is a feed item in the ledger of every item ever seen.
type FeedItem struct {
	Id           int64
	AccountId    int
	Handle       string // of the account; only loaded by GetDueItems
	Guid         string
	LinkKey      string
	PostGuidHash int64
	PostTime     time.Time
	FirstSeen    time.Time
	Status       int
	Link         string
	Title        string
	Description  string
}

type Toot struct {
	PostGuidHash int64
	TootedAt     time.Time
	StatusId     string
	Content      string
}

type TootQueueItem struct {
	Id          int
	SendingUser string
	ToInbox     string
	TootedAt    time.Time
	StatusId    string
	Content     string
}

type FollowerInfo struct {
	RequestId     string // ID of the follow request activity; needed for approve reply
	ApproveStatus int    // 0: unapproved, 1: approved, negative: banned
	UserUrl       string // https://genart.social/users/twilliability
	Handle        string // twilliability
	Host          string // genart.social
	UserInbox     string // https://genart.social/users/twilliability/inbox
	SharedInbox   string // https://genart.social/inbox
}