blocks|key|1661699|text|在rails中，您可以创建一个configuration对象并从中获取必要的信息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1661700|config+++=+Rails.configuration.database_configuration
host+++++=+config[Rails.env]["host"]
database+=+config[Rails.env]["database"]
username+=+config[Rails.env]["username"]
password+=+config[Rails.env]["password"]|code-block|syntax|javascript|1661701|有关详细信息，请参阅documentation+for+Rails::Configuration。|offset|length|1661702|这只是使用YAML::load从数据库配置文件(database.yml)加载配置，您可以自己使用该文件从rails环境外部获取信息：|style|CODE|1661703|require+'YAML'
info+=+YAML::load(IO.read("database.yml"))
print+info["production"]["host"]
print+info["production"]["database"]
...|1661704|entityMap|0|LINK|mutability|MUTABLE|url|http://api.rubyonrails.org/classes/Rails/Configuration.html|1|http://www.ruby-doc.org/core/classes/YAML.html^0|0|0|A|D|0|0|O|C|5|A|1|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@$I|13|J|14|1|15]]|A|$]]|$1|K|3|L|5|6|7|16|8|@$I|17|J|18|M|N]]|9|@$I|19|J|1A|1|1B]]|A|$]]|$1|O|3|P|5|D|7|1C|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

From within rails you can create a configuration object and obtain the necessary information from it:

<pre><code>config = Rails.configuration.database_configuration
host = config[Rails.env]["host"]
database = config[Rails.env]["database"]
username = config[Rails.env]["username"]
password = config[Rails.env]["password"]
</code></pre>

See the <a href="http://api.rubyonrails.org/classes/Rails/Configuration.html" rel="noreferrer">documentation</a> for Rails::Configuration for details.

This just uses <a href="http://www.ruby-doc.org/core/classes/YAML.html" rel="noreferrer">YAML::load</a> to load the configuration from the database configuration file (<code>database.yml</code>) which you can use yourself to get the information from outside the rails environment:

<pre><code>require 'YAML'
info = YAML::load(IO.read("database.yml"))
print info["production"]["host"]
print info["production"]["database"]
...
</code></pre>

blocks|key|1447028|text|Bryan在上面的评论中的回答值得更多的关注：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1447029|>>+Rails.configuration.database_configuration[Rails.env]
=>+{"encoding"=>"unicode",+"username"=>"postgres",+"adapter"=>"postgresql",+"port"=>5432,+"host"=>"localhost",+"password"=>"postgres",+"database"=>"mydb",+"pool"=>5}|code-block|syntax|javascript|1447030|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Bryan's answer in the comment above deserves a little more exposure:

<pre><code>&gt;&gt; Rails.configuration.database_configuration[Rails.env]
=&gt; {"encoding"=&gt;"unicode", "username"=&gt;"postgres", "adapter"=&gt;"postgresql", "port"=&gt;5432, "host"=&gt;"localhost", "password"=&gt;"postgres", "database"=&gt;"mydb", "pool"=&gt;5}
</code></pre>

blocks|key|1661896|text|我认为这是最简单的解决方案。经过一些测试(至少在Rails+5.2中)，这将正确地解析DATABASE_URL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1661897|+ActiveRecord::Base.configurations[Rails.env]|code-block|syntax|javascript|1661898|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I think this is the simplest solution. After some testing (in Rails 5.2 at least) this will resolve DATABASE_URL correctly.

<pre><code> ActiveRecord::Base.configurations[Rails.env]
</code></pre>

blocks|key|1661937|text|从Rails6.1开始，ActiveRecord::Base.connection_config就被弃用了。新的合适的方法是通过ActiveRecord::Base.connection_db_config|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1661938|ActiveRecord::Base.connection_config+=>+#<ActiveRecord::DatabaseConfigurations::HashConfig+@env_name="development",+@name="primary",+@configuration_hash={:adapter=>"mysql2",+:encoding=>"utf8mb4",+:database=>"your-db-name",+:pool=>5,+:host=>"127.0.0.1",+:username=>"root",+:password=>nil,+:socket=>"/var/run/mysqld/mysqld.sock"}>|code-block|syntax|javascript|1661939|你会得到一个ActiveRecord::DatabaseConfigurations::HashConfig+object。|1661940|entityMap|0|LINK|mutability|MUTABLE|url|https://api.rubyonrails.org/classes/ActiveRecord/DatabaseConfigurations/HashConfig.html^0|C|10|1S|13|0|0|6|1J|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

As of Rails 6.1 <code>ActiveRecord::Base.connection_config</code> is deprecated. The new proper way to do this is via <code>ActiveRecord::Base.connection_db_config</code>
<pre class="lang-rb prettyprint-override"><code>ActiveRecord::Base.connection_config =&gt; #&lt;ActiveRecord::DatabaseConfigurations::HashConfig @env_name=&quot;development&quot;, @name=&quot;primary&quot;, @configuration_hash={:adapter=&gt;&quot;mysql2&quot;, :encoding=&gt;&quot;utf8mb4&quot;, :database=&gt;&quot;your-db-name&quot;, :pool=&gt;5, :host=&gt;&quot;127.0.0.1&quot;, :username=&gt;&quot;root&quot;, :password=&gt;nil, :socket=&gt;&quot;/var/run/mysqld/mysqld.sock&quot;}&gt;
</code></pre>
And you will get a <a href="https://api.rubyonrails.org/classes/ActiveRecord/DatabaseConfigurations/HashConfig.html" rel="nofollow noreferrer">ActiveRecord::DatabaseConfigurations::HashConfig object</a> back.

