James Harker's Profile

Comments by James Harker

James Harker on #389 Multitenancy with PostgreSQL (pro) 2013-05-07 08:56:08

I eventually went with something like this. Works well for me.

          ruby
        
  def create_schema()
    original_search_path = connection.schema_search_path
    connection.execute("create schema tennant#{id}")
    connection.schema_search_path = "tennant#{id},public"
    structure_sql = open("#{Rails.root}/db/structure.sql", 'r').read
    structure_sql = structure_sql.gsub("SET search_path = public, pg_catalog;", "") # Remove line from SQL dump file
    connection.execute(structure_sql)
    connection.execute("drop table my_table")
    ensure
      return connection.schema_search_path = original_search_path
  end

James Harker on #389 Multitenancy with PostgreSQL (pro) 2012-11-11 08:12:08

Thanks for the tip.

James Harker on #389 Multitenancy with PostgreSQL (pro) 2012-11-06 07:02:07

Has anyone figured out how to do this if you're also using hstore?
I can't work out how to replace:

          ruby
        
load Rails.root.join("db/schema.rb")

with a similar line that will load and execute the file db/structure.sql instead.