Skip to content

Instantly share code, notes, and snippets.

@gintsgints
Created August 15, 2015 17:33
Show Gist options
  • Save gintsgints/dafe9dc89a861b872dd0 to your computer and use it in GitHub Desktop.
Save gintsgints/dafe9dc89a861b872dd0 to your computer and use it in GitHub Desktop.
foreign key with fields specified
Auto commit:true Exec: ===== SELECT "User"."id", "User"."name", "User"."createdAt", "User"."updatedAt", "Projects"."id" AS "Projects.id", "Projects"."name" AS "Projects.name", "Projects"."createdAt" AS "Projects.createdAt", "Projects"."updatedAt" AS "Projects.updatedAt", "Projects.user_projects"."createdAt" AS "Projects.user_projects.createdAt", "Projects.user_projects"."updatedAt" AS "Projects.user_projects.updatedAt", "Projects.user_projects"."project_id" AS "Projects.user_projects.projectId", "Projects.user_projects"."user_id" AS "Projects.user_projects.userId" FROM "Users" "User" LEFT OUTER JOIN ("user_projects" "Projects.user_projects" INNER JOIN "Projects" "Projects" ON "Projects"."id" = "Projects.user_projects"."project_id") ON "User"."id" = "Projects.user_projects"."user_id" WHERE "User"."id" IN (1)===== end of code
Got error: Error: ORA-00972: identifier is too long
3) should correctly get associations even after a child instance is deleted
√ should correctly get associations when doubly linked (780ms)
Auto commit:true Exec: ===== SELECT "Group"."id", "Group"."groupName", "Group"."createdAt", "Group"."updatedAt", "Users"."id" AS "Users.id", "Users"."name" AS "Users.name", "Users"."createdAt" AS "Users.createdAt", "Users"."updatedAt" AS "Users.updatedAt", "Users.group_users"."createdAt" AS "Users.group_users.createdAt", "Users.group_users"."updatedAt" AS "Users.group_users.updatedAt", "Users.group_users"."user_id" AS "Users.group_users.userId", "Users.group_users"."group_id" AS "Users.group_users.groupId", "Users.Projects"."id" AS "Users.Projects.id", "Users.Projects"."name" AS "Users.Projects.name", "Users.Projects"."createdAt" AS "Users.Projects.createdAt", "Users.Projects"."updatedAt" AS "Users.Projects.updatedAt", "Users.Projects.user_projects"."createdAt" AS "Users.Projects.user_projects.createdAt", "Users.Projects.user_projects"."updatedAt" AS "Users.Projects.user_projects.updatedAt", "Users.Projects.user_projects"."project_id" AS "Users.Projects.user_projects.projectId", "Users.Projects.user_projects"."user_id" AS "Users.Projects.user_projects.userId" FROM "Groups" "Group" LEFT OUTER JOIN ("group_users" "Users.group_users" INNER JOIN "Users" "Users" ON "Users"."id" = "Users.group_users"."user_id") ON "Group"."id" = "Users.group_users"."group_id" LEFT OUTER JOIN ("user_projects" "Users.Projects.user_projects" INNER JOIN "Projects" "Users.Projects" ON "Users.Projects"."id" = "Users.Projects.user_projects"."project_id") ON "Users"."id" = "Users.Projects.user_projects"."user_id" WHERE "Group"."id" IN (1)===== end of code
Got error: Error: ORA-00972: identifier is too long
4) should be able to handle nested includes properly
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment