Help me on how to

Rails
1

i want to check the given mysql database is exists or not using rails…
i searched the net and found the below
SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME =
‘testdb’
this is works in query browser.

like wise i can i check in rails …
pls guide me on this

2

Hi
Is it the db details you specified in database.yml? If yes you can
get details from
ActiveRecord::Base.configurations

An example is
ActiveRecord::Base.configurations[‘development’][‘database’]

Sijo

3

Sijo k g wrote:

Hi
Is it the db details you specified in database.yml? If yes you can
get details from
ActiveRecord::Base.configurations

An example is
ActiveRecord::Base.configurations[‘development’][‘database’]

Sijo

Thanks for the reply…
no i dont want to check the db which is specified in the yml file.
in the same port, i ll create a new database to move existing records.
for that i want to check whether the given db is alive or not

4

Hi

no i dont want to check the db which is specified in the yml file.
in the same port, i ll create a new database to move existing records.
for that i want to check whether the given db is alive or not

You can directly execute query from with in rails
ActiveRecord::Base.connection.execute(sql)

  May be there some other solutions to your question which i am not

aware of

Sijo

5

Sijo k g wrote:

Hi

no i dont want to check the db which is specified in the yml file.
in the same port, i ll create a new database to move existing records.
for that i want to check whether the given db is alive or not

You can directly execute query from with in rails
ActiveRecord::Base.connection.execute(sql)

  May be there some other solutions to your question which i am not

aware of

Sijo

Thank u
sql = “SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE
SCHEMA_NAME ‘c1’”
@s = ActiveRecord::Base.connection.execute(sql)
how to know the result.
it always retuns not nil even for wrong db(which is not exists)
how can i check it up

6

Hi

sql = “SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE
SCHEMA_NAME ‘c1’”
@s = ActiveRecord::Base.connection.execute(sql)
how to know the result.
it always retuns not nil even for wrong db(which is not exists)
how can i check it up

One is @s.collect.size for 0

Sijo