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.directory.business.rss;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39 import java.util.ArrayList;
40 import java.util.List;
41
42
43
44
45
46
47 public class DirectoryResourceRssConfigDAO implements IDirectoryResourceRssConfigDAO
48 {
49 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = "SELECT id_rss,id_directory,id_entry_title,id_entry_description,id_entry_image,id_entry_link,id_entry_filter_1,value_filter_1,id_entry_filter_2,value_filter_2,id_workflow_state "
50 + "FROM directory_rss_cf WHERE id_rss=?";
51 private static final String SQL_QUERY_INSERT = "INSERT INTO directory_rss_cf( "
52 + "id_rss,id_directory,id_entry_title,id_entry_description,id_entry_image,id_entry_link,id_entry_filter_1,value_filter_1,id_entry_filter_2,value_filter_2,id_workflow_state)"
53 + "VALUES (?,?,?,?,?,?,?,?,?,?,?)";
54 private static final String SQL_QUERY_UPDATE = "UPDATE directory_rss_cf "
55 + "SET id_rss=?,id_directory=?,id_entry_title=?,id_entry_description=?,id_entry_image=?,id_entry_link=?,id_entry_filter_1=?,value_filter_1=?,id_entry_filter_2=?,value_filter_2=?,id_workflow_state=? "
56 + " WHERE id_rss=?";
57 private static final String SQL_QUERY_DELETE = "DELETE FROM directory_rss_cf WHERE id_rss=? ";
58 private static final String SQL_QUERY_FIND_ALL = "SELECT id_rss,id_directory,id_entry_title,id_entry_description,id_entry_image,id_entry_link,id_workflow_state,id_entry_filter_1,value_filter_1,id_entry_filter_2,value_filter_2 "
59 + "FROM directory_rss_cf";
60
61
62
63
64 @Override
65 public synchronized void insert( DirectoryResourceRssConfig config, Plugin plugin )
66 {
67 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin );
68
69 int nPos = 0;
70
71 daoUtil.setInt( ++nPos, config.getIdRss( ) );
72 daoUtil.setInt( ++nPos, config.getIdDirectory( ) );
73 daoUtil.setInt( ++nPos, config.getIdEntryTitle( ) );
74 daoUtil.setInt( ++nPos, config.getIdEntryDescription( ) );
75 daoUtil.setInt( ++nPos, config.getIdEntryImage( ) );
76 daoUtil.setInt( ++nPos, config.getIdEntryLink( ) );
77 daoUtil.setInt( ++nPos, config.getIdEntryFilter1( ) );
78 daoUtil.setString( ++nPos, config.getValueFilter1( ) );
79 daoUtil.setInt( ++nPos, config.getIdEntryFilter2( ) );
80 daoUtil.setString( ++nPos, config.getValueFilter2( ) );
81 daoUtil.setInt( ++nPos, config.getIdWorkflowState( ) );
82
83 daoUtil.executeUpdate( );
84 daoUtil.free( );
85 }
86
87
88
89
90 @Override
91 public void store( DirectoryResourceRssConfig config, Plugin plugin )
92 {
93 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, plugin );
94
95 int nPos = 0;
96
97 daoUtil.setInt( ++nPos, config.getIdRss( ) );
98 daoUtil.setInt( ++nPos, config.getIdDirectory( ) );
99 daoUtil.setInt( ++nPos, config.getIdEntryTitle( ) );
100 daoUtil.setInt( ++nPos, config.getIdEntryDescription( ) );
101 daoUtil.setInt( ++nPos, config.getIdEntryImage( ) );
102 daoUtil.setInt( ++nPos, config.getIdEntryLink( ) );
103 daoUtil.setInt( ++nPos, config.getIdEntryFilter1( ) );
104 daoUtil.setString( ++nPos, config.getValueFilter1( ) );
105 daoUtil.setInt( ++nPos, config.getIdEntryFilter2( ) );
106 daoUtil.setString( ++nPos, config.getValueFilter2( ) );
107 daoUtil.setInt( ++nPos, config.getIdWorkflowState( ) );
108
109 daoUtil.setInt( ++nPos, config.getIdRss( ) );
110 daoUtil.executeUpdate( );
111 daoUtil.free( );
112 }
113
114
115
116
117 @Override
118 public DirectoryResourceRssConfig load( int nIdRss, Plugin plugin )
119 {
120 DirectoryResourceRssConfig config = null;
121 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, plugin );
122
123 daoUtil.setInt( 1, nIdRss );
124
125 daoUtil.executeQuery( );
126
127 int nPos = 0;
128
129 if ( daoUtil.next( ) )
130 {
131 config = new DirectoryResourceRssConfig( );
132 config.setIdRss( daoUtil.getInt( ++nPos ) );
133 config.setIdDirectory( daoUtil.getInt( ++nPos ) );
134 config.setIdEntryTitle( daoUtil.getInt( ++nPos ) );
135 config.setIdEntryDescription( daoUtil.getInt( ++nPos ) );
136 config.setIdEntryImage( daoUtil.getInt( ++nPos ) );
137 config.setIdEntryLink( daoUtil.getInt( ++nPos ) );
138 config.setIdEntryFilter1( daoUtil.getInt( ++nPos ) );
139 config.setValueFilter1( daoUtil.getString( ++nPos ) );
140 config.setIdEntryFilter2( daoUtil.getInt( ++nPos ) );
141 config.setValueFilter2( daoUtil.getString( ++nPos ) );
142 config.setIdWorkflowState( daoUtil.getInt( ++nPos ) );
143 }
144
145 daoUtil.free( );
146
147 return config;
148 }
149
150
151
152
153 @Override
154 public void delete( int nIdRss, Plugin plugin )
155 {
156 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin );
157
158 daoUtil.setInt( 1, nIdRss );
159 daoUtil.executeUpdate( );
160 daoUtil.free( );
161 }
162
163
164
165
166 @Override
167 public List<DirectoryResourceRssConfig> loadAll( Plugin plugin )
168 {
169 List<DirectoryResourceRssConfig> configList = new ArrayList<DirectoryResourceRssConfig>( );
170 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_ALL, plugin );
171
172 daoUtil.executeQuery( );
173
174 int nPos = 0;
175
176 if ( daoUtil.next( ) )
177 {
178 DirectoryResourceRssConfig config = new DirectoryResourceRssConfig( );
179 config.setIdRss( daoUtil.getInt( ++nPos ) );
180 config.setIdDirectory( daoUtil.getInt( ++nPos ) );
181 config.setIdEntryTitle( daoUtil.getInt( ++nPos ) );
182 config.setIdEntryDescription( daoUtil.getInt( ++nPos ) );
183 config.setIdEntryImage( daoUtil.getInt( ++nPos ) );
184 config.setIdEntryLink( daoUtil.getInt( ++nPos ) );
185 config.setIdEntryFilter1( daoUtil.getInt( ++nPos ) );
186 config.setValueFilter1( daoUtil.getString( ++nPos ) );
187 config.setIdEntryFilter2( daoUtil.getInt( ++nPos ) );
188 config.setValueFilter2( daoUtil.getString( ++nPos ) );
189 config.setIdWorkflowState( daoUtil.getInt( ++nPos ) );
190
191 configList.add( config );
192 }
193
194 daoUtil.free( );
195
196 return configList;
197 }
198 }