Started GET "/" for 127.0.0.1 at 2013-09-02 17:29:46 +0900 Connecting to database specified by database.yml ActionController::RoutingError (No route matches [GET] "/"): actionpack (3.2.14) lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.14) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.14) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.14) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.14) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.14) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/static.rb:63:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/application.rb:231:in `call' rack (1.4.5) lib/rack/content_length.rb:14:in `call' railties (3.2.14) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.5) lib/rack/handler/webrick.rb:59:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/routing_error.erb within rescues/layout (1.5ms) Started GET "/" for 127.0.0.1 at 2013-09-02 17:32:32 +0900 Connecting to database specified by database.yml ActionController::RoutingError (No route matches [GET] "/"): actionpack (3.2.14) lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.14) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.14) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.14) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.14) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.14) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/static.rb:63:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/application.rb:231:in `call' rack (1.4.5) lib/rack/content_length.rb:14:in `call' railties (3.2.14) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.5) lib/rack/handler/webrick.rb:59:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/routing_error.erb within rescues/layout (1.4ms) Started GET "/heart" for 127.0.0.1 at 2013-09-02 17:32:36 +0900 Processing by Heart::DashboardsController#default as HTML Completed 500 Internal Server Error in 2ms NameError (undefined local variable or method `login_required' for #): activesupport (3.2.14) lib/active_support/callbacks.rb:429:in `_run__2412702781360070980__process_action__3183586525168145007__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:17:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rescue.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `block in instrument' activesupport (3.2.14) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `instrument' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/params_wrapper.rb:207:in `process_action' activerecord (3.2.14) lib/active_record/railties/controller_runtime.rb:18:in `process_action' actionpack (3.2.14) lib/abstract_controller/base.rb:121:in `process' actionpack (3.2.14) lib/abstract_controller/rendering.rb:45:in `process' actionpack (3.2.14) lib/action_controller/metal.rb:203:in `dispatch' actionpack (3.2.14) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' actionpack (3.2.14) lib/action_controller/metal.rb:246:in `block in action' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `dispatch' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:36:in `call' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/railtie/configurable.rb:30:in `method_missing' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' rack (1.4.5) lib/rack/etag.rb:23:in `call' rack (1.4.5) lib/rack/conditionalget.rb:25:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/head.rb:14:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/params_parser.rb:21:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/flash.rb:242:in `call' rack (1.4.5) lib/rack/session/abstract/id.rb:210:in `context' rack (1.4.5) lib/rack/session/abstract/id.rb:205:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/cookies.rb:341:in `call' activerecord (3.2.14) lib/active_record/query_cache.rb:64:in `call' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `_run__1413434976434168771__call__2470357054874793741__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_call_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:27:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/reloader.rb:65:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/remote_ip.rb:31:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.14) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.14) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.14) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.14) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.14) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/static.rb:63:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/application.rb:231:in `call' rack (1.4.5) lib/rack/content_length.rb:14:in `call' railties (3.2.14) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.5) lib/rack/handler/webrick.rb:59:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_trace.erb (0.9ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (0.8ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (7.1ms) Started GET "/heart" for 127.0.0.1 at 2013-09-02 17:32:55 +0900 Processing by Heart::DashboardsController#default as HTML Completed 500 Internal Server Error in 26ms ActiveRecord::StatementInvalid (Could not find table 'heart_dashboards'): activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:472:in `table_structure' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:346:in `columns' activerecord (3.2.14) lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize' activerecord (3.2.14) lib/active_record/model_schema.rb:229:in `yield' activerecord (3.2.14) lib/active_record/model_schema.rb:229:in `default' activerecord (3.2.14) lib/active_record/model_schema.rb:229:in `columns' activerecord (3.2.14) lib/active_record/model_schema.rb:238:in `columns_hash' activerecord (3.2.14) lib/active_record/locking/optimistic.rb:131:in `locking_enabled?' activerecord (3.2.14) lib/active_record/relation.rb:170:in `exec_queries' activerecord (3.2.14) lib/active_record/relation.rb:160:in `block in to_a' activerecord (3.2.14) lib/active_record/explain.rb:34:in `logging_query_plan' activerecord (3.2.14) lib/active_record/relation.rb:159:in `to_a' activerecord (3.2.14) lib/active_record/relation/finder_methods.rb:381:in `find_first' activerecord (3.2.14) lib/active_record/relation/finder_methods.rb:122:in `first' /Users/cwabbott/work/innovationtime/engine/heart/app/controllers/heart/dashboards_controller.rb:65:in `default' actionpack (3.2.14) lib/action_controller/metal/implicit_render.rb:4:in `send_action' actionpack (3.2.14) lib/abstract_controller/base.rb:167:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rendering.rb:10:in `process_action' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:18:in `block in process_action' activesupport (3.2.14) lib/active_support/callbacks.rb:425:in `_run__2412702781360070980__process_action__3183586525168145007__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:17:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rescue.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `block in instrument' activesupport (3.2.14) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `instrument' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/params_wrapper.rb:207:in `process_action' activerecord (3.2.14) lib/active_record/railties/controller_runtime.rb:18:in `process_action' actionpack (3.2.14) lib/abstract_controller/base.rb:121:in `process' actionpack (3.2.14) lib/abstract_controller/rendering.rb:45:in `process' actionpack (3.2.14) lib/action_controller/metal.rb:203:in `dispatch' actionpack (3.2.14) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' actionpack (3.2.14) lib/action_controller/metal.rb:246:in `block in action' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `dispatch' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:36:in `call' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/railtie/configurable.rb:30:in `method_missing' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' rack (1.4.5) lib/rack/etag.rb:23:in `call' rack (1.4.5) lib/rack/conditionalget.rb:25:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/head.rb:14:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/params_parser.rb:21:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/flash.rb:242:in `call' rack (1.4.5) lib/rack/session/abstract/id.rb:210:in `context' rack (1.4.5) lib/rack/session/abstract/id.rb:205:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/cookies.rb:341:in `call' activerecord (3.2.14) lib/active_record/query_cache.rb:64:in `call' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `_run__1413434976434168771__call__2470357054874793741__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_call_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:27:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/reloader.rb:65:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/remote_ip.rb:31:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.14) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.14) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.14) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.14) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.14) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/static.rb:63:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/application.rb:231:in `call' rack (1.4.5) lib/rack/content_length.rb:14:in `call' railties (3.2.14) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.5) lib/rack/handler/webrick.rb:59:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.0ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (0.7ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (5.6ms) Connecting to database specified by database.yml  (0.1ms) select sqlite_version(*)  (1.3ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)  (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" Migrating to CreateHeartMetrics (20130902083428)  (0.0ms) begin transaction  (0.4ms) CREATE TABLE "heart_metrics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "fulldate" date, "dayofweek" integer, "dayofyear" integer, "weekofyear" integer, "monthofyear" integer, "year" integer, "movingaverage" integer DEFAULT 0, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) CREATE INDEX "index_metrics_on_movingaverage" ON "metrics" ("movingaverage") SQLite3::SQLException: no such table: main.metrics: CREATE INDEX "index_metrics_on_movingaverage" ON "metrics" ("movingaverage")  (0.9ms) rollback transaction Connecting to database specified by database.yml  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  Migrating to CreateHeartMetrics (20130902083555)  (0.0ms) select sqlite_version(*)  (0.0ms) begin transaction  (0.5ms) CREATE TABLE "heart_metrics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "fulldate" date, "dayofweek" integer, "dayofyear" integer, "weekofyear" integer, "monthofyear" integer, "year" integer, "movingaverage" integer DEFAULT 0, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) CREATE INDEX "index_heart_metrics_on_movingaverage" ON "heart_metrics" ("movingaverage")  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20130902083555')  (2.1ms) commit transaction Migrating to CreateHeartIsometrics (20130902083556)  (0.0ms) begin transaction  (0.3ms) CREATE TABLE "heart_isometrics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "fulldate" date, "movingaverage" integer DEFAULT 0, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20130902083556')  (0.7ms) commit transaction Migrating to CreateHeartDashboards (20130902083557)  (0.0ms) begin transaction  (0.4ms) CREATE TABLE "heart_dashboards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "dashboard" text, "description" text, "date_from" date, "status" integer, "supplement" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20130902083557')  (0.6ms) commit transaction Migrating to CreateHeartAnnotations (20130902083558)  (0.0ms) begin transaction  (0.3ms) CREATE TABLE "heart_annotations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "fulldate" date, "note" varchar(255), "dashboard_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20130902083558')  (0.6ms) commit transaction Migrating to CreateHeartImages (20130902083559)  (0.0ms) begin transaction  (0.3ms) CREATE TABLE "heart_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "dashboard_id" integer, "purpose" varchar(255), "dataurl" text(4294967295), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20130902083559')  (0.6ms) commit transaction Migrating to CreateHeartConfigurations (20130902083560)  (0.0ms) begin transaction  (0.3ms) CREATE TABLE "heart_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "auth" varchar(255), "username" varchar(255), "password" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20130902083560')  (0.5ms) commit transaction  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" Started GET "/heart" for 127.0.0.1 at 2013-09-02 17:36:25 +0900 Connecting to database specified by database.yml Processing by Heart::DashboardsController#default as HTML Heart::Dashboard Load (0.1ms) SELECT "heart_dashboards".* FROM "heart_dashboards" WHERE "heart_dashboards"."title" = 'Default' LIMIT 1 Heart::Annotation Load (0.2ms) SELECT "heart_annotations".* FROM "heart_annotations" WHERE "heart_annotations"."dashboard_id" IS NULL AND ("heart_annotations"."fulldate" BETWEEN '2008-09-02' AND '2013-09-02') ORDER BY fulldate ASC Heart::Metric Load (0.3ms) SELECT fulldate, fulldate AS d, year, monthofyear AS month, dayofyear AS day, '90' AS movingaverage FROM metrics WHERE fulldate > SUBDATE(NOW(), 90) AND movingaverage = 90 GROUP BY fulldate ORDER BY d ASC SQLite3::SQLException: no such table: metrics: SELECT fulldate, fulldate AS d, year, monthofyear AS month, dayofyear AS day, '90' AS movingaverage FROM metrics WHERE fulldate > SUBDATE(NOW(), 90) AND movingaverage = 90 GROUP BY fulldate ORDER BY d ASC Completed 500 Internal Server Error in 58ms ActiveRecord::StatementInvalid (SQLite3::SQLException: no such table: metrics: SELECT fulldate, fulldate AS d, year, monthofyear AS month, dayofyear AS day, '90' AS movingaverage FROM metrics WHERE fulldate > SUBDATE(NOW(), 90) AND movingaverage = 90 GROUP BY fulldate ORDER BY d ASC): sqlite3 (1.3.8) lib/sqlite3/database.rb:91:in `initialize' sqlite3 (1.3.8) lib/sqlite3/database.rb:91:in `new' sqlite3 (1.3.8) lib/sqlite3/database.rb:91:in `prepare' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:246:in `block in exec_query' activerecord (3.2.14) lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log' activesupport (3.2.14) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activerecord (3.2.14) lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:242:in `exec_query' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:467:in `select' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all' activerecord (3.2.14) lib/active_record/querying.rb:38:in `block in find_by_sql' activerecord (3.2.14) lib/active_record/explain.rb:34:in `logging_query_plan' activerecord (3.2.14) lib/active_record/querying.rb:37:in `find_by_sql' /Users/cwabbott/work/innovationtime/engine/heart/app/models/heart/metric.rb:100:in `aggregate_daily_moving_averages' /Users/cwabbott/work/innovationtime/engine/heart/app/controllers/heart/dashboards_controller.rb:67:in `default' actionpack (3.2.14) lib/action_controller/metal/implicit_render.rb:4:in `send_action' actionpack (3.2.14) lib/abstract_controller/base.rb:167:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rendering.rb:10:in `process_action' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:18:in `block in process_action' activesupport (3.2.14) lib/active_support/callbacks.rb:425:in `_run__2090397386611503088__process_action__1853030207831234485__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:17:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rescue.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `block in instrument' activesupport (3.2.14) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `instrument' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/params_wrapper.rb:207:in `process_action' activerecord (3.2.14) lib/active_record/railties/controller_runtime.rb:18:in `process_action' actionpack (3.2.14) lib/abstract_controller/base.rb:121:in `process' actionpack (3.2.14) lib/abstract_controller/rendering.rb:45:in `process' actionpack (3.2.14) lib/action_controller/metal.rb:203:in `dispatch' actionpack (3.2.14) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' actionpack (3.2.14) lib/action_controller/metal.rb:246:in `block in action' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `dispatch' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:36:in `call' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/railtie/configurable.rb:30:in `method_missing' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' rack (1.4.5) lib/rack/etag.rb:23:in `call' rack (1.4.5) lib/rack/conditionalget.rb:25:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/head.rb:14:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/params_parser.rb:21:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/flash.rb:242:in `call' rack (1.4.5) lib/rack/session/abstract/id.rb:210:in `context' rack (1.4.5) lib/rack/session/abstract/id.rb:205:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/cookies.rb:341:in `call' activerecord (3.2.14) lib/active_record/query_cache.rb:64:in `call' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `_run__3147548099089648966__call__451232412091413659__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_call_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:27:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/reloader.rb:65:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/remote_ip.rb:31:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.14) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.14) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.14) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.14) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.14) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/static.rb:63:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/application.rb:231:in `call' rack (1.4.5) lib/rack/content_length.rb:14:in `call' railties (3.2.14) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.5) lib/rack/handler/webrick.rb:59:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_trace.erb (0.9ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (0.7ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (6.5ms) Started GET "/heart" for 127.0.0.1 at 2013-09-02 17:37:35 +0900 Processing by Heart::DashboardsController#default as HTML Heart::Dashboard Load (0.1ms) SELECT "heart_dashboards".* FROM "heart_dashboards" WHERE "heart_dashboards"."title" = 'Default' LIMIT 1 Heart::Annotation Load (0.1ms) SELECT "heart_annotations".* FROM "heart_annotations" WHERE "heart_annotations"."dashboard_id" IS NULL AND ("heart_annotations"."fulldate" BETWEEN '2008-09-02' AND '2013-09-02') ORDER BY fulldate ASC Heart::Metric Load (0.2ms) SELECT fulldate, fulldate AS d, year, monthofyear AS month, dayofyear AS day, '90' AS movingaverage FROM heart_metrics WHERE fulldate > SUBDATE(NOW(), 90) AND movingaverage = 90 GROUP BY fulldate ORDER BY d ASC SQLite3::SQLException: no such function: NOW: SELECT fulldate, fulldate AS d, year, monthofyear AS month, dayofyear AS day, '90' AS movingaverage FROM heart_metrics WHERE fulldate > SUBDATE(NOW(), 90) AND movingaverage = 90 GROUP BY fulldate ORDER BY d ASC Completed 500 Internal Server Error in 16ms ActiveRecord::StatementInvalid (SQLite3::SQLException: no such function: NOW: SELECT fulldate, fulldate AS d, year, monthofyear AS month, dayofyear AS day, '90' AS movingaverage FROM heart_metrics WHERE fulldate > SUBDATE(NOW(), 90) AND movingaverage = 90 GROUP BY fulldate ORDER BY d ASC): sqlite3 (1.3.8) lib/sqlite3/database.rb:91:in `initialize' sqlite3 (1.3.8) lib/sqlite3/database.rb:91:in `new' sqlite3 (1.3.8) lib/sqlite3/database.rb:91:in `prepare' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:246:in `block in exec_query' activerecord (3.2.14) lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log' activesupport (3.2.14) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activerecord (3.2.14) lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:242:in `exec_query' activerecord (3.2.14) lib/active_record/connection_adapters/sqlite_adapter.rb:467:in `select' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all' activerecord (3.2.14) lib/active_record/querying.rb:38:in `block in find_by_sql' activerecord (3.2.14) lib/active_record/explain.rb:34:in `logging_query_plan' activerecord (3.2.14) lib/active_record/querying.rb:37:in `find_by_sql' /Users/cwabbott/work/innovationtime/engine/heart/app/models/heart/metric.rb:100:in `aggregate_daily_moving_averages' /Users/cwabbott/work/innovationtime/engine/heart/app/controllers/heart/dashboards_controller.rb:67:in `default' actionpack (3.2.14) lib/action_controller/metal/implicit_render.rb:4:in `send_action' actionpack (3.2.14) lib/abstract_controller/base.rb:167:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rendering.rb:10:in `process_action' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:18:in `block in process_action' activesupport (3.2.14) lib/active_support/callbacks.rb:425:in `_run__2090397386611503088__process_action__1853030207831234485__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/abstract_controller/callbacks.rb:17:in `process_action' actionpack (3.2.14) lib/action_controller/metal/rescue.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `block in instrument' activesupport (3.2.14) lib/active_support/notifications/instrumenter.rb:20:in `instrument' activesupport (3.2.14) lib/active_support/notifications.rb:123:in `instrument' actionpack (3.2.14) lib/action_controller/metal/instrumentation.rb:29:in `process_action' actionpack (3.2.14) lib/action_controller/metal/params_wrapper.rb:207:in `process_action' activerecord (3.2.14) lib/active_record/railties/controller_runtime.rb:18:in `process_action' actionpack (3.2.14) lib/abstract_controller/base.rb:121:in `process' actionpack (3.2.14) lib/abstract_controller/rendering.rb:45:in `process' actionpack (3.2.14) lib/action_controller/metal.rb:203:in `dispatch' actionpack (3.2.14) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' actionpack (3.2.14) lib/action_controller/metal.rb:246:in `block in action' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:73:in `dispatch' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:36:in `call' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/railtie/configurable.rb:30:in `method_missing' journey (1.0.4) lib/journey/router.rb:68:in `block in call' journey (1.0.4) lib/journey/router.rb:56:in `each' journey (1.0.4) lib/journey/router.rb:56:in `call' actionpack (3.2.14) lib/action_dispatch/routing/route_set.rb:608:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' rack (1.4.5) lib/rack/etag.rb:23:in `call' rack (1.4.5) lib/rack/conditionalget.rb:25:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/head.rb:14:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/params_parser.rb:21:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/flash.rb:242:in `call' rack (1.4.5) lib/rack/session/abstract/id.rb:210:in `context' rack (1.4.5) lib/rack/session/abstract/id.rb:205:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/cookies.rb:341:in `call' activerecord (3.2.14) lib/active_record/query_cache.rb:64:in `call' activerecord (3.2.14) lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `_run__3147548099089648966__call__451232412091413659__callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:405:in `__run_callback' activesupport (3.2.14) lib/active_support/callbacks.rb:385:in `_run_call_callbacks' activesupport (3.2.14) lib/active_support/callbacks.rb:81:in `run_callbacks' actionpack (3.2.14) lib/action_dispatch/middleware/callbacks.rb:27:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/reloader.rb:65:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/remote_ip.rb:31:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.14) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.14) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.14) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.14) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.5) lib/rack/methodoverride.rb:21:in `call' rack (1.4.5) lib/rack/runtime.rb:17:in `call' activesupport (3.2.14) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.5) lib/rack/lock.rb:15:in `call' actionpack (3.2.14) lib/action_dispatch/middleware/static.rb:63:in `call' railties (3.2.14) lib/rails/engine.rb:484:in `call' railties (3.2.14) lib/rails/application.rb:231:in `call' rack (1.4.5) lib/rack/content_length.rb:14:in `call' railties (3.2.14) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.5) lib/rack/handler/webrick.rb:59:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/cwabbott/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_trace.erb (23.9ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (0.8ms) Rendered /Users/cwabbott/.rvm/gems/ruby-1.9.3-p194/gems/actionpack-3.2.14/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (28.8ms) Connecting to database specified by database.yml Connecting to database specified by database.yml  (69.5ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (25.4ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (1.3ms) SELECT `schema_migrations`.`version` FROM `schema_migrations`  Migrating to CreateHeartMetrics (20130902083555)  (19.0ms) CREATE TABLE `heart_metrics` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `fulldate` date, `dayofweek` int(11), `dayofyear` int(11), `weekofyear` int(11), `monthofyear` int(11), `year` int(11), `movingaverage` int(11) DEFAULT 0, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (17.4ms) CREATE INDEX `index_heart_metrics_on_movingaverage` ON `heart_metrics` (`movingaverage`)  (0.3ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20130902083555') Migrating to CreateHeartIsometrics (20130902083556)  (8.8ms) CREATE TABLE `heart_isometrics` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `fulldate` date, `movingaverage` int(11) DEFAULT 0, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (0.4ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20130902083556') Migrating to CreateHeartDashboards (20130902083557)  (12.5ms) CREATE TABLE `heart_dashboards` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `dashboard` text, `description` text, `date_from` date, `status` int(11), `supplement` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (0.5ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20130902083557') Migrating to CreateHeartAnnotations (20130902083558)  (13.6ms) CREATE TABLE `heart_annotations` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `fulldate` date, `note` varchar(255), `dashboard_id` int(11), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (0.3ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20130902083558') Migrating to CreateHeartImages (20130902083559)  (14.2ms) CREATE TABLE `heart_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `dashboard_id` int(11), `purpose` varchar(255), `dataurl` longtext, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (0.4ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20130902083559') Migrating to CreateHeartConfigurations (20130902083560)  (17.3ms) CREATE TABLE `heart_configurations` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `auth` varchar(255), `username` varchar(255), `password` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (0.3ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20130902083560')  (0.2ms) SELECT `schema_migrations`.`version` FROM `schema_migrations`  Connecting to database specified by database.yml  (1.5ms) SELECT `schema_migrations`.`version` FROM `schema_migrations`   (0.8ms) DROP DATABASE IF EXISTS `heart_dummy_test`  (3.7ms) CREATE DATABASE `heart_dummy_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (18.0ms) CREATE TABLE `heart_annotations` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `fulldate` date, `note` varchar(255), `dashboard_id` int(11), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (18.1ms) CREATE TABLE `heart_configurations` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `auth` varchar(255), `username` varchar(255), `password` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (9.0ms) CREATE TABLE `heart_dashboards` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `dashboard` text, `description` text, `date_from` date, `status` int(11), `supplement` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (9.1ms) CREATE TABLE `heart_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `dashboard_id` int(11), `purpose` varchar(255), `dataurl` longtext, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (8.9ms) CREATE TABLE `heart_isometrics` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `fulldate` date, `movingaverage` int(11) DEFAULT 0, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (9.0ms) CREATE TABLE `heart_metrics` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `fulldate` date, `dayofweek` int(11), `dayofyear` int(11), `weekofyear` int(11), `monthofyear` int(11), `year` int(11), `movingaverage` int(11) DEFAULT 0, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB  (20.0ms) CREATE INDEX `index_heart_metrics_on_movingaverage` ON `heart_metrics` (`movingaverage`)  (15.6ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (18.0ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.1ms) SELECT version FROM `schema_migrations`  (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('20130902083560')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20130902083555')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20130902083556')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20130902083557')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20130902083558')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20130902083559')