PostgreSQLですべてのデータを削除する

DatabaseCleaner.groovy

import groovy.sql.Sql

class DatabaseCleaner {

    static excludes = ["databasechangelog", "databasechangeloglock"]

    static clean(sql) {
        // テーブルデータの削除
        sql.eachRow("SELECT tablename FROM pg_tables WHERE schemaname = 'public';") { row ->
            if (row.tablename in excludes) return
            sql.executeUpdate("TRUNCATE TABLE ${row.tablename} CASCADE;".toString())
        }
        // シーケンスの初期化
        sql.eachRow("SELECT relname AS sequnence_name FROM pg_class WHERE relkind = 'S';") { row ->
            sql.execute("SELECT setval('${row.sequnence_name}', (SELECT start_value FROM ${row.sequnence_name}), false);".toString())
        }
    }

}