Add place field to TeamTeilnahme with getter and setter logic, including database update handling

CommonCore/SQL/src/de/steamwar/sql/TeamTeilnahme.java

@@ -24,11 +24,13 @@ import de.steamwar.sql.internal.SelectStatement;
 import de.steamwar.sql.internal.Statement;
 import de.steamwar.sql.internal.Table;
 import lombok.AllArgsConstructor;
+import lombok.Getter;
 
 import java.util.Set;
 import java.util.stream.Collectors;
 
 @AllArgsConstructor
+@Getter
 public class TeamTeilnahme {
 
     private static final Table<TeamTeilnahme> table = new Table<>(TeamTeilnahme.class);
@@ -38,16 +40,28 @@ public class TeamTeilnahme {
     private static final Statement insert = table.insert(Table.PRIMARY);
     private static final Statement delete = table.delete(Table.PRIMARY);
     private static final Statement deleteFuture = new Statement("DELETE t FROM TeamTeilnahme t INNER JOIN Event e ON t.EventID = e.EventID WHERE t.TeamID = ? AND e.Start > NOW()");
+    private static final Statement update = table.update(Table.PRIMARY, "Place");
 
     @Field(keys = {Table.PRIMARY})
     private final int teamId;
     @Field(keys = {Table.PRIMARY})
     private final int eventId;
+    @Field
+    private int place;
+
+    public void setPlace(int place) {
+        update.update(place, teamId, eventId);
+        this.place = place;
+    }
 
     public static boolean nimmtTeil(int teamID, int eventID){
         return select.select(teamID, eventID) != null;
     }
 
+    public static TeamTeilnahme get(int teamID, int eventID) {
+        return select.select(teamID, eventID);
+    }
+
     public static void teilnehmen(int teamID, int eventID){
         insert.update(teamID, eventID);
     }