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 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE ) )
70 {
71 daoUtil.setInt( 1, nPortletId );
72 daoUtil.setInt( 2, nSpaceId );
73 daoUtil.executeUpdate( );
74 }
75 }
76
77
78
79
80
81
82
83 public void deleteAllSpaces( int nPortletId )
84 {
85 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE_ALL_SPACES ) )
86 {
87 daoUtil.setInt( 1, nPortletId );
88 daoUtil.executeUpdate( );
89 }
90 }
91
92
93
94
95
96
97
98 public void insert( DocumentAutoPublication documentAutoPublication )
99 {
100 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT ) )
101 {
102 daoUtil.setInt( 1, documentAutoPublication.getIdPortlet( ) );
103 daoUtil.setInt( 2, documentAutoPublication.getIdSpace( ) );
104
105 daoUtil.executeUpdate( );
106 }
107 }
108
109
110
111
112
113
114
115
116
117
118 public DocumentAutoPublication load( int nPortletId, int nSpaceId )
119 {
120 DocumentAutoPublication documentAutoPublication = null;
121
122 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_PRIMARY_KEY ) )
123 {
124 daoUtil.setInt( 1, nPortletId );
125 daoUtil.setInt( 2, nSpaceId );
126 daoUtil.executeQuery( );
127
128 if ( daoUtil.next( ) )
129 {
130 documentAutoPublication = new DocumentAutoPublication( );
131 documentAutoPublication.setIdPortlet( daoUtil.getInt( 1 ) );
132 documentAutoPublication.setIdSpace( daoUtil.getInt( 2 ) );
133 }
134 }
135 return documentAutoPublication;
136 }
137
138
139
140
141
142
143 public Collection<DocumentAutoPublication> load( )
144 {
145 Collection<DocumentAutoPublication> listDocumentAutoPublication = new ArrayList<>( );
146 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_ALL ) )
147 {
148 daoUtil.executeQuery( );
149
150 while ( daoUtil.next( ) )
151 {
152 DocumentAutoPublicationtion/DocumentAutoPublication.html#DocumentAutoPublication">DocumentAutoPublication documentAutoPublication = new DocumentAutoPublication( );
153 documentAutoPublication.setIdPortlet( daoUtil.getInt( 1 ) );
154 documentAutoPublication.setIdSpace( daoUtil.getInt( 2 ) );
155 listDocumentAutoPublication.add( documentAutoPublication );
156 }
157 }
158 return listDocumentAutoPublication;
159 }
160
161
162
163
164
165
166
167
168 public Collection<DocumentAutoPublication> selectByPortletId( int nPortletId )
169 {
170 Collection<DocumentAutoPublication> listDocumentAutoPublication = new ArrayList<>( );
171 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_PORTLET_ID ) )
172 {
173 daoUtil.setInt( 1, nPortletId );
174 daoUtil.executeQuery( );
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 return listDocumentAutoPublication;
185 }
186
187
188
189
190
191
192
193
194 public Collection<DocumentAutoPublication> selectBySpaceId( int nSpaceId )
195 {
196 Collection<DocumentAutoPublication> listDocumentAutoPublication = new ArrayList<>( );
197 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_SPACE_ID ) )
198 {
199 daoUtil.setInt( 1, nSpaceId );
200 daoUtil.executeQuery( );
201
202 while ( daoUtil.next( ) )
203 {
204 DocumentAutoPublicationtion/DocumentAutoPublication.html#DocumentAutoPublication">DocumentAutoPublication documentAutoPublication = new DocumentAutoPublication( );
205 documentAutoPublication.setIdPortlet( daoUtil.getInt( 1 ) );
206 documentAutoPublication.setIdSpace( nSpaceId );
207 listDocumentAutoPublication.add( documentAutoPublication );
208 }
209 }
210 return listDocumentAutoPublication;
211 }
212
213
214
215
216
217
218
219 public void store( DocumentAutoPublication documentAutoPublication )
220 {
221
222
223
224
225
226
227
228
229 }
230 }