I try be good wit delete my orders and rubby says "no way frendly!". So I say, you go delete when I say go delete! like this is bad time:
arymcdo@labtop:~/depot> script/console
Loading development environment.
>> os = Order.find(:all)
=> [#"1", "name"=>"fdsa", "id"=>"2", "address"=>"dfsa", "email"=>"fdsaf"}>, #"1", "name"=>"fds", "id"=>"3", "address"=>"fds", "email"=>"fds"}>, #"1", "name"=>"dsaf", "id"=>"4", "address"=>"fda", "email"=>"dsf"}>, #"1", "name"=>"fd", "id"=>"5", "address"=>"fd", "email"=>"fd"}>, #"1", "name"=>"some dude", "id"=>"6", "address"=>"jkl;", "email"=>"blah@blahzy.com"}>, #"1", "name"=>"dude", "id"=>"7", "address"=>"somewhere", "email"=>"dude@here.com"}>, #"2", "name"=>"test", "id"=>"8", "address"=>"test", "email"=>"test"}>]
>> os.each { |o| o.destroy}
ActiveRecord::StatementInvalid: Mysql::Error: Cannot delete or update a parent row: a foreign key constraint fails (`depot_development/line_items`, CONSTRAINT `fk_line_item_orders` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`)): DELETE FROM orders
WHERE `id` = 1
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/mysql_adapter.rb:243:in `execute'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/mysql_adapter.rb:258:in `update'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract/database_statements.rb:47:in `delete'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1561:in `destroy_without_callbacks'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/callbacks.rb:321:in `destroy_without_transactions'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/transactions.rb:125:in `destroy'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/connection_adapters/abstract/database_statements.rb:59:in `transaction'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/transactions.rb:95:in `transaction'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/transactions.rb:121:in `transaction'
from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/transactions.rb:125:in `destroy'
from (irb):2
from (irb):2:in `each'
from (irb):2
aw man! super bad time here! I say you go delete with your foronion constaint! like this time here:
>> os.each do |o|
?> o.line_items.each { |l| l.destroy }
>> o.destroy
>> end
=> [#"1", "name"=>"fdsa", "id"=>"2", "address"=>"dfsa", "email"=>"fdsaf"}, @line_items=[#"2", "total_price"=>"59.95", "quantity"=>"2", "product_id"=>"6", "id"=>"3"}>]>, #"1", "name"=>"fds", "id"=>"3", "address"=>"fds", "email"=>"fds"}, @line_items=[#"3", "total_price"=>"59.95", "quantity"=>"2", "product_id"=>"6", "id"=>"4"}>, #"3", "total_price"=>"895.99", "quantity"=>"1", "product_id"=>"8", "id"=>"5"}>, #"3", "total_price"=>"28.50", "quantity"=>"1", "product_id"=>"2", "id"=>"6"}>, #"3", "total_price"=>"27.75", "quantity"=>"1", "product_id"=>"3", "id"=>"7"}>, #"3", "total_price"=>"29.95", "quantity"=>"1", "product_id"=>"1", "id"=>"8"}>]>, #"1", "name"=>"dsaf", "id"=>"4", "address"=>"fda", "email"=>"dsf"}, @line_items=[#"4", "total_price"=>"59.95", "quantity"=>"1", "product_id"=>"6", "id"=>"9"}>]>, #"1", "name"=>"fd", "id"=>"5", "address"=>"fd", "email"=>"fd"}, @line_items=[#"5", "total_price"=>"59.95", "quantity"=>"1", "product_id"=>"6", "id"=>"10"}>]>, #"1", "name"=>"some dude", "id"=>"6", "address"=>"jkl;", "email"=>"blah@blahzy.com"}, @line_items=[#"6", "total_price"=>"895.99", "quantity"=>"1", "product_id"=>"8", "id"=>"11"}>, #"6", "total_price"=>"59.95", "quantity"=>"1", "product_id"=>"6", "id"=>"12"}>, #"6", "total_price"=>"27.75", "quantity"=>"1", "product_id"=>"3", "id"=>"13"}>]>, #"1", "name"=>"dude", "id"=>"7", "address"=>"somewhere", "email"=>"dude@here.com"}, @line_items=[#"7", "total_price"=>"29.95", "quantity"=>"1", "product_id"=>"1", "id"=>"14"}>]>, #"2", "name"=>"test", "id"=>"8", "address"=>"test", "email"=>"test"}, @line_items=[#"8", "total_price"=>"59.95", "quantity"=>"1", "product_id"=>"6", "id"=>"15"}>, #"8", "total_price"=>"29.95", "quantity"=>"2", "product_id"=>"1", "id"=>"16"}>, #"8", "total_price"=>"27.75", "quantity"=>"1", "product_id"=>"3", "id"=>"17"}>]>]
>> Order.find(:all)
=> []
>> quit
yo mans! I did it like this time! yo ruby is grate!
