io.narayana.openshift.txrecovery.ApplicationRecoveryPodHibernate5DAO Maven / Gradle / Ivy
The newest version!
/*
* JBoss, Home of Professional Open Source.
* Copyright 2018, Red Hat, Inc., and individual contributors
* as indicated by the @author tags. See the copyright.txt file in the
* distribution for a full listing of individual contributors.
*
* This 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 2.1 of
* the License, or (at your option) any later version.
*
* This software 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 software; if not, write to the Free
* Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
* 02110-1301 USA, or see the FSF site: http://www.fsf.org.
*/
package io.narayana.openshift.txrecovery;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.hibernate.jdbc.ReturningWork;
import org.hibernate.resource.transaction.spi.TransactionStatus;
import org.jboss.logging.Logger;
import io.narayana.openshift.txrecovery.hibernate.ApplicationRecoveryPod;
import io.narayana.openshift.txrecovery.logging.I18NLogger;
/**
* Data manipulation service working with the {@link ApplicationRecoveryPod}.
*/
public class ApplicationRecoveryPodHibernate5DAO {
private static final Logger log = Logger.getLogger(ApplicationRecoveryPodHibernate5DAO.class);
private Session session;
public ApplicationRecoveryPodHibernate5DAO(Session session) {
this.session = session;
}
/**
* Save a single record with pod name content.
*
* @param applicationPodName app pod name to be saved
* @param recoveryPodName recovery pod name to be saved
* @return true if saved successfully, false otherwise
*/
public boolean saveRecord(String applicationPodName, String recoveryPodName) {
session.getTransaction().begin();
ApplicationRecoveryPod record = new ApplicationRecoveryPod(applicationPodName, recoveryPodName);
try {
session.persist(record);
session.getTransaction().commit();
} catch (Exception e) {
if(session.getTransaction() != null && session.getTransaction().getStatus() == TransactionStatus.ACTIVE)
session.getTransaction().rollback();
I18NLogger.logger.error_cannotPersistRecord(record, e);
return false;
}
return true;
}
public int delete(String applicationPodName, String recoveryPodName) {
String whereClause = "";
if(applicationPodName != null && !applicationPodName.isEmpty()) {
whereClause += " where id.applicationPodName = :appPod";
}
if(recoveryPodName != null && !recoveryPodName.isEmpty()) {
whereClause += whereClause.isEmpty() ? " where " : " and ";
whereClause += "id.recoveryPodName = :recPod";
}
String query = "delete from " + ApplicationRecoveryPod.class.getSimpleName() + whereClause;
log.debugf("Query to be executed: %s", query);
// creating hql delete query
session.getTransaction().begin();
Query q = session.createQuery(query);
if(applicationPodName != null && !applicationPodName.isEmpty())
q.setString("appPod", applicationPodName);
if(recoveryPodName != null && !recoveryPodName.isEmpty())
q.setString("recPod", recoveryPodName);
int numberDeletedRecords = q.executeUpdate();
session.getTransaction().commit();
return numberDeletedRecords;
}
/**
* To delete a record.
*
* @param recordDto dto to be deleted
* @return true if deleted, false otherwise
*/
public boolean deleteRecord(ApplicationRecoveryPod recordDto) {
if(recordDto == null) return false;
session.getTransaction().begin();
try {
session.delete(recordDto);
session.getTransaction().commit();
} catch (Exception e) {
if(session.getTransaction() != null && session.getTransaction().getStatus() == TransactionStatus.ACTIVE)
session.getTransaction().rollback();
I18NLogger.logger.error_cannotRemoveRecord(recordDto, e);
return false;
}
return true;
}
/**
* Verifies if table name exists in the database.
*
* @param tableName table name to be found
* @return true if found, false otherwise
*/
public boolean tableExists(final String tableName) {
try {
return session.doReturningWork(
new ReturningWork() {
public Boolean execute(Connection connection) throws SQLException {
String tableNameSearch = tableName;
if (connection.getMetaData().storesLowerCaseIdentifiers()) {
tableNameSearch = tableName.toLowerCase();
} if (connection.getMetaData().storesUpperCaseIdentifiers()) {
tableNameSearch = tableName.toUpperCase();
}
try (ResultSet tables = connection.getMetaData().getTables(null,null, tableNameSearch, new String[]{"TABLE"})) {
boolean isCaseSensitive = connection.getMetaData().supportsMixedCaseIdentifiers();
while(tables.next()) {
String currentTableName = tables.getString("TABLE_NAME");
if(isCaseSensitive) {
return currentTableName.equals(tableName);
} else {
return currentTableName.equalsIgnoreCase(tableName);
}
}
}
return false;
}
}
);
} catch (Exception e) {
I18NLogger.logger.error_dbTableDoesNotExist(tableName, e);
return false;
}
}
/**
* To get records that contains specified app pod name or recovery pod name.
*
* @param applicationPodName app pod name to filter recovery markers by
* @param recoveryPodName rec pod name to filter recovery markers by
* @return the records or null
*/
@SuppressWarnings("unchecked")
public Collection getRecords(String applicationPodName, String recoveryPodName) {
// the Criteria is deprecated in Hibernate 5.2 (see https://github.com/treehouse/giflib-hibernate/commit/f97a2828a466e849d8ae84884b5dce60a66cf412)
Criteria criteria = session.createCriteria(ApplicationRecoveryPod.class);
if(applicationPodName != null && !applicationPodName.isEmpty()) {
criteria.add(Restrictions.eq("id.applicationPodName", applicationPodName));
}
if(recoveryPodName != null && !recoveryPodName.isEmpty()) {
criteria.add(Restrictions.eq("id.recoveryPodName", recoveryPodName));
}
return criteria.list();
}
/**
* Running to drop table with native SQL query.
* Expecting the table name coming in safe format
* the method is not safe for sql injection.
*
* @param tableName table name to drop
* @return number of dropped tables
*/
public int dropTable(String tableName) {
Query q = session.createSQLQuery(String.format("DROP TABLE %s", tableName));
session.getTransaction().begin();
int numberDroppedRecords = q.executeUpdate();
session.getTransaction().commit();
return numberDroppedRecords;
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy