internal

type DbCommon struct {
	ID          string  `db:"id" goqu:"skipupdate"`
	Name        string  `db:"name"`
	Description *string `db:"description"`
	*DbTimestamps
}

type DbItem struct {
	*DbCommon
	StatusID *string `db:"status_id"`
}

type DbNote struct {
	ID       string `db:"id"`
	NoteText string `db:"note_text"`
	ItemID   string `db:"item_id"`
	*DbTimestamps
}

type DbProtoable interface {
	ToProto() (proto.Message, error)
}

type DbStatus struct {
	*DbCommon
	Color *string `db:"color"`
	Kind  *string `db:"kind"`
}

type DbTimestamps struct {
	Created uint64  `db:"created"`
	Updated uint64  `db:"updated"`
	Deleted *uint64 `db:"deleted"`
}

type DbUser struct {
	ID           string  `db:"id" goqu:"skipupdate"`
	Username     string  `db:"username"`
	Password     string  `db:"password"`
	FirstName    *string `db:"first_name"`
	LastName     *string `db:"last_name"`
	EmailAddress *string `db:"email_address"`
	LastLogin    *uint64 `db:"last_login"`
	AvatarURL    *string `db:"avatar_url"`
	*DbTimestamps
}

type ProtoStorer interface {
	Insert(ctx context.Context, pb proto.Message) (proto.Message, error)
	Select(ctx context.Context, idval string) (proto.Message, error)
	Update(ctx context.Context, idval string, opts ...filters.FilterOption) error
	Delete(ctx context.Context, idval string) error
	Where(ctx context.Context, opts ...filters.FilterOption) ([]proto.Message, error)
}