Getting Property Out of a Variable in Python Gremlin Query

I've been working on attempting to find a performance way to route from point A to point B.

Right now my schema is as follows

Vertex Labels:

Airport:
- Properties: airport: Airport code.
Day:
- Properties: Datestamp representing the day.

Edge Labels:

has_flights_on:
- Connects Airport to Day.
- Indicates an airport has flights on a specific day.
flight:
- Connects Day to Airport (destination).
- Properties: flight_id, origin, destination, start_timestamp, end_timestamp, capacity, tail_number, equipment_type.

Graph Structure:

Airport vertex for each airport.
Day vertex for specific days connected to airports with flights.
has_flights_on edges connect Airport to Day.
flight edges connect Day to Airport, representing flights.

Example:

Airport (JFK) -> has_flights_on -> Day (2023-08-03) -> flight -> Airport (LAX)
- Indicates a flight from JFK to LAX on August 3, 2023.

This is my query right now

        g.V().has('Airport', 'airport', origin) # find origin airport
        .as_('current_airport')
        .repeat(
            __.out('has_flights_on')  # Go to the corresponding Day vertex
            .has('date', gte(start_datestamp))
            .has('date', lte(end_datestamp))
            .outE('flight')  # Go to the Flight edge  .where(__.values('origin').is_(__.select('current_airport').values('airport'))) # this is the problem
            .inV().hasLabel('Airport')  # Go to the destination Airport vertex
            .as_('current_airport')  # Update the current airport alias
            .simplePath()  # Ensure that the path doesn't contain cycles
        )
        .until(__.has('airport', destination).or_().loops().is_(4))  # Finish when destination is reached or max hops exceeded
        .has('airport', destination)
        .path()
        .by(__.valueMap('airport', 'flight_id', 'start_timestamp', 'end_timestamp'))
        .toList()

        g.V().has('Airport', 'airport', origin) # find origin airport
        .as_('current_airport')
        .repeat(
            __.out('has_flights_on')  # Go to the corresponding Day vertex
            .has('date', gte(start_datestamp))
            .has('date', lte(end_datestamp))
            .outE('flight')  # Go to the Flight edge  .where(__.values('origin').is_(__.select('current_airport').values('airport'))) # this is the problem
            .inV().hasLabel('Airport')  # Go to the destination Airport vertex
            .as_('current_airport')  # Update the current airport alias
            .simplePath()  # Ensure that the path doesn't contain cycles
        )
        .until(__.has('airport', destination).or_().loops().is_(4))  # Finish when destination is reached or max hops exceeded
        .has('airport', destination)
        .path()
        .by(__.valueMap('airport', 'flight_id', 'start_timestamp', 'end_timestamp'))
        .toList()

        g.V().has('Airport', 'airport', origin) # find origin airport
        .as_('current_airport')
        .repeat(
            __.out('has_flights_on')  # Go to the corresponding Day vertex
            .has('date', gte(start_datestamp))
            .has('date', lte(end_datestamp))
            .outE('flight')  # Go to the Flight edge  .where(__.values('origin').is_(__.select('current_airport').values('airport'))) # this is the problem
            .inV().hasLabel('Airport')  # Go to the destination Airport vertex
            .as_('current_airport')  # Update the current airport alias
            .simplePath()  # Ensure that the path doesn't contain cycles
        )
        .until(__.has('airport', destination).or_().loops().is_(4))  # Finish when destination is reached or max hops exceeded
        .has('airport', destination)
        .path()
        .by(__.valueMap('airport', 'flight_id', 'start_timestamp', 'end_timestamp'))
        .toList()

        g.V().has('Airport', 'airport', origin) # find origin airport
        .as_('current_airport')
        .repeat(
            __.out('has_flights_on')  # Go to the corresponding Day vertex
            .has('date', gte(start_datestamp))
            .has('date', lte(end_datestamp))
            .outE('flight')  # Go to the Flight edge  .where(__.values('origin').is_(__.select('current_airport').values('airport'))) # this is the problem
            .inV().hasLabel('Airport')  # Go to the destination Airport vertex
            .as_('current_airport')  # Update the current airport alias
            .simplePath()  # Ensure that the path doesn't contain cycles
        )
        .until(__.has('airport', destination).or_().loops().is_(4))  # Finish when destination is reached or max hops exceeded
        .has('airport', destination)
        .path()
        .by(__.valueMap('airport', 'flight_id', 'start_timestamp', 'end_timestamp'))
        .toList()

The problem is the where, see below for more context.

Getting Property Out of a Variable in Python Gremlin Query

Similar Threads

Similar Threads

Similar Threads