Multi Tenancy

Changing databases at the connection level

You may use NoBrainer.run_with(:db => 'db_name') to change the default database to use on the connection.

NoBrainer.run_with(:db => 'client1') do
  Project.each { ... }
end

Typically, run_with() blocks are implemented as around filters on controllers, or rack middlewares.

Model specific behavior

With NoBrainer you may specify which Model gets stored where with the table_config declaration. For example, to store the User model in some_table:

class Project
  table_config :name => 'some_table'
end

You may also use lazily evaluated lambdas. For example:

class Project
  table_config :name => ->{ "project_#{Thread.current[:client]}" }
end

For introspection, you may use Model.table_name to retreive the computed table name.

Managing Databases

NoBrainer does not automatically create indexes when auto creating a database or table. To create the indexes on a custom database, you may use the following:

NoBrainer.run_with(:db => 'db_name') { NoBrainer.sync_schema }

Make sure all your models are loaded before calling sync_schema if you are not using Rails.