pgdb

package
v0.0.0-...-0ee86d9 Latest Latest
Warning

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

 Go to latest Published: May 24, 2022 License: MIT Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

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 GetLandBySizeParams 

type GetLandBySizeParams struct {
	Acres   sql.NullFloat64
	Acres_2 sql.NullFloat64
}

type GetValidProxyRow 

type GetValidProxyRow struct {
	Ip       string
	Lastused sql.NullString
	Uses     sql.NullInt32
}

type Improvement 

type Improvement struct {
	ID          int32
	Name        sql.NullString
	Description sql.NullString
	StateCode   sql.NullString
	LivingArea  sql.NullInt32
	Value       sql.NullInt32
	PropertyID  sql.NullInt32
}

type ImprovementDetail 

type ImprovementDetail struct {
	ID              int32
	ImprovementID   sql.NullInt32
	ImprovementType sql.NullString
	Description     sql.NullString
	Class           sql.NullString
	ExteriorWall    sql.NullString
	YearBuilt       sql.NullInt32
	SquareFeet      sql.NullInt32
}

type InsertImprovementDetailParams 

type InsertImprovementDetailParams struct {
	ImprovementID   sql.NullInt32
	ImprovementType sql.NullString
	Description     sql.NullString
	Class           sql.NullString
	ExteriorWall    sql.NullString
	YearBuilt       sql.NullInt32
	SquareFeet      sql.NullInt32
}

type InsertImprovementParams 

type InsertImprovementParams struct {
	Name        sql.NullString
	Description sql.NullString
	StateCode   sql.NullString
	LivingArea  sql.NullInt32
	Value       sql.NullInt32
	PropertyID  sql.NullInt32
}

type InsertJurisdictionParams 

type InsertJurisdictionParams struct {
	Entity         sql.NullString
	Description    sql.NullString
	TaxRate        sql.NullInt32
	AppraisedValue sql.NullInt32
	TaxableValue   sql.NullInt32
	EstimatedTax   sql.NullInt32
	PropertyID     sql.NullInt32
}

type InsertLandParams 

type InsertLandParams struct {
	Number      sql.NullInt32
	LandType    sql.NullString
	Description sql.NullString
	Acres       sql.NullFloat64
	SquareFeet  sql.NullFloat64
	EffFront    sql.NullFloat64
	EffDepth    sql.NullFloat64
	MarketValue sql.NullInt32
	PropertyID  sql.NullInt32
}

type InsertPropertyRecordParams 

type InsertPropertyRecordParams struct {
	ID                  int32
	OwnerID             sql.NullInt32
	OwnerName           sql.NullString
	OwnerMailingAddress sql.NullString
	Zoning              sql.NullString
	NeighborhoodCd      sql.NullString
	Neighborhood        sql.NullString
	Address             sql.NullString
	LegalDescription    sql.NullString
	GeographicID        sql.NullString
	Exemptions          sql.NullString
	OwnershipPercentage sql.NullFloat64
	MapscoMapID         sql.NullString
}

type InsertRollValueParams 

type InsertRollValueParams struct {
	Year         sql.NullInt32
	Improvements sql.NullInt32
	LandMarket   sql.NullInt32
	AgValuation  sql.NullInt32
	Appraised    sql.NullInt32
	HomesteadCap sql.NullInt32
	Assessed     sql.NullInt32
	PropertyID   sql.NullInt32
}

type Jurisdiction 

type Jurisdiction struct {
	ID             int32
	Entity         sql.NullString
	Description    sql.NullString
	TaxRate        sql.NullInt32
	AppraisedValue sql.NullInt32
	TaxableValue   sql.NullInt32
	EstimatedTax   sql.NullInt32
	PropertyID     sql.NullInt32
}

type Land 

type Land struct {
	ID          int32
	Number      sql.NullInt32
	LandType    sql.NullString
	Description sql.NullString
	Acres       sql.NullFloat64
	SquareFeet  sql.NullFloat64
	EffFront    sql.NullFloat64
	EffDepth    sql.NullFloat64
	MarketValue sql.NullInt32
	PropertyID  sql.NullInt32
}

type ListPropertiesParams 

type ListPropertiesParams struct {
	Limit  int32
	Offset int32
}

type PendingUrl 

type PendingUrl struct {
	Url string
}

type Property 

type Property struct {
	ID                  int32
	OwnerID             sql.NullInt32
	OwnerName           sql.NullString
	OwnerMailingAddress sql.NullString
	Zoning              sql.NullString
	NeighborhoodCd      sql.NullString
	Neighborhood        sql.NullString
	Address             sql.NullString
	LegalDescription    sql.NullString
	GeographicID        sql.NullString
	Exemptions          sql.NullString
	OwnershipPercentage sql.NullFloat64
	MapscoMapID         sql.NullString
	Longitude           sql.NullFloat64
	Latitude            sql.NullFloat64
	AddressNumber       string
	AddressLineTwo      sql.NullString
	City                sql.NullString
	Street              sql.NullString
	County              sql.NullString
	State               sql.NullString
}

type Proxy 

type Proxy struct {
	Ip       string
	Lastused sql.NullString
	Uses     sql.NullInt32
	IsBad    sql.NullInt32
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) GetDistinctNeighborhoods 

func (q *Queries) GetDistinctNeighborhoods(ctx context.Context) ([]sql.NullString, error)

