Changes between Version 1 and Version 2 of SearchRoutesUseCase

Timestamp:

01/12/25 21:39:36 (3 days ago)

Author:

222077

Comment:

--

SearchRoutesUseCase

@@ -10 +10 @@
         * The user may click on a route and view upcoming trips for that route.
     1.2. If no routes match the search criteria, the user is notified accordingly.
+{{{#!sql
+SELECT r.route_id, l1.name AS from_location, l2.name AS to_location, tr.company_name AS organizer_name
+FROM route r
+         JOIN location l1 ON r.from_location_id = l1.location_id
+         JOIN location l2 ON r.to_location_id = l2.location_id
+         JOIN transport_organizer tr ON r.transport_organizer_id = tr.transport_organizer_id
+WHERE l1.name ILIKE '%from_location%'
+  AND l2.name ILIKE '%to_location%'
+}}}