import type { IDatabase, IMain } from 'pg-promise';
import type { SquareByTransitRoute } from '../models';
import type { ColumnSet } from 'pg-promise';
export declare class SquareByTransitRouteRepository {
    db: IDatabase<any>;
    pgp: IMain;
    cs: ColumnSet;
    constructor(db: IDatabase<any>, pgp: IMain);
    list(): Promise<SquareByTransitRoute[]>;
    listByTablePeriodId(table_period_id: number): Promise<SquareByTransitRoute[]>;
    listByRouteIds(table_period_id: number, route_ids: string[]): Promise<SquareByTransitRoute[]>;
    listByRouteIdsWithMaxDistance(table_period_id: number, route_ids: string[], max_distance: number): Promise<SquareByTransitRoute[]>;
    listByTablePeriodIdDistinct(table_period_id: number): Promise<BigInt[]>;
    listByRouteIdsDistinct(table_period_id: number, route_ids: string[]): Promise<BigInt[]>;
    listByRouteIdsWithMaxDistanceDistinct(table_period_id: number, route_ids: string[], max_distance: number): Promise<BigInt[]>;
    add(square_by_transit_route: SquareByTransitRoute): Promise<SquareByTransitRoute>;
    bulk_insert(squares_by_transit_route: SquareByTransitRoute[]): Promise<void>;
}