@Override
public Optional<String> getPopulateTempTableStatement() {
String sql =
"insert into "
+ getTempTableName()
+ " "
+ "select coc.categoryoptioncomboid as cocid, coc.name as cocname, ";
for (DataElementCategory category : objects) {
sql +=
"("
+ "select co.name from categoryoptioncombos_categoryoptions cocco "
+ "inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid "
+ "inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid "
+ "where coc.categoryoptioncomboid = cocco.categoryoptioncomboid "
+ "and cco.categoryid = "
+ category.getId()
+ " "
+ "limit 1) as "
+ columnQuote
+ category.getName()
+ columnQuote
+ ", ";
sql +=
"("
+ "select co.uid from categoryoptioncombos_categoryoptions cocco "
+ "inner join dataelementcategoryoption co on cocco.categoryoptionid = co.categoryoptionid "
+ "inner join categories_categoryoptions cco on co.categoryoptionid = cco.categoryoptionid "
+ "where coc.categoryoptioncomboid = cocco.categoryoptioncomboid "
+ "and cco.categoryid = "
+ category.getId()
+ " "
+ "limit 1) as "
+ columnQuote
+ category.getUid()
+ columnQuote
+ ", ";
}
sql = TextUtils.removeLastComma(sql) + " ";
sql += "from categoryoptioncombo coc ";
return Optional.of(sql);
}
