SP
Chhorn Chandy
Dear All,
RoR 🙂 can we use multiple database ?
Please share sample code.
Thanks
Rails 5.2.3
RoR 🙂 can we use multiple database ?
Please share sample code.
Thanks
Rails 5.2.3
Try this gem - https://github.com/thiagopradi/octopus
Size: a a a
2019 November 25
N
Спасибо всем за советы, ещё раз посмотрю в сторону js, когда доберусь до кода
C
Try this gem - https://github.com/thiagopradi/octopus
gem octopus support with rails 5 ?
ЕЗ
Chhorn Chandy
gem octopus support with rails 5 ?
Yep. Alternatively, you can try and update your Rails version. Rails 6 has multiple databases support natively.
C
Yep. Alternatively, you can try and update your Rails version. Rails 6 has multiple databases support natively.
OK. I try update 6.0.1.
Thanks.
Thanks.
A
class SecondDatabaseRecord < ActiveRecord::Base
self.abstract_class = true
establish_connection "#{Rails.env}_second_database".to_sym
end
You can use smth like that.
C
class SecondDatabaseRecord < ActiveRecord::Base
self.abstract_class = true
establish_connection "#{Rails.env}_second_database".to_sym
end
You can use smth like that.
It's work with Rails 5 ?
A
Chhorn Chandy
It's work with Rails 5 ?
yep.
C
Can we put in application_record ?
establish_connection "#{Rails.env}_second_database".to_symA
No, application_record will use your first database, second_database — second. Then you inherit model from second_database for tables there
AK
TableSecondDBDataClass <
SecondDatabaseRecordC
TableSecondDBDataClass <
SecondDatabaseRecordhmmm :)
АЛ
Nick
Спасибо всем за советы, ещё раз посмотрю в сторону js, когда доберусь до кода
Была оода пол назад такая же дичь с JS, скрипт ниже херил на оинке тип
C
No, application_record will use your first database, second_database — second. Then you inherit model from second_database for tables there
?
I got error : no implicit conversion of nil into String
I got error : no implicit conversion of nil into String
A
application_record.rb:
second_database_record.rb:
report.rb
user.rb
By the way, you can't mix ORM chains from both databases.
class ApplicationRecord < ActiveRecord::Base
self.abstract_class = true
end
second_database_record.rb:
class SecondDatabaseRecord < ActiveRecord::Base
self.abstract_class = true
establish_connection "#{Rails.env}_second_database".to_sym
end
report.rb
class Report < SecondDatabaseRecord
# blablabla
end
user.rb
class User < ApplicationRecord
# blablabla
end
By the way, you can't mix ORM chains from both databases.
A
Chhorn Chandy
?
I got error : no implicit conversion of nil into String
I got error : no implicit conversion of nil into String
u need to define connection strings to second database in database.yml
A
development_second_database:
host....
OB
Ребят, может у кого была проблема, webpacker падает из-за стилей? maximum call stack size exceeded webpack
C
u need to define connection strings to second database in database.yml
A
hmmm... try
Rails.env.present?
establish_connection :development_sec Rails.env.present?