db

package
v0.0.0-...-ae676c1 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Aug 31, 2025 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func DecodeUUID 

func DecodeUUID(uuidStr string) (pgtype.UUID, error)

func EncodeUUID 

func EncodeUUID(uuid pgtype.UUID) string

Types

type CommonStatuses 

type CommonStatuses string
const (
	CommonStatusesActive   CommonStatuses = "active"
	CommonStatusesInactive CommonStatuses = "inactive"
)

func (*CommonStatuses) Scan 

func (e *CommonStatuses) Scan(src interface{}) error

type CreateSurveyParams 

type CreateSurveyParams struct {
	ParseStatus    NullSurveyParseStatuses
	DeliveryStatus NullSurveyDeliveryStatuses
	ErrorLog       pgtype.Text
	Name           string
	Config         []byte
	UrlSlug        string
}

type CreateSurveySessionParams 

type CreateSurveySessionParams struct {
	Status NullSurveysSessionsStatus
	Uuid   pgtype.UUID
	IpAddr pgtype.Text
}

type CreateSurveySessionRow 

type CreateSurveySessionRow struct {
	ID   int32
	Uuid pgtype.UUID
}

type DBTX 

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteSurveyQuestionsNotInListParams 

type DeleteSurveyQuestionsNotInListParams struct {
	SurveyID int32
	Column2  []string
}

type GetSurveyByURLSlugRow 

type GetSurveyByURLSlugRow struct {
	ID             int32
	Uuid           pgtype.UUID
	CreatedAt      pgtype.Timestamp
	ParseStatus    NullSurveyParseStatuses
	DeliveryStatus NullSurveyDeliveryStatuses
	ErrorLog       pgtype.Text
	Name           string
	Config         []byte
	UrlSlug        string
}

type GetSurveyByUUIDRow 

type GetSurveyByUUIDRow struct {
	ID             int32
	Uuid           pgtype.UUID
	CreatedAt      pgtype.Timestamp
	ParseStatus    NullSurveyParseStatuses
	DeliveryStatus NullSurveyDeliveryStatuses
	ErrorLog       pgtype.Text
	Name           string
	Config         []byte
	UrlSlug        string
}

type GetSurveyQuestionsRow 

type GetSurveyQuestionsRow struct {
	Uuid       pgtype.UUID
	QuestionID string
}

type GetSurveySessionAnswersRow 

type GetSurveySessionAnswersRow struct {
	QuestionID   pgtype.Text
	QuestionUuid pgtype.UUID
	Answer       []byte
}

type GetSurveySessionByIPAddressParams 

type GetSurveySessionByIPAddressParams struct {
	Uuid   pgtype.UUID
	IpAddr pgtype.Text
}

type GetSurveySessionByIPAddressRow 

type GetSurveySessionByIPAddressRow struct {
	ID         int32
	Uuid       pgtype.UUID
	CreatedAt  pgtype.Timestamp
	Status     NullSurveysSessionsStatus
	SurveyUuid pgtype.UUID
}

type GetSurveySessionParams 

type GetSurveySessionParams struct {
	Uuid   pgtype.UUID
	Uuid_2 pgtype.UUID
}

type GetSurveySessionRow 

type GetSurveySessionRow struct {
	ID         int32
	Uuid       pgtype.UUID
	CreatedAt  pgtype.Timestamp
	Status     NullSurveysSessionsStatus
	SurveyUuid pgtype.UUID
}

type GetSurveySessionsWithAnswersParams 

type GetSurveySessionsWithAnswersParams struct {
	Uuid   pgtype.UUID
	Limit  int32
	Offset int32
}

type GetSurveySessionsWithAnswersRow 

type GetSurveySessionsWithAnswersRow struct {
	ID             int32
	Uuid           pgtype.UUID
	CreatedAt      pgtype.Timestamp
	CompletedAt    pgtype.Timestamp
	Status         NullSurveysSessionsStatus
	QuestionID     pgtype.Text
	QuestionUuid   pgtype.UUID
	Answer         []byte
	ResponseStatus pgtype.Int4
	Response       pgtype.Text
}

type GetSurveysParams 

type GetSurveysParams struct {
	Status   NullSurveysSessionsStatus
	Status_2 NullSurveysSessionsStatus
}

type GetSurveysRow 

type GetSurveysRow struct {
	ID                      int32
	Uuid                    pgtype.UUID
	CreatedAt               pgtype.Timestamp
	ParseStatus             NullSurveyParseStatuses
	DeliveryStatus          NullSurveyDeliveryStatuses
	ErrorLog                pgtype.Text
	Name                    string
	Config                  []byte
	UrlSlug                 string
	SessionsCountInProgress int64
	SessionsCountCompleted  int64
}

