models

type Proposal struct {
	ID        int `gorm:"primary_key"` // This is the Payload Model PK field
	Abstract  string
	Detail    string
	Reviews   []Review // has many Reviews
	Title     string
	UserID    int // has many Proposal
	Withdrawn *bool
	CreatedAt time.Time  // timestamp
	DeletedAt *time.Time // nullable timestamp (soft delete)
	UpdatedAt time.Time  // timestamp
	User      User
}

type ProposalDB struct {
	Db gorm.DB
}

type ProposalStorage interface {
	DB() interface{}
	List(ctx context.Context) []Proposal
	Get(ctx context.Context, id int) (Proposal, error)
	Add(ctx context.Context, proposal *Proposal) (*Proposal, error)
	Update(ctx context.Context, proposal *Proposal) error
	Delete(ctx context.Context, id int) error

	ListProposal(ctx context.Context, userID int) []*app.Proposal
	OneProposal(ctx context.Context, id int, userID int) (*app.Proposal, error)

	ListProposalLink(ctx context.Context, userID int) []*app.ProposalLink
	OneProposalLink(ctx context.Context, id int, userID int) (*app.ProposalLink, error)

	UpdateFromCreateProposalPayload(ctx context.Context, payload *app.CreateProposalPayload, id int) error

	UpdateFromUpdateProposalPayload(ctx context.Context, payload *app.UpdateProposalPayload, id int) error
}

type Review struct {
	ID         int `gorm:"primary_key"` // This is the Review Model PK field
	Comment    *string
	ProposalID int // Belongs To Proposal
	Rating     int
	UserID     int        // has many Review
	CreatedAt  time.Time  // timestamp
	DeletedAt  *time.Time // nullable timestamp (soft delete)
	UpdatedAt  time.Time  // timestamp
	Proposal   Proposal
	User       User
}

type ReviewDB struct {
	Db gorm.DB
}

type ReviewStorage interface {
	DB() interface{}
	List(ctx context.Context) []Review
	Get(ctx context.Context, id int) (Review, error)
	Add(ctx context.Context, review *Review) (*Review, error)
	Update(ctx context.Context, review *Review) error
	Delete(ctx context.Context, id int) error

	ListReview(ctx context.Context, proposalID int, userID int) []*app.Review
	OneReview(ctx context.Context, id int, proposalID int, userID int) (*app.Review, error)

	ListReviewLink(ctx context.Context, proposalID int, userID int) []*app.ReviewLink
	OneReviewLink(ctx context.Context, id int, proposalID int, userID int) (*app.ReviewLink, error)

	UpdateFromCreateReviewPayload(ctx context.Context, payload *app.CreateReviewPayload, id int) error

	UpdateFromUpdateReviewPayload(ctx context.Context, payload *app.UpdateReviewPayload, id int) error
}

type Test struct {
	CreatedAt time.Time  // timestamp
	DeletedAt *time.Time // nullable timestamp (soft delete)
	UpdatedAt time.Time  // timestamp
}

type TestDB struct {
	Db gorm.DB
}

type TestStorage interface {
	DB() interface{}
	List(ctx context.Context) []Test
	Get(ctx context.Context) (Test, error)
	Add(ctx context.Context, test *Test) (*Test, error)
	Update(ctx context.Context, test *Test) error
	Delete(ctx context.Context) error
}

type TestToo struct {
	Idone     int `gorm:"primary_key"` // This is one of the TestToo Model PK fields
	Idtwo     int `gorm:"primary_key"` // This is one of the TestToo Model PK fields
	Bio       *string
	City      *string
	Country   *string
	Email     string
	Firstname string
	Lastname  string
	State     *string
	CreatedAt time.Time  // timestamp
	DeletedAt *time.Time // nullable timestamp (soft delete)
	UpdatedAt time.Time  // timestamp
}

type TestTooDB struct {
	Db gorm.DB
}

type TestTooStorage interface {
	DB() interface{}
	List(ctx context.Context) []TestToo
	Get(ctx context.Context, idone int, idtwo int) (TestToo, error)
	Add(ctx context.Context, testtoo *TestToo) (*TestToo, error)
	Update(ctx context.Context, testtoo *TestToo) error
	Delete(ctx context.Context, idone int, idtwo int) error

	ListUser(ctx context.Context) []*app.User
	OneUser(ctx context.Context, idone int, idtwo int) (*app.User, error)

	ListUserLink(ctx context.Context) []*app.UserLink
	OneUserLink(ctx context.Context, idone int, idtwo int) (*app.UserLink, error)

	UpdateFromCreateUserPayload(ctx context.Context, payload *app.CreateUserPayload, idone int, idtwo int) error

	UpdateFromUpdateUserPayload(ctx context.Context, payload *app.UpdateUserPayload, idone int, idtwo int) error
}

type User struct {
	ID        int `gorm:"primary_key"` // This is the User Model PK field
	Bio       *string
	City      *string
	Country   *string
	Email     string
	Firstname string
	Lastname  string
	Proposals []Proposal // has many Proposals
	Reviews   []Review   // has many Reviews
	State     *string
	CreatedAt time.Time  // timestamp
	DeletedAt *time.Time // nullable timestamp (soft delete)
	UpdatedAt time.Time  // timestamp
}

type UserDB struct {
	Db gorm.DB
}

type UserStorage interface {
	DB() interface{}
	List(ctx context.Context) []User
	Get(ctx context.Context, id int) (User, error)
	Add(ctx context.Context, user *User) (*User, error)
	Update(ctx context.Context, user *User) error
	Delete(ctx context.Context, id int) error

	ListUser(ctx context.Context) []*app.User
	OneUser(ctx context.Context, id int) (*app.User, error)

	ListUserLink(ctx context.Context) []*app.UserLink
	OneUserLink(ctx context.Context, id int) (*app.UserLink, error)

	UpdateFromCreateUserPayload(ctx context.Context, payload *app.CreateUserPayload, id int) error

	UpdateFromUpdateUserPayload(ctx context.Context, payload *app.UpdateUserPayload, id int) error
}