- Echobase-commits - mailman.cloud.codelutin.com

r46 - trunk/echobase-services/src/main/java/fr/ifremer/echobase/services
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 23:52:13 +0100 (Sat, 12 Nov 2011) New Revision: 46 Url: http://forge.codelutin.com/repositories/revision/echobase/46 Log: change log levels + finish export service (create the csv file) Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java 2011-11-12 20:23:18 UTC (rev 45) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java 2011-11-12 22:52:13 UTC (rev 46) @@ -116,13 +116,13 @@ int from = pager.getStartIndex(); int to = pager.getEndIndex(); - if (log.isInfoEnabled()) { - log.info("Count = " + count); - log.info("page = " + pager.getPageNumber()); - log.info("pageSize = " + pager.getPageSize()); - log.info("from = " + from); - log.info("to = " + to); - log.info("pageCount= " + pager.getPageCount()); + if (log.isDebugEnabled()) { + log.debug("Count = " + count); + log.debug("page = " + pager.getPageNumber()); + log.debug("pageSize = " + pager.getPageSize()); + log.debug("from = " + from); + log.debug("to = " + to); + log.debug("pageCount= " + pager.getPageCount()); } TopiaQuery query = dao.createQuery("e"); Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java 2011-11-12 20:23:18 UTC (rev 45) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java 2011-11-12 22:52:13 UTC (rev 46) @@ -75,7 +75,7 @@ } } - public void createOrUpdate(ExportQuery exportQuery, EchoBaseUser user) { + public ExportQuery createOrUpdate(ExportQuery exportQuery, EchoBaseUser user) { try { ExportQueryDAO dao = getDAO(); ExportQuery entityToSave; @@ -96,11 +96,24 @@ dao.update(entityToSave); getTransaction().commitTransaction(); + return entityToSave; } catch (TopiaException eee) { throw new EchoBaseTechnicalException(eee); } } + public void delete(String topiaId) { + try { + ExportQueryDAO dao = getDAO(); + ExportQuery entityToDelete = dao.findByTopiaId(topiaId); + dao.delete(entityToDelete); + + getTransaction().commitTransaction(); + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException(eee); + } + } + protected ExportQueryDAO getDAO() throws TopiaException { return EchoBaseDAOHelper.getExportQueryDAO(getTransaction()); } @@ -135,6 +148,29 @@ } } + public String createCsvStream(String sql, EchoBaseUser echoBaseUser) { + + GenericSQLQuery sqlQuery = new GenericSQLQuery(sql, null); + Map<String, Object>[] rows; + String[] columnNames; + try { + rows = sqlQuery.getResult(getTransaction()); + columnNames = sqlQuery.getColumnNames(); + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException("Could not execute sql query", eee); + } + StringBuilder buffer = new StringBuilder(); + int rowCount = rows.length; + buffer.append("# Created at ").append(new Date()).append(" by user ").append(echoBaseUser.getEmail()); + buffer.append("\n#").append(StringUtils.join(columnNames, ";")); + for (int i = 0; i < rowCount; i++) { + Map<String, Object> row = rows[i]; + buffer.append('\n').append(StringUtils.join(row.values(), ";")); + } + + return buffer.toString(); + } + private static class GenericSQLQuery extends TopiaSQLQuery<Map<String, Object>> { protected String[] columnNames;

1 0

r45 - in trunk/echobase-ui/src/main: java/fr/ifremer/echobase/ui java/fr/ifremer/echobase/ui/actions java/fr/ifremer/echobase/ui/actions/export java/fr/ifremer/echobase/ui/actions/json resources resources/config resources/i18n webapp/WEB-INF webapp/WEB-INF/includes webapp/WEB-INF/jsp webapp/WEB-INF/jsp/export
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 21:23:18 +0100 (Sat, 12 Nov 2011) New Revision: 45 Url: http://forge.codelutin.com/repositories/revision/echobase/45 Log: - continue sql export - reformat - continue menus Added: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadPage.java trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadSqlGrid.java trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/SaveExportQuery.java trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetSqlResult.java trunk/echobase-ui/src/main/resources/config/struts-export.xml trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportGrid.jsp Removed: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportQueryForm.jsp Modified: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/EchoBaseActionSupport.java trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetUsers.java trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties trunk/echobase-ui/src/main/resources/struts.xml trunk/echobase-ui/src/main/webapp/WEB-INF/decorators.xml trunk/echobase-ui/src/main/webapp/WEB-INF/includes/menu.jsp trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/export.jsp trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/home.jsp Modified: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java 2011-11-12 20:23:18 UTC (rev 45) @@ -256,7 +256,7 @@ rootContextSupplier.get(); try { boolean schemaFound = TopiaUtil.isSchemaExist( - tx.getHibernateConfiguration(), + tx, EchoBaseUserImpl.class.getName() ); Modified: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/EchoBaseActionSupport.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/EchoBaseActionSupport.java 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/EchoBaseActionSupport.java 2011-11-12 20:23:18 UTC (rev 45) @@ -43,7 +43,6 @@ import java.text.SimpleDateFormat; import java.util.Collection; import java.util.Date; -import java.util.Locale; import java.util.Map; /** @@ -192,6 +191,10 @@ return getDecoratorService().sortAndDecorate(getLocale(), beans, context); } + public String decorate(Object o, String context) { + return getDecoratorService().decorate(getLocale(), o, context); + } + protected SimpleDateFormat getDateFormat() { if (dateFormat == null) { dateFormat = new SimpleDateFormat("dd/MM/yyyy"); @@ -207,7 +210,7 @@ } protected DecoratorService getDecoratorService() { - if (decoratorService==null) { + if (decoratorService == null) { decoratorService = newService(DecoratorService.class); } return decoratorService; Added: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadPage.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadPage.java (rev 0) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadPage.java 2011-11-12 20:23:18 UTC (rev 45) @@ -0,0 +1,113 @@ +/* + * #%L + * EchoBase :: UI + * + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2011 Ifremer, Codelutin + * %% + * 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% + */ +package fr.ifremer.echobase.ui.actions.export; + +import fr.ifremer.echobase.entities.ExportQuery; +import fr.ifremer.echobase.entities.ExportQueryImpl; +import fr.ifremer.echobase.services.ExportSqlService; +import fr.ifremer.echobase.ui.actions.EchoBaseActionSupport; +import org.apache.commons.lang.StringUtils; + +import java.util.Collection; +import java.util.Map; + +/** + * Load export sql page. + * + * @author tchemit <chemit(a)codelutin.com> + * @since 0.1 + */ +public class LoadPage extends EchoBaseActionSupport { + + private static final long serialVersionUID = 1L; + + /** All available queries */ + protected Map<String, String> queries; + + /** Selected query */ + protected ExportQuery query; + + public ExportQuery getQuery() { + if (query == null) { + query = new ExportQueryImpl(); + } + return query; + } + + public Map<String, String> getQueries() { + return queries; + } + + public Map<String, String> getTableNames() { + return queries; + } + + @Override + public String input() throws Exception { + ExportSqlService service = newService(ExportSqlService.class); + + Collection<ExportQuery> sqlQueries = service.getQueries(); + queries = sortAndDecorate(sqlQueries, null); + + if (sqlQueries.isEmpty()) { + // no query saved + addActionMessage(_("echobase.info.no.sqlQuery.saved")); + } + + String selectedQueryId = getQuery().getTopiaId(); + + if (StringUtils.isEmpty(selectedQueryId)) { + + // no query selected + addActionMessage(_("echobase.info.no.sqlQuery.selected")); + } else { + + // load query + query = service.getQuery(selectedQueryId); + } + return INPUT; + } + +// public String getEditType(ColumnMeta meta) { +// Class<?> type = meta.getType(); +// String editType = "text"; +// if (boolean.class.equals(type)) { +// editType = "checkbox"; +// } else if (TopiaEntity.class.isAssignableFrom(type)) { +// editType = "select"; +// } +// return editType; +// } +// +// public String getFormatter(ColumnMeta meta) { +// Class<?> type = meta.getType(); +// String editType = "'string'"; +// if (boolean.class.equals(type)) { +// editType = "'checkbox'"; +// } else if (TopiaEntity.class.isAssignableFrom(type)) { +// editType = "'formatEntityLabel'"; +// } +// return editType; +// } +} Property changes on: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadPage.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Added: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadSqlGrid.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadSqlGrid.java (rev 0) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadSqlGrid.java 2011-11-12 20:23:18 UTC (rev 45) @@ -0,0 +1,66 @@ +/* + * #%L + * EchoBase :: UI + * + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2011 Ifremer, Codelutin + * %% + * 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% + */ +package fr.ifremer.echobase.ui.actions.export; + +import fr.ifremer.echobase.services.ExportSqlService; +import fr.ifremer.echobase.ui.actions.EchoBaseActionSupport; + +/** + * Load export sql grid page. + * + * @author tchemit <chemit(a)codelutin.com> + * @since 0.1 + */ +public class LoadSqlGrid extends EchoBaseActionSupport { + + private static final long serialVersionUID = 1L; + + /** Sql request to execute. */ + protected String sql; + + /** names of columns from the executed sql request. */ + protected String[] columnNames; + + public String getSql() { + return sql; + } + + public String[] getColumnNames() { + return columnNames; + } + + public void setSql(String sql) { + this.sql = sql; + } + + @Override + public String input() throws Exception { + + // obtain columNames from the request + ExportSqlService service = newService(ExportSqlService.class); + columnNames = service.getColumnNames(sql); + + return INPUT; + } +} Property changes on: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/LoadSqlGrid.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Added: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/SaveExportQuery.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/SaveExportQuery.java (rev 0) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/SaveExportQuery.java 2011-11-12 20:23:18 UTC (rev 45) @@ -0,0 +1,62 @@ +/* + * #%L + * EchoBase :: UI + * + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2011 Ifremer, Codelutin + * %% + * 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% + */ +package fr.ifremer.echobase.ui.actions.export; + +import fr.ifremer.echobase.entities.ExportQuery; +import fr.ifremer.echobase.entities.ExportQueryImpl; +import fr.ifremer.echobase.services.ExportSqlService; +import fr.ifremer.echobase.ui.actions.EchoBaseActionSupport; + +/** + * To save a given export query. + * + * @author tchemit <chemit(a)codelutin.com> + * @since 0.1 + */ +public class SaveExportQuery extends EchoBaseActionSupport { + + private static final long serialVersionUID = 1L; + + /** Selected query */ + protected ExportQuery query; + + public ExportQuery getQuery() { + if (query == null) { + query = new ExportQueryImpl(); + } + return query; + } + + @Override + public String execute() throws Exception { + + //TODO : do validation + ExportSqlService service = newService(ExportSqlService.class); + + service.createOrUpdate(getQuery(), + getEchoBaseSession().getEchoBaseUser() + ); + return SUCCESS; + } +} Property changes on: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/export/SaveExportQuery.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Added: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetSqlResult.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetSqlResult.java (rev 0) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetSqlResult.java 2011-11-12 20:23:18 UTC (rev 45) @@ -0,0 +1,92 @@ +/* + * #%L + * EchoBase :: UI + * + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2011 Ifremer, Codelutin + * %% + * 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% + */ +package fr.ifremer.echobase.ui.actions.json; + +import fr.ifremer.echobase.services.ExportSqlService; + +import java.util.Map; + +/** + * To get a export sql DTO. + * + * @author tchemit <chemit(a)codelutin.com> + * @since 0.1 + */ +public class GetSqlResult extends AbstractJSONPaginedAction { + + private static final long serialVersionUID = 1L; + + /** Sql request to execute. */ + protected String sql; + +// /** names of columns from the executed sql request. */ +// protected String[] columnNames; + + /** Datas of the given table. */ + protected Map<?, ?>[] datas; + + public GetSqlResult() { + super("datas_"); + } + + public void setSql(String sql) { + this.sql = sql; + } + +// public String[] getColumnNames() { +// return columnNames; +// } + + public Map<?, ?>[] getDatas() { + return datas; + } + + @Override + public Integer getRows() { + return pager.getPageSize(); + } + + @Override + public Integer getPage() { + return pager.getPageNumber(); + } + + @Override + public Integer getTotal() { + return pager.getPageCount(); + } + + @Override + public Integer getRecords() { + return pager.getRecords(); + } + + @Override + public String execute() throws Exception { + + ExportSqlService service = newService(ExportSqlService.class); + datas = service.executeSql(sql, pager); + return SUCCESS; + } +} Property changes on: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetSqlResult.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Modified: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetUsers.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetUsers.java 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/actions/json/GetUsers.java 2011-11-12 20:23:18 UTC (rev 45) @@ -23,11 +23,11 @@ */ package fr.ifremer.echobase.ui.actions.json; +import com.google.common.collect.Lists; import fr.ifremer.echobase.entities.EchoBaseUser; import fr.ifremer.echobase.entities.EchoBaseUserDTO; import fr.ifremer.echobase.services.UserService; -import java.util.ArrayList; import java.util.List; /** @@ -76,7 +76,7 @@ List<EchoBaseUser> allUsers = newService(UserService.class).getUsers(pager); - users = new ArrayList<EchoBaseUserDTO>(allUsers.size()); + users = Lists.newArrayList(); for (EchoBaseUser user : allUsers) { users.add(user.toDTO()); } Added: trunk/echobase-ui/src/main/resources/config/struts-export.xml =================================================================== --- trunk/echobase-ui/src/main/resources/config/struts-export.xml (rev 0) +++ trunk/echobase-ui/src/main/resources/config/struts-export.xml 2011-11-12 20:23:18 UTC (rev 45) @@ -0,0 +1,65 @@ +<?xml version="1.0" encoding="UTF-8" ?> + + +<!DOCTYPE struts PUBLIC + "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" + "http://struts.apache.org/dtds/struts-2.1.7.dtd"> + +<struts> + + <package name="export" extends="loggued" namespace="/export"> + + <action name="exportSql" method="input" + class="fr.ifremer.echobase.ui.actions.export.LoadPage"> + <interceptor-ref name="basicStackLoggued"/> + <result name="input">/WEB-INF/jsp/export/export.jsp</result> + </action> + + <action name="loadResult" method="input" + class="fr.ifremer.echobase.ui.actions.export.LoadSqlGrid"> + <interceptor-ref name="basicStackLoggued"/> + <result name="input">/WEB-INF/jsp/export/exportGrid.jsp</result> + </action> + + <action name="saveQuery" + class="fr.ifremer.echobase.ui.actions.export.SaveExportQuery"> + <interceptor-ref name="basicStackLoggued"/> + <result type="redirectAction"> + <param name="actionName">exportSql</param> + <param name="namespace">export</param> + <param name="query.topiaId">${query.topiaId}</param> + </result> + </action> + + <action name="getSqlResult" method="execute" + class="fr.ifremer.echobase.ui.actions.json.GetSqlResult"> + <interceptor-ref name="basicStackLoggued"/> + <result type="json"/> + </action> + + </package> + +</struts> + Property changes on: trunk/echobase-ui/src/main/resources/config/struts-export.xml ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Modified: trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties =================================================================== --- trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/resources/i18n/echobase-ui_fr_FR.properties 2011-11-12 20:23:18 UTC (rev 45) @@ -1,3 +1,4 @@ +echobase.action.applySqlQuery=Appliquer la requête echobase.action.create=Créer echobase.action.delete=Suppression echobase.action.import=Importer @@ -6,11 +7,16 @@ echobase.action.login=Connection echobase.action.logout=Déconnexion echobase.action.save=Sauvegarder +echobase.action.saveSqlQuery=Enregistrer la requête echobase.common.admin=Administrateur echobase.common.comment=Commentaire echobase.common.email=Email echobase.common.import=Import configuration echobase.common.password=Mot de passe +echobase.common.query.description=Description +echobase.common.query.name=Nom +echobase.common.request.result=Résultat de la requête sql +echobase.common.sqlQueries=Requêtes enregistrées echobase.common.tableName=Nom de la table echobase.common.user=Utilisateur echobase.common.voyage=Campagne @@ -29,6 +35,8 @@ echobase.importFile.lectureAgeGen=Fichier lecture age echobase.importFile.pecherie=Fichier pecherie echobase.importFile.typeEchoSpecies=Fichier espèces +echobase.info.no.sqlQuery.saved=Aucune requête d'export sql enregistré +echobase.info.no.sqlQuery.selected=Aucune requête d'export sql sélectionnée echobase.info.no.table.selected=Aucune table sélectionnée echobase.label.admin.user.create=Création d'un utilisateur echobase.label.admin.user.delete=Suppression d'un utilisateur @@ -40,12 +48,14 @@ echobase.label.login=Connexion echobase.label.user.login=Utilisateur \: %s echobase.label.welcome=Bienvenue -echobase.menu.export=Exports +echobase.menu.dbeditor=Modification du référentiel +echobase.menu.export=Export sql echobase.menu.import=Imports echobase.menu.logs=Logs echobase.menu.users=Utilisateurs echobase.message.modified.property= -echobase.msg.warnImportInProgress=Merci de ne pas fermer la fenêtre pour pouvoir acceder au résultats de l'import. +echobase.msg.warnImportInProgress=Merci de ne pas fermer la fenêtre pour pouvoir accéder aux résultats de l'import. +echobase.sqlQuery.configuration=Configuration de la requête echobase.title.dbEditor=Modification de la base echobase.title.export=Export echobase.title.import=Imports Modified: trunk/echobase-ui/src/main/resources/struts.xml =================================================================== --- trunk/echobase-ui/src/main/resources/struts.xml 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/resources/struts.xml 2011-11-12 20:23:18 UTC (rev 45) @@ -128,6 +128,7 @@ <include file="config/struts-json.xml"/> <include file="config/struts-user.xml"/> <include file="config/struts-import.xml"/> + <include file="config/struts-export.xml"/> </struts> Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/decorators.xml =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/decorators.xml 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/decorators.xml 2011-11-12 20:23:18 UTC (rev 45) @@ -30,6 +30,8 @@ <pattern>/user/login*</pattern> <pattern>/index*</pattern> <pattern>/dbeditor/getForeignEntities*</pattern> + <pattern>/export/loadResult*</pattern> + <pattern>/export/getSqlResult*</pattern> </excludes> <decorator name="layout-default" page="layout-default.jsp"> Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/includes/menu.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/includes/menu.jsp 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/includes/menu.jsp 2011-11-12 20:23:18 UTC (rev 45) @@ -28,11 +28,14 @@ <s:a action="import" namespace="/import"><s:text name="echobase.menu.import"/></s:a> </li> <li> - <s:a action="export"><s:text name="echobase.menu.export"/></s:a> + <s:a action="exportSql" namespace="/export"><s:text name="echobase.menu.export"/></s:a> </li> <li> <s:a action="logs"><s:text name="echobase.menu.logs"/></s:a> </li> + <li> + <s:a action="dbeditor" namespace="/dbeditor"><s:text name="echobase.menu.dbeditor"/></s:a> + </li> <s:if test="%{userIsAdmin}"> <li> Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/export.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/export.jsp 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/export.jsp 2011-11-12 20:23:18 UTC (rev 45) @@ -25,29 +25,70 @@ <%@ taglib prefix="s" uri="/struts-tags" %> <%@ taglib prefix="sj" uri="/struts-jquery-tags" %> +<s:url id="loadUrl" action='exportSql' namespace='/export'/> +<s:url id="loadGridUrl" action="loadResult" namespace="/export"/> +<script type="text/javascript"> + + jQuery(document).ready(function () { + + $('[name="query.topiaId"]').change(function(event) { + var url = "${loadUrl}?" + $.param({ 'query.topiaId':this.value}); + console.info("Reload url " + url); + window.location = url; + }); + }); + + function loadGridData() { + // get sql query + var sqlQuery = "${loadGridUrl}?" + $.param({ sql :$('[name="query.sqlQuery"]').val()}); + + $.ajax(sqlQuery, { + success: function(data, textStatus, jqXHR) { + $('#resultGrid').html(data); + console.info("Return " + data); + } + }); + return false; + } +</script> + <title><s:text name="echobase.title.export"/></title> -<s:url id="savedExportQueries" action="savedExportQueries" namespace="/ajax"/> -<sj:select id="lastQueriesSelect" - href="%{savedExportQueries}" - name="selectedQuery" - listKey="topiaId" - listValue="name" - list="savedExportQueries" - emptyOption="true" - listenTopics="updateSavedExportQueries" - onChangeTopics="updateExportQueryForm"/> +<s:form id="exportQueryForm" namespace="/export"> -<s:url id="exportQueryFormUrl" action="exportQueryFormForm" namespace="/fragment"/> -<sj:div id="exportQueryForm" - href="%{exportQueryFormUrl}" - listenTopics="updateExportQueryForm" - onSuccessTopics="updateExportGrid" - indicator="indicator-searchPanel"> - <img id="indicator-searchPanel" src="/img/indicator.gif" alt="Loading..." style="display:none"/> -</sj:div> + <s:select key="query.topiaId" label="%{getText('echobase.common.sqlQueries')}" + list="queries" headerKey="" headerValue=""/> -<%-- TODO sletellier : add result grid listen event updateExportGrid named exportGrid --%> + <br/> -</sjg:grid> \ No newline at end of file + <fieldset> + <legend><s:text name="echobase.sqlQuery.configuration"/></legend> + + <s:textfield key="query.name" required="true" + label="%{getText('echobase.common.query.name')}" size="40"/> + + <s:textarea key="query.description" required="true" cols="160" rows="6" + label="%{getText('echobase.common.query.description')}"/> + + <s:textarea key="query.sqlQuery" required="true" cols="160" rows="6" + label="%{getText('echobase.common.sqlQuery')}"/> + + <s:label value="%{query.lastModifiedDate}" readonly="true" + label="%{getText('echobase.common.lastModifiedDate')}"/> + + <s:label value="%{decorate(query.lastModifiedUser, null)}" readonly="true" + label="%{getText('echobase.common.lastModifiedUser')}"/> + </fieldset> + <br/> + + <s:submit action="saveQuery" key="echobase.action.saveSqlQuery" + align="right"/> + + <s:submit key="echobase.action.applySqlQuery" align="right" onclick="return loadGridData();"/> +</s:form> + +<br/> +<div id="resultGrid"></div> + + Added: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportGrid.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportGrid.jsp (rev 0) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportGrid.jsp 2011-11-12 20:23:18 UTC (rev 45) @@ -0,0 +1,51 @@ +<%-- + #%L + EchoBase :: UI + + $Id$ + $HeadURL$ + %% + Copyright (C) 2011 Ifremer, Codelutin + %% + 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% + --%> +<%@page contentType="text/html" pageEncoding="UTF-8" %> +<%@ taglib prefix="s" uri="/struts-tags" %> +<%@ taglib prefix="sj" uri="/struts-jquery-tags" %> +<%@ taglib prefix="sjg" uri="/struts-jquery-grid-tags" %> + +<s:url id="loadUrl" action="getSqlResult" namespace="/export" + escapeAmp="false"> + <s:param name="sql" value="%{sql}"/> +</s:url> + +<sjg:grid id="rows" caption="%{getText('echobase.common.request.result')}" + dataType="json" href="%{loadUrl}" gridModel="datas" + pager="true" pagerButtons="true" pagerInput="true" + navigator="true" autowidth="true" rownumbers="false" + navigatorEdit="false" navigatorDelete="false" + navigatorSearch="false" navigatorRefresh="true" + navigatorAdd="false" + rowList="10,15,20,50" rowNum="10" + viewrecords="true" resizable="true" editinline="false"> + + <s:iterator value="columnNames" var="name" status="status"> + + <sjg:gridColumn name="%{#name}" title="%{#name}" sortable="false"/> + + </s:iterator> + +</sjg:grid> + Property changes on: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportGrid.jsp ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native Deleted: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportQueryForm.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportQueryForm.jsp 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/export/exportQueryForm.jsp 2011-11-12 20:23:18 UTC (rev 45) @@ -1,67 +0,0 @@ -<%-- - #%L - EchoBase :: UI - - $Id$ - $HeadURL$ - %% - Copyright (C) 2011 Ifremer, Codelutin - %% - 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% - --%> -<%@page contentType="text/html" pageEncoding="UTF-8"%> -<%@taglib prefix="s" uri="/struts-tags"%> -<%@taglib prefix="sj" uri="/struts-jquery-tags" %> - -<s:form id="exportQueryForm" action="executeExportQuery" namespace="/export"> - - <s:text name="echobase.export.queryName"/> - <s:textfield id="queryName" - cssClass="right" - theme="simple" - name="queryName" - size="40"/> - - <s:text name="echobase.export.querySql"/> - <s:textarea id="querySql" - name="querySql" - cols="160" - rows="6"/> - - <s:text name="echobase.export.queryDescription"/> - <s:textarea id="querySql" - name="querySql" - cols="160" - rows="6"/> - - <s:url id="saveExportQueryUrl" action="saveExportQuery" namespace="export"/> - - <s:set id="saveExportQueryText"> - <s:text name="echobase.action.save"/> - </s:set> - - <sj:submit id="saveQuery" - href="%{saveExportQueryUrl}" - value="%{saveExportQueryText}" - onSuccessTopics="updateExportQueries" - button="true"/> - - <sj:submit id="search" - value="%{searchText}" - indicator="indicator-exportGrid" - targets="exportGrid" - button="true"/> - -</s:form> \ No newline at end of file Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/home.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/home.jsp 2011-11-12 20:22:04 UTC (rev 44) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/home.jsp 2011-11-12 20:23:18 UTC (rev 45) @@ -28,5 +28,4 @@ <h2><s:text name="echobase.label.welcome"/></h2> -<s:a action="dbeditor" namespace="/dbeditor">Modification du référentiel</s:a> <hr/> \ No newline at end of file

1 0

r44 - trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/dbeditor
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 21:22:04 +0100 (Sat, 12 Nov 2011) New Revision: 44 Url: http://forge.codelutin.com/repositories/revision/echobase/44 Log: reformat Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/dbeditor/dbeditor.jsp Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/dbeditor/dbeditor.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/dbeditor/dbeditor.jsp 2011-11-12 20:21:21 UTC (rev 43) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/jsp/dbeditor/dbeditor.jsp 2011-11-12 20:22:04 UTC (rev 44) @@ -47,8 +47,7 @@ </script> <div> - <s:select key="tableName" - label='%{getText("echobase.common.tableName")}' + <s:select key="tableName" label='%{getText("echobase.common.tableName")}' list="tableNames" headerKey="" headerValue=""/> </div> <br/>

1 0

r43 - trunk/echobase-services/src/main/java/fr/ifremer/echobase/services
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 21:21:21 +0100 (Sat, 12 Nov 2011) New Revision: 43 Url: http://forge.codelutin.com/repositories/revision/echobase/43 Log: continue export sql service Added: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java Added: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java (rev 0) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java 2011-11-12 20:21:21 UTC (rev 43) @@ -0,0 +1,217 @@ +/* + * #%L + * EchoBase :: Services + * + * $Id$ + * $HeadURL$ + * %% + * Copyright (C) 2011 Ifremer, Codelutin + * %% + * 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% + */ +package fr.ifremer.echobase.services; + +import fr.ifremer.echobase.EchoBaseTechnicalException; +import fr.ifremer.echobase.entities.EchoBaseDAOHelper; +import fr.ifremer.echobase.entities.EchoBaseUser; +import fr.ifremer.echobase.entities.ExportQuery; +import fr.ifremer.echobase.entities.ExportQueryDAO; +import org.apache.commons.lang.StringUtils; +import org.apache.commons.logging.Log; +import org.apache.commons.logging.LogFactory; +import org.nuiton.topia.TopiaContext; +import org.nuiton.topia.TopiaException; +import org.nuiton.topia.framework.TopiaContextImplementor; +import org.nuiton.topia.framework.TopiaSQLQuery; + +import java.sql.Connection; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Collection; +import java.util.Date; +import java.util.List; +import java.util.Map; + +/** + * Service to deal with sql export. + * + * @author tchemit <chemit(a)codelutin.com> + * @since 0.1 + */ +public class ExportSqlService extends AbstractEchoBaseService { + + /** Logger. */ + private static final Log log = LogFactory.getLog(ExportSqlService.class); + + public Collection<ExportQuery> getQueries() { + try { + List<ExportQuery> result = getDAO().findAll(); + return result; + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException("Could not obtain export queries", eee); + } + } + + public ExportQuery getQuery(String queryId) { + + try { + ExportQuery result = getDAO().findByTopiaId(queryId); + return result; + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException("Could not obtain export query with id " + queryId, eee); + } + } + + public void createOrUpdate(ExportQuery exportQuery, EchoBaseUser user) { + try { + ExportQueryDAO dao = getDAO(); + ExportQuery entityToSave; + + // No id, creating new one entity + String id = exportQuery.getTopiaId(); + if (StringUtils.isEmpty(id)) { + entityToSave = dao.create(); + } else { + entityToSave = dao.findByTopiaId(id); + } + + entityToSave.setName(exportQuery.getName()); + entityToSave.setDescription(exportQuery.getDescription()); + entityToSave.setSqlQuery(exportQuery.getSqlQuery()); + entityToSave.setLastModifiedDate(new Date()); + entityToSave.setLastModifiedUser(user); + + dao.update(entityToSave); + getTransaction().commitTransaction(); + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException(eee); + } + } + + protected ExportQueryDAO getDAO() throws TopiaException { + return EchoBaseDAOHelper.getExportQueryDAO(getTransaction()); + } + + public Map<String, Object>[] executeSql(String sql, Pager pager) { + + // get a query to count all rows for the request + GenericSQLQuery sqlQuery = new GenericSQLQuery(sql, pager); + try { + Map<String, Object>[] result = sqlQuery.getResult(getTransaction()); + return result; + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException("Could not execute sql query", eee); + } + } + + public String[] getColumnNames(String sql) { + + String limitSql = sql.trim(); + if (limitSql.endsWith(";")) { + limitSql = limitSql.substring(0, limitSql.length() - 1); + limitSql += " LIMIT 1"; + } + try { + // do a limit query to one result and obtain the column names + // from the meta data of the result set + GenericSQLQuery sqlQuery = new GenericSQLQuery(limitSql, null); + String[] result = sqlQuery.getColumnNames(getTransaction()); + return result; + } catch (TopiaException eee) { + throw new EchoBaseTechnicalException("Could not execute query " + limitSql, eee); + } + } + + private static class GenericSQLQuery extends TopiaSQLQuery<Map<String, Object>> { + + protected String[] columnNames; + + private final String sql; + + private final Pager pager; + + public GenericSQLQuery(String sql, Pager pager) { + this.sql = sql; + this.pager = pager; + } + + public String[] getColumnNames() { + return columnNames; + } + + @Override + protected PreparedStatement prepareQuery(Connection connection) throws SQLException { + return connection.prepareStatement( + sql, + ResultSet.TYPE_SCROLL_INSENSITIVE, + ResultSet.CONCUR_READ_ONLY + ); + } + + @Override + protected void afterExecuteQuery(ResultSet set) throws SQLException { + super.afterExecuteQuery(set); + + // obtain columnNames + columnNames = getColumnNames(set); + + if (pager != null) { + + // must count rows + int nbRows = getNbRows(set); + if (log.isInfoEnabled()) { + log.info("For request " + sql + ", nb rows = " + nbRows); + } + pager.setRecords(nbRows); + pager.computeIndexesAndPageCount(); + } + } + + @Override + protected Map<String, Object> prepareResult(ResultSet set) throws SQLException { + + if (pager != null) { + + // get row number (getRow() begins at 1) + int rowNumber = set.getRow() - 1; + if (rowNumber < pager.getStartIndex() || + rowNumber >= pager.getEndIndex()) { + + // out of pager bound, by returning null + // result will not be take in account + return null; + } + } + + Map<String, Object> result = getRowAsMap(columnNames, set); + return result; + } + + public Map<String, Object>[] getResult(TopiaContext tx) throws TopiaException { + List<Map<String, Object>> rows = + findMultipleResult((TopiaContextImplementor) tx); + return rows.toArray(new Map[rows.size()]); + } + + + public String[] getColumnNames(TopiaContext tx) throws TopiaException { + findSingleResult((TopiaContextImplementor) tx); + return columnNames; + } + + + } +} Property changes on: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/ExportSqlService.java ___________________________________________________________________ Added: svn:keywords + Author Date Id Revision HeadURL Added: svn:eol-style + native

1 0

r42 - trunk/echobase-services/src/main/java/fr/ifremer/echobase/services
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 21:21:07 +0100 (Sat, 12 Nov 2011) New Revision: 42 Url: http://forge.codelutin.com/repositories/revision/echobase/42 Log: add decorator Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DecoratorService.java Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DecoratorService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DecoratorService.java 2011-11-12 20:20:53 UTC (rev 41) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DecoratorService.java 2011-11-12 20:21:07 UTC (rev 42) @@ -27,6 +27,7 @@ import com.google.common.collect.Lists; import com.google.common.collect.Maps; import fr.ifremer.echobase.entities.EchoBaseUser; +import fr.ifremer.echobase.entities.ExportQuery; import fr.ifremer.echobase.entities.Voyage; import org.apache.commons.collections.CollectionUtils; import org.nuiton.topia.persistence.TopiaEntity; @@ -123,6 +124,8 @@ // voyage decorator registerJXPathDecorator(locale, Voyage.class, "${voyageName}$s"); + // export query decorator + registerJXPathDecorator(locale, ExportQuery.class, "${name}$s - ${description}$s"); } } }

1 0

r41 - trunk/echobase-services/src/main/java/fr/ifremer/echobase/services
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 21:20:53 +0100 (Sat, 12 Nov 2011) New Revision: 41 Url: http://forge.codelutin.com/repositories/revision/echobase/41 Log: id can be empty (from form) Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java 2011-11-12 20:16:33 UTC (rev 40) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/UserService.java 2011-11-12 20:20:53 UTC (rev 41) @@ -96,7 +96,7 @@ // No id, creating new one entity String id = userDTO.getId(); - if (id == null) { + if (StringUtils.isEmpty(id)) { user = dao.create(); } else { user = dao.findByTopiaId(id);

1 0

r40 - trunk
by tchemit＠users.forge.codelutin.com 12 Nov '11

12 Nov '11

Author: tchemit Date: 2011-11-12 21:16:33 +0100 (Sat, 12 Nov 2011) New Revision: 40 Url: http://forge.codelutin.com/repositories/revision/echobase/40 Log: pass to snapshot of topia Modified: trunk/pom.xml Modified: trunk/pom.xml =================================================================== --- trunk/pom.xml 2011-11-11 17:19:56 UTC (rev 39) +++ trunk/pom.xml 2011-11-12 20:16:33 UTC (rev 40) @@ -107,7 +107,7 @@  <eugenePluginVersion>2.4.1</eugenePluginVersion> - <topiaVersion>2.6.3</topiaVersion> + <topiaVersion>2.6.4-SNAPSHOT</topiaVersion> <nuitonUtilsVersion>2.4-SNAPSHOT</nuitonUtilsVersion> <nuitonI18nVersion>2.4.1</nuitonI18nVersion> <nuitonWebVersion>1.6-SNAPSHOT</nuitonWebVersion>

1 0

r39 - trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui
by tchemit＠users.forge.codelutin.com 11 Nov '11

11 Nov '11

Author: tchemit Date: 2011-11-11 18:19:56 +0100 (Fri, 11 Nov 2011) New Revision: 39 Url: http://forge.codelutin.com/repositories/revision/echobase/39 Log: add options to create a lotf of admin (for dev purpose only) Modified: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java Modified: trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java =================================================================== --- trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java 2011-11-11 17:17:43 UTC (rev 38) +++ trunk/echobase-ui/src/main/java/fr/ifremer/echobase/ui/EchoBaseApplicationListener.java 2011-11-11 17:19:56 UTC (rev 39) @@ -225,12 +225,24 @@ "admin user (password admin)."); } - EchoBaseUserDTO userDTO = new EchoBaseUserDTOImpl(); + EchoBaseUserDTO userDTO; + userDTO = new EchoBaseUserDTOImpl(); userDTO.setEmail("admin"); userDTO.setPassword("admin"); userDTO.setAdmin(true); service.createOrUpdate(userDTO); + if (configuration.getOptionAsBoolean("createAdmins")) { + for (int i = 0; i < 1000; i++) { + userDTO = new EchoBaseUserDTOImpl(); + userDTO.setEmail("admin" + i); + userDTO.setPassword("admin"); + userDTO.setAdmin(i % 2 == 0); + service.createOrUpdate(userDTO); + + } + } + } } finally { transaction.closeContext();

1 0

r38 - trunk/echobase-services/src/main/java/fr/ifremer/echobase/services
by tchemit＠users.forge.codelutin.com 11 Nov '11

11 Nov '11

Author: tchemit Date: 2011-11-11 18:17:43 +0100 (Fri, 11 Nov 2011) New Revision: 38 Url: http://forge.codelutin.com/repositories/revision/echobase/38 Log: fix saing of foreign keys Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java Modified: trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java =================================================================== --- trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java 2011-11-11 17:17:04 UTC (rev 37) +++ trunk/echobase-services/src/main/java/fr/ifremer/echobase/services/DbEditorService.java 2011-11-11 17:17:43 UTC (rev 38) @@ -168,9 +168,21 @@ for (Map.Entry<String, String> entry : properties.entrySet()) { String propertyName = entry.getKey(); String propertyValue = entry.getValue(); + Object value; + ColumnMeta columnMeta = tableMeta.getColumns(propertyName); + if (columnMeta.isFK()) { + + // let's find the entity + TopiaDAO daoFK = EchoBaseDAOHelper.getDAO( + getTransaction(), + (Class<? extends TopiaEntity>) columnMeta.getType()); + value = daoFK.findByTopiaId(propertyValue); + } else { + value = propertyValue; + } BeanUtils.setProperty(entityToSave, propertyName, - propertyValue); + value); } PropertyDiff[] propertyDiffs = monitor.getPropertyDiffs();

1 0

r37 - trunk/echobase-ui/src/main/webapp/WEB-INF/includes
by tchemit＠users.forge.codelutin.com 11 Nov '11

11 Nov '11

Author: tchemit Date: 2011-11-11 18:17:04 +0100 (Fri, 11 Nov 2011) New Revision: 37 Url: http://forge.codelutin.com/repositories/revision/echobase/37 Log: change jquery theme Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/includes/metas.jsp Modified: trunk/echobase-ui/src/main/webapp/WEB-INF/includes/metas.jsp =================================================================== --- trunk/echobase-ui/src/main/webapp/WEB-INF/includes/metas.jsp 2011-11-11 17:15:10 UTC (rev 36) +++ trunk/echobase-ui/src/main/webapp/WEB-INF/includes/metas.jsp 2011-11-11 17:17:04 UTC (rev 37) @@ -32,5 +32,5 @@ href="<s:url value='/css/screen.css' />"/> <link rel="icon" type="image/png" href="<s:url value='/images/logo_codelutin.png' />"/> - <sj:head jqueryui="true" jquerytheme="start"/> + <sj:head jqueryui="true" jquerytheme="cupertino"/> </head>

1 0