sqlite

Documentation

Index

• Variables
• func Open(DSN string) (*sql.DB, error)
• type MealService
  • func NewMealService(query *gen.Queries, db *sql.DB) *MealService
  • func (ms *MealService) CreateMeal(m *dinny.Meal) error
  • func (ms *MealService) DeleteMeal(id int64) error
  • func (ms *MealService) FindMealByDate(date dinny.Date) (*dinny.Meal, error)
  • func (ms *MealService) FindMealByID(id int64) (*dinny.Meal, error)
  • func (ms *MealService) FindMealBySlackMessageID(slackMessageID string) (*dinny.Meal, error)
  • func (ms *MealService) UpdateMeal(id int64, upd dinny.MealUpdate) error
• type MemberService
  • func NewMemberService(query *gen.Queries, db *sql.DB) *MemberService
  • func (ms *MemberService) CreateMember(m *dinny.Member) error
  • func (ms *MemberService) DeleteMember(id int64) error
  • func (ms *MemberService) FindMemberByID(id int64) (*dinny.Member, error)
  • func (ms *MemberService) FindMemberBySlackUID(slackUID string) (*dinny.Member, error)
  • func (ms *MemberService) ListMembers() ([]*dinny.Member, error)
  • func (ms *MemberService) UpdateMember(id int64, upd dinny.MemberUpdate) error

Variables

var Schema string

embed the sqlite schema within the binary to create the tables at runtime.

Functions

func Open

func Open(DSN string) (*sql.DB, error)

Open creates a connection to the sqlite database.

Types

type MealService

type MealService struct {
	// contains filtered or unexported fields
}

MemberService represents a service for managing members.

func NewMealService

func NewMealService(query *gen.Queries, db *sql.DB) *MealService

NewMemberService returns a new instance of MemberService.

func (*MealService) CreateMeal

func (ms *MealService) CreateMeal(m *dinny.Meal) error

CreateMeal creates a new meal.

func (*MealService) DeleteMeal

func (ms *MealService) DeleteMeal(id int64) error

DeleteMeal permanently deletes a meal.

func (*MealService) FindMealByDate

func (ms *MealService) FindMealByDate(date dinny.Date) (*dinny.Meal, error)

FindMealByDate retrieves a meal by Date. Returns ErrNotFound if meal does not exist.

func (*MealService) FindMealByID

func (ms *MealService) FindMealByID(id int64) (*dinny.Meal, error)

FindMealByID retrieves a meal by ID. Returns ErrNotFound if meal does not exist.

func (*MealService) FindMealBySlackMessageID

func (ms *MealService) FindMealBySlackMessageID(slackMessageID string) (*dinny.Meal, error)

FindMealBySlackMessageID retrieves a meal by SlackMessageID. Returns ErrNotFound if meal does not exist.

func (*MealService) UpdateMeal

func (ms *MealService) UpdateMeal(id int64, upd dinny.MealUpdate) error

UpdateMeal updates a meal object.

type MemberService

type MemberService struct {
	// contains filtered or unexported fields
}

MemberService represents a service for managing members.

func NewMemberService

func NewMemberService(query *gen.Queries, db *sql.DB) *MemberService

NewMemberService returns a new instance of MemberService.

func (*MemberService) CreateMember

func (ms *MemberService) CreateMember(m *dinny.Member) error

Creates a new member.

func (*MemberService) DeleteMember

func (ms *MemberService) DeleteMember(id int64) error

Permanently deletes a member.

func (*MemberService) FindMemberByID

func (ms *MemberService) FindMemberByID(id int64) (*dinny.Member, error)

Retrieves a member by ID Returns ErrNotFound if meal does not exist.

func (*MemberService) FindMemberBySlackUID

func (ms *MemberService) FindMemberBySlackUID(slackUID string) (*dinny.Member, error)

Retrieves a member by SlackID Returns ErrNotFound if meal does not exist.

func (*MemberService) ListMembers

func (ms *MemberService) ListMembers() ([]*dinny.Member, error)

Retrieves a list of members.

func (*MemberService) UpdateMember

func (ms *MemberService) UpdateMember(id int64, upd dinny.MemberUpdate) error

Updates a member object.