1 package org.cacert.gigi;
3 import static org.junit.Assert.*;
5 import org.cacert.gigi.database.DatabaseConnection;
6 import org.cacert.gigi.database.GigiPreparedStatement;
7 import org.cacert.gigi.testUtils.ConfiguredTest;
10 public class TestSQL extends ConfiguredTest {
13 public void testPrepared() {
14 GigiPreparedStatement[] ps = new GigiPreparedStatement[DatabaseConnection.MAX_CACHED_INSTANCES];
15 String stmt = "SELECT 1 FROM `users`;";
16 for (int i = 0; i < ps.length; i++) {
17 assertEquals(i, DatabaseConnection.getInstance().getNumberOfLockedStatements());
18 ps[i] = new GigiPreparedStatement(stmt);
20 assertEquals(DatabaseConnection.MAX_CACHED_INSTANCES, DatabaseConnection.getInstance().getNumberOfLockedStatements());
21 for (int i = ps.length - 1; i >= 0; i--) {
23 assertEquals(i, DatabaseConnection.getInstance().getNumberOfLockedStatements());
25 for (int i = 0; i < ps.length; i++) {
26 assertEquals(i, DatabaseConnection.getInstance().getNumberOfLockedStatements());
27 ps[i] = new GigiPreparedStatement(stmt);