foundation

type Assets struct {
	Dist http.FileSystem
	Img  http.FileSystem
}

type Config struct {
	HostPort      string
	DBPath        string
	LitestreamYml string

	Startup       time.Time
	DevFileServer bool
}

type Context struct {
	context.Context
	Config *Config
}

type Link struct {
	bun.BaseModel `bun:"table:links,alias:l"`

	ShortLink   string       `bun:"short_link,pk"`
	FullURL     string       `bun:"full_url,notnull"`
	UserID      int64        `bun:"user_id,notnull"`
	CreatedAt   time.Time    `bun:"created_at,nullzero,notnull"`
	UpdatedAt   time.Time    `bun:"updated_at,nullzero,notnull"`
	User        *User        `bun:"rel:has-one,join:user_id=id"`
	Visits      []*LinkVisit `bun:"rel:has-many,join:short_link=short_link"`
	VisitsCount int64        `bun:"visits_count,scanonly"`
}

type LinkVisit struct {
	bun.BaseModel `bun:"table:link_visits,alias:lv"`

	ID        int64         `bun:"id,pk,autoincrement"`
	ShortLink string        `bun:"short_link,notnull"`
	UserID    sql.NullInt64 `bun:"user_id"`
	VisitedAt time.Time     `bun:"visited_at,nullzero,notnull"`
}

type Request struct {
	*Context
	Writer  http.ResponseWriter
	Request *http.Request
	Params  httprouter.Params

	Session         *Session
	PreviousSession *Session
	User            *User
}

type Session struct {
	bun.BaseModel `bun:"table:sessions,alias:s"`

	ID        string        `bun:"id,pk"`
	UserID    sql.NullInt64 `bun:"user_id"`
	CreatedAt time.Time     `bun:"created_at,nullzero,notnull"`
	ExpiresAt time.Time     `bun:"expires_at,nullzero,notnull"`
	CSRFToken string        `bun:"csrf_token,nullzero,notnull"`
}

type User struct {
	bun.BaseModel `bun:"table:users,alias:u"`

	ID             int64     `bun:"id,pk,autoincrement"`
	DisplayName    string    `bun:"display_name,notnull"`
	UserName       string    `bun:"user_name,unique"`
	HashedPassword string    `bun:"hashed_password,notnull"`
	CreatedAt      time.Time `bun:"created_at,nullzero,notnull"`
	UpdatedAt      time.Time `bun:"updated_at,nullzero,notnull"`
}