package com.ankurm.testing;

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

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.junit.jupiter.api.AfterEach;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;

/** Needs the H2 driver (com.h2database:h2) on the test classpath. */
class DatabaseSeedTest {

    private Connection database;

    @BeforeEach
    void initDatabase() throws SQLException {
        database = DriverManager.getConnection("jdbc:h2:mem:seed;DB_CLOSE_DELAY=-1", "sa", "");
        System.out.println("LOG: Cleaning tables and seeding User data...");
        execute("CREATE TABLE IF NOT EXISTS users (id INT PRIMARY KEY, name VARCHAR(50))");
        execute("DELETE FROM users");
        execute("INSERT INTO users (id, name) VALUES (1, 'Ankur')");
    }

    @AfterEach
    void closeDatabase() throws SQLException {
        if (database != null) database.close();
    }

    @Test
    void findUserById() throws SQLException {
        System.out.println("Executing Test: findUserById()");
        try (Statement s = database.createStatement(); ResultSet rs = s.executeQuery("SELECT name FROM users WHERE id = 1")) {
            rs.next();
            assertEquals("Ankur", rs.getString(1));
        }
    }

    @Test
    void deleteUser() throws SQLException {
        System.out.println("Executing Test: deleteUser()");
        execute("DELETE FROM users WHERE id = 1");
        try (Statement s = database.createStatement(); ResultSet rs = s.executeQuery("SELECT COUNT(*) FROM users")) {
            rs.next();
            assertEquals(0, rs.getInt(1));
        }
    }

    private void execute(String sql) throws SQLException {
        try (Statement s = database.createStatement()) { s.execute(sql); }
    }
}
