Source code: org/acs/damsel/srvr/db/TestLowAssetDB.java
1 package org.acs.damsel.srvr.db;
2
3 import junit.framework.*;
4 import java.sql.*;
5 import java.util.*;
6 import java.util.Vector;
7 import org.acs.damsel.srvr.*;
8 import org.apache.log4j.*;
9 import org.acs.damsel.srvr.asset.*;
10 import org.acs.damsel.srvr.schema.*;
11 import org.acs.damsel.srvr.collection.*;
12 import org.acs.damsel.srvr.collection.Collection;
13 import java.lang.reflect.*;
14 import org.acs.damsel.srvr.db.*;
15 import org.acs.damsel.srvr.db.Table;
16
17 public class TestLowAssetDB
18 extends TestCase {
19 private LowAssetDB lowAssetDB = null;
20
21 protected void setUp() throws Exception {
22 super.setUp();
23 lowAssetDB = new LowAssetDB();
24 }
25
26 protected void tearDown() throws Exception {
27 lowAssetDB = null;
28 super.tearDown();
29 }
30
31 public void testGenericQuery() {
32 String query = "SELECT * FROM AssetTable";
33 Table resultTable = null;
34 Vector results = null;
35 Vector row = null;
36 String str = null;
37
38 try {
39 lowAssetDB = new LowAssetDB();
40 resultTable = lowAssetDB.executeQuery(query);
41 results = resultTable.getResults();
42 this.assertNotNull(results);
43 }
44 catch (SQLException ex) {
45 this.fail("Caught unexpected SQLException during testGenericQuery");
46 ex.printStackTrace();
47 }
48 }
49
50 // fills the permissions table with all possible permissions
51 /*public void testFillPermissions() {
52 String table = "PermissionsTable";
53 String pid;
54 Vector columnNames = new Vector();
55 Vector columnValues = new Vector();
56 columnNames.add("PermissionID");
57 columnNames.add("ownerRead");
58 columnNames.add("ownerWrite");
59 columnNames.add("ownerDelete");
60 columnNames.add("groupRead");
61 columnNames.add("groupWrite");
62 columnNames.add("groupDelete");
63 columnNames.add("othersRead");
64 columnNames.add("othersWrite");
65 columnNames.add("othersDelete");
66 for(int i = 0; i < 512; i++) {
67 pid = Integer.toString(i);
68 columnValues.add(pid);
69 if((i & 1) != 0) {columnValues.add("true");} else {columnValues.add("false");}
70 if((i & 2) != 0) {columnValues.add("true");} else {columnValues.add("false");}
71 if((i & 4) != 0) {columnValues.add("true");} else {columnValues.add("false");}
72 if((i & 8) != 0) {columnValues.add("true");} else {columnValues.add("false");}
73 if((i & 16) != 0) {columnValues.add("true");} else {columnValues.add("false");}
74 if((i & 32) != 0) {columnValues.add("true");} else {columnValues.add("false");}
75 if((i & 64) != 0) {columnValues.add("true");} else {columnValues.add("false");}
76 if((i & 128) != 0) {columnValues.add("true");} else {columnValues.add("false");}
77 if((i & 256) != 0) {columnValues.add("true");} else {columnValues.add("false");}
78
79 try {
80 MidAssetDB.instance().insert(table, columnNames, columnValues);
81 }
82 catch (SQLException ex) {
83 System.out.println(ex.getMessage());
84 this.fail("caught unexpected SQLException");
85 }
86 System.out.println(columnValues);
87 columnValues.clear();
88 }
89 }*/
90
91 }