Package org.h2.fulltext

Class FullText.FullTextTrigger

java.lang.Object

org.h2.fulltext.FullText.FullTextTrigger

All Implemented Interfaces:

Trigger

Enclosing class:

FullText

public static final class FullText.FullTextTrigger
extends Object
implements Trigger

Trigger updates the index when a inserting, updating, or deleting a row.

Field Summary

Fields

Modifier and Type	Field	Description
private int[]	columnTypes
private static final int	DELETE_MAP
private static final int	DELETE_ROW
private IndexInfo	index
private static final int	INSERT_MAP
private static final int	INSERT_ROW
private static final int	INSERT_WORD
private static final int	SELECT_ROW
private FullTextSettings	setting
private static final String[]	SQL

Fields inherited from interface org.h2.api.Trigger

DELETE, INSERT, SELECT, UPDATE

Constructor Summary

Constructors

Constructor	Description
FullTextTrigger()

Method Summary

Modifier and Type	Method	Description
void	close()	INTERNAL
private void	delete(Connection conn, Object[] row)	Delete a row from the index.
void	fire(Connection conn, Object[] oldRow, Object[] newRow)	INTERNAL
private String	getKey(Object[] row)
private static PreparedStatement	getStatement(Connection conn, int index)
private int[]	getWordIds(Connection conn, Object[] row)
void	init(Connection conn, String schemaName, String triggerName, String tableName, boolean before, int type)	INTERNAL
private void	insert(Connection conn, Object[] row)	Add a row to the index.
void	remove()	INTERNAL

Methods inherited from class java.lang.Object

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

Field Details

setting

private FullTextSettings setting

index

private IndexInfo index

columnTypes

private int[] columnTypes

INSERT_WORD

private static final int INSERT_WORD

See Also:

• Constant Field Values

INSERT_ROW

private static final int INSERT_ROW

See Also:

• Constant Field Values

INSERT_MAP

private static final int INSERT_MAP

See Also:

• Constant Field Values

DELETE_ROW

private static final int DELETE_ROW

See Also:

• Constant Field Values

DELETE_MAP

private static final int DELETE_MAP

See Also:

• Constant Field Values

SELECT_ROW

private static final int SELECT_ROW

See Also:

• Constant Field Values

SQL

private static final String[] SQL

Constructor Details

FullTextTrigger

public FullTextTrigger()

Method Details

init

public void init(Connection conn,
 String schemaName,
 String triggerName,
 String tableName,
 boolean before,
 int type)
          throws SQLException

INTERNAL

Specified by:

init in interface Trigger

Parameters:

conn - a connection to the database (a system connection)

schemaName - the name of the schema

triggerName - the name of the trigger used in the CREATE TRIGGER statement

tableName - the name of the table

before - whether the fire method is called before or after the operation is performed

type - the operation type: INSERT, UPDATE, DELETE, SELECT, or a combination (this parameter is a bit field)

Throws:

SQLException - on SQL exception

See Also:

• Trigger.init(Connection, String, String, String, boolean, int)

fire

public void fire(Connection conn,
 Object[] oldRow,
 Object[] newRow)
          throws SQLException

INTERNAL

Specified by:

fire in interface Trigger

Parameters:

conn - a connection to the database

oldRow - the old row, or null if no old row is available (for INSERT)

newRow - the new row, or null if no new row is available (for DELETE)

Throws:

SQLException - if the operation must be undone

See Also:

• Trigger.fire(Connection, Object[], Object[])

close

public void close()

INTERNAL

Specified by:

close in interface Trigger

remove

public void remove()

INTERNAL

Specified by:

remove in interface Trigger

insert

private void insert(Connection conn,
 Object[] row)
             throws SQLException

Add a row to the index.

Parameters:

conn - to use

row - the row

Throws:

SQLException - on failure

delete

private void delete(Connection conn,
 Object[] row)
             throws SQLException

Delete a row from the index.

Parameters:

conn - to use

row - the row

Throws:

SQLException - on failure

getWordIds

private int[] getWordIds(Connection conn,
 Object[] row)
                  throws SQLException

Throws:

SQLException

getKey

private String getKey(Object[] row)
               throws SQLException

Throws:

SQLException

getStatement

private static PreparedStatement getStatement(Connection conn,
 int index)
                                       throws SQLException

Throws:

SQLException