@Override
    public void setStatementParameters(PreparedStatement statement, boolean setDefaultId) throws SQLException {
    """
	Sets the parameters for a prepared statement following the parameter order defined in
	{@link com.conveyal.gtfs.loader.Table#ROUTES}. JDBC prepared statement parameters use a one-based index.
    """
        int oneBasedIndex = 1;
        if (!setDefaultId) statement.setInt(oneBasedIndex++, id);
        statement.setString(oneBasedIndex++, route_id);
        statement.setString(oneBasedIndex++, agency_id);
        statement.setString(oneBasedIndex++, route_short_name);
        statement.setString(oneBasedIndex++, route_long_name);
        statement.setString(oneBasedIndex++, route_desc);
        setIntParameter(statement, oneBasedIndex++, route_type);
        statement.setString(oneBasedIndex++, route_url != null ? route_url.toString() : null);
        statement.setString(oneBasedIndex++, route_branding_url != null ? route_branding_url.toString() : null);
        statement.setString(oneBasedIndex++, route_color);
        statement.setString(oneBasedIndex++, route_text_color);
        // Editor-specific fields publicly_visible, wheelchair_accessible, route_sort_order, and status.
        setIntParameter(statement, oneBasedIndex++, 0);
        setIntParameter(statement, oneBasedIndex++, 0);
        // route_sort_order
        setIntParameter(statement, oneBasedIndex++, route_sort_order);
        setIntParameter(statement, oneBasedIndex++, 0);
    }
@Override
    public void setStatementParameters(PreparedStatement statement, boolean setDefaultId) throws SQLException {
        int oneBasedIndex = 1;
        if (!setDefaultId) statement.setInt(oneBasedIndex++, id);
        statement.setString(oneBasedIndex++, route_id);
        statement.setString(oneBasedIndex++, agency_id);
        statement.setString(oneBasedIndex++, route_short_name);
        statement.setString(oneBasedIndex++, route_long_name);
        statement.setString(oneBasedIndex++, route_desc);
        setIntParameter(statement, oneBasedIndex++, route_type);
        statement.setString(oneBasedIndex++, route_url != null ? route_url.toString() : null);
        statement.setString(oneBasedIndex++, route_branding_url != null ? route_branding_url.toString() : null);
        statement.setString(oneBasedIndex++, route_color);
        statement.setString(oneBasedIndex++, route_text_color);
        // Editor-specific fields publicly_visible, wheelchair_accessible, route_sort_order, and status.
        setIntParameter(statement, oneBasedIndex++, 0);
        setIntParameter(statement, oneBasedIndex++, 0);
        // route_sort_order
        setIntParameter(statement, oneBasedIndex++, route_sort_order);
        setIntParameter(statement, oneBasedIndex++, 0);
    }
@ Override public void setStatementParameters ( PreparedStatement statement , boolean setDefaultId ) throws SQLException { int oneBasedIndex = 1 ; if ( ! setDefaultId ) statement . setInt ( oneBasedIndex ++ , id ) ; statement . setString ( oneBasedIndex ++ , route_id ) ; statement . setString ( oneBasedIndex ++ , agency_id ) ; statement . setString ( oneBasedIndex ++ , route_short_name ) ; statement . setString ( oneBasedIndex ++ , route_long_name ) ; statement . setString ( oneBasedIndex ++ , route_desc ) ; setIntParameter ( statement , oneBasedIndex ++ , route_type ) ; statement . setString ( oneBasedIndex ++ , route_url != null ? route_url . toString ( ) : null ) ; statement . setString ( oneBasedIndex ++ , route_branding_url != null ? route_branding_url . toString ( ) : null ) ; statement . setString ( oneBasedIndex ++ , route_color ) ; statement . setString ( oneBasedIndex ++ , route_text_color ) ; // Editor-specific fields publicly_visible, wheelchair_accessible, route_sort_order, and status. setIntParameter ( statement , oneBasedIndex ++ , 0 ) ; setIntParameter ( statement , oneBasedIndex ++ , 0 ) ; // route_sort_order setIntParameter ( statement , oneBasedIndex ++ , route_sort_order ) ; setIntParameter ( statement , oneBasedIndex ++ , 0 ) ; }
Sets the parameters for a prepared statement following the parameter order defined in
{@link com.conveyal.gtfs.loader.Table#ROUTES}. JDBC prepared statement parameters use a one-based index.
Sets the parameters for a prepared statement following the parameter order defined in {