db

package
v0.0.0-...-5540ed6 Latest Latest
Warning

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

 Go to latest Published: Apr 17, 2024 License: GPL-3.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var ErrRecordNotFound = pgx.ErrNoRows

Functions

This section is empty.

Types

type Area 

type Area struct {
	ID       int64  `json:"id"`
	AreaName string `json:"area_name"`
	AreaDesc string `json:"area_desc"`
}

type Band 

type Band struct {
	ID        int64  `json:"id"`
	BandName  string `json:"band_name"`
	BandDesc  string `json:"band_desc"`
	Size      int64  `json:"size"`
	StartFreq int64  `json:"start_freq"`
	EndFreq   int64  `json:"end_freq"`
	TechID    int64  `json:"tech_id"`
}

type Block 

type Block struct {
	ID              int64  `json:"id"`
	BlockName       string `json:"block_name"`
	BlockDesc       string `json:"block_desc"`
	TotalPopulation int64  `json:"total_population"`
	TownID          int64  `json:"town_id"`
	ClutterID       int64  `json:"clutter_id"`
}

type Carrier 

type Carrier struct {
	ID          int64  `json:"id"`
	CarrierName string `json:"carrier_name"`
	CarrierDesc string `json:"carrier_desc"`
	Size        int64  `json:"size"`
	StartFreq   int64  `json:"start_freq"`
	EndFreq     int64  `json:"end_freq"`
	BandID      int64  `json:"band_id"`
}

type Cell 

type Cell struct {
	ID                int64  `json:"id"`
	CellName          string `json:"cell_name"`
	CellNameOld       string `json:"cell_name_old"`
	CellIDGivin       string `json:"cell_id_givin"`
	CellIDGivinOld    string `json:"cell_id_givin_old"`
	SectorName        string `json:"sector_name"`
	Uplinkuarfcn      string `json:"uplinkuarfcn"`
	Downlinkuarfcn    string `json:"downlinkuarfcn"`
	Dlprscramblecode  string `json:"dlprscramblecode"`
	Azimuth           string `json:"azimuth"`
	Height            string `json:"height"`
	Etilt             string `json:"etilt"`
	Mtilt             string `json:"mtilt"`
	Antennatype       string `json:"antennatype"`
	Antennamodel      string `json:"antennamodel"`
	Ecgi              string `json:"ecgi"`
	SiteID            int64  `json:"site_id"`
	CarrierID         int64  `json:"carrier_id"`
	ServiceareatypeID int64  `json:"serviceareatype_id"`
}

type City 

type City struct {
	ID       int64  `json:"id"`
	CityName string `json:"city_name"`
	CityDesc string `json:"city_desc"`
	StateID  int64  `json:"state_id"`
}

type Clutter 

type Clutter struct {
	ID          int64  `json:"id"`
	ClutterName string `json:"clutter_name"`
	ClutterDesc string `json:"clutter_desc"`
}

type Continent 

type Continent struct {
	ID            int64  `json:"id"`
	ContinentName string `json:"continent_name"`
	ContinentDesc string `json:"continent_desc"`
}

type Country 

type Country struct {
	ID          int64  `json:"id"`
	CountryName string `json:"country_name"`
	CountryDesc string `json:"country_desc"`
	ContinentID int64  `json:"continent_id"`
}

type CreateAreaParams 

type CreateAreaParams struct {
	AreaName string `json:"area_name"`
	AreaDesc string `json:"area_desc"`
}

type CreateBandParams 

type CreateBandParams struct {
	BandName  string `json:"band_name"`
	BandDesc  string `json:"band_desc"`
	Size      int64  `json:"size"`
	StartFreq int64  `json:"start_freq"`
	EndFreq   int64  `json:"end_freq"`
	TechID    int64  `json:"tech_id"`
}

type CreateBlockParams 

type CreateBlockParams struct {
	BlockName       string `json:"block_name"`
	BlockDesc       string `json:"block_desc"`
	TotalPopulation int64  `json:"total_population"`
	TownID          int64  `json:"town_id"`
	ClutterID       int64  `json:"clutter_id"`
}

type CreateCarrierParams 

type CreateCarrierParams struct {
	CarrierName string `json:"carrier_name"`
	CarrierDesc string `json:"carrier_desc"`
	Size        int64  `json:"size"`
	StartFreq   int64  `json:"start_freq"`
	EndFreq     int64  `json:"end_freq"`
	BandID      int64  `json:"band_id"`
}

type CreateCellParams 

type CreateCellParams struct {
	CellName          string `json:"cell_name"`
	CellNameOld       string `json:"cell_name_old"`
	CellIDGivin       string `json:"cell_id_givin"`
	CellIDGivinOld    string `json:"cell_id_givin_old"`
	SectorName        string `json:"sector_name"`
	Uplinkuarfcn      string `json:"uplinkuarfcn"`
	Downlinkuarfcn    string `json:"downlinkuarfcn"`
	Dlprscramblecode  string `json:"dlprscramblecode"`
	Azimuth           string `json:"azimuth"`
	Height            string `json:"height"`
	Etilt             string `json:"etilt"`
	Mtilt             string `json:"mtilt"`
	Antennatype       string `json:"antennatype"`
	Antennamodel      string `json:"antennamodel"`
	Ecgi              string `json:"ecgi"`
	SiteID            int64  `json:"site_id"`
	CarrierID         int64  `json:"carrier_id"`
	ServiceareatypeID int64  `json:"serviceareatype_id"`
}

type CreateCityParams 

type CreateCityParams struct {
	CityName string `json:"city_name"`
	CityDesc string `json:"city_desc"`
	StateID  int64  `json:"state_id"`
}

type CreateClutterParams 

type CreateClutterParams struct {
	ClutterName string `json:"clutter_name"`
	ClutterDesc string `json:"clutter_desc"`
}

type CreateContinentParams 

type CreateContinentParams struct {
	ContinentName string `json:"continent_name"`
	ContinentDesc string `json:"continent_desc"`
}

type CreateCountryParams 

type CreateCountryParams struct {
	CountryName string `json:"country_name"`
	CountryDesc string `json:"country_desc"`
	ContinentID int64  `json:"continent_id"`
}

type CreateDistrictParams 

type CreateDistrictParams struct {
	DistrictName string `json:"district_name"`
	DistrictDesc string `json:"district_desc"`
	CityID       int64  `json:"city_id"`
}

type CreatePropertyParams 

type CreatePropertyParams struct {
	PropertyName string  `json:"property_name"`
	Lat          float32 `json:"lat"`
	Long         float32 `json:"long"`
	BlockID      int64   `json:"block_id"`
}

type CreateServiceareatypeParams 

type CreateServiceareatypeParams struct {
	ServiceareatypeName string `json:"serviceareatype_name"`
	ServiceareatypeDesc string `json:"serviceareatype_desc"`
}

type CreateSessionParams 

type CreateSessionParams struct {
	ID           uuid.UUID `json:"id"`
	Username     string    `json:"username"`
	RefreshToken string    `json:"refresh_token"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	IsBlocked    bool      `json:"is_blocked"`
	ExpiresAt    time.Time `json:"expires_at"`
}

type CreateSiteParams 

type CreateSiteParams struct {
	SiteName       string    `json:"site_name"`
	SiteNameOld    string    `json:"site_name_old"`
	SiteIDGivin    string    `json:"site_id_givin"`
	SiteIDGivinOld string    `json:"site_id_givin_old"`
	Lac            string    `json:"lac"`
	Rac            string    `json:"rac"`
	Rnc            string    `json:"rnc"`
	SiteOnAirDate  time.Time `json:"site_on_air_date"`
	PropertyID     int64     `json:"property_id"`
	SitetypeID     int64     `json:"sitetype_id"`
	VendorID       int64     `json:"vendor_id"`
}

type CreateSitetypeParams 

type CreateSitetypeParams struct {
	TypeName string `json:"type_name"`
	TypeDesc string `json:"type_desc"`
}

type CreateStateParams 

type CreateStateParams struct {
	StateName string `json:"state_name"`
	StateDesc string `json:"state_desc"`
	CountryID int64  `json:"country_id"`
	AreaID    int64  `json:"area_id"`
}

type CreateTechParams 

type CreateTechParams struct {
	TechName string `json:"tech_name"`
	TechDesc string `json:"tech_desc"`
}

type CreateTownParams 

type CreateTownParams struct {
	TownName   string `json:"town_name"`
	TownDesc   string `json:"town_desc"`
	DistrictID int64  `json:"district_id"`
}

type CreateTrafficParams 

type CreateTrafficParams struct {
	TrafficDate              time.Time `json:"traffic_date"`
	Avgdailydldatamb         float32   `json:"avgdailydldatamb"`
	Avgdailyuldatamb         float32   `json:"avgdailyuldatamb"`
	Avgdailytotdatamb        float32   `json:"avgdailytotdatamb"`
	Avgdailytotvoicemin      float32   `json:"avgdailytotvoicemin"`
	Avgdailytotvideomin      float32   `json:"avgdailytotvideomin"`
	Qci1Data                 float32   `json:"qci1_data"`
	Qci6Data                 float32   `json:"qci6_data"`
	Qci8Data                 float32   `json:"qci8_data"`
	QciOtherData             float32   `json:"qci_other_data"`
	Avgdailytotvoicemin4g    float32   `json:"avgdailytotvoicemin4g"`
	Avgdailytotvoicemintotal float32   `json:"avgdailytotvoicemintotal"`
	Userdlthroughput         float32   `json:"userdlthroughput"`
	Dlpacketlossrate         float32   `json:"dlpacketlossrate"`
	Overallpsdropcallrate    float32   `json:"overallpsdropcallrate"`
	Bhdldatamb               float32   `json:"bhdldatamb"`
	Bhupdatamb               float32   `json:"bhupdatamb"`
	Bhtotdatamb              float32   `json:"bhtotdatamb"`
	Bhtotvoicemin            float32   `json:"bhtotvoicemin"`
	Bhtotvideomin            float32   `json:"bhtotvideomin"`
	Bhcsusers                float32   `json:"bhcsusers"`
	Bhhsupausers             float32   `json:"bhhsupausers"`
	Bhhsdpausers             float32   `json:"bhhsdpausers"`
	Bhr99uldl                float32   `json:"bhr99uldl"`
	Powercapacity            float32   `json:"powercapacity"`
	Powerutilization         float32   `json:"powerutilization"`
	Codecapacity             float32   `json:"codecapacity"`
	Codeutilization          float32   `json:"codeutilization"`
	Ceulcapacity             float32   `json:"ceulcapacity"`
	Ceulutilization          float32   `json:"ceulutilization"`
	Cedlcapacity             float32   `json:"cedlcapacity"`
	Cedlutilization          float32   `json:"cedlutilization"`
	Iubcapacity              float32   `json:"iubcapacity"`
	Iubutlization            float32   `json:"iubutlization"`
	Bhrrcusers               float32   `json:"bhrrcusers"`
	CellID                   int64     `json:"cell_id"`
}

type CreateUserParams 

type CreateUserParams struct {
	Username       string `json:"username"`
	HashedPassword string `json:"hashed_password"`
	FullName       string `json:"full_name"`
	Email          string `json:"email"`
	Role           string `json:"role"`
}

type CreateVendorParams 

type CreateVendorParams struct {
	VendorName string `json:"vendor_name"`
	VendorDesc string `json:"vendor_desc"`
}

type DBTX 

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type District 

type District struct {
	ID           int64  `json:"id"`
	DistrictName string `json:"district_name"`
	DistrictDesc string `json:"district_desc"`
	CityID       int64  `json:"city_id"`
}

type ListAreasParams 

type ListAreasParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListBandsParams 

type ListBandsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
	TechID int64 `json:"tech_id"`
}

type ListBlocksParams 

type ListBlocksParams struct {
	Limit     int32 `json:"limit"`
	Offset    int32 `json:"offset"`
	TownID    int64 `json:"town_id"`
	ClutterID int64 `json:"clutter_id"`
}

type ListCarriersParams 

type ListCarriersParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
	BandID int64 `json:"band_id"`
}

type ListCellsParams 

type ListCellsParams struct {
	Limit             int32 `json:"limit"`
	Offset            int32 `json:"offset"`
	SiteID            int64 `json:"site_id"`
	CarrierID         int64 `json:"carrier_id"`
	ServiceareatypeID int64 `json:"serviceareatype_id"`
}

type ListCitiesParams 

type ListCitiesParams struct {
	Limit   int32 `json:"limit"`
	Offset  int32 `json:"offset"`
	StateID int64 `json:"state_id"`
}

type ListCluttersParams 

type ListCluttersParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListContinentsParams 

type ListContinentsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListCountriesParams 

type ListCountriesParams struct {
	Limit       int32 `json:"limit"`
	Offset      int32 `json:"offset"`
	ContinentID int64 `json:"continent_id"`
}

type ListDistrictsParams 

type ListDistrictsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
	CityID int64 `json:"city_id"`
}

type ListPropertiesParams 

type ListPropertiesParams struct {
	Limit   int32 `json:"limit"`
	Offset  int32 `json:"offset"`
	BlockID int64 `json:"block_id"`
}

type ListServiceareatypesParams 

type ListServiceareatypesParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListSessionsParams 

type ListSessionsParams struct {
	Limit    int32  `json:"limit"`
	Offset   int32  `json:"offset"`
	Username string `json:"username"`
}

type ListSitesParams 

type ListSitesParams struct {
	Limit      int32 `json:"limit"`
	Offset     int32 `json:"offset"`
	PropertyID int64 `json:"property_id"`
	SitetypeID int64 `json:"sitetype_id"`
	VendorID   int64 `json:"vendor_id"`
}

type ListSitetypesParams 

type ListSitetypesParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListStatesParams 

type ListStatesParams struct {
	Limit     int32 `json:"limit"`
	Offset    int32 `json:"offset"`
	CountryID int64 `json:"country_id"`
	AreaID    int64 `json:"area_id"`
}

type ListTechsParams 

type ListTechsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListTownsParams 

type ListTownsParams struct {
	Limit      int32 `json:"limit"`
	Offset     int32 `json:"offset"`
	DistrictID int64 `json:"district_id"`
}

type ListTrafficParams 

type ListTrafficParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
	CellID int64 `json:"cell_id"`
}

type ListUsersParams 

type ListUsersParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type ListVendorsParams 

type ListVendorsParams struct {
	Limit  int32 `json:"limit"`
	Offset int32 `json:"offset"`
}

type Property 

type Property struct {
	ID           int64   `json:"id"`
	PropertyName string  `json:"property_name"`
	Lat          float32 `json:"lat"`
	Long         float32 `json:"long"`
	BlockID      int64   `json:"block_id"`
}

type Querier 

type Querier interface {
	CreateArea(ctx context.Context, arg CreateAreaParams) (Area, error)
	CreateBand(ctx context.Context, arg CreateBandParams) (Band, error)
	CreateBlock(ctx context.Context, arg CreateBlockParams) (Block, error)
	CreateCarrier(ctx context.Context, arg CreateCarrierParams) (Carrier, error)
	CreateCell(ctx context.Context, arg CreateCellParams) (Cell, error)
	CreateCity(ctx context.Context, arg CreateCityParams) (City, error)
	CreateClutter(ctx context.Context, arg CreateClutterParams) (Clutter, error)
	CreateContinent(ctx context.Context, arg CreateContinentParams) (Continent, error)
	CreateCountry(ctx context.Context, arg CreateCountryParams) (Country, error)
	CreateDistrict(ctx context.Context, arg CreateDistrictParams) (District, error)
	CreateProperty(ctx context.Context, arg CreatePropertyParams) (Property, error)
	CreateServiceareatype(ctx context.Context, arg CreateServiceareatypeParams) (Serviceareatype, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	CreateSite(ctx context.Context, arg CreateSiteParams) (Site, error)
	CreateSitetype(ctx context.Context, arg CreateSitetypeParams) (Sitetype, error)
	CreateState(ctx context.Context, arg CreateStateParams) (State, error)
	CreateTech(ctx context.Context, arg CreateTechParams) (Tech, error)
	CreateTown(ctx context.Context, arg CreateTownParams) (Town, error)
	CreateTraffic(ctx context.Context, arg CreateTrafficParams) (Traffic, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	CreateVendor(ctx context.Context, arg CreateVendorParams) (Vendor, error)
	DeleteArea(ctx context.Context, id int64) error
	DeleteBand(ctx context.Context, id int64) error
	DeleteBlock(ctx context.Context, id int64) error
	DeleteCarrier(ctx context.Context, id int64) error
	DeleteCell(ctx context.Context, id int64) error
	DeleteCity(ctx context.Context, id int64) error
	DeleteClutter(ctx context.Context, id int64) error
	DeleteContinent(ctx context.Context, id int64) error
	DeleteCountry(ctx context.Context, id int64) error
	DeleteDistrict(ctx context.Context, id int64) error
	DeleteProperty(ctx context.Context, id int64) error
	DeleteServiceareatype(ctx context.Context, id int64) error
	DeleteSession(ctx context.Context, id uuid.UUID) error
	DeleteSite(ctx context.Context, id int64) error
	DeleteSitetype(ctx context.Context, id int64) error
	DeleteState(ctx context.Context, id int64) error
	DeleteTech(ctx context.Context, id int64) error
	DeleteTown(ctx context.Context, id int64) error
	DeleteTraffic(ctx context.Context, id int64) error
	DeleteUser(ctx context.Context, username string) error
	DeleteVendor(ctx context.Context, id int64) error
	GetArea0(ctx context.Context, id int64) (Area, error)
	GetArea1(ctx context.Context, areaName string) (Area, error)
	GetBand0(ctx context.Context, id int64) (Band, error)
	GetBand1(ctx context.Context, bandName string) (Band, error)
	GetBlock0(ctx context.Context, id int64) (Block, error)
	GetBlock1(ctx context.Context, blockName string) (Block, error)
	GetCarrier0(ctx context.Context, id int64) (Carrier, error)
	GetCarrier1(ctx context.Context, carrierName string) (Carrier, error)
	GetCell0(ctx context.Context, id int64) (Cell, error)
	GetCell1(ctx context.Context, cellName string) (Cell, error)
	GetCity0(ctx context.Context, id int64) (City, error)
	GetCity1(ctx context.Context, cityName string) (City, error)
	GetClutter0(ctx context.Context, id int64) (Clutter, error)
	GetClutter1(ctx context.Context, clutterName string) (Clutter, error)
	GetContinent0(ctx context.Context, id int64) (Continent, error)
	GetContinent1(ctx context.Context, continentName string) (Continent, error)
	GetCountry0(ctx context.Context, id int64) (Country, error)
	GetCountry1(ctx context.Context, countryName string) (Country, error)
	GetDistrict0(ctx context.Context, id int64) (District, error)
	GetDistrict1(ctx context.Context, districtName string) (District, error)
	GetProperty0(ctx context.Context, id int64) (Property, error)
	GetProperty1(ctx context.Context, propertyName string) (Property, error)
	GetServiceareatype0(ctx context.Context, id int64) (Serviceareatype, error)
	GetServiceareatype1(ctx context.Context, serviceareatypeName string) (Serviceareatype, error)
	GetSession0(ctx context.Context, id uuid.UUID) (Session, error)
	GetSite0(ctx context.Context, id int64) (Site, error)
	GetSite1(ctx context.Context, siteName string) (Site, error)
	GetSitetype0(ctx context.Context, id int64) (Sitetype, error)
	GetSitetype1(ctx context.Context, typeName string) (Sitetype, error)
	GetState0(ctx context.Context, id int64) (State, error)
	GetState1(ctx context.Context, stateName string) (State, error)
	GetTech0(ctx context.Context, id int64) (Tech, error)
	GetTech1(ctx context.Context, techName string) (Tech, error)
	GetTown0(ctx context.Context, id int64) (Town, error)
	GetTown1(ctx context.Context, townName string) (Town, error)
	GetTraffic0(ctx context.Context, id int64) (Traffic, error)
	GetUser0(ctx context.Context, username string) (User, error)
	GetUser3(ctx context.Context, email string) (User, error)
	GetVendor0(ctx context.Context, id int64) (Vendor, error)
	GetVendor1(ctx context.Context, vendorName string) (Vendor, error)
	ListAreas(ctx context.Context, arg ListAreasParams) ([]Area, error)
	ListBands(ctx context.Context, arg ListBandsParams) ([]Band, error)
	ListBlocks(ctx context.Context, arg ListBlocksParams) ([]Block, error)
	ListCarriers(ctx context.Context, arg ListCarriersParams) ([]Carrier, error)
	ListCells(ctx context.Context, arg ListCellsParams) ([]Cell, error)
	ListCities(ctx context.Context, arg ListCitiesParams) ([]City, error)
	ListClutters(ctx context.Context, arg ListCluttersParams) ([]Clutter, error)
	ListContinents(ctx context.Context, arg ListContinentsParams) ([]Continent, error)
	ListCountries(ctx context.Context, arg ListCountriesParams) ([]Country, error)
	ListDistricts(ctx context.Context, arg ListDistrictsParams) ([]District, error)
	ListProperties(ctx context.Context, arg ListPropertiesParams) ([]Property, error)
	ListServiceareatypes(ctx context.Context, arg ListServiceareatypesParams) ([]Serviceareatype, error)
	ListSessions(ctx context.Context, arg ListSessionsParams) ([]Session, error)
	ListSites(ctx context.Context, arg ListSitesParams) ([]Site, error)
	ListSitetypes(ctx context.Context, arg ListSitetypesParams) ([]Sitetype, error)
	ListStates(ctx context.Context, arg ListStatesParams) ([]State, error)
	ListTechs(ctx context.Context, arg ListTechsParams) ([]Tech, error)
	ListTowns(ctx context.Context, arg ListTownsParams) ([]Town, error)
	ListTraffic(ctx context.Context, arg ListTrafficParams) ([]Traffic, error)
	ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)
	ListVendors(ctx context.Context, arg ListVendorsParams) ([]Vendor, error)
	UpdateArea(ctx context.Context, arg UpdateAreaParams) (Area, error)
	UpdateBand(ctx context.Context, arg UpdateBandParams) (Band, error)
	UpdateBlock(ctx context.Context, arg UpdateBlockParams) (Block, error)
	UpdateCarrier(ctx context.Context, arg UpdateCarrierParams) (Carrier, error)
	UpdateCell(ctx context.Context, arg UpdateCellParams) (Cell, error)
	UpdateCity(ctx context.Context, arg UpdateCityParams) (City, error)
	UpdateClutter(ctx context.Context, arg UpdateClutterParams) (Clutter, error)
	UpdateContinent(ctx context.Context, arg UpdateContinentParams) (Continent, error)
	UpdateCountry(ctx context.Context, arg UpdateCountryParams) (Country, error)
	UpdateDistrict(ctx context.Context, arg UpdateDistrictParams) (District, error)
	UpdateProperty(ctx context.Context, arg UpdatePropertyParams) (Property, error)
	UpdateServiceareatype(ctx context.Context, arg UpdateServiceareatypeParams) (Serviceareatype, error)
	UpdateSession(ctx context.Context, arg UpdateSessionParams) (Session, error)
	UpdateSite(ctx context.Context, arg UpdateSiteParams) (Site, error)
	UpdateSitetype(ctx context.Context, arg UpdateSitetypeParams) (Sitetype, error)
	UpdateState(ctx context.Context, arg UpdateStateParams) (State, error)
	UpdateTech(ctx context.Context, arg UpdateTechParams) (Tech, error)
	UpdateTown(ctx context.Context, arg UpdateTownParams) (Town, error)
	UpdateTraffic(ctx context.Context, arg UpdateTrafficParams) (Traffic, error)
	UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)
	UpdateVendor(ctx context.Context, arg UpdateVendorParams) (Vendor, error)
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) CreateArea 

func (q *Queries) CreateArea(ctx context.Context, arg CreateAreaParams) (Area, error)

func (*Queries) CreateBand 

func (q *Queries) CreateBand(ctx context.Context, arg CreateBandParams) (Band, error)

func (*Queries) CreateBlock 

func (q *Queries) CreateBlock(ctx context.Context, arg CreateBlockParams) (Block, error)

func (*Queries) CreateCarrier 

func (q *Queries) CreateCarrier(ctx context.Context, arg CreateCarrierParams) (Carrier, error)

func (*Queries) CreateCell 

func (q *Queries) CreateCell(ctx context.Context, arg CreateCellParams) (Cell, error)

func (*Queries) CreateCity 

func (q *Queries) CreateCity(ctx context.Context, arg CreateCityParams) (City, error)

func (*Queries) CreateClutter 

func (q *Queries) CreateClutter(ctx context.Context, arg CreateClutterParams) (Clutter, error)

func (*Queries) CreateContinent 

func (q *Queries) CreateContinent(ctx context.Context, arg CreateContinentParams) (Continent, error)

func (*Queries) CreateCountry 

func (q *Queries) CreateCountry(ctx context.Context, arg CreateCountryParams) (Country, error)

func (*Queries) CreateDistrict 

func (q *Queries) CreateDistrict(ctx context.Context, arg CreateDistrictParams) (District, error)

func (*Queries) CreateProperty 

func (q *Queries) CreateProperty(ctx context.Context, arg CreatePropertyParams) (Property, error)

func (*Queries) CreateServiceareatype 

func (q *Queries) CreateServiceareatype(ctx context.Context, arg CreateServiceareatypeParams) (Serviceareatype, error)

func (*Queries) CreateSession 

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)

func (*Queries) CreateSite 

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

func (*Queries) CreateSitetype 

func (q *Queries) CreateSitetype(ctx context.Context, arg CreateSitetypeParams) (Sitetype, error)

func (*Queries) CreateState 

func (q *Queries) CreateState(ctx context.Context, arg CreateStateParams) (State, error)

func (*Queries) CreateTech 

func (q *Queries) CreateTech(ctx context.Context, arg CreateTechParams) (Tech, error)

func (*Queries) CreateTown 

func (q *Queries) CreateTown(ctx context.Context, arg CreateTownParams) (Town, error)

func (*Queries) CreateTraffic 

func (q *Queries) CreateTraffic(ctx context.Context, arg CreateTrafficParams) (Traffic, error)

func (*Queries) CreateUser 

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) CreateVendor 

func (q *Queries) CreateVendor(ctx context.Context, arg CreateVendorParams) (Vendor, error)

func (*Queries) DeleteArea 

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

func (*Queries) DeleteBand 

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

func (*Queries) DeleteBlock 

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

func (*Queries) DeleteCarrier 

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

func (*Queries) DeleteCell 

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

func (*Queries) DeleteCity 

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

func (*Queries) DeleteClutter 

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

func (*Queries) DeleteContinent 

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

func (*Queries) DeleteCountry 

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

func (*Queries) DeleteDistrict 

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

func (*Queries) DeleteProperty 

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

func (*Queries) DeleteServiceareatype 

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

func (*Queries) DeleteSession 

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

func (*Queries) DeleteSite 

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

func (*Queries) DeleteSitetype 

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

func (*Queries) DeleteState 

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

func (*Queries) DeleteTech 

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

func (*Queries) DeleteTown 

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

func (*Queries) DeleteTraffic 

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

func (*Queries) DeleteUser 

func (q *Queries) DeleteUser(ctx context.Context, username string) error

func (*Queries) DeleteVendor 

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

func (*Queries) GetArea0 

func (q *Queries) GetArea0(ctx context.Context, id int64) (Area, error)

func (*Queries) GetArea1 

func (q *Queries) GetArea1(ctx context.Context, areaName string) (Area, error)

func (*Queries) GetBand0 

func (q *Queries) GetBand0(ctx context.Context, id int64) (Band, error)

func (*Queries) GetBand1 

func (q *Queries) GetBand1(ctx context.Context, bandName string) (Band, error)

func (*Queries) GetBlock0 

func (q *Queries) GetBlock0(ctx context.Context, id int64) (Block, error)

func (*Queries) GetBlock1 

func (q *Queries) GetBlock1(ctx context.Context, blockName string) (Block, error)

func (*Queries) GetCarrier0 

func (q *Queries) GetCarrier0(ctx context.Context, id int64) (Carrier, error)

func (*Queries) GetCarrier1 

func (q *Queries) GetCarrier1(ctx context.Context, carrierName string) (Carrier, error)

func (*Queries) GetCell0 

func (q *Queries) GetCell0(ctx context.Context, id int64) (Cell, error)

func (*Queries) GetCell1 

func (q *Queries) GetCell1(ctx context.Context, cellName string) (Cell, error)

func (*Queries) GetCity0 

func (q *Queries) GetCity0(ctx context.Context, id int64) (City, error)

func (*Queries) GetCity1 

func (q *Queries) GetCity1(ctx context.Context, cityName string) (City, error)

func (*Queries) GetClutter0 

func (q *Queries) GetClutter0(ctx context.Context, id int64) (Clutter, error)

func (*Queries) GetClutter1 

func (q *Queries) GetClutter1(ctx context.Context, clutterName string) (Clutter, error)

func (*Queries) GetContinent0 

func (q *Queries) GetContinent0(ctx context.Context, id int64) (Continent, error)

func (*Queries) GetContinent1 

func (q *Queries) GetContinent1(ctx context.Context, continentName string) (Continent, error)

func (*Queries) GetCountry0 

func (q *Queries) GetCountry0(ctx context.Context, id int64) (Country, error)

func (*Queries) GetCountry1 

func (q *Queries) GetCountry1(ctx context.Context, countryName string) (Country, error)

func (*Queries) GetDistrict0 

func (q *Queries) GetDistrict0(ctx context.Context, id int64) (District, error)

func (*Queries) GetDistrict1 

func (q *Queries) GetDistrict1(ctx context.Context, districtName string) (District, error)

func (*Queries) GetProperty0 

func (q *Queries) GetProperty0(ctx context.Context, id int64) (Property, error)

func (*Queries) GetProperty1 

func (q *Queries) GetProperty1(ctx context.Context, propertyName string) (Property, error)

func (*Queries) GetServiceareatype0 

func (q *Queries) GetServiceareatype0(ctx context.Context, id int64) (Serviceareatype, error)

func (*Queries) GetServiceareatype1 

func (q *Queries) GetServiceareatype1(ctx context.Context, serviceareatypeName string) (Serviceareatype, error)

func (*Queries) GetSession0 

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

func (*Queries) GetSite0 

func (q *Queries) GetSite0(ctx context.Context, id int64) (Site, error)

func (*Queries) GetSite1 

func (q *Queries) GetSite1(ctx context.Context, siteName string) (Site, error)

func (*Queries) GetSitetype0 

func (q *Queries) GetSitetype0(ctx context.Context, id int64) (Sitetype, error)

func (*Queries) GetSitetype1 

func (q *Queries) GetSitetype1(ctx context.Context, typeName string) (Sitetype, error)

func (*Queries) GetState0 

func (q *Queries) GetState0(ctx context.Context, id int64) (State, error)

func (*Queries) GetState1 

func (q *Queries) GetState1(ctx context.Context, stateName string) (State, error)

func (*Queries) GetTech0 

func (q *Queries) GetTech0(ctx context.Context, id int64) (Tech, error)

func (*Queries) GetTech1 

func (q *Queries) GetTech1(ctx context.Context, techName string) (Tech, error)

func (*Queries) GetTown0 

func (q *Queries) GetTown0(ctx context.Context, id int64) (Town, error)

func (*Queries) GetTown1 

func (q *Queries) GetTown1(ctx context.Context, townName string) (Town, error)

func (*Queries) GetTraffic0 

func (q *Queries) GetTraffic0(ctx context.Context, id int64) (Traffic, error)

func (*Queries) GetUser0 

func (q *Queries) GetUser0(ctx context.Context, username string) (User, error)

func (*Queries) GetUser3 

func (q *Queries) GetUser3(ctx context.Context, email string) (User, error)

func (*Queries) GetVendor0 

func (q *Queries) GetVendor0(ctx context.Context, id int64) (Vendor, error)

func (*Queries) GetVendor1 

func (q *Queries) GetVendor1(ctx context.Context, vendorName string) (Vendor, error)

func (*Queries) ListAreas 

func (q *Queries) ListAreas(ctx context.Context, arg ListAreasParams) ([]Area, error)

func (*Queries) ListBands 

func (q *Queries) ListBands(ctx context.Context, arg ListBandsParams) ([]Band, error)

func (*Queries) ListBlocks 

func (q *Queries) ListBlocks(ctx context.Context, arg ListBlocksParams) ([]Block, error)

func (*Queries) ListCarriers 

func (q *Queries) ListCarriers(ctx context.Context, arg ListCarriersParams) ([]Carrier, error)

func (*Queries) ListCells 

func (q *Queries) ListCells(ctx context.Context, arg ListCellsParams) ([]Cell, error)

func (*Queries) ListCities 

func (q *Queries) ListCities(ctx context.Context, arg ListCitiesParams) ([]City, error)

func (*Queries) ListClutters 

func (q *Queries) ListClutters(ctx context.Context, arg ListCluttersParams) ([]Clutter, error)

func (*Queries) ListContinents 

func (q *Queries) ListContinents(ctx context.Context, arg ListContinentsParams) ([]Continent, error)

func (*Queries) ListCountries 

func (q *Queries) ListCountries(ctx context.Context, arg ListCountriesParams) ([]Country, error)

func (*Queries) ListDistricts 

func (q *Queries) ListDistricts(ctx context.Context, arg ListDistrictsParams) ([]District, error)

func (*Queries) ListProperties 

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

func (*Queries) ListServiceareatypes 

func (q *Queries) ListServiceareatypes(ctx context.Context, arg ListServiceareatypesParams) ([]Serviceareatype, error)

func (*Queries) ListSessions 

func (q *Queries) ListSessions(ctx context.Context, arg ListSessionsParams) ([]Session, error)

func (*Queries) ListSites 

func (q *Queries) ListSites(ctx context.Context, arg ListSitesParams) ([]Site, error)

func (*Queries) ListSitetypes 

func (q *Queries) ListSitetypes(ctx context.Context, arg ListSitetypesParams) ([]Sitetype, error)

func (*Queries) ListStates 

func (q *Queries) ListStates(ctx context.Context, arg ListStatesParams) ([]State, error)

func (*Queries) ListTechs 

func (q *Queries) ListTechs(ctx context.Context, arg ListTechsParams) ([]Tech, error)

func (*Queries) ListTowns 

func (q *Queries) ListTowns(ctx context.Context, arg ListTownsParams) ([]Town, error)

func (*Queries) ListTraffic 

func (q *Queries) ListTraffic(ctx context.Context, arg ListTrafficParams) ([]Traffic, error)

func (*Queries) ListUsers 

func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)

func (*Queries) ListVendors 

func (q *Queries) ListVendors(ctx context.Context, arg ListVendorsParams) ([]Vendor, error)

func (*Queries) UpdateArea 

func (q *Queries) UpdateArea(ctx context.Context, arg UpdateAreaParams) (Area, error)

func (*Queries) UpdateBand 

func (q *Queries) UpdateBand(ctx context.Context, arg UpdateBandParams) (Band, error)

func (*Queries) UpdateBlock 

func (q *Queries) UpdateBlock(ctx context.Context, arg UpdateBlockParams) (Block, error)

func (*Queries) UpdateCarrier 

func (q *Queries) UpdateCarrier(ctx context.Context, arg UpdateCarrierParams) (Carrier, error)

func (*Queries) UpdateCell 

func (q *Queries) UpdateCell(ctx context.Context, arg UpdateCellParams) (Cell, error)

func (*Queries) UpdateCity 

func (q *Queries) UpdateCity(ctx context.Context, arg UpdateCityParams) (City, error)

func (*Queries) UpdateClutter 

func (q *Queries) UpdateClutter(ctx context.Context, arg UpdateClutterParams) (Clutter, error)

func (*Queries) UpdateContinent 

func (q *Queries) UpdateContinent(ctx context.Context, arg UpdateContinentParams) (Continent, error)

func (*Queries) UpdateCountry 

func (q *Queries) UpdateCountry(ctx context.Context, arg UpdateCountryParams) (Country, error)

func (*Queries) UpdateDistrict 

func (q *Queries) UpdateDistrict(ctx context.Context, arg UpdateDistrictParams) (District, error)

func (*Queries) UpdateProperty 

func (q *Queries) UpdateProperty(ctx context.Context, arg UpdatePropertyParams) (Property, error)

func (*Queries) UpdateServiceareatype 

func (q *Queries) UpdateServiceareatype(ctx context.Context, arg UpdateServiceareatypeParams) (Serviceareatype, error)

func (*Queries) UpdateSession 

func (q *Queries) UpdateSession(ctx context.Context, arg UpdateSessionParams) (Session, error)

func (*Queries) UpdateSite 

func (q *Queries) UpdateSite(ctx context.Context, arg UpdateSiteParams) (Site, error)

func (*Queries) UpdateSitetype 

func (q *Queries) UpdateSitetype(ctx context.Context, arg UpdateSitetypeParams) (Sitetype, error)

func (*Queries) UpdateState 

func (q *Queries) UpdateState(ctx context.Context, arg UpdateStateParams) (State, error)

func (*Queries) UpdateTech 

func (q *Queries) UpdateTech(ctx context.Context, arg UpdateTechParams) (Tech, error)

func (*Queries) UpdateTown 

func (q *Queries) UpdateTown(ctx context.Context, arg UpdateTownParams) (Town, error)

func (*Queries) UpdateTraffic 

func (q *Queries) UpdateTraffic(ctx context.Context, arg UpdateTrafficParams) (Traffic, error)

func (*Queries) UpdateUser 

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

func (*Queries) UpdateVendor 

func (q *Queries) UpdateVendor(ctx context.Context, arg UpdateVendorParams) (Vendor, error)

func (*Queries) WithTx 

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

type Serviceareatype 

type Serviceareatype struct {
	ID                  int64  `json:"id"`
	ServiceareatypeName string `json:"serviceareatype_name"`
	ServiceareatypeDesc string `json:"serviceareatype_desc"`
}

type Session 

type Session struct {
	ID           uuid.UUID `json:"id"`
	Username     string    `json:"username"`
	RefreshToken string    `json:"refresh_token"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	IsBlocked    bool      `json:"is_blocked"`
	ExpiresAt    time.Time `json:"expires_at"`
	CreatedAt    time.Time `json:"created_at"`
}

