| JDataStoreUtil.java |
1 /**
2 * Copyright (c) 2000-2008 Liferay, Inc. All rights reserved.
3 *
4 * Permission is hereby granted, free of charge, to any person obtaining a copy
5 * of this software and associated documentation files (the "Software"), to deal
6 * in the Software without restriction, including without limitation the rights
7 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
8 * copies of the Software, and to permit persons to whom the Software is
9 * furnished to do so, subject to the following conditions:
10 *
11 * The above copyright notice and this permission notice shall be included in
12 * all copies or substantial portions of the Software.
13 *
14 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
15 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
16 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
17 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
18 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
19 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
20 * SOFTWARE.
21 */
22
23 package com.liferay.portal.tools.sql;
24
25 import com.liferay.portal.kernel.util.StringUtil;
26
27 import java.io.IOException;
28
29 /**
30 * <a href="JDataStoreUtil.java.html"><b><i>View Source</i></b></a>
31 *
32 * @author Alexander Chow
33 *
34 */
35 public class JDataStoreUtil extends FirebirdUtil {
36
37 public static DBUtil getInstance() {
38 return _instance;
39 }
40
41 public String buildSQL(String template) throws IOException {
42 template = convertTimestamp(template);
43 template = StringUtil.replace(template, TEMPLATE, getTemplate());
44
45 template = reword(template);
46 template = StringUtil.replace(
47 template,
48 new String[] {"\\'", "\\\"", "\\\\", "\\n", "\\r"},
49 new String[] {"''", "\"", "\\", "\n", "\r"});
50
51 return template;
52 }
53
54 protected JDataStoreUtil() {
55 }
56
57 protected String getServerName() {
58 return "jdatastore";
59 }
60
61 protected String[] getTemplate() {
62 return _JDATASTORE;
63 }
64
65 private static String[] _JDATASTORE = {
66 "--", "TRUE", "FALSE",
67 "'1970-01-01'", "current_timestamp",
68 " boolean", " date", " double",
69 " integer", " bigint",
70 " long varchar", " long varchar", " varchar",
71 "", "commit"
72 };
73
74 private static JDataStoreUtil _instance = new JDataStoreUtil();
75
76 }