View Javadoc
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 }