-/*\r
- * Copyright (C) 2001, 2002 The Mir-coders group\r
- *\r
- * This file is part of Mir.\r
- *\r
- * Mir is free software; you can redistribute it and/or modify\r
- * it under the terms of the GNU General Public License as published by\r
- * the Free Software Foundation; either version 2 of the License, or\r
- * (at your option) any later version.\r
- *\r
- * Mir is distributed in the hope that it will be useful,\r
- * but WITHOUT ANY WARRANTY; without even the implied warranty of\r
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\r
- * GNU General Public License for more details.\r
- *\r
- * You should have received a copy of the GNU General Public License\r
- * along with Mir; if not, write to the Free Software\r
- * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA\r
- *\r
- * In addition, as a special exception, The Mir-coders gives permission to link\r
- * the code of this program with the com.oreilly.servlet library, any library\r
- * licensed under the Apache Software License, The Sun (tm) Java Advanced\r
- * Imaging library (JAI), The Sun JIMI library (or with modified versions of\r
- * the above that use the same license as the above), and distribute linked\r
- * combinations including the two. You must obey the GNU General Public\r
- * License in all respects for all of the code used other than the above\r
- * mentioned libraries. If you modify this file, you may extend this exception\r
- * to your version of the file, but you are not obligated to do so. If you do\r
- * not wish to do so, delete this exception statement from your version.\r
- */\r
-\r
-package mircoders.localizer.basic;\r
-\r
-import java.util.HashMap;\r
-import java.util.Iterator;\r
-import java.util.List;\r
-import java.util.Map;\r
-import java.util.Vector;\r
-\r
-import mir.entity.Entity;\r
-import mir.entity.adapter.EntityAdapter;\r
-import mir.entity.adapter.EntityAdapterDefinition;\r
-import mir.entity.adapter.EntityAdapterModel;\r
-import mir.media.MediaHelper;\r
-import mir.media.MirMedia;\r
-import mir.util.RewindableIterator;\r
-import mir.log.LoggerWrapper;\r
-import mircoders.entity.EntityUploadedMedia;\r
-import mircoders.global.MirGlobal;\r
-import mircoders.localizer.MirAdminInterfaceLocalizer;\r
-import mircoders.localizer.MirDataModelLocalizer;\r
-import mircoders.localizer.MirLocalizerFailure;\r
-import mircoders.storage.DatabaseArticleType;\r
-import mircoders.storage.DatabaseAudio;\r
-import mircoders.storage.DatabaseBreaking;\r
-import mircoders.storage.DatabaseComment;\r
-import mircoders.storage.DatabaseCommentStatus;\r
-import mircoders.storage.DatabaseContent;\r
-import mircoders.storage.DatabaseFeature;\r
-import mircoders.storage.DatabaseImageType;\r
-import mircoders.storage.DatabaseImages;\r
-import mircoders.storage.DatabaseLanguage;\r
-import mircoders.storage.DatabaseMedia;\r
-import mircoders.storage.DatabaseMediaType;\r
-import mircoders.storage.DatabaseMediafolder;\r
-import mircoders.storage.DatabaseMessages;\r
-import mircoders.storage.DatabaseOther;\r
-import mircoders.storage.DatabaseTopics;\r
-import mircoders.storage.DatabaseUploadedMedia;\r
-import mircoders.storage.DatabaseUsers;\r
-import mircoders.storage.DatabaseVideo;\r
-\r
-public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {\r
- private EntityAdapterModel model;\r
- protected LoggerWrapper logger;\r
-\r
- public MirBasicDataModelLocalizer() {\r
- model=null;\r
- logger = new LoggerWrapper("Localizer.DataModel");\r
- }\r
-\r
- public EntityAdapterModel adapterModel() throws MirLocalizerFailure {\r
- if (model==null)\r
- model = buildModel();\r
-\r
- return model;\r
- };\r
-\r
- protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
- try {\r
- anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");\r
- anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange");\r
- anEntityAdapterDefinition.addMirDateField("date", "date");\r
- anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());\r
- anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());\r
- anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());\r
-\r
- anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));\r
- anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));\r
-\r
- anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));\r
- anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));\r
- anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));\r
- anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));\r
- anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));\r
- anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());\r
-\r
- anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());\r
-\r
- anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));\r
- anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));\r
-\r
- anEntityAdapterDefinition.addCalculatedField("children", new ContentToChildrenField());\r
- anEntityAdapterDefinition.addCalculatedField("parent", new ContentToParentField());\r
-\r
- anEntityAdapterDefinition.addCalculatedField("operations",\r
- new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));\r
- }\r
- catch (Throwable t) {\r
- throw new MirLocalizerFailure(t.getMessage(), t);\r
- }\r
- }\r
-\r
- protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
- try {\r
- anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");\r
- anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());\r
- anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());\r
-\r
- anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));\r
- anEntityAdapterDefinition.addCalculatedField("operations",\r
- new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));\r
- }\r
- catch (Throwable t) {\r
- throw new MirLocalizerFailure(t.getMessage(), t);\r
- }\r
- }\r
-\r
- protected EntityAdapterModel buildModel() throws MirLocalizerFailure {\r
- EntityAdapterModel result = new EntityAdapterModel();\r
-\r
- try {\r
- EntityAdapterDefinition definition;\r
-\r
- definition = new EntityAdapterDefinition();\r
- constructContentAdapterDefinition( definition );\r
- result.addMapping( "content", DatabaseContent.getInstance(), definition);\r
-\r
- definition = new EntityAdapterDefinition();\r
- constructCommentAdapterDefinition( definition );\r
- result.addMapping( "comment", DatabaseComment.getInstance(), definition);\r
-\r
- result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());\r
-\r
- definition = new EntityAdapterDefinition();\r
- definition.addDBDateField("creationdate", "webdb_create");\r
- result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);\r
-\r
- result.addMapping( "feature", DatabaseFeature.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "internalMessage", DatabaseMessages.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "media", DatabaseMedia.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "image", DatabaseImages.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "audio", DatabaseAudio.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "video", DatabaseVideo.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());\r
- }\r
- catch (Throwable t) {\r
- throw new MirLocalizerFailure(t.getMessage(), t);\r
- }\r
-\r
- return result;\r
- }\r
-\r
- protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getToOneRelation(\r
- "id="+anEntityAdapter.get("to_media"),\r
- "id",\r
- "content" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getToOneRelation(\r
- "id="+anEntityAdapter.get("to_comment_status"),\r
- "id",\r
- "commentStatus" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {\r
- private List operations;\r
-\r
- public EntityToSimpleOperationsField(List anOperations) {\r
- operations = anOperations;\r
- }\r
-\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- Iterator i = operations.iterator();\r
- List availableOperations = new Vector();\r
-\r
- while (i.hasNext()) {\r
- MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =\r
- (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();\r
-\r
- if (operation.isAvailable(anEntityAdapter)) {\r
- availableOperations.add(operation.getName());\r
- }\r
- };\r
-\r
- return availableOperations;\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class FilteredField implements EntityAdapterDefinition.CalculatedField {\r
- String fieldName;\r
-\r
- public FilteredField(String aFieldName) {\r
- fieldName = aFieldName;\r
- }\r
-\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {\r
- return anEntityAdapter.get(fieldName);\r
- }\r
- else {\r
- return MirGlobal.localizer().producerAssistant().filterText((String) anEntityAdapter.get(fieldName));\r
- }\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToParentField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- logger.debug("ContentToParentField.getValue");\r
- return anEntityAdapter.getToOneRelation(\r
- "id="+anEntityAdapter.get("to_content"),\r
- "id",\r
- "content" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToChildrenField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getRelation(\r
- "to_content="+anEntityAdapter.get("id"),\r
- "id",\r
- "content" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getToOneRelation(\r
- "id="+anEntityAdapter.get("to_language"),\r
- "id",\r
- "language" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getToOneRelation(\r
- "id="+anEntityAdapter.get("to_article_type"),\r
- "id",\r
- "articleType" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getRelation(\r
- "to_media="+anEntityAdapter.get("id")+" and is_published='1'",\r
- "webdb_create",\r
- "comment" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getRelation(\r
- "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)",\r
- "title",\r
- "topic" );\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {\r
- String definition;\r
-\r
- public ContentToMediaField(String aDefinition) {\r
- definition = aDefinition;\r
- }\r
-\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return anEntityAdapter.getRelation(\r
- "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)",\r
- "id",\r
- definition);\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-\r
- protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- EntityAdapter media;\r
- Entity mediaType;\r
- RewindableIterator iterator;\r
- Map result;\r
- MirMedia mediaHandler;\r
- String tinyIcon;\r
- String iconAlt;\r
-\r
- try {\r
- iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));\r
- iterator.rewind();\r
-\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyText");\r
- iconAlt = "Text";\r
-\r
- if (iterator.hasNext()) {\r
- media = (EntityAdapter) iterator.next();\r
-\r
- mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();\r
- mediaHandler = MediaHelper.getHandler( mediaType );\r
-\r
- if (mediaHandler.isVideo()) {\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyVideo");\r
- iconAlt = "Video";\r
- }\r
- else if (mediaHandler.isAudio()) {\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyAudio");\r
- iconAlt = "Audio";\r
- }\r
- else if (mediaHandler.isImage()) {\r
- tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyImage");\r
- iconAlt = "Image";\r
- }\r
- else {\r
- tinyIcon = mediaHandler.getTinyIconName();\r
- iconAlt = mediaHandler.getIconAltName();\r
- }\r
-\r
- }\r
- }\r
- catch (Throwable t) {\r
- logger.error("ContentToIconField: " +t.getMessage());\r
- throw new RuntimeException(t.getMessage());\r
- }\r
-\r
- result = new HashMap();\r
- result.put("tiny_icon", MirGlobal.getConfigProperty("Producer.ImageRoot") + "/" + tinyIcon);\r
- result.put("icon_alt", iconAlt);\r
-\r
- return result;\r
- }\r
- }\r
-\r
- protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {\r
- private String extraCondition;\r
-\r
- public ContentCommentCountField(String anExtraCondition) {\r
- super();\r
-\r
- extraCondition = anExtraCondition;\r
- }\r
-\r
- public Object getValue(EntityAdapter anEntityAdapter) {\r
- try {\r
- return Integer.toString(\r
- DatabaseComment.getInstance().getSize(\r
- "to_media="+anEntityAdapter.get("id")+" " + extraCondition));\r
- }\r
- catch (Throwable t) {\r
- throw new RuntimeException(t.getMessage());\r
- }\r
- }\r
- }\r
-}\r
+/*
+ * Copyright (C) 2001, 2002 The Mir-coders group
+ *
+ * This file is part of Mir.
+ *
+ * Mir is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * Mir is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with Mir; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+ *
+ * In addition, as a special exception, The Mir-coders gives permission to link
+ * the code of this program with any library licensed under the Apache Software License,
+ * The Sun (tm) Java Advanced Imaging library (JAI), The Sun JIMI library
+ * (or with modified versions of the above that use the same license as the above),
+ * and distribute linked combinations including the two. You must obey the
+ * GNU General Public License in all respects for all of the code used other than
+ * the above mentioned libraries. If you modify this file, you may extend this
+ * exception to your version of the file, but you are not obligated to do so.
+ * If you do not wish to do so, delete this exception statement from your version.
+ */
+package mircoders.localizer.basic;
+
+import java.util.HashMap;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+import java.util.Vector;
+
+import mir.config.MirPropertiesConfiguration;
+import mir.entity.Entity;
+import mir.entity.adapter.EntityAdapter;
+import mir.entity.adapter.EntityAdapterDefinition;
+import mir.entity.adapter.EntityAdapterModel;
+import mir.log.LoggerWrapper;
+import mir.media.MediaHelper;
+import mir.media.MirMedia;
+import mir.util.ParameterExpander;
+import mir.util.RewindableIterator;
+import mir.util.StructuredContentParser;
+import mircoders.entity.EntityUploadedMedia;
+import mircoders.global.MirGlobal;
+import mircoders.localizer.MirAdminInterfaceLocalizer;
+import mircoders.localizer.MirDataModelLocalizer;
+import mircoders.localizer.MirLocalizerExc;
+import mircoders.localizer.MirLocalizerFailure;
+import mircoders.storage.DatabaseArticleType;
+import mircoders.storage.DatabaseAudio;
+import mircoders.storage.DatabaseBreaking;
+import mircoders.storage.DatabaseComment;
+import mircoders.storage.DatabaseCommentStatus;
+import mircoders.storage.DatabaseContent;
+import mircoders.storage.DatabaseContentToMedia;
+import mircoders.storage.DatabaseContentToTopics;
+import mircoders.storage.DatabaseImageType;
+import mircoders.storage.DatabaseImages;
+import mircoders.storage.DatabaseLanguage;
+import mircoders.storage.DatabaseMediaType;
+import mircoders.storage.DatabaseMediafolder;
+import mircoders.storage.DatabaseMessages;
+import mircoders.storage.DatabaseOther;
+import mircoders.storage.DatabaseTopics;
+import mircoders.storage.DatabaseUploadedMedia;
+import mircoders.storage.DatabaseUsers;
+import mircoders.storage.DatabaseVideo;
+
+public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {
+ protected LoggerWrapper logger;
+ protected MirPropertiesConfiguration configuration;
+
+ public MirBasicDataModelLocalizer() throws MirLocalizerFailure, MirLocalizerExc {
+ logger = new LoggerWrapper("Localizer.DataModel");
+
+ try {
+ configuration = MirPropertiesConfiguration.instance();
+ }
+ catch (Throwable e) {
+ throw new MirLocalizerFailure("Can't get configuration: " + e.getMessage(), e);
+ }
+ }
+
+ protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure, MirLocalizerExc {
+ try {
+ anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));
+ anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange", configuration.getString("Mir.DefaultTimezone"));
+ anEntityAdapterDefinition.addMirDateField("date", "date", configuration.getString("Mir.DefaultTimezone"));
+ anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());
+ anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());
+ anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());
+
+ anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));
+ anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));
+
+ anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));
+ anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new ContentToMediaField( "uploadedMedia", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new ContentToMediaField( "image", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new ContentToMediaField( "audio", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new ContentToMediaField( "video", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new ContentToMediaField( "otherMedia", false));
+ anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());
+
+ anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());
+
+ anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
+ anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));
+
+ anEntityAdapterDefinition.addCalculatedField("children", new ContentToChildrenField());
+ anEntityAdapterDefinition.addCalculatedField("parent", new ContentToParentField());
+
+ anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Article.PublicUrl")));
+
+ anEntityAdapterDefinition.addCalculatedField("operations",
+ new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));
+ }
+ catch (Throwable t) {
+ throw new MirLocalizerFailure(t.getMessage(), t);
+ }
+ }
+
+ protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {
+ try {
+ anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));
+ anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());
+ anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());
+
+ anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new CommentToMediaField( "uploadedMedia" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_images", new CommentToMediaField( "image" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_audio", new CommentToMediaField( "audio" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_video", new CommentToMediaField( "video" ));
+ anEntityAdapterDefinition.addCalculatedField("to_media_other", new CommentToMediaField( "otherMedia" ));
+ anEntityAdapterDefinition.addCalculatedField("to_all_uploaded_media", new CommentToMediaField( "uploadedMedia", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_images", new CommentToMediaField( "image", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_audio", new CommentToMediaField( "audio", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_video", new CommentToMediaField( "video", false));
+ anEntityAdapterDefinition.addCalculatedField("to_all_media_other", new CommentToMediaField( "otherMedia", false));
+
+ anEntityAdapterDefinition.addCalculatedField("publicurl", new ExpandedField(configuration.getString("Comment.PublicUrl")));
+
+ anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));
+ anEntityAdapterDefinition.addCalculatedField("operations",
+ new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));
+ }
+ catch (Throwable t) {
+ throw new MirLocalizerFailure(t.getMessage(), t);
+ }
+ }
+
+ public EntityAdapterModel adapterModel() throws MirLocalizerFailure, MirLocalizerExc {
+ EntityAdapterModel result = new EntityAdapterModel();
+
+ try {
+ EntityAdapterDefinition definition;
+
+ definition = new EntityAdapterDefinition();
+ constructContentAdapterDefinition( definition );
+ result.addMapping( "content", DatabaseContent.getInstance(), definition);
+
+ definition = new EntityAdapterDefinition();
+ constructCommentAdapterDefinition( definition );
+ result.addMapping( "comment", DatabaseComment.getInstance(), definition);
+
+ result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());
+
+ definition = new EntityAdapterDefinition();
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));
+ result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);
+
+ definition = new EntityAdapterDefinition();
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));
+ result.addMapping( "internalMessage", DatabaseMessages.getInstance(), definition);
+
+ definition = new EntityAdapterDefinition();
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());
+ result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), definition);
+ definition = new EntityAdapterDefinition();
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());
+ result.addMapping( "image", DatabaseImages.getInstance(), definition);
+ definition = new EntityAdapterDefinition();
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());
+ result.addMapping( "audio", DatabaseAudio.getInstance(), definition);
+ definition = new EntityAdapterDefinition();
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());
+ result.addMapping( "video", DatabaseVideo.getInstance(), definition);
+ definition = new EntityAdapterDefinition();
+ definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());
+ result.addMapping( "otherMedia", DatabaseOther.getInstance(), definition);
+
+
+ result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());
+ result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());
+
+ result.addMapping( "content_x_topic", DatabaseContentToTopics.getInstance(), new EntityAdapterDefinition());
+
+ }
+ catch (Throwable t) {
+ throw new MirLocalizerFailure(t.getMessage(), t);
+ }
+
+ return result;
+ }
+
+ protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getToOneRelation(
+ "id="+anEntityAdapter.get("to_media"),
+ "id",
+ "content" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getToOneRelation(
+ "id="+anEntityAdapter.get("to_comment_status"),
+ "id",
+ "commentStatus" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {
+ private List operations;
+
+ public EntityToSimpleOperationsField(List anOperations) {
+ operations = anOperations;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ Iterator i = operations.iterator();
+ List availableOperations = new Vector();
+
+ while (i.hasNext()) {
+ MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =
+ (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();
+
+ if (operation.isAvailable(anEntityAdapter)) {
+ availableOperations.add(operation.getName());
+ }
+ };
+
+ return availableOperations;
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class FilteredField implements EntityAdapterDefinition.CalculatedField {
+ private String fieldName;
+
+ public FilteredField(String aFieldName) {
+ fieldName = aFieldName;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {
+ return MirGlobal.localizer().producerAssistant().filterHTMLText((String) anEntityAdapter.get(fieldName));
+ }
+ else {
+ return MirGlobal.localizer().producerAssistant().filterNonHTMLText((String) anEntityAdapter.get(fieldName));
+ }
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class StructuredContentField implements EntityAdapterDefinition.CalculatedField {
+ private String expression;
+
+ public StructuredContentField(String anExpression) {
+ expression = anExpression;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return StructuredContentParser.parse(ParameterExpander.evaluateStringExpression(anEntityAdapter, expression));
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ExpandedField implements EntityAdapterDefinition.CalculatedField {
+ private String expression;
+
+ public ExpandedField(String anExpression) {
+ expression = anExpression;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return ParameterExpander.expandExpression(anEntityAdapter, expression);
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class EvaluatedField implements EntityAdapterDefinition.CalculatedField {
+ private String expression;
+
+ public EvaluatedField(String anExpression) {
+ expression = anExpression;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return ParameterExpander.evaluateExpression(anEntityAdapter, expression);
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToParentField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ logger.debug("ContentToParentField.getValue");
+ return anEntityAdapter.getToOneRelation(
+ "id="+anEntityAdapter.get("to_content"),
+ "id",
+ "content" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToChildrenField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getRelation(
+ "to_content="+anEntityAdapter.get("id"),
+ "id",
+ "content" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getToOneRelation(
+ "id="+anEntityAdapter.get("to_language"),
+ "id",
+ "language" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getToOneRelation(
+ "id="+anEntityAdapter.get("to_article_type"),
+ "id",
+ "articleType" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class MediaToMediaFolderField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getToOneRelation(
+ "id="+anEntityAdapter.get("to_media_folder"),
+ "id",
+ "mediaFolder" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {
+ private String extracondition;
+ private String order;
+
+ public ContentToCommentsField() {
+ this ( " and is_published='1'", "webdb_create");
+ }
+
+ public ContentToCommentsField(String anExtraCondition, String anOrder) {
+ order = anOrder;
+ extracondition = anExtraCondition;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return anEntityAdapter.getRelation(
+ "to_media="+anEntityAdapter.get("id")+" " + extracondition,
+ order,
+ "comment" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {
+ private String topicCondition;
+ private String topicOrder;
+
+ public ContentToTopicsField() {
+ this(null);
+ }
+
+ public ContentToTopicsField(String aTopicCondition) {
+ this(aTopicCondition, "title");
+ }
+
+ public ContentToTopicsField(String aTopicCondition, String aTopicOrder) {
+ topicCondition = aTopicCondition;
+ topicOrder = aTopicOrder;
+ }
+
+ // TODO rewrite as relational select
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ String condition = "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)";
+ if (topicCondition!=null && topicCondition.length()>0)
+ condition = "(" + topicCondition + ") and " + condition;
+
+ return anEntityAdapter.getRelation(
+ condition,
+ topicOrder,
+ "topic" );
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {
+ private String definition;
+ private boolean published;
+
+ public ContentToMediaField(String aDefinition, boolean anOnlyPublished) {
+ definition = aDefinition;
+ published = anOnlyPublished;
+ }
+
+ public ContentToMediaField(String aDefinition) {
+ this(aDefinition, true);
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ // TODO rewrite as relational select
+ String condition = "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)";
+ if (published)
+ condition = "is_published='t' and " + condition;
+ return anEntityAdapter.getRelation(
+ condition,
+ "id",
+ definition);
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class CommentToMediaField implements EntityAdapterDefinition.CalculatedField {
+ private String definition;
+ private boolean published;
+
+ public CommentToMediaField(String aDefinition, boolean anOnlyPublished) {
+ definition = aDefinition;
+ published = anOnlyPublished;
+ }
+
+ public CommentToMediaField(String aDefinition) {
+ this(aDefinition, true);
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ // TODO rewrite as relational select
+ String condition = "exists (select * from comment_x_media where comment_id="+anEntityAdapter.get("id")+" and media_id=id)";
+ if (published)
+ condition = "is_published='t' and " + condition;
+ return anEntityAdapter.getRelation(
+ condition,
+ "id",
+ definition);
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ EntityAdapter media;
+ Entity mediaType;
+ RewindableIterator iterator;
+ Map result;
+ MirMedia mediaHandler;
+ String tinyIcon;
+ String iconAlt;
+
+ try {
+ iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));
+ iterator.rewind();
+
+ tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyText");
+ iconAlt = "Text";
+
+ if (iterator.hasNext()) {
+ media = (EntityAdapter) iterator.next();
+
+ mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();
+ mediaHandler = MediaHelper.getHandler( mediaType );
+
+ if (mediaHandler.isVideo()) {
+ tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyVideo");
+ iconAlt = "Video";
+ }
+ else if (mediaHandler.isAudio()) {
+ tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyAudio");
+ iconAlt = "Audio";
+ }
+ else if (mediaHandler.isImage()) {
+ tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyImage");
+ iconAlt = "Image";
+ }
+ else {
+ tinyIcon = mediaHandler.getTinyIconName();
+ iconAlt = mediaHandler.getIconAltName();
+ }
+
+ }
+ }
+ catch (Throwable t) {
+ logger.error("ContentToIconField: " +t.getMessage());
+ throw new RuntimeException(t.getMessage());
+ }
+
+ result = new HashMap();
+ result.put("tiny_icon", MirGlobal.config().getString("Producer.ImageRoot") + "/" + tinyIcon);
+ result.put("icon_alt", iconAlt);
+
+ return result;
+ }
+ }
+
+ protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {
+ private String extraCondition;
+
+ public ContentCommentCountField(String anExtraCondition) {
+ super();
+
+ extraCondition = anExtraCondition;
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ return Integer.toString(
+ DatabaseComment.getInstance().getSize(
+ "to_media="+anEntityAdapter.get("id")+" " + extraCondition));
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+
+ protected class ContentMediaCountField implements EntityAdapterDefinition.CalculatedField {
+ private String table;
+ private boolean published;
+
+ public ContentMediaCountField(String aTable, boolean anOnlyPublished) {
+ table = aTable;
+ published = anOnlyPublished;
+ }
+
+ public ContentMediaCountField(String aTable) {
+ this(aTable, true);
+ }
+
+ public Object getValue(EntityAdapter anEntityAdapter) {
+ try {
+ String subQuery = "select * from "+table+" where id = media_id";
+ if (published)
+ subQuery = subQuery + " and is_published='t'";
+
+ return Integer.toString(
+ DatabaseContentToMedia.getInstance().getSize(
+ "exists ("+subQuery+")"));
+ }
+ catch (Throwable t) {
+ throw new RuntimeException(t.getMessage());
+ }
+ }
+ }
+}