Processing ProductsController#index (for 127.0.0.1 at 2008-07-24 08:54:29) [GET] Session ID: 516264dbb9a2fb7792ea3375d071afc7 Parameters: {"action"=>"index", "controller"=>"products"} SQL (0.000156) SET SQL_AUTO_IS_NULL=0 Product Load (0.000000) Mysql::Error: Table 'depot_development.products' doesn't exist: SELECT * FROM `products`  ActiveRecord::StatementInvalid (Mysql::Error: Table 'depot_development.products' doesn't exist: SELECT * FROM `products` ): /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/mysql_adapter.rb:299:in `execute' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/mysql_adapter.rb:515:in `select' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:80:in `cache_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:582:in `find_by_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:1341:in `find_every' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:536:in `find' /app/controllers/products_controller.rb:5:in `index' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:1162:in `send' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:1162:in `perform_action_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:580:in `call_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:573:in `perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/rescue.rb:201:in `perform_action_without_caching' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:13:in `perform_action' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/query_cache.rb:8:in `cache' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:12:in `perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:529:in `send' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:529:in `process_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:569:in `process_without_session_management_support' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/session_management.rb:130:in `process' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:389:in `process' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:149:in `handle_request' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:107:in `dispatch' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:104:in `synchronize' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:104:in `dispatch' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:120:in `dispatch_cgi' /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:35:in `dispatch' /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:112:in `handle_dispatch' /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:78:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib/ruby/1.8/webrick/server.rb:92:in `each' /usr/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/lib/ruby/1.8/webrick/server.rb:82:in `start' /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:62:in `dispatch' /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/servers/webrick.rb:66 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:509:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:354:in `new_constants_in' /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:509:in `require' /usr/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/server.rb:39 /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' script/server:3 Rendering /usr/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/templates/rescues/layout.erb (internal_server_error) SQL (0.000168) SET SQL_AUTO_IS_NULL=0 SQL (0.000306) SHOW TABLES SQL (0.043538) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB SQL (0.004163) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`) SQL (0.000244) SHOW TABLES SQL (0.000338) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) SQL (0.000068) SELECT version FROM schema_migrations SQL (0.002555) CREATE TABLE `products` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255) DEFAULT NULL NULL, `description` text DEFAULT NULL NULL, `image_url` varchar(255) DEFAULT NULL NULL, `created_at` datetime DEFAULT NULL NULL, `updated_at` datetime DEFAULT NULL NULL) ENGINE=InnoDB SQL (0.000787) INSERT INTO schema_migrations (version) VALUES ('20080724075409') SQL (0.000238) SELECT version FROM schema_migrations SQL (0.000215) SHOW TABLES SQL (0.000852) SHOW FIELDS FROM `products` SQL (0.000711) describe `products` SQL (0.000320) SHOW KEYS FROM `products` Processing ProductsController#index (for 127.0.0.1 at 2008-07-24 08:54:57) [GET] Session ID: BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo SGFzaHsABjoKQHVzZWR7AA==--9a7a4cb8d57b822aeb31c468bcb62a33430f150b Parameters: {"action"=>"index", "controller"=>"products"} Product Load (0.000316) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Completed in 0.01792 (55 reqs/sec) | Rendering: 0.00568 (31%) | DB: 0.00047 (2%) | 200 OK [http://localhost/products] Processing ProductsController#new (for 127.0.0.1 at 2008-07-24 08:55:01) [GET] Session ID: BAh7BiIKZmxhc2hJQzonQWN0aW9uQ29udHJvbGxlcjo6Rmxhc2g6OkZsYXNo SGFzaHsABjoKQHVzZWR7AA==--9a7a4cb8d57b822aeb31c468bcb62a33430f150b Parameters: {"action"=>"new", "controller"=>"products"} Product Columns (0.000866) SHOW FIELDS FROM `products` Rendering template within layouts/products Rendering products/new Completed in 0.02357 (42 reqs/sec) | Rendering: 0.01115 (47%) | DB: 0.00087 (3%) | 200 OK [http://localhost/products/new] Processing ProductsController#create (for 127.0.0.1 at 2008-07-24 08:55:07) [POST] Session ID: BAh7BzoMY3NyZl9pZCIlOWM2MWUxN2RiODdmNDI2MTQxNjIwODM5ZmY2Yzdj OWIiCmZsYXNoSUM6J0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhh c2h7AAY6CkB1c2VkewA=--be2cb095a3a64313ddeabee8ee4f7ac896aae350 Parameters: {"commit"=>"Create", "product"=>{"image_url"=>"lkj l;j", "title"=>"lkj ", "description"=>"l;kj lk;j l;kj lj"}, "authenticity_token"=>"466a8d52a74d0603850d0b0d709e5f2c5e3ce774", "action"=>"create", "controller"=>"products"} Product Columns (0.000988) SHOW FIELDS FROM `products` SQL (0.000084) BEGIN Product Create (0.000799) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `description`, `created_at`) VALUES('lkj l;j', '2008-07-24 07:55:07', 'lkj ', 'l;kj lk;j l;kj lj', '2008-07-24 07:55:07') SQL (0.002049) COMMIT Redirected to http://localhost:3000/products/1 Completed in 0.02044 (48 reqs/sec) | DB: 0.00392 (19%) | 302 Found [http://localhost/products] Processing ProductsController#show (for 127.0.0.1 at 2008-07-24 08:55:07) [GET] Session ID: BAh7BzoMY3NyZl9pZCIlOWM2MWUxN2RiODdmNDI2MTQxNjIwODM5ZmY2Yzdj OWIiCmZsYXNoSUM6J0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhh c2h7BjoLbm90aWNlIiZQcm9kdWN0IHdhcyBzdWNjZXNzZnVsbHkgY3JlYXRl ZC4GOgpAdXNlZHsGOwdG--f2c2ee2eb4620b461f69f905e5860ebe7060c7f2 Parameters: {"action"=>"show", "id"=>"1", "controller"=>"products"} Product Columns (0.001114) SHOW FIELDS FROM `products` Product Load (0.000544) SELECT * FROM `products` WHERE (`products`.`id` = 1)  Rendering template within layouts/products Rendering products/show Completed in 0.02537 (39 reqs/sec) | Rendering: 0.00662 (26%) | DB: 0.00166 (6%) | 200 OK [http://localhost/products/1] Processing ProductsController#index (for 127.0.0.1 at 2008-07-24 08:55:09) [GET] Session ID: BAh7BzoMY3NyZl9pZCIlOWM2MWUxN2RiODdmNDI2MTQxNjIwODM5ZmY2Yzdj OWIiCmZsYXNoSUM6J0FjdGlvbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhh c2h7BjoLbm90aWNlIiZQcm9kdWN0IHdhcyBzdWNjZXNzZnVsbHkgY3JlYXRl ZC4GOgpAdXNlZHsGOwdU--e278ebd0c668af234fdcc2a973394c40ab1571fd Parameters: {"action"=>"index", "controller"=>"products"} Product Load (0.000324) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (0.003374) SHOW FIELDS FROM `products` Completed in 0.02020 (49 reqs/sec) | Rendering: 0.00515 (25%) | DB: 0.00370 (18%) | 200 OK [http://localhost/products] SQL (0.3ms) SET SQL_AUTO_IS_NULL=0 SQL (17.9ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) Migrating to AddProductPrice (20090128142730) SQL (222.8ms) ALTER TABLE `products` ADD `price` decimal(8,2) DEFAULT 2 SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('20090128142730') SQL (0.6ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.5ms) SHOW TABLES SQL (2.2ms) SHOW FIELDS FROM `products` SQL (1.9ms) describe `products` SQL (1.0ms) SHOW KEYS FROM `products` SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.5ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations SQL (0.4ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to AddProductPrice (20090128142730) SQL (27.2ms) ALTER TABLE `products` DROP `price` SQL (40.9ms) DELETE FROM schema_migrations WHERE version = '20090128142730' Migrating to CreateProducts (20080724075409) SQL (26.4ms) DROP TABLE `products` SQL (38.8ms) DELETE FROM schema_migrations WHERE version = '20080724075409' SQL (0.5ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.4ms) SHOW TABLES SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.4ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) SQL (30.6ms) CREATE TABLE `products` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `image_url` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB SQL (25.8ms) INSERT INTO schema_migrations (version) VALUES ('20080724075409') Migrating to AddProductPrice (20090128142730) SQL (16.2ms) ALTER TABLE `products` ADD `price` decimal(8,2) DEFAULT 0 SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('20090128142730') SQL (0.5ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.5ms) SHOW TABLES SQL (3.6ms) SHOW FIELDS FROM `products` SQL (1.9ms) describe `products` SQL (0.6ms) SHOW KEYS FROM `products` Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 10:55:37) [GET] SQL (41.3ms) SET SQL_AUTO_IS_NULL=0 Product Load (49.7ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (23.1ms) SHOW FIELDS FROM `products` Completed in 234ms (View: 147, DB: 114) | 200 OK [http://localhost/products] Processing ProductsController#edit (for 127.0.0.1 at 2009-01-30 10:55:41) [GET] Parameters: {"id"=>"1"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.1ms) SHOW FIELDS FROM `products` Product Load (23.3ms) SELECT * FROM `products` WHERE (`products`.`id` = 1)  Rendering template within layouts/products Rendering products/edit Completed in 52ms (View: 16, DB: 24) | 200 OK [http://localhost/products/1/edit] Processing ProductsController#update (for 127.0.0.1 at 2009-01-30 10:55:42) [PUT] Parameters: {"commit"=>"Update", "authenticity_token"=>"f081ce86efd30d00f8269cdde39c0b562c696c34", "product"=>{"image_url"=>"", "price"=>"17.00", "title"=>"First product", "description"=>"This is the description of the first product"}, "id"=>"1"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.2ms) SHOW FIELDS FROM `products` Product Load (0.3ms) SELECT * FROM `products` WHERE (`products`.`id` = 1)  SQL (0.7ms) BEGIN Product Exists (62.9ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'First product' AND `products`.id <> 1) LIMIT 1 SQL (0.2ms) ROLLBACK Rendering template within layouts/products Rendering products/edit Completed in 182ms (View: 22, DB: 65) | 200 OK [http://localhost/products/1] Processing ProductsController#update (for 127.0.0.1 at 2009-01-30 10:56:00) [PUT] Parameters: {"commit"=>"Update", "authenticity_token"=>"f081ce86efd30d00f8269cdde39c0b562c696c34", "product"=>{"image_url"=>"prod1", "price"=>"17.00", "title"=>"First product", "description"=>"This is the description of the first product"}, "id"=>"1"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.3ms) SHOW FIELDS FROM `products` Product Load (0.1ms) SELECT * FROM `products` WHERE (`products`.`id` = 1)  SQL (0.1ms) BEGIN Product Exists (0.1ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'First product' AND `products`.id <> 1) LIMIT 1 SQL (0.2ms) ROLLBACK Rendering template within layouts/products Rendering products/edit Completed in 42ms (View: 16, DB: 2) | 200 OK [http://localhost/products/1] Processing ProductsController#update (for 127.0.0.1 at 2009-01-30 10:56:04) [PUT] Parameters: {"commit"=>"Update", "authenticity_token"=>"f081ce86efd30d00f8269cdde39c0b562c696c34", "product"=>{"image_url"=>"prod1.png", "price"=>"17.00", "title"=>"First product", "description"=>"This is the description of the first product"}, "id"=>"1"} SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.1ms) SHOW FIELDS FROM `products` Product Load (0.2ms) SELECT * FROM `products` WHERE (`products`.`id` = 1)  SQL (0.1ms) BEGIN Product Exists (0.1ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'First product' AND `products`.id <> 1) LIMIT 1 Product Update (31.3ms) UPDATE `products` SET `updated_at` = '2009-01-30 10:56:04', `image_url` = 'prod1.png' WHERE `id` = 1 SQL (8.9ms) COMMIT Redirected to # Completed in 69ms (DB: 42) | 302 Found [http://localhost/products/1] Processing ProductsController#show (for 127.0.0.1 at 2009-01-30 10:56:04) [GET] Parameters: {"id"=>"1"} SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Product Columns (2.4ms) SHOW FIELDS FROM `products` Product Load (0.6ms) SELECT * FROM `products` WHERE (`products`.`id` = 1)  Rendering template within layouts/products Rendering products/show Completed in 43ms (View: 17, DB: 3) | 200 OK [http://localhost/products/1] Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 10:56:07) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.4ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.7ms) SHOW FIELDS FROM `products` Completed in 28ms (View: 14, DB: 2) | 200 OK [http://localhost/products] Processing ProductsController#new (for 127.0.0.1 at 2009-01-30 10:56:13) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.1ms) SHOW FIELDS FROM `products` Rendering template within layouts/products Rendering products/new Completed in 34ms (View: 21, DB: 1) | 200 OK [http://localhost/products/new] Processing ProductsController#create (for 127.0.0.1 at 2009-01-30 10:56:15) [POST] Parameters: {"commit"=>"Create", "authenticity_token"=>"f081ce86efd30d00f8269cdde39c0b562c696c34", "product"=>{"image_url"=>"", "price"=>"0.0", "title"=>"", "description"=>""}} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.2ms) SHOW FIELDS FROM `products` SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY '') LIMIT 1 SQL (0.2ms) ROLLBACK Rendering template within layouts/products Rendering products/new Completed in 49ms (View: 18, DB: 2) | 200 OK [http://localhost/products] Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 10:56:26) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.2ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.4ms) SHOW FIELDS FROM `products` Completed in 32ms (View: 16, DB: 2) | 200 OK [http://localhost/products] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.4ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) Migrating to AddProductPrice (20090128142730) Migrating to AddTestData (20090130111521) Product Delete all (8.2ms) DELETE FROM `products`  Product Columns (1.7ms) SHOW FIELDS FROM `products` SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Version Control') LIMIT 1 Product Create (28.2ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/auto.jpg', '2009-01-30 11:21:28', 'Pragmatic Version Control', 29.95, '

