protected void verifyContentSearch(long groupId, String portletId) throws Exception {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
con = DataAccess.getUpgradeOptimizedConnection();
ps =
con.prepareStatement(
"select preferences from PortletPreferences inner join "
+ "Layout on PortletPreferences.plid = Layout.plid where "
+ "groupId = ? and portletId = ?");
ps.setLong(1, groupId);
ps.setString(2, portletId);
rs = ps.executeQuery();
while (rs.next()) {
String xml = rs.getString("preferences");
PortletPreferences portletPreferences = PortletPreferencesFactoryUtil.fromDefaultXML(xml);
String articleId = portletPreferences.getValue("articleId", null);
List<JournalContentSearch> contentSearches =
JournalContentSearchLocalServiceUtil.getArticleContentSearches(groupId, articleId);
if (contentSearches.isEmpty()) {
continue;
}
JournalContentSearch contentSearch = contentSearches.get(0);
JournalContentSearchLocalServiceUtil.updateContentSearch(
contentSearch.getGroupId(),
contentSearch.isPrivateLayout(),
contentSearch.getLayoutId(),
contentSearch.getPortletId(),
articleId,
true);
}
} finally {
DataAccess.cleanUp(con, ps, rs);
}
}
/**
* Updates the journal content search in the database or adds it if it does not yet exist. Also
* notifies the appropriate model listeners.
*
* @param journalContentSearch the journal content search
* @param merge whether to merge the journal content search with the current session. See {@link
* com.liferay.portal.service.persistence.BatchSession#update(com.liferay.portal.kernel.dao.orm.Session,
* com.liferay.portal.model.BaseModel, boolean)} for an explanation.
* @return the journal content search that was updated
* @throws SystemException if a system exception occurred
*/
public JournalContentSearch updateJournalContentSearch(
JournalContentSearch journalContentSearch, boolean merge) throws SystemException {
journalContentSearch.setNew(false);
journalContentSearch = journalContentSearchPersistence.update(journalContentSearch, merge);
Indexer indexer = IndexerRegistryUtil.getIndexer(getModelClassName());
if (indexer != null) {
try {
indexer.reindex(journalContentSearch);
} catch (SearchException se) {
if (_log.isWarnEnabled()) {
_log.warn(se, se);
}
}
}
return journalContentSearch;
}