git.useribm.hu - mediacube.git/blob

   1 package hu.user.mediacube.indexer.db;\r
   2 \r
   3 import java.util.List;\r
   4 import java.util.Map;\r
   5 \r
   6 import org.apache.ibatis.jdbc.SQL;\r
   7 \r
   8 import hu.user.mediacube.indexer.db.MediadescriptionExample.Criteria;\r
   9 import hu.user.mediacube.indexer.db.MediadescriptionExample.Criterion;\r
  10 \r
  11 public class MediadescriptionSqlProvider {\r
  12 \r
  13         /**\r
  14          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
  15          *\r
  16          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
  17          */\r
  18         protected void applyWhere(SQL sql, MediadescriptionExample example, boolean includeExamplePhrase) {\r
  19                 if (example == null) {\r
  20                         return;\r
  21                 }\r
  22 \r
  23                 String parmPhrase1;\r
  24                 String parmPhrase1_th;\r
  25                 String parmPhrase2;\r
  26                 String parmPhrase2_th;\r
  27                 String parmPhrase3;\r
  28                 String parmPhrase3_th;\r
  29                 if (includeExamplePhrase) {\r
  30                         parmPhrase1 = "%s #{example.oredCriteria[%d].allCriteria[%d].value}";\r
  31                         parmPhrase1_th = "%s #{example.oredCriteria[%d].allCriteria[%d].value,typeHandler=%s}";\r
  32                         parmPhrase2 = "%s #{example.oredCriteria[%d].allCriteria[%d].value} and #{example.oredCriteria[%d].criteria[%d].secondValue}";\r
  33                         parmPhrase2_th = "%s #{example.oredCriteria[%d].allCriteria[%d].value,typeHandler=%s} and #{example.oredCriteria[%d].criteria[%d].secondValue,typeHandler=%s}";\r
  34                         parmPhrase3 = "#{example.oredCriteria[%d].allCriteria[%d].value[%d]}";\r
  35                         parmPhrase3_th = "#{example.oredCriteria[%d].allCriteria[%d].value[%d],typeHandler=%s}";\r
  36                 } else {\r
  37                         parmPhrase1 = "%s #{oredCriteria[%d].allCriteria[%d].value}";\r
  38                         parmPhrase1_th = "%s #{oredCriteria[%d].allCriteria[%d].value,typeHandler=%s}";\r
  39                         parmPhrase2 = "%s #{oredCriteria[%d].allCriteria[%d].value} and #{oredCriteria[%d].criteria[%d].secondValue}";\r
  40                         parmPhrase2_th = "%s #{oredCriteria[%d].allCriteria[%d].value,typeHandler=%s} and #{oredCriteria[%d].criteria[%d].secondValue,typeHandler=%s}";\r
  41                         parmPhrase3 = "#{oredCriteria[%d].allCriteria[%d].value[%d]}";\r
  42                         parmPhrase3_th = "#{oredCriteria[%d].allCriteria[%d].value[%d],typeHandler=%s}";\r
  43                 }\r
  44 \r
  45                 StringBuilder sb = new StringBuilder();\r
  46                 List<Criteria> oredCriteria = example.getOredCriteria();\r
  47                 boolean firstCriteria = true;\r
  48                 for (int i = 0; i < oredCriteria.size(); i++) {\r
  49                         Criteria criteria = oredCriteria.get(i);\r
  50                         if (criteria.isValid()) {\r
  51                                 if (firstCriteria) {\r
  52                                         firstCriteria = false;\r
  53                                 } else {\r
  54                                         sb.append(" or ");\r
  55                                 }\r
  56 \r
  57                                 sb.append('(');\r
  58                                 List<Criterion> criterions = criteria.getAllCriteria();\r
  59                                 boolean firstCriterion = true;\r
  60                                 for (int j = 0; j < criterions.size(); j++) {\r
  61                                         Criterion criterion = criterions.get(j);\r
  62                                         if (firstCriterion) {\r
  63                                                 firstCriterion = false;\r
  64                                         } else {\r
  65                                                 sb.append(" and ");\r
  66                                         }\r
  67 \r
  68                                         if (criterion.isNoValue()) {\r
  69                                                 sb.append(criterion.getCondition());\r
  70                                         } else if (criterion.isSingleValue()) {\r
  71                                                 if (criterion.getTypeHandler() == null) {\r
  72                                                         sb.append(String.format(parmPhrase1, criterion.getCondition(), i, j));\r
  73                                                 } else {\r
  74                                                         sb.append(String.format(parmPhrase1_th, criterion.getCondition(), i, j, criterion.getTypeHandler()));\r
  75                                                 }\r
  76                                         } else if (criterion.isBetweenValue()) {\r
  77                                                 if (criterion.getTypeHandler() == null) {\r
  78                                                         sb.append(String.format(parmPhrase2, criterion.getCondition(), i, j, i, j));\r
  79                                                 } else {\r
  80                                                         sb.append(String.format(parmPhrase2_th, criterion.getCondition(), i, j, criterion.getTypeHandler(), i, j,\r
  81                                                                         criterion.getTypeHandler()));\r
  82                                                 }\r
  83                                         } else if (criterion.isListValue()) {\r
  84                                                 sb.append(criterion.getCondition());\r
  85                                                 sb.append(" (");\r
  86                                                 List<?> listItems = (List<?>) criterion.getValue();\r
  87                                                 boolean comma = false;\r
  88                                                 for (int k = 0; k < listItems.size(); k++) {\r
  89                                                         if (comma) {\r
  90                                                                 sb.append(", ");\r
  91                                                         } else {\r
  92                                                                 comma = true;\r
  93                                                         }\r
  94                                                         if (criterion.getTypeHandler() == null) {\r
  95                                                                 sb.append(String.format(parmPhrase3, i, j, k));\r
  96                                                         } else {\r
  97                                                                 sb.append(String.format(parmPhrase3_th, i, j, k, criterion.getTypeHandler()));\r
  98                                                         }\r
  99                                                 }\r
 100                                                 sb.append(')');\r
 101                                         }\r
 102                                 }\r
 103                                 sb.append(')');\r
 104                         }\r
 105                 }\r
 106 \r
 107                 if (sb.length() > 0) {\r
 108                         sql.WHERE(sb.toString());\r
 109                 }\r
 110         }\r
 111 \r
 112         /**\r
 113          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 114          *\r
 115          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 116          */\r
 117         public String countByExample(MediadescriptionExample example) {\r
 118                 SQL sql = new SQL();\r
 119                 sql.SELECT("count(*)").FROM("DB2ADMIN.MEDIADESCRIPTION");\r
 120                 applyWhere(sql, example, false);\r
 121                 return sql.toString();\r
 122         }\r
 123 \r
 124         /**\r
 125          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 126          *\r
 127          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 128          */\r
 129         public String deleteByExample(MediadescriptionExample example) {\r
 130                 SQL sql = new SQL();\r
 131                 sql.DELETE_FROM("DB2ADMIN.MEDIADESCRIPTION");\r
 132                 applyWhere(sql, example, false);\r
 133                 return sql.toString();\r
 134         }\r
 135 \r
 136         /**\r
 137          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 138          *\r
 139          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 140          */\r
 141         public String insertSelective(Mediadescription record) {\r
 142                 SQL sql = new SQL();\r
 143                 sql.INSERT_INTO("DB2ADMIN.MEDIADESCRIPTION");\r
 144 \r
 145                 if (record.getId() != null) {\r
 146                         sql.VALUES("ID", "#{id,jdbcType=BIGINT}");\r
 147                 }\r
 148 \r
 149                 if (record.getItemid() != null) {\r
 150                         sql.VALUES("ITEMID", "#{itemid,jdbcType=BIGINT}");\r
 151                 }\r
 152 \r
 153                 if (record.getMediaid() != null) {\r
 154                         sql.VALUES("MEDIAID", "#{mediaid,jdbcType=BIGINT}");\r
 155                 }\r
 156 \r
 157                 if (record.getMediafileid() != null) {\r
 158                         sql.VALUES("MEDIAFILEID", "#{mediafileid,jdbcType=BIGINT}");\r
 159                 }\r
 160 \r
 161                 if (record.getDescription() != null) {\r
 162                         sql.VALUES("DESCRIPTION", "#{description,jdbcType=CLOB}");\r
 163                 }\r
 164 \r
 165                 return sql.toString();\r
 166         }\r
 167 \r
 168         /**\r
 169          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 170          *\r
 171          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 172          */\r
 173         public String selectByExample(MediadescriptionExample example) {\r
 174                 SQL sql = new SQL();\r
 175                 if (example != null && example.isDistinct()) {\r
 176                         sql.SELECT_DISTINCT("ID");\r
 177                 } else {\r
 178                         sql.SELECT("ID");\r
 179                 }\r
 180                 sql.SELECT("ITEMID");\r
 181                 sql.SELECT("MEDIAID");\r
 182                 sql.SELECT("MEDIAFILEID");\r
 183                 sql.FROM("DB2ADMIN.MEDIADESCRIPTION");\r
 184                 applyWhere(sql, example, false);\r
 185 \r
 186                 sql.FETCH_FIRST_ROWS_ONLY(1);\r
 187 \r
 188                 if (example != null && example.getOrderByClause() != null) {\r
 189                         sql.ORDER_BY(example.getOrderByClause());\r
 190                 }\r
 191 \r
 192                 return sql.toString();\r
 193         }\r
 194 \r
 195         /**\r
 196          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 197          *\r
 198          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 199          */\r
 200         public String selectByExampleWithBLOBs(MediadescriptionExample example) {\r
 201                 SQL sql = new SQL();\r
 202                 if (example != null && example.isDistinct()) {\r
 203                         sql.SELECT_DISTINCT("ID");\r
 204                 } else {\r
 205                         sql.SELECT("ID");\r
 206                 }\r
 207                 sql.SELECT("ITEMID");\r
 208                 sql.SELECT("MEDIAID");\r
 209                 sql.SELECT("MEDIAFILEID");\r
 210                 sql.SELECT("DESCRIPTION");\r
 211                 sql.FROM("DB2ADMIN.MEDIADESCRIPTION");\r
 212                 applyWhere(sql, example, false);\r
 213 \r
 214                 if (example != null && example.getOrderByClause() != null) {\r
 215                         sql.ORDER_BY(example.getOrderByClause());\r
 216                 }\r
 217 \r
 218                 return sql.toString();\r
 219         }\r
 220 \r
 221         /**\r
 222          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 223          *\r
 224          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 225          */\r
 226         public String updateByExample(Map<String, Object> parameter) {\r
 227                 SQL sql = new SQL();\r
 228                 sql.UPDATE("DB2ADMIN.MEDIADESCRIPTION");\r
 229 \r
 230                 sql.SET("ID = #{record.id,jdbcType=BIGINT}");\r
 231                 sql.SET("ITEMID = #{record.itemid,jdbcType=BIGINT}");\r
 232                 sql.SET("MEDIAID = #{record.mediaid,jdbcType=BIGINT}");\r
 233                 sql.SET("MEDIAFILEID = #{record.mediafileid,jdbcType=BIGINT}");\r
 234 \r
 235                 MediadescriptionExample example = (MediadescriptionExample) parameter.get("example");\r
 236                 applyWhere(sql, example, true);\r
 237                 return sql.toString();\r
 238         }\r
 239 \r
 240         /**\r
 241          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 242          *\r
 243          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 244          */\r
 245         public String updateByExampleSelective(Map<String, Object> parameter) {\r
 246                 Mediadescription record = (Mediadescription) parameter.get("record");\r
 247                 MediadescriptionExample example = (MediadescriptionExample) parameter.get("example");\r
 248 \r
 249                 SQL sql = new SQL();\r
 250                 sql.UPDATE("DB2ADMIN.MEDIADESCRIPTION");\r
 251 \r
 252                 if (record.getId() != null) {\r
 253                         sql.SET("ID = #{record.id,jdbcType=BIGINT}");\r
 254                 }\r
 255 \r
 256                 if (record.getItemid() != null) {\r
 257                         sql.SET("ITEMID = #{record.itemid,jdbcType=BIGINT}");\r
 258                 }\r
 259 \r
 260                 if (record.getMediaid() != null) {\r
 261                         sql.SET("MEDIAID = #{record.mediaid,jdbcType=BIGINT}");\r
 262                 }\r
 263 \r
 264                 if (record.getMediafileid() != null) {\r
 265                         sql.SET("MEDIAFILEID = #{record.mediafileid,jdbcType=BIGINT}");\r
 266                 }\r
 267 \r
 268                 if (record.getDescription() != null) {\r
 269                         sql.SET("DESCRIPTION = #{record.description,jdbcType=CLOB}");\r
 270                 }\r
 271 \r
 272                 applyWhere(sql, example, true);\r
 273                 return sql.toString();\r
 274         }\r
 275 \r
 276         /**\r
 277          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 278          *\r
 279          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 280          */\r
 281         public String updateByExampleWithBLOBs(Map<String, Object> parameter) {\r
 282                 SQL sql = new SQL();\r
 283                 sql.UPDATE("DB2ADMIN.MEDIADESCRIPTION");\r
 284 \r
 285                 sql.SET("ID = #{record.id,jdbcType=BIGINT}");\r
 286                 sql.SET("ITEMID = #{record.itemid,jdbcType=BIGINT}");\r
 287                 sql.SET("MEDIAID = #{record.mediaid,jdbcType=BIGINT}");\r
 288                 sql.SET("MEDIAFILEID = #{record.mediafileid,jdbcType=BIGINT}");\r
 289                 sql.SET("DESCRIPTION = #{record.description,jdbcType=CLOB}");\r
 290 \r
 291                 MediadescriptionExample example = (MediadescriptionExample) parameter.get("example");\r
 292                 applyWhere(sql, example, true);\r
 293                 return sql.toString();\r
 294         }\r
 295 \r
 296         /**\r
 297          * This method was generated by MyBatis Generator. This method corresponds to the database table DB2ADMIN.MEDIADESCRIPTION\r
 298          *\r
 299          * @mbg.generated Fri Sep 13 15:49:42 CEST 2019\r
 300          */\r
 301         public String updateByPrimaryKeySelective(Mediadescription record) {\r
 302                 SQL sql = new SQL();\r
 303                 sql.UPDATE("DB2ADMIN.MEDIADESCRIPTION");\r
 304 \r
 305                 if (record.getItemid() != null) {\r
 306                         sql.SET("ITEMID = #{itemid,jdbcType=BIGINT}");\r
 307                 }\r
 308 \r
 309                 if (record.getMediaid() != null) {\r
 310                         sql.SET("MEDIAID = #{mediaid,jdbcType=BIGINT}");\r
 311                 }\r
 312 \r
 313                 if (record.getMediafileid() != null) {\r
 314                         sql.SET("MEDIAFILEID = #{mediafileid,jdbcType=BIGINT}");\r
 315                 }\r
 316 \r
 317                 if (record.getDescription() != null) {\r
 318                         sql.SET("DESCRIPTION = #{description,jdbcType=CLOB}");\r
 319                 }\r
 320 \r
 321                 sql.WHERE("ID = #{id,jdbcType=BIGINT}");\r
 322 \r
 323                 return sql.toString();\r
 324         }\r
 325 }