6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
# File 'lib/pg_party/hacks/postgresql_database_tasks.rb', line 6
def run_cmd(cmd, args, action)
if action != "dumping" || !PgParty.config.schema_exclude_partitions
return super
end
partitions = ActiveRecord::Base.connection.select_values(<<-SQL, "SCHEMA")
SELECT
inhrelid::regclass::text
FROM
pg_inherits
JOIN pg_class AS p ON inhparent = p.oid
WHERE p.relkind = 'p'
SQL
excluded_tables = partitions.flat_map { |table| ["-T", "*.#{table}"] }
super(cmd, args + excluded_tables, action)
end
|