db

type Comment struct {
	ID        int    `db:"commentid" json:"commentid"`
	Text      string `db:"comment" json:"comment"`
	Timestamp int64  `db:"timestamp" json:"timestamp"`
	DeviceID  string `db:"deviceid" json:"-"`
}

type DB struct {
	Pq    *sql.DB
	Redis *redis.Client
}

type IDB interface {
	FetchNPosts(ctx context.Context, n int) ([]*Post, error)
	FetchPostsFromID(ctx context.Context, id, limit int, prop string) ([]*Post, error)
	LikePost(ctx context.Context, postid, deviceid string) error
	Report(ctx context.Context, postid, deviceid, reason string) error
	SubmitPost(ctx context.Context, p *Post) error

	// Authentication related endpoints
	VerifyDeviceID(ctx context.Context, deviceid string) (string, error)
	RegisterDeviceID(ctx context.Context, deviceid, hash string, t time.Duration) error
}

type Like struct {
	DeviceID string `db:"deviceid" json:"-"`
}

type Post struct {
	ID        int    `db:"postid" json:"postid"`
	Text      string `db:"post" json:"post"`
	Timestamp int64  `db:"timestamp" json:"timestamp"`
	DeviceID  string `db:"deviceid" json:"-"`
	IPAddr    string `db:"ipAddr" json:"-"`
	PostMeta
}

type PostMeta struct {
	Likeable      bool       `json:"likeable"`
	Editable      bool       `json:"editable"`
	CommentsCount int        `db:"comments" json:"comments_count"`
	LikesCount    int        `db:"likes" json:"likes_count"`
	Comments      []*Comment `json:"comments"`
}