/**
* Get the site that the siteMaster references
*
* @param siteMaster
* @return
*/
private String getSiteMasterSite(SearchBuilderItem siteMaster) {
if (siteMaster.getName().startsWith(SearchBuilderItem.INDEX_MASTER)
&& !SearchBuilderItem.GLOBAL_CONTEXT.equals(siteMaster.getContext())) {
// this depends on the pattern, perhapse it should be a parse
return siteMaster.getName().substring(SearchBuilderItem.INDEX_MASTER.length() + 1);
}
return null;
}
/**
* get the action for the site master
*
* @param siteMaster
* @return
*/
private Integer getSiteMasterAction(SearchBuilderItem siteMaster) {
if (siteMaster.getName().startsWith(SearchBuilderItem.INDEX_MASTER)
&& !SearchBuilderItem.GLOBAL_CONTEXT.equals(siteMaster.getContext())) {
if (SearchBuilderItem.STATE_PENDING.equals(siteMaster.getSearchstate())) {
return siteMaster.getSearchaction();
}
}
return SearchBuilderItem.STATE_UNKNOWN;
}
private int populateStatement(PreparedStatement pst, SearchBuilderItem sbi) throws SQLException {
pst.setString(1, sbi.getName());
pst.setString(2, sbi.getContext());
pst.setInt(3, sbi.getSearchaction().intValue());
pst.setInt(4, sbi.getSearchstate().intValue());
pst.setDate(5, new Date(sbi.getVersion().getTime()));
pst.setInt(6, sbi.getItemscope().intValue());
pst.setString(7, sbi.getId());
return 7;
}
private void refreshIndex(Connection connection, SearchBuilderItem controlItem)
throws SQLException {
// delete all and return the master action only
// the caller will then rebuild the index from scratch
log.debug(
"UPDATE ALL RECORDS =========================================================="); //$NON-NLS-1$
Statement stm = null;
try {
stm = connection.createStatement();
if (SearchBuilderItem.GLOBAL_CONTEXT.equals(controlItem.getContext())) {
stm.execute(
"update searchbuilderitem set searchstate = " //$NON-NLS-1$
+ SearchBuilderItem.STATE_PENDING
+ " where itemscope = "
+ SearchBuilderItem.ITEM); // $NON-NLS-1$
} else {
stm.execute(
"update searchbuilderitem set searchstate = " //$NON-NLS-1$
+ SearchBuilderItem.STATE_PENDING
+ " where itemscope = "
+ SearchBuilderItem.ITEM_SITE_MASTER
+ " and context = '"
+ controlItem.getContext() // $NON-NLS-1$
+ "' and name <> '"
+ controlItem.getName()
+ "'"); //$NON-NLS-1$ //$NON-NLS-2$
}
controlItem.setSearchstate(SearchBuilderItem.STATE_COMPLETED);
updateOrSave(connection, controlItem);
connection.commit();
} finally {
try {
stm.close();
} catch (Exception ex) {
log.debug(ex);
}
;
}
}
private void rebuildIndex(
Connection connection, SearchBuilderItem controlItem, SearchIndexBuilderWorker worker)
throws SQLException {
// delete all and return the master action only
// the caller will then rebuild the index from scratch
log.info(
"DELETE ALL RECORDS =========================================================="); //$NON-NLS-1$
Statement stm = null;
try {
stm = connection.createStatement();
if (SearchBuilderItem.GLOBAL_CONTEXT.equals(controlItem.getContext())) {
stm.execute(
"delete from searchbuilderitem where itemscope = "
+ SearchBuilderItem.ITEM
+ " or itemscope = "
+ SearchBuilderItem.ITEM_SITE_MASTER); // $NON-NLS-1$
} else {
stm.execute("delete from searchbuilderitem where itemscope = " + SearchBuilderItem.ITEM);
stm.execute(
"delete from searchbuilderitem where context = '" //$NON-NLS-1$
+ controlItem.getContext()
+ "' and name <> '" //$NON-NLS-1$
+ controlItem.getName()
+ "' "); //$NON-NLS-1$
}
log.debug(
"DONE DELETE ALL RECORDS ==========================================================="); //$NON-NLS-1$
connection.commit();
log.debug(
"ADD ALL RECORDS ==========================================================="); //$NON-NLS-1$
long lastupdate = System.currentTimeMillis();
List<String> contextList = new ArrayList<String>();
if (SearchBuilderItem.GLOBAL_CONTEXT.equals(controlItem.getContext())) {
for (Iterator<Site> i =
SiteService.getSites(SelectionType.ANY, null, null, null, SortType.NONE, null)
.iterator();
i.hasNext(); ) {
Site s = (Site) i.next();
if (!SiteService.isSpecialSite(s.getId())) {
if (searchIndexBuilder.isOnlyIndexSearchToolSites()) {
ToolConfiguration t = s.getToolForCommonId("sakai.search"); // $NON-NLS-1$
if (t != null) {
contextList.add(s.getId());
}
} else if (!(searchIndexBuilder.isExcludeUserSites()
&& SiteService.isUserSite(s.getId()))) {
contextList.add(s.getId());
}
}
}
} else {
contextList.add(controlItem.getContext());
}
for (Iterator<String> c = contextList.iterator(); c.hasNext(); ) {
String siteContext = (String) c.next();
log.debug("Rebuild for " + siteContext); // $NON-NLS-1$
for (Iterator<EntityContentProducer> i =
searchIndexBuilder.getContentProducers().iterator();
i.hasNext(); ) {
EntityContentProducer ecp = (EntityContentProducer) i.next();
Iterator<String> contentIterator = null;
contentIterator = ecp.getSiteContentIterator(siteContext);
log.debug("Using ECP " + ecp); // $NON-NLS-1$
int added = 0;
for (; contentIterator.hasNext(); ) {
if ((System.currentTimeMillis() - lastupdate) > 60000L) {
lastupdate = System.currentTimeMillis();
if (!worker.getLockTransaction(15L * 60L * 1000L, true)) {
throw new RuntimeException(
"Transaction Lock Expired while Rebuilding Index "); //$NON-NLS-1$
}
}
String resourceName = (String) contentIterator.next();
log.debug("Checking " + resourceName); // $NON-NLS-1$
if (resourceName == null || resourceName.length() > 255) {
log.warn(
"Entity Reference Longer than 255 characters, ignored: Reference=" //$NON-NLS-1$
+ resourceName);
continue;
}
SearchBuilderItem sbi = new SearchBuilderItemImpl();
sbi.setName(resourceName);
sbi.setSearchaction(SearchBuilderItem.ACTION_ADD);
sbi.setSearchstate(SearchBuilderItem.STATE_PENDING);
sbi.setId(UUID.randomUUID().toString());
sbi.setVersion(new Date(System.currentTimeMillis()));
sbi.setItemscope(SearchBuilderItem.ITEM);
String context = null;
try {
context = ecp.getSiteId(resourceName);
} catch (Exception ex) {
log.debug(
"No context for resource "
+ resourceName //$NON-NLS-1$
+ " defaulting to none"); //$NON-NLS-1$
}
if (context == null || context.length() == 0) {
context = "none"; // $NON-NLS-1$
}
sbi.setContext(context);
try {
updateOrSave(connection, sbi);
} catch (SQLException sqlex) {
log.error("Failed to update " + sqlex.getMessage()); // $NON-NLS-1$
}
connection.commit();
}
log.debug(" Added " + added); // $NON-NLS-1$
}
}
log.info(
"DONE ADD ALL RECORDS ==========================================================="); //$NON-NLS-1$
controlItem.setSearchstate(SearchBuilderItem.STATE_COMPLETED);
updateOrSave(connection, controlItem);
connection.commit();
} finally {
try {
stm.close();
} catch (Exception ex) {
log.debug(ex);
}
}
}