1 package club.wpia.gigi;
3 import static org.junit.Assert.*;
7 import club.wpia.gigi.database.DatabaseConnection;
8 import club.wpia.gigi.database.GigiPreparedStatement;
9 import club.wpia.gigi.testUtils.ConfiguredTest;
11 public class TestSQL extends ConfiguredTest {
14 public void testPrepared() {
15 GigiPreparedStatement[] ps = new GigiPreparedStatement[DatabaseConnection.MAX_CACHED_INSTANCES];
16 String stmt = "SELECT 1 FROM `users`;";
17 for (int i = 0; i < ps.length; i++) {
18 assertEquals(i, DatabaseConnection.getInstance().getNumberOfLockedStatements());
19 ps[i] = new GigiPreparedStatement(stmt);
21 assertEquals(DatabaseConnection.MAX_CACHED_INSTANCES, DatabaseConnection.getInstance().getNumberOfLockedStatements());
22 for (int i = ps.length - 1; i >= 0; i--) {
24 assertEquals(i, DatabaseConnection.getInstance().getNumberOfLockedStatements());
26 for (int i = 0; i < ps.length; i++) {
27 assertEquals(i, DatabaseConnection.getInstance().getNumberOfLockedStatements());
28 ps[i] = new GigiPreparedStatement(stmt);