func (*Queries) GetDistinctStreets 

func (q *Queries) GetDistinctStreets(ctx context.Context) ([]sql.NullString, error)

func (*Queries) GetImprovementByID 

func (q *Queries) GetImprovementByID(ctx context.Context, id int32) (Improvement, error)

func (*Queries) GetImprovementDetail 

func (q *Queries) GetImprovementDetail(ctx context.Context, id int32) (ImprovementDetail, error)

func (*Queries) GetImprovementDetails 

func (q *Queries) GetImprovementDetails(ctx context.Context, improvementID sql.NullInt32) ([]ImprovementDetail, error)

query.sql

func (*Queries) GetImprovementsByPropertyID 

func (q *Queries) GetImprovementsByPropertyID(ctx context.Context, propertyID sql.NullInt32) ([]Improvement, error)

func (*Queries) GetJurisdictionsByPropertyID 

func (q *Queries) GetJurisdictionsByPropertyID(ctx context.Context, propertyID sql.NullInt32) ([]Jurisdiction, error)

func (*Queries) GetLandByPropertyID 

func (q *Queries) GetLandByPropertyID(ctx context.Context, propertyID sql.NullInt32) ([]Land, error)

func (*Queries) GetLandBySize 

func (q *Queries) GetLandBySize(ctx context.Context, arg GetLandBySizeParams) ([]Land, error)

func (*Queries) GetLandByType 

func (q *Queries) GetLandByType(ctx context.Context, landType sql.NullString) ([]Land, error)

func (*Queries) GetNeighborhoodsLike 

func (q *Queries) GetNeighborhoodsLike(ctx context.Context, upper string) ([]sql.NullString, error)

func (*Queries) GetPropertyByID 

func (q *Queries) GetPropertyByID(ctx context.Context, id int32) (Property, error)

func (*Queries) GetPropertyByNeighborhood 

func (q *Queries) GetPropertyByNeighborhood(ctx context.Context, neighborhood sql.NullString) ([]Property, error)

func (*Queries) GetPropertyByStreet 

func (q *Queries) GetPropertyByStreet(ctx context.Context, upper string) ([]Property, error)

func (*Queries) GetRandomURLs 

func (q *Queries) GetRandomURLs(ctx context.Context, limit int32) ([]string, error)

func (*Queries) GetRemainingURLCount 

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

func (*Queries) GetRollValuesByPropertyID 

func (q *Queries) GetRollValuesByPropertyID(ctx context.Context, propertyID sql.NullInt32) ([]RollValue, error)

func (*Queries) GetStreetsLike 

func (q *Queries) GetStreetsLike(ctx context.Context, dollar_1 string) ([]sql.NullString, error)

func (*Queries) GetValidProxy 

func (q *Queries) GetValidProxy(ctx context.Context) (GetValidProxyRow, error)

func (*Queries) InsertImprovement 

func (q *Queries) InsertImprovement(ctx context.Context, arg InsertImprovementParams) (int32, error)

func (*Queries) InsertImprovementDetail 

func (q *Queries) InsertImprovementDetail(ctx context.Context, arg InsertImprovementDetailParams) error

func (*Queries) InsertJurisdiction 

func (q *Queries) InsertJurisdiction(ctx context.Context, arg InsertJurisdictionParams) error

func (*Queries) InsertLand 

func (q *Queries) InsertLand(ctx context.Context, arg InsertLandParams) error

func (*Queries) InsertPropertyRecord 

func (q *Queries) InsertPropertyRecord(ctx context.Context, arg InsertPropertyRecordParams) error

func (*Queries) InsertRollValue 

func (q *Queries) InsertRollValue(ctx context.Context, arg InsertRollValueParams) error

func (*Queries) IsExistingProperty 

func (q *Queries) IsExistingProperty(ctx context.Context, id int32) (bool, error)

func (*Queries) ListProperties 

func (q *Queries) ListProperties(ctx context.Context, arg ListPropertiesParams) ([]Property, error)

func (*Queries) RemovePendingURL 

func (q *Queries) RemovePendingURL(ctx context.Context, url string) error

func (*Queries) UpdatePropertySetAddressParts 

func (q *Queries) UpdatePropertySetAddressParts(ctx context.Context, arg UpdatePropertySetAddressPartsParams) error

func (*Queries) UpdateProxyLastUsedTime 

func (q *Queries) UpdateProxyLastUsedTime(ctx context.Context, arg UpdateProxyLastUsedTimeParams) error

func (*Queries) WithTx 

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

type RollValue 

type RollValue struct {
	ID           int32
	Year         sql.NullInt32
	Improvements sql.NullInt32
	LandMarket   sql.NullInt32
	AgValuation  sql.NullInt32
	Appraised    sql.NullInt32
	HomesteadCap sql.NullInt32
	Assessed     sql.NullInt32
	PropertyID   sql.NullInt32
}

type UpdatePropertySetAddressPartsParams 

type UpdatePropertySetAddressPartsParams struct {
	AddressNumber  string
	AddressLineTwo sql.NullString
	Street         sql.NullString
	City           sql.NullString
	County         sql.NullString
	State          sql.NullString
	ID             int32
}

type UpdateProxyLastUsedTimeParams 

type UpdateProxyLastUsedTimeParams struct {
	Lastused sql.NullString
	Uses     sql.NullInt32
	Ip       string
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.