I have an application I am trying to develop that requires communicating with two databases, an internal database for application specific configuration (postgres) and a legacy database (mysql).
When I created my new application I initially specified --database=postgres.
So I have two questions?
(a) How would can I initialize a new adaptor (Cannot instantiate adapter of Lotus::Model::Adapters::SqlAdapter -- mysql)?
(b) How would I go about defining both these adaptors in lib/my_application.rb?(what I currently have)
adapter type: :sql, uri: ENV['TEST_ANALYTICS_DATABASE_URL']
adapter type: :sql, uri: ENV['LEGACY_GENIE_URL']