import mir.entity.adapter.EntityAdapterDefinition;\r
import mir.entity.adapter.EntityAdapterModel;\r
import mir.log.LoggerWrapper;\r
-import mir.media.MediaHelper;\r
-import mir.media.MirMedia;\r
+import mir.media.MediaHandler;\r
+import mir.misc.NumberUtils;\r
import mir.util.ParameterExpander;\r
import mir.util.RewindableIterator;\r
import mir.util.StructuredContentParser;\r
import mircoders.localizer.MirDataModelLocalizer;\r
import mircoders.localizer.MirLocalizerExc;\r
import mircoders.localizer.MirLocalizerFailure;\r
+import mircoders.media.MediaHelper;\r
+import mircoders.module.ModuleContent;\r
import mircoders.storage.DatabaseArticleType;\r
import mircoders.storage.DatabaseAudio;\r
import mircoders.storage.DatabaseBreaking;\r
anEntityAdapterDefinition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
anEntityAdapterDefinition.addDBDateField("changedate", "webdb_lastchange", configuration.getString("Mir.DefaultTimezone"));\r
anEntityAdapterDefinition.addMirDateField("date", "date", configuration.getString("Mir.DefaultTimezone"));\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("lockinguser", new ContentToUserField("to_locking_user"));\r
+ anEntityAdapterDefinition.addCalculatedField("is_locked", new ContentToIsLockedField());\r
+\r
anEntityAdapterDefinition.addCalculatedField("to_topics", new ContentToTopicsField());\r
anEntityAdapterDefinition.addCalculatedField("to_comments", new ContentToCommentsField());\r
anEntityAdapterDefinition.addCalculatedField("language", new ContentToLanguageField());\r
anEntityAdapterDefinition.addCalculatedField("commentcount", new ContentCommentCountField(" and is_published='1'"));\r
anEntityAdapterDefinition.addCalculatedField("fullcommentcount", new ContentCommentCountField(""));\r
\r
+\r
+ anEntityAdapterDefinition.addCalculatedField("mediacount", new ContentMediaCountField("uploaded_media", true));\r
+ anEntityAdapterDefinition.addCalculatedField("fullmediacount", new ContentMediaCountField("uploaded_media", false));\r
+\r
anEntityAdapterDefinition.addCalculatedField("to_uploaded_media", new ContentToMediaField( "uploadedMedia" ));\r
anEntityAdapterDefinition.addCalculatedField("to_media_images", new ContentToMediaField( "image" ));\r
anEntityAdapterDefinition.addCalculatedField("to_media_audio", new ContentToMediaField( "audio" ));\r
definition = new EntityAdapterDefinition();\r
constructCommentAdapterDefinition( definition );\r
result.addMapping( "comment", DatabaseComment.getInstance(), definition);\r
+ result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());\r
\r
result.addMapping( "articleType", DatabaseArticleType.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "commentStatus", DatabaseCommentStatus.getInstance(), new EntityAdapterDefinition());\r
+\r
+ result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
+\r
\r
definition = new EntityAdapterDefinition();\r
definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
\r
definition = new EntityAdapterDefinition();\r
definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
result.addMapping( "uploadedMedia", DatabaseUploadedMedia.getInstance(), definition);\r
definition = new EntityAdapterDefinition();\r
definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
result.addMapping( "image", DatabaseImages.getInstance(), definition);\r
definition = new EntityAdapterDefinition();\r
definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
result.addMapping( "audio", DatabaseAudio.getInstance(), definition);\r
definition = new EntityAdapterDefinition();\r
definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
result.addMapping( "video", DatabaseVideo.getInstance(), definition);\r
definition = new EntityAdapterDefinition();\r
definition.addCalculatedField("mediafolder", new MediaToMediaFolderField());\r
+ definition.addCalculatedField("human_readable_size", new HumanReadableSizeField("value"));\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("info", new MediaToMediaInfoField());\r
+ definition.addCalculatedField("big_icon", new MediaToBigIconField());\r
result.addMapping( "otherMedia", DatabaseOther.getInstance(), definition);\r
\r
\r
result.addMapping( "language", DatabaseLanguage.getInstance(), new EntityAdapterDefinition());\r
result.addMapping( "mediaType", DatabaseMediaType.getInstance(), new EntityAdapterDefinition());\r
result.addMapping( "topic", DatabaseTopics.getInstance(), new EntityAdapterDefinition());\r
- result.addMapping( "user", DatabaseUsers.getInstance(), new EntityAdapterDefinition());\r
+\r
+ definition = new EntityAdapterDefinition();\r
+ definition.addDBDateField("creationdate", "webdb_create", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addDBDateField("lastlogindate", "lastlogin", configuration.getString("Mir.DefaultTimezone"));\r
+ definition.addCalculatedField("structuredProfile", new StructuredContentField("profile"));\r
+ result.addMapping( "user", DatabaseUsers.getInstance(), definition);\r
+\r
result.addMapping( "otherMedia", DatabaseOther.getInstance(), new EntityAdapterDefinition());\r
\r
result.addMapping( "content_x_topic", DatabaseContentToTopics.getInstance(), new EntityAdapterDefinition());\r
}\r
}\r
\r
+ public static class MediaInfo {\r
+ private MediaHandler mediaHandler;\r
+\r
+ public MediaInfo(MediaHandler aHandler) {\r
+ mediaHandler = aHandler;\r
+ }\r
+ public String getBigIcon() {\r
+ if (mediaHandler == null)\r
+ return "bla";\r
+ else\r
+ return mediaHandler.getBigIconName();\r
+ }\r
+\r
+ public String getSmallIcon() {\r
+ if (mediaHandler == null)\r
+ return "bla";\r
+ else\r
+ return mediaHandler.getTinyIconName();\r
+ }\r
+\r
+ public String getMediaType() {\r
+ return "";\r
+ }\r
+ }\r
+\r
+ protected class MediaToMediaInfoField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ MediaHandler mediaHandler = MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType());\r
+\r
+ return new MediaInfo(mediaHandler);\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class MediaToBigIconField implements EntityAdapterDefinition.CalculatedField {\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return MediaHelper.getHandler(((EntityUploadedMedia) anEntityAdapter.getEntity()).getMediaType()).getBigIconName();\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
protected class ContentToCommentsField implements EntityAdapterDefinition.CalculatedField {\r
private String extracondition;\r
private String order;\r
\r
protected class ContentToTopicsField implements EntityAdapterDefinition.CalculatedField {\r
private String topicCondition;\r
+ private String topicOrder;\r
\r
public ContentToTopicsField() {\r
this(null);\r
}\r
\r
public ContentToTopicsField(String aTopicCondition) {\r
+ this(aTopicCondition, "title");\r
+ }\r
+\r
+ public ContentToTopicsField(String aTopicCondition, String aTopicOrder) {\r
topicCondition = aTopicCondition;\r
+ topicOrder = aTopicOrder;\r
}\r
\r
public Object getValue(EntityAdapter anEntityAdapter) {\r
try {\r
- String condition = "exists (select * from content_x_topic where content_id="+anEntityAdapter.get("id")+" and topic_id=id)";\r
+\r
+ Vector extraTable = new Vector();\r
+ extraTable.add("content_x_topic cxt");\r
+ String condition = "cxt.content_id="+anEntityAdapter.get("id")+\r
+ " and cxt.topic_id=t.id";\r
+\r
if (topicCondition!=null && topicCondition.length()>0)\r
condition = "(" + topicCondition + ") and " + condition;\r
\r
- return anEntityAdapter.getRelation(\r
- condition,\r
- "title",\r
- "topic" );\r
+ return anEntityAdapter.getComplexRelation("t", extraTable,\r
+ condition, topicOrder, "topic" );\r
}\r
catch (Throwable t) {\r
throw new RuntimeException(t.getMessage());\r
\r
public Object getValue(EntityAdapter anEntityAdapter) {\r
try {\r
- String condition = "exists (select * from content_x_media where content_id="+anEntityAdapter.get("id")+" and media_id=id)";\r
+ String condition = "cxm.content_id="+ anEntityAdapter.get("id") +\r
+ " and cxm.media_id = m.id";\r
if (published)\r
condition = "is_published='t' and " + condition;\r
- return anEntityAdapter.getRelation(\r
- condition,\r
- "id",\r
- definition);\r
+\r
+ List extraTables = new Vector();\r
+ extraTables.add("content_x_media cxm");\r
+\r
+ return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition);\r
}\r
catch (Throwable t) {\r
throw new RuntimeException(t.getMessage());\r
\r
public Object getValue(EntityAdapter anEntityAdapter) {\r
try {\r
- String condition = "exists (select * from comment_x_media where comment_id="+anEntityAdapter.get("id")+" and media_id=id)";\r
+\r
+ String condition = "cxm.comment_id="+ anEntityAdapter.get("id") +\r
+ " and cxm.media_id = m.id";\r
if (published)\r
- condition = "is_published='t' and " + condition;\r
- return anEntityAdapter.getRelation(\r
- condition,\r
- "id",\r
- definition);\r
+ condition = "is_published='t' and " + condition;\r
+\r
+ List extraTables = new Vector();\r
+ extraTables.add("comment_x_media cxm");\r
+ return anEntityAdapter.getComplexRelation("m", extraTables, condition, "id", definition);\r
+\r
}\r
catch (Throwable t) {\r
throw new RuntimeException(t.getMessage());\r
Entity mediaType;\r
RewindableIterator iterator;\r
Map result;\r
- MirMedia mediaHandler;\r
+ MediaHandler mediaHandler;\r
String tinyIcon;\r
String iconAlt;\r
\r
mediaType = ((EntityUploadedMedia) (media.getEntity())).getMediaType();\r
mediaHandler = MediaHelper.getHandler( mediaType );\r
\r
- if (mediaHandler.isVideo()) {\r
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyVideo");\r
- iconAlt = "Video";\r
- }\r
- else if (mediaHandler.isAudio()) {\r
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyAudio");\r
- iconAlt = "Audio";\r
- }\r
- else if (mediaHandler.isImage()) {\r
- tinyIcon = MirGlobal.config().getString("Producer.Icon.TinyImage");\r
- iconAlt = "Image";\r
- }\r
- else {\r
- tinyIcon = mediaHandler.getTinyIconName();\r
- iconAlt = mediaHandler.getIconAltName();\r
- }\r
-\r
+ tinyIcon = mediaHandler.getTinyIconName();\r
+ iconAlt = mediaHandler.getIconAltName();\r
}\r
}\r
catch (Throwable t) {\r
}\r
}\r
\r
+ protected class HumanReadableSizeField implements EntityAdapterDefinition.CalculatedField {\r
+ private String fieldName;\r
+\r
+ public HumanReadableSizeField(String aFieldName) {\r
+ fieldName= aFieldName;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ String size = (String) anEntityAdapter.get(fieldName);\r
+ if (size!=null)\r
+ return NumberUtils.humanReadableSize(Double.parseDouble(size));\r
+ else\r
+ return "";\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+\r
protected class ContentMediaCountField implements EntityAdapterDefinition.CalculatedField {\r
private String table;\r
private boolean published;\r
\r
public Object getValue(EntityAdapter anEntityAdapter) {\r
try {\r
- String subQuery = "select * from "+table+" where id = media_id";\r
+ Vector extraTable = new Vector();\r
+ extraTable.add(table+" m");\r
+ String selectSql = "cxm.media_id=m.id and cxm.content_id="+\r
+ anEntityAdapter.get("id");\r
if (published)\r
- subQuery = subQuery + " and is_published='t'";\r
+ selectSql+= " and m.is_published='t'";\r
\r
return Integer.toString(\r
DatabaseContentToMedia.getInstance().getSize(\r
- "exists ("+subQuery+")"));\r
+ "cxm", extraTable, selectSql));\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+ protected class ContentToUserField implements EntityAdapterDefinition.CalculatedField {\r
+ /**\r
+ *\r
+ * @param aFieldName the source field. will be mapped to the id field in the user\r
+ * table\r
+ */\r
+ private String fieldName;\r
+\r
+ public ContentToUserField(String aFieldName) {\r
+ fieldName = aFieldName;\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return anEntityAdapter.getToOneRelation(\r
+ "id=" + anEntityAdapter.get(fieldName),\r
+ "id",\r
+ "user");\r
+ }\r
+ catch (Throwable t) {\r
+ throw new RuntimeException(t.getMessage());\r
+ }\r
+ }\r
+ }\r
+\r
+ protected class ContentToIsLockedField implements EntityAdapterDefinition.CalculatedField {\r
+ private ModuleContent contentModule;\r
+\r
+ public ContentToIsLockedField() {\r
+ contentModule = new ModuleContent(DatabaseContent.getInstance());\r
+ }\r
+\r
+ public Object getValue(EntityAdapter anEntityAdapter) {\r
+ try {\r
+ return new Boolean(contentModule.queryArticleLock(anEntityAdapter.getEntity().getId())!=null);\r
}\r
catch (Throwable t) {\r
throw new RuntimeException(t.getMessage());\r