imsdb

package
v0.0.0-...-01a0c8f Latest Latest
Warning

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

Go to latest
Published: Feb 11, 2026 License: Apache-2.0 Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActionLog

type ActionLog struct {
	ID             int64
	CreatedAt      float64
	ActionType     string
	Method         sql.NullString
	Path           sql.NullString
	Referrer       sql.NullString
	UserID         sql.NullInt64
	UserName       sql.NullString
	PositionID     sql.NullInt64
	PositionName   sql.NullString
	ClientAddress  sql.NullString
	HttpStatus     sql.NullInt16
	DurationMicros sql.NullInt64
}

type ActionLogsParams

type ActionLogsParams struct {
	MinTime float64
	MaxTime float64
}

type ActionLogsRow

type ActionLogsRow struct {
	ActionLog ActionLog
}

type AddActionLogParams

type AddActionLogParams struct {
	CreatedAt      float64
	ActionType     string
	Method         sql.NullString
	Path           sql.NullString
	Referrer       sql.NullString
	UserID         sql.NullInt64
	UserName       sql.NullString
	PositionID     sql.NullInt64
	PositionName   sql.NullString
	ClientAddress  sql.NullString
	HttpStatus     sql.NullInt16
	DurationMicros sql.NullInt64
}

type AddEventAccessParams

type AddEventAccessParams struct {
	Event      int32
	Expression string
	Mode       EventAccessMode
	Validity   EventAccessValidity
	Expires    sql.NullFloat64
}

type AttachFieldReportToIncidentParams

type AttachFieldReportToIncidentParams struct {
	IncidentNumber sql.NullInt32
	Event          int32
	Number         int32
}

type AttachIncidentTypeToIncidentParams

type AttachIncidentTypeToIncidentParams struct {
	Event          int32
	IncidentNumber int32
	IncidentType   int32
}

type AttachRangerHandleToIncidentParams

type AttachRangerHandleToIncidentParams struct {
	Event          int32
	IncidentNumber int32
	RangerHandle   string
	Role           sql.NullString
}

type AttachRangerToStayParams

type AttachRangerToStayParams struct {
	Event        int32
	StayNumber   int32
	RangerHandle string
	Role         sql.NullString
}

type AttachReportEntryToFieldReportParams

type AttachReportEntryToFieldReportParams struct {
	Event             int32
	FieldReportNumber int32
	ReportEntry       int32
}

type AttachReportEntryToIncidentParams

type AttachReportEntryToIncidentParams struct {
	Event          int32
	IncidentNumber int32
	ReportEntry    int32
}

type AttachReportEntryToStayParams

type AttachReportEntryToStayParams struct {
	Event       int32
	StayNumber  int32
	ReportEntry int32
}

type AttachStayToIncidentParams

type AttachStayToIncidentParams struct {
	IncidentNumber sql.NullInt32
	Event          int32
	Number         int32
}

type ClearEventAccessForExpressionParams

type ClearEventAccessForExpressionParams struct {
	Event      int32
	Expression string
}

type ClearEventAccessForModeParams

type ClearEventAccessForModeParams struct {
	Event int32
	Mode  EventAccessMode
}

type ConcentricStreet

type ConcentricStreet struct {
	Event int32
	ID    string
	Name  string
}

type ConcentricStreetsRow

type ConcentricStreetsRow struct {
	ConcentricStreet ConcentricStreet
}

type CreateConcentricStreetParams

type CreateConcentricStreetParams struct {
	Event int32
	ID    string
	Name  string
}

type CreateDestinationParams

type CreateDestinationParams struct {
	Event          int32
	Number         int32
	Type           DestinationType
	Name           string
	LocationString string
	ExternalData   json.RawMessage
}

type CreateEventParams

type CreateEventParams struct {
	Name        string
	IsGroup     bool
	ParentGroup sql.NullInt32
}

type CreateFieldReportParams

type CreateFieldReportParams struct {
	Event          int32
	Number         int32
	Created        float64
	Summary        sql.NullString
	IncidentNumber sql.NullInt32
}

type CreateIncidentParams

type CreateIncidentParams struct {
	Event    int32
	Number   int32
	Created  float64
	Priority int8
	State    IncidentState
	Started  float64
}

type CreateIncidentTypeParams

type CreateIncidentTypeParams struct {
	Name   string
	Hidden bool
}

type CreateReportEntryParams

type CreateReportEntryParams struct {
	Author                   string
	Text                     string
	Created                  float64
	Generated                bool
	Stricken                 bool
	AttachedFile             sql.NullString
	AttachedFileOriginalName sql.NullString
	AttachedFileMediaType    sql.NullString
}

type CreateStayParams

type CreateStayParams struct {
	Event   int32
	Number  int32
	Created float64
}

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 Destination

type Destination struct {
	Event          int32
	Type           DestinationType
	Number         int32
	Name           string
	LocationString string
	ExternalData   json.RawMessage
}

type DestinationType

