/tst/org/diffkit/diff/testcase/test19.dbsetup.xml

  1<?xml version="1.0" encoding="UTF-8"?>
  2
  3<beans xmlns="http://www.springframework.org/schema/beans"
  4	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5	xsi:schemaLocation="http://www.springframework.org/schema/beans
  6http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
  7
  8	<bean id="rhs.table" class="org.diffkit.db.DKDBTable">
  9		<constructor-arg index="0">
 10			<null />
 11		</constructor-arg>
 12		<constructor-arg index="1">
 13			<null />
 14		</constructor-arg>
 15		<constructor-arg index="2" value="TEST19_RHS_TABLE" />
 16		<constructor-arg index="3">
 17			<list>
 18				<ref bean="rhs.column1" />
 19				<ref bean="rhs.column2" />
 20				<ref bean="rhs.column3" />
 21				<ref bean="rhs.column4" />
 22				<ref bean="rhs.column5" />
 23				<ref bean="rhs.column6" />
 24				<ref bean="rhs.column7" />
 25				<ref bean="rhs.column8" />
 26				<ref bean="rhs.column9" />
 27				<ref bean="rhs.column10" />
 28				<ref bean="rhs.column11" />
 29				<ref bean="rhs.column12" />
 30				<ref bean="rhs.column13" />
 31            <ref bean="rhs.column14" />
 32            <ref bean="rhs.column15" />
 33            <ref bean="rhs.column16" />
 34			</list>
 35		</constructor-arg>
 36		<constructor-arg index="4" ref="rhs.pk" />
 37	</bean>
 38
 39	<bean id="rhs.pk" class="org.diffkit.db.DKDBPrimaryKey">
 40		<constructor-arg index="0" value="test19_rhs_pk" />
 41		<constructor-arg index="1">
 42			<list>
 43				<value>COLUMN1</value>
 44			</list>
 45		</constructor-arg>
 46	</bean>
 47
 48	<bean id="lhs.table" class="org.diffkit.db.DKDBTable">
 49		<constructor-arg index="0">
 50			<null />
 51		</constructor-arg>
 52		<constructor-arg index="1">
 53			<null />
 54		</constructor-arg>
 55		<constructor-arg index="2" value="TEST19_LHS_TABLE" />
 56		<constructor-arg index="3">
 57			<list>
 58				<ref bean="lhs.column1" />
 59				<ref bean="lhs.column2" />
 60				<ref bean="lhs.column3" />
 61				<ref bean="lhs.column4" />
 62				<ref bean="lhs.column5" />
 63				<ref bean="lhs.column6" />
 64				<ref bean="lhs.column7" />
 65				<ref bean="lhs.column8" />
 66				<ref bean="lhs.column9" />
 67				<ref bean="lhs.column10" />
 68				<ref bean="lhs.column11" />
 69				<ref bean="lhs.column12" />
 70            <ref bean="lhs.column13" />
 71            <ref bean="lhs.column14" />
 72            <ref bean="lhs.column15" />
 73            <ref bean="lhs.column16" />
 74			</list>
 75		</constructor-arg>
 76		<constructor-arg index="4" ref="lhs.pk" />
 77	</bean>
 78
 79	<bean id="lhs.pk" class="org.diffkit.db.DKDBPrimaryKey">
 80		<constructor-arg index="0" value="test19_lhs_pk" />
 81		<constructor-arg index="1">
 82			<list>
 83				<value>COLUMN1</value>
 84			</list>
 85		</constructor-arg>
 86	</bean>
 87
 88	<bean id="rhs.column1" class="org.diffkit.db.DKDBColumn">
 89		<constructor-arg index="0" value="COLUMN1" />
 90		<constructor-arg index="1" value="1" />
 91		<constructor-arg index="2" value="VARCHAR" />
 92		<constructor-arg index="3" value="128" />
 93		<constructor-arg index="4" value="true" />
 94	</bean>
 95
 96	<bean id="rhs.column2" class="org.diffkit.db.DKDBColumn">
 97		<constructor-arg index="0" value="COLUMN2" />
 98		<constructor-arg index="1" value="2" />
 99		<constructor-arg index="2" value="BIGINT" />
