108 lines
7.3 KiB
Go
108 lines
7.3 KiB
Go
|
// Code generated by sqlc. DO NOT EDIT.
|
||
|
|
// versions:
|
||
|
|
// sqlc v1.31.1
|
||
|
|
|
||
|
|
package db
|
||
|
|
|
||
|
|
import (
|
||
|
|
"context"
|
||
|
|
"database/sql"
|
||
|
|
)
|
||
|
|
|
||
|
|
type Querier interface {
|
||
|
|
AddBuildingToAirportByUsername(ctx context.Context, arg AddBuildingToAirportByUsernameParams) (sql.Result, error)
|
||
|
|
AddContractToAirport(ctx context.Context, arg AddContractToAirportParams) (sql.Result, error)
|
||
|
|
AddCountry(ctx context.Context, arg AddCountryParams) (sql.Result, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 4. BUILDINGS & PRODUCTION ENGINE
|
||
|
|
// ============================================================================
|
||
|
|
AddRecipe(ctx context.Context, arg AddRecipeParams) (sql.Result, error)
|
||
|
|
Addproduct(ctx context.Context, name string) (sql.Result, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 5. FLEET & DYNAMIC INFRASTRUCTURE OPERATIONS
|
||
|
|
// ============================================================================
|
||
|
|
BuyPlaneForPlayer(ctx context.Context, arg BuyPlaneForPlayerParams) (sql.Result, error)
|
||
|
|
CheckHangarOccupancy(ctx context.Context, currentBuildingID sql.NullInt32) (int64, error)
|
||
|
|
CheckHangarOccupancyByUsername(ctx context.Context, arg CheckHangarOccupancyByUsernameParams) (int64, error)
|
||
|
|
// specific hangar
|
||
|
|
CheckRunwayOccupancyByUsername(ctx context.Context, arg CheckRunwayOccupancyByUsernameParams) (int64, error)
|
||
|
|
CompleteContract(ctx context.Context, id uint32) error
|
||
|
|
// ============================================================================
|
||
|
|
// 2. AIRPORT CORE MANAGEMENT
|
||
|
|
// ============================================================================
|
||
|
|
// airport row management
|
||
|
|
CreateAirportByUserName(ctx context.Context, arg CreateAirportByUserNameParams) (sql.Result, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 1. AUTHENTICATION & USERS
|
||
|
|
// ============================================================================
|
||
|
|
CreateUser(ctx context.Context, arg CreateUserParams) (sql.Result, error)
|
||
|
|
DeleteAirportByUserName(ctx context.Context, username string) error
|
||
|
|
DeleteUserByUsername(ctx context.Context, username string) error
|
||
|
|
FindAvailableInfrastructure(ctx context.Context, arg FindAvailableInfrastructureParams) (uint32, error)
|
||
|
|
FindAvailableInfrastructureForPlane(ctx context.Context, arg FindAvailableInfrastructureForPlaneParams) (uint32, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 7. PROGRESSION CONTRACTS & ECONOMY LOGS
|
||
|
|
// ============================================================================
|
||
|
|
GetActiveContracts(ctx context.Context, airportID uint32) ([]GetActiveContractsRow, error)
|
||
|
|
GetActiveContractsWithProduct(ctx context.Context, airportID uint32) ([]GetActiveContractsWithProductRow, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 8. MISSING QUERIES (added for TUI — regenerate sqlc after adding these)
|
||
|
|
// ============================================================================
|
||
|
|
GetAirportBuildingsByAirportId(ctx context.Context, airportID uint32) ([]GetAirportBuildingsByAirportIdRow, error)
|
||
|
|
GetAirportBuildingsByUsername(ctx context.Context, username string) ([]GetAirportBuildingsByUsernameRow, error)
|
||
|
|
GetAirportByUserId(ctx context.Context, userID int32) (GetAirportByUserIdRow, error)
|
||
|
|
GetAirportByUserName(ctx context.Context, username string) (GetAirportByUserNameRow, error)
|
||
|
|
GetAllBuildings(ctx context.Context) ([]GetAllBuildingsRow, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 3. country
|
||
|
|
// ============================================================================
|
||
|
|
GetAllCountries(ctx context.Context) ([]GetAllCountriesRow, error)
|
||
|
|
GetAllPlanes(ctx context.Context) ([]Plane, error)
|
||
|
|
GetAllProducts(ctx context.Context) ([]Product, error)
|
||
|
|
GetCountryById(ctx context.Context, id uint16) (GetCountryByIdRow, error)
|
||
|
|
GetCountryByName(ctx context.Context, name string) (GetCountryByNameRow, error)
|
||
|
|
GetPlaneById(ctx context.Context, id uint32) (Plane, error)
|
||
|
|
GetPlanesByAircraftSize(ctx context.Context, aircraftSize PlanesAircraftSize) ([]Plane, error)
|
||
|
|
GetPlanesByAircraftType(ctx context.Context, aircraftType PlanesAircraftType) ([]Plane, error)
|
||
|
|
GetPlanesByMinLevel(ctx context.Context, minLevel uint32) ([]Plane, error)
|
||
|
|
GetPlanesByOperationType(ctx context.Context, operationType PlanesOperationType) ([]Plane, error)
|
||
|
|
// ============================================================================
|
||
|
|
// 6. TIME-BASED FLIGHT ENGINE
|
||
|
|
// ============================================================================
|
||
|
|
GetPlanesReadyToLand(ctx context.Context) ([]GetPlanesReadyToLandRow, error)
|
||
|
|
// specific runway
|
||
|
|
GetPlanesReadyToLandByUsername(ctx context.Context, username string) ([]GetPlanesReadyToLandByUsernameRow, error)
|
||
|
|
GetPlayerFleet(ctx context.Context, airportID uint32) ([]GetPlayerFleetRow, error)
|
||
|
|
GetPlayerPlanesByUsername(ctx context.Context, username string) ([]GetPlayerPlanesByUsernameRow, error)
|
||
|
|
GetProductById(ctx context.Context, id uint16) (Product, error)
|
||
|
|
GetUserByUsername(ctx context.Context, username string) (GetUserByUsernameRow, error)
|
||
|
|
GetUserIdByUsername(ctx context.Context, username string) (int32, error)
|
||
|
|
LogCompletedFlightRoute(ctx context.Context, arg LogCompletedFlightRouteParams) error
|
||
|
|
LogCurrencyTransaction(ctx context.Context, arg LogCurrencyTransactionParams) error
|
||
|
|
UpdateAirportCash(ctx context.Context, arg UpdateAirportCashParams) error
|
||
|
|
// airport resource management
|
||
|
|
UpdateAirportCurrencies(ctx context.Context, arg UpdateAirportCurrenciesParams) error
|
||
|
|
UpdateAirportFuel(ctx context.Context, arg UpdateAirportFuelParams) error
|
||
|
|
UpdateAirportFuelRate(ctx context.Context, arg UpdateAirportFuelRateParams) error
|
||
|
|
UpdateAirportMaxFuel(ctx context.Context, arg UpdateAirportMaxFuelParams) error
|
||
|
|
UpdateAirportPassengerRate(ctx context.Context, arg UpdateAirportPassengerRateParams) error
|
||
|
|
UpdateAirportResources(ctx context.Context, id uint32) error
|
||
|
|
UpdateAirportResourcesUpdated(ctx context.Context, arg UpdateAirportResourcesUpdatedParams) error
|
||
|
|
UpdateAirportmaxPassengers(ctx context.Context, arg UpdateAirportmaxPassengersParams) error
|
||
|
|
UpdateAirportpassengers(ctx context.Context, arg UpdateAirportpassengersParams) error
|
||
|
|
UpdateContractDelivery(ctx context.Context, arg UpdateContractDeliveryParams) error
|
||
|
|
UpdatePlaneState(ctx context.Context, arg UpdatePlaneStateParams) error
|
||
|
|
UpdatePlayerPlaneState(ctx context.Context, arg UpdatePlayerPlaneStateParams) error
|
||
|
|
UpdateUserPasswordByUserName(ctx context.Context, arg UpdateUserPasswordByUserNameParams) error
|
||
|
|
addBuilding(ctx context.Context, arg addBuildingParams) (sql.Result, error)
|
||
|
|
addOperationalBuilding(ctx context.Context, arg addOperationalBuildingParams) (sql.Result, error)
|
||
|
|
addPassiveProductionBuilding(ctx context.Context, arg addPassiveProductionBuildingParams) (sql.Result, error)
|
||
|
|
// planes & fleet management
|
||
|
|
addPlane(ctx context.Context, arg addPlaneParams) (sql.Result, error)
|
||
|
|
addPlaneToAirportByUsername(ctx context.Context, arg addPlaneToAirportByUsernameParams) (sql.Result, error)
|
||
|
|
addStorageBuilding(ctx context.Context, arg addStorageBuildingParams) (sql.Result, error)
|
||
|
|
updatePlayerExperience(ctx context.Context, arg updatePlayerExperienceParams) error
|
||
|
|
updatePlayerLevel(ctx context.Context, arg updatePlayerLevelParams) error
|
||
|
|
}
|
||
|
|
|
||
|
|
var _ Querier = (*Queries)(nil)
|