blocks|key|1661858|text|老问题，但这是我查找如何做到这一点的第一站之一，所以我认为这可能会对其他人有所帮助。我通常在主目录中有.my.cnf文件。所以在我的database.yml配置文件中使用'parseconfig‘gem和一些ERB语法意味着我已经有了动态文件，我可以很好地签入到源代码管理中，也可以简化部署(在我的例子中)。还要注意通用套接字的列表，这使得将我的应用程序移动到可能具有不同Unix套接字路径的不同操作系统变得更容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1661859|<%25+
++++require+'parseconfig'
++++c=ParseConfig.new('../../.my.cnf')+%25>

mysqlevn:+&mysql
++adapter:+mysql+
++username:+<%25=+c.params['client']['user']+%25>
++password:+<%25=+c.params['client']['password']+%25>
++host:+localhost+
++socket:+<%25=+[+
++'/var/run/mysqld/mysqld.sock',
++'/var/lib/mysql/mysql.sock',
++'/tmp/mysqld.sock',
++'/tmp/mysql.sock'].detect+{+%7Csocket%7C+File.exist?(socket)+}+%25>

production:
++database:+app_production
++<<:+*mysql


development:
++database:+app_development+
++<<:+*mysql

#+Do+not+set+this+db+to+the+same+as+development+or+production.
test:
++database:+app_test
++<<:+*mysql|code-block|syntax|javascript|1661860|参考：http://effectif.com/articles/database-yml-should-be-checked-in|offset|length|1661861|entityMap|0|LINK|mutability|MUTABLE|url|http://effectif.com/articles/database-yml-should-be-checked-in^0|0|0|3|1Q|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Old question but this was one of my first stops in looking up how to do this so I figure this may help someone else. I normally have .my.cnf files in the home directory. So using the 'parseconfig' gem and some ERB syntax in my database.yml config file means I've got dynamic file that I can feel good about checking into source control and also simplify deployments (in my case). Also note the list of common sockets, this makes it easier to move my app to different operating systems that might have a different Unix socket path.

<pre><code>&lt;% 
 require 'parseconfig'
 c=ParseConfig.new('../../.my.cnf') %&gt;

mysqlevn: &amp;mysql
 adapter: mysql 
 username: &lt;%= c.params['client']['user'] %&gt;
 password: &lt;%= c.params['client']['password'] %&gt;
 host: localhost 
 socket: &lt;%= [ 
 '/var/run/mysqld/mysqld.sock',
 '/var/lib/mysql/mysql.sock',
 '/tmp/mysqld.sock',
 '/tmp/mysql.sock'].detect { |socket| File.exist?(socket) } %&gt;

production:
 database: app_production
 &lt;&lt;: *mysql


development:
 database: app_development 
 &lt;&lt;: *mysql

# Do not set this db to the same as development or production.
test:
 database: app_test
 &lt;&lt;: *mysql
</code></pre>

ref: <a href="http://effectif.com/articles/database-yml-should-be-checked-in" rel="nofollow">http://effectif.com/articles/database-yml-should-be-checked-in</a>

blocks|key|1661950|text|在Rails+6.1%2B中，您可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1661951|ActiveRecord::Base.connection_db_config.configuration_hash|code-block|syntax|javascript|1661952|这将返回一个包含当前环境的连接信息的散列：|1661953|{
++:adapter=>"postgresql",
++:encoding=>"utf8",
++:min_messages=>"WARNING",
++:host=>"localhost",
++:username=>"postgres",
++:password=>"P@ssw0rd",
++:port=>5432,
++:database=>"my_app_development"
}|1661954|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

In Rails 6.1+, you can use:
<pre><code>ActiveRecord::Base.connection_db_config.configuration_hash
</code></pre>
This returns a hash containing the current environment's connection information:
<pre><code>{
 :adapter=&gt;&quot;postgresql&quot;,
 :encoding=&gt;&quot;utf8&quot;,
 :min_messages=&gt;&quot;WARNING&quot;,
 :host=&gt;&quot;localhost&quot;,
 :username=&gt;&quot;postgres&quot;,
 :password=&gt;&quot;P@ssw0rd&quot;,
 :port=&gt;5432,
 :database=&gt;&quot;my_app_development&quot;
}
</code></pre>

I'm writing a rake task that does some DB work outside of Rails/ActiveRecord.

Is there a way to get the DB connection info (host, username, password, DB name) for the current environment as defined in <code>database.yml</code>?

I'd like to get it so I can use it to connect like this...

<pre><code>con = Mysql.real_connect("host", "user", "pw", "current_db")
</code></pre>

Can you get DB username, pw, database name in Rails?

我正在编写一个rake任务，它在Rails/ActiveRecord之外执行一些DB工作。是否有办法获取database.yml中定义的当前环境的数据库连接信息(主机、用户名、密码、数据库名称我想得到它，这样我就可以用它来连接了。con = Mysql.real_connect("host", "user", "pw", "current_db")

问你能在Rails中获得DB用户名，pw，数据库名吗？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问你能在Rails中获得DB用户名，pw，数据库名吗？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问你能在Rails中获得DB用户名，pw，数据库名吗？
EN