type Site 

type Site struct {
	ID             int64     `json:"id"`
	SiteName       string    `json:"site_name"`
	SiteNameOld    string    `json:"site_name_old"`
	SiteIDGivin    string    `json:"site_id_givin"`
	SiteIDGivinOld string    `json:"site_id_givin_old"`
	Lac            string    `json:"lac"`
	Rac            string    `json:"rac"`
	Rnc            string    `json:"rnc"`
	SiteOnAirDate  time.Time `json:"site_on_air_date"`
	PropertyID     int64     `json:"property_id"`
	SitetypeID     int64     `json:"sitetype_id"`
	VendorID       int64     `json:"vendor_id"`
}

type Sitetype 

type Sitetype struct {
	ID       int64  `json:"id"`
	TypeName string `json:"type_name"`
	TypeDesc string `json:"type_desc"`
}

type State 

type State struct {
	ID        int64  `json:"id"`
	StateName string `json:"state_name"`
	StateDesc string `json:"state_desc"`
	CountryID int64  `json:"country_id"`
	AreaID    int64  `json:"area_id"`
}

type Store 

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

SQLStore provides all functions to execute SQL queries and transactions

func NewStore 

func NewStore(connpool *pgxpool.Pool) *Store

NewStore creates a new store

type Tech 

type Tech struct {
	ID       int64  `json:"id"`
	TechName string `json:"tech_name"`
	TechDesc string `json:"tech_desc"`
}

