src/test/java/com/cs102/attendance/Cs102AttendanceProjectApplicationTests.java

// package com.cs102.attendance;

// import com.cs102.attendance.repository.TestConnectionRepository;
// import org.junit.jupiter.api.Test;
// import org.springframework.beans.factory.annotation.Autowired;
// import org.springframework.boot.test.context.SpringBootTest;

// import javax.sql.DataSource;
// import java.sql.Connection;
// import java.sql.SQLException;

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

// @SpringBootTest
// class Cs102AttendanceProjectApplicationTests {

// 	@Autowired
// 	private DataSource dataSource;

// 	@Autowired
// 	private TestConnectionRepository testConnectionRepository;

// 	@Test
// 	void contextLoads() {
// 	}

// 	@Test
// 	void testDatabaseConnection() throws SQLException {
// 		// Test that we can get a connection from the DataSource
// 		try (Connection connection = dataSource.getConnection()) {
// 			assertNotNull(connection, "Database connection should not be null");
// 			assertTrue(connection.isValid(5), "Database connection should be valid");
			
// 			// Print connection details for verification
// 			System.out.println("Database URL: " + connection.getMetaData().getURL());
// 			System.out.println("Database Driver: " + connection.getMetaData().getDriverName());
// 			System.out.println("Database Version: " + connection.getMetaData().getDatabaseProductVersion());
// 		}
// 	}

// 	@Test
// 	void testRepositoryConnection() {
// 		// Test that the repository can execute queries
// 		assertDoesNotThrow(() -> {
// 			Integer result = testConnectionRepository.testQuery();
// 			assertEquals(1, result, "Test query should return 1");
// 		}, "Repository test query should not throw an exception");
// 	}

// }