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 -- Posted via http://www.ruby-forum.com/.
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 -- Posted via http://www.ruby-forum.com/.
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''] > > > > SijoThanks 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 -- Posted via http://www.ruby-forum.com/.
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 notYou 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 -- Posted via http://www.ruby-forum.com/.
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 > > > > SijoThank 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 -- Posted via http://www.ruby-forum.com/.
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 upOne is @s.collect.size for 0 Sijo -- Posted via http://www.ruby-forum.com/.