On Saturday, January 7, 2017 at 9:36:01 AM UTC-8, Junaid Farooq wrote:
>
> We have added Sequel as PostgreSQL adapter in our Rails app. and
> initialized it in initializers as
>
> require 'evercam_misc'
>
> DB = Sequel::Model.db = Sequel.connect(ENV['DATABASE_URL'],
> max_connections: 100)
> Sequel::Model.db.sql_log_level = Rails.application.config.log_level ||
> :debug
>
> if ARGV.any? {|parameter| parameter =~ /(--sandbox|-s)/}
> # Do everything inside a transaction when using rails c --sandbox (or
> -s).
> DB.pool.after_connect = proc do |connection|
> DB.send(:add_transaction, connection, {})
> DB.send(:begin_transaction, connection, {})
> end
> end
>
> # Connection created, pull in the model classes.
> require 'evercam_models'
>
>
> But there is another model for which I want it to connect to separate DB.
> Is that possible to do that for only one Sequel model which is
>
>
> require 'active_support/core_ext/object/blank'
> class CameraActivity < Sequel::Model
> end
>
> The DB to which i want it to connect is
>
> ENV['SNAPSHOT_DATABASE_URL']
>
This should work:
class CameraActivity <
Sequel::Model(Sequel.connect(ENV['SNAPSHOT_DATABASE_URL'])[:camera_activities])
end
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
