package com.ankurm.testing;

import org.junit.jupiter.api.AfterEach;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

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

    private Connection connection;

    @BeforeEach
    void setUpConnection() throws SQLException {
        connection = DriverManager.getConnection("jdbc:h2:mem:testdb", "sa", "");
        System.out.println("Database connection established.");
    }

    @AfterEach
    void closeConnection() throws SQLException {
        if (connection != null && !connection.isClosed()) {
            connection.close();
            System.out.println("Database connection closed.");
        }
    }

    @Test
    void testUserInsertion() {
        System.out.println("Testing user insertion logic...");
    }
}
