Class SearchDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.fulltext.dao.SearchDAO

public class SearchDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields

Modifier and Type	Field	Description
static final String	TABLE

Fields inherited from class CommonDAO

con, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
SearchDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	delete(String objectType, int objectId)	Deletes the record about the object
void	delete(SearchItem item)	Deletes the record about the object
List<SearchItem>	getScheduledUpdates(int secondsOld, int maxCount)	Selects records that need to be updated
void	init(String objectType, String objectTable)	Initializes indexing for object types
void	scheduleUpdate(String objectType, int objectId)	Marks the object as needing an update
void	searchCustomer(Pageable<Customer> result, String filter)	Full-text search of customers
void	searchMessages(Pageable<Pair<Message,Process>> result, String filter)	Full-text search of messages linked to processes
void	searchProcess(Pageable<Process> result, String filter)	Full-text search of processes
void	update(SearchItem item)	Updates the searchable text of the record

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

TABLE

public static final String TABLE

See Also:

• Constant Field Values

Constructor Details

SearchDAO

public SearchDAO(Connection con)

Method Details

searchCustomer

public void searchCustomer(Pageable<Customer> result,
 String filter)
                    throws SQLException

Full-text search of customers

Parameters:

result - the search result

filter - query string with + and - symbols for adding / removing words

Throws:

SQLException

searchProcess

public void searchProcess(Pageable<Process> result,
 String filter)
                   throws SQLException

Full-text search of processes

Parameters:

result - the search result

filter - query string with + and - symbols for adding / removing words

Throws:

SQLException

searchMessages

public void searchMessages(Pageable<Pair<Message,Process>> result,
 String filter)
                    throws SQLException

Full-text search of messages linked to processes

Parameters:

result - the search result

filter - query string with + and - symbols for adding / removing words

Throws:

SQLException

scheduleUpdate

public void scheduleUpdate(String objectType,
 int objectId)
                    throws SQLException

Marks the object as needing an update

Parameters:

objectType - the object type

objectId - the object ID

Throws:

SQLException

delete

public void delete(String objectType,
 int objectId)

Deletes the record about the object

Parameters:

objectType - the object type

objectId - the object ID

delete

public void delete(SearchItem item)

Deletes the record about the object

Parameters:

item - the search item

getScheduledUpdates

public List<SearchItem> getScheduledUpdates(int secondsOld,
 int maxCount)

Selects records that need to be updated

Parameters:

secondsOld - the object's last change was more than this many seconds ago

maxCount - the maximum count

update

public void update(SearchItem item)

Updates the searchable text of the record

Parameters:

item - the search item

init

public void init(String objectType,
 String objectTable)
          throws SQLException

Initializes indexing for object types

Parameters:

objectType - the object type

objectTable - the object table name

Throws:

SQLException