protected void upgradeRatingsStats() throws Exception {
try (LoggingTimer loggingTimer = new LoggingTimer()) {
StringBundler sb = new StringBundler(4);
sb.append("select classNameId, classPK, count(1) as totalEntries,");
sb.append(" sum(RatingsEntry.score) as totalScore, ");
sb.append("sum(RatingsEntry.score) / count(1) as averageScore ");
sb.append("from RatingsEntry group by classNameId, classPK");
String selectSQL = sb.toString();
String updateSQL =
"update RatingsStats set totalEntries = ?, totalScore = ?, "
+ "averageScore = ? where classNameId = ? and classPK = ?";
try (PreparedStatement ps1 = connection.prepareStatement(selectSQL);
ResultSet rs = ps1.executeQuery();
PreparedStatement ps2 =
AutoBatchPreparedStatementUtil.autoBatch(connection.prepareStatement(updateSQL))) {
while (rs.next()) {
ps2.setInt(1, rs.getInt("totalEntries"));
ps2.setDouble(2, rs.getDouble("totalScore"));
ps2.setDouble(3, rs.getDouble("averageScore"));
ps2.setLong(4, rs.getLong("classNameId"));
ps2.setLong(5, rs.getLong("classPK"));
ps2.addBatch();
}
ps2.executeBatch();
}
}
}
protected void updateAssetEntryClassTypeId() throws Exception {
try (LoggingTimer loggingTimer = new LoggingTimer();
PreparedStatement ps1 =
connection.prepareStatement(
"select companyId, groupId, resourcePrimKey, structureId "
+ "from JournalArticle where structureId != ''");
ResultSet rs = ps1.executeQuery()) {
long classNameId =
PortalUtil.getClassNameId("com.liferay.portlet.journal.model.JournalArticle");
try (PreparedStatement ps2 =
AutoBatchPreparedStatementUtil.concurrentAutoBatch(
connection,
"update AssetEntry set classTypeId = ? where " + "classNameId = ? AND classPK = ?")) {
while (rs.next()) {
long groupId = rs.getLong("groupId");
long companyId = rs.getLong("companyId");
long resourcePrimKey = rs.getLong("resourcePrimKey");
String structureId = rs.getString("structureId");
long ddmStructureId =
getDDMStructureId(groupId, getCompanyGroupId(companyId), structureId);
ps2.setLong(1, ddmStructureId);
ps2.setLong(2, classNameId);
ps2.setLong(3, resourcePrimKey);
ps2.addBatch();
}
ps2.executeBatch();
}
}
}
