Defining connection session variables via database.yml

vipulnsward · October 4, 2014, 5:33am

I came across a use case where I needed provide session variables for
a connection.
For example some of these [1]. I see it was reported here [2] 5 years ago.

Would something like passing:

session_variables: time_zone=UTC,someVar=someValue

in the database.yml config be acceptable as a solution?

Thanks,

[1] http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
[2] https://rails.lighthouseapp.com/projects/8994/tickets/3579-activerecord-not-settingchecking-mysql-session-variable-time_zone

Vipul A.M.

Y_Thong_Kuah · October 4, 2014, 7:03am

This is already implemented as of 4.1

http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/MysqlAdapter.html

Cheers
Thong

Christian_Kruse1 · October 4, 2014, 8:02am

Hi,

vipulnsward · October 4, 2014, 4:57pm

It seems to already be implemented. Matthew pointed there is

github.com

rails/rails/blob/master/activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb#L825-L836


# frozen_string_literal: true


require "active_record/connection_adapters/abstract_adapter"
require "active_record/connection_adapters/statement_pool"
require "active_record/connection_adapters/mysql/column"
require "active_record/connection_adapters/mysql/explain_pretty_printer"
require "active_record/connection_adapters/mysql/quoting"
require "active_record/connection_adapters/mysql/schema_creation"
require "active_record/connection_adapters/mysql/schema_definitions"
require "active_record/connection_adapters/mysql/schema_dumper"
require "active_record/connection_adapters/mysql/schema_statements"
require "active_record/connection_adapters/mysql/type_metadata"


module ActiveRecord
  module ConnectionAdapters
    class AbstractMysqlAdapter < AbstractAdapter
      include MySQL::Quoting
      include MySQL::SchemaStatements


      ##

This file has been truncated. show original

and
I see https://github.com/rails/rails/commit/97d06e8c4bd44154abda41a3f7e4bc49929a919f
was implemented 2 years ago.
Although its not documented.

Sorry for the noise and thanks Matthew!
Vipul A.M.
+91-8149-204995