type Town 

type Town struct {
	ID         int64  `json:"id"`
	TownName   string `json:"town_name"`
	TownDesc   string `json:"town_desc"`
	DistrictID int64  `json:"district_id"`
}

type Traffic 

type Traffic struct {
	ID                       int64     `json:"id"`
	TrafficDate              time.Time `json:"traffic_date"`
	Avgdailydldatamb         float32   `json:"avgdailydldatamb"`
	Avgdailyuldatamb         float32   `json:"avgdailyuldatamb"`
	Avgdailytotdatamb        float32   `json:"avgdailytotdatamb"`
	Avgdailytotvoicemin      float32   `json:"avgdailytotvoicemin"`
	Avgdailytotvideomin      float32   `json:"avgdailytotvideomin"`
	Qci1Data                 float32   `json:"qci1_data"`
	Qci6Data                 float32   `json:"qci6_data"`
	Qci8Data                 float32   `json:"qci8_data"`
	QciOtherData             float32   `json:"qci_other_data"`
	Avgdailytotvoicemin4g    float32   `json:"avgdailytotvoicemin4g"`
	Avgdailytotvoicemintotal float32   `json:"avgdailytotvoicemintotal"`
	Userdlthroughput         float32   `json:"userdlthroughput"`
	Dlpacketlossrate         float32   `json:"dlpacketlossrate"`
	Overallpsdropcallrate    float32   `json:"overallpsdropcallrate"`
	Bhdldatamb               float32   `json:"bhdldatamb"`
	Bhupdatamb               float32   `json:"bhupdatamb"`
	Bhtotdatamb              float32   `json:"bhtotdatamb"`
	Bhtotvoicemin            float32   `json:"bhtotvoicemin"`
	Bhtotvideomin            float32   `json:"bhtotvideomin"`
	Bhcsusers                float32   `json:"bhcsusers"`
	Bhhsupausers             float32   `json:"bhhsupausers"`
	Bhhsdpausers             float32   `json:"bhhsdpausers"`
	Bhr99uldl                float32   `json:"bhr99uldl"`
	Powercapacity            float32   `json:"powercapacity"`
	Powerutilization         float32   `json:"powerutilization"`
	Codecapacity             float32   `json:"codecapacity"`
	Codeutilization          float32   `json:"codeutilization"`
	Ceulcapacity             float32   `json:"ceulcapacity"`
	Ceulutilization          float32   `json:"ceulutilization"`
	Cedlcapacity             float32   `json:"cedlcapacity"`
	Cedlutilization          float32   `json:"cedlutilization"`
	Iubcapacity              float32   `json:"iubcapacity"`
	Iubutlization            float32   `json:"iubutlization"`
	Bhrrcusers               float32   `json:"bhrrcusers"`
	CellID                   int64     `json:"cell_id"`
}

