Class: OsmImport::Target::PgViews::TargetView

Inherits:
TargetEntry
  • Object
show all
Defined in:
lib/osm_import/target/pg_views.rb

Instance Method Summary collapse

Instance Method Details

#create! ⇒ Object 



37
38
39
40
41
 
# File 'lib/osm_import/target/pg_views.rb', line 37

def create!
  return if table.type_mapper.mappings.empty?

  conn.exec "CREATE VIEW #{name} AS SELECT #{geometry_expr} AS geometry, #{fields.keys.map{|k| "#{assigns[k]} AS #{k}"}.join(',')} FROM #{target.raw_prefix}#{table.type.gsub('multi','')} src WHERE #{conditions.join(' AND ')}"
end

#drop! ⇒ Object 



33
34
35
 
# File 'lib/osm_import/target/pg_views.rb', line 33

def drop!
  conn.exec "DROP VIEW IF EXISTS #{name}"
end