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(-)
(limited to 'src')
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