blocks|key|604451|text|Rails.configuration.database_configuration|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|604452|这将为您提供一个哈希表，其中包含每个环境的配置。例如，要获取您的开发数据库名称：|unstyled|604453|Rails.configuration.database_configuration["development"]["database"]|604454|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre class="lang-rb prettyprint-override"><code>Rails.configuration.database_configuration
</code></pre>

This will give you a hash table with the configurations for each of your environments. E.g. to get your development database name:

<pre class="lang-rb prettyprint-override"><code>Rails.configuration.database_configuration["development"]["database"]
</code></pre>

blocks|key|604502|text|要利用来自tsherif的注释，您可以在rails控制台(rails+c)中运行Rails.configuration命令来获取数据库名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|604503|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

To piggyback on the comments from tsherif, you can run the Rails.configuration commands inside the rails console (rails c) to get the database names.

blocks|key|388538|text|在Rails+4.2中，您可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388539|ActiveRecord::Base.connection.current_database|code-block|syntax|javascript|388540|您还可以询问特定型号的数据库(因为每个型号可以使用不同的数据库)：|388541|User.connection.current_database|388542|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 4.2, you can do this:

<pre><code>ActiveRecord::Base.connection.current_database
</code></pre>

You can also ask specific models for their database (since it's possible to use different databases per model):

<pre><code>User.connection.current_database
</code></pre>

blocks|key|388595|text|获取更多信息的另一种方法是使用数据库特定的连接信息方法。例如，如果您使用的是postgresql，则可以使用以下命令获取当前数据库连接的详细信息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|388596|ActiveRecord::Base.connection.raw_connection.conninfo_hash|code-block|syntax|javascript|388597|这将提供更多的连接细节，而不仅仅是那些与默认值不同的细节。|388598|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

An additional way to get more iformation is to use the database specific connection info methods. For example, if you are using postgresql, you can get details for the current database connection with:

<pre><code>ActiveRecord::Base.connection.raw_connection.conninfo_hash
</code></pre>

This will give more connection details, not only those that differ from defaults.

blocks|key|604715|text|如果想要获取在bash或shell脚本中使用的数据库名称，请使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|604716|db_name="$(bundle+exec+rails+runner+"puts+ActiveRecord::Base.connection.current_database")"|code-block|syntax|javascript|604717|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|$]]

If you want to get the database name for use within a bash or shell script then use the following:
<pre class="lang-sh prettyprint-override"><code>db_name=&quot;$(bundle exec rails runner &quot;puts ActiveRecord::Base.connection.current_database&quot;)&quot;
</code></pre>

blocks|key|604764|text|从Rails6.1开始，你必须使用ActiveRecord::Base.connection_db_config。因此，您可以访问其他类方法，如database()。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|604765|db_config+=+ActiveRecord::Base.connection_db_config
print+db_config.database
#+main+available+methods:+[:host,+:schema_cache_path,+:migrations_paths,+:config,+:database,+:_database=,+:checkout_timeout,+:reaping_frequency,+:idle_timeout,+:replica?,+:configuration_hash,+:adapter,+:pool]|code-block|syntax|javascript|604766|entityMap^0|H|13|20|A|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

Since Rails 6.1 you must use <code>ActiveRecord::Base.connection_db_config</code>. So you can access the others class methods, like <code>database()</code>.
<pre><code>db_config = ActiveRecord::Base.connection_db_config
print db_config.database
# main available methods: [:host, :schema_cache_path, :migrations_paths, :config, :database, :_database=, :checkout_timeout, :reaping_frequency, :idle_timeout, :replica?, :configuration_hash, :adapter, :pool]
</code></pre>

In database.yml you define all the settings. How can I access those settings from ruby? I've looked in <code>App::Application::config</code>, but can't find it there. Also, I remember people were able to configure database settings without yaml, does anyone know how?

how to check the database name that ActiveRecord uses

数据库

在database.yml中，您可以定义所有设置。如何从ruby访问这些设置？我在App::Application::config里找过了，但是找不到。另外，我记得人们可以在没有yaml的情况下配置数据库设置，有人知道怎么做吗？

问如何检查ActiveRecord使用的数据库名称
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何检查ActiveRecord使用的数据库名称EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何检查ActiveRecord使用的数据库名称
EN