1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 package fr.paris.lutece.plugins.document.business.autopublication;
35
36 import fr.paris.lutece.plugins.document.business.spaces.DocumentSpace;
37 import fr.paris.lutece.portal.business.portlet.Portlet;
38 import fr.paris.lutece.util.sql.DAOUtil;
39
40 import java.util.ArrayList;
41 import java.util.Collection;
42
43
44
45
46
47 public class DocumentAutoPublicationDAO implements IDocumentAutoPublicationDAO
48 {
49 private static final String SQL_QUERY_INSERT = "INSERT INTO document_auto_publication ( id_portlet , id_space ) VALUES ( ? , ? )";
50 private static final String SQL_QUERY_SELECT_BY_PRIMARY_KEY = "SELECT id_portlet, id_space FROM document_auto_publication WHERE id_portlet = ? AND id_space = ?";
51 private static final String SQL_QUERY_SELECT_ALL = "SELECT id_portlet, id_space FROM document_auto_publication ";
52 private static final String SQL_QUERY_SELECT_BY_PORTLET_ID = "SELECT id_space FROM document_auto_publication WHERE id_portlet = ? ";
53 private static final String SQL_QUERY_SELECT_BY_SPACE_ID = "SELECT id_portlet FROM document_auto_publication WHERE id_space = ? ";
54
55
56 private static final String SQL_QUERY_DELETE = "DELETE FROM document_auto_publication WHERE id_portlet= ? AND id_space= ? ";
57 private static final String SQL_QUERY_DELETE_ALL_SPACES = "DELETE FROM document_auto_publication WHERE id_portlet= ? ";
58
59
60
61
62
63
64
65
66
67 public void delete( int nPortletId, int nSpaceId )
68 {
69 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
70 daoUtil.setInt( 1, nPortletId );
71 daoUtil.setInt( 2, nSpaceId );
72 daoUtil.executeUpdate( );
73 daoUtil.free( );
74 }
75
76
77
78
79
80
81
82 public void deleteAllSpaces( int nPortletId )
83 {
84 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE_ALL_SPACES );
85 daoUtil.setInt( 1, nPortletId );
86 daoUtil.executeUpdate( );
87 daoUtil.free( );
88 }
89
90
91
92
93
94
95
96 public void insert( DocumentAutoPublication documentAutoPublication )
97 {
98 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
99 daoUtil.setInt( 1, documentAutoPublication.getIdPortlet( ) );
100 daoUtil.setInt( 2, documentAutoPublication.getIdSpace( ) );
101
102 daoUtil.executeUpdate( );
103 daoUtil.free( );
104 }
105
106
107
108
109
110
111
112
113
114
115 public DocumentAutoPublication load( int nPortletId, int nSpaceId )
116 {
117 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_PRIMARY_KEY );
118 daoUtil.setInt( 1, nPortletId );
119 daoUtil.setInt( 2, nSpaceId );
120 daoUtil.executeQuery( );
121
122 DocumentAutoPublication documentAutoPublication = null;
123
124 if ( daoUtil.next( ) )
125 {
126 documentAutoPublication = new DocumentAutoPublication( );
127 documentAutoPublication.setIdPortlet( daoUtil.getInt( 1 ) );
128 documentAutoPublication.setIdSpace( daoUtil.getInt( 2 ) );
129 }
130
131 daoUtil.free( );
132
133 return documentAutoPublication;
134 }
135
136
137
138
139
140
141 public Collection<DocumentAutoPublication> load( )
142 {
143 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_ALL );
144 daoUtil.executeQuery( );
145
146 Collection<DocumentAutoPublication> listDocumentAutoPublication = new ArrayList<DocumentAutoPublication>( );
147
148 while ( daoUtil.next( ) )
149 {
150 DocumentAutoPublicationtion/DocumentAutoPublication.html#DocumentAutoPublication">DocumentAutoPublication documentAutoPublication = new DocumentAutoPublication( );
151 documentAutoPublication.setIdPortlet( daoUtil.getInt( 1 ) );
152 documentAutoPublication.setIdSpace( daoUtil.getInt( 2 ) );
153 listDocumentAutoPublication.add( documentAutoPublication );
154 }
155
156 daoUtil.free( );
157
158 return listDocumentAutoPublication;
159 }
160
161
162
163
164
165
166
167
168 public Collection<DocumentAutoPublication> selectByPortletId( int nPortletId )
169 {
170 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_PORTLET_ID );
171 daoUtil.setInt( 1, nPortletId );
172 daoUtil.executeQuery( );
173
174 Collection<DocumentAutoPublication> listDocumentAutoPublication = new ArrayList<DocumentAutoPublication>( );
175
176 while ( daoUtil.next( ) )
177 {
178 DocumentAutoPublicationtion/DocumentAutoPublication.html#DocumentAutoPublication">DocumentAutoPublication documentAutoPublication = new DocumentAutoPublication( );
179 documentAutoPublication.setIdPortlet( nPortletId );
180 documentAutoPublication.setIdSpace( daoUtil.getInt( 1 ) );
181 listDocumentAutoPublication.add( documentAutoPublication );
182 }
183
184 daoUtil.free( );
185
186 return listDocumentAutoPublication;
187 }
188
189
190
191
192
193
194
195
196 public Collection<DocumentAutoPublication> selectBySpaceId( int nSpaceId )
197 {
198 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_SPACE_ID );
199 daoUtil.setInt( 1, nSpaceId );
200 daoUtil.executeQuery( );
201
202 Collection<DocumentAutoPublication> listDocumentAutoPublication = new ArrayList<DocumentAutoPublication>( );
203
204 while ( daoUtil.next( ) )
205 {
206 DocumentAutoPublicationtion/DocumentAutoPublication.html#DocumentAutoPublication">DocumentAutoPublication documentAutoPublication = new DocumentAutoPublication( );
207 documentAutoPublication.setIdPortlet( daoUtil.getInt( 1 ) );
208 documentAutoPublication.setIdSpace( nSpaceId );
209 listDocumentAutoPublication.add( documentAutoPublication );
210 }
211
212 daoUtil.free( );
213
214 return listDocumentAutoPublication;
215 }
216
217
218
219
220
221
222
223 public void store( DocumentAutoPublication documentAutoPublication )
224 {
225
226
227
228
229
230
231
232
233 }
234 }