git.useribm.hu - mediacube.git/blob

   1 package hu.user.mediacube.indexer.db;\r
   2 \r
   3 import java.util.Map;\r
   4 \r
   5 import org.apache.ibatis.jdbc.SQL;\r
   6 \r
   7 public class IndexerViewSqlProvider {\r
   8 \r
   9         private Long getLongParam(Map<String, Object> parameter, String name) {\r
  10                 return parameter.containsKey(name) ? (Long) parameter.get(name) : null;\r
  11         }\r
  12 \r
  13         public String selectAll() {\r
  14                 SQL sql = new SQL();\r
  15                 sql.SELECT("*");\r
  16                 sql.FROM("VW_INDEXER").FETCH_FIRST_ROWS_ONLY(100);\r
  17                 return sql.toString();\r
  18         }\r
  19 \r
  20         public String selectDescription(IndexerDescription description) {\r
  21                 //              Long itemId = getLongParam(parameter, "itemId");\r
  22                 //              Long mediaId = getLongParam(parameter, "mediaId");\r
  23                 //              Long mediaFileId = getLongParam(parameter, "mediaFileId");\r
  24 \r
  25                 SQL sql = new SQL();\r
  26                 sql.SELECT("FULLDESC(itemId, mediaId, mediaFileId)");\r
  27                 sql.FROM("VW_ITEMS");\r
  28                 sql.WHERE("itemId = #{itemId,jdbcType=BIGINT}").AND().WHERE("mediaId = #{mediaId,jdbcType=BIGINT}").AND()\r
  29                                 .WHERE("mediaFileId = #{mediaFileId,jdbcType=BIGINT}");\r
  30                 return sql.toString();\r
  31         }\r
  32 }\r