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 getInsertVertexAnnotationString
*
* @param config
* @return
*/
public static String getInsertVertexAnnotationString(Config config) {
return "INSERT INTO "
+ config.getDestinationVertexAnnotatedTableEntry().getTableName()
+ " (\"ID\", \"ROUTE_ID\",\"TIME_A\",\"TIME_D\") VALUES (?,?,?,?)";
}