01: /* Copyright (c) 2001-2005, The HSQL Development Group
02: * All rights reserved.
03: *
04: * Redistribution and use in source and binary forms, with or without
05: * modification, are permitted provided that the following conditions are met:
06: *
07: * Redistributions of source code must retain the above copyright notice, this
08: * list of conditions and the following disclaimer.
09: *
10: * Redistributions in binary form must reproduce the above copyright notice,
11: * this list of conditions and the following disclaimer in the documentation
12: * and/or other materials provided with the distribution.
13: *
14: * Neither the name of the HSQL Development Group nor the names of its
15: * contributors may be used to endorse or promote products derived from this
16: * software without specific prior written permission.
17: *
18: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
19: * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
20: * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
21: * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
22: * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
23: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
24: * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
25: * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
26: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
28: * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29: */
30:
31: package org.hsqldb.util;
32:
33: import java.sql.ResultSet;
34: import java.sql.ResultSetMetaData;
35: import java.sql.SQLException;
36:
37: /**
38: * Helper class for conversion from a different databases
39: *
40: * @author sqlbob@users
41: * @version 1.7.0
42: */
43: class McKoiTransferHelper extends TransferHelper {
44:
45: McKoiTransferHelper() {
46: super ();
47: }
48:
49: String fixupColumnDefRead(TransferTable t, ResultSetMetaData meta,
50: String columnType, ResultSet columnDesc, int columnIndex)
51: throws SQLException {
52:
53: String CompareString = "UNIQUEKEY(\'" + t.Stmts.sDestTable
54: + "\'";
55:
56: if (columnType.indexOf(CompareString) > 0) {
57:
58: // We just found a increment
59: columnType = "SERIAL";
60: }
61:
62: return (columnType);
63: }
64:
65: public McKoiTransferHelper(TransferDb database, Traceable t,
66: String q) {
67: super (database, t, q);
68: }
69:
70: String fixupColumnDefWrite(TransferTable t, ResultSetMetaData meta,
71: String columnType, ResultSet columnDesc, int columnIndex)
72: throws SQLException {
73:
74: if (columnType.equals("SERIAL")) {
75: columnType = "INTEGER DEFAULT UNIQUEKEY (\'"
76: + t.Stmts.sSourceTable + "\')";
77: }
78:
79: return (columnType);
80: }
81:
82: boolean needTransferTransaction() {
83: return (true);
84: }
85: }
|