db

Documentation

Index

• type DBTX
• type Email
• type GetEmailsWithPaginationParams
• type GetTrackersWithPaginationParams
• type InsertEmailParams
• type InsertTrackerParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) GetEmailByUUID(ctx context.Context, argUuid uuid.UUID) (Email, error)
  • func (q *Queries) GetEmails(ctx context.Context) ([]Email, error)
  • func (q *Queries) GetEmailsWithPagination(ctx context.Context, arg GetEmailsWithPaginationParams) ([]Email, error)
  • func (q *Queries) GetTrackerByUUID(ctx context.Context, emailUuid uuid.UUID) (Tracker, error)
  • func (q *Queries) GetTrackers(ctx context.Context) ([]Tracker, error)
  • func (q *Queries) GetTrackersWithPagination(ctx context.Context, arg GetTrackersWithPaginationParams) ([]Tracker, error)
  • func (q *Queries) InsertEmail(ctx context.Context, arg InsertEmailParams) (Email, error)
  • func (q *Queries) InsertTracker(ctx context.Context, arg InsertTrackerParams) (Tracker, error)
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type Tracker

Types

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 Email

type Email struct {
	Recipient string
	Subject   string
	SendDate  time.Time
	Uuid      uuid.UUID
}

type GetEmailsWithPaginationParams

type GetEmailsWithPaginationParams struct {
	Limit  int32
	Offset int32
}

type GetTrackersWithPaginationParams

type GetTrackersWithPaginationParams struct {
	Limit  int32
	Offset int32
}

type InsertEmailParams

type InsertEmailParams struct {
	Recipient string
	Subject   string
}

type InsertTrackerParams

type InsertTrackerParams struct {
	EmailUuid uuid.UUID
	IpAddress *string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) GetEmailByUUID

func (q *Queries) GetEmailByUUID(ctx context.Context, argUuid uuid.UUID) (Email, error)

func (*Queries) GetEmails

func (q *Queries) GetEmails(ctx context.Context) ([]Email, error)

func (*Queries) GetEmailsWithPagination

func (q *Queries) GetEmailsWithPagination(ctx context.Context, arg GetEmailsWithPaginationParams) ([]Email, error)

func (*Queries) GetTrackerByUUID

func (q *Queries) GetTrackerByUUID(ctx context.Context, emailUuid uuid.UUID) (Tracker, error)

func (*Queries) GetTrackers

func (q *Queries) GetTrackers(ctx context.Context) ([]Tracker, error)

func (*Queries) GetTrackersWithPagination

func (q *Queries) GetTrackersWithPagination(ctx context.Context, arg GetTrackersWithPaginationParams) ([]Tracker, error)

func (*Queries) InsertEmail

func (q *Queries) InsertEmail(ctx context.Context, arg InsertEmailParams) (Email, error)

func (*Queries) InsertTracker

func (q *Queries) InsertTracker(ctx context.Context, arg InsertTrackerParams) (Tracker, error)

func (*Queries) WithTx

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

type Tracker

type Tracker struct {
	TrackerID int32
	OpenDate  time.Time
	EmailUuid uuid.UUID
	IpAddress *string
}