From 824e8cb818820b313b7dd08d8f72932b8ca7d41d Mon Sep 17 00:00:00 2001
From: Dominic Rogetzer <e1627756@student.tuwien.ac.at>
Date: Tue, 19 Jun 2018 18:29:39 +0200
Subject: Set status of vehicles to 'ZUM_BERUFUNGSORT' when creating op
 [#25963]

---
 .../groupphase/missioncontrol/dao/OperationDatabaseDAO.java      | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/missioncontrol/dao/OperationDatabaseDAO.java b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/missioncontrol/dao/OperationDatabaseDAO.java
index 53682f9..238a2a8 100644
--- a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/missioncontrol/dao/OperationDatabaseDAO.java
+++ b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/missioncontrol/dao/OperationDatabaseDAO.java
@@ -114,16 +114,23 @@ public class OperationDatabaseDAO implements OperationDAO {
         String sql =
                 "INSERT INTO VehicleOperation(vehicleId, operationId)"
                         + " SELECT version, ? FROM Vehicle WHERE id = ?";
+        String sqlUpdateVehicleStatus =
+                "UPDATE Vehicle SET status = 'ZUM_BERUFUNGSORT' WHERE id = ?";
 
-        try (PreparedStatement pstmt = con.prepareStatement(sql)) {
+        try (PreparedStatement pstmt = con.prepareStatement(sql);
+                PreparedStatement stmtUpdateVehicleStatus =
+                        con.prepareStatement(sqlUpdateVehicleStatus)) {
             pstmt.setLong(1, operationId);
 
             for (long id : (Iterable<Long>) vehicles.stream().map(Vehicle::id)::iterator) {
                 pstmt.setLong(2, id);
+                stmtUpdateVehicleStatus.setLong(1, id);
                 pstmt.addBatch();
+                stmtUpdateVehicleStatus.addBatch();
             }
 
             pstmt.executeBatch();
+            stmtUpdateVehicleStatus.executeBatch();
         }
     }
 
-- 
cgit v1.2.3-70-g09d2