1 /*
2 * Copyright (c) 2002-2015, 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.sqlpage.business;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.portal.service.plugin.PluginService;
38 import fr.paris.lutece.portal.service.spring.SpringContextService;
39
40 import java.util.List;
41
42 /**
43 * This class provides instances management methods (create, find, ...) for SQLFragment objects
44 */
45 public final class SQLFragmentHome
46 {
47 // Static variable pointed at the DAO instance
48 private static ISQLFragmentDAO _dao = SpringContextService.getBean( "sqlpage.sQLFragmentDAO" );
49 private static Plugin _plugin = PluginService.getPlugin( "sqlpage" );
50
51 /**
52 * Private constructor - this class need not be instantiated
53 */
54 private SQLFragmentHome( )
55 {
56 }
57
58 /**
59 * Create an instance of the sQLFragment class
60 *
61 * @param sQLFragment
62 * The instance of the SQLFragment which contains the informations to store
63 * @return The instance of sQLFragment which has been created with its primary key.
64 */
65 public static SQLFragment create( SQLFragment sQLFragment )
66 {
67 _dao.insert( sQLFragment, _plugin );
68
69 return sQLFragment;
70 }
71
72 /**
73 * Update of the sQLFragment which is specified in parameter
74 *
75 * @param sQLFragment
76 * The instance of the SQLFragment which contains the data to store
77 * @return The instance of the sQLFragment which has been updated
78 */
79 public static SQLFragment update( SQLFragment sQLFragment )
80 {
81 _dao.store( sQLFragment, _plugin );
82
83 return sQLFragment;
84 }
85
86 /**
87 * Remove the sQLFragment whose identifier is specified in parameter
88 *
89 * @param nKey
90 * The sQLFragment Id
91 */
92 public static void remove( int nKey )
93 {
94 _dao.delete( nKey, _plugin );
95 }
96
97 // /////////////////////////////////////////////////////////////////////////
98 // Finders
99
100 /**
101 * Returns an instance of a sQLFragment whose identifier is specified in parameter
102 *
103 * @param nKey
104 * The sQLFragment primary key
105 * @return an instance of SQLFragment
106 */
107 public static SQLFragment findByPrimaryKey( int nKey )
108 {
109 return _dao.load( nKey, _plugin );
110 }
111
112 /**
113 * Load the data of all the sQLFragment objects and returns them in form of a List
114 *
115 * @param nIdPage
116 * The Page ID
117 * @return the List which contains the data of all the sQLFragment objects
118 */
119 public static List<SQLFragment> getSQLFragmentsList( int nIdPage )
120 {
121 return _dao.selectSQLFragmentsList( nIdPage, _plugin );
122 }
123
124 /**
125 * Reorder fragments
126 *
127 * @param previous
128 * the fragment 1
129 * @param next
130 * the fragment 2
131 */
132 public static void swapFragmentsOrder( SQLFragment previous, SQLFragment next )
133 {
134 if ( ( next.getIdOrder( ) - previous.getIdOrder( ) ) != 1 )
135 {
136 next.setIdOrder( previous.getIdOrder( ) + 1 );
137 }
138
139 _dao.swapFragmentsOrder( previous, next, _plugin );
140 }
141 }