type DestinationType string
const (
	DestinationTypeCamp  DestinationType = "camp"
	DestinationTypeArt   DestinationType = "art"
	DestinationTypeOther DestinationType = "other"
)

func AllDestinationTypeValues

func AllDestinationTypeValues() []DestinationType

func (*DestinationType) Scan

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

func (DestinationType) Valid

func (e DestinationType) Valid() bool

type DestinationsParams

type DestinationsParams struct {
	ExcludeExternalData interface{}
	Event               int32
}

type DestinationsRow

type DestinationsRow struct {
	Event          int32
	Type           DestinationType
	Number         int32
	Name           string
	LocationString string
	ExternalData   interface{}
}

type DetachIncidentTypeFromIncidentParams

type DetachIncidentTypeFromIncidentParams struct {
	Event          int32
	IncidentNumber int32
	IncidentType   int32
}

type DetachRangerFromStayParams

type DetachRangerFromStayParams struct {
	Event        int32
	StayNumber   int32
	RangerHandle string
}

type DetachRangerHandleFromIncidentParams

type DetachRangerHandleFromIncidentParams struct {
	Event          int32
	IncidentNumber int32
	RangerHandle   string
}

type Event

type Event struct {
	ID          int32
	Name        string
	IsGroup     bool
	ParentGroup sql.NullInt32
}

type EventAccess

type EventAccess struct {
	ID         int32
	Event      int32
	Expression string
	Mode       EventAccessMode
	Validity   EventAccessValidity
	Expires    sql.NullFloat64
}

type EventAccessAllRow

type EventAccessAllRow struct {
	EventAccess EventAccess
}

type EventAccessMode

type EventAccessMode string
const (
	EventAccessModeRead       EventAccessMode = "read"
	EventAccessModeWrite      EventAccessMode = "write"
	EventAccessModeReport     EventAccessMode = "report"
	EventAccessModeWriteStays EventAccessMode = "write_stays"
)

func AllEventAccessModeValues

func AllEventAccessModeValues() []EventAccessMode

func (*EventAccessMode) Scan

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

func (EventAccessMode) Valid

func (e EventAccessMode) Valid() bool

type EventAccessValidity

type EventAccessValidity string
const (
	EventAccessValidityAlways EventAccessValidity = "always"
	EventAccessValidityOnsite EventAccessValidity = "onsite"
)

func AllEventAccessValidityValues

func AllEventAccessValidityValues() []EventAccessValidity

func (*EventAccessValidity) Scan

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

func (EventAccessValidity) Valid

func (e EventAccessValidity) Valid() bool

type EventAndParentAccessParams

type EventAndParentAccessParams struct {
	EventID int32
}

type EventAndParentAccessRow

type EventAndParentAccessRow struct {
	EventAccess EventAccess
}

type EventRow

type EventRow struct {
	Event Event
}

type EventsRow

type EventsRow struct {
	Event Event
}

type FieldReport

type FieldReport struct {
	Event          int32
	Number         int32
	Created        float64
	Summary        sql.NullString
	IncidentNumber sql.NullInt32
}

type FieldReportParams

type FieldReportParams struct {
	Event  int32
	Number int32
}

type FieldReportReportEntry

type FieldReportReportEntry struct {
	Event             int32
	FieldReportNumber int32
	ReportEntry       int32
}

type FieldReportRow

type FieldReportRow struct {
	FieldReport FieldReport
}

type FieldReport_ReportEntriesParams

type FieldReport_ReportEntriesParams struct {
	Event             int32
	FieldReportNumber int32
}

type FieldReport_ReportEntriesRow

type FieldReport_ReportEntriesRow struct {
	ReportEntry ReportEntry
}

type FieldReportsRow

type FieldReportsRow struct {
	FieldReport FieldReport
}

type FieldReports_ReportEntriesParams

type FieldReports_ReportEntriesParams struct {
	Event     int32
	Generated bool
}

type FieldReports_ReportEntriesRow

type FieldReports_ReportEntriesRow struct {
	FieldReportNumber int32
	ReportEntry       ReportEntry
}

type Incident

type Incident struct {
	Event                int32
	Number               int32
	Created              float64
	Priority             int8
	State                IncidentState
	Started              float64
	Closed               sql.NullFloat64
	Summary              sql.NullString
	LocationName         sql.NullString
	LocationAddress      sql.NullString
	LocationConcentric   sql.NullString
	LocationRadialHour   sql.NullInt16
	LocationRadialMinute sql.NullInt16
	LocationDescription  sql.NullString
}

type IncidentIncidentType

type IncidentIncidentType struct {
	Event          int32
	IncidentNumber int32
	IncidentType   int32
}

type IncidentLinkedIncident

type IncidentLinkedIncident struct {
	Event1          int32
	IncidentNumber1 int32
	Event2          int32
	IncidentNumber2 int32
}

type IncidentParams

type IncidentParams struct {
	Event  int32
	Number int32
}

type IncidentRanger

