thr3ads.net - Rails - Raw SQL from a Rake Task [Feb 2008]

If this information is useful, please help other people find it:
Share via:

Joe Peck

2008-Feb-13 20:48 UTC

Raw SQL from a Rake Task

How do I execute a raw SQL file from a rake task?  Right now I have
this:

require ''active_record''
desc "Get all the pico HTML mess into a Ruby model"
task :muck => :environment do
  ActiveRecord::Base.establish_connection(RAILS_ENV.to_sym)
  puts "About to process ''uge SQL file...\n"
  execute "#{RAILS_ROOT}/db/html_template.sql"
  puts "File executed\n"
end

But when I try it, I get this error:
undefined method `execute'' for main:Object


Anyone know how to use a raw sql file in a rake task?
-- 
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Thufir

2008-Feb-13 22:36 UTC

head link

Re: Raw SQL from a Rake Task

I also would be interested to know how to do this!

On pg 38 (?) of "ruby on rails, up and running" by oreilly, they
describe something along the lines of:

import foo.sql

No, that''s not quite it, because it''s a ruby command on a .sql
file.
It''s not a rake task, but accomplishes what you''re trying to
do.

I believe that rake can be used to import CVS data, which might be
more convenient...


-Thufir
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Joe Peck

2008-Feb-14 14:30 UTC

head link

Re: Raw SQL from a Rake Task

> import foo.sql
> 
> No, that''s not quite it, because it''s a ruby command on a
.sql file.
> It''s not a rake task, but accomplishes what you''re trying
to do.
> 
> I believe that rake can be used to import CVS data, which might be
> more convenient...
> 
> 
> -ThufirFor some reason, running "import foo.sql" opens up X11, then hangs. 
There must be some way to execute SQL in a rake task...
-- 
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Frederick Cheung

2008-Feb-14 14:42 UTC

head link

Re: Raw SQL from a Rake Task

On 13 Feb 2008, at 20:48, Joe Peck wrote:
>
> How do I execute a raw SQL file from a rake task?  Right now I have
> this:
>
> require ''active_record''
> desc "Get all the pico HTML mess into a Ruby model"
> task :muck => :environment do
>  ActiveRecord::Base.establish_connection(RAILS_ENV.to_sym)
>  puts "About to process ''uge SQL file...\n"
>  execute "#{RAILS_ROOT}/db/html_template.sql"
>  puts "File executed\n"
> end
>
> But when I try it, I get this error:
> undefined method `execute'' for main:Object
>ActiveRecord::Base.connection.execute(...)

Fred>
--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Joe Peck

2008-Oct-16 19:36 UTC

head link

Re: Raw SQL from a Rake Task

Frederick Cheung wrote:> ActiveRecord::Base.connection.execute(...)
> 
> Fred
That seems to work if actual sql code is put in the parenthesis, but how 
can I run SQL out of a sql file in the rake task?

Doing this in the rake task:
ActiveRecord::Base.connection.execute("#{RAILS_ROOT}/db/html_template.sql")

gives me this error:
rake aborted!
Mysql::Error: You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to 
use near ''/projects/trieste2/db/html_template.sql'' at line 1: 
/projects/trieste2/db/html_template.sql


How can I run the sql that is in the sql file?
-- 
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Pardee, Roy

2008-Oct-16 19:49 UTC

head link

Re: Raw SQL from a Rake Task

Can you just shell out to whatever command-line tool your database supports for
executing large sql files?

-----Original Message-----
From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
[mailto:rubyonrails-talk@googlegroups.com] On Behalf Of Joe Peck
Sent: Thursday, October 16, 2008 12:36 PM
To: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
Subject: [Rails] Re: Raw SQL from a Rake Task


Frederick Cheung wrote:> ActiveRecord::Base.connection.execute(...)
>
> Fred
That seems to work if actual sql code is put in the parenthesis, but how can I
run SQL out of a sql file in the rake task?

Doing this in the rake task:
ActiveRecord::Base.connection.execute("#{RAILS_ROOT}/db/html_template.sql")

gives me this error:
rake aborted!
Mysql::Error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
''/projects/trieste2/db/html_template.sql'' at line 1:
/projects/trieste2/db/html_template.sql


How can I run the sql that is in the sql file?
--
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Joe Peck

2008-Oct-17 14:54 UTC

head link

Re: Raw SQL from a Rake Task

Roy Pardee wrote:> Can you just shell out to whatever command-line tool your database 
> supports for executing large sql files?
Yeah, I can.  Now I ran into good ol'' Error 1136: Column count
doesn''t
match value count at row 1

It really looks to me like it should work, but I''m sure
there''s some
tiny thing that is wrong.

insert into html_templates (id, name, htmlcode, style, js, count) 
values(''1000'',''Mega 
Template'',''<html><body>Hello</body></html>'',''\r\nborder:1px;
\r\nborder-color:#333333;
\r\nborder-style:solid;\r\n}\r\n'','''',''0'');
-- 
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Joe Peck

2008-Oct-17 16:07 UTC

head link

Re: Raw SQL from a Rake Task

Joe Peck wrote:> Roy Pardee wrote:
>> Can you just shell out to whatever command-line tool your database 
>> supports for executing large sql files?
> 
> Yeah, I can.  Now I ran into good ol'' Error 1136: Column count
doesn''t
> match value count at row 1
> 
> It really looks to me like it should work, but I''m sure
there''s some
> tiny thing that is wrong.
> 
> insert into html_templates (id, name, htmlcode, style, js, count) 
> values(''1000'',''Mega 
>
Template'',''<html><body>Hello</body></html>'',''\r\nborder:1px;
> \r\nborder-color:#333333;
\r\nborder-style:solid;\r\n}\r\n'','''',''0'');
Okay, figured it out.  I''ll post this in case someone else stumbles 
around looking for how to fix this error.

http://htmlfixit.com/cgi-tutes/tutorial_MySQL_Error_Invalid_Query_Column_Count_Does_Not_Match_Value_Count.php
-- 
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

MatthewRudy

2008-Oct-18 13:29 UTC

head link

Re: Raw SQL from a Rake Task

you need to load the .sql file into ruby,
and then call .execute on it.

sql = File.open("some.sql").read
sql.split('';'').each do |sql_statement|
  ActiveRecord::Base.connection.execute(sql_statement)
end

We split it by ";" because a .sql file may contain multiple
statgements,
and you''ll need to execute those seperately.

But that should work fine.

Yours,
MatthewRudy
http://workingwithrails.com/person/12394-matthew-rudy-jacobs

On Oct 16, 8:36 pm, Joe Peck
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> Frederick Cheung wrote:
> > ActiveRecord::Base.connection.execute(...)
>
> > Fred
>
> That seems to work if actual sql code is put in the parenthesis, but how
> can I run SQL out of a sql file in the rake task?
>
> Doing this in the rake task:
>
ActiveRecord::Base.connection.execute("#{RAILS_ROOT}/db/html_template.sql")
>
> gives me this error:
> rake aborted!
> Mysql::Error: You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near ''/projects/trieste2/db/html_template.sql'' at
line 1:
> /projects/trieste2/db/html_template.sql
>
> How can I run the sql that is in the sql file?
> --
> Posted viahttp://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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails - Feb 2008 - Raw SQL from a Rake Task

Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task

Re: Raw SQL from a Rake Task