View Javadoc
1   /**
2    * 
3    */
4   package org.melati.poem.test;
5   
6   import org.melati.poem.CachedExists;
7   
8   /**
9    * @author timp
10   * @since 31/10/2006
11   */
12  public class CachedExistsTest extends PoemTestCase {
13  
14    public CachedExistsTest(String name) {
15      super(name);
16    }
17  
18    protected void setUp()
19        throws Exception {
20      super.setUp();
21    }
22  
23    protected void tearDown()
24        throws Exception {
25      super.tearDown();
26    }
27  
28    /**
29     * @see org.melati.poem.CachedExists#CachedExists
30     */
31    public void testCachedExistsTableStringTableArray() {
32      // FIXME work out good use case
33      int queries = getDb().getQueryCount();
34      CachedExists ce = new CachedExists(getDb().getUserTable(), 
35          getDb().getUserTable().troidColumn().fullQuotedName() +" = 0", null);
36      int queries2 = getDb().getQueryCount();
37      assertEquals(queries, queries2);
38      assertTrue(ce.exists());
39      int queries3 = getDb().getQueryCount();
40      assertEquals(queries2 + 1, queries3);
41      assertTrue(ce.exists());
42      int queries4 = getDb().getQueryCount();
43      assertEquals(queries3, queries4);
44  
45    }
46  
47    /**
48     * @see org.melati.poem.CachedExists#CachedExists
49     */
50    public void testCachedExistsTableString() {
51      int queries = getDb().getQueryCount();
52      CachedExists ce = new CachedExists(getDb().getUserTable(), 
53          getDb().getUserTable().troidColumn().fullQuotedName() +" = 0");
54      int queries2 = getDb().getQueryCount();
55      assertEquals(queries, queries2);
56      assertTrue(ce.exists());
57      int queries3 = getDb().getQueryCount();
58      assertEquals(queries2 + 1, queries3);
59      assertTrue(ce.exists());
60      int queries4 = getDb().getQueryCount();
61      assertEquals(queries3, queries4);
62  
63    }
64  
65    /**
66     * @see org.melati.poem.CachedExists#exists()
67     */
68    public void testExists() {
69      int queries = getDb().getQueryCount();
70      CachedExists ce = new CachedExists(getDb().getUserTable(), 
71          getDb().getUserTable().troidColumn().fullQuotedName() +" = 0");
72      int queries2 = getDb().getQueryCount();
73      assertEquals(queries, queries2);
74      assertTrue(ce.exists());
75      int queries3 = getDb().getQueryCount();
76      assertEquals(queries2 + 1, queries3);
77      assertTrue(ce.exists());
78      int queries4 = getDb().getQueryCount();
79      assertEquals(queries3, queries4);
80  
81    }
82  
83  }