type UpdateAreaParams 

type UpdateAreaParams struct {
	ID       int64  `json:"id"`
	AreaName string `json:"area_name"`
	AreaDesc string `json:"area_desc"`
}

type UpdateBandParams 

type UpdateBandParams struct {
	ID        int64  `json:"id"`
	BandName  string `json:"band_name"`
	BandDesc  string `json:"band_desc"`
	Size      int64  `json:"size"`
	StartFreq int64  `json:"start_freq"`
	EndFreq   int64  `json:"end_freq"`
	TechID    int64  `json:"tech_id"`
}

type UpdateBlockParams 

type UpdateBlockParams struct {
	ID              int64  `json:"id"`
	BlockName       string `json:"block_name"`
	BlockDesc       string `json:"block_desc"`
	TotalPopulation int64  `json:"total_population"`
	TownID          int64  `json:"town_id"`
	ClutterID       int64  `json:"clutter_id"`
}

type UpdateCarrierParams 

type UpdateCarrierParams struct {
	ID          int64  `json:"id"`
	CarrierName string `json:"carrier_name"`
	CarrierDesc string `json:"carrier_desc"`
	Size        int64  `json:"size"`
	StartFreq   int64  `json:"start_freq"`
	EndFreq     int64  `json:"end_freq"`
	BandID      int64  `json:"band_id"`
}