type NullCommonStatuses 

type NullCommonStatuses struct {
	CommonStatuses CommonStatuses
	Valid          bool // Valid is true if CommonStatuses is not NULL
}

func (*NullCommonStatuses) Scan 

func (ns *NullCommonStatuses) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullCommonStatuses) Value 

func (ns NullCommonStatuses) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullSurveyDeliveryStatuses 

type NullSurveyDeliveryStatuses struct {
	SurveyDeliveryStatuses SurveyDeliveryStatuses
	Valid                  bool // Valid is true if SurveyDeliveryStatuses is not NULL
}

func (*NullSurveyDeliveryStatuses) Scan 

func (ns *NullSurveyDeliveryStatuses) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullSurveyDeliveryStatuses) Value 

func (ns NullSurveyDeliveryStatuses) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullSurveyParseStatuses 

type NullSurveyParseStatuses struct {
	SurveyParseStatuses SurveyParseStatuses
	Valid               bool // Valid is true if SurveyParseStatuses is not NULL
}

func (*NullSurveyParseStatuses) Scan 

func (ns *NullSurveyParseStatuses) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullSurveyParseStatuses) Value 

func (ns NullSurveyParseStatuses) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type NullSurveysSessionsStatus 

type NullSurveysSessionsStatus struct {
	SurveysSessionsStatus SurveysSessionsStatus
	Valid                 bool // Valid is true if SurveysSessionsStatus is not NULL
}

func (*NullSurveysSessionsStatus) Scan 

func (ns *NullSurveysSessionsStatus) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullSurveysSessionsStatus) Value 

func (ns NullSurveysSessionsStatus) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) CreateSurvey 

func (q *Queries) CreateSurvey(ctx context.Context, arg CreateSurveyParams) (Survey, error)

func (*Queries) CreateSurveySession 

func (q *Queries) CreateSurveySession(ctx context.Context, arg CreateSurveySessionParams) (CreateSurveySessionRow, error)

func (*Queries) DeleteSurveyQuestionsNotInList 

func (q *Queries) DeleteSurveyQuestionsNotInList(ctx context.Context, arg DeleteSurveyQuestionsNotInListParams) error

func (*Queries) DeleteSurveySession 

func (q *Queries) DeleteSurveySession(ctx context.Context, uuid pgtype.UUID) error

func (*Queries) GetSurveyByURLSlug 

func (q *Queries) GetSurveyByURLSlug(ctx context.Context, urlSlug string) (GetSurveyByURLSlugRow, error)

func (*Queries) GetSurveyByUUID 

func (q *Queries) GetSurveyByUUID(ctx context.Context, uuid pgtype.UUID) (GetSurveyByUUIDRow, error)

func (*Queries) GetSurveyQuestions 

func (q *Queries) GetSurveyQuestions(ctx context.Context, surveyID int32) ([]GetSurveyQuestionsRow, error)

func (*Queries) GetSurveySession 

func (q *Queries) GetSurveySession(ctx context.Context, arg GetSurveySessionParams) (GetSurveySessionRow, error)

func (*Queries) GetSurveySessionAnswers 

func (q *Queries) GetSurveySessionAnswers(ctx context.Context, uuid pgtype.UUID) ([]GetSurveySessionAnswersRow, error)

func (*Queries) GetSurveySessionByIPAddress 

func (q *Queries) GetSurveySessionByIPAddress(ctx context.Context, arg GetSurveySessionByIPAddressParams) (GetSurveySessionByIPAddressRow, error)

func (*Queries) GetSurveySessionsCount 

func (q *Queries) GetSurveySessionsCount(ctx context.Context, uuid pgtype.UUID) (int64, error)

func (*Queries) GetSurveySessionsWithAnswers 

func (q *Queries) GetSurveySessionsWithAnswers(ctx context.Context, arg GetSurveySessionsWithAnswersParams) ([]GetSurveySessionsWithAnswersRow, error)

func (*Queries) GetSurveys 

func (q *Queries) GetSurveys(ctx context.Context, arg GetSurveysParams) ([]GetSurveysRow, error)

func (*Queries) StoreWebhookResponse 

func (q *Queries) StoreWebhookResponse(ctx context.Context, arg StoreWebhookResponseParams) error

func (*Queries) UpdateSurvey 

func (q *Queries) UpdateSurvey(ctx context.Context, arg UpdateSurveyParams) error

func (*Queries) UpdateSurveySessionStatus 

