|
1 package allinone;
2
3 import com.lutris.appserver.server.sql.*;
4 import com.lutris.util.*;
5 import org.enhydra.dods.*;
6 import java.sql.SQLException  ;
7
8
9 import javax.swing.*;
10 import java.util.*;
11 import java.awt.*;
12 import java.awt.event.*;
13 import java.net.*;
14 import java.io.*;
15 import org.apache.log4j.Logger;
16 import org.apache.log4j.xml.DOMConfigurator;
17 import com.lutris.appserver.server.sql.*;
18 import allinone.data.tableA.*;
19 import allinone.data.tableB.*;
20 import allinone.data.tableC.*;
21 import allinone.data.tableD.*;
22
23 public class MultiReference{
24 void showTables(DBTransaction dbTrans){
25 try{
26 NDCTableAQuery queryA = new NDCTableAQuery(dbTrans);
27 NDCTableADO[] allADO = queryA.getDOArray();
28 System.err.println();
29 System.err.println("-------------TableA-----begin----------");
30 if(allADO!=null) {
31 if(allADO.length>0)System.err.println("---oid------someData------refToC---refToD-----");
32 for(int i=0; i<allADO.length; i++){
33 System.err.print(" "+allADO[i].getHandle());
34 System.err.print(" "+allADO[i].getSomedata());
35 System.err.print(" "+(null != allADO[i].getReftoc()?allADO[i].getReftoc().getHandle():"null"));
36 System.err.print(" "+(null != allADO[i].getReftob()?allADO[i].getReftob().getHandle():"null"));
37 System.err.println();
38 }
39 } else {
40 System.err.println("noData");
41 }
42 System.err.println("-------------TableA-----end------------");
43
44 NDCTableBQuery queryB = new NDCTableBQuery(dbTrans);
45 NDCTableBDO[] allBDO = queryB.getDOArray();
46 System.err.println();
47 System.err.println("-------------TableB-----begin----------");
48 if(allBDO!=null) {
49 if(allBDO.length>0)System.err.println("---oid------someData------refToD-----");
50 for(int i=0; i<allBDO.length; i++){
51 System.err.print(" "+allBDO[i].getHandle());
52 System.err.print(" "+allBDO[i].getSomedata());
53 System.err.print(" "+(null != allBDO[i].getReftod()?allBDO[i].getReftod().getHandle():"null"));
54 System.err.println();
55 }
56 } else {
57 System.err.println("noData");
58 }
59 System.err.println("-------------TableB-----end------------");
60
61 NDCTableCQuery queryC = new NDCTableCQuery(dbTrans);
62 NDCTableCDO[] allCDO = queryC.getDOArray();
63 System.err.println();
64 System.err.println("-------------TableC-----begin----------");
65 if(allCDO!=null) {
66 if(allCDO.length>0)System.err.println("---oid------someData------refToD-----");
67 for(int i=0; i<allCDO.length; i++){
68 System.err.print(" "+allCDO[i].getHandle());
69 System.err.print(" "+allCDO[i].getSomedata());
70 System.err.print(" "+(null != allCDO[i].getReftod()?allCDO[i].getReftod().getHandle():"null"));
71 System.err.println();
72 }
73 } else {
74 System.err.println("noData");
75 }
76 System.err.println("-------------TableC-----end------------");
77
78 NDCTableDQuery queryD = new NDCTableDQuery(dbTrans);
79 NDCTableDDO[] allDDO = queryD.getDOArray();
80 System.err.println();
81 System.err.println("-------------TableD-----begin----------");
82 if(allDDO!=null) {
83 if(allDDO.length>0)System.err.println("---oid------someData--------");
84 for(int i=0; i<allDDO.length; i++){
85 System.err.print(" "+allDDO[i].getHandle());
86 System.err.print(" "+allDDO[i].getSomedata());
87 System.err.println();
88 }
89 } else {
90 System.err.println("noData");
91 }
92 System.err.println("-------------TableD-----end------------");
93 }catch(Exception e){
94 e.printStackTrace();
95 }
96 }
97
98 public void runTest(DBTransaction dbTrans1) {
99 try {
100 boolean autoWrite = ((StandardDatabaseManager)DODS.getDatabaseManager()).getDatabaseManagerConfiguration().getAutoWrite();
101 System.err.println("___ - + * startin MultRef with unDelete * + - ___");
102 showTables(dbTrans1);
103
104 NDCTableDDO tableD1 = NDCTableDDO.createVirgin(dbTrans1);
105 tableD1.setSomedata("tableD1");
106 tableD1.save();
107 NDCTableDDO tableD2 = NDCTableDDO.createVirgin(dbTrans1);
108 tableD2.setSomedata("tableD2");
109 tableD2.save();
110 NDCTableDDO tableD3 = NDCTableDDO.createVirgin(dbTrans1);
111 tableD3.setSomedata("tableD3");
112 tableD3.save();
113 NDCTableDDO tableD4 = NDCTableDDO.createVirgin(dbTrans1);
114 tableD4.setSomedata("tableD4");
115 tableD4.save();
116 NDCTableDDO tableD5 = NDCTableDDO.createVirgin(dbTrans1);
117 tableD5.setSomedata("tableD5");
118 tableD5.save();
119 NDCTableDDO tableD6 = NDCTableDDO.createVirgin(dbTrans1);
120 tableD6.setSomedata("tableD6");
121 tableD6.save();
122 if(!autoWrite)
123 dbTrans1.write();
124
125 NDCTableCDO tableC1 = NDCTableCDO.createVirgin(dbTrans1);
126 tableC1.setSomedata("tableC1");
127 tableC1.setReftod(tableD1);
128 tableC1.save();
129 NDCTableCDO tableC2 = NDCTableCDO.createVirgin(dbTrans1);
130 tableC2.setSomedata("tableC2");
131 tableC2.setReftod(tableD2);
132 tableC2.save();
133 NDCTableCDO tableC3 = NDCTableCDO.createVirgin(dbTrans1);
134 tableC3.setSomedata("tableC3");
135 tableC3.setReftod(tableD3);
136 tableC3.save();
137 NDCTableCDO tableC4 = NDCTableCDO.createVirgin(dbTrans1);
138 tableC4.setSomedata("tableC4");
139 tableC4.setReftod(tableD4);
140 tableC4.save();
141 NDCTableCDO tableC5 = NDCTableCDO.createVirgin(dbTrans1);
142 tableC5.setSomedata("tableC5");
143 tableC5.setReftod(tableD5);
144 tableC5.save();
145 NDCTableCDO tableC6 = NDCTableCDO.createVirgin(dbTrans1);
146 tableC6.setSomedata("tableC6");
147 tableC6.setReftod(tableD6);
148 tableC6.save();
149 if(!autoWrite)
150 dbTrans1.write();
151
152 NDCTableBDO tableB1 = NDCTableBDO.createVirgin(dbTrans1);
153 tableB1.setSomedata("tableB1");
154 tableB1.setReftod(tableD1);
155 tableB1.save();
156 NDCTableBDO tableB2 = NDCTableBDO.createVirgin(dbTrans1);
157 tableB2.setSomedata("tableB2");
158 tableB2.setReftod(tableD2);
159 tableB2.save();
160 NDCTableBDO tableB3 = NDCTableBDO.createVirgin(dbTrans1);
161 tableB3.setSomedata("tableB3");
162 tableB3.setReftod(tableD3);
163 tableB3.save();
164 NDCTableBDO tableB4 = NDCTableBDO.createVirgin(dbTrans1);
165 tableB4.setSomedata("tableB4");
166 tableB4.setReftod(tableD4);
167 tableB4.save();
168 NDCTableBDO tableB5 = NDCTableBDO.createVirgin(dbTrans1);
169 tableB5.setSomedata("tableB5");
170 tableB5.setReftod(tableD5);
171 tableB5.save();
172 NDCTableBDO tableB6 = NDCTableBDO.createVirgin(dbTrans1);
173 tableB6.setSomedata("tableB6");
174 tableB6.setReftod(tableD6);
175 tableB6.save();
176 if(!autoWrite)
177 dbTrans1.write();
178
179 NDCTableADO tableA1 = NDCTableADO.createVirgin(dbTrans1);
180 tableA1.setSomedata("tableA1");
181 tableA1.setReftob(tableB1);
182 tableA1.setReftoc(tableC1);
183 tableA1.save();
184 NDCTableADO tableA2 = NDCTableADO.createVirgin(dbTrans1);
185 tableA2.setSomedata("tableA2");
186 tableA2.setReftob(tableB2);
187 tableA2.setReftoc(tableC2);
188 tableA2.save();
189 NDCTableADO tableA3 = NDCTableADO.createVirgin(dbTrans1);
190 tableA3.setSomedata("tableA3");
191 tableA3.setReftob(tableB3);
192 tableA3.setReftoc(tableC3);
193 tableA3.save();
194 NDCTableADO tableA4 = NDCTableADO.createVirgin(dbTrans1);
195 tableA4.setSomedata("tableA4");
196 tableA4.setReftob(tableB4);
197 tableA4.setReftoc(tableC4);
198 tableA4.save();
199 NDCTableADO tableA5 = NDCTableADO.createVirgin(dbTrans1);
200 tableA5.setSomedata("tableA5");
201 tableA5.setReftob(tableB5);
202 tableA5.setReftoc(tableC5);
203 tableA5.save();
204 NDCTableADO tableA6 = NDCTableADO.createVirgin(dbTrans1);
205 tableA6.setSomedata("tableA6");
206 tableA6.setReftob(tableB6);
207 tableA6.setReftoc(tableC6);
208 tableA6.save();
209 if(!autoWrite)
210 dbTrans1.write();
211 dbTrans1.commit();
212
215 System.err.println("rows inserted");
216 showTables(dbTrans1);
217
218 System.err.print("delete1 --- ");
219 tableD1.delete();
220 System.err.print("delete2 --- ");
221 tableD2.delete();
222 System.err.print("delete3 --- ");
223 tableD3.delete();
224 System.err.print("delete4 --- ");
225 tableD4.delete();
226 System.err.print("delete5 --- ");
227 tableD5.delete();
228 System.err.println("delete6 ---");
229 tableD6.delete();
230 if(!autoWrite)
231 dbTrans1.write();
232
233 showTables(dbTrans1);
234
235 System.err.print("unDelete1 --- ");
236 tableD1.unDelete();
237 System.err.println("newD1:"+tableD1.getHandle());
238 System.err.print("unDelete2 --- ");
239 tableD2.unDelete();
240 System.err.println("newD2:"+tableD2.getHandle());
241 if(!autoWrite)
242 dbTrans1.write();
243
244 System.err.println("after undelete there are two D's, aren't they?");
245 showTables(dbTrans1);
246
247 tableD1.delete();
248 tableD2.delete();
249
250 if (null != dbTrans1)
251 dbTrans1.commit();
252 System.err.println("that's all folks, table are empty now, I hope :) ");
253 showTables(dbTrans1);
254 }catch (Exception ex){
255 System.err.println(ex.toString());
256 ex.printStackTrace();
257 }
258 }
259 }
260
|
Popular Tags
|
Java API By Example, From Geeks To Geeks.