sqlc

Documentation

Index

• type CreateObservationParams
• type CreatePolicyParams
• type CreateSiteParams
• type CreateSpeciesParams
• type CreateTargetPopulationParams
• type DBTX
• type DeletePolicyParams
• type GetObservationBySpeciesParams
• type GetPolicyBySiteSpeciesParams
• type GetPolicyBySiteSpeciesRow
• type GetSiteObservationForSpeciesParams
• type GetSiteSpeciesTargetPopulationParams
• type GetSiteSpeciesTargetPopulationRow
• type GetSiteTargetPopulationsRow
• type Observation
• type Policy
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateObservation(ctx context.Context, arg CreateObservationParams) (Observation, error)
  • func (q *Queries) CreatePolicy(ctx context.Context, arg CreatePolicyParams) (Policy, error)
  • func (q *Queries) CreateSite(ctx context.Context, arg CreateSiteParams) (Site, error)
  • func (q *Queries) CreateSpecies(ctx context.Context, arg CreateSpeciesParams) (Species, error)
  • func (q *Queries) CreateTargetPopulation(ctx context.Context, arg CreateTargetPopulationParams) (TargetPopulation, error)
  • func (q *Queries) DeletePolicy(ctx context.Context, arg DeletePolicyParams) (Policy, error)
  • func (q *Queries) GetObservationBySpecies(ctx context.Context, arg GetObservationBySpeciesParams) (Observation, error)
  • func (q *Queries) GetPolicyBySiteSpecies(ctx context.Context, arg GetPolicyBySiteSpeciesParams) (GetPolicyBySiteSpeciesRow, error)
  • func (q *Queries) GetSite(ctx context.Context, id uint32) (Site, error)
  • func (q *Queries) GetSiteObservationForSpecies(ctx context.Context, arg GetSiteObservationForSpeciesParams) ([]Observation, error)
  • func (q *Queries) GetSiteSpeciesTargetPopulation(ctx context.Context, arg GetSiteSpeciesTargetPopulationParams) (GetSiteSpeciesTargetPopulationRow, error)
  • func (q *Queries) GetSiteTargetPopulations(ctx context.Context, siteID uint32) ([]GetSiteTargetPopulationsRow, error)
  • func (q *Queries) GetSpeciesByName(ctx context.Context, name string) (Species, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Site
• type Species
• type TargetPopulation

Types

type CreateObservationParams

type CreateObservationParams struct {
	SiteID    uint32
	SpeciesID uint32
	Count     uint32
	CreatedAt string
	ClientID  uint32
}

type CreatePolicyParams

type CreatePolicyParams struct {
	ID           uint32
	PopulationID uint32
	Action       uint32
	CreatedAt    string
}

type CreateSiteParams

type CreateSiteParams struct {
	ID        uint32
	CreatedAt string
}

type CreateSpeciesParams

type CreateSpeciesParams struct {
	Name      string
	CreatedAt string
}

type CreateTargetPopulationParams

type CreateTargetPopulationParams struct {
	SiteID    uint32
	SpeciesID uint32
	Min       uint32
	Max       uint32
	CreatedAt 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 DeletePolicyParams

type DeletePolicyParams struct {
	DeletedAt sql.NullString
	ID        uint32
	SiteID    uint32
}

type GetObservationBySpeciesParams

type GetObservationBySpeciesParams struct {
	SiteID    uint32
	SpeciesID uint32
}

type GetPolicyBySiteSpeciesParams

type GetPolicyBySiteSpeciesParams struct {
	SiteID uint32
	Name   string
}

type GetPolicyBySiteSpeciesRow

type GetPolicyBySiteSpeciesRow struct {
	ID           uint32
	CreatedAt    string
	DeletedAt    sql.NullString
	Action       uint32
	PopulationID uint32
	ID_2         uint32
	CreatedAt_2  string
	SiteID       uint32
	SpeciesID    uint32
	Min          uint32
	Max          uint32
	ID_3         uint32
	CreatedAt_3  string
	Name         string
}

type GetSiteObservationForSpeciesParams

type GetSiteObservationForSpeciesParams struct {
	SiteID    uint32
	SpeciesID uint32
}

type GetSiteSpeciesTargetPopulationParams

type GetSiteSpeciesTargetPopulationParams struct {
	SiteID uint32
	Name   string
}

type GetSiteSpeciesTargetPopulationRow

type GetSiteSpeciesTargetPopulationRow struct {
	ID          uint32
	CreatedAt   string
	SiteID      uint32
	SpeciesID   uint32
	Min         uint32
	Max         uint32
	ID_2        uint32
	CreatedAt_2 string
	Name        string
}

type GetSiteTargetPopulationsRow

type GetSiteTargetPopulationsRow struct {
	ID          uint32
	CreatedAt   string
	SiteID      uint32
	SpeciesID   uint32
	Min         uint32
	Max         uint32
	ID_2        uint32
	CreatedAt_2 string
	Name        string
}

type Observation

type Observation struct {
	ID        uint32
	CreatedAt string
	SiteID    uint32
	SpeciesID uint32
	Count     uint32
	ClientID  uint32
}

type Policy

type Policy struct {
	ID           uint32
	CreatedAt    string
	DeletedAt    sql.NullString
	Action       uint32
	PopulationID uint32
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateObservation

func (q *Queries) CreateObservation(ctx context.Context, arg CreateObservationParams) (Observation, error)

func (*Queries) CreatePolicy

func (q *Queries) CreatePolicy(ctx context.Context, arg CreatePolicyParams) (Policy, error)

func (*Queries) CreateSite

func (q *Queries) CreateSite(ctx context.Context, arg CreateSiteParams) (Site, error)

func (*Queries) CreateSpecies

func (q *Queries) CreateSpecies(ctx context.Context, arg CreateSpeciesParams) (Species, error)

func (*Queries) CreateTargetPopulation

func (q *Queries) CreateTargetPopulation(ctx context.Context, arg CreateTargetPopulationParams) (TargetPopulation, error)

func (*Queries) DeletePolicy

func (q *Queries) DeletePolicy(ctx context.Context, arg DeletePolicyParams) (Policy, error)

func (*Queries) GetObservationBySpecies

func (q *Queries) GetObservationBySpecies(ctx context.Context, arg GetObservationBySpeciesParams) (Observation, error)

func (*Queries) GetPolicyBySiteSpecies

func (q *Queries) GetPolicyBySiteSpecies(ctx context.Context, arg GetPolicyBySiteSpeciesParams) (GetPolicyBySiteSpeciesRow, error)

func (*Queries) GetSite

func (q *Queries) GetSite(ctx context.Context, id uint32) (Site, error)

func (*Queries) GetSiteObservationForSpecies

func (q *Queries) GetSiteObservationForSpecies(ctx context.Context, arg GetSiteObservationForSpeciesParams) ([]Observation, error)

func (*Queries) GetSiteSpeciesTargetPopulation

func (q *Queries) GetSiteSpeciesTargetPopulation(ctx context.Context, arg GetSiteSpeciesTargetPopulationParams) (GetSiteSpeciesTargetPopulationRow, error)

func (*Queries) GetSiteTargetPopulations

func (q *Queries) GetSiteTargetPopulations(ctx context.Context, siteID uint32) ([]GetSiteTargetPopulationsRow, error)

func (*Queries) GetSpeciesByName

func (q *Queries) GetSpeciesByName(ctx context.Context, name string) (Species, error)

func (*Queries) WithTx

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

type Site

type Site struct {
	ID        uint32
	CreatedAt string
}

type Species

type Species struct {
	ID        uint32
	CreatedAt string
	Name      string
}

type TargetPopulation

type TargetPopulation struct {
	ID        uint32
	CreatedAt string
	SiteID    uint32
	SpeciesID uint32
	Min       uint32
	Max       uint32
}