/
PostgreSqlDbDialect.java
140 lines (114 loc) · 5.05 KB
/
PostgreSqlDbDialect.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
/*
* SymmetricDS is an open source database synchronization solution.
*
* Copyright (C) Eric Long <erilong@users.sourceforge.net>
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 3 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, see
* <http://www.gnu.org/licenses/>.
*/
package org.jumpmind.symmetric.db.postgresql;
import java.net.URL;
import java.util.Date;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.jumpmind.symmetric.db.AbstractDbDialect;
import org.jumpmind.symmetric.db.IDbDialect;
import org.jumpmind.symmetric.db.SqlScript;
public class PostgreSqlDbDialect extends AbstractDbDialect implements IDbDialect {
static final Log logger = LogFactory.getLog(PostgreSqlDbDialect.class);
static final String TRANSACTION_ID_FUNCTION_NAME = "fn_transaction_id";
static final String SYNC_TRIGGERS_DISABLED_USER_VARIABLE = "explain_pretty_print";
protected void initForSpecificDialect() {
try {
if (!isFunctionUpToDate(TRANSACTION_ID_FUNCTION_NAME)) {
logger.info("Creating function " + TRANSACTION_ID_FUNCTION_NAME);
new SqlScript(getTransactionIdSqlUrl(), getPlatform().getDataSource(), '/')
.execute();
}
} catch (Exception e) {
logger.error("Error while initializing PostgreSql.", e);
}
}
protected boolean allowsNullForIdentityColumn() {
return false;
}
private URL getTransactionIdSqlUrl() {
return getClass().getResource("/dialects/postgresql-transactionid.sql");
}
public boolean isFunctionUpToDate(String name) throws Exception {
long lastModified = getTransactionIdSqlUrl().openConnection().getLastModified();
String checkSchema = (getDefaultSchema() != null && getDefaultSchema().length() > 0) ? " and routine_schema = '"
+ getDefaultSchema() + "'"
: "";
return jdbcTemplate.queryForInt(
"select count(*) from information_schema.routines where created >= ? and routine_name = ?"
+ checkSchema, new Object[] { new Date(lastModified), name.toLowerCase() }) > 0;
}
@Override
protected boolean doesTriggerExistOnPlatform(String schema, String tableName, String triggerName) {
schema = schema == null ? (getDefaultSchema() == null ? null : getDefaultSchema()) : schema;
String checkSchema = (schema != null && schema.length() > 0) ? " and trigger_schema = '"
+ schema + "'" : "";
return jdbcTemplate.queryForInt(
"select count(*) from information_schema.triggers where trigger_name like ? and event_object_table like ?"
+ checkSchema, new Object[] { triggerName.toLowerCase(), tableName.toLowerCase() }) > 0;
}
public void removeTrigger(String schemaName, String triggerName) {
throw new RuntimeException("Not implemented. Use removeTrigger(schema, trigger, table) instead.");
}
public void removeTrigger(String schemaName, String triggerName, String tableName) {
schemaName = schemaName == null ? "" : (schemaName + ".");
try {
jdbcTemplate.update("drop trigger " + schemaName + triggerName + " on " + tableName);
jdbcTemplate.update("drop function " + schemaName + "f" + triggerName + "()");
} catch (Exception e) {
logger.warn("Trigger does not exist");
}
}
public void disableSyncTriggers() {
jdbcTemplate.update("set " + SYNC_TRIGGERS_DISABLED_USER_VARIABLE + " to off");
}
public void enableSyncTriggers() {
jdbcTemplate.update("set " + SYNC_TRIGGERS_DISABLED_USER_VARIABLE + " to on");
}
public String getSyncTriggersExpression() {
return "current_setting('" + SYNC_TRIGGERS_DISABLED_USER_VARIABLE + "') = 'on'";
}
public String getTransactionTriggerExpression() {
return "null";
}
public String getSelectLastInsertIdSql(String sequenceName) {
return "select currval('" + sequenceName + "_seq')";
}
public boolean requiresSavepointForFallback() {
return true;
}
public boolean isCharSpacePadded() {
return true;
}
public boolean isCharSpaceTrimmed() {
return false;
}
public boolean isEmptyStringNulled() {
return false;
}
public boolean storesLowerCaseNamesInCatalog() {
return true;
}
public void purge() {
}
public String getDefaultSchema() {
return null;
}
}