/*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* 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.apache.isis.runtimes.dflt.objectstores.sql;
import java.sql.Timestamp;
import java.util.Date;
import org.apache.isis.core.metamodel.adapter.version.SerialNumberVersion;
import org.apache.isis.core.metamodel.adapter.version.Version;
import org.apache.isis.runtimes.dflt.objectstores.sql.jdbc.JdbcConnector;
public class VersionMapping {
private String lastActivityDateColumn;
private String lastActivityUserColumn;
private String versionColumn;
public void init() {
lastActivityDateColumn = Sql.identifier("MODIFIED_ON");
lastActivityUserColumn = Sql.identifier("MODIFIED_BY");
versionColumn = Sql.identifier("VERSION");
}
public String insertColumns() {
return versionColumn + ", " + lastActivityUserColumn + ", " + lastActivityDateColumn;
}
public String insertValues(final DatabaseConnector connector, final SerialNumberVersion version) {
connector.addToQueryValues(version.getSequence());
String user = version.getUser();
if (user == "") {
user = "unknown";
}
connector.addToQueryValues(user);
connector.addToQueryValues(new Timestamp(new Date().getTime()));
return "?,?,?";
}
public String whereClause(final DatabaseConnector connector, final SerialNumberVersion version) {
connector.addToQueryValues(version.getSequence());
return versionColumn + " = ?";
}
public String updateAssigment(final DatabaseConnector connector, final long nextSequence) {
connector.addToQueryValues(nextSequence);
return versionColumn + " = ?";
}
public String appendSelectColumns() {
final StringBuffer sql = new StringBuffer();
sql.append(versionColumn);
sql.append(",");
sql.append(lastActivityUserColumn);
sql.append(",");
sql.append(lastActivityDateColumn);
return sql.toString();
}
public String appendColumnDefinitions() {
final StringBuffer sql = new StringBuffer();
sql.append(versionColumn);
sql.append(" bigint");
sql.append(",");
sql.append(lastActivityUserColumn);
sql.append(" varchar(32)");
sql.append(",");
sql.append(lastActivityDateColumn);
sql.append(" " + JdbcConnector.TYPE_TIMESTAMP());
return sql.toString();
}
public Object appendUpdateValues(final DatabaseConnector connector, final long versionSequence) {
connector.addToQueryValues(versionSequence);
return versionColumn + "= ?";
}
public Version getLock(final Results rs) {
final long number = rs.getLong(versionColumn);
final String user = rs.getString(lastActivityUserColumn);
final Date time = rs.getJavaDateTime(lastActivityDateColumn, Defaults.getCalendar());
final Version version = new SerialNumberVersion(number, user, time);
return version;
}
}