/** * Licensed to JumpMind Inc under one or more contributor * license agreements. See the NOTICE file distributed * with this work for additional information regarding * copyright ownership. JumpMind Inc licenses this file * to you under the GNU General Public License, version 3.0 (GPLv3) * (the "License"); you may not use this file except in compliance * with the License. * * You should have received a copy of the GNU General Public License, * version 3.0 (GPLv3) along with this library; if not, see * <http://www.gnu.org/licenses/>. * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ package org.jumpmind.db.platform.redshift; import java.util.HashMap; import java.util.Map; import javax.sql.DataSource; import org.apache.commons.lang.StringUtils; import org.jumpmind.db.platform.AbstractJdbcDatabasePlatform; import org.jumpmind.db.platform.DatabaseNamesConstants; import org.jumpmind.db.sql.SqlTemplateSettings; public class RedshiftDatabasePlatform extends AbstractJdbcDatabasePlatform { private Map<String, String> sqlScriptReplacementTokens; public RedshiftDatabasePlatform(DataSource dataSource, SqlTemplateSettings settings) { super(dataSource, overrideSettings(settings)); sqlScriptReplacementTokens = new HashMap<String, String>(); sqlScriptReplacementTokens.put("current_timestamp", "sysdate"); } protected static SqlTemplateSettings overrideSettings(SqlTemplateSettings settings) { if (settings == null) { settings = new SqlTemplateSettings(); } settings.setQueryTimeout(0); return settings; } @Override protected RedshiftDdlBuilder createDdlBuilder() { return new RedshiftDdlBuilder(); } @Override protected RedshiftDdlReader createDdlReader() { return new RedshiftDdlReader(this); } @Override protected RedshiftJdbcSqlTemplate createSqlTemplate() { return new RedshiftJdbcSqlTemplate(dataSource, settings, null, getDatabaseInfo()); } public String getName() { return DatabaseNamesConstants.REDSHIFT; } public String getDefaultCatalog() { return null; } public String getDefaultSchema() { if (StringUtils.isBlank(defaultSchema)) { defaultSchema = (String) getSqlTemplate().queryForObject("select current_schema()", String.class); } return defaultSchema; } @Override public Map<String, String> getSqlScriptReplacementTokens() { return sqlScriptReplacementTokens; } }