\n Pragmatic Project Automation shows you how to improve the \n consistency and repeatability of your project\'s procedures using \n automation to reduce risk and errors.\n

\n

\n Simply put, we\'re going to put this thing called a computer to work \n for you doing the mundane (but important) project stuff. That means \n you\'ll have more time and energy to do the really \n exciting---and difficult---stuff, like writing quality code.\n

', '2009-01-30 11:21:28') SQL (0.6ms) COMMIT SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Version Control') LIMIT 1 SQL (0.1ms) ROLLBACK SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Unit Testing (C#)') LIMIT 1 Product Create (0.4ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/utc.jpg', '2009-01-30 11:21:28', 'Pragmatic Unit Testing (C#)', 27.75, '

\n Pragmatic programmers use feedback to drive their development and \n personal processes. The most valuable feedback you can get while \n coding comes from unit testing.\n

\n

\n Without good tests in place, coding can become a frustrating game of \n \"whack-a-mole.\" That\'s the carnival game where the player strikes at a \n mechanical mole; it retreats and another mole pops up on the opposite side \n of the field. The moles pop up and down so fast that you end up flailing \n your mallet helplessly as the moles continue to pop up where you least \n expect them.\n

', '2009-01-30 11:21:28') SQL (0.5ms) COMMIT SQL (23.8ms) INSERT INTO schema_migrations (version) VALUES ('20090130111521') SQL (0.4ms) SHOW TABLES SQL (0.3ms) SELECT version FROM schema_migrations SQL (0.3ms) SHOW TABLES SQL (1.0ms) SHOW FIELDS FROM `products` SQL (1.1ms) describe `products` SQL (0.5ms) SHOW KEYS FROM `products` Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:21:36) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.7ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.1ms) SHOW FIELDS FROM `products` Completed in 34ms (View: 19, DB: 2) | 200 OK [http://localhost/products] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.4ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations SQL (0.3ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to AddTestData (20090130111521) Product Delete all (7.2ms) DELETE FROM `products`  SQL (9.5ms) DELETE FROM schema_migrations WHERE version = '20090130111521' Migrating to AddProductPrice (20090128142730) SQL (174.7ms) ALTER TABLE `products` DROP `price` SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '20090128142730' Migrating to CreateProducts (20080724075409) SQL (1.4ms) DROP TABLE `products` SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '20080724075409' SQL (0.4ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.5ms) SHOW TABLES SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.5ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) SQL (6.1ms) CREATE TABLE `products` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `image_url` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('20080724075409') Migrating to AddProductPrice (20090128142730) SQL (8.7ms) ALTER TABLE `products` ADD `price` decimal(8,2) DEFAULT 0 SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('20090128142730') Migrating to AddTestData (20090130111521) Product Delete all (9.7ms) DELETE FROM `products`  Product Columns (2.1ms) SHOW FIELDS FROM `products` SQL (0.2ms) BEGIN Product Exists (0.5ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Project Automation') LIMIT 1 Product Create (0.4ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/auto.jpg', '2009-01-30 11:22:38', 'Pragmatic Project Automation', 29.95, '

\n Pragmatic Project Automation shows you how to improve the \n consistency and repeatability of your project\'s procedures using \n automation to reduce risk and errors.\n

\n

\n Simply put, we\'re going to put this thing called a computer to work \n for you doing the mundane (but important) project stuff. That means \n you\'ll have more time and energy to do the really \n exciting---and difficult---stuff, like writing quality code.\n

', '2009-01-30 11:22:38') SQL (0.6ms) COMMIT SQL (0.2ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Version Control') LIMIT 1 Product Create (0.4ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/svn.jpg', '2009-01-30 11:22:38', 'Pragmatic Version Control', 28.5, '

\n This book is a recipe-based approach to using Subversion that will \n get you up and running quickly---and correctly. All projects need\n version control: it\'s a foundational piece of any project\'s \n infrastructure. Yet half of all project teams in the U.S. don\'t use\n any version control at all. Many others don\'t use it well, and end \n up experiencing time-consuming problems.\n

', '2009-01-30 11:22:38') SQL (0.6ms) COMMIT SQL (0.2ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Unit Testing (C#)') LIMIT 1 Product Create (0.5ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/utc.jpg', '2009-01-30 11:22:38', 'Pragmatic Unit Testing (C#)', 27.75, '

\n Pragmatic programmers use feedback to drive their development and \n personal processes. The most valuable feedback you can get while \n coding comes from unit testing.\n

\n

\n Without good tests in place, coding can become a frustrating game of \n \"whack-a-mole.\" That\'s the carnival game where the player strikes at a \n mechanical mole; it retreats and another mole pops up on the opposite side \n of the field. The moles pop up and down so fast that you end up flailing \n your mallet helplessly as the moles continue to pop up where you least \n expect them.\n

', '2009-01-30 11:22:38') SQL (6.3ms) COMMIT SQL (13.7ms) INSERT INTO schema_migrations (version) VALUES ('20090130111521') SQL (0.5ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.5ms) SHOW TABLES SQL (1.8ms) SHOW FIELDS FROM `products` SQL (1.8ms) describe `products` SQL (0.7ms) SHOW KEYS FROM `products` Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:22:43) [GET] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.4ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.1ms) SHOW FIELDS FROM `products` Completed in 31ms (View: 17, DB: 2) | 200 OK [http://localhost/products] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.4ms) SHOW TABLES SQL (0.1ms) SELECT version FROM schema_migrations SQL (0.3ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to AddTestData (20090130111521) Product Delete all (5.1ms) DELETE FROM `products`  SQL (12.1ms) DELETE FROM schema_migrations WHERE version = '20090130111521' Migrating to AddProductPrice (20090128142730) SQL (30.2ms) ALTER TABLE `products` DROP `price` SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '20090128142730' Migrating to CreateProducts (20080724075409) SQL (2.0ms) DROP TABLE `products` SQL (6.3ms) DELETE FROM schema_migrations WHERE version = '20080724075409' SQL (0.4ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.4ms) SHOW TABLES SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (1.2ms) SHOW TABLES SQL (0.2ms) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) SQL (3.4ms) CREATE TABLE `products` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `image_url` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('20080724075409') Migrating to AddProductPrice (20090128142730) SQL (6.6ms) ALTER TABLE `products` ADD `price` decimal(8,2) DEFAULT 0 SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('20090128142730') Migrating to AddTestData (20090130111521) Product Delete all (0.4ms) DELETE FROM `products`  Product Columns (1.1ms) SHOW FIELDS FROM `products` SQL (0.1ms) BEGIN Product Exists (0.6ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Project Automation') LIMIT 1 Product Create (0.6ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/auto.jpg', '2009-01-30 11:26:48', 'Pragmatic Project Automation', 29.95, '

\n Pragmatic Project Automation shows you how to improve the \n consistency and repeatability of your project\'s procedures using \n automation to reduce risk and errors.\n

\n

\n Simply put, we\'re going to put this thing called a computer to work \n for you doing the mundane (but important) project stuff. That means \n you\'ll have more time and energy to do the really \n exciting---and difficult---stuff, like writing quality code.\n

', '2009-01-30 11:26:48') SQL (0.7ms) COMMIT SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Version Control') LIMIT 1 Product Create (1.0ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/svn.jpg', '2009-01-30 11:26:48', 'Pragmatic Version Control', 28.5, '

\n This book is a recipe-based approach to using Subversion that will \n get you up and running quickly&emdash;and correctly. All projects need\n version control: it\'s a foundational piece of any project\'s \n infrastructure. Yet half of all project teams in the U.S. don\'t use\n any version control at all. Many others don\'t use it well, and end \n up experiencing time-consuming problems.\n

', '2009-01-30 11:26:48') SQL (1.8ms) COMMIT SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Unit Testing (C#)') LIMIT 1 Product Create (0.4ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/utc.jpg', '2009-01-30 11:26:48', 'Pragmatic Unit Testing (C#)', 27.75, '

\n Pragmatic programmers use feedback to drive their development and \n personal processes. The most valuable feedback you can get while \n coding comes from unit testing.\n

\n

\n Without good tests in place, coding can become a frustrating game of \n \"whack-a-mole.\" That\'s the carnival game where the player strikes at a \n mechanical mole; it retreats and another mole pops up on the opposite side \n of the field. The moles pop up and down so fast that you end up flailing \n your mallet helplessly as the moles continue to pop up where you least \n expect them.\n

', '2009-01-30 11:26:48') SQL (2.0ms) COMMIT SQL (8.2ms) INSERT INTO schema_migrations (version) VALUES ('20090130111521') SQL (0.4ms) SHOW TABLES SQL (0.3ms) SELECT version FROM schema_migrations SQL (0.3ms) SHOW TABLES SQL (1.0ms) SHOW FIELDS FROM `products` SQL (1.0ms) describe `products` SQL (0.4ms) SHOW KEYS FROM `products` Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:26:52) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.4ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.1ms) SHOW FIELDS FROM `products` Completed in 37ms (View: 24, DB: 2) | 200 OK [http://localhost/products] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.4ms) SHOW TABLES SQL (0.1ms) SELECT version FROM schema_migrations SQL (0.5ms) SHOW TABLES SQL (0.1ms) SELECT version FROM schema_migrations Migrating to AddTestData (20090130111521) Product Delete all (12.5ms) DELETE FROM `products`  SQL (12.4ms) DELETE FROM schema_migrations WHERE version = '20090130111521' Migrating to AddProductPrice (20090128142730) SQL (22.2ms) ALTER TABLE `products` DROP `price` SQL (0.7ms) DELETE FROM schema_migrations WHERE version = '20090128142730' Migrating to CreateProducts (20080724075409) SQL (6.1ms) DROP TABLE `products` SQL (0.9ms) DELETE FROM schema_migrations WHERE version = '20080724075409' SQL (0.4ms) SHOW TABLES SQL (0.3ms) SELECT version FROM schema_migrations SQL (0.4ms) SHOW TABLES SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 SQL (0.4ms) SHOW TABLES SQL (0.1ms) SELECT version FROM schema_migrations Migrating to CreateProducts (20080724075409) SQL (4.6ms) CREATE TABLE `products` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `image_url` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('20080724075409') Migrating to AddProductPrice (20090128142730) SQL (7.3ms) ALTER TABLE `products` ADD `price` decimal(8,2) DEFAULT 0 SQL (0.8ms) INSERT INTO schema_migrations (version) VALUES ('20090128142730') Migrating to AddTestData (20090130111521) Product Delete all (1.1ms) DELETE FROM `products`  Product Columns (2.5ms) SHOW FIELDS FROM `products` SQL (0.2ms) BEGIN Product Exists (0.5ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Project Automation') LIMIT 1 Product Create (0.4ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/auto.jpg', '2009-01-30 11:28:11', 'Pragmatic Project Automation', 29.95, '

\n Pragmatic Project Automation shows you how to improve the \n consistency and repeatability of your project\'s procedures using \n automation to reduce risk and errors.\n

\n

\n Simply put, we\'re going to put this thing called a computer to work \n for you doing the mundane (but important) project stuff. That means \n you\'ll have more time and energy to do the really \n exciting—and difficult—stuff, like writing quality code.\n

', '2009-01-30 11:28:11') SQL (0.5ms) COMMIT SQL (0.1ms) BEGIN Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Version Control') LIMIT 1 Product Create (0.3ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/svn.jpg', '2009-01-30 11:28:11', 'Pragmatic Version Control', 28.5, '

\n This book is a recipe-based approach to using Subversion that will \n get you up and running quickly—and correctly. All projects need\n version control: it\'s a foundational piece of any project\'s \n infrastructure. Yet half of all project teams in the U.S. don\'t use\n any version control at all. Many others don\'t use it well, and end \n up experiencing time-consuming problems.\n

', '2009-01-30 11:28:11') SQL (0.5ms) COMMIT SQL (0.2ms) BEGIN Product Exists (0.6ms) SELECT `products`.id FROM `products` WHERE (`products`.`title` = BINARY 'Pragmatic Unit Testing (C#)') LIMIT 1 Product Create (0.3ms) INSERT INTO `products` (`image_url`, `updated_at`, `title`, `price`, `description`, `created_at`) VALUES('/images/utc.jpg', '2009-01-30 11:28:11', 'Pragmatic Unit Testing (C#)', 27.75, '

\n Pragmatic programmers use feedback to drive their development and \n personal processes. The most valuable feedback you can get while \n coding comes from unit testing.\n

\n

\n Without good tests in place, coding can become a frustrating game of \n \"whack-a-mole.\" That\'s the carnival game where the player strikes at a \n mechanical mole; it retreats and another mole pops up on the opposite side \n of the field. The moles pop up and down so fast that you end up flailing \n your mallet helplessly as the moles continue to pop up where you least \n expect them.\n

', '2009-01-30 11:28:11') SQL (1.3ms) COMMIT SQL (0.7ms) INSERT INTO schema_migrations (version) VALUES ('20090130111521') SQL (0.9ms) SHOW TABLES SQL (0.4ms) SELECT version FROM schema_migrations SQL (0.3ms) SHOW TABLES SQL (1.0ms) SHOW FIELDS FROM `products` SQL (1.3ms) describe `products` SQL (0.4ms) SHOW KEYS FROM `products` Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:28:19) [GET] SQL (0.3ms) SET SQL_AUTO_IS_NULL=0 Product Load (1.3ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.2ms) SHOW FIELDS FROM `products` Completed in 30ms (View: 15, DB: 3) | 200 OK [http://localhost/products] Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:53:52) [GET] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.3ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.3ms) SHOW FIELDS FROM `products` Completed in 41ms (View: 24, DB: 2) | 200 OK [http://localhost/products] Processing ProductsController#show (for 127.0.0.1 at 2009-01-30 11:53:55) [GET] Parameters: {"id"=>"1"} SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Product Columns (2.1ms) SHOW FIELDS FROM `products` Product Load (0.7ms) SELECT * FROM `products` WHERE (`products`.`id` = 1)  Rendering template within layouts/products Rendering products/show Completed in 41ms (View: 20, DB: 3) | 200 OK [http://localhost/products/1] Processing ProductsController#show (for 127.0.0.1 at 2009-01-30 11:54:35) [GET] Parameters: {"id"=>"3"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.3ms) SHOW FIELDS FROM `products` Product Load (0.4ms) SELECT * FROM `products` WHERE (`products`.`id` = 3)  Rendering template within layouts/products Rendering products/show Completed in 29ms (View: 14, DB: 2) | 200 OK [http://localhost/products/3] Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:54:44) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.3ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.2ms) SHOW FIELDS FROM `products` Completed in 39ms (View: 24, DB: 2) | 200 OK [http://localhost/products] Processing ProductsController#show (for 127.0.0.1 at 2009-01-30 11:55:35) [GET] Parameters: {"id"=>"3"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.1ms) SHOW FIELDS FROM `products` Product Load (0.1ms) SELECT * FROM `products` WHERE (`products`.`id` = 3)  Rendering template within layouts/products Rendering products/show Completed in 27ms (View: 13, DB: 1) | 200 OK [http://localhost/products/3] Processing ProductsController#edit (for 127.0.0.1 at 2009-01-30 11:55:43) [GET] Parameters: {"id"=>"2"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.9ms) SHOW FIELDS FROM `products` Product Load (0.5ms) SELECT * FROM `products` WHERE (`products`.`id` = 2)  Rendering template within layouts/products Rendering products/edit Completed in 33ms (View: 18, DB: 2) | 200 OK [http://localhost/products/2/edit] Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:56:05) [GET] SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.2ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.1ms) SHOW FIELDS FROM `products` Completed in 35ms (View: 20, DB: 1) | 200 OK [http://localhost/products] Processing ProductsController#show (for 127.0.0.1 at 2009-01-30 11:56:08) [GET] Parameters: {"id"=>"2"} SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Columns (1.1ms) SHOW FIELDS FROM `products` Product Load (0.2ms) SELECT * FROM `products` WHERE (`products`.`id` = 2)  Rendering template within layouts/products Rendering products/show Completed in 26ms (View: 12, DB: 1) | 200 OK [http://localhost/products/2] Processing ProductsController#index (for 127.0.0.1 at 2009-01-30 11:56:25) [GET] SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Product Load (0.2ms) SELECT * FROM `products`  Rendering template within layouts/products Rendering products/index Product Columns (1.9ms) SHOW FIELDS FROM `products` Completed in 35ms (View: 21, DB: 2) | 200 OK [http://localhost/products]