de.tsl2.nano.h5.PersistenceUI Maven / Gradle / Ivy
/*
* File: $HeadURL$
* Id : $Id$
*
* created by: Tom, Thomas Schneider
* created on: 08.08.2014
*
* Copyright: (c) Thomas Schneider 2014, all rights reserved
*/
package de.tsl2.nano.h5;
import static de.tsl2.nano.bean.def.BeanPresentationHelper.PROP_ENABLER;
import static de.tsl2.nano.bean.def.BeanPresentationHelper.PROP_LENGTH;
import static de.tsl2.nano.bean.def.BeanPresentationHelper.PROP_NULLABLE;
import static de.tsl2.nano.bean.def.BeanPresentationHelper.PROP_STYLE;
import static de.tsl2.nano.bean.def.BeanPresentationHelper.PROP_VISIBLE;
import java.io.File;
import java.io.Serializable;
import java.util.Arrays;
import java.util.Properties;
import java.util.regex.Pattern;
import de.tsl2.nano.action.IAction;
import de.tsl2.nano.action.IActivable;
import de.tsl2.nano.bean.def.AttributeDefinition;
import de.tsl2.nano.bean.def.Bean;
import de.tsl2.nano.bean.def.BeanPresentationHelper;
import de.tsl2.nano.bean.def.IIPresentable;
import de.tsl2.nano.bean.def.IPresentable;
import de.tsl2.nano.bean.def.SecureAction;
import de.tsl2.nano.bean.def.ValueExpression;
import de.tsl2.nano.core.ENV;
import de.tsl2.nano.core.util.FileUtil;
import de.tsl2.nano.core.util.MapUtil;
import de.tsl2.nano.core.util.SortedProperties;
import de.tsl2.nano.core.util.StringUtil;
import de.tsl2.nano.core.util.Util;
import de.tsl2.nano.format.RegExpFormat;
import de.tsl2.nano.h5.plugin.INanoPlugin;
import de.tsl2.nano.h5.websocket.WSEvent;
import de.tsl2.nano.h5.websocket.WebSocketDependencyListener;
import de.tsl2.nano.persistence.DatabaseTool;
import de.tsl2.nano.persistence.Persistence;
import de.tsl2.nano.plugin.Plugins;
/**
* factory to create a user interface for {@link Persistence}.
*
* @author Tom, Thomas Schneider
* @version $Revision$
*/
public class PersistenceUI {
public static final String ACTION_LOGIN_OK = "tsl2nano.login.ok";
/**
* constructor
*/
private PersistenceUI() {
}
/**
* createPersistenceUI
*
* @param persistence
* @return
*/
@SuppressWarnings({ "serial", "unchecked" })
public static Bean createPersistenceUI(final Persistence persistence,
final ISystemConnector connector) {
final Bean login = Bean.getBean(persistence);
BeanPresentationHelper helper = login.getPresentationHelper();
if (login.isDefault()) {
login.setAttributeFilter("connectionUserName", "connectionPassword", "connectionUrl", "jarFile",
"connectionDriverClass", "provider", "datasourceClass", "jtaDataSource", "transactionType",
"persistenceUnit", "hibernateDialect", "database", "defaultSchema", "port", "generator", "autoddl",
"replication",
"jdbcProperties");
login.setValueExpression(new ValueExpression("{connectionUrl}"));
if (ENV.get("app.login.administration", true)) {
/*
* create dependency listeners
*/
Properties props;
String pfile = ENV.getConfigPath() + "persistence.properties";
if ((props = FileUtil.loadPropertiesFromFile(pfile)) == null) {
props = new SortedProperties();
addFileNames(props, "BEANJAR_");
props.setProperty("PROVIDER_Hibernate", "org.hibernate.ejb.HibernatePersistence");
props.setProperty("PROVIDER_Hibernate5", "org.hibernate.jpa.HibernatePersistenceProvider");
props.setProperty("PROVIDER_OpenJPA", "org.apache.openjpa.persistence.PersistenceProviderImpl");
props.setProperty("PROVIDER_EclipseLink", "org.eclipse.persistence.jpa.PersistenceProvider");
props.setProperty("PROVIDER_TopLink", "oracle.toplink.essentials.PersistenceProvider");
props.setProperty("PROVIDER_Acme", "com.acme.persistence");
props.setProperty("PROVIDER_DataNucleus", "org.datanucleus.api.jpa.PersistenceProviderImpl");
props.setProperty("PROVIDER_BatooJPA", "org.batoo.jpa.core.BatooPersistenceProvider");
props.setProperty("PROVIDER_EBean", "de.tsl2.nano.ebeanprovider.EntityManager");
props.setProperty("PROVIDER_ORMLite", "de.tsl2.nano.ormliteprovider.EntityManager");
props.setProperty("DRIVER_jdbc.odbc", "sun.jdbc.odbc.JdbcOdbcDriver");
props.setProperty("DRIVER_jdbc.oracle", "oracle.jdbc.OracleDriver");
props.setProperty("DRIVER_jdbc.db2", "com.ibm.db2.jcc.DB2Driver");
props.setProperty("DRIVER_jdbc.hsqldb", Persistence.HSQLDB_DATABASE_DRIVER);
props.setProperty("DRIVER_jdbc.h2", Persistence.H2_DATABASE_DRIVER);
props.setProperty("DRIVER_jdbc.sybase", "com.sybase.jdbc2.jdbc.SybDriver");
props.setProperty("DRIVER_jdbc.derby.embedded", "org.apache.derby.jdbc.EmbeddedDriver");
props.setProperty("DRIVER_jdbc.derby.client", Persistence.DERBY_DATABASE_DRIVER);
props.setProperty("DRIVER_jdbc.xerial", "org.sqlite.JDBC");
props.setProperty("DRIVER_jdbc.sqldroid", "org.sqldroid.SQLDroidDriver");
props.setProperty("DRIVER_jdbc.postgresql", "org.postgresql.Driver");
props.setProperty("DRIVER_jdbc.mysql", "com.mysql.jdbc.Driver");
props.setProperty("DRIVER_jdbc.jtds.sqlserver", "net.sourceforge.jtds.jdbc.Driver");
props.setProperty("DRIVER_jdbc.firebirdsql", "jaybird-jdk17");
props.setProperty("DRIVER_jdbc.ucanaccess", "net.ucanaccess.jdbc.UcanaccessDriver");
props.setProperty("DRIVER_jdbc.sapdb", "com.sap.dbtech.jdbc.DriverSapDB");
//if unknown, we use the driver name...
props.setProperty("DATASOURCE_jdbc.odbc", "sun.jdbc.odbc.JdbcOdbcDriver");
props.setProperty("DATASOURCE_jdbc.oracle", "oracle.jdbc.pool.OracleDataSource");
props.setProperty("DATASOURCE_jdbc.db2", "com.ibm.db2.jcc.DB2Driver");
props.setProperty("DATASOURCE_jdbc.hsqldb", "org.hsqldb.jdbc.JDBCDataSource");
props.setProperty("DATASOURCE_jdbc.h2", Persistence.H2_DATABASE_DRIVER);
props.setProperty("DATASOURCE_jdbc.sybase", "com.sybase.jdbc2.jdbc.SybDataSource");
props.setProperty("DATASOURCE_jdbc.derby", Persistence.DERBY_DATABASE_DRIVER);
props.setProperty("DATASOURCE_jdbc.xerial", "org.sqlite.JDBC");
props.setProperty("DATASOURCE_jdbc.sqldroid", "org.sqldroid.SQLDroidDriver");
props.setProperty("DATASOURCE_jdbc.postgresql", "org.postgresql.Driver");
props.setProperty("DATASOURCE_jdbc.mysql", "com.mysql.jdbc.Driver");
props.setProperty("DATASOURCE_jdbc.jtds", "net.sourceforge.jtds.jdbc.Driver");
props.setProperty("DATASOURCE_jdbc.firebirdsql", "jaybird-jdk17");
props.setProperty("DATASOURCE_jdbc.ucanaccess", "net.ucanaccess.jdbc.UcanaccessDriver");
props.setProperty("DATASOURCE_jdbc.sapdb", "com.sap.dbtech.jdbc.DriverSapDB");
props.setProperty("DIALECT_jdbc.oracle", "org.hibernate.dialect.Oracle10gDialect");
props.setProperty("DIALECT_jdbc.db2", "org.hibernate.dialect.DB2Dialect");
props.setProperty("DIALECT_jdbc.derby", "org.hibernate.dialect.DerbyDialect");
props.setProperty("DIALECT_jdbc.informix", "org.hibernate.dialect.InformixDialect");
props.setProperty("DIALECT_jdbc.hsqldb", "org.hibernate.dialect.HSQLDialect");
props.setProperty("DIALECT_jdbc.h2", "org.hibernate.dialect.H2Dialect");
props.setProperty("DIALECT_jdbc.sybase", "org.hibernate.dialect.SybaseDialect");
props.setProperty("DIALECT_jdbc.sqlite", "org.hibernate.dialect.SQLiteDialect");//xerial SQLite
props.setProperty("DIALECT_jdbc.postgresql", "org.hibernate.dialect.PostgresDialect");
props.setProperty("DIALECT_jdbc.mysql", "org.hibernate.dialect.MySQLDialect");
props.setProperty("DIALECT_jdbc.sqlserver", "org.hibernate.dialect.SQLServerDialect");//Microsoft SQL-Server
props.setProperty("DIALECT_jdbc.firebirdsql", "org.hibernate.dialect.FirebirdDialect");//jaybird
props.setProperty("DIALECT_jdbc.sapdb", "org.hibernate.dialect.SAPDBDialect");
props.setProperty("URLSYNTAX_jdbc.odbc", "jdbc:odbc:");
props.setProperty("URLSYNTAX_jdbc.oracle",
"jdbc:oracle:thin:@[:]:");
props.setProperty("URLSYNTAX_jdbc.db2", "jdbc:db2://:/");
props.setProperty("URLSYNTAX_jdbc.hsqldb", "jdbc:hsqldb:");
props.setProperty("URLSYNTAX_jdbc.h2", "jdbc:h2:[tcp://][:port(default 9092)]");
props.setProperty("URLSYNTAX_jdbc.sybase", "jdbc:sybase:Tds::");
props.setProperty("URLSYNTAX_jdbc.derby",
"jdbc:derby://[server:][:port][databaseName][;attribute=value]*");
props.setProperty("URLSYNTAX_jdbc.xerial", "jdbc:sqlite:");
props.setProperty("URLSYNTAX_jdbc.sqldroid", "jdbc:sqlite:");
props.setProperty("URLSYNTAX_jdbc.postgresql", "jdbc:postgresql://:/");
props.setProperty("URLSYNTAX_jdbc.mysql",
"jdbc:mysql://[,][<:3306>]/[?=][&=]");
props.setProperty("URLSYNTAX_jdbc.jtds",
"jdbc:jtds:://[:][/][;=[;...]]");
props.setProperty("URLSYNTAX_jdbc.firebirdsql", "jdbc:firebirdsql://host[:port]/");
props.setProperty("URLSYNTAX_jdbc.ucanaccess", "jdbc:ucanaccess://");//ms-access
props.setProperty("URLSYNTAX_jdbc.sapdb", "jdbc:sapdb://[:]/");//default-port: 7210
FileUtil.saveProperties(pfile, props);
}
//input assists - completions
((IIPresentable) login.getAttribute("jarFile").getPresentation())
.setItemList(MapUtil.getValues(props, "BEANJAR_.*"));
((IIPresentable) login.getAttribute("connectionUrl").getPresentation())
.setItemList(MapUtil.getValues(props, "URLSYNTAX_.*"));
((IIPresentable) login.getAttribute("connectionDriverClass").getPresentation())
.setItemList(MapUtil.getValues(props, "DRIVER_.*"));
((IIPresentable) login.getAttribute("datasourceClass").getPresentation())
.setItemList(MapUtil.getValues(props, "DATASOURCE_.*"));
((IIPresentable) login.getAttribute("provider").getPresentation())
.setItemList(MapUtil.getValues(props, "PROVIDER_.*"));
((IIPresentable) login.getAttribute("hibernateDialect").getPresentation())
.setItemList(MapUtil.getValues(props, "DIALECT_.*"));
((IIPresentable) login.getAttribute("transactionType").getPresentation())
.setItemList(Arrays.asList("RESOURCE_LOCAL", "JTA"));
final Properties p = props;
//refresh the default schema to be asked by the username listener
String ds = (String) login.getValue("defaultSchema");
final StringBuilder defaultSchema = ds != null ? new StringBuilder(ds) : new StringBuilder();
login
.getAttribute("defaultSchema")
.changeHandler()
.addListener(
new WebSocketDependencyListener() {
@Override
public String evaluate(WSEvent evt) {
String value = (String) evt.newValue;
String eval = StringUtil.toString(value);
defaultSchema.delete(0, defaultSchema.length());
if (value != null) {
defaultSchema.append(eval);
}
return eval;
}
}, WSEvent.class);
login
.getAttribute("connectionUserName")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("defaultSchema")) {
@Override
public String evaluate(WSEvent evt) {
Object value = evt.newValue;
Object userName = Util.asString(value);
String eval;
if (userName != null && Util.isEmpty(defaultSchema)) {
if (value != null && DatabaseTool.isInternalDatabase(persistence.getConnectionUrl())) {
eval = Persistence.DEFAULT_SCHEMA;
} else {
eval = userName.toString().toUpperCase();
}
defaultSchema.replace(0, defaultSchema.length(), eval);
} else {
eval = defaultSchema.toString();
}
return eval;
}
}, WSEvent.class);
login
.getAttribute("connectionUrl")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("connectionDriverClass")) {
@Override
public String evaluate(WSEvent evt) {
Object value = evt.newValue;
String url = Util.asString(value);
if (url != null) {
String prefix = StringUtil.extract(url, "^\\w+[:]\\w+").replace(':', '.');
if (!Util.isEmpty(prefix)) {
return p.getProperty("DRIVER_" + prefix);
}
}
return null;
}
}, WSEvent.class);
login
.getAttribute("connectionUrl")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("datasourceClass")) {
@Override
public String evaluate(WSEvent evt) {
Object value = evt.newValue;
String url = Util.asString(value);
if (url != null) {
String prefix = getDriverPrefix(url);
if (!Util.isEmpty(prefix)) {
return p.getProperty("DATASOURCE_" + prefix);
}
}
return null;
}
}, WSEvent.class);
login
.getAttribute("connectionUrl")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("hibernateDialect")) {
@Override
public String evaluate(WSEvent evt) {
Object value = evt.newValue;
String url = Util.asString(value);
if (url != null) {
String prefix = getDriverPrefix(url);
if (!Util.isEmpty(prefix)) {
return p.getProperty("DIALECT_" + prefix);
}
}
return null;
}
}, WSEvent.class);
login
.getAttribute("connectionUrl")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("database")) {
@Override
public String evaluate(WSEvent evt) {
if (!Util.isEmpty(evt.newValue) && evt.getOldValue() != null) {
Object value = evt.newValue;
String url = Util.asString(value);
if (url != null && !DatabaseTool.isEmbeddedDatabase(url)) {
String prefix = getDriverPrefix(url);
if (!Util.isEmpty(prefix)) {
String newValue = StringUtil.extract(url, "[:]\\d+[:/;](\\w+)");
if (!Util.isEmpty(newValue))
return newValue;
} else {
String newValue = StringUtil.extract(url, "(\\w+)");
if (!Util.isEmpty(newValue))
return newValue;
}
}
}
//fallback
return persistence.getDatabase();
}
}, WSEvent.class);
login
.getAttribute("connectionUrl")
.changeHandler()
.addListener(
new WebSocketDependencyListener(
(AttributeDefinition) login.getAttribute("port")) {
@Override
public String evaluate(WSEvent evt) {
Object value = evt.newValue;
String url = Util.asString(value);
if (url != null) {
String prefix = getDriverPrefix(url);
if (!Util.isEmpty(prefix)) {
return DatabaseTool.getPort(url);
}
}
return null;
}
}, WSEvent.class);
login
.getAttribute("connectionUrl")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("defaultSchema")) {
@Override
public String evaluate(WSEvent evt) {
Object value = evt.newValue;
Object userName = login.getAttribute("connectionUserName").getValue();
String eval = null;
if (userName != null) {
if (value != null && DatabaseTool.isInternalDatabase((String) value)) {
eval = Persistence.DEFAULT_SCHEMA;
} else {
eval = userName.toString().toUpperCase();
}
}
return eval;
}
}, WSEvent.class);
// login.getAttribute("provider").changeHandler().addListener(new WebSocketDependencyListener() {
// @Override
// protected String evaluate(WSEvent evt) {
// Object value = evt.newValue;
// String url = Util.asString(value);
// if (url != null) {
// String prefix = StringUtil.extract(url, "\\w+[:]\\w+");
// String v = p.getProperty("DIALECT_" + prefix);
// return v;
// }
// return null;
// }
// }, WSEvent.class);
login
.getAttribute("provider")
.changeHandler()
.addListener(
new WebSocketDependencyListener((AttributeDefinition) login
.getAttribute("provider")) {
@Override
protected String evaluate(WSEvent evt) {
Object value = evt.newValue;
String provider = Util.asString(value);
if (p != null) {
String k, prov = provider.toLowerCase();
for (Object key : p.keySet()) {
k = (String) key;
if (k.startsWith("PROVIDER_") && k.toLowerCase().contains(prov)) {
provider = p.getProperty(k);
break;
}
}
}
return provider;
}
}, WSEvent.class);
/*
* create expandable panels
*/
login.addValueGroup("connection", true, "connectionUserName", "connectionPassword", "connectionUrl",
"jarFile");
login.addValueGroup("details ", false, "connectionDriverClass", "provider", "datasourceClass",
"jtaDataSource",
"transactionType",
"persistenceUnit", "hibernateDialect", "database", "defaultSchema", "port", "generator", "autoddl",
"replication");
} else { //simple user login
helper.change(PROP_VISIBLE, false, "connectionUrl", "jarFile",
"connectionDriverClass", "provider", "datasourceClass", "jtaDataSource", "transactionType",
"persistenceUnit", "hibernateDialect", "database", "defaultSchema", "port", "generator", "autoddl",
"replication",
"jdbcProperties");
persistence.setConnectionUserName(null);
persistence.setConnectionPassword(null);
login.getAttribute("connectionUserName").getPresentation()
.setLayoutConstraints((Serializable) MapUtil.asMap("style", "width:120;"));
login.getAttribute("connectionPassword").getPresentation()
.setLayoutConstraints((Serializable) MapUtil.asMap("style", "width:120;"));
login.setValueExpression(new ValueExpression(ENV.translate("tsl2nano.login.title", true)));
}
}
if (login.toString().matches(ENV.get("app.login.present.attribute.multivalue", ".*"))) {
login.removeAttributes("jdbcProperties");
}
if (ENV.get("app.login.jarfile.fileselector", false)) {
login.getAttribute("jarFile").getPresentation().setType(IPresentable.TYPE_ATTACHMENT);
((Html5Presentable) login.getAttribute("jarFile").getPresentation()).getLayoutConstraints().put("accept",
".jar");
}
login.getAttribute("generator").setRange(Arrays.asList(Persistence.GEN_HIBERNATE, Persistence.GEN_OPENJPA));
login.getAttribute("autoddl").setRange(Arrays.asList("false", "validate", "update", "create", "create-drop"));
helper.change(BeanPresentationHelper.PROP_DESCRIPTION,
ENV.translate("jarFile.tooltip", true),
"jarFile");
login.getAttribute("connectionPassword").getPresentation().setType(IPresentable.TYPE_INPUT_PASSWORD);
helper.change(PROP_NULLABLE, false);
helper.change(PROP_NULLABLE, true, "connectionPassword");
helper.change(PROP_NULLABLE, true, "jarFile");
helper.change(PROP_NULLABLE, true, "replication");
helper.change(PROP_STYLE, IPresentable.STYLE_MULTI, "database");
helper.change(PROP_LENGTH, 100000, "database");
((RegExpFormat) login.getAttribute("database").getFormat()).setPattern(RegExpFormat.alphanum(100000, false),
null, 100000, Pattern.MULTILINE);
login.getAttribute("database").getPresentation()
.setLayoutConstraints((Serializable) MapUtil.asMap("rows", 1, "cols", "50", "style", "width:382;"));
/*
* caution: this is a flag to disable changing any field of the persistence.xml. The persistence.xml
* will be loaded by the provider as is. This is an issue for testing purposes on differen providers.
*/
helper.change(PROP_ENABLER, new IActivable() {
@Override
public boolean isActive() {
return ENV.get("app.login.save.persistence", true);
}
});
helper.chg("replication", PROP_ENABLER, new IActivable() {
@Override
public boolean isActive() {
return ENV.get("service.use.database.replication", false);
}
});
// ((Map)login.getPresentable().getLayoutConstraints()).put("style", "opacity: 0.9;");
IAction © 2015 - 2025 Weber Informatics LLC | Privacy Policy