100		<constructor-arg index="3" value="32" />
101		<constructor-arg index="4" value="true" />
102	</bean>
103
104	<bean id="rhs.column3" class="org.diffkit.db.DKDBColumn">
105		<constructor-arg index="0" value="COLUMN3" />
106		<constructor-arg index="1" value="3" />
107		<constructor-arg index="2" value="DATE" />
108		<constructor-arg index="3" value="0" />
109		<constructor-arg index="4" value="true" />
110	</bean>
111
112	<bean id="rhs.column4" class="org.diffkit.db.DKDBColumn">
113		<constructor-arg index="0" value="COLUMN4" />
114		<constructor-arg index="1" value="4" />
115		<constructor-arg index="2" value="CHAR" />
116		<constructor-arg index="3" value="4" />
117		<constructor-arg index="4" value="true" />
118	</bean>
119
120	<bean id="rhs.column5" class="org.diffkit.db.DKDBColumn">
121		<constructor-arg index="0" value="COLUMN5" />
122		<constructor-arg index="1" value="5" />
123		<constructor-arg index="2" value="TIME" />
124		<constructor-arg index="3" value="0" />
125		<constructor-arg index="4" value="true" />
126	</bean>
127
128	<bean id="rhs.column6" class="org.diffkit.db.DKDBColumn">
129		<constructor-arg index="0" value="COLUMN6" />
130		<constructor-arg index="1" value="6" />
131		<constructor-arg index="2" value="INTEGER" />
132		<constructor-arg index="3" value="0" />
133		<constructor-arg index="4" value="true" />
134	</bean>
135
136	<bean id="rhs.column7" class="org.diffkit.db.DKDBColumn">
137		<constructor-arg index="0" value="COLUMN7" />
138		<constructor-arg index="1" value="7" />
139		<constructor-arg index="2" value="DECIMAL" />
140		<constructor-arg index="3" value="10" />
141		<constructor-arg index="4" value="2" />
142		<constructor-arg index="5" value="true" />
143	</bean>
144
145	<bean id="rhs.column8" class="org.diffkit.db.DKDBColumn">
146		<constructor-arg index="0" value="COLUMN8" />
147		<constructor-arg index="1" value="8" />
148		<constructor-arg index="2" value="DOUBLE" />
149		<constructor-arg index="3" value="10" />
150		<constructor-arg index="4" value="true" />
151	</bean>
152
153	<bean id="rhs.column9" class="org.diffkit.db.DKDBColumn">
154		<constructor-arg index="0" value="COLUMN9" />
155		<constructor-arg index="1" value="9" />
156		<constructor-arg index="2" value="REAL" />
157		<constructor-arg index="3" value="10" />
158		<constructor-arg index="4" value="true" />
159	</bean>
160
161	<bean id="rhs.column10" class="org.diffkit.db.DKDBColumn">
162		<constructor-arg index="0" value="COLUMN10" />
163		<constructor-arg index="1" value="10" />
164		<constructor-arg index="2" value="TIMESTAMP" />
165		<constructor-arg index="3" value="10" />
166		<constructor-arg index="4" value="true" />
167	</bean>
168
169	<bean id="rhs.column11" class="org.diffkit.db.DKDBColumn">
170		<constructor-arg index="0" value="COLUMN11" />
171		<constructor-arg index="1" value="11" />
172		<constructor-arg index="2" value="BOOLEAN" />
173		<constructor-arg index="3" value="0" />
174		<constructor-arg index="4" value="true" />
175	</bean>
176
177	<bean id="rhs.column12" class="org.diffkit.db.DKDBColumn">
178		<constructor-arg index="0" value="COLUMN12" />
179		<constructor-arg index="1" value="12" />
180		<constructor-arg index="2" value="TINYINT" />
181		<constructor-arg index="3" value="0" />
182		<constructor-arg index="4" value="true" />
183	</bean>
184
185	<bean id="rhs.column13" class="org.diffkit.db.DKDBColumn">
186		<constructor-arg index="0" value="COLUMN13" />
187		<constructor-arg index="1" value="13" />
188		<constructor-arg index="2" value="SMALLINT" />
189		<constructor-arg index="3" value="0" />
190		<constructor-arg index="4" value="true" />
191	</bean>
192
193   <bean id="rhs.column14" class="org.diffkit.db.DKDBColumn">
194      <constructor-arg index="0" value="COLUMN14" />
195      <constructor-arg index="1" value="14" />
196      <constructor-arg index="2" value="NCHAR" />
197      <constructor-arg index="3" value="64" />
198      <constructor-arg index="4" value="true" />
199   </bean>
200   
201   <bean id="rhs.column15" class="org.diffkit.db.DKDBColumn">
202      <constructor-arg index="0" value="COLUMN15" />
203      <constructor-arg index="1" value="15" />
204      <constructor-arg index="2" value="NVARCHAR" />
205      <constructor-arg index="3" value="256" />
206      <constructor-arg index="4" value="true" />
207   </bean>
208
209   <bean id="rhs.column16" class="org.diffkit.db.DKDBColumn">
210      <constructor-arg index="0" value="COLUMN16" />
211      <constructor-arg index="1" value="16" />
212      <constructor-arg index="2" value="CLOB" />
213      <constructor-arg index="3" value="1000" />
214      <constructor-arg index="4" value="true" />
215   </bean>
216
217	<bean id="lhs.column1" class="org.diffkit.db.DKDBColumn">
218		<constructor-arg index="0" value="COLUMN1" />
219		<constructor-arg index="1" value="1" />
220		<constructor-arg index="2" value="VARCHAR" />
221		<constructor-arg index="3" value="128" />
222		<constructor-arg index="4" value="true" />
223	</bean>
224
225	<bean id="lhs.column2" class="org.diffkit.db.DKDBColumn">
226		<constructor-arg index="0" value="COLUMN2" />
227		<constructor-arg index="1" value="2" />
228		<constructor-arg index="2" value="BIGINT" />
229		<constructor-arg index="3" value="32" />
230		<constructor-arg index="4" value="true" />
231	</bean>
232
233	<bean id="lhs.column3" class="org.diffkit.db.DKDBColumn">
234		<constructor-arg index="0" value="COLUMN3" />
235		<constructor-arg index="1" value="3" />
236		<constructor-arg index="2" value="DATE" />
237		<constructor-arg index="3" value="0" />
238		<constructor-arg index="4" value="true" />
239	</bean>
240
241	<bean id="lhs.column4" class="org.diffkit.db.DKDBColumn">
242		<constructor-arg index="0" value="COLUMN4" />
243		<constructor-arg index="1" value="4" />
244		<constructor-arg index="2" value="CHAR" />
245		<constructor-arg index="3" value="4" />
246		<constructor-arg index="4" value="true" />
247	</bean>
248
249	<bean id="lhs.column5" class="org.diffkit.db.DKDBColumn">
250		<constructor-arg index="0" value="COLUMN5" />
251		<constructor-arg index="1" value="5" />
252		<constructor-arg index="2" value="TIME" />
253		<constructor-arg index="3" value="0" />
254		<constructor-arg index="4" value="true" />
255	</bean>
256
257	<bean id="lhs.column6" class="org.diffkit.db.DKDBColumn">
258		<constructor-arg index="0" value="COLUMN6" />
259		<constructor-arg index="1" value="6" />
260		<constructor-arg index="2" value="INTEGER" />
261		<constructor-arg index="3" value="0" />
262		<constructor-arg index="4" value="true" />
263	</bean>
264
265	<bean id="lhs.column7" class="org.diffkit.db.DKDBColumn">
266		<constructor-arg index="0" value="COLUMN7" />
267		<constructor-arg index="1" value="7" />
268		<constructor-arg index="2" value="DECIMAL" />
269		<constructor-arg index="3" value="10" />
270		<constructor-arg index="4" value="2" />
271		<constructor-arg index="5" value="true" />
272	</bean>
273
274	<bean id="lhs.column8" class="org.diffkit.db.DKDBColumn">
275		<constructor-arg index="0" value="COLUMN8" />
276		<constructor-arg index="1" value="8" />
277		<constructor-arg index="2" value="DOUBLE" />
278		<constructor-arg index="3" value="10" />
279		<constructor-arg index="4" value="true" />
280	</bean>
281
282	<bean id="lhs.column9" class="org.diffkit.db.DKDBColumn">
283		<constructor-arg index="0" value="COLUMN9" />
284		<constructor-arg index="1" value="9" />
285		<constructor-arg index="2" value="REAL" />
286		<constructor-arg index="3" value="10" />
287		<constructor-arg index="4" value="true" />
288	</bean>
289
290	<bean id="lhs.column10" class="org.diffkit.db.DKDBColumn">
291		<constructor-arg index="0" value="COLUMN10" />
292		<constructor-arg index="1" value="10" />
293		<constructor-arg index="2" value="TIMESTAMP" />
294		<constructor-arg index="3" value="10" />
295		<constructor-arg index="4" value="true" />
296	</bean>
297
298	<bean id="lhs.column11" class="org.diffkit.db.DKDBColumn">
299		<constructor-arg index="0" value="COLUMN11" />
300		<constructor-arg index="1" value="11" />
301		<constructor-arg index="2" value="BOOLEAN" />
302		<constructor-arg index="3" value="0" />
303		<constructor-arg index="4" value="true" />
304	</bean>
305
306	<bean id="lhs.column12" class="org.diffkit.db.DKDBColumn">
307		<constructor-arg index="0" value="COLUMN12" />
308		<constructor-arg index="1" value="12" />
309		<constructor-arg index="2" value="TINYINT" />
310		<constructor-arg index="3" value="0" />
311		<constructor-arg index="4" value="true" />
312	</bean>
313
314	<bean id="lhs.column13" class="org.diffkit.db.DKDBColumn">
315		<constructor-arg index="0" value="COLUMN13" />
316		<constructor-arg index="1" value="13" />
317		<constructor-arg index="2" value="SMALLINT" />
318		<constructor-arg index="3" value="0" />
319		<constructor-arg index="4" value="true" />
320	</bean>
321   
322   <bean id="lhs.column14" class="org.diffkit.db.DKDBColumn">
323      <constructor-arg index="0" value="COLUMN14" />
324      <constructor-arg index="1" value="14" />
325      <constructor-arg index="2" value="NCHAR" />
326      <constructor-arg index="3" value="64" />
327      <constructor-arg index="4" value="true" />
328   </bean>
329   
330   <bean id="lhs.column15" class="org.diffkit.db.DKDBColumn">
331      <constructor-arg index="0" value="COLUMN15" />
332      <constructor-arg index="1" value="15" />
333      <constructor-arg index="2" value="NVARCHAR" />
334      <constructor-arg index="3" value="256" />
335      <constructor-arg index="4" value="true" />
336   </bean>
337
338   <bean id="lhs.column16" class="org.diffkit.db.DKDBColumn">
339      <constructor-arg index="0" value="COLUMN16" />
340      <constructor-arg index="1" value="16" />
341      <constructor-arg index="2" value="CLOB" />
342      <constructor-arg index="3" value="1000" />
343      <constructor-arg index="4" value="true" />
344   </bean>
345
346	<bean id="connectionSource" class="org.diffkit.db.DKDatabase">
347		<constructor-arg ref="connectionInfo" />
348	</bean>
349
350</beans>