class PG::FTS::Index::Self
Attributes
catalog[R]
document[R]
fields[R]
foreign_key[R]
key[R]
name[R]
source[R]
table[R]
Public Class Methods
new(table, *fields, key: nil, catalog: nil, as: nil)
click to toggle source
# File lib/pg/fts/index/self.rb, line 11 def initialize(table, *fields, key: nil, catalog: nil, as: nil) @table = table @fields = fields @key = key || :id @catalog = catalog || PG::FTS.catalog @name = as end
Public Instance Methods
build_query()
click to toggle source
# File lib/pg/fts/index/self.rb, line 19 def build_query <<-SQL.gsub(/^ {4}/, '') INSERT INTO "#{PG::FTS.table}" ( "document_id", "document_table", "source_id", "source_table", "tsv") SELECT "#{document}"."#{key}", '#{document}', "#{source}"."#{key}", '#{source}', #{ts_vector(source)} FROM "#{document}"; SQL end
on_document_delete_procedure()
click to toggle source
# File lib/pg/fts/index/self.rb, line 95 def on_document_delete_procedure <<-SQL.gsub(/^ {4}/, '') CREATE FUNCTION "#{on_document_delete_procedure_name}"() RETURNS TRIGGER AS $$ BEGIN #{on_document_delete_query.gsub(/^/, ' ')} RETURN OLD; END; $$ LANGUAGE plpgsql; SQL end
on_document_delete_query()
click to toggle source
# File lib/pg/fts/index/self.rb, line 85 def on_document_delete_query <<-SQL.gsub(/^ {4}/, '') DELETE FROM "#{PG::FTS.table}" WHERE "#{PG::FTS.table}"."source_id" = OLD."#{key}" AND "#{PG::FTS.table}"."source_table" = '#{source}' AND "#{PG::FTS.table}"."document_id" = OLD."#{key}" AND "#{PG::FTS.table}"."document_table" = '#{document}'; SQL end
on_document_delete_trigger()
click to toggle source
# File lib/pg/fts/index/self.rb, line 143 def on_document_delete_trigger <<-SQL.gsub(/^ {4}/, '') CREATE TRIGGER "#{on_document_delete_trigger_name}" AFTER DELETE ON "#{document}" FOR EACH ROW EXECUTE PROCEDURE "#{on_document_delete_procedure_name}"(); SQL end
on_document_insert_procedure()
click to toggle source
# File lib/pg/fts/index/self.rb, line 53 def on_document_insert_procedure <<-SQL.gsub(/^ {4}/, '') CREATE FUNCTION "#{on_document_insert_procedure_name}"() RETURNS TRIGGER AS $$ BEGIN #{on_document_insert_query.gsub(/^/, ' ')} RETURN NEW; END; $$ LANGUAGE plpgsql; SQL end
on_document_insert_query()
click to toggle source
# File lib/pg/fts/index/self.rb, line 36 def on_document_insert_query <<-SQL.gsub(/^ {4}/, '') INSERT INTO "#{PG::FTS.table}" ( "document_id", "document_table", "source_id", "source_table", "tsv") VALUES ( NEW."#{key}", '#{document}', NEW."#{key}", '#{source}', #{ts_vector}); SQL end
on_document_insert_trigger()
click to toggle source
# File lib/pg/fts/index/self.rb, line 125 def on_document_insert_trigger <<-SQL.gsub(/^ {4}/, '') CREATE TRIGGER "#{on_document_insert_trigger_name}" AFTER INSERT ON "#{document}" FOR EACH ROW EXECUTE PROCEDURE "#{on_document_insert_procedure_name}"(); SQL end
on_document_truncate_procedure()
click to toggle source
# File lib/pg/fts/index/self.rb, line 114 def on_document_truncate_procedure <<-SQL.gsub(/^ {4}/, '') CREATE FUNCTION "#{on_document_truncate_procedure_name}"() RETURNS TRIGGER AS $$ BEGIN #{on_document_truncate_query.gsub(/^/, ' ')} RETURN NULL; END; $$ LANGUAGE plpgsql; SQL end
on_document_truncate_query()
click to toggle source
# File lib/pg/fts/index/self.rb, line 106 def on_document_truncate_query <<-SQL.gsub(/^ {4}/, '') DELETE FROM "#{PG::FTS.table}" WHERE "#{PG::FTS.table}"."source_table" = '#{source}' AND "#{PG::FTS.table}"."document_table" = '#{document}'; SQL end
on_document_truncate_trigger()
click to toggle source
# File lib/pg/fts/index/self.rb, line 152 def on_document_truncate_trigger <<-SQL.gsub(/^ {4}/, '') CREATE TRIGGER "#{on_document_truncate_trigger_name}" AFTER TRUNCATE ON "#{document}" FOR EACH STATEMENT EXECUTE PROCEDURE "#{on_document_truncate_procedure_name}"(); SQL end
on_document_update_procedure()
click to toggle source
# File lib/pg/fts/index/self.rb, line 74 def on_document_update_procedure <<-SQL.gsub(/^ {4}/, '') CREATE FUNCTION "#{on_document_update_procedure_name}"() RETURNS TRIGGER AS $$ BEGIN #{on_document_update_query.gsub(/^/, ' ')} RETURN NEW; END; $$ LANGUAGE plpgsql; SQL end
on_document_update_query()
click to toggle source
# File lib/pg/fts/index/self.rb, line 64 def on_document_update_query <<-SQL.gsub(/^ {4}/, '') UPDATE "#{PG::FTS.table}" SET "tsv" = (#{ts_vector}) WHERE "#{PG::FTS.table}"."source_id" = NEW."#{key}" AND "#{PG::FTS.table}"."source_table" = '#{source}' AND "#{PG::FTS.table}"."document_id" = NEW."#{key}" AND "#{PG::FTS.table}"."document_table" = '#{document}'; SQL end
on_document_update_trigger()
click to toggle source
# File lib/pg/fts/index/self.rb, line 134 def on_document_update_trigger <<-SQL.gsub(/^ {4}/, '') CREATE TRIGGER "#{on_document_update_trigger_name}" AFTER UPDATE ON "#{document}" FOR EACH ROW EXECUTE PROCEDURE "#{on_document_update_procedure_name}"(); SQL end