package tutorial;

import static org.junit.jupiter.api.Assertions.*;

import org.junit.jupiter.api.Test;

class LessonTest {

  @Test
  void staleWriteCannotOverwriteAndRollbackPreservesState() throws Exception {
    try (var a = VersionedStore.connect(); var b = VersionedStore.connect()) {
      try (var s = a.createStatement()) {
        s.execute(
          "CREATE TABLE vehicles(id INT PRIMARY KEY,name TEXT NOT NULL,version INT NOT NULL)"
        );
        s.execute("INSERT INTO vehicles VALUES(1,'Original',1)");
      }
      a.setAutoCommit(false);
      b.setAutoCommit(false);
      assertEquals(1, VersionedStore.update(a, "First", 1));
      a.commit();
      assertEquals(0, VersionedStore.update(b, "Stale", 1));
      b.rollback();
      assertEquals(1, VersionedStore.update(a, "Temporary", 2));
      a.rollback();
      try (
        var s = b.createStatement();
        var r = s.executeQuery("SELECT name,version FROM vehicles WHERE id=1")
      ) {
        assertTrue(r.next());
        assertEquals("First", r.getString(1));
        assertEquals(2, r.getInt(2));
      }
      b.rollback();
      assertEquals(1, VersionedStore.update(b, "Reviewed", 2));
      b.commit();
      try (
        var s = b.createStatement();
        var r = s.executeQuery("SELECT name,version FROM vehicles WHERE id=1")
      ) {
        assertTrue(r.next());
        assertEquals("Reviewed", r.getString(1));
        assertEquals(3, r.getInt(2));
      }
    }
  }
}
