Changeset cd64b06 for backend/GlobeGuru-backend/src/main/java/DatabaseUtil.java

Timestamp:

01/11/25 01:23:10 (5 days ago)

Author:

Kristijan <kristijanzafirovski26@…>

Branches:

master

Children:

0a7426e

Parents:

1c51912

Message:

Added info scraping for escape travel

File:

• backend/GlobeGuru-backend/src/main/java/DatabaseUtil.java (modified) (2 diffs)

backend/GlobeGuru-backend/src/main/java/DatabaseUtil.java

@@ -151 +151 @@
                 "FROM options o " +
                 "LEFT JOIN optionDetails od ON o.id = od.optionId " +
-                "WHERE (o.country LIKE ? OR o.hotelName LIKE ?)";
+                "WHERE (o.country LIKE ? OR o.hotelName LIKE ?) " +
+                "AND od.type IS NOT NULL " +
+                "AND od.board IS NOT NULL " +
+                "AND od.price > 0";
 
         if (dateQuery != null && !dateQuery.isEmpty() && !dateFlag) {
@@ -200 +203 @@
         return options;
     }
+