org.h2.fulltext

Class FullText.FullTextTrigger

java.lang.Object

org.h2.fulltext.FullText.FullTextTrigger

All Implemented Interfaces:

Trigger

Enclosing class:

FullText

public static 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 and Description
protected int[]	columnTypes
protected IndexInfo	index
protected PreparedStatement	prepDeleteMap
protected PreparedStatement	prepDeleteRow
protected PreparedStatement	prepInsertMap
protected PreparedStatement	prepInsertRow
protected PreparedStatement	prepInsertWord
protected PreparedStatement	prepSelectRow
protected FullTextSettings	setting

Fields inherited from interface org.h2.api.Trigger

DELETE, INSERT, SELECT, UPDATE

Constructor Summary

Constructors

Constructor and Description
FullText.FullTextTrigger()

Method Summary

Methods

Modifier and Type	Method and Description
void	close() INTERNAL
protected void	delete(Object[] row) Delete a row from the index.
void	fire(Connection conn, Object[] oldRow, Object[] newRow) INTERNAL
void	init(Connection conn, String schemaName, String triggerName, String tableName, boolean before, int type) INTERNAL
protected void	insert(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 Detail

setting

protected FullTextSettings setting

index

protected IndexInfo index

columnTypes

protected int[] columnTypes

prepInsertWord

protected PreparedStatement prepInsertWord

prepInsertRow

protected PreparedStatement prepInsertRow

prepInsertMap

protected PreparedStatement prepInsertMap

prepDeleteRow

protected PreparedStatement prepDeleteRow

prepDeleteMap

protected PreparedStatement prepDeleteMap

prepSelectRow

protected PreparedStatement prepSelectRow

Constructor Detail

FullText.FullTextTrigger

public FullText.FullTextTrigger()

Method Detail

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

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

close

public void close()

INTERNAL

Specified by:

close in interface Trigger

remove

public void remove()

INTERNAL

Specified by:

remove in interface Trigger

insert

protected void insert(Object[] row)
               throws SQLException

Add a row to the index.

Parameters:

row - the row

Throws:

SQLException

delete

protected void delete(Object[] row)
               throws SQLException

Delete a row from the index.

Parameters:

row - the row

Throws:

SQLException