2 * Copyright (C) 2001, 2002 The Mir-coders group
\r
4 * This file is part of Mir.
\r
6 * Mir is free software; you can redistribute it and/or modify
\r
7 * it under the terms of the GNU General Public License as published by
\r
8 * the Free Software Foundation; either version 2 of the License, or
\r
9 * (at your option) any later version.
\r
11 * Mir is distributed in the hope that it will be useful,
\r
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
\r
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
\r
14 * GNU General Public License for more details.
\r
16 * You should have received a copy of the GNU General Public License
\r
17 * along with Mir; if not, write to the Free Software
\r
18 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
\r
20 * In addition, as a special exception, The Mir-coders gives permission to link
\r
21 * the code of this program with the com.oreilly.servlet library, any library
\r
22 * licensed under the Apache Software License, The Sun (tm) Java Advanced
\r
23 * Imaging library (JAI), The Sun JIMI library (or with modified versions of
\r
24 * the above that use the same license as the above), and distribute linked
\r
25 * combinations including the two. You must obey the GNU General Public
\r
26 * License in all respects for all of the code used other than the above
\r
27 * mentioned libraries. If you modify this file, you may extend this exception
\r
28 * to your version of the file, but you are not obligated to do so. If you do
\r
29 * not wish to do so, delete this exception statement from your version.
\r
32 package mircoders.localizer.basic;
\r
34 import java.util.HashMap;
\r
35 import java.util.Iterator;
\r
36 import java.util.List;
\r
37 import java.util.Map;
\r
38 import java.util.Vector;
\r
40 import mir.entity.Entity;
\r
41 import mir.entity.adapter.EntityAdapter;
\r
42 import mir.entity.adapter.EntityAdapterDefinition;
\r
43 import mir.entity.adapter.EntityAdapterModel;
\r
44 import mir.log.LoggerWrapper;
\r
45 import mir.media.MediaHelper;
\r
46 import mir.media.MirMedia;
\r
47 import mir.util.RewindableIterator;
\r
48 import mircoders.entity.EntityUploadedMedia;
\r
49 import mircoders.global.MirGlobal;
\r
50 import mircoders.localizer.MirAdminInterfaceLocalizer;
\r
51 import mircoders.localizer.MirDataModelLocalizer;
\r
52 import mircoders.localizer.MirLocalizerFailure;
\r
53 import mircoders.storage.DatabaseArticleType;
\r
54 import mircoders.storage.DatabaseAudio;
\r
55 import mircoders.storage.DatabaseBreaking;
\r
56 import mircoders.storage.DatabaseComment;
\r
57 import mircoders.storage.DatabaseCommentStatus;
\r
58 import mircoders.storage.DatabaseContent;
\r
59 import mircoders.storage.DatabaseFeature;
\r
60 import mircoders.storage.DatabaseImageType;
\r
61 import mircoders.storage.DatabaseImages;
\r
62 import mircoders.storage.DatabaseLanguage;
\r
63 import mircoders.storage.DatabaseMedia;
\r
64 import mircoders.storage.DatabaseMediaType;
\r
65 import mircoders.storage.DatabaseMediafolder;
\r
66 import mircoders.storage.DatabaseMessages;
\r
67 import mircoders.storage.DatabaseOther;
\r
68 import mircoders.storage.DatabaseTopics;
\r
69 import mircoders.storage.DatabaseUploadedMedia;
\r
70 import mircoders.storage.DatabaseUsers;
\r
71 import mircoders.storage.DatabaseVideo;
\r
73 public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {
\r
74 private EntityAdapterModel model;
\r
75 protected LoggerWrapper logger;
\r
77 public MirBasicDataModelLocalizer() {
\r
79 logger = new LoggerWrapper("Localizer.DataModel");
\r
82 public EntityAdapterModel adapterModel() throws MirLocalizerFailure {
\r
84 model = buildModel();
\r
89 protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {
\r
91 anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");
\r
92 anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange");
\r
93 anEntityAdapterDefinition.addMirDateField("date", "date");
\r
94 anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());
\r
95 anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());
\r
96 anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());
\r
98 anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));
\r
99 anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));
\r
101 anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));
\r
102 anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));
\r
103 anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));
\r
104 anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));
\r
105 anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));
\r
106 anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());
\r
108 anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());
\r
110 anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
\r
111 anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));
\r
113 anEntityAdapterDefinition.addCalculatedField("children", new ContentToChildrenField());
\r
114 anEntityAdapterDefinition.addCalculatedField("parent", new ContentToParentField());
\r
116 anEntityAdapterDefinition.addCalculatedField("operations",
\r
117 new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));
\r
119 catch (Throwable t) {
\r
120 throw new MirLocalizerFailure(t.getMessage(), t);
\r
124 protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {
\r
126 anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");
\r
127 anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());
\r
128 anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());
\r
130 anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
\r
131 anEntityAdapterDefinition.addCalculatedField("operations",
\r
132 new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));
\r
134 catch (Throwable t) {
\r
135 throw new MirLocalizerFailure(t.getMessage(), t);
\r
139 protected EntityAdapterModel buildModel() throws MirLocalizerFailure {
\r
140 EntityAdapterModel result = new EntityAdapterModel();
\r
143 EntityAdapterDefinition definition;
\r
145 definition = new EntityAdapterDefinition();
\r
146 constructContentAdapterDefinition( definition );
\r
147 result.addMapping( "content", DatabaseContent.getInstance(), definition);
\r
149 definition = new EntityAdapterDefinition();
\r
150 constructCommentAdapterDefinition( definition );
\r
151 result.addMapping( "comment", DatabaseComment.getInstance(), definition);
\r
153 result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());
\r
154 result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());
\r
156 definition = new EntityAdapterDefinition();
\r
157 definition.addDBDateField("creationdate", "webdb_create");
\r
158 result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);
\r
160 result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());
\r
161 result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());
\r
162 result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());
\r
163 result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());
\r
164 result.addMapping( "internalMessage", DatabaseMessages.getInstance(), new EntityAdapterDefinition());
\r
165 result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());
\r
166 result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());
\r
167 result.addMapping( "media", DatabaseMedia.getInstance(), new EntityAdapterDefinition());
\r
168 result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), new EntityAdapterDefinition());
\r
169 result.addMapping( "image", DatabaseImages.getInstance(), new EntityAdapterDefinition());
\r
170 result.addMapping( "audio", DatabaseAudio.getInstance(), new EntityAdapterDefinition());
\r
171 result.addMapping( "video", DatabaseVideo.getInstance(), new EntityAdapterDefinition());
\r
172 result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());
\r
174 catch (Throwable t) {
\r
175 throw new MirLocalizerFailure(t.getMessage(), t);
\r
181 protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {
\r
182 public Object getValue(EntityAdapter anEntityAdapter) {
\r
184 return anEntityAdapter.getToOneRelation(
\r
185 "id="+anEntityAdapter.get("to_media"),
\r
189 catch (Throwable t) {
\r
190 throw new RuntimeException(t.getMessage());
\r
195 protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {
\r
196 public Object getValue(EntityAdapter anEntityAdapter) {
\r
198 return anEntityAdapter.getToOneRelation(
\r
199 "id="+anEntityAdapter.get("to_comment_status"),
\r
203 catch (Throwable t) {
\r
204 throw new RuntimeException(t.getMessage());
\r
209 protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {
\r
210 private List operations;
\r
212 public EntityToSimpleOperationsField(List anOperations) {
\r
213 operations = anOperations;
\r
216 public Object getValue(EntityAdapter anEntityAdapter) {
\r
218 Iterator i = operations.iterator();
\r
219 List availableOperations = new Vector();
\r
221 while (i.hasNext()) {
\r
222 MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =
\r
223 (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();
\r
225 if (operation.isAvailable(anEntityAdapter)) {
\r
226 availableOperations.add(operation.getName());
\r
230 return availableOperations;
\r
232 catch (Throwable t) {
\r
233 throw new RuntimeException(t.getMessage());
\r
238 protected class FilteredField implements EntityAdapterDefinition.CalculatedField {
\r
241 public FilteredField(String aFieldName) {
\r
242 fieldName = aFieldName;
\r
245 public Object getValue(EntityAdapter anEntityAdapter) {
\r
247 if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {
\r
248 return anEntityAdapter.get(fieldName);
\r
251 return MirGlobal.localizer().producerAssistant().filterText((String) anEntityAdapter.get(fieldName));
\r
254 catch (Throwable t) {
\r
255 throw new RuntimeException(t.getMessage());
\r
260 protected class ContentToParentField implements EntityAdapterDefinition.CalculatedField {
\r
261 public Object getValue(EntityAdapter anEntityAdapter) {
\r
263 logger.debug("ContentToParentField.getValue");
\r
264 return anEntityAdapter.getToOneRelation(
\r
265 "id="+anEntityAdapter.get("to_content"),
\r
269 catch (Throwable t) {
\r
270 throw new RuntimeException(t.getMessage());
\r
275 protected class ContentToChildrenField implements EntityAdapterDefinition.CalculatedField {
\r
276 public Object getValue(EntityAdapter anEntityAdapter) {
\r
278 return anEntityAdapter.getRelation(
\r
279 "to_content="+anEntityAdapter.get("id"),
\r
283 catch (Throwable t) {
\r
284 throw new RuntimeException(t.getMessage());
\r
289 protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {
\r
290 public Object getValue(EntityAdapter anEntityAdapter) {
\r
292 return anEntityAdapter.getToOneRelation(
\r
293 "id="+anEntityAdapter.get("to_language"),
\r
297 catch (Throwable t) {
\r
298 throw new RuntimeException(t.getMessage());
\r
303 protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {
\r
304 public Object getValue(EntityAdapter anEntityAdapter) {
\r
306 return anEntityAdapter.getToOneRelation(
\r
307 "id="+anEntityAdapter.get("to_article_type"),
\r
311 catch (Throwable t) {
\r
312 throw new RuntimeException(t.getMessage());
\r
317 protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {
\r
318 public Object getValue(EntityAdapter anEntityAdapter) {
\r
320 return anEntityAdapter.getRelation(
\r
321 "to_media="+anEntityAdapter.get("id")+" and is_published='1'",
\r
325 catch (Throwable t) {
\r
326 throw new RuntimeException(t.getMessage());
\r
331 protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {
\r
332 public Object getValue(EntityAdapter anEntityAdapter) {
\r
334 return anEntityAdapter.getRelation(
\r
335 "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)",
\r
339 catch (Throwable t) {
\r
340 throw new RuntimeException(t.getMessage());
\r
345 protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {
\r
348 public ContentToMediaField(String aDefinition) {
\r
349 definition = aDefinition;
\r
352 public Object getValue(EntityAdapter anEntityAdapter) {
\r
354 return anEntityAdapter.getRelation(
\r
355 "is_published='t' and exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)",
\r
359 catch (Throwable t) {
\r
360 throw new RuntimeException(t.getMessage());
\r
365 protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {
\r
366 public Object getValue(EntityAdapter anEntityAdapter) {
\r
367 EntityAdapter media;
\r
369 RewindableIterator iterator;
\r
371 MirMedia mediaHandler;
\r
376 iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));
\r
379 tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyText");
\r
382 if (iterator.hasNext()) {
\r
383 media = (EntityAdapter) iterator.next();
\r
385 mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();
\r
386 mediaHandler = MediaHelper.getHandler( mediaType );
\r
388 if (mediaHandler.isVideo()) {
\r
389 tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyVideo");
\r
392 else if (mediaHandler.isAudio()) {
\r
393 tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyAudio");
\r
396 else if (mediaHandler.isImage()) {
\r
397 tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyImage");
\r
401 tinyIcon = mediaHandler.getTinyIconName();
\r
402 iconAlt = mediaHandler.getIconAltName();
\r
407 catch (Throwable t) {
\r
408 logger.error("ContentToIconField: " +t.getMessage());
\r
409 throw new RuntimeException(t.getMessage());
\r
412 result = new HashMap();
\r
413 result.put("tiny_icon", MirGlobal.getConfigProperty("Producer.ImageRoot") + "/" + tinyIcon);
\r
414 result.put("icon_alt", iconAlt);
\r
420 protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {
\r
421 private String extraCondition;
\r
423 public ContentCommentCountField(String anExtraCondition) {
\r
426 extraCondition = anExtraCondition;
\r
429 public Object getValue(EntityAdapter anEntityAdapter) {
\r
431 return Integer.toString(
\r
432 DatabaseComment.getInstance().getSize(
\r
433 "to_media="+anEntityAdapter.get("id")+" " + extraCondition));
\r
435 catch (Throwable t) {
\r
436 throw new RuntimeException(t.getMessage());
\r