How to truncate a table from a rake file


#1

I am new to rails and want to figure out the syntax for truncating a
table using a rake file. Any ideas? thanks in advance!


#2

On Tue, Mar 17, 2009 at 12:36 PM, Chris G. <
removed_email_address@domain.invalid> wrote:

I am new to rails and want to figure out the syntax for truncating a
table using a rake file. Any ideas? thanks in advance!

Hi, what do you mean truncate a table? Do you mean delete the contents
of
the table or
delete the table?

-Conrad


#3

Conrad T. wrote:

On Tue, Mar 17, 2009 at 12:36 PM, Chris G. <
removed_email_address@domain.invalid> wrote:

I am new to rails and want to figure out the syntax for truncating a
table using a rake file. Any ideas? thanks in advance!

Hi, what do you mean truncate a table? Do you mean delete the contents
of
the table or
delete the table?

-Conrad

delete the contents of the table


#4

On Mar 17, 7:58 pm, Chris G. removed_email_address@domain.invalid
wrote:

delete the table?

-Conrad

delete the contents of the table

If you make your task depend on the magic :environment task then
activerecord will be loaded with your database configuration (and you
models etc.) and you can just do MyModel.connection.execute “…” as
you would have normally or just SomeModel.delete_all if you don’t care
about the difference between truncate and deleting all rows.

Fred