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
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
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
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
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
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.