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
38 import java.util.List;
39
40 /**
41 * ISQLFragmentDAO Interface
42 */
43 public interface ISQLFragmentDAO
44 {
45 /**
46 * Insert a new record in the table.
47 *
48 * @param sQLFragment
49 * instance of the SQLFragment object to insert
50 * @param plugin
51 * the Plugin
52 */
53 void insert( SQLFragment sQLFragment, Plugin plugin );
54
55 /**
56 * Update the record in the table
57 *
58 * @param sQLFragment
59 * the reference of the SQLFragment
60 * @param plugin
61 * the Plugin
62 */
63 void store( SQLFragment sQLFragment, Plugin plugin );
64
65 /**
66 * Delete a record from the table
67 *
68 * @param nKey
69 * The identifier of the SQLFragment to delete
70 * @param plugin
71 * the Plugin
72 */
73 void delete( int nKey, Plugin plugin );
74
75 // /////////////////////////////////////////////////////////////////////////
76 // Finders
77
78 /**
79 * Load the data from the table
80 *
81 * @param nKey
82 * The identifier of the sQLFragment
83 * @param plugin
84 * the Plugin
85 * @return The instance of the sQLFragment
86 */
87 SQLFragment load( int nKey, Plugin plugin );
88
89 /**
90 * Load the data of all the sQLFragment objects and returns them as a List
91 *
92 * @param nIdPage
93 * The Page ID
94 * @param plugin
95 * the Plugin
96 * @return The List which contains the data of all the sQLFragment objects
97 */
98 List<SQLFragment> selectSQLFragmentsList( int nIdPage, Plugin plugin );
99
100 /**
101 * Swap fragments order
102 *
103 * @param fragment1
104 * the fragment 1
105 * @param fragment2
106 * the fragment 2
107 * @param plugin
108 * The plugin
109 */
110 void swapFragmentsOrder( SQLFragment fragment1, SQLFragment fragment2, Plugin plugin );
111 }