1
2
3
4 package org.melati.poem.test;
5
6 import org.melati.poem.CachedExists;
7
8
9
10
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
30
31 public void testCachedExistsTableStringTableArray() {
32
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
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
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 }