Module: SchemaPlusMultischema::Middleware::PostgreSQL::Schema::Tables

Defined in:
lib/schema_plus_multischema/middleware.rb

Instance Method Summary collapse

Instance Method Details

#implement(env) ⇒ Object 



10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/schema_plus_multischema/middleware.rb', line 10

def implement(env)
  use_prefix = (env.connection.schema_search_path != DEFAULT_SCHEMA_SEARCH_PATH)
  query = "    SELECT schemaname, tablename\n    FROM pg_tables\n    WHERE schemaname = ANY(current_schemas(false))\n  SQL\n  env.tables += env.connection.exec_query(query, 'SCHEMA').map { |row|\n    if use_prefix\n      \"\#{row['schemaname']}.\#{row['tablename']}\"\n    else\n      row['tablename']\n    end\n  }\nend\n"