2 * Copyright (C) 2001, 2002 The Mir-coders group
4 * This file is part of Mir.
6 * Mir is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 2 of the License, or
9 * (at your option) any later version.
11 * Mir is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License
17 * along with Mir; if not, write to the Free Software
18 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
20 * In addition, as a special exception, The Mir-coders gives permission to link
21 * the code of this program with any library licensed under the Apache Software License,
22 * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library
23 * (or with modified versions of the above that use the same license as the above),
24 * and distribute linked combinations including the two. You must obey the
25 * GNU General Public License in all respects for all of the code used other than
26 * the above mentioned libraries. If you modify this file, you may extend this
27 * exception to your version of the file, but you are not obligated to do so.
28 * If you do not wish to do so, delete this exception statement from your version.
30 package mircoders.localizer.basic;
32 import java.util.HashMap;
33 import java.util.Iterator;
34 import java.util.List;
36 import java.util.Vector;
38 import mir.config.MirPropertiesConfiguration;
39 import mir.entity.Entity;
40 import mir.entity.adapter.EntityAdapter;
41 import mir.entity.adapter.EntityAdapterDefinition;
42 import mir.entity.adapter.EntityAdapterModel;
43 import mir.log.LoggerWrapper;
44 import mir.media.MediaHelper;
45 import mir.media.MirMedia;
46 import mir.util.ParameterExpander;
48 import mircoders.entity.EntityUploadedMedia;
49 import mircoders.global.MirGlobal;
50 import mircoders.localizer.MirAdminInterfaceLocalizer;
51 import mircoders.localizer.MirDataModelLocalizer;
52 import mircoders.localizer.MirLocalizerExc;
53 import mircoders.localizer.MirLocalizerFailure;
54 import mircoders.storage.DatabaseArticleType;
55 import mircoders.storage.DatabaseAudio;
56 import mircoders.storage.DatabaseBreaking;
57 import mircoders.storage.*;
58 import mircoders.storage.DatabaseCommentStatus;
59 import mircoders.storage.DatabaseContent;
60 import mircoders.storage.DatabaseImageType;
61 import mircoders.storage.DatabaseImages;
62 import mircoders.storage.DatabaseLanguage;
63 import mircoders.storage.DatabaseMedia;
64 import mircoders.storage.DatabaseMediaType;
65 import mircoders.storage.DatabaseMediafolder;
66 import mircoders.storage.DatabaseMessages;
67 import mircoders.storage.DatabaseOther;
68 import mircoders.storage.DatabaseTopics;
69 import mircoders.storage.DatabaseUploadedMedia;
70 import mircoders.storage.DatabaseUsers;
71 import mircoders.storage.DatabaseVideo;
73 public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {
74 protected LoggerWrapper logger;
75 protected MirPropertiesConfiguration configuration;
77 public MirBasicDataModelLocalizer() throws MirLocalizerFailure, MirLocalizerExc {
78 logger = new LoggerWrapper("Localizer.DataModel");
81 configuration = MirPropertiesConfiguration.instance();
84 throw new MirLocalizerFailure("Can't get configuration: " + e.getMessage(), e);
88 protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure, MirLocalizerExc {
90 anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");
91 anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange");
92 anEntityAdapterDefinition.addMirDateField("date", "date");
93 anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());
94 anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());
95 anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());
97 anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));
98 anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));
100 anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));
101 anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));
102 anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));
103 anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));
104 anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));
105 anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new ContentToMediaField( "uploadedMedia", false));
106 anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new ContentToMediaField( "image", false));
107 anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new ContentToMediaField( "audio", false));
108 anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new ContentToMediaField( "video", false));
109 anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new ContentToMediaField( "otherMedia", false));
110 anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());
112 anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());
114 anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
115 anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));
117 anEntityAdapterDefinition.addCalculatedField("children", new ContentToChildrenField());
118 anEntityAdapterDefinition.addCalculatedField("parent", new ContentToParentField());
120 anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Article.PublicUrl")));
122 anEntityAdapterDefinition.addCalculatedField("operations",
123 new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));
125 catch (Throwable t) {
126 throw new MirLocalizerFailure(t.getMessage(), t);
130 protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {
132 anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");
133 anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());
134 anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());
136 anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new CommentToMediaField( "uploadedMedia" ));
137 anEntityAdapterDefinition.addCalculatedField("to_media_images", new CommentToMediaField( "image" ));
138 anEntityAdapterDefinition.addCalculatedField("to_media_audio", new CommentToMediaField( "audio" ));
139 anEntityAdapterDefinition.addCalculatedField("to_media_video", new CommentToMediaField( "video" ));
140 anEntityAdapterDefinition.addCalculatedField("to_media_other", new CommentToMediaField( "otherMedia" ));
141 anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new CommentToMediaField( "uploadedMedia", false));
142 anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new CommentToMediaField( "image", false));
143 anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new CommentToMediaField( "audio", false));
144 anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new CommentToMediaField( "video", false));
145 anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new CommentToMediaField( "otherMedia", false));
147 anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Comment.PublicUrl")));
149 anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
150 anEntityAdapterDefinition.addCalculatedField("operations",
151 new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));
153 catch (Throwable t) {
154 throw new MirLocalizerFailure(t.getMessage(), t);
158 public EntityAdapterModel adapterModel() throws MirLocalizerFailure, MirLocalizerExc {
159 EntityAdapterModel result = new EntityAdapterModel();
162 EntityAdapterDefinition definition;
164 definition = new EntityAdapterDefinition();
165 constructContentAdapterDefinition( definition );
166 result.addMapping( "content", DatabaseContent.getInstance(), definition);
168 definition = new EntityAdapterDefinition();
169 constructCommentAdapterDefinition( definition );
170 result.addMapping( "comment", DatabaseComment.getInstance(), definition);
172 result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());
173 result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());
175 definition = new EntityAdapterDefinition();
176 definition.addDBDateField("creationdate", "webdb_create");
177 result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);
179 result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());
180 result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());
181 result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());
182 result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());
183 result.addMapping( "internalMessage", DatabaseMessages.getInstance(), new EntityAdapterDefinition());
184 result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());
185 result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());
186 result.addMapping( "media", DatabaseMedia.getInstance(), new EntityAdapterDefinition());
187 result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), new EntityAdapterDefinition());
188 result.addMapping( "image", DatabaseImages.getInstance(), new EntityAdapterDefinition());
189 result.addMapping( "audio", DatabaseAudio.getInstance(), new EntityAdapterDefinition());
190 result.addMapping( "video", DatabaseVideo.getInstance(), new EntityAdapterDefinition());
191 result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());
193 result.addMapping( "content_x_topic", DatabaseContentToTopics.getInstance(), new EntityAdapterDefinition());
196 catch (Throwable t) {
197 throw new MirLocalizerFailure(t.getMessage(), t);
203 protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {
204 public Object getValue(EntityAdapter anEntityAdapter) {
206 return anEntityAdapter.getToOneRelation(
207 "id="+anEntityAdapter.get("to_media"),
211 catch (Throwable t) {
212 throw new RuntimeException(t.getMessage());
217 protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {
218 public Object getValue(EntityAdapter anEntityAdapter) {
220 return anEntityAdapter.getToOneRelation(
221 "id="+anEntityAdapter.get("to_comment_status"),
225 catch (Throwable t) {
226 throw new RuntimeException(t.getMessage());
231 protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {
232 private List operations;
234 public EntityToSimpleOperationsField(List anOperations) {
235 operations = anOperations;
238 public Object getValue(EntityAdapter anEntityAdapter) {
240 Iterator i = operations.iterator();
241 List availableOperations = new Vector();
243 while (i.hasNext()) {
244 MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =
245 (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();
247 if (operation.isAvailable(anEntityAdapter)) {
248 availableOperations.add(operation.getName());
252 return availableOperations;
254 catch (Throwable t) {
255 throw new RuntimeException(t.getMessage());
260 protected class FilteredField implements EntityAdapterDefinition.CalculatedField {
261 private String fieldName;
263 public FilteredField(String aFieldName) {
264 fieldName = aFieldName;
267 public Object getValue(EntityAdapter anEntityAdapter) {
269 if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {
270 return MirGlobal.localizer().producerAssistant().filterHTMLText((String) anEntityAdapter.get(fieldName));
273 return MirGlobal.localizer().producerAssistant().filterNonHTMLText((String) anEntityAdapter.get(fieldName));
276 catch (Throwable t) {
277 throw new RuntimeException(t.getMessage());
282 protected class StructuredContentField implements EntityAdapterDefinition.CalculatedField {
283 private String expression;
285 public StructuredContentField(String anExpression) {
286 expression = anExpression;
289 public Object getValue(EntityAdapter anEntityAdapter) {
291 return StructuredContentParser.parse(ParameterExpander.evaluateStringExpression(anEntityAdapter, expression));
293 catch (Throwable t) {
294 throw new RuntimeException(t.getMessage());
299 protected class ExpandedField implements EntityAdapterDefinition.CalculatedField {
300 private String expression;
302 public ExpandedField(String anExpression) {
303 expression = anExpression;
306 public Object getValue(EntityAdapter anEntityAdapter) {
308 return ParameterExpander.expandExpression(anEntityAdapter, expression);
310 catch (Throwable t) {
311 throw new RuntimeException(t.getMessage());
316 protected class EvaluatedField implements EntityAdapterDefinition.CalculatedField {
317 private String expression;
319 public EvaluatedField(String anExpression) {
320 expression = anExpression;
323 public Object getValue(EntityAdapter anEntityAdapter) {
325 return ParameterExpander.evaluateExpression(anEntityAdapter, expression);
327 catch (Throwable t) {
328 throw new RuntimeException(t.getMessage());
333 protected class ContentToParentField implements EntityAdapterDefinition.CalculatedField {
334 public Object getValue(EntityAdapter anEntityAdapter) {
336 logger.debug("ContentToParentField.getValue");
337 return anEntityAdapter.getToOneRelation(
338 "id="+anEntityAdapter.get("to_content"),
342 catch (Throwable t) {
343 throw new RuntimeException(t.getMessage());
348 protected class ContentToChildrenField implements EntityAdapterDefinition.CalculatedField {
349 public Object getValue(EntityAdapter anEntityAdapter) {
351 return anEntityAdapter.getRelation(
352 "to_content="+anEntityAdapter.get("id"),
356 catch (Throwable t) {
357 throw new RuntimeException(t.getMessage());
362 protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {
363 public Object getValue(EntityAdapter anEntityAdapter) {
365 return anEntityAdapter.getToOneRelation(
366 "id="+anEntityAdapter.get("to_language"),
370 catch (Throwable t) {
371 throw new RuntimeException(t.getMessage());
376 protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {
377 public Object getValue(EntityAdapter anEntityAdapter) {
379 return anEntityAdapter.getToOneRelation(
380 "id="+anEntityAdapter.get("to_article_type"),
384 catch (Throwable t) {
385 throw new RuntimeException(t.getMessage());
390 protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {
391 private String extracondition;
392 private String order;
394 public ContentToCommentsField() {
395 this ( " and is_published='1'", "webdb_create");
398 public ContentToCommentsField(String anExtraCondition, String anOrder) {
400 extracondition = anExtraCondition;
403 public Object getValue(EntityAdapter anEntityAdapter) {
405 return anEntityAdapter.getRelation(
406 "to_media="+anEntityAdapter.get("id")+" " + extracondition,
410 catch (Throwable t) {
411 throw new RuntimeException(t.getMessage());
416 protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {
417 private String topicCondition;
419 public ContentToTopicsField() {
423 public ContentToTopicsField(String aTopicCondition) {
424 topicCondition = aTopicCondition;
427 public Object getValue(EntityAdapter anEntityAdapter) {
429 String condition = "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)";
430 if (topicCondition!=null && topicCondition.length()>0)
431 condition = "(" + topicCondition + ") and " + condition;
433 return anEntityAdapter.getRelation(
438 catch (Throwable t) {
439 throw new RuntimeException(t.getMessage());
444 protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {
445 private String definition;
446 private boolean published;
448 public ContentToMediaField(String aDefinition, boolean anOnlyPublished) {
449 definition = aDefinition;
450 published = anOnlyPublished;
453 public ContentToMediaField(String aDefinition) {
454 this(aDefinition, true);
457 public Object getValue(EntityAdapter anEntityAdapter) {
459 String condition = "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)";
461 condition = "is_published='t' and " + condition;
462 return anEntityAdapter.getRelation(
467 catch (Throwable t) {
468 throw new RuntimeException(t.getMessage());
473 protected class CommentToMediaField implements EntityAdapterDefinition.CalculatedField {
474 private String definition;
475 private boolean published;
477 public CommentToMediaField(String aDefinition, boolean anOnlyPublished) {
478 definition = aDefinition;
479 published = anOnlyPublished;
482 public CommentToMediaField(String aDefinition) {
483 this(aDefinition, true);
486 public Object getValue(EntityAdapter anEntityAdapter) {
488 String condition = "exists (select * from comment_x_media where comment_id="+anEntityAdapter.get("id")+" and media_id=id)";
490 condition = "is_published='t' and " + condition;
491 return anEntityAdapter.getRelation(
496 catch (Throwable t) {
497 throw new RuntimeException(t.getMessage());
502 protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {
503 public Object getValue(EntityAdapter anEntityAdapter) {
506 RewindableIterator iterator;
508 MirMedia mediaHandler;
513 iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));
516 tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyText");
519 if (iterator.hasNext()) {
520 media = (EntityAdapter) iterator.next();
522 mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();
523 mediaHandler = MediaHelper.getHandler( mediaType );
525 if (mediaHandler.isVideo()) {
526 tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyVideo");
529 else if (mediaHandler.isAudio()) {
530 tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyAudio");
533 else if (mediaHandler.isImage()) {
534 tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyImage");
538 tinyIcon = mediaHandler.getTinyIconName();
539 iconAlt = mediaHandler.getIconAltName();
544 catch (Throwable t) {
545 logger.error("ContentToIconField: " +t.getMessage());
546 throw new RuntimeException(t.getMessage());
549 result = new HashMap();
550 result.put("tiny_icon", MirGlobal.config().getString("Producer.ImageRoot") + "/" + tinyIcon);
551 result.put("icon_alt", iconAlt);
557 protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {
558 private String extraCondition;
560 public ContentCommentCountField(String anExtraCondition) {
563 extraCondition = anExtraCondition;
566 public Object getValue(EntityAdapter anEntityAdapter) {
568 return Integer.toString(
569 DatabaseComment.getInstance().getSize(
570 "to_media="+anEntityAdapter.get("id")+" " + extraCondition));
572 catch (Throwable t) {
573 throw new RuntimeException(t.getMessage());