type UpdateCellParams 

type UpdateCellParams struct {
	ID                int64  `json:"id"`
	CellName          string `json:"cell_name"`
	CellNameOld       string `json:"cell_name_old"`
	CellIDGivin       string `json:"cell_id_givin"`
	CellIDGivinOld    string `json:"cell_id_givin_old"`
	SectorName        string `json:"sector_name"`
	Uplinkuarfcn      string `json:"uplinkuarfcn"`
	Downlinkuarfcn    string `json:"downlinkuarfcn"`
	Dlprscramblecode  string `json:"dlprscramblecode"`
	Azimuth           string `json:"azimuth"`
	Height            string `json:"height"`
	Etilt             string `json:"etilt"`
	Mtilt             string `json:"mtilt"`
	Antennatype       string `json:"antennatype"`
	Antennamodel      string `json:"antennamodel"`
	Ecgi              string `json:"ecgi"`
	SiteID            int64  `json:"site_id"`
	CarrierID         int64  `json:"carrier_id"`
	ServiceareatypeID int64  `json:"serviceareatype_id"`
}

type UpdateCityParams 

type UpdateCityParams struct {
	ID       int64  `json:"id"`
	CityName string `json:"city_name"`
	CityDesc string `json:"city_desc"`
	StateID  int64  `json:"state_id"`
}

