Writing a SQL Query in Active Record?

ruby-talk
1

Hi,

I am using the following code snippet for connecting to SQL Server
through Active Record:

require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connection(
:adapter => "sqlserver",
:host => "xxx.xxx.xxx.xxx,8080"
:username => "username"
:password => "password"
:database => "xyz_1008"
)

Now, I want to execute a query in this sql server after getting
successfully connected but am not aware how to do so. Can anyone give an
example as to how we write the query say ("Select * from Name") after
establishing the above connection successfully?

Thanks,
Anukul

···

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

2

Anukul Singhal wrote:

Hi,

I am using the following code snippet for connecting to SQL Server
through Active Record:

require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connection(
:adapter => "sqlserver",
:host => "xxx.xxx.xxx.xxx,8080"
:username => "username"
:password => "password"
:database => "xyz_1008"
)

Now, I want to execute a query in this sql server after getting
successfully connected but am not aware how to do so. Can anyone give an
example as to how we write the query say ("Select * from Name") after
establishing the above connection successfully?

ar.rubyonrails.com

Look for #find, or #find_by_sql.

- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan
Blog: http://justarubyist.blogspot.com

You write with ease to show your breeding,
But easy writing 's curst hard reading.
~ -- Richard Brinsley Sheridan (1751-1816)
~ -- Clio's Protest, Life of Sheridan (Moore), Vol. i, p. 155

3

Phillip Gawlowski wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Anukul Singhal wrote:
> Hi,
>
> I am using the following code snippet for connecting to SQL Server
> through Active Record:
>
> require 'rubygems'
> require 'active_record'
>
> ActiveRecord::Base.establish_connection(
> :adapter => "sqlserver",
> :host => "xxx.xxx.xxx.xxx,8080"
> :username => "username"
> :password => "password"
> :database => "xyz_1008"
> )
>
> Now, I want to execute a query in this sql server after getting
> successfully connected but am not aware how to do so. Can anyone give an
> example as to how we write the query say ("Select * from Name") after
> establishing the above connection successfully?

ar.rubyonrails.com

Look for #find, or #find_by_sql.

- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan
Blog: http://justarubyist.blogspot.com

You write with ease to show your breeding,
But easy writing 's curst hard reading.
~ -- Richard Brinsley Sheridan (1751-1816)
~ -- Clio's Protest, Life of Sheridan (Moore), Vol. i, p. 155
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkgjHOcACgkQbtAgaoJTgL9k8QCdHTVwPREoYlByjns1t1Sr9NOY
eYYAmgJ5A9zOn9ZrX8KgAUXwSz6oLORz
=KK/C
-----END PGP SIGNATURE-----

Hi,

Thanks for the reply.

I am not using rails. Want to run the query only using Active Record on
Ruby (Scite Editor)

Can you give any prototype as to how I can proceed writing a simple
"SELECT" query after establishing the connection with the sql server db?

Thanks,
Anukul

···

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

4

Anukul Singhal wrote:

I am not using rails. Want to run the query only using Active Record on
Ruby (Scite Editor)

Yes, that is what ActiveRecord's #find and #find_by_sql methods do.

Rails uses ActiveRecord, but ActiveRecord works without using Rails itself.

Can you give any prototype as to how I can proceed writing a simple
"SELECT" query after establishing the connection with the sql server db?

class Table < ActiveRecord::Base; end

select = Table.find :all

- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan
Blog: http://justarubyist.blogspot.com

~ How many boards would the Mongols hoard if the Mongol hordes got bored?
      -- Calvin

5

* Anukul Singhal <anukul.singhal@gmail.com> (17:55) schrieb:

I am not using rails. Want to run the query only using Active Record on
Ruby (Scite Editor)

What's ActiveRecord for if you just want to use SQL?

Can you give any prototype as to how I can proceed writing a simple
"SELECT" query after establishing the connection with the sql server db?

The normal ActiveRecord way is to create a Class and let it do that.

mfg, simon .... l

6

Simon Krahnke wrote:

* Anukul Singhal <anukul.singhal@gmail.com> (17:55) schrieb:

I am not using rails. Want to run the query only using Active Record on
Ruby (Scite Editor)

What's ActiveRecord for if you just want to use SQL?

- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan
Blog: http://justarubyist.blogspot.com

Parenthesise to avoid ambiguity.
~ - The Elements of Programming Style (Kernighan & Plaugher)