[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Writing a SQL Query in Active Record?

Anukul Singhal

5/8/2008 3:16:00 PM

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-....
5 Answers

Phillip Gawlowski

5/8/2008 3:32:00 PM

0

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

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

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

Anukul Singhal

5/8/2008 3:56:00 PM

0

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

Phillip Gawlowski

5/8/2008 5:40:00 PM

0

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

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

~ How many boards would the Mongols hoard if the Mongol hordes got bored?
-- Calvin
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail....

iEYEARECAAYFAkgjOwUACgkQbtAgaoJTgL8NVQCgpLIP+PbwTxDnEhXiXDg3sLlc
gy0An3GewesORQjT2Q7uQlvbEpUuRyi4
=8Svr
-----END PGP SIGNATURE-----

Simon Krahnke

5/8/2008 5:52:00 PM

0

* 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

Phillip Gawlowski

5/8/2008 6:16:00 PM

0

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

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?

http://en.wikipedia.org/wiki/Active_reco...


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

Parenthesise to avoid ambiguity.
~ - The Elements of Programming Style (Kernighan & Plaugher)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail....

iEYEARECAAYFAkgjQzwACgkQbtAgaoJTgL8rbwCghN8DPR/rsWP4/sqedGKGXakq
vH8AnjQZvMCyAel3WC991pKY12VsE9wY
=zw3a
-----END PGP SIGNATURE-----