func (q *Queries) UpdateSurveySessionStatus(ctx context.Context, arg UpdateSurveySessionStatusParams) error

func (*Queries) UpdateSurveySessionStatusCompleted 

func (q *Queries) UpdateSurveySessionStatusCompleted(ctx context.Context, arg UpdateSurveySessionStatusCompletedParams) error

func (*Queries) UpsertSurveyQuestion 

func (q *Queries) UpsertSurveyQuestion(ctx context.Context, arg UpsertSurveyQuestionParams) error

func (*Queries) UpsertSurveyQuestionAnswer 

func (q *Queries) UpsertSurveyQuestionAnswer(ctx context.Context, arg UpsertSurveyQuestionAnswerParams) error

func (*Queries) WithTx 

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type StoreWebhookResponseParams 

type StoreWebhookResponseParams struct {
	CreatedAt      pgtype.Timestamp
	SessionID      int32
	ResponseStatus int32
	Response       pgtype.Text
}

type Survey 

type Survey struct {
	ID             int32
	Uuid           pgtype.UUID
	CreatedAt      pgtype.Timestamp
	ParseStatus    NullSurveyParseStatuses
	DeliveryStatus NullSurveyDeliveryStatuses
	ErrorLog       pgtype.Text
	Name           string
	UrlSlug        string
	Config         []byte
}

type SurveyDeliveryStatuses 

type SurveyDeliveryStatuses string
const (
	SurveyDeliveryStatusesLaunched SurveyDeliveryStatuses = "launched"
	SurveyDeliveryStatusesStopped  SurveyDeliveryStatuses = "stopped"
)

func (*SurveyDeliveryStatuses) Scan 

func (e *SurveyDeliveryStatuses) Scan(src interface{}) error

type SurveyParseStatuses 

type SurveyParseStatuses string
const (
	SurveyParseStatusesSuccess SurveyParseStatuses = "success"
	SurveyParseStatusesError   SurveyParseStatuses = "error"
	SurveyParseStatusesDeleted SurveyParseStatuses = "deleted"
)

func (*SurveyParseStatuses) Scan 

func (e *SurveyParseStatuses) Scan(src interface{}) error

type SurveysAnswer 

type SurveysAnswer struct {
	ID         int32
	Uuid       pgtype.UUID
	CreatedAt  pgtype.Timestamp
	SessionID  int32
	QuestionID int32
	Answer     []byte
}

type SurveysQuestion 

type SurveysQuestion struct {
	ID         int32
	Uuid       pgtype.UUID
	SurveyID   int32
	QuestionID string
}

type SurveysSession 

type SurveysSession struct {
	ID          int32
	Uuid        pgtype.UUID
	CreatedAt   pgtype.Timestamp
	CompletedAt pgtype.Timestamp
	Status      NullSurveysSessionsStatus
	SurveyID    int32
	IpAddr      pgtype.Text
}

type SurveysSessionsStatus 

type SurveysSessionsStatus string
const (
	SurveysSessionsStatusInProgress SurveysSessionsStatus = "in_progress"
	SurveysSessionsStatusCompleted  SurveysSessionsStatus = "completed"
)

func (*SurveysSessionsStatus) Scan 

func (e *SurveysSessionsStatus) Scan(src interface{}) error

type SurveysWebhookResponse 

type SurveysWebhookResponse struct {
	ID             int32
	CreatedAt      pgtype.Timestamp
	SessionID      int32
	ResponseStatus int32
	Response       pgtype.Text
}

type UpdateSurveyParams 

type UpdateSurveyParams struct {
	ParseStatus    NullSurveyParseStatuses
	DeliveryStatus NullSurveyDeliveryStatuses
	ErrorLog       pgtype.Text
	Name           string
	Config         []byte
	UrlSlug        string
	Uuid           pgtype.UUID
}

type UpdateSurveySessionStatusCompletedParams 

type UpdateSurveySessionStatusCompletedParams struct {
	Status NullSurveysSessionsStatus
	Uuid   pgtype.UUID
}

type UpdateSurveySessionStatusParams 

type UpdateSurveySessionStatusParams struct {
	Status NullSurveysSessionsStatus
	Uuid   pgtype.UUID
}

type UpsertSurveyQuestionAnswerParams 

type UpsertSurveyQuestionAnswerParams struct {
	Uuid   pgtype.UUID
	Uuid_2 pgtype.UUID
	Answer []byte
}

type UpsertSurveyQuestionParams 

type UpsertSurveyQuestionParams struct {
	SurveyID   int32
	QuestionID string
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.