type UpdateClutterParams 

type UpdateClutterParams struct {
	ID          int64  `json:"id"`
	ClutterName string `json:"clutter_name"`
	ClutterDesc string `json:"clutter_desc"`
}

type UpdateContinentParams 

type UpdateContinentParams struct {
	ID            int64  `json:"id"`
	ContinentName string `json:"continent_name"`
	ContinentDesc string `json:"continent_desc"`
}

type UpdateCountryParams 

type UpdateCountryParams struct {
	ID          int64  `json:"id"`
	CountryName string `json:"country_name"`
	CountryDesc string `json:"country_desc"`
	ContinentID int64  `json:"continent_id"`
}

type UpdateDistrictParams 

type UpdateDistrictParams struct {
	ID           int64  `json:"id"`
	DistrictName string `json:"district_name"`
	DistrictDesc string `json:"district_desc"`
	CityID       int64  `json:"city_id"`
}

type UpdatePropertyParams 

type UpdatePropertyParams struct {
	ID           int64   `json:"id"`
	PropertyName string  `json:"property_name"`
	Lat          float32 `json:"lat"`
	Long         float32 `json:"long"`
	BlockID      int64   `json:"block_id"`
}

type UpdateServiceareatypeParams 

type UpdateServiceareatypeParams struct {
	ID                  int64  `json:"id"`
	ServiceareatypeName string `json:"serviceareatype_name"`
	ServiceareatypeDesc string `json:"serviceareatype_desc"`
}

