Re: [Rails-core] MySQL backticks and column names

2006-04-19 Thread John W. Long

Rick Olson wrote:

Yup, go for it.  Post the ticket # and I'll see about adding it.  I'd
appreciate any folks using mssql, oracle, etc to try it out too.


Rick, any word on this?

--
John Long
http://wiseheartdesign.com
___
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core


Re: [Rails-core] MySQL backticks and column names

2006-04-19 Thread Rick Olson
> Thinking about this a little more, I wonder if we should create a new
> quoting method called "quote_index_name" and use it when quoting indexes
> for connection adapters. It's probably premature at this point, but I
> thought I would mention it.

I wouldn't worry about it.  If it becomes a big need in the other
adapters, it can be added easily enough I suppose.

http://dev.rubyonrails.org/changeset/4239

--
Rick Olson
http://techno-weenie.net
___
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core


Re: [Rails-core] ActiveRecord , Looking For Feedback

2006-04-19 Thread zdennis
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Jeff Lindsay wrote:
> Your IO Mode plugin sounds interesting too... care to share it? That
> and this bulk AR/virtual table both sound useful to me. Release them
> as plugins? : )

Here is a link to 0.0.1 of the ActiveRecord IO Mode plugin:
  http://www.mktec.com/oss/rails-plugins/active_record_io_mode.0.0.1.tgz

It is more documentation then code, and only 201 lines. It works
successfully with the MysqlAdapter. I believe it should work for
Postgres, but I'm not a Postgres user so any feedback would be great.
Any Oracle, MSSQL, SQLite, etc... users please let me know if this works
or not for you.

Once installed in the vendor/plugins directory you can test this by
running "ruby script/console" from the RAILS_ROOT, and doing something
similar to:

  # to redirect sql to an array
  >> arr = []
  >> ActiveRecord::Base.send_sql_to arr
  => true

  # let's test it
  >> Test.find :all, :limit => 1
  => []
  >> arr
  => ["SELECT * FROM tests LIMIT 1;\n"]

  # redirect sql back to our db connection
  >> ActiveRecord::Base.send_sql_to :db
  => true
  >> Test.find :all, :limit => 1
  =>  [#"test1", "id"=>"1"}>]

I am working on packaging the other plugin sometime in the next day or two.

Any feedback or suggestions are graciously accepted!

Zach


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFERvrhMyx0fW1d8G0RAsOeAJ9abtP2VPk4rzpLu1uC3w4kiwKCgACcD9do
9dI8dPKOvzrKOjsQ97CpQgI=
=OHQS
-END PGP SIGNATURE-
___
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core


Re: [Rails-core] ActiveRecord , Looking For Feedback

2006-04-19 Thread Jeff Lindsay
Very cool. That's just what I thought it was. : )

-jeff

On 4/19/06, zdennis <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Jeff Lindsay wrote:
> > Your IO Mode plugin sounds interesting too... care to share it? That
> > and this bulk AR/virtual table both sound useful to me. Release them
> > as plugins? : )
>
> Here is a link to 0.0.1 of the ActiveRecord IO Mode plugin:
>   http://www.mktec.com/oss/rails-plugins/active_record_io_mode.0.0.1.tgz
>
> It is more documentation then code, and only 201 lines. It works
> successfully with the MysqlAdapter. I believe it should work for
> Postgres, but I'm not a Postgres user so any feedback would be great.
> Any Oracle, MSSQL, SQLite, etc... users please let me know if this works
> or not for you.
>
> Once installed in the vendor/plugins directory you can test this by
> running "ruby script/console" from the RAILS_ROOT, and doing something
> similar to:
>
>   # to redirect sql to an array
>   >> arr = []
>   >> ActiveRecord::Base.send_sql_to arr
>   => true
>
>   # let's test it
>   >> Test.find :all, :limit => 1
>   => []
>   >> arr
>   => ["SELECT * FROM tests LIMIT 1;\n"]
>
>   # redirect sql back to our db connection
>   >> ActiveRecord::Base.send_sql_to :db
>   => true
>   >> Test.find :all, :limit => 1
>   =>  [#"test1", "id"=>"1"}>]
>
> I am working on packaging the other plugin sometime in the next day or two.
>
> Any feedback or suggestions are graciously accepted!
>
> Zach
>
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.1 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFERvrhMyx0fW1d8G0RAsOeAJ9abtP2VPk4rzpLu1uC3w4kiwKCgACcD9do
> 9dI8dPKOvzrKOjsQ97CpQgI=
> =OHQS
> -END PGP SIGNATURE-
> ___
> Rails-core mailing list
> [email protected]
> http://lists.rubyonrails.org/mailman/listinfo/rails-core
>


--
Jeff Lindsay
http://blogrium.com/
___
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core