queries

Documentation

Index

• type BvvBackendSamenvoeging
• type BvvBackendVreemdeling
• type BvvBackendVreemdelingMapping
• type DBTX
• type Queries
  • func New(db DBTX) *Queries
  • func Prepare(ctx context.Context, db DBTX) (*Queries, error)
  • func (q *Queries) Close() error
  • func (q *Queries) SamenvoegingGet(ctx context.Context, vreemdelingLeidendID string) ([]*BvvBackendSamenvoeging, error)
  • func (q *Queries) SamenvoegingInsert(ctx context.Context, arg *SamenvoegingInsertParams) error
  • func (q *Queries) VreemdelingCount(ctx context.Context) (int64, error)
  • func (q *Queries) VreemdelingCreate(ctx context.Context, arg *VreemdelingCreateParams) error
  • func (q *Queries) VreemdelingDeleteById(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) VreemdelingDeleteByNummer(ctx context.Context, vreemdelingnummer string) error
  • func (q *Queries) VreemdelingGetById(ctx context.Context, id uuid.UUID) (*BvvBackendVreemdeling, error)
  • func (q *Queries) VreemdelingGetByNummer(ctx context.Context, vreemdelingnummer string) (*BvvBackendVreemdeling, error)
  • func (q *Queries) VreemdelingSearchByNameAndBirthdate(ctx context.Context, arg *VreemdelingSearchByNameAndBirthdateParams) ([]*BvvBackendVreemdeling, error)
  • func (q *Queries) VreemdelingUpdateById(ctx context.Context, arg *VreemdelingUpdateByIdParams) error
  • func (q *Queries) VreemdelingUpdateByNummer(ctx context.Context, arg *VreemdelingUpdateByNummerParams) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SamenvoegingInsertParams
• type VreemdelingCreateParams
• type VreemdelingSearchByNameAndBirthdateParams
• type VreemdelingUpdateByIdParams
• type VreemdelingUpdateByNummerParams

Types

type BvvBackendSamenvoeging

type BvvBackendSamenvoeging struct {
	ID                     uuid.UUID
	VreemdelingLeidendID   string
	VreemdelingVervallenID string
	CreatedAt              time.Time
}

type BvvBackendVreemdeling

type BvvBackendVreemdeling struct {
	ID                uuid.UUID
	Vreemdelingnummer string
	Name              sql.NullString
	Searchname        sql.NullString
	Birthdate         sql.NullTime
	CreatedAt         time.Time
	UpdatedAt         time.Time
	DeletedAt         sql.NullTime
}

type BvvBackendVreemdelingMapping

type BvvBackendVreemdelingMapping struct {
	Vreemdelingnummer           string
	DuplicateVreemdelingnummers []string
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type Queries

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

func New

func New(db DBTX) *Queries

func Prepare

func Prepare(ctx context.Context, db DBTX) (*Queries, error)

func (*Queries) Close

func (q *Queries) Close() error

func (*Queries) SamenvoegingGet

func (q *Queries) SamenvoegingGet(ctx context.Context, vreemdelingLeidendID string) ([]*BvvBackendSamenvoeging, error)

func (*Queries) SamenvoegingInsert

func (q *Queries) SamenvoegingInsert(ctx context.Context, arg *SamenvoegingInsertParams) error

func (*Queries) VreemdelingCount

func (q *Queries) VreemdelingCount(ctx context.Context) (int64, error)

func (*Queries) VreemdelingCreate

func (q *Queries) VreemdelingCreate(ctx context.Context, arg *VreemdelingCreateParams) error

func (*Queries) VreemdelingDeleteById

func (q *Queries) VreemdelingDeleteById(ctx context.Context, id uuid.UUID) error

func (*Queries) VreemdelingDeleteByNummer

func (q *Queries) VreemdelingDeleteByNummer(ctx context.Context, vreemdelingnummer string) error

func (*Queries) VreemdelingGetById

func (q *Queries) VreemdelingGetById(ctx context.Context, id uuid.UUID) (*BvvBackendVreemdeling, error)

func (*Queries) VreemdelingGetByNummer

func (q *Queries) VreemdelingGetByNummer(ctx context.Context, vreemdelingnummer string) (*BvvBackendVreemdeling, error)

func (*Queries) VreemdelingSearchByNameAndBirthdate

func (q *Queries) VreemdelingSearchByNameAndBirthdate(ctx context.Context, arg *VreemdelingSearchByNameAndBirthdateParams) ([]*BvvBackendVreemdeling, error)

func (*Queries) VreemdelingUpdateById

func (q *Queries) VreemdelingUpdateById(ctx context.Context, arg *VreemdelingUpdateByIdParams) error

func (*Queries) VreemdelingUpdateByNummer

func (q *Queries) VreemdelingUpdateByNummer(ctx context.Context, arg *VreemdelingUpdateByNummerParams) error

func (*Queries) WithTx

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

type SamenvoegingInsertParams

type SamenvoegingInsertParams struct {
	ID                     uuid.UUID
	VreemdelingLeidendID   string
	VreemdelingVervallenID string
	CreatedAt              time.Time
}

type VreemdelingCreateParams

type VreemdelingCreateParams struct {
	ID                uuid.UUID
	Vreemdelingnummer string
	Name              sql.NullString
	Searchname        sql.NullString
	Birthdate         sql.NullTime
}

type VreemdelingSearchByNameAndBirthdateParams

type VreemdelingSearchByNameAndBirthdateParams struct {
	Name      sql.NullString
	Birthdate sql.NullTime
}

type VreemdelingUpdateByIdParams

type VreemdelingUpdateByIdParams struct {
	ID                uuid.UUID
	Vreemdelingnummer string
	Name              sql.NullString
	Searchname        sql.NullString
	Birthdate         sql.NullTime
}

type VreemdelingUpdateByNummerParams

type VreemdelingUpdateByNummerParams struct {
	Vreemdelingnummer   string
	Vreemdelingnummer_2 string
	Name                sql.NullString
	Searchname          sql.NullString
	Birthdate           sql.NullTime
}