package tutorial;

import java.sql.*;

public class VersionedStore {

  public static Connection connect() throws SQLException {
    return DriverManager.getConnection(
      System.getenv("LEARNING_DATABASE_URL"),
      "learning",
      "learning"
    );
  }

  public static int update(Connection c, String name, int expected)
    throws SQLException {
    try (
      var s = c.prepareStatement(
        "UPDATE vehicles SET name=?,version=version+1 WHERE id=1 AND version=?"
      )
    ) {
      s.setString(1, name);
      s.setInt(2, expected);
      return s.executeUpdate();
    }
  }
}