type IncidentRanger struct {
	ID             int32
	Event          int32
	IncidentNumber int32
	RangerHandle   string
	Role           sql.NullString
}

type IncidentReportEntry

type IncidentReportEntry struct {
	Event          int32
	IncidentNumber int32
	ReportEntry    int32
}

type IncidentRow

type IncidentRow struct {
	Incident           Incident
	IncidentTypeIds    interface{}
	FieldReportNumbers interface{}
	StayNumbers        interface{}
}

type IncidentState

type IncidentState string
const (
	IncidentStateNew        IncidentState = "new"
	IncidentStateOnHold     IncidentState = "on_hold"
	IncidentStateDispatched IncidentState = "dispatched"
	IncidentStateOnScene    IncidentState = "on_scene"
	IncidentStateClosed     IncidentState = "closed"
)

func AllIncidentStateValues

func AllIncidentStateValues() []IncidentState

func (*IncidentState) Scan

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

func (IncidentState) Valid

func (e IncidentState) Valid() bool

type IncidentType

type IncidentType struct {
	ID          int32
	Name        string
	Hidden      bool
	Description sql.NullString
}

type IncidentTypeRow

type IncidentTypeRow struct {
	IncidentType IncidentType
}

type IncidentTypesRow

type IncidentTypesRow struct {
	IncidentType IncidentType
}

type Incident_LinkedIncidentsParams

type Incident_LinkedIncidentsParams struct {
	Event1          int32
	IncidentNumber1 int32
}

type Incident_LinkedIncidentsRow

type Incident_LinkedIncidentsRow struct {
	LinkedEvent           int32
	LinkedEventName       string
	LinkedIncident        int32
	LinkedIncidentSummary sql.NullString
}

type Incident_RangersParams

type Incident_RangersParams struct {
	Event          int32
	IncidentNumber int32
}

type Incident_RangersRow

type Incident_RangersRow struct {
	IncidentRanger IncidentRanger
}

type Incident_ReportEntriesParams

type Incident_ReportEntriesParams struct {
	Event          int32
	IncidentNumber int32
}

type Incident_ReportEntriesRow

type Incident_ReportEntriesRow struct {
	IncidentNumber int32
	ReportEntry    ReportEntry
}

type IncidentsRow

type IncidentsRow struct {
	Incident           Incident
	IncidentTypeIds    interface{}
	FieldReportNumbers interface{}
	StayNumbers        interface{}
}

type Incidents_RangersRow

type Incidents_RangersRow struct {
	IncidentRanger IncidentRanger
}

type Incidents_ReportEntriesParams

type Incidents_ReportEntriesParams struct {
	Event     int32
	Generated bool
}

type Incidents_ReportEntriesRow

type Incidents_ReportEntriesRow struct {
	IncidentNumber int32
	ReportEntry    ReportEntry
}

type LinkIncidentsParams

type LinkIncidentsParams struct {
	Event1          int32
	IncidentNumber1 int32
	Event2          int32
	IncidentNumber2 int32
}

type NullDestinationType

type NullDestinationType struct {
	DestinationType DestinationType
	Valid           bool // Valid is true if DestinationType is not NULL
}

func (*NullDestinationType) Scan

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

Scan implements the Scanner interface.

func (NullDestinationType) Value

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

Value implements the driver Valuer interface.

type NullEventAccessMode

type NullEventAccessMode struct {
	EventAccessMode EventAccessMode
	Valid           bool // Valid is true if EventAccessMode is not NULL
}

func (*NullEventAccessMode) Scan

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

Scan implements the Scanner interface.

func (NullEventAccessMode) Value

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

Value implements the driver Valuer interface.

type NullEventAccessValidity

type NullEventAccessValidity struct {
	EventAccessValidity EventAccessValidity
	Valid               bool // Valid is true if EventAccessValidity is not NULL
}

func (*NullEventAccessValidity) Scan

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

Scan implements the Scanner interface.

func (NullEventAccessValidity) Value

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

Value implements the driver Valuer interface.

type NullIncidentState

type NullIncidentState struct {
	IncidentState IncidentState
	Valid         bool // Valid is true if IncidentState is not NULL
}

func (*NullIncidentState) Scan

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

Scan implements the Scanner interface.

func (NullIncidentState) Value

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

Value implements the driver Valuer interface.

type Querier

