SysmjGDd

1$ ruby dmtest.rb 
2Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.064269) DROP TABLE IF EXISTS "comments"
3Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.039812) DROP TABLE IF EXISTS "categories"
4Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.039265) DROP TABLE IF EXISTS "posts"
5Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.001818) DROP TABLE IF EXISTS "categorizations"
6Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000019) PRAGMA table_info('categorizations')
7Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000023) SELECT sqlite_version(*)
8Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.049739) CREATE TABLE "categorizations" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "created_at" DATETIME, "category_id" INTEGER, "post_id" INTEGER)
9Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000014) PRAGMA table_info('posts')
10Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.018931) CREATE TABLE "posts" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50), "title" VARCHAR(50), "body" TEXT, "created_at" DATETIME)
11Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000013) PRAGMA table_info('categories')
12Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.007401) CREATE TABLE "categories" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(50))
13Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000012) PRAGMA table_info('comments')
14Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.007529) CREATE TABLE "comments" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "posted_by" VARCHAR(50), "email" VARCHAR(50), "url" VARCHAR(50), "body" TEXT, "post_id" INTEGER)
15Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.003453) INSERT INTO "posts" ("name") VALUES ('post1')
16Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000056) SELECT "id", "posted_by", "email", "url", "post_id" FROM "comments" WHERE ("post_id" IN (1)) ORDER BY "id"
17Wed, 11 Mar 2009 13:06:34 GMT ~ debug ~ (0.000046) SELECT "id", "posted_by", "email", "url", "post_id" FROM "comments" WHERE ("post_id" IN (1)) AND ("email" IS NULL) ORDER BY "id"