lib/fx/adapters/postgres/triggers.rb in fx-0.2.0 vs lib/fx/adapters/postgres/triggers.rb in fx-0.3.0
- old
+ new
@@ -6,11 +6,11 @@
# Fetches defined triggers from the postgres connection.
# @api private
class Triggers
# The SQL query used by F(x) to retrieve the triggers considered
# dumpable into `db/schema.rb`.
- TRIGGERS_WITH_DEFINITIONS_QUERY = <<~SQL
+ TRIGGERS_WITH_DEFINITIONS_QUERY = <<-EOS.freeze
SELECT
pt.tgname AS name,
pg_get_triggerdef(pt.oid) AS definition
FROM pg_trigger pt
JOIN pg_class pc
@@ -18,10 +18,10 @@
JOIN pg_proc pp
ON (pp.oid = pt.tgfoid)
WHERE pt.tgname
NOT ILIKE '%constraint%' AND pt.tgname NOT ILIKE 'pg%'
ORDER BY pc.oid;
- SQL
+ EOS
# Wraps #all as a static facade.
#
# @return [Array<Fx::Trigger>]
def self.all(*args)