type Querier interface {
	ActionLogs(ctx context.Context, db DBTX, arg ActionLogsParams) ([]ActionLogsRow, error)
	AddActionLog(ctx context.Context, db DBTX, arg AddActionLogParams) (int64, error)
	AddEventAccess(ctx context.Context, db DBTX, arg AddEventAccessParams) (int64, error)
	AttachFieldReportToIncident(ctx context.Context, db DBTX, arg AttachFieldReportToIncidentParams) error
	AttachIncidentTypeToIncident(ctx context.Context, db DBTX, arg AttachIncidentTypeToIncidentParams) error
	AttachRangerHandleToIncident(ctx context.Context, db DBTX, arg AttachRangerHandleToIncidentParams) error
	AttachRangerToStay(ctx context.Context, db DBTX, arg AttachRangerToStayParams) error
	AttachReportEntryToFieldReport(ctx context.Context, db DBTX, arg AttachReportEntryToFieldReportParams) error
	AttachReportEntryToIncident(ctx context.Context, db DBTX, arg AttachReportEntryToIncidentParams) error
	AttachReportEntryToStay(ctx context.Context, db DBTX, arg AttachReportEntryToStayParams) error
	AttachStayToIncident(ctx context.Context, db DBTX, arg AttachStayToIncidentParams) error
	ClearEventAccessForExpression(ctx context.Context, db DBTX, arg ClearEventAccessForExpressionParams) error
	ClearEventAccessForMode(ctx context.Context, db DBTX, arg ClearEventAccessForModeParams) error
	ConcentricStreets(ctx context.Context, db DBTX, event int32) ([]ConcentricStreetsRow, error)
	CreateConcentricStreet(ctx context.Context, db DBTX, arg CreateConcentricStreetParams) error
	CreateDestination(ctx context.Context, db DBTX, arg CreateDestinationParams) error
	CreateEvent(ctx context.Context, db DBTX, arg CreateEventParams) (int64, error)
	CreateFieldReport(ctx context.Context, db DBTX, arg CreateFieldReportParams) error
	CreateIncident(ctx context.Context, db DBTX, arg CreateIncidentParams) (int64, error)
	CreateIncidentType(ctx context.Context, db DBTX, arg CreateIncidentTypeParams) (int64, error)
	CreateReportEntry(ctx context.Context, db DBTX, arg CreateReportEntryParams) (int64, error)
	CreateStay(ctx context.Context, db DBTX, arg CreateStayParams) (int64, error)
	Destinations(ctx context.Context, db DBTX, arg DestinationsParams) ([]DestinationsRow, error)
	DetachIncidentTypeFromIncident(ctx context.Context, db DBTX, arg DetachIncidentTypeFromIncidentParams) error
	DetachRangerFromStay(ctx context.Context, db DBTX, arg DetachRangerFromStayParams) error
	DetachRangerHandleFromIncident(ctx context.Context, db DBTX, arg DetachRangerHandleFromIncidentParams) error
	Event(ctx context.Context, db DBTX, id int32) (EventRow, error)
	EventAccessAll(ctx context.Context, db DBTX) ([]EventAccessAllRow, error)
	// This returns access for a target event, as well as for that event's
	// parent group, if any. If the target event *is* a group, this query
	// will return nothing. That's intentional, and it helps prevent people
	// from adding incidents or FRs to event groups as though those were events.
	EventAndParentAccess(ctx context.Context, db DBTX, arg EventAndParentAccessParams) ([]EventAndParentAccessRow, error)
	Events(ctx context.Context, db DBTX) ([]EventsRow, error)
	FieldReport(ctx context.Context, db DBTX, arg FieldReportParams) (FieldReportRow, error)
	FieldReport_ReportEntries(ctx context.Context, db DBTX, arg FieldReport_ReportEntriesParams) ([]FieldReport_ReportEntriesRow, error)
	FieldReports(ctx context.Context, db DBTX, event int32) ([]FieldReportsRow, error)
	FieldReports_ReportEntries(ctx context.Context, db DBTX, arg FieldReports_ReportEntriesParams) ([]FieldReports_ReportEntriesRow, error)
	Incident(ctx context.Context, db DBTX, arg IncidentParams) (IncidentRow, error)
	IncidentType(ctx context.Context, db DBTX, id int32) (IncidentTypeRow, error)
	IncidentTypes(ctx context.Context, db DBTX) ([]IncidentTypesRow, error)
	Incident_LinkedIncidents(ctx context.Context, db DBTX, arg Incident_LinkedIncidentsParams) ([]Incident_LinkedIncidentsRow, error)
	Incident_Rangers(ctx context.Context, db DBTX, arg Incident_RangersParams) ([]Incident_RangersRow, error)
	Incident_ReportEntries(ctx context.Context, db DBTX, arg Incident_ReportEntriesParams) ([]Incident_ReportEntriesRow, error)
	Incidents(ctx context.Context, db DBTX, event int32) ([]IncidentsRow, error)
	Incidents_Rangers(ctx context.Context, db DBTX, event int32) ([]Incidents_RangersRow, error)
	Incidents_ReportEntries(ctx context.Context, db DBTX, arg Incidents_ReportEntriesParams) ([]Incidents_ReportEntriesRow, error)
	LinkIncidents(ctx context.Context, db DBTX, arg LinkIncidentsParams) error
	// This doesn't use "MAX" because sqlc can't figure out the type for aggregations :(.
	NextFieldReportNumber(ctx context.Context, db DBTX, event int32) (int32, error)
	// This doesn't use "MAX" because sqlc can't figure out the type for aggregations :(.
	NextIncidentNumber(ctx context.Context, db DBTX, event int32) (int32, error)
	// This doesn't use "MAX" because sqlc can't figure out the type for aggregations :(.
	NextStayNumber(ctx context.Context, db DBTX, event int32) (int32, error)
	QueryEventID(ctx context.Context, db DBTX, name string) (QueryEventIDRow, error)
	RemoveDestinations(ctx context.Context, db DBTX, arg RemoveDestinationsParams) error
	SchemaVersion(ctx context.Context, db DBTX) (int16, error)
	SetFieldReportReportEntryStricken(ctx context.Context, db DBTX, arg SetFieldReportReportEntryStrickenParams) error
	//
	// The "stricken" queries seem bloated at first blush, because the whole
	// "where ID in (..." could just be "where ID =". What it's doing though is
	// ensuring that the provided eventID and incidentNumber actually align with
	// the reportEntryID in question, and that's important for authorization purposes.
	//
	SetIncidentReportEntryStricken(ctx context.Context, db DBTX, arg SetIncidentReportEntryStrickenParams) error
	SetStayReportEntryStricken(ctx context.Context, db DBTX, arg SetStayReportEntryStrickenParams) error
	Stay(ctx context.Context, db DBTX, arg StayParams) (StayRow, error)
	Stay_Rangers(ctx context.Context, db DBTX, arg Stay_RangersParams) ([]Stay_RangersRow, error)
	Stay_ReportEntries(ctx context.Context, db DBTX, arg Stay_ReportEntriesParams) ([]Stay_ReportEntriesRow, error)
	Stays(ctx context.Context, db DBTX, event int32) ([]StaysRow, error)
	Stays_Rangers(ctx context.Context, db DBTX, event int32) ([]Stays_RangersRow, error)
	Stays_ReportEntries(ctx context.Context, db DBTX, arg Stays_ReportEntriesParams) ([]Stays_ReportEntriesRow, error)
	UnlinkIncidents(ctx context.Context, db DBTX, arg UnlinkIncidentsParams) error
	UpdateEvent(ctx context.Context, db DBTX, arg UpdateEventParams) error
	UpdateFieldReport(ctx context.Context, db DBTX, arg UpdateFieldReportParams) error
	UpdateIncident(ctx context.Context, db DBTX, arg UpdateIncidentParams) error
	UpdateIncidentType(ctx context.Context, db DBTX, arg UpdateIncidentTypeParams) error
	UpdateStay(ctx context.Context, db DBTX, arg UpdateStayParams) error
}

