test/dummy/log/development.log in survey_says-0.0.1 vs test/dummy/log/development.log in survey_says-0.0.2

- old
+ new

@@ -11104,5 +11104,258 @@ Served asset /survey_says.js - 200 OK (0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2011-12-14 03:53:30 -0500 Served asset /jquery.js - 304 Not Modified (2ms) +  (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateUsers (20111010112000) +Migrating to CreateQuestions (20111208181247) +Migrating to CreateAnswers (20111208181414) +Migrating to CreateSurveyProperties (20111208181429) +Migrating to CreateScores (20111208181449) +Migrating to CreateUserAnswers (20111211175518) +Migrating to CreateQuestionnaires (20111211175604) +Migrating to AddQuestionaireIdToQuestions (20111211180011) +Migrating to CreateSurveyImages (20111213185612) +  (0.3ms) select sqlite_version(*) +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.0ms) PRAGMA index_list("answers") +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.0ms) PRAGMA index_info('index_questionnaires_on_name') +  (0.0ms) PRAGMA index_list("questions") +  (0.0ms) PRAGMA index_info('index_questions_on_questionnaire_id') +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_list("survey_images") +  (0.0ms) PRAGMA index_list("survey_properties") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.0ms) PRAGMA index_list("users") +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateUsers (20111010112000) +  (0.3ms) select sqlite_version(*) +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.0ms) PRAGMA index_list("answers") +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.0ms) PRAGMA index_info('index_questionnaires_on_name') +  (0.0ms) PRAGMA index_list("questions") +  (0.0ms) PRAGMA index_info('index_questions_on_questionnaire_id') +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_list("survey_images") +  (0.0ms) PRAGMA index_list("survey_properties") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.0ms) PRAGMA index_list("users") +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.2ms) select sqlite_version(*) +  (1.4ms) CREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer, "details" text, "active" boolean, "position" integer, "created_at" datetime, "updated_at" datetime)  +  (1.1ms) CREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL) +  (0.0ms) PRAGMA index_list("questionnaires") +  (1.1ms) CREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name") +  (1.0ms) CREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text, "active" boolean, "position" integer, "created_at" datetime, "updated_at" datetime, "questionnaire_id" integer)  +  (0.0ms) PRAGMA index_list("questions") +  (1.1ms) CREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id") +  (0.9ms) CREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "survey_property_id" integer, "value" integer, "created_at" datetime, "updated_at" datetime) +  (1.2ms) CREATE TABLE "survey_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "imageable_id" integer, "imageable_type" varchar(255), "position" integer, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "caption" varchar(255), "created_at" datetime, "updated_at" datetime)  +  (1.3ms) CREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) +  (1.1ms) CREATE TABLE "user_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "answer_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)  +  (0.0ms) PRAGMA index_list("user_answers") +  (1.0ms) CREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.9ms) CREATE INDEX "index_user_answers_on_user_id" ON "user_answers" ("user_id") +  (1.0ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))  +  (1.0ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) +  (0.0ms) PRAGMA index_list("schema_migrations") +  (1.1ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") +  (0.1ms) SELECT version FROM "schema_migrations" +  (1.0ms) INSERT INTO "schema_migrations" (version) VALUES ('20111213185612') +  (1.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20111010112000') +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateUsers (20111010112000) +  (0.3ms) select sqlite_version(*) +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.0ms) PRAGMA index_list("answers") +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.0ms) PRAGMA index_info('index_questionnaires_on_name') +  (0.0ms) PRAGMA index_list("questions") +  (0.0ms) PRAGMA index_info('index_questions_on_questionnaire_id') +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_list("survey_images") +  (0.0ms) PRAGMA index_list("survey_properties") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.0ms) PRAGMA index_list("users") +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateUsers (20111010112000) +Migrating to CreateQuestions (20111208181247) +Migrating to CreateAnswers (20111208181414) +Migrating to CreateSurveyProperties (20111208181429) +Migrating to CreateScores (20111208181449) +Migrating to CreateUserAnswers (20111211175518) +Migrating to CreateQuestionnaires (20111211175604) +Migrating to AddQuestionaireIdToQuestions (20111211180011) +Migrating to CreateSurveyImages (20111213185612) +  (0.3ms) select sqlite_version(*) +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.0ms) PRAGMA index_list("answers") +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.0ms) PRAGMA index_info('index_questionnaires_on_name') +  (0.0ms) PRAGMA index_list("questions") +  (0.0ms) PRAGMA index_info('index_questions_on_questionnaire_id') +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_list("survey_images") +  (0.0ms) PRAGMA index_list("survey_properties") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.0ms) PRAGMA index_list("users") +  (0.1ms) select sqlite_version(*) +  (1.1ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) +  (0.0ms) PRAGMA index_list("schema_migrations") +  (1.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateUsers (20111010112000) +  (0.4ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111010112000') +Migrating to CreateQuestions (20111208181247) +  (0.4ms) CREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text NOT NULL, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime) +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111208181247') +Migrating to CreateAnswers (20111208181414) +  (0.3ms) CREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer NOT NULL, "details" text, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime) +  (0.0ms) PRAGMA index_list("answers") +  (0.1ms) CREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id") +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111208181414') +Migrating to CreateSurveyProperties (20111208181429) +  (0.3ms) CREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime) +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111208181429') +Migrating to CreateScores (20111208181449) +  (0.3ms) CREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer NOT NULL, "survey_property_id" integer NOT NULL, "value" integer NOT NULL, "created_at" datetime, "updated_at" datetime) +  (0.0ms) PRAGMA index_list("scores") +  (0.1ms) CREATE INDEX "index_scores_on_answer_id" ON "scores" ("answer_id") +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_info('index_scores_on_answer_id') +  (0.1ms) CREATE INDEX "index_scores_on_survey_property_id" ON "scores" ("survey_property_id") +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111208181449') +Migrating to CreateUserAnswers (20111211175518) +  (0.3ms) CREATE TABLE "user_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "answer_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)  +  (0.0ms) PRAGMA index_list("user_answers") +  (0.1ms) CREATE INDEX "index_user_answers_on_user_id" ON "user_answers" ("user_id") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.1ms) CREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id") +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111211175518') +Migrating to CreateQuestionnaires (20111211175604) +  (0.3ms) CREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL) +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.1ms) CREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name") +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111211175604') +Migrating to AddQuestionaireIdToQuestions (20111211180011) +  (0.6ms) ALTER TABLE "questions" ADD "questionnaire_id" integer +  (0.1ms) PRAGMA index_list("questions") +  (0.2ms) CREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id") +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111211180011') +Migrating to CreateSurveyImages (20111213185612) +  (0.4ms) CREATE TABLE "survey_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "imageable_id" integer, "imageable_type" varchar(255), "position" integer, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "caption" varchar(255), "created_at" datetime, "updated_at" datetime) +  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20111213185612') +  (0.3ms) select sqlite_version(*) +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.0ms) PRAGMA index_list("answers") +  (0.0ms) PRAGMA index_info('index_answers_on_question_id') +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.0ms) PRAGMA index_info('index_questionnaires_on_name') +  (0.0ms) PRAGMA index_list("questions") +  (0.0ms) PRAGMA index_info('index_questions_on_questionnaire_id') +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_info('index_scores_on_survey_property_id') +  (0.0ms) PRAGMA index_info('index_scores_on_answer_id') +  (0.0ms) PRAGMA index_list("survey_images") +  (0.0ms) PRAGMA index_list("survey_properties") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.0ms) PRAGMA index_list("users") +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +Migrating to CreateUsers (20111010112000) +  (0.3ms) select sqlite_version(*) +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.0ms) PRAGMA index_list("answers") +  (0.0ms) PRAGMA index_info('index_answers_on_question_id') +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.0ms) PRAGMA index_info('index_questionnaires_on_name') +  (0.0ms) PRAGMA index_list("questions") +  (0.0ms) PRAGMA index_info('index_questions_on_questionnaire_id') +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_info('index_scores_on_survey_property_id') +  (0.0ms) PRAGMA index_info('index_scores_on_answer_id') +  (0.0ms) PRAGMA index_list("survey_images") +  (0.0ms) PRAGMA index_list("survey_properties") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.0ms) PRAGMA index_info('index_user_answers_on_user_id') +  (0.0ms) PRAGMA index_list("users") +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.2ms) select sqlite_version(*) +  (1.2ms) CREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer NOT NULL, "details" text, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime)  +  (0.1ms) PRAGMA index_list("answers") +  (0.7ms) CREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id") +  (0.7ms) CREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL) +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.8ms) CREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name") +  (0.9ms) CREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text NOT NULL, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime, "questionnaire_id" integer)  +  (0.0ms) PRAGMA index_list("questions") +  (0.7ms) CREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id") +  (0.9ms) CREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer NOT NULL, "survey_property_id" integer NOT NULL, "value" integer NOT NULL, "created_at" datetime, "updated_at" datetime) +  (0.0ms) PRAGMA index_list("scores") +  (0.7ms) CREATE INDEX "index_scores_on_answer_id" ON "scores" ("answer_id") +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_info('index_scores_on_answer_id') +  (0.6ms) CREATE INDEX "index_scores_on_survey_property_id" ON "scores" ("survey_property_id") +  (0.8ms) CREATE TABLE "survey_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "imageable_id" integer, "imageable_type" varchar(255), "position" integer, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "caption" varchar(255), "created_at" datetime, "updated_at" datetime) +  (0.8ms) CREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)  +  (0.8ms) CREATE TABLE "user_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "answer_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime) +  (0.0ms) PRAGMA index_list("user_answers") +  (0.7ms) CREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (0.7ms) CREATE INDEX "index_user_answers_on_user_id" ON "user_answers" ("user_id") +  (0.8ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) +  (0.7ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)  +  (0.0ms) PRAGMA index_list("schema_migrations") +  (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") +  (0.1ms) SELECT version FROM "schema_migrations" +  (0.9ms) INSERT INTO "schema_migrations" (version) VALUES ('20111213185612') +  (0.7ms) INSERT INTO "schema_migrations" (version) VALUES ('20111010112000') +  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations"  +  (0.2ms) select sqlite_version(*) +  (1.2ms) CREATE TABLE "answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "question_id" integer NOT NULL, "details" text, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime)  +  (0.0ms) PRAGMA index_list("answers") +  (0.8ms) CREATE INDEX "index_answers_on_question_id" ON "answers" ("question_id") +  (1.3ms) CREATE TABLE "questionnaires" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL) +  (0.0ms) PRAGMA index_list("questionnaires") +  (0.8ms) CREATE INDEX "index_questionnaires_on_name" ON "questionnaires" ("name") +  (1.3ms) CREATE TABLE "questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "details" text NOT NULL, "active" boolean DEFAULT 't', "position" integer, "created_at" datetime, "updated_at" datetime, "questionnaire_id" integer)  +  (0.0ms) PRAGMA index_list("questions") +  (1.0ms) CREATE INDEX "index_questions_on_questionnaire_id" ON "questions" ("questionnaire_id") +  (1.1ms) CREATE TABLE "scores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer NOT NULL, "survey_property_id" integer NOT NULL, "value" integer NOT NULL, "created_at" datetime, "updated_at" datetime) +  (0.0ms) PRAGMA index_list("scores") +  (0.9ms) CREATE INDEX "index_scores_on_answer_id" ON "scores" ("answer_id") +  (0.0ms) PRAGMA index_list("scores") +  (0.0ms) PRAGMA index_info('index_scores_on_answer_id') +  (1.2ms) CREATE INDEX "index_scores_on_survey_property_id" ON "scores" ("survey_property_id") +  (1.0ms) CREATE TABLE "survey_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "imageable_id" integer, "imageable_type" varchar(255), "position" integer, "photo_file_name" varchar(255), "photo_content_type" varchar(255), "photo_file_size" integer, "caption" varchar(255), "created_at" datetime, "updated_at" datetime) +  (1.2ms) CREATE TABLE "survey_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)  +  (0.8ms) CREATE TABLE "user_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "answer_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime) +  (0.0ms) PRAGMA index_list("user_answers") +  (0.7ms) CREATE INDEX "index_user_answers_on_answer_id" ON "user_answers" ("answer_id") +  (0.0ms) PRAGMA index_list("user_answers") +  (0.0ms) PRAGMA index_info('index_user_answers_on_answer_id') +  (1.0ms) CREATE INDEX "index_user_answers_on_user_id" ON "user_answers" ("user_id") +  (1.1ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) +  (0.8ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)  +  (0.0ms) PRAGMA index_list("schema_migrations") +  (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") +  (0.1ms) SELECT version FROM "schema_migrations" +  (1.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20111213185612') +  (1.1ms) INSERT INTO "schema_migrations" (version) VALUES ('20111010112000')