Module: Listable::ConnectionAdapters::SchemaStatements

Defined in:
lib/listable/connection_adapters.rb

Instance Method Summary collapse

Instance Method Details

#create_view(view_name, queries) ⇒ Object 



5
6
7
8
9
10
11
 
# File 'lib/listable/connection_adapters.rb', line 5

def create_view(view_name, queries)
  create_sql = "CREATE VIEW #{view_name.to_s.pluralize} AS "
  queries.map!(&:to_sql) # Compile the arel queries to sql
  create_sql << queries * ' UNION ' # Combines the queries with union

  execute create_sql
end

#drop_view(view_name) ⇒ Object 



13
14
15
 
# File 'lib/listable/connection_adapters.rb', line 13

def drop_view(view_name)
  execute "DROP VIEW #{view_name}"
end