type Queries

type Queries struct {
}

func New

func New() *Queries

func (*Queries) ActionLogs

func (q *Queries) ActionLogs(ctx context.Context, db DBTX, arg ActionLogsParams) ([]ActionLogsRow, error)

func (*Queries) AddActionLog

func (q *Queries) AddActionLog(ctx context.Context, db DBTX, arg AddActionLogParams) (int64, error)

func (*Queries) AddEventAccess

func (q *Queries) AddEventAccess(ctx context.Context, db DBTX, arg AddEventAccessParams) (int64, error)

func (*Queries) AttachFieldReportToIncident

func (q *Queries) AttachFieldReportToIncident(ctx context.Context, db DBTX, arg AttachFieldReportToIncidentParams) error

func (*Queries) AttachIncidentTypeToIncident

func (q *Queries) AttachIncidentTypeToIncident(ctx context.Context, db DBTX, arg AttachIncidentTypeToIncidentParams) error

func (*Queries) AttachRangerHandleToIncident

func (q *Queries) AttachRangerHandleToIncident(ctx context.Context, db DBTX, arg AttachRangerHandleToIncidentParams) error

func (*Queries) AttachRangerToStay

func (q *Queries) AttachRangerToStay(ctx context.Context, db DBTX, arg AttachRangerToStayParams) error

func (*Queries) AttachReportEntryToFieldReport

func (q *Queries) AttachReportEntryToFieldReport(ctx context.Context, db DBTX, arg AttachReportEntryToFieldReportParams) error

func (*Queries) AttachReportEntryToIncident

func (q *Queries) AttachReportEntryToIncident(ctx context.Context, db DBTX, arg AttachReportEntryToIncidentParams) error

func (*Queries) AttachReportEntryToStay

func (q *Queries) AttachReportEntryToStay(ctx context.Context, db DBTX, arg AttachReportEntryToStayParams) error

func (*Queries) AttachStayToIncident

func (q *Queries) AttachStayToIncident(ctx context.Context, db DBTX, arg AttachStayToIncidentParams) error

func (*Queries) ClearEventAccessForExpression

func (q *Queries) ClearEventAccessForExpression(ctx context.Context, db DBTX, arg ClearEventAccessForExpressionParams) error

func (*Queries) ClearEventAccessForMode

func (q *Queries) ClearEventAccessForMode(ctx context.Context, db DBTX, arg ClearEventAccessForModeParams) error

func (*Queries) ConcentricStreets

func (q *Queries) ConcentricStreets(ctx context.Context, db DBTX, event int32) ([]ConcentricStreetsRow, error)