type UpdateSessionParams 

type UpdateSessionParams struct {
	ID           uuid.UUID `json:"id"`
	Username     string    `json:"username"`
	RefreshToken string    `json:"refresh_token"`
	UserAgent    string    `json:"user_agent"`
	ClientIp     string    `json:"client_ip"`
	IsBlocked    bool      `json:"is_blocked"`
	ExpiresAt    time.Time `json:"expires_at"`
	CreatedAt    time.Time `json:"created_at"`
}

type UpdateSiteParams 

type UpdateSiteParams struct {
	ID             int64     `json:"id"`
	SiteName       string    `json:"site_name"`
	SiteNameOld    string    `json:"site_name_old"`
	SiteIDGivin    string    `json:"site_id_givin"`
	SiteIDGivinOld string    `json:"site_id_givin_old"`
	Lac            string    `json:"lac"`
	Rac            string    `json:"rac"`
	Rnc            string    `json:"rnc"`
	SiteOnAirDate  time.Time `json:"site_on_air_date"`
	PropertyID     int64     `json:"property_id"`
	SitetypeID     int64     `json:"sitetype_id"`
	VendorID       int64     `json:"vendor_id"`
}

type UpdateSitetypeParams 

type UpdateSitetypeParams struct {
	ID       int64  `json:"id"`
	TypeName string `json:"type_name"`
	TypeDesc string `json:"type_desc"`
}

type UpdateStateParams 

type UpdateStateParams struct {
	ID        int64  `json:"id"`
	StateName string `json:"state_name"`
	StateDesc string `json:"state_desc"`
	CountryID int64  `json:"country_id"`
	AreaID    int64  `json:"area_id"`
}

type UpdateTechParams 

type UpdateTechParams struct {
	ID       int64  `json:"id"`
	TechName string `json:"tech_name"`
	TechDesc string `json:"tech_desc"`
}

type UpdateTownParams 

type UpdateTownParams struct {
	ID         int64  `json:"id"`
	TownName   string `json:"town_name"`
	TownDesc   string `json:"town_desc"`
	DistrictID int64  `json:"district_id"`
}

type UpdateTrafficParams 

type UpdateTrafficParams struct {
	ID                       int64     `json:"id"`
	TrafficDate              time.Time `json:"traffic_date"`
	Avgdailydldatamb         float32   `json:"avgdailydldatamb"`
	Avgdailyuldatamb         float32   `json:"avgdailyuldatamb"`
	Avgdailytotdatamb        float32   `json:"avgdailytotdatamb"`
	Avgdailytotvoicemin      float32   `json:"avgdailytotvoicemin"`
	Avgdailytotvideomin      float32   `json:"avgdailytotvideomin"`
	Qci1Data                 float32   `json:"qci1_data"`
	Qci6Data                 float32   `json:"qci6_data"`
	Qci8Data                 float32   `json:"qci8_data"`
	QciOtherData             float32   `json:"qci_other_data"`
	Avgdailytotvoicemin4g    float32   `json:"avgdailytotvoicemin4g"`
	Avgdailytotvoicemintotal float32   `json:"avgdailytotvoicemintotal"`
	Userdlthroughput         float32   `json:"userdlthroughput"`
	Dlpacketlossrate         float32   `json:"dlpacketlossrate"`
	Overallpsdropcallrate    float32   `json:"overallpsdropcallrate"`
	Bhdldatamb               float32   `json:"bhdldatamb"`
	Bhupdatamb               float32   `json:"bhupdatamb"`
	Bhtotdatamb              float32   `json:"bhtotdatamb"`
	Bhtotvoicemin            float32   `json:"bhtotvoicemin"`
	Bhtotvideomin            float32   `json:"bhtotvideomin"`
	Bhcsusers                float32   `json:"bhcsusers"`
	Bhhsupausers             float32   `json:"bhhsupausers"`
	Bhhsdpausers             float32   `json:"bhhsdpausers"`
	Bhr99uldl                float32   `json:"bhr99uldl"`
	Powercapacity            float32   `json:"powercapacity"`
	Powerutilization         float32   `json:"powerutilization"`
	Codecapacity             float32   `json:"codecapacity"`
	Codeutilization          float32   `json:"codeutilization"`
	Ceulcapacity             float32   `json:"ceulcapacity"`
	Ceulutilization          float32   `json:"ceulutilization"`
	Cedlcapacity             float32   `json:"cedlcapacity"`
	Cedlutilization          float32   `json:"cedlutilization"`
	Iubcapacity              float32   `json:"iubcapacity"`
	Iubutlization            float32   `json:"iubutlization"`
	Bhrrcusers               float32   `json:"bhrrcusers"`
	CellID                   int64     `json:"cell_id"`
}

type UpdateUserParams 

type UpdateUserParams struct {
	Username          string    `json:"username"`
	HashedPassword    string    `json:"hashed_password"`
	FullName          string    `json:"full_name"`
	Email             string    `json:"email"`
	PasswordChangedAt time.Time `json:"password_changed_at"`
	Role              string    `json:"role"`
}

type UpdateVendorParams 

type UpdateVendorParams struct {
	ID         int64  `json:"id"`
	VendorName string `json:"vendor_name"`
	VendorDesc string `json:"vendor_desc"`
}

type User 

type User struct {
	Username          string    `json:"username"`
	HashedPassword    string    `json:"hashed_password"`
	FullName          string    `json:"full_name"`
	Email             string    `json:"email"`
	PasswordChangedAt time.Time `json:"password_changed_at"`
	PasswordCreatedAt time.Time `json:"password_created_at"`
	Role              string    `json:"role"`
}

type Vendor 

type Vendor struct {
	ID         int64  `json:"id"`
	VendorName string `json:"vendor_name"`
	VendorDesc string `json:"vendor_desc"`
}

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.