HELP ME ON HOW TO

[Adam Akhtar-2]

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/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-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
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

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
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

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
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

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
--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

[Adam Akhtar-2]

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

--
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@...
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---