X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=source%2Fmircoders%2Flocalizer%2Fbasic%2FMirBasicDataModelLocalizer.java;h=937e9c4532eafebaa332ce58d996a89e36a0ae1e;hb=04bf29aa1f1abf43e96d0272b2a286f0c1f9fea8;hp=f96b3947da8d3ccbcd8ea3333194c902cd28c77b;hpb=8297c34c7a424107fd7d1980b6e8e5a3ae26494b;p=mir.git diff --git a/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java b/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java index f96b3947..937e9c45 100755 --- a/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java +++ b/source/mircoders/localizer/basic/MirBasicDataModelLocalizer.java @@ -41,8 +41,8 @@ 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.media.MediaHandler; +import mir.misc.NumberUtils; import mir.util.ParameterExpander; import mir.util.RewindableIterator; import mir.util.StructuredContentParser; @@ -52,6 +52,8 @@ import mircoders.localizer.MirAdminInterfaceLocalizer; import mircoders.localizer.MirDataModelLocalizer; import mircoders.localizer.MirLocalizerExc; import mircoders.localizer.MirLocalizerFailure; +import mircoders.media.MediaHelper; +import mircoders.module.ModuleContent; import mircoders.storage.DatabaseArticleType; import mircoders.storage.DatabaseAudio; import mircoders.storage.DatabaseBreaking; @@ -92,6 +94,10 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { 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("lockinguser", new ContentToUserField("to_locking_user")); + anEntityAdapterDefinition.addCalculatedField("is_locked", new ContentToIsLockedField()); + anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField()); anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField()); anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField()); @@ -99,6 +105,10 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'")); anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField("")); + + anEntityAdapterDefinition.addCalculatedField("mediacount", new ContentMediaCountField("uploaded_media", true)); + anEntityAdapterDefinition.addCalculatedField("fullmediacount", new ContentMediaCountField("uploaded_media", false)); + anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" )); anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" )); anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" )); @@ -170,9 +180,12 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { definition = new EntityAdapterDefinition(); constructCommentAdapterDefinition( definition ); result.addMapping( "comment", DatabaseComment.getInstance(), definition); + result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition()); result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition()); - result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition()); + + result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition()); + definition = new EntityAdapterDefinition(); definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); @@ -184,18 +197,37 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { definition = new EntityAdapterDefinition(); definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), definition); definition = new EntityAdapterDefinition(); definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); result.addMapping( "image", DatabaseImages.getInstance(), definition); definition = new EntityAdapterDefinition(); definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); result.addMapping( "audio", DatabaseAudio.getInstance(), definition); definition = new EntityAdapterDefinition(); definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); result.addMapping( "video", DatabaseVideo.getInstance(), definition); definition = new EntityAdapterDefinition(); definition.addCalculatedField("mediafolder", new MediaToMediaFolderField()); + definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value")); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("info", new MediaToMediaInfoField()); + definition.addCalculatedField("big_icon", new MediaToBigIconField()); result.addMapping( "otherMedia", DatabaseOther.getInstance(), definition); @@ -204,7 +236,13 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { 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()); + + definition = new EntityAdapterDefinition(); + definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone")); + definition.addDBDateField("lastlogindate", "lastlogin", configuration.getString("Mir.DefaultTimezone")); + definition.addCalculatedField("structuredProfile", new StructuredContentField("profile")); + result.addMapping( "user", DatabaseUsers.getInstance(), definition); + result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition()); result.addMapping( "content_x_topic", DatabaseContentToTopics.getInstance(), new EntityAdapterDefinition()); @@ -418,6 +456,55 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } } + public static class MediaInfo { + private MediaHandler mediaHandler; + + public MediaInfo(MediaHandler aHandler) { + mediaHandler = aHandler; + } + public String getBigIcon() { + if (mediaHandler == null) + return "bla"; + else + return mediaHandler.getBigIconName(); + } + + public String getSmallIcon() { + if (mediaHandler == null) + return "bla"; + else + return mediaHandler.getTinyIconName(); + } + + public String getMediaType() { + return ""; + } + } + + protected class MediaToMediaInfoField implements EntityAdapterDefinition.CalculatedField { + public Object getValue(EntityAdapter anEntityAdapter) { + try { + MediaHandler mediaHandler = MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType()); + + return new MediaInfo(mediaHandler); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + protected class MediaToBigIconField implements EntityAdapterDefinition.CalculatedField { + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType()).getBigIconName(); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField { private String extracondition; private String order; @@ -446,25 +533,34 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { 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; } public Object getValue(EntityAdapter anEntityAdapter) { try { - String condition = "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)"; + + Vector extraTable = new Vector(); + extraTable.add("content_x_topic cxt"); + String condition = "cxt.content_id="+anEntityAdapter.get("id")+ + " and cxt.topic_id=t.id"; + if (topicCondition!=null && topicCondition.length()>0) condition = "(" + topicCondition + ") and " + condition; - return anEntityAdapter.getRelation( - condition, - "title", - "topic" ); + return anEntityAdapter.getComplexRelation("t", extraTable, + condition, topicOrder, "topic" ); } catch (Throwable t) { throw new RuntimeException(t.getMessage()); @@ -487,13 +583,15 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { public Object getValue(EntityAdapter anEntityAdapter) { try { - String condition = "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)"; + String condition = "cxm.content_id="+ anEntityAdapter.get("id") + + " and cxm.media_id = m.id"; if (published) condition = "is_published='t' and " + condition; - return anEntityAdapter.getRelation( - condition, - "id", - definition); + + List extraTables = new Vector(); + extraTables.add("content_x_media cxm"); + + return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition); } catch (Throwable t) { throw new RuntimeException(t.getMessage()); @@ -516,13 +614,16 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { public Object getValue(EntityAdapter anEntityAdapter) { try { - String condition = "exists (select * from comment_x_media where comment_id="+anEntityAdapter.get("id")+" and media_id=id)"; + + String condition = "cxm.comment_id="+ anEntityAdapter.get("id") + + " and cxm.media_id = m.id"; if (published) - condition = "is_published='t' and " + condition; - return anEntityAdapter.getRelation( - condition, - "id", - definition); + condition = "is_published='t' and " + condition; + + List extraTables = new Vector(); + extraTables.add("comment_x_media cxm"); + return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition); + } catch (Throwable t) { throw new RuntimeException(t.getMessage()); @@ -536,7 +637,7 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { Entity mediaType; RewindableIterator iterator; Map result; - MirMedia mediaHandler; + MediaHandler mediaHandler; String tinyIcon; String iconAlt; @@ -553,23 +654,8 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { 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(); - } - + tinyIcon = mediaHandler.getTinyIconName(); + iconAlt = mediaHandler.getIconAltName(); } } catch (Throwable t) { @@ -606,6 +692,28 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { } } + protected class HumanReadableSizeField implements EntityAdapterDefinition.CalculatedField { + private String fieldName; + + public HumanReadableSizeField(String aFieldName) { + fieldName= aFieldName; + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + String size = (String) anEntityAdapter.get(fieldName); + if (size!=null) + return NumberUtils.humanReadableSize(Double.parseDouble(size)); + else + return ""; + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + protected class ContentMediaCountField implements EntityAdapterDefinition.CalculatedField { private String table; private boolean published; @@ -621,13 +729,57 @@ public class MirBasicDataModelLocalizer implements MirDataModelLocalizer { public Object getValue(EntityAdapter anEntityAdapter) { try { - String subQuery = "select * from "+table+" where id = media_id"; + Vector extraTable = new Vector(); + extraTable.add(table+" m"); + String selectSql = "cxm.media_id=m.id and cxm.content_id="+ + anEntityAdapter.get("id"); if (published) - subQuery = subQuery + " and is_published='t'"; + selectSql+= " and m.is_published='t'"; return Integer.toString( DatabaseContentToMedia.getInstance().getSize( - "exists ("+subQuery+")")); + "cxm", extraTable, selectSql)); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + protected class ContentToUserField implements EntityAdapterDefinition.CalculatedField { + /** + * + * @param aFieldName the source field. will be mapped to the id field in the user + * table + */ + private String fieldName; + + public ContentToUserField(String aFieldName) { + fieldName = aFieldName; + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return anEntityAdapter.getToOneRelation( + "id=" + anEntityAdapter.get(fieldName), + "id", + "user"); + } + catch (Throwable t) { + throw new RuntimeException(t.getMessage()); + } + } + } + + protected class ContentToIsLockedField implements EntityAdapterDefinition.CalculatedField { + private ModuleContent contentModule; + + public ContentToIsLockedField() { + contentModule = new ModuleContent(DatabaseContent.getInstance()); + } + + public Object getValue(EntityAdapter anEntityAdapter) { + try { + return new Boolean(contentModule.queryArticleLock(anEntityAdapter.getEntity().getId())!=null); } catch (Throwable t) { throw new RuntimeException(t.getMessage());