test/dummy/log/development.log in query_report-1.0.3 vs test/dummy/log/development.log in query_report-1.0.4

- old
+ new

@@ -38170,5 +38170,603 @@  (0.1ms) commit transaction  (0.1ms) begin transaction SQL (0.3ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Fri, 06 Sep 2013 16:16:40 UTC +00:00], ["dob", Thu, 06 Sep 1979 16:16:40 UTC +00:00], ["name", "User#3"], ["updated_at", Fri, 06 Sep 2013 16:16:40 UTC +00:00]]  (0.1ms) commit transaction User Load (0.2ms) SELECT "users".* FROM "users" +Connecting to database specified by database.yml +  (1.4ms) select sqlite_version(*) +  (0.2ms) CREATE TABLE "gem_defined_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer) +  (0.1ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer, "dob" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.1ms) CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255)) +  (0.1ms) CREATE TABLE "readerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer)  +  (0.1ms) CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer) +  (0.1ms) CREATE TABLE "user_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255), "user_id" integer)  +  (0.0ms) begin transaction + SQL (35.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 30], ["created_at", Sat, 07 Sep 2013 11:13:04 UTC +00:00], ["dob", nil], ["name", "Jitu"], ["updated_at", Sat, 07 Sep 2013 11:13:04 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "readerships" ("book_id", "user_id") VALUES (?, ?) [["book_id", nil], ["user_id", 1]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 1]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."age" = 34 LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 2]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 3]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 4]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE (("users"."age" = 10 AND "users"."created_at" >= '2013-04-07 00:00:00.000000' AND "users"."created_at" <= '2013-10-07 00:00:00.000000')) LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 5]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 6]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 7]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 8]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 9]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 10]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 11]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 12]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 13]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:13:05 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.1ms) SELECT AVG("users"."age") AS avg_id FROM "users" +  (0.0ms) SELECT AVG("users"."age") AS avg_id FROM "users"  + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 14]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 15]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 16]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:06 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:13:06 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:06 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 17]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 18]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 19]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:13:06 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:13:06 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:13:06 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:13:06 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" +Connecting to database specified by database.yml +  (1.5ms) select sqlite_version(*) +  (0.2ms) CREATE TABLE "gem_defined_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer) +  (0.1ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer, "dob" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.1ms) CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255)) +  (0.1ms) CREATE TABLE "readerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer)  +  (0.1ms) CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer) +  (0.1ms) CREATE TABLE "user_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255), "user_id" integer)  + User Load (1.0ms) SELECT "users".* FROM "users" +  (0.0ms) begin transaction + SQL (2.7ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:15:05 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 1]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 2]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 3]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:05 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:15:05 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:05 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:05 UTC +00:00]] +  (0.0ms) commit transaction +  (0.1ms) SELECT AVG("users"."age") AS avg_id FROM "users" +  (0.0ms) SELECT AVG("users"."age") AS avg_id FROM "users"  + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 4]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 5]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 6]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:06 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:15:06 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:06 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 7]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 8]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 9]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:06 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:06 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."age" = 34 LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 10]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 11]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 12]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:06 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:06 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE (("users"."age" = 10 AND "users"."dob" >= '1993-09-07 00:00:00.000000' AND "users"."dob" <= '2013-10-07 00:00:00.000000')) LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 13]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 14]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 15]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:06 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:06 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:06 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.2ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 16]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 17]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 18]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:15:07 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:15:07 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" LIMIT 25 OFFSET 0 +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 30], ["created_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00], ["dob", nil], ["name", "Jitu"], ["updated_at", Sat, 07 Sep 2013 11:15:07 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "readerships" ("book_id", "user_id") VALUES (?, ?) [["book_id", nil], ["user_id", 22]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 22 LIMIT 1 +Connecting to database specified by database.yml +  (1.4ms) select sqlite_version(*) +  (0.2ms) CREATE TABLE "gem_defined_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer) +  (0.1ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer, "dob" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.1ms) CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255)) +  (0.1ms) CREATE TABLE "readerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer)  +  (0.1ms) CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer) +  (0.1ms) CREATE TABLE "user_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255), "user_id" integer)  + User Load (0.9ms) SELECT "users".* FROM "users" +  (0.0ms) begin transaction + SQL (2.8ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:40 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:40 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 1]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 2]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 3]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:40 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:40 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 4]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 5]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 6]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:40 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:40 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE (("users"."dob" >= '1992-09-07 00:00:00.000000' AND "users"."dob" <= '2013-10-07 00:00:00.000000')) LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 7]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 8]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 9]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:40 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", nil], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:40 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."age" = 34 LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 10]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 11]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 12]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:40 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:16:40 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:40 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:40 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.3ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 13]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 14]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 15]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:41 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:41 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:41 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:41 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:16:41 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:41 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:41 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:41 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:41 UTC +00:00]] +  (0.0ms) commit transaction +  (0.1ms) SELECT AVG("users"."age") AS avg_id FROM "users" +  (0.0ms) SELECT AVG("users"."age") AS avg_id FROM "users"  + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 16]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 17]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 18]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:16:42 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:16:42 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:16:42 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 30], ["created_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00], ["dob", nil], ["name", "Jitu"], ["updated_at", Sat, 07 Sep 2013 11:16:42 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "readerships" ("book_id", "user_id") VALUES (?, ?) [["book_id", nil], ["user_id", 22]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 22 LIMIT 1 +Connecting to database specified by database.yml +  (1.6ms) select sqlite_version(*) +  (0.2ms) CREATE TABLE "gem_defined_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer) +  (0.1ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer, "dob" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +  (0.1ms) CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255)) +  (0.1ms) CREATE TABLE "readerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer)  +  (0.1ms) CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer) +  (0.1ms) CREATE TABLE "user_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255), "user_id" integer)  + User Load (0.9ms) SELECT "users".* FROM "users" +  (0.0ms) begin transaction + SQL (2.8ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:34 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:34 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:34 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:34 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:34 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:34 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:34 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:17:34 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:34 UTC +00:00]] +  (0.0ms) commit transaction +  (0.1ms) SELECT AVG("users"."age") AS avg_id FROM "users" +  (0.1ms) SELECT AVG("users"."age") AS avg_id FROM "users"  + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.1ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 1]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 2]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 3]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:35 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:35 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:17:35 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 4]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 5]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 6]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:35 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:35 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Fri, 07 Sep 1979 11:17:35 UTC +00:00], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 30], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", nil], ["name", "Jitu"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "readerships" ("book_id", "user_id") VALUES (?, ?) [["book_id", nil], ["user_id", 10]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10 LIMIT 1 + User Load (0.1ms) SELECT "users".* FROM "users" +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 7]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 8]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 9]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 10]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:35 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:35 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."age" = 34 LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 11]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 12]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 13]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:35 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:35 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" WHERE (("users"."dob" >= '1992-09-07 00:00:00.000000' AND "users"."dob" <= '2013-10-07 00:00:00.000000')) LIMIT 25 OFFSET 0 + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 14]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 15]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 16]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:35 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:35 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.2ms) SELECT "users".* FROM "users" + User Load (0.1ms) SELECT "users".* FROM "users"  +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 17]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 18]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.0ms) DELETE FROM "users" WHERE "users"."id" = ? [["id", 19]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.2ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Sun, 07 Sep 2003 11:17:35 UTC +00:00], ["name", "User#1"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 20], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", Tue, 07 Sep 1993 11:17:35 UTC +00:00], ["name", "User#2"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction +  (0.0ms) begin transaction + SQL (0.1ms) INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Sat, 07 Sep 2013 11:17:35 UTC +00:00]] +  (0.0ms) commit transaction + User Load (0.1ms) SELECT "users".* FROM "users" LIMIT 25 OFFSET 0