jVW3UKnv

1 ~ (0.000069) SELECT sqlite_version(*)
2 ~ (0.170509) DROP TABLE IF EXISTS "people"
3 ~ (0.000036) PRAGMA table_info("people")
4 ~ (0.157415) CREATE TABLE "people" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT)
5 ~ (0.157829) DROP TABLE IF EXISTS "loans"
6 ~ (0.000031) PRAGMA table_info("loans")
7 ~ (0.174376) CREATE TABLE "loans" ("id" VARCHAR(36) NOT NULL, PRIMARY KEY("id"))
8 ~ (0.182974) DROP TABLE IF EXISTS "tickets"
9 ~ (0.000032) PRAGMA table_info("tickets")
10 ~ (0.174169) CREATE TABLE "tickets" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "loan_id" VARCHAR(36), "loaner_id" INTEGER NOT NULL, "loanee_id" INTEGER NOT NULL)
11 ~ (0.166520) CREATE INDEX "index_tickets_loaner" ON "tickets" ("loaner_id")
12 ~ (0.166484) CREATE INDEX "index_tickets_loanee" ON "tickets" ("loanee_id")
13 ~ (0.208128) CREATE UNIQUE INDEX "unique_tickets_loaner" ON "tickets" ("loan_id")
14 ~ (0.315982) INSERT INTO "people" DEFAULT VALUES
15 ~ (0.249397) INSERT INTO "people" DEFAULT VALUES
16 ~ (0.140535) INSERT INTO "loans" ("id") VALUES ('724deb54-72de-4cb9-a8eb-ff23d93a39d4')
17 ~ (0.000077) SELECT "id" FROM "tickets" WHERE ("loan_id" = '724deb54-72de-4cb9-a8eb-ff23d93a39d4' AND "loaner_id" = 1) ORDER BY "id" LIMIT 1
18 ~ (0.146969) INSERT INTO "tickets" ("loan_id", "loaner_id", "loanee_id") VALUES ('724deb54-72de-4cb9-a8eb-ff23d93a39d4', 1, 2)
19 ~ (0.000077) SELECT "id" FROM "tickets" WHERE ("loan_id" = '724deb54-72de-4cb9-a8eb-ff23d93a39d4' AND "loaner_id" = 1) ORDER BY "id" LIMIT 1
20false
21#<DataMapper::Validations::ValidationErrors:0x95d86e0 @resource=#<Ticket @id=nil @loan_id=#<UUID:0x4afb456 UUID:724deb54-72de-4cb9-a8eb-ff23d93a39d4> @loaner_id=1 @loanee_id=2>, @errors={:loan_id=>["Loan is already taken"]}>