package fr.ifremer.quadrige2.core.dao.technical.liquibase;
   
   /*-
    * #%L
    * Quadrige2 Core :: Quadrige2 Core Shared
    * $Id:$
    * $HeadURL:$
    * %%
    * Copyright (C) 2017 Ifremer
   * %%
   * This program is free software: you can redistribute it and/or modify
   * it under the terms of the GNU Affero General Public License as published by
   * the Free Software Foundation, either version 3 of the License, or
   * (at your option) any later version.
   * 
   * This program 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 General Public License for more details.
   * 
   * You should have received a copy of the GNU Affero General Public License
   * along with this program.  If not, see <http://www.gnu.org/licenses/>.
   * #L%
   */
  
  
  import fr.ifremer.quadrige2.core.config.Quadrige2Configuration;
  import fr.ifremer.quadrige2.core.config.Quadrige2ConfigurationOption;
  import fr.ifremer.quadrige2.core.dao.technical.Daos;
  import fr.ifremer.quadrige2.core.exception.Quadrige2TechnicalException;
  import liquibase.database.Database;
  import liquibase.database.DatabaseFactory;
  import liquibase.database.jvm.JdbcConnection;
  import liquibase.diff.DiffResult;
  import liquibase.diff.compare.CompareControl;
  import liquibase.diff.output.DiffOutputControl;
  import liquibase.diff.output.changelog.DiffToChangeLog;
  import liquibase.diff.output.report.DiffToReport;
  import liquibase.exception.DatabaseException;
  import liquibase.exception.LiquibaseException;
  import liquibase.integration.commandline.CommandLineUtils;
  import liquibase.logging.Logger;
  import liquibase.resource.ClassLoaderResourceAccessor;
  import liquibase.resource.FileSystemResourceAccessor;
  import liquibase.resource.ResourceAccessor;
  import liquibase.structure.core.DatabaseObjectFactory;
  import org.apache.commons.lang3.ArrayUtils;
  import org.apache.commons.lang3.StringUtils;
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  import org.hibernate.cfg.Environment;
  import org.nuiton.version.Version;
  import org.nuiton.version.VersionBuilder;
  import org.springframework.beans.factory.BeanNameAware;
  import org.springframework.beans.factory.InitializingBean;
  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.context.ResourceLoaderAware;
  import org.springframework.context.annotation.Lazy;
  import org.springframework.core.io.Resource;
  import org.springframework.core.io.ResourceLoader;
  import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
  import org.springframework.core.io.support.ResourcePatternUtils;
  import org.springframework.jdbc.datasource.DataSourceUtils;
  import org.springframework.stereotype.Component;
  import org.springframework.util.ResourceUtils;
  
  import javax.sql.DataSource;
  import javax.xml.parsers.ParserConfigurationException;
  import java.io.*;
  import java.sql.Connection;
  import java.sql.SQLException;
  import java.util.*;
  import java.util.regex.Matcher;
  import java.util.regex.Pattern;
  
  /**
   * <p>Liquibase class.</p>
   */
  @Component("liquibase")
  @Lazy
  public class Liquibase implements InitializingBean, BeanNameAware, ResourceLoaderAware {
  
      /** Logger. */
      private static final Log log =
              LogFactory.getLog(Liquibase.class);
  
      /** Constant <code>CHANGE_LOG_SNAPSHOT_SUFFIX="-SNAPSHOT.xml"</code> */
      protected final static String CHANGE_LOG_SNAPSHOT_SUFFIX = "-SNAPSHOT.xml";
  
      private String beanName;
  
      private ResourceLoader resourceLoader;
  
      private DataSource dataSource;
  
      private Quadrige2Configuration config;
  
      private String changeLog;
  
     private String defaultSchema;
 
     private String contexts;
 
     private Map<String, String> parameters;
 
     protected Version maxChangeLogFileVersion;
 
     /**
      * Constructor used by Spring
      *
      * @param dataSource a {@link javax.sql.DataSource} object.
      * @param config a {@link fr.ifremer.quadrige2.core.config.Quadrige2Configuration} object.
      */
     @Autowired
     public Liquibase(DataSource dataSource, Quadrige2Configuration config) {
         this.dataSource = dataSource;
         this.config = config;
     }
 
     /**
      * Constructor used when Spring is not started (no datasource, and @Resource not initialized)
      *
      * @param config a {@link fr.ifremer.quadrige2.core.config.Quadrige2Configuration} object.
      */
     public Liquibase(Quadrige2Configuration config) {
         this.dataSource = null;
         this.config = config;
         // Init change log
         setChangeLog(config.getLiquibaseChangeLogPath());
     }
 
     /**
      * {@inheritDoc}
      *
      * Executed automatically when the bean is initialized.
      */
     @Override
     public void afterPropertiesSet() throws LiquibaseException {
         // Update the change log path, from configuration
         setChangeLog(config.getLiquibaseChangeLogPath());
 
         // Compute the max changelog file version
         computeMaxChangeLogFileVersion();
 
         boolean shouldRun = Quadrige2Configuration.getInstance().useLiquibaseAutoRun();
 
         if (!shouldRun) {
             getLog().debug(
                     String.format("Liquibase did not run because properties '%s' set to false.",
                             Quadrige2ConfigurationOption.LIQUIBASE_RUN_AUTO.getKey()));
             return;
         }
 
         executeUpdate();
     }
 
     /**
      * <p>getDatabaseProductName.</p>
      *
      * @return a {@link java.lang.String} object.
      * @throws liquibase.exception.DatabaseException if any.
      */
     public String getDatabaseProductName() throws DatabaseException {
         Connection connection = null;
         String name = "unknown";
         try {
             connection = createConnection();
             Database database =
                     DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(dataSource.getConnection()));
             name = database.getDatabaseProductName();
         } catch (SQLException e) {
             throw new DatabaseException(e);
         } finally {
             if (connection != null) {
                 try {
                     if (!connection.getAutoCommit()) {
                         connection.rollback();
                     }
                 } catch (Exception e) {
                     getLog().warning("Problem rollback connection", e);
                 }
                 releaseConnection(connection);
             }
         }
         return name;
     }
 
     /**
      * <p>Getter for the field <code>dataSource</code>.</p>
      *
      * @return The DataSource that liquibase will use to perform the migration.
      */
     public DataSource getDataSource() {
         return dataSource;
     }
 
     /**
      * The DataSource that liquibase will use to perform the migration.
      *
      * @param dataSource a {@link javax.sql.DataSource} object.
      */
     public void setDataSource(DataSource dataSource) {
         this.dataSource = dataSource;
     }
 
     /**
      * <p>Getter for the field <code>changeLog</code>.</p>
      *
      * @return a Resource that is able to resolve to a file or classpath resource.
      */
     public String getChangeLog() {
         return changeLog;
     }
 
     /**
      * Sets a Spring Resource that is able to resolve to a file or classpath resource.
      * An example might be <code>classpath:db-changelog.xml</code>.
      *
      * @param dataModel a {@link java.lang.String} object.
      */
     public void setChangeLog(String dataModel) {
 
         this.changeLog = dataModel;
     }
 
     /**
      * <p>Getter for the field <code>contexts</code>.</p>
      *
      * @return a {@link java.lang.String} object.
      */
     public String getContexts() {
         return contexts;
     }
 
     /**
      * <p>Setter for the field <code>contexts</code>.</p>
      *
      * @param contexts a {@link java.lang.String} object.
      */
     public void setContexts(String contexts) {
         this.contexts = contexts;
     }
 
     /**
      * <p>Getter for the field <code>defaultSchema</code>.</p>
      *
      * @return a {@link java.lang.String} object.
      */
     public String getDefaultSchema() {
         return defaultSchema;
     }
 
     /**
      * <p>Setter for the field <code>defaultSchema</code>.</p>
      *
      * @param defaultSchema a {@link java.lang.String} object.
      */
     public void setDefaultSchema(String defaultSchema) {
         this.defaultSchema = defaultSchema;
     }
 
     /**
      * Execute liquibase update, using change log
      *
      * @throws liquibase.exception.LiquibaseException if any.
      */
     public void executeUpdate() throws LiquibaseException {
         executeUpdate(null);
     }
 
     /**
      * Execute liquibase update, using change log
      *
      * @param connectionProperties the properties for connection
      * @throws liquibase.exception.LiquibaseException if any.
      */
     public void executeUpdate(Properties connectionProperties) throws LiquibaseException {
 
         Connection c = null;
         liquibase.Liquibase liquibase;
         try {
             // open connection
             c = createConnection(connectionProperties);
 
             // create liquibase instance
             liquibase = createLiquibase(c);
 
             // First, release locks, then update and release locks again
             liquibase.forceReleaseLocks();
             performUpdate(liquibase);
             liquibase.forceReleaseLocks();
 
             // Compact database (if HsqlDB)
             Daos.compactDatabase(c);
 
         } catch (SQLException e) {
             throw new DatabaseException(e);
         } finally {
             if (c != null) {
                 try {
                     c.rollback();
                 } catch (SQLException e) {
                     // nothing to do
                 }
                 releaseConnection(c);
             }
         }
 
     }
 
     /**
      * <p>performUpdate.</p>
      *
      * @param liquibase a {@link liquibase.Liquibase} object.
      * @throws liquibase.exception.LiquibaseException if any.
      */
     protected void performUpdate(liquibase.Liquibase liquibase) throws LiquibaseException {
         liquibase.update(getContexts());
     }
 
     /**
      * Execute liquibase status, using change log
      *
      * @throws liquibase.exception.LiquibaseException if any.
      * @param writer a {@link java.io.Writer} object.
      */
     public void reportStatus(Writer writer) throws LiquibaseException {
 
         Connection c = null;
         liquibase.Liquibase liquibase;
         Writer myWriter = null;
         try {
             // open connection
             c = createConnection();
 
             // create liquibase instance
             liquibase = createLiquibase(c);
 
             // First, release locks, then update and release locks again
             liquibase.forceReleaseLocks();
             if (writer != null) {
                 performReportStatus(liquibase, writer);
             }
             else {
                 myWriter = new OutputStreamWriter(System.out);
                 performReportStatus(liquibase, myWriter);
             }
             liquibase.forceReleaseLocks();
 
         } catch (SQLException e) {
             throw new DatabaseException(e);
         } finally {
             if (c != null) {
                 try {
                     c.rollback();
                 } catch (SQLException e) {
                     // nothing to do
                 }
                 releaseConnection(c);
             }
             if (myWriter != null) {
                 try {
                     myWriter.close();
                 } catch (IOException e) {
                     // nothing to do
                 }
             }
         }
 
     }
 
     /**
      * <p>performReportStatus.</p>
      *
      * @param liquibase a {@link liquibase.Liquibase} object.
      * @param writer a {@link java.io.Writer} object.
      * @throws liquibase.exception.LiquibaseException if any.
      */
     protected void performReportStatus(liquibase.Liquibase liquibase, Writer writer) throws LiquibaseException {
         liquibase.reportStatus(true, getContexts(), writer);
     }
 
     /**
      * <p>createLiquibase.</p>
      *
      * @param c a {@link java.sql.Connection} object.
      * @return a {@link liquibase.Liquibase} object.
      * @throws liquibase.exception.LiquibaseException if any.
      */
     protected liquibase.Liquibase createLiquibase(Connection c) throws LiquibaseException {
         String adjustedChangeLog = getChangeLog();
         // If Spring started, no changes
         if (this.resourceLoader == null) {
             // Remove 'classpath:' and 'files:' prefixes
             adjustedChangeLog = adjustNoFilePrefix(adjustNoClasspath(adjustedChangeLog));
         }
 
         liquibase.Liquibase liquibase = new liquibase.Liquibase(adjustedChangeLog, createResourceAccessor(), createDatabase(c));
         if (parameters != null) {
             for (Map.Entry<String, String> entry : parameters.entrySet()) {
                 liquibase.setChangeLogParameter(entry.getKey(), entry.getValue());
             }
         }
 
         return liquibase;
     }
 
     /**
      * Subclasses may override this method add change some database settings such as
      * default schema before returning the database object.
      *
      * @param c a {@link java.sql.Connection} object.
      * @return a Database implementation retrieved from the {@link liquibase.database.DatabaseFactory}.
      * @throws liquibase.exception.DatabaseException if any.
      */
     protected Database createDatabase(Connection c) throws DatabaseException {
         Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(c));
         if (StringUtils.trimToNull(this.defaultSchema) != null) {
             database.setDefaultSchemaName(this.defaultSchema);
         }
         return database;
     }
 
     /**
      * Create a database connection to hibernate model.
      * This is useful for diff report
      *
      * @throws liquibase.exception.DatabaseException if any.
      * @return a {@link liquibase.database.Database} object.
      */
     protected Database createHibernateDatabase() throws DatabaseException {
 
         ResourceAccessor accessor = new ClassLoaderResourceAccessor(this.getClass().getClassLoader());
 
         return CommandLineUtils.createDatabaseObject(accessor,
                 "hibernate:classic:hibernate.cfg.xml",
                 null,
                 null,
                 null,
                 config.getJdbcCatalog(), config.getJdbcSchema(),
                 false, false,
                 null, null, null, null, null, null, null
         );
     }
 
     /**
      * <p>setChangeLogParameters.</p>
      *
      * @param parameters a {@link java.util.Map} object.
      */
     public void setChangeLogParameters(Map<String, String> parameters) {
         this.parameters = parameters;
     }
 
     /**
      * Create a new resourceAccessor.
      *
      * @return a {@link liquibase.resource.ResourceAccessor} object.
      */
     protected ResourceAccessor createResourceAccessor() {
         // If Spring started, resolve using Spring
         if (this.resourceLoader != null) {
             return new SpringResourceOpener(getChangeLog());
         }
 
         // Classpath resource accessor
         if (isClasspathPrefixPresent(changeLog)) {
             return new ClassLoaderResourceAccessor(this.getClass().getClassLoader());
         }
 
         // File resource accessor
         return new FileSystemResourceAccessor(new File(adjustNoFilePrefix(changeLog)).getParent());
     }
 
     /**
      * {@inheritDoc}
      *
      * Spring sets this automatically to the instance's configured bean name.
      */
     @Override
     public void setBeanName(String name) {
         this.beanName = name;
     }
 
     /**
      * <p>Getter for the field <code>beanName</code>.</p>
      *
      * @return the Spring-name of this instance.
      */
     public String getBeanName() {
         return beanName;
     }
 
     /** {@inheritDoc} */
     @Override
     public void setResourceLoader(ResourceLoader resourceLoader) {
         this.resourceLoader = resourceLoader;
     }
 
     /**
      * <p>Getter for the field <code>resourceLoader</code>.</p>
      *
      * @return a {@link org.springframework.core.io.ResourceLoader} object.
      */
     public ResourceLoader getResourceLoader() {
         return resourceLoader;
     }
 
     /** {@inheritDoc} */
     @Override
     public String toString() {
         return getClass().getName() + "(" + this.getResourceLoader().toString() + ")";
     }
 
     /**
      * <p>computeMaxChangeLogFileVersion.</p>
      */
     protected void computeMaxChangeLogFileVersion() {
         this.maxChangeLogFileVersion = null;
 
         // Get the changelog path
         String changeLogPath = getChangeLog();
         if (StringUtils.isBlank(changeLogPath)) {
             return;
         }
 
         // Secure all separator (need for regex)
         changeLogPath = changeLogPath.replaceAll("\\\\", "/");
 
         // Get the parent folder path
         int index = changeLogPath.lastIndexOf('/');
         if (index == -1 || index == changeLogPath.length() - 1) {
             return;
         }
 
         // Compute a regex (based from changelog master file)
         String changeLogWithVersionRegex = changeLogPath.substring(index + 1);
         changeLogWithVersionRegex = changeLogWithVersionRegex.replaceAll("master\\.xml", "([0-9]\\\\.[.-_a-zA-Z]+)\\\\.xml");
         Pattern changeLogWithVersionPattern = Pattern.compile(changeLogWithVersionRegex);
 
         Version maxVersion = null;
 
         PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(resourceLoader);
 
         try {
             // Get resources from classpath
             String pathPrefix = changeLogPath.substring(0, index);
             Resource[] resources = resolver.getResources(pathPrefix + "/**/db-changelog-*.xml"); // WARNING: '**/' is mandatory, for multi-dbms (e.g. quadrige2-core-server)
             if (ArrayUtils.isNotEmpty(resources)) {
                 for (Resource resource : resources) {
                     String filename = resource.getFilename();
                     Matcher matcher = changeLogWithVersionPattern.matcher(filename);
 
                     // If the filename match the changelog with version pattern
                     if (matcher.matches()) {
                         String fileVersion = matcher.group(1);
                         // Skip SNAPSHOT versions
                         if (!fileVersion.endsWith(CHANGE_LOG_SNAPSHOT_SUFFIX)) {
                             try {
                                 Version version = VersionBuilder.create(fileVersion).build();
 
                                 // Store a version has max if need
                                 if (maxVersion == null || maxVersion.before(version)) {
                                     maxVersion = version;
                                 }
                             } catch (IllegalArgumentException iae) {
                                 // Bad version format : log but continue
                                 getLog().warning(
                                         String.format(
                                                 "Bad format version found in file: %s/%s. Ignoring this file when computing the max schema version.",
                                                 changeLogPath, filename));
                             }
                         }
                     }
                 }
             }
             else {
                 log.warn(String.format("No changelog files with version found. Please check master changelog file exists at [%s]", changeLogPath));
             }
         } catch (IOException e) {
             throw new RuntimeException("Could not get changelog files", e);
         }
 
         if (maxVersion != null) {
             this.maxChangeLogFileVersion = maxVersion;
         }
     }
 
     /**
      * Get the max version from all change log files.
      * change log file with version must have a same pattern as the master changelog
      *
      * @return the max version founded in files, or null if version found
      */
     public Version getMaxChangeLogFileVersion() {
         return this.maxChangeLogFileVersion;
     }
 
     /**
      * Generate a diff report (using text format)
      *
      * @param outputFile a {@link java.io.File} object.
      * @param typesToControl
      *            a comma separated database object to check (i.e Table, View, Column...). If null, all types are
      *            checked
      * @throws liquibase.exception.LiquibaseException if any.
      */
     public void reportDiff(File outputFile, String typesToControl) throws LiquibaseException {
         Connection c = null;
         liquibase.Liquibase liquibase;
         PrintStream writer = null;
         try {
             // open connection
             c = createConnection();
 
             // create liquibase instance
             liquibase = createLiquibase(c);
 
             // First, release locks, then update and release locks again
             liquibase.forceReleaseLocks();
             DiffResult diffResult = performDiff(liquibase, typesToControl);
             liquibase.forceReleaseLocks();
 
             // Write the result into report file
             writer = outputFile != null ? new PrintStream(outputFile) : null;
 
             new DiffToReport(diffResult, writer != null ? writer : System.out)
                     .print();
 
         } catch (SQLException e) {
             throw new DatabaseException(e);
         } catch (FileNotFoundException e) {
             throw new Quadrige2TechnicalException("Could not write diff report file.", e);
         } finally {
             if (c != null) {
                 try {
                     c.rollback();
                 } catch (SQLException e) {
                     // nothing to do
                 }
                 releaseConnection(c);
             }
             if (writer != null) {
                 writer.close();
             }
         }
     }
 
     /**
      * Generate a changelog file, with all diff found
      *
      * @param changeLogFile a {@link java.io.File} object.
      * @param typesToControl
      *            a comma separated database object to check (i.e Table, View, Column...). If null, all types are
      *            checked
      * @throws liquibase.exception.LiquibaseException if any.
      */
     public void generateDiffChangelog(File changeLogFile, String typesToControl) throws LiquibaseException {
         Connection c = null;
         liquibase.Liquibase liquibase;
         PrintStream writer = null;
         try {
             // open connection
             c = createConnection();
 
             // create liquibase instance
             liquibase = createLiquibase(c);
 
             // First, release locks, then update and release locks again
             liquibase.forceReleaseLocks();
             DiffResult diffResult = performDiff(liquibase, typesToControl);
             liquibase.forceReleaseLocks();
 
             // Write the result into report file
             writer = changeLogFile != null ? new PrintStream(changeLogFile) : null;
 
             DiffOutputControl diffOutputControl = new DiffOutputControl(false, false, false, null);
             new DiffToChangeLog(diffResult, diffOutputControl)
                     .print(writer != null ? writer : System.out);
 
         } catch (SQLException e) {
             throw new DatabaseException(e);
         } catch (FileNotFoundException e) {
             throw new Quadrige2TechnicalException("Could not generate changelog file.", e);
         } catch (ParserConfigurationException e) {
             throw new Quadrige2TechnicalException("Could not generate changelog file.", e);
         } catch (IOException e) {
             throw new Quadrige2TechnicalException("Could not generate changelog file.", e);
         } finally {
             if (c != null) {
                 try {
                     c.rollback();
                 } catch (SQLException e) {
                     // nothing to do
                 }
                 releaseConnection(c);
             }
             if (writer != null) {
                 writer.close();
             }
         }
     }
 
     /**
      * <p>performDiff.</p>
      *
      * @param liquibase
      *            the connection to the target database
      * @param typesToControl
      *            a comma separated database object to check (i.e Table, View, Column...). If null, all types are
      *            checked
      * @return the diff result
      * @throws liquibase.exception.LiquibaseException if any.
      */
     protected DiffResult performDiff(liquibase.Liquibase liquibase, String typesToControl) throws LiquibaseException {
         Database referenceDatabase = createHibernateDatabase();
         CompareControl compareControl = new CompareControl(DatabaseObjectFactory.getInstance().parseTypes(typesToControl));
         return liquibase.diff(referenceDatabase, liquibase.getDatabase(), compareControl);
     }
 
     public class SpringResourceOpener implements ResourceAccessor {
 
         private String parentFile;
         public SpringResourceOpener(String parentFile) {
             this.parentFile = parentFile;
         }
 
         @Override
         public Set<String> list(String relativeTo, String path, boolean includeFiles, boolean includeDirectories, boolean recursive) throws IOException {
             Set<String> returnSet = new HashSet<String>();
 
             Resource[] resources = ResourcePatternUtils.getResourcePatternResolver(getResourceLoader()).getResources(adjustClasspath(path));
 
             for (Resource res : resources) {
                 returnSet.add(res.getURL().toExternalForm());
             }
 
             return returnSet;
         }
 
         @Override
         public Set<InputStream> getResourcesAsStream(String path) throws IOException {
             Set<InputStream> returnSet = new HashSet<InputStream>();
             Resource[] resources = ResourcePatternUtils.getResourcePatternResolver(getResourceLoader()).getResources(adjustClasspath(path));
 
             if (resources == null || resources.length == 0) {
                 return null;
             }
             for (Resource resource : resources) {
                 returnSet.add(resource.getURL().openStream());
             }
 
             return returnSet;
         }
 
         public Resource getResource(String file) {
             return getResourceLoader().getResource(adjustClasspath(file));
         }
 
         private String adjustClasspath(String file) {
             return isPrefixPresent(parentFile) && !isPrefixPresent(file) ? ResourceLoader.CLASSPATH_URL_PREFIX + file : file;
         }
 
         public boolean isPrefixPresent(String file) {
             return file.startsWith("classpath") || file.startsWith("file:") || file.startsWith("url:");
         }
 
         @Override
         public ClassLoader toClassLoader() {
             return getResourceLoader().getClassLoader();
         }
     }
 
     /**
      * <p>getLog.</p>
      *
      * @return a {@link liquibase.logging.Logger} object.
      */
     protected Logger getLog() {
         return liquibase.logging.LogFactory.getInstance().getLog();
     }
 
     /**
      * <p>createConnection.</p>
      *
      * @return a {@link java.sql.Connection} object.
      * @throws java.sql.SQLException if any.
      */
     protected Connection createConnection() throws SQLException {
         if (dataSource != null) {
             return DataSourceUtils.getConnection(dataSource);
         }
         return Daos.createConnection(config.getConnectionProperties());
     }
 
     /**
      * Create a connection from the given properties.<p/>
      * If JDBC Url is equals to the datasource, use the datsource to create the connection
      *
      * @param connectionProperties a {@link java.util.Properties} object.
      * @throws java.sql.SQLException if any.
      * @return a {@link java.sql.Connection} object.
      */
     protected Connection createConnection(Properties connectionProperties) throws SQLException {
         Properties targetConnectionProperties = (connectionProperties != null) ? connectionProperties : config.getConnectionProperties();
         String jdbcUrl = targetConnectionProperties.getProperty(Environment.URL);
         if (Objects.equals(config.getJdbcURL(), jdbcUrl) && dataSource != null) {
             return DataSourceUtils.getConnection(dataSource);
         }
         return Daos.createConnection(targetConnectionProperties);
     }
 
     /**
      * <p>releaseConnection.</p>
      *
      * @param conn a {@link java.sql.Connection} object.
      */
     protected void releaseConnection(Connection conn) {
         if (dataSource != null) {
             DataSourceUtils.releaseConnection(conn, dataSource);
             return;
         }
         Daos.closeSilently(conn);
     }
 
     /**
      * <p>adjustNoClasspath.</p>
      *
      * @param file a {@link java.lang.String} object.
      * @return a {@link java.lang.String} object.
      */
     protected String adjustNoClasspath(String file) {
         return isClasspathPrefixPresent(file)
                 ? file.substring(ResourceLoader.CLASSPATH_URL_PREFIX.length())
                 : file;
     }
 
     /**
      * <p>isClasspathPrefixPresent.</p>
      *
      * @param file a {@link java.lang.String} object.
      * @return a boolean.
      */
     protected boolean isClasspathPrefixPresent(String file) {
         return file.startsWith(ResourceLoader.CLASSPATH_URL_PREFIX);
     }
 
     /**
      * <p>isFilePrefixPresent.</p>
      *
      * @param file a {@link java.lang.String} object.
      * @return a boolean.
      */
     protected boolean isFilePrefixPresent(String file) {
         return file.startsWith(ResourceUtils.FILE_URL_PREFIX);
     }
 
     /**
      * <p>adjustNoFilePrefix.</p>
      *
      * @param file a {@link java.lang.String} object.
      * @return a {@link java.lang.String} object.
      */
     protected String adjustNoFilePrefix(String file) {
         return isFilePrefixPresent(file)
                 ? file.substring(ResourceUtils.FILE_URL_PREFIX.length())
                 : file;
     }
 
 }