public static String getVertexAnnotations(Config config) {
return "SELECT TO_TIMESTAMP(V.TIME_A,'SSSSS') ARRIVAL_TIME, TO_TIMESTAMP(V.TIME_D,'SSSSS') DEPARTURE_TIME, R.ROUTE_SHORT_NAME, R.ROUTE_TYPE FROM "
+ config.getDestinationVertexAnnotatedTableEntry().getTableName()
+ " V, "
+ config.getRouteTable()
+ " R WHERE V.ROUTE_ID=R.ROUTE_ID";
}
/**
* Method getNodeRouteAnnotations
*
* @param config
* @return
*/
public static final String getNodeRoutesAnnotations(Config config) {
return "SELECT R.ROUTE_SHORT_NAME,R.ROUTE_TYPE FROM "
+ config.getRouteTable()
+ " R, "
+ config.getProperty("result.route_vertices")
+ " V"
+ " WHERE R.ID=V.ROUTE_ID";
}