JpaConfig.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2022 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * 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 Affero 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/>.
 */
 
package org.turro.jpa.config;
 
import java.io.IOException;
import java.nio.file.Path;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import org.turro.elephant.context.ElephantContext;
import org.turro.file.Document;
import org.turro.file.Folder;
import org.turro.json.IJSONizable;
import org.turro.log.WebLoggers;
 
public class JpaConfig implements IJSONizable {
 
  private String url, username, password;
 
  public void setUrl(String url) {
    this.url = url;
  }
 
  public void setUsername(String username) {
    this.username = username;
  }
 
  public void setPassword(String password) {
    this.password = password;
  }
  
  private Properties properties() {
    Properties properties = new Properties();
    properties.setProperty("hibernate.connection.url", url);
    properties.setProperty("hibernate.connection.username", username);
    properties.setProperty("hibernate.connection.password", password);
    addDefaults(properties);
    return properties;
  }
  
  private void addDefaults(Properties properties) {
    properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
    properties.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver");
    properties.setProperty("hibernate.hbm2ddl.auto", "update");
    properties.setProperty("hibernate.show_sql", "false");
        properties.setProperty("hibernate.format_sql", "false");
        properties.setProperty("hibernate.use_sql_comments", "false");
    properties.setProperty("hibernate.connection.provider_class", "org.hibernate.connection.C3P0ConnectionProvider");
    properties.setProperty("hibernate.c3p0.max_size", "6");
    properties.setProperty("hibernate.c3p0.min_size", "2");
    properties.setProperty("hibernate.c3p0.timeout", "5000");
    properties.setProperty("hibernate.c3p0.max_statements", "200");
    properties.setProperty("hibernate.c3p0.idle_test_period", "3000");
    properties.setProperty("hibernate.c3p0.acquire_increment", "2");
    properties.setProperty("hibernate.c3p0.validate", "false");
  }
 
  /* Utils */
  
  public static List<Document> daos() {
    try {
      Folder daoFolder = Folder.from(Path.of(ElephantContext.getRealPath(DAO_FOLDER)));
      return daoFolder.documents("*.json");
    } catch (IOException ex) {
      WebLoggers.severe(JpaConfig.class).exception(ex).log();
    }
    return null;
  }
  
  /* IJSONizable */
 
  @Override
  public String toJson() {
    return toJson(this);
  }
  
  @Override
  public String toJson(Map<String, Object> properties) {
    return toJson(this, properties);
  }
 
  /* Factory */
  
  private static final String DAO_FOLDER = "/WEB-INF/elephant/conf/dao";
  
  public static Properties from(String pu, String name) {
    try {
      Document configFile = Document.from(Path.of(ElephantContext.getRealPath(DAO_FOLDER))
              .resolve(pu + ".json"));
      if(!configFile.exists()) {
        JpaConfigMigrate.migrate(configFile, name);
      }
      return IJSONizable.fromJson(configFile.content(), JpaConfig.class).properties();
    } catch (IOException ex) {
      WebLoggers.severe(JpaConfig.class).exception(ex).log();
    }
    return null;
  }
  
}