source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java

   1 /*\r
   2  * Copyright (C) 2001, 2002  The Mir-coders group\r
   3  *\r
   4  * This file is part of Mir.\r
   5  *\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
  10  *\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
  15  *\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
  19  *\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
  30  */\r
  31 \r
  32 package mircoders.localizer.basic;\r
  33 \r
  34 import java.util.*;\r
  35 import mir.entity.*;\r
  36 import mir.entity.adapter.*;\r
  37 import mir.media.*;\r
  38 import mir.misc.*;\r
  39 import mir.util.*;\r
  40 import mircoders.storage.*;\r
  41 import mircoders.global.*;\r
  42 import mircoders.entity.*;\r
  43 import mircoders.localizer.*;\r
  44 \r
  45 public class MirBasicDataModelLocalizer implements MirDataModelLocalizer {\r
  46   private EntityAdapterModel model;\r
  47 \r
  48   public MirBasicDataModelLocalizer() {\r
  49   }\r
  50 \r
  51   public EntityAdapterModel adapterModel() throws MirLocalizerFailure {\r
  52     if (model==null)\r
  53       model = buildModel();\r
  54 \r
  55     return model;\r
  56   };\r
  57 \r
  58   protected void constructContentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
  59     try {\r
  60       anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");\r
  61       anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange");\r
  62       anEntityAdapterDefinition.addMirDateField("date", "date");\r
  63       anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());\r
  64       anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());\r
  65       anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());\r
  66 \r
  67       anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));\r
  68       anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));\r
  69 \r
  70       anEntityAdapterDefinition.addCalculatedField("to_media_images",  new ContentToMediaField( "image" ));\r
  71       anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));\r
  72       anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));\r
  73       anEntityAdapterDefinition.addCalculatedField("to_media_video", new ContentToMediaField( "video" ));\r
  74       anEntityAdapterDefinition.addCalculatedField("to_media_other", new ContentToMediaField( "otherMedia" ));\r
  75       anEntityAdapterDefinition.addCalculatedField("to_media_icon", new ContentToIconField());\r
  76 \r
  77       anEntityAdapterDefinition.addCalculatedField("article_type", new ContentToArticleTypeField());\r
  78 \r
  79       anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));\r
  80       anEntityAdapterDefinition.addCalculatedField("content_data_parsed", new FilteredField("content_data"));\r
  81 \r
  82       anEntityAdapterDefinition.addCalculatedField("operations",\r
  83           new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleArticleOperations()));\r
  84     }\r
  85     catch (Throwable t) {\r
  86       throw new MirLocalizerFailure(t.getMessage(), t);\r
  87     }\r
  88   }\r
  89 \r
  90   protected void constructCommentAdapterDefinition(EntityAdapterDefinition anEntityAdapterDefinition) throws MirLocalizerFailure {\r
  91     try {\r
  92       anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create");\r
  93       anEntityAdapterDefinition.addCalculatedField("to_content", new CommentToContentField());\r
  94       anEntityAdapterDefinition.addCalculatedField("status", new CommentToStatusField());\r
  95 \r
  96       anEntityAdapterDefinition.addCalculatedField("description_parsed", new FilteredField("description"));\r
  97       anEntityAdapterDefinition.addCalculatedField("operations",\r
  98           new EntityToSimpleOperationsField(MirGlobal.localizer().adminInterface().simpleCommentOperations()));\r
  99     }\r
 100     catch (Throwable t) {\r
 101       throw new MirLocalizerFailure(t.getMessage(), t);\r
 102     }\r
 103   }\r
 104 \r
 105   protected EntityAdapterModel buildModel() throws MirLocalizerFailure {\r
 106     EntityAdapterModel result = new EntityAdapterModel();\r
 107 \r
 108     try {\r
 109       EntityAdapterDefinition definition;\r
 110 \r
 111       definition = new EntityAdapterDefinition();\r
 112       constructContentAdapterDefinition( definition );\r
 113       result.addMapping( "content", DatabaseContent.getInstance(), definition);\r
 114 \r
 115       definition = new EntityAdapterDefinition();\r
 116       constructCommentAdapterDefinition( definition );\r
 117       result.addMapping( "comment", DatabaseComment.getInstance(), definition);\r
 118 \r
 119       result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());\r
 120       result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());\r
 121 \r
 122       definition = new EntityAdapterDefinition();\r
 123       definition.addDBDateField("creationdate", "webdb_create");\r
 124       result.addMapping( "breakingNews", DatabaseBreaking.getInstance(), definition);\r
 125 \r
 126       result.addMapping( "feature", DatabaseFeature.getInstance(), new EntityAdapterDefinition());\r
 127       result.addMapping( "imageType", DatabaseImageType.getInstance(), new EntityAdapterDefinition());\r
 128       result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());\r
 129       result.addMapping( "mediaFolder", DatabaseMediafolder.getInstance(), new EntityAdapterDefinition());\r
 130       result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
 131       result.addMapping( "internalMessage", DatabaseMessages.getInstance(), new EntityAdapterDefinition());\r
 132       result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());\r
 133       result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());\r
 134       result.addMapping( "media", DatabaseMedia.getInstance(), new EntityAdapterDefinition());\r
 135       result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), new EntityAdapterDefinition());\r
 136       result.addMapping( "image", DatabaseImages.getInstance(), new EntityAdapterDefinition());\r
 137       result.addMapping( "audio", DatabaseAudio.getInstance(), new EntityAdapterDefinition());\r
 138       result.addMapping( "video", DatabaseVideo.getInstance(), new EntityAdapterDefinition());\r
 139       result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());\r
 140     }\r
 141     catch (Throwable t) {\r
 142       throw new MirLocalizerFailure(t.getMessage(), t);\r
 143     }\r
 144 \r
 145     return result;\r
 146   }\r
 147 \r
 148   protected class CommentToContentField implements EntityAdapterDefinition.CalculatedField {\r
 149     public Object getValue(EntityAdapter anEntityAdapter) {\r
 150       try {\r
 151         return anEntityAdapter.getToOneRelation(\r
 152                     "id="+anEntityAdapter.get("to_media"),\r
 153                     "id",\r
 154                     "content" );\r
 155       }\r
 156       catch (Throwable t) {\r
 157         throw new RuntimeException(t.getMessage());\r
 158       }\r
 159     }\r
 160   }\r
 161 \r
 162   protected class CommentToStatusField implements EntityAdapterDefinition.CalculatedField {\r
 163     public Object getValue(EntityAdapter anEntityAdapter) {\r
 164       try {\r
 165         return anEntityAdapter.getToOneRelation(\r
 166                     "id="+anEntityAdapter.get("to_comment_status"),\r
 167                     "id",\r
 168                     "commentStatus" );\r
 169       }\r
 170       catch (Throwable t) {\r
 171         throw new RuntimeException(t.getMessage());\r
 172       }\r
 173     }\r
 174   }\r
 175 \r
 176   protected class EntityToSimpleOperationsField implements EntityAdapterDefinition.CalculatedField {\r
 177     private List operations;\r
 178 \r
 179     public EntityToSimpleOperationsField(List anOperations) {\r
 180       operations = anOperations;\r
 181     }\r
 182 \r
 183     public Object getValue(EntityAdapter anEntityAdapter) {\r
 184       try {\r
 185         Iterator i = operations.iterator();\r
 186         List availableOperations = new Vector();\r
 187 \r
 188         while (i.hasNext()) {\r
 189           MirAdminInterfaceLocalizer.MirSimpleEntityOperation operation =\r
 190             (MirAdminInterfaceLocalizer.MirSimpleEntityOperation) i.next();\r
 191 \r
 192           if (operation.isAvailable(anEntityAdapter)) {\r
 193             availableOperations.add(operation.getName());\r
 194           }\r
 195         };\r
 196 \r
 197         return availableOperations;\r
 198       }\r
 199       catch (Throwable t) {\r
 200         throw new RuntimeException(t.getMessage());\r
 201       }\r
 202     }\r
 203   }\r
 204 \r
 205   protected class FilteredField implements EntityAdapterDefinition.CalculatedField {\r
 206     String fieldName;\r
 207 \r
 208     public FilteredField(String aFieldName) {\r
 209       fieldName = aFieldName;\r
 210     }\r
 211 \r
 212     public Object getValue(EntityAdapter anEntityAdapter) {\r
 213       try {\r
 214         if (anEntityAdapter.get("is_html")!=null && anEntityAdapter.get("is_html").equals("1")) {\r
 215           return anEntityAdapter.get(fieldName);\r
 216         }\r
 217         else {\r
 218           return MirGlobal.localizer().producerAssistant().filterText((String) anEntityAdapter.get(fieldName));\r
 219         }\r
 220       }\r
 221       catch (Throwable t) {\r
 222         throw new RuntimeException(t.getMessage());\r
 223       }\r
 224     }\r
 225   }\r
 226 \r
 227   protected class ContentToLanguageField implements EntityAdapterDefinition.CalculatedField {\r
 228     public Object getValue(EntityAdapter anEntityAdapter) {\r
 229       try {\r
 230         return anEntityAdapter.getToOneRelation(\r
 231                     "id="+anEntityAdapter.get("to_language"),\r
 232                     "id",\r
 233                     "language" );\r
 234       }\r
 235       catch (Throwable t) {\r
 236         throw new RuntimeException(t.getMessage());\r
 237       }\r
 238     }\r
 239   }\r
 240 \r
 241   protected class ContentToArticleTypeField implements EntityAdapterDefinition.CalculatedField {\r
 242     public Object getValue(EntityAdapter anEntityAdapter) {\r
 243       try {\r
 244         return anEntityAdapter.getToOneRelation(\r
 245                     "id="+anEntityAdapter.get("to_article_type"),\r
 246                     "id",\r
 247                     "articleType" );\r
 248       }\r
 249       catch (Throwable t) {\r
 250         throw new RuntimeException(t.getMessage());\r
 251       }\r
 252     }\r
 253   }\r
 254 \r
 255   protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {\r
 256     public Object getValue(EntityAdapter anEntityAdapter) {\r
 257       try {\r
 258         return anEntityAdapter.getRelation(\r
 259                     "to_media="+anEntityAdapter.get("id")+" and is_published='1'",\r
 260                     "webdb_create",\r
 261                     "comment" );\r
 262       }\r
 263       catch (Throwable t) {\r
 264         throw new RuntimeException(t.getMessage());\r
 265       }\r
 266     }\r
 267   }\r
 268 \r
 269   protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {\r
 270     public Object getValue(EntityAdapter anEntityAdapter) {\r
 271       try {\r
 272         return anEntityAdapter.getRelation(\r
 273                     "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)",\r
 274                     "title",\r
 275                     "topic" );\r
 276       }\r
 277       catch (Throwable t) {\r
 278         throw new RuntimeException(t.getMessage());\r
 279       }\r
 280     }\r
 281   }\r
 282 \r
 283   protected class ContentToMediaField implements EntityAdapterDefinition.CalculatedField {\r
 284     String definition;\r
 285 \r
 286     public ContentToMediaField(String aDefinition) {\r
 287       definition = aDefinition;\r
 288     }\r
 289 \r
 290     public Object getValue(EntityAdapter anEntityAdapter) {\r
 291       try {\r
 292         return anEntityAdapter.getRelation(\r
 293           "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)",\r
 294           "title",\r
 295           definition);\r
 296       }\r
 297       catch (Throwable t) {\r
 298         throw new RuntimeException(t.getMessage());\r
 299       }\r
 300     }\r
 301   }\r
 302 \r
 303   protected class ContentToIconField implements EntityAdapterDefinition.CalculatedField {\r
 304     public Object getValue(EntityAdapter anEntityAdapter) {\r
 305       EntityAdapter media;\r
 306       Entity mediaType;\r
 307       RewindableIterator iterator;\r
 308       Map result;\r
 309       MirMedia mediaHandler;\r
 310       String tinyIcon;\r
 311       String iconAlt;\r
 312 \r
 313       try {\r
 314         iterator = (RewindableIterator) (anEntityAdapter.get("to_uploaded_media"));\r
 315         iterator.rewind();\r
 316 \r
 317         tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyText");\r
 318         iconAlt = "Text";\r
 319 \r
 320         if (iterator.hasNext()) {\r
 321           media = (EntityAdapter) iterator.next();\r
 322 \r
 323           mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();\r
 324           mediaHandler = MediaHelper.getHandler( mediaType );\r
 325 \r
 326           if (mediaHandler.isVideo()) {\r
 327             tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyVideo");\r
 328             iconAlt = "Video";\r
 329           }\r
 330           else if (mediaHandler.isAudio()) {\r
 331             tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyAudio");\r
 332             iconAlt = "Audio";\r
 333           }\r
 334           else if (mediaHandler.isImage()) {\r
 335             tinyIcon = MirGlobal.getConfigProperty("Producer.Icon.TinyImage");\r
 336             iconAlt = "Image";\r
 337           }\r
 338           else {\r
 339             tinyIcon = mediaHandler.getTinyIconName();\r
 340             iconAlt = mediaHandler.getIconAltName();\r
 341           }\r
 342 \r
 343         }\r
 344       }\r
 345       catch (Throwable t) {\r
 346         System.out.println("ContentToIconField: exception: " +t.getMessage());\r
 347         t.printStackTrace(System.out);\r
 348         throw new RuntimeException(t.getMessage());\r
 349       }\r
 350 \r
 351       result = new HashMap();\r
 352       result.put("tiny_icon", MirGlobal.getConfigProperty("Producer.ImageRoot") + "/" + tinyIcon);\r
 353       result.put("icon_alt", iconAlt);\r
 354 \r
 355       return result;\r
 356     }\r
 357   }\r
 358 \r
 359   protected class ContentCommentCountField implements EntityAdapterDefinition.CalculatedField {\r
 360     private String extraCondition;\r
 361 \r
 362     public ContentCommentCountField(String anExtraCondition) {\r
 363       super();\r
 364 \r
 365       extraCondition = anExtraCondition;\r
 366     }\r
 367 \r
 368     public Object getValue(EntityAdapter anEntityAdapter) {\r
 369       try {\r
 370         return Integer.toString(\r
 371             DatabaseComment.getInstance().getSize(\r
 372                   "to_media="+anEntityAdapter.get("id")+" " + extraCondition));\r
 373       }\r
 374       catch (Throwable t) {\r
 375         throw new RuntimeException(t.getMessage());\r
 376       }\r
 377     }\r
 378   }\r
 379 }\r