func (*Queries) CreateConcentricStreet

func (q *Queries) CreateConcentricStreet(ctx context.Context, db DBTX, arg CreateConcentricStreetParams) error

func (*Queries) CreateDestination

func (q *Queries) CreateDestination(ctx context.Context, db DBTX, arg CreateDestinationParams) error

func (*Queries) CreateEvent

func (q *Queries) CreateEvent(ctx context.Context, db DBTX, arg CreateEventParams) (int64, error)

func (*Queries) CreateFieldReport

func (q *Queries) CreateFieldReport(ctx context.Context, db DBTX, arg CreateFieldReportParams) error

func (*Queries) CreateIncident

func (q *Queries) CreateIncident(ctx context.Context, db DBTX, arg CreateIncidentParams) (int64, error)

func (*Queries) CreateIncidentType

func (q *Queries) CreateIncidentType(ctx context.Context, db DBTX, arg CreateIncidentTypeParams) (int64, error)

func (*Queries) CreateReportEntry

func (q *Queries) CreateReportEntry(ctx context.Context, db DBTX, arg CreateReportEntryParams) (int64, error)

func (*Queries) CreateStay

func (q *Queries) CreateStay(ctx context.Context, db DBTX, arg CreateStayParams) (int64, error)

func (*Queries) Destinations

func (q *Queries) Destinations(ctx context.Context, db DBTX, arg DestinationsParams) ([]DestinationsRow, error)

func (*Queries) DetachIncidentTypeFromIncident

func (q *Queries) DetachIncidentTypeFromIncident(ctx context.Context, db DBTX, arg DetachIncidentTypeFromIncidentParams) error

func (*Queries) DetachRangerFromStay

func (q *Queries) DetachRangerFromStay(ctx context.Context, db DBTX, arg DetachRangerFromStayParams) error

func (*Queries) DetachRangerHandleFromIncident

func (q *Queries) DetachRangerHandleFromIncident(ctx context.Context, db DBTX, arg DetachRangerHandleFromIncidentParams) error

func (*Queries) Event

func (q *Queries) Event(ctx context.Context, db DBTX, id int32) (EventRow, error)

func (*Queries) EventAccessAll

func (q *Queries) EventAccessAll(ctx context.Context, db DBTX) ([]EventAccessAllRow, error)

func (*Queries) EventAndParentAccess

func (q *Queries) EventAndParentAccess(ctx context.Context, db DBTX, arg EventAndParentAccessParams) ([]EventAndParentAccessRow, error)

This returns access for a target event, as well as for that event's parent group, if any. If the target event *is* a group, this query will return nothing. That's intentional, and it helps prevent people from adding incidents or FRs to event groups as though those were events.

func (*Queries) Events

func (q *Queries) Events(ctx context.Context, db DBTX) ([]EventsRow, error)

func (*Queries) FieldReport

func (q *Queries) FieldReport(ctx context.Context, db DBTX, arg FieldReportParams) (FieldReportRow, error)

func (*Queries) FieldReport_ReportEntries

func (q *Queries) FieldReport_ReportEntries(ctx context.Context, db DBTX, arg FieldReport_ReportEntriesParams) ([]FieldReport_ReportEntriesRow, error)

func (*Queries) FieldReports

func (q *Queries) FieldReports(ctx context.Context, db DBTX, event int32) ([]FieldReportsRow, error)

func (*Queries) FieldReports_ReportEntries

func (q *Queries) FieldReports_ReportEntries(ctx context.Context, db DBTX, arg FieldReports_ReportEntriesParams) ([]FieldReports_ReportEntriesRow, error)

func (*Queries) Incident

func (q *Queries) Incident(ctx context.Context, db DBTX, arg IncidentParams) (IncidentRow, error)

func (*Queries) IncidentType

func (q *Queries) IncidentType(ctx context.Context, db DBTX, id int32) (IncidentTypeRow, error)

func (*Queries) IncidentTypes

func (q *Queries) IncidentTypes(ctx context.Context, db DBTX) ([]IncidentTypesRow, error)

func (*Queries) Incident_LinkedIncidents

func (q *Queries) Incident_LinkedIncidents(ctx context.Context, db DBTX, arg Incident_LinkedIncidentsParams) ([]Incident_LinkedIncidentsRow, error)

func (*Queries) Incident_Rangers

func (q *Queries) Incident_Rangers(ctx context.Context, db DBTX, arg Incident_RangersParams) ([]Incident_RangersRow, error)

func (*Queries) Incident_ReportEntries

func (q *Queries) Incident_ReportEntries(ctx context.Context, db DBTX, arg Incident_ReportEntriesParams) ([]Incident_ReportEntriesRow, error)

func (*Queries) Incidents

func (q *Queries) Incidents(ctx context.Context, db DBTX, event int32) ([]IncidentsRow, error)

func (*Queries) Incidents_Rangers

func (q *Queries) Incidents_Rangers(ctx context.Context, db DBTX, event int32) ([]Incidents_RangersRow, error)

func (*Queries) Incidents_ReportEntries

func (q *Queries) Incidents_ReportEntries(ctx context.Context, db DBTX, arg Incidents_ReportEntriesParams) ([]Incidents_ReportEntriesRow, error)

func (*Queries) LinkIncidents

func (q *Queries) LinkIncidents(ctx context.Context, db DBTX, arg LinkIncidentsParams) error

func (*Queries) NextFieldReportNumber

func (q *Queries) NextFieldReportNumber(ctx context.Context, db DBTX, event int32) (int32, error)

This doesn't use "MAX" because sqlc can't figure out the type for aggregations :(.

func (*Queries) NextIncidentNumber

func (q *Queries) NextIncidentNumber(ctx context.Context, db DBTX, event int32) (int32, error)

This doesn't use "MAX" because sqlc can't figure out the type for aggregations :(.

func (*Queries) NextStayNumber

func (q *Queries) NextStayNumber(ctx context.Context, db DBTX, event int32) (int32, error)

This doesn't use "MAX" because sqlc can't figure out the type for aggregations :(.

func (*Queries) QueryEventID

func (q *Queries) QueryEventID(ctx context.Context, db DBTX, name string) (QueryEventIDRow, error)

func (*Queries) RemoveDestinations

func (q *Queries) RemoveDestinations(ctx context.Context, db DBTX, arg RemoveDestinationsParams) error

func (*Queries) SchemaVersion

func (q *Queries) SchemaVersion(ctx context.Context, db DBTX) (int16, error)

func (*Queries) SetFieldReportReportEntryStricken

func (q *Queries) SetFieldReportReportEntryStricken(ctx context.Context, db DBTX, arg SetFieldReportReportEntryStrickenParams) error

func (*Queries) SetIncidentReportEntryStricken

func (q *Queries) SetIncidentReportEntryStricken(ctx context.Context, db DBTX, arg SetIncidentReportEntryStrickenParams) error

The "stricken" queries seem bloated at first blush, because the whole "where ID in (..." could just be "where ID =". What it's doing though is ensuring that the provided eventID and incidentNumber actually align with the reportEntryID in question, and that's important for authorization purposes.

func (*Queries) SetStayReportEntryStricken

func (q *Queries) SetStayReportEntryStricken(ctx context.Context, db DBTX, arg SetStayReportEntryStrickenParams) error

func (*Queries) Stay

func (q *Queries) Stay(ctx context.Context, db DBTX, arg StayParams) (StayRow, error)

func (*Queries) Stay_Rangers

func (q *Queries) Stay_Rangers(ctx context.Context, db DBTX, arg Stay_RangersParams) ([]Stay_RangersRow, error)

func (*Queries) Stay_ReportEntries

func (q *Queries) Stay_ReportEntries(ctx context.Context, db DBTX, arg Stay_ReportEntriesParams) ([]Stay_ReportEntriesRow, error)

func (*Queries) Stays

func (q *Queries) Stays(ctx context.Context, db DBTX, event int32) ([]StaysRow, error)

func (*Queries) Stays_Rangers

func (q *Queries) Stays_Rangers(ctx context.Context, db DBTX, event int32) ([]Stays_RangersRow, error)

func (*Queries) Stays_ReportEntries

func (q *Queries) Stays_ReportEntries(ctx context.Context, db DBTX, arg Stays_ReportEntriesParams) ([]Stays_ReportEntriesRow, error)

func (*Queries) UnlinkIncidents

func (q *Queries) UnlinkIncidents(ctx context.Context, db DBTX, arg UnlinkIncidentsParams) error

func (*Queries) UpdateEvent

func (q *Queries) UpdateEvent(ctx context.Context, db DBTX, arg UpdateEventParams) error

func (*Queries) UpdateFieldReport

func (q *Queries) UpdateFieldReport(ctx context.Context, db DBTX, arg UpdateFieldReportParams) error

func (*Queries) UpdateIncident

func (q *Queries) UpdateIncident(ctx context.Context, db DBTX, arg UpdateIncidentParams) error

func (*Queries) UpdateIncidentType

func (q *Queries) UpdateIncidentType(ctx context.Context, db DBTX, arg UpdateIncidentTypeParams) error

func (*Queries) UpdateStay

func (q *Queries) UpdateStay(ctx context.Context, db DBTX, arg UpdateStayParams) error

type QueryEventIDRow

type QueryEventIDRow struct {
	Event Event
}

type RemoveDestinationsParams

type RemoveDestinationsParams struct {
	Event int32
	Type  DestinationType
}

type ReportEntry

type ReportEntry struct {
	ID                       int32
	Author                   string
	Text                     string
	Created                  float64
	Generated                bool
	Stricken                 bool
	AttachedFile             sql.NullString
	AttachedFileOriginalName sql.NullString
	AttachedFileMediaType    sql.NullString
}

type SchemaInfo

type SchemaInfo struct {
	Version int16
}

type SetFieldReportReportEntryStrickenParams

type SetFieldReportReportEntryStrickenParams struct {
	Stricken          bool
	Event             int32
	FieldReportNumber int32
	ReportEntry       int32
}

type SetIncidentReportEntryStrickenParams

type SetIncidentReportEntryStrickenParams struct {
	Stricken       bool
	Event          int32
	IncidentNumber int32
	ReportEntry    int32
}

type SetStayReportEntryStrickenParams

type SetStayReportEntryStrickenParams struct {
	Stricken    bool
	Event       int32
	StayNumber  int32
	ReportEntry int32
}

type Stay

type Stay struct {
	Event                int32
	Number               int32
	Created              float64
	IncidentNumber       sql.NullInt32
	GuestPreferredName   sql.NullString
	GuestLegalName       sql.NullString
	GuestDescription     sql.NullString
	GuestCampName        sql.NullString
	GuestCampAddress     sql.NullString
	GuestCampDescription sql.NullString
	ArrivalTime          sql.NullFloat64
	ArrivalMethod        sql.NullString
	ArrivalState         sql.NullString
	ArrivalReason        sql.NullString
	ArrivalBelongings    sql.NullString
	DepartureTime        sql.NullFloat64
	DepartureMethod      sql.NullString
	DepartureState       sql.NullString
	ResourceRest         sql.NullString
	ResourceClothes      sql.NullString
	ResourcePogs         sql.NullString
	ResourceFoodBev      sql.NullString
	ResourceOther        sql.NullString
}

type StayParams

type StayParams struct {
	Event  int32
	Number int32
}

type StayRanger

type StayRanger struct {
	ID           int32
	Event        int32
	StayNumber   int32
	RangerHandle string
	Role         sql.NullString
}

type StayReportEntry

type StayReportEntry struct {
	Event       int32
	StayNumber  int32
	ReportEntry int32
}

type StayRow

type StayRow struct {
	Stay Stay
}

type Stay_RangersParams

type Stay_RangersParams struct {
	Event      int32
	StayNumber int32
}

type Stay_RangersRow

type Stay_RangersRow struct {
	StayRanger StayRanger
}

type Stay_ReportEntriesParams

type Stay_ReportEntriesParams struct {
	Event      int32
	StayNumber int32
}

type Stay_ReportEntriesRow

type Stay_ReportEntriesRow struct {
	StayNumber  int32
	ReportEntry ReportEntry
}

type StaysRow

type StaysRow struct {
	Stay Stay
}

type Stays_RangersRow

type Stays_RangersRow struct {
	StayRanger StayRanger
}

type Stays_ReportEntriesParams

type Stays_ReportEntriesParams struct {
	Event     int32
	Generated bool
}

type Stays_ReportEntriesRow

type Stays_ReportEntriesRow struct {
	StayNumber  int32
	ReportEntry ReportEntry
}

type UnlinkIncidentsParams

type UnlinkIncidentsParams struct {
	Event1          int32
	IncidentNumber1 int32
	Event2          int32
	IncidentNumber2 int32
}

type UpdateEventParams

type UpdateEventParams struct {
	Name        string
	IsGroup     bool
	ParentGroup sql.NullInt32
	ID          int32
}

type UpdateFieldReportParams

type UpdateFieldReportParams struct {
	Summary        sql.NullString
	IncidentNumber sql.NullInt32
	Event          int32
	Number         int32
}

type UpdateIncidentParams

type UpdateIncidentParams struct {
	Priority             int8
	State                IncidentState
	Started              float64
	Closed               sql.NullFloat64
	Summary              sql.NullString
	LocationName         sql.NullString
	LocationAddress      sql.NullString
	LocationConcentric   sql.NullString
	LocationRadialHour   sql.NullInt16
	LocationRadialMinute sql.NullInt16
	LocationDescription  sql.NullString
	Event                int32
	Number               int32
}

type UpdateIncidentTypeParams

type UpdateIncidentTypeParams struct {
	Hidden      bool
	Name        string
	Description sql.NullString
	ID          int32
}

type UpdateStayParams

type UpdateStayParams struct {
	IncidentNumber       sql.NullInt32
	GuestPreferredName   sql.NullString
	GuestLegalName       sql.NullString
	GuestDescription     sql.NullString
	GuestCampName        sql.NullString
	GuestCampAddress     sql.NullString
	GuestCampDescription sql.NullString
	ArrivalTime          sql.NullFloat64
	ArrivalMethod        sql.NullString
	ArrivalState         sql.NullString
	ArrivalReason        sql.NullString
	ArrivalBelongings    sql.NullString
	DepartureTime        sql.NullFloat64
	DepartureMethod      sql.NullString
	DepartureState       sql.NullString
	ResourceRest         sql.NullString
	ResourceClothes      sql.NullString
	ResourcePogs         sql.NullString
	ResourceFoodBev      sql.NullString
	ResourceOther        sql.NullString
	Event                int32
	Number               int32
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL