1 /* 2 * Copyright (c) 2002-2017, Mairie de Paris 3 * All rights reserved. 4 * 5 * Redistribution and use in source and binary forms, with or without 6 * modification, are permitted provided that the following conditions 7 * are met: 8 * 9 * 1. Redistributions of source code must retain the above copyright notice 10 * and the following disclaimer. 11 * 12 * 2. Redistributions in binary form must reproduce the above copyright notice 13 * and the following disclaimer in the documentation and/or other materials 14 * provided with the distribution. 15 * 16 * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its 17 * contributors may be used to endorse or promote products derived from 18 * this software without specific prior written permission. 19 * 20 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 21 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 22 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 23 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE 24 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 25 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 26 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 27 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 28 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 29 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 30 * POSSIBILITY OF SUCH DAMAGE. 31 * 32 * License 1.0 33 */ 34 package fr.paris.lutece.plugins.adminsql.business; 35 36 import fr.paris.lutece.portal.service.plugin.Plugin; 37 import fr.paris.lutece.portal.service.spring.SpringContextService; 38 39 40 import java.util.List; 41 42 43 /** 44 * The class calling the business objects 45 */ 46 public final class TableHome 47 { 48 private static ITableDAO _dao = (ITableDAO) SpringContextService.getPluginBean( "adminsql", "tableDAO" ); 49 50 /** 51 * Find the tables list of a pool 52 * @param plugin Plugin adminsq 53 * @return list of tables 54 */ 55 public static List<Table> findAll( Plugin plugin ) 56 { 57 return _dao.selectTableList( plugin ); 58 } 59 60 /** 61 * Find the tables list of a pool 62 * @param strPoolName the name of the pool 63 * @param plugin Plugin adminsq 64 * @return list of tables 65 */ 66 public static List<Table> findAllByPool( String strPoolName, Plugin plugin ) 67 { 68 return _dao.selectTableListByPool( strPoolName, plugin ); 69 } 70 71 /** 72 * Find table in tables list 73 * @param strPoolName the name of the pool 74 * @param strTableName the name of the table 75 * @param plugin Plugin adminsql 76 * @return table in tables list 77 */ 78 public static Table findByPrimaryKey( String strPoolName, String strTableName, Plugin plugin ) 79 { 80 return _dao.load( strPoolName, strTableName, plugin ); 81 } 82 83 /** 84 * Create an intance of a field 85 * @param strPoolName the name of the pool 86 * @param table Table object 87 * @param field field object 88 * @param plugin Plugin adminsql 89 * @return list of the tables 90 */ 91 public static void create( String strPoolName, Table table, Field field, Plugin plugin )//throws CreationException 1.Field null 92 { 93 _dao.insert( strPoolName, table, field, plugin ); 94 } 95 96 /** 97 * Delete a table 98 * @param strTableName the name of the table 99 * @param plugin Plugin adminsql 100 */ 101 public static void remove( String strTableName, Plugin plugin ) 102 { 103 _dao.delete( strTableName, plugin ); 104 } 105 106 /** 107 * Update a table on a database 108 * @param strTableNameToModify 109 * @param table Table object 110 */ 111 public static void update( String strTableNameToModify, Table table ) 112 { 113 _dao.store( strTableNameToModify, table ); 114 } 115 }