Versions in this module Expand all Collapse all v0 v0.0.5 Dec 15, 2025 v0.0.4 Dec 15, 2025 v0.0.3 Dec 11, 2025 Changes in this version + var PGInstance *postgres + func InitializeDatabase(ctx context.Context, uri string) error + func LogErrorTypeInfo(err error) + func SaveOrUpdateAerialSprayLine(ctx context.Context, org *models.Organization, fs []*fslayer.AerialSprayLine) (inserts uint, updates uint, err error) + func SaveOrUpdateAerialSpraySession(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateBarrierSpray(ctx context.Context, org *models.Organization, fs []*fslayer.BarrierSpray) (inserts uint, updates uint, err error) + func SaveOrUpdateBarrierSprayRoute(ctx context.Context, org *models.Organization, fs []*fslayer.BarrierSprayRoute) (inserts uint, updates uint, err error) + func SaveOrUpdateContainerRelate(ctx context.Context, org *models.Organization, fs []*fslayer.ContainerRelate) (inserts uint, updates uint, err error) + func SaveOrUpdateFieldScoutingLog(ctx context.Context, org *models.Organization, fs []*fslayer.FieldScoutingLog) (inserts uint, updates uint, err error) + func SaveOrUpdateHabitatRelate(ctx context.Context, org *models.Organization, fs []*fslayer.HabitatRelate) (inserts uint, updates uint, err error) + func SaveOrUpdateInspectionSample(ctx context.Context, org *models.Organization, fs []*fslayer.InspectionSample) (inserts uint, updates uint, err error) + func SaveOrUpdateInspectionSampleDetail(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateLandingCount(ctx context.Context, org *models.Organization, fs []*fslayer.LandingCount) (inserts uint, updates uint, err error) + func SaveOrUpdateLandingCountLocation(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateLineLocation(ctx context.Context, org *models.Organization, fs []*fslayer.LineLocation) (inserts uint, updates uint, err error) + func SaveOrUpdateLocationTracking(ctx context.Context, org *models.Organization, fs []*fslayer.LocationTracking) (inserts uint, updates uint, err error) + func SaveOrUpdateMosquitoInspection(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateOfflineMapAreas(ctx context.Context, org *models.Organization, fs []*fslayer.OfflineMapAreas) (inserts uint, updates uint, err error) + func SaveOrUpdatePointLocation(ctx context.Context, org *models.Organization, fs []*fslayer.PointLocation) (inserts uint, updates uint, err error) + func SaveOrUpdatePolygonLocation(ctx context.Context, org *models.Organization, fs []*fslayer.PolygonLocation) (inserts uint, updates uint, err error) + func SaveOrUpdatePool(ctx context.Context, org *models.Organization, fs []*fslayer.Pool) (inserts uint, updates uint, err error) + func SaveOrUpdatePoolBuffer(ctx context.Context, org *models.Organization, fs []*fslayer.PoolBuffer) (inserts uint, updates uint, err error) + func SaveOrUpdatePoolDetail(ctx context.Context, org *models.Organization, fs []*fslayer.PoolDetail) (inserts uint, updates uint, err error) + func SaveOrUpdateProposedTreatmentArea(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateQALarvCount(ctx context.Context, org *models.Organization, fs []*fslayer.QALarvCount) (inserts uint, updates uint, err error) + func SaveOrUpdateQAMosquitoInspection(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateQAProductObservation(ctx context.Context, org *models.Organization, ...) (inserts uint, updates uint, err error) + func SaveOrUpdateRestrictedArea(ctx context.Context, org *models.Organization, fs []*fslayer.RestrictedArea) (inserts uint, updates uint, err error) + func SaveOrUpdateRodentInspection(ctx context.Context, org *models.Organization, fs []*fslayer.RodentInspection) (inserts uint, updates uint, err error) + func SaveOrUpdateRodentLocation(ctx context.Context, org *models.Organization, fs []*fslayer.RodentLocation) (inserts uint, updates uint, err error) + func SaveOrUpdateSampleCollection(ctx context.Context, org *models.Organization, fs []*fslayer.SampleCollection) (inserts uint, updates uint, err error) + func SaveOrUpdateSampleLocation(ctx context.Context, org *models.Organization, fs []*fslayer.SampleLocation) (inserts uint, updates uint, err error) + func SaveOrUpdateServiceRequest(ctx context.Context, org *models.Organization, fs []*fslayer.ServiceRequest) (inserts uint, updates uint, err error) + func SaveOrUpdateSpeciesAbundance(ctx context.Context, org *models.Organization, fs []*fslayer.SpeciesAbundance) (inserts uint, updates uint, err error) + func SaveOrUpdateStormDrain(ctx context.Context, org *models.Organization, fs []*fslayer.StormDrain) (inserts uint, updates uint, err error) + func SaveOrUpdateTimeCard(ctx context.Context, org *models.Organization, fs []*fslayer.TimeCard) (inserts uint, updates uint, err error) + func SaveOrUpdateTracklog(ctx context.Context, org *models.Organization, fs []*fslayer.Tracklog) (inserts uint, updates uint, err error) + func SaveOrUpdateTrapData(ctx context.Context, org *models.Organization, fs []*fslayer.TrapData) (inserts uint, updates uint, err error) + func SaveOrUpdateTrapLocation(ctx context.Context, org *models.Organization, fs []*fslayer.TrapLocation) (inserts uint, updates uint, err error) + func SaveOrUpdateTreatment(ctx context.Context, org *models.Organization, fs []*fslayer.Treatment) (inserts uint, updates uint, err error) + func SaveOrUpdateTreatmentArea(ctx context.Context, org *models.Organization, fs []*fslayer.TreatmentArea) (inserts uint, updates uint, err error) + func SaveOrUpdateULVSprayRoute(ctx context.Context, org *models.Organization, fs []*fslayer.ULVSprayRoute) (inserts uint, updates uint, err error) + func SaveOrUpdateZones(ctx context.Context, org *models.Organization, fs []*fslayer.Zones) (inserts uint, updates uint, err error) + func SaveOrUpdateZones2(ctx context.Context, org *models.Organization, fs []*fslayer.Zones2) (inserts uint, updates uint, err error) + func TestPreparedQuery(ctx context.Context, row *fslayer.RodentLocation) error + func TestPreparedQueryOld(ctx context.Context) error + type BoolParam bool + func Bool(b bool) BoolParam + func (p BoolParam) ToSql() string + type EnumParam string + func Enum(n string, e Stringable) EnumParam + func (p EnumParam) ToSql() string + type Float64Param struct + Name string + Value float64 + func Float64(n string, f float64) Float64Param + func (p Float64Param) ToSql() string + type FloatParam float64 + func Float(f float64) FloatParam + func (p FloatParam) ToSql() string + type GISLineParam struct + Name string + Value GeometryLine + WKID int + func GISLine(n string, v GeometryLine, wkid int) GISLineParam + func (p GISLineParam) ToSql() string + type GISPointParam struct + Name string + Value GeometryPoint + WKID int + func GISPoint(n string, v GeometryPoint, wkid int) GISPointParam + func (p GISPointParam) ToSql() string + type GISPolygonParam struct + Name string + Value GeometryPolygon + WKID int + func GISPolygon(n string, v GeometryPolygon, wkid int) GISPolygonParam + func (p GISPolygonParam) ToSql() string + type GeometryLine struct + Paths [][][]float64 + type GeometryPoint struct + X float64 + Y float64 + type GeometryPolygon struct + Rings [][][]float64 + type InsertResultRow struct + Inserted bool + Version int + type Int16Param struct + Name string + Value int16 + func Int16(n string, i int16) Int16Param + func (p Int16Param) ToSql() string + type Int32Param struct + Name string + Value int32 + func Int32(n string, i int32) Int32Param + func (p Int32Param) ToSql() string + type Int64Param struct + Name string + Value int64 + func Int64(n string, i int64) Int64Param + func (p Int64Param) ToSql() string + type JsonBParam struct + Name string + Value json.RawMessage + func JsonB(n string, v json.RawMessage) JsonBParam + func (p JsonBParam) ToSql() string + type NullParam struct + Name string + func Null() NullParam + func (p NullParam) ToSql() string + type SqlParam interface + ToSql func() string + type StringParam struct + Name string + Value string + func String(n, s string) StringParam + func (p StringParam) ToSql() string + type Stringable interface + String func() string + type TimestampParam struct + Name string + Value time.Time + func Timestamp(name string, t time.Time) TimestampParam + func (p TimestampParam) ToSql() string + type TimestamptzParam time.Time + func Timestamptz(t time.Time) TimestamptzParam + func (p TimestamptzParam) ToSql() string + type UUIDParam struct + Name string + Value string + func UUID(name string, u uuid.UUID) UUIDParam + func (p UUIDParam) ToSql() string + type Uint32Param struct + Name string + Value uint32 + func Uint32(name string, u uint) Uint32Param + func (p Uint32Param) ToSql() string + type Uint64Param struct + Name string + Value uint64 + func Uint64(name string, u uint64) Uint64Param + func (p Uint64Param) ToSql() string + type UintParam struct + Name string + Value uint + func Uint(name string, u uint) UintParam + func (p UintParam) ToSql() string