Sha256: 75f7ffb5e6dd469f02aaeece8044a07e6a048190de642f92b044e0c85176951d
Contents?: true
Size: 1.09 KB
Versions: 10
Compression:
Stored size: 1.09 KB
Contents
class CreateFunctionToRenderAuditViewAsJson < ActiveRecord::Migration[5.1]
def up
sql = <<-SQL.squish
CREATE OR REPLACE FUNCTION audit_view_as_json(view_name text)
/*
Converts the specified view into its json representation suitable for feeding for example
into jQuery datatables plugin, or creating a historical snapshot.
Example usage:
select audit_view_as_json('reporting_bone_audit')
TC 1.11.2017
*/
RETURNS json
LANGUAGE 'plpgsql'
as $$
DECLARE result json;
BEGIN
EXECUTE format('
select row_to_json(t)
from (
select
current_timestamp as runat,
(select array_to_json(array_agg(row_to_json(d))
)
from (select * from %s) d) as data) t;
', quote_ident(view_name)) into result;
return result;
END
$$;
SQL
ActiveRecord::Base.connection.execute(sql)
end
def down
ActiveRecord::Base.connection.execute(
"DROP FUNCTION IF EXISTS audit_view_as_json(text);"
)
end
end
Version data entries
10 entries across 10 versions & 1 rubygems