JDataStoreUtil.java |
1 /** 2 * Copyright (c) 2000-2009 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 * @author Sandeep Soni 34 * @author Ganesh Ram 35 * 36 */ 37 public class JDataStoreUtil extends FirebirdUtil { 38 39 public static DBUtil getInstance() { 40 return _instance; 41 } 42 43 public String buildSQL(String template) throws IOException { 44 template = convertTimestamp(template); 45 template = replaceTemplate(template, getTemplate()); 46 47 template = reword(template); 48 template = StringUtil.replace( 49 template, 50 new String[] {"\\'", "\\\"", "\\\\", "\\n", "\\r"}, 51 new String[] {"''", "\"", "\\", "\n", "\r"}); 52 53 return template; 54 } 55 56 protected JDataStoreUtil() { 57 super(TYPE_JDATASTORE); 58 } 59 60 protected String getServerName() { 61 return "jdatastore"; 62 } 63 64 protected String[] getTemplate() { 65 return _JDATASTORE; 66 } 67 68 private static String[] _JDATASTORE = { 69 "--", "TRUE", "FALSE", 70 "'1970-01-01'", "current_timestamp", 71 " binary", " boolean", " date", 72 " double", " integer", " bigint", 73 " long varchar", " long varchar", " varchar", 74 "", "commit" 75 }; 76 77 private static JDataStoreUtil _instance = new JDataStoreUtil(); 78 79 }