npm WARN deprecated superagent@8.1.2: Please upgrade to v9.0.0+ as we have fixed a public vulnerability with formidable dependency. Note that v9.0.0+ requires Node.js v14.18.0+. See https://github.com/ladjs/superagent/pull/1800 for insight. This project is supported and maintained by the team at Forward Email @ https://forwardemail.net

added 629 packages, and audited 1821 packages in 9s

117 packages are looking for funding
  run `npm fund` for details

10 vulnerabilities (1 low, 2 moderate, 5 high, 2 critical)

To address issues that do not require attention, run:
  npm audit fix

To address all issues (including breaking changes), run:
  npm audit fix --force

Run `npm audit` for details.

> test
> AUTH_SERVICE_URL=http://localhost:4000 DEVICE_SERVICE_URL=http://localhost:4000 EXPERIMENT_SERVICE_URL=http://localhost:4000 mocha

(node:3759) ExperimentalWarning: `--experimental-loader` may be removed in the future; instead use `register()`:
--import 'data:text/javascript,import { register } from "node:module"; import { pathToFileURL } from "node:url"; register("ts-node/esm", pathToFileURL("./"));'
(Use `node --trace-warnings ...` to show where the warning was created)


  LTI Login
query: PRAGMA foreign_keys = OFF
query: BEGIN TRANSACTION
query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" IN ('platform_model','lti_message_model','lti_resource_model','lti_session_model','lti_resource_student','lti_resource_student_role_map_model')
query: SELECT * FROM "sqlite_master" WHERE "type" = 'index' AND "tbl_name" IN ('platform_model','lti_message_model','lti_resource_model','lti_session_model','lti_resource_student','lti_resource_student_role_map_model')
query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'typeorm_metadata'
query: CREATE TABLE "platform_model" ("id" varchar PRIMARY KEY NOT NULL, "iss" varchar, "client_id" varchar, "deployment_id" varchar, "authentication_request_url" varchar, "access_token_url" varchar, "jwks_url" varchar, "registrated" boolean NOT NULL, "associated_user" varchar, "createdDate" datetime NOT NULL DEFAULT (datetime('now')))
query: CREATE TABLE "lti_message_model" ("id" varchar PRIMARY KEY NOT NULL, "nonce" varchar NOT NULL, "platformId" varchar)
query: CREATE TABLE "lti_resource_model" ("id" varchar PRIMARY KEY NOT NULL, "resource_link_id" varchar NOT NULL, "experiment_template_uri" varchar, "namesServiceUrl" varchar, "platformId" varchar, CONSTRAINT "UQ_b32c74da4904eb5a89e54cd10f0" UNIQUE ("resource_link_id", "platformId"))
query: CREATE TABLE "lti_session_model" ("id" varchar PRIMARY KEY NOT NULL, "launchMessage" text NOT NULL, "experiment_uri" varchar, "createdDate" datetime NOT NULL DEFAULT (datetime('now')), "resourceId" varchar)
query: CREATE TABLE "lti_resource_student" ("id" varchar PRIMARY KEY NOT NULL, "external_id" varchar NOT NULL, "name" varchar, "email" varchar, "resourceId" varchar, CONSTRAINT "UQ_0c5be18cabc4568deceed983a28" UNIQUE ("resourceId", "external_id"))
query: CREATE TABLE "lti_resource_student_role_map_model" ("id" varchar PRIMARY KEY NOT NULL, "role" varchar NOT NULL, "device" varchar NOT NULL, "studentId" varchar, CONSTRAINT "UQ_85227c7e05549f72ce80b9838cd" UNIQUE ("studentId", "role"))
query: CREATE TABLE "temporary_lti_message_model" ("id" varchar PRIMARY KEY NOT NULL, "nonce" varchar NOT NULL, "platformId" varchar, CONSTRAINT "FK_83b08a7ab0a613dd9291669b1b8" FOREIGN KEY ("platformId") REFERENCES "platform_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_message_model"("id", "nonce", "platformId") SELECT "id", "nonce", "platformId" FROM "lti_message_model"
query: DROP TABLE "lti_message_model"
query: ALTER TABLE "temporary_lti_message_model" RENAME TO "lti_message_model"
query: CREATE TABLE "temporary_lti_resource_model" ("id" varchar PRIMARY KEY NOT NULL, "resource_link_id" varchar NOT NULL, "experiment_template_uri" varchar, "namesServiceUrl" varchar, "platformId" varchar, CONSTRAINT "UQ_b32c74da4904eb5a89e54cd10f0" UNIQUE ("resource_link_id", "platformId"), CONSTRAINT "FK_28e63bcc54c528e6fbb8ce85e57" FOREIGN KEY ("platformId") REFERENCES "platform_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_resource_model"("id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId") SELECT "id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId" FROM "lti_resource_model"
query: DROP TABLE "lti_resource_model"
query: ALTER TABLE "temporary_lti_resource_model" RENAME TO "lti_resource_model"
query: CREATE TABLE "temporary_lti_session_model" ("id" varchar PRIMARY KEY NOT NULL, "launchMessage" text NOT NULL, "experiment_uri" varchar, "createdDate" datetime NOT NULL DEFAULT (datetime('now')), "resourceId" varchar, CONSTRAINT "FK_1f00f22e8b8c4ac22385800114e" FOREIGN KEY ("resourceId") REFERENCES "lti_resource_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_session_model"("id", "launchMessage", "experiment_uri", "createdDate", "resourceId") SELECT "id", "launchMessage", "experiment_uri", "createdDate", "resourceId" FROM "lti_session_model"
query: DROP TABLE "lti_session_model"
query: ALTER TABLE "temporary_lti_session_model" RENAME TO "lti_session_model"
query: CREATE TABLE "temporary_lti_resource_student" ("id" varchar PRIMARY KEY NOT NULL, "external_id" varchar NOT NULL, "name" varchar, "email" varchar, "resourceId" varchar, CONSTRAINT "UQ_0c5be18cabc4568deceed983a28" UNIQUE ("resourceId", "external_id"), CONSTRAINT "FK_0e4e3416e03e35da792b1c37e97" FOREIGN KEY ("resourceId") REFERENCES "lti_resource_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_resource_student"("id", "external_id", "name", "email", "resourceId") SELECT "id", "external_id", "name", "email", "resourceId" FROM "lti_resource_student"
query: DROP TABLE "lti_resource_student"
query: ALTER TABLE "temporary_lti_resource_student" RENAME TO "lti_resource_student"
query: CREATE TABLE "temporary_lti_resource_student_role_map_model" ("id" varchar PRIMARY KEY NOT NULL, "role" varchar NOT NULL, "device" varchar NOT NULL, "studentId" varchar, CONSTRAINT "UQ_85227c7e05549f72ce80b9838cd" UNIQUE ("studentId", "role"), CONSTRAINT "FK_bb7977461bc0c66845b24084dae" FOREIGN KEY ("studentId") REFERENCES "lti_resource_student" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_resource_student_role_map_model"("id", "role", "device", "studentId") SELECT "id", "role", "device", "studentId" FROM "lti_resource_student_role_map_model"
query: DROP TABLE "lti_resource_student_role_map_model"
query: ALTER TABLE "temporary_lti_resource_student_role_map_model" RENAME TO "lti_resource_student_role_map_model"
query: COMMIT
query: PRAGMA foreign_keys = ON
query: INSERT INTO "platform_model"("id", "iss", "client_id", "deployment_id", "authentication_request_url", "access_token_url", "jwks_url", "registrated", "associated_user", "createdDate") VALUES (?, NULL, NULL, NULL, NULL, NULL, NULL, 0, ?, datetime('now')) -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","user1"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" = ? -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."id" = ?)) LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" IN (?) -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: BEGIN TRANSACTION
query: UPDATE "platform_model" SET "iss" = ?, "client_id" = ?, "deployment_id" = ?, "authentication_request_url" = ?, "access_token_url" = ?, "jwks_url" = ?, "registrated" = 1 WHERE "id" IN (?) -- PARAMETERS: ["http://localhost:43213","TEST","TEST","http://localhost:43213/auth_request","http://localhost:43213/access_token","http://localhost:43213/jwks","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: COMMIT
query: BEGIN TRANSACTION
query: INSERT INTO "lti_message_model"("id", "nonce", "platformId") VALUES (?, ?, ?) -- PARAMETERS: ["a9cbd28a-00c1-4cd4-879f-0cf067d8ed56","tHL737LiZEE5qQt61o-xr_hF0pOfX5QelDAuEnpzUGA","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: COMMIT
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."id" = ?)) LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT DISTINCT "distinctAlias"."LtiMessageModel_id" AS "ids_LtiMessageModel_id" FROM (SELECT "LtiMessageModel"."id" AS "LtiMessageModel_id", "LtiMessageModel"."nonce" AS "LtiMessageModel_nonce", "LtiMessageModel"."platformId" AS "LtiMessageModel_platformId", "LtiMessageModel__LtiMessageModel_platform"."id" AS "LtiMessageModel__LtiMessageModel_platform_id", "LtiMessageModel__LtiMessageModel_platform"."iss" AS "LtiMessageModel__LtiMessageModel_platform_iss", "LtiMessageModel__LtiMessageModel_platform"."client_id" AS "LtiMessageModel__LtiMessageModel_platform_client_id", "LtiMessageModel__LtiMessageModel_platform"."deployment_id" AS "LtiMessageModel__LtiMessageModel_platform_deployment_id", "LtiMessageModel__LtiMessageModel_platform"."authentication_request_url" AS "LtiMessageModel__LtiMessageModel_platform_authentication_request_url", "LtiMessageModel__LtiMessageModel_platform"."access_token_url" AS "LtiMessageModel__LtiMessageModel_platform_access_token_url", "LtiMessageModel__LtiMessageModel_platform"."jwks_url" AS "LtiMessageModel__LtiMessageModel_platform_jwks_url", "LtiMessageModel__LtiMessageModel_platform"."registrated" AS "LtiMessageModel__LtiMessageModel_platform_registrated", "LtiMessageModel__LtiMessageModel_platform"."associated_user" AS "LtiMessageModel__LtiMessageModel_platform_associated_user", "LtiMessageModel__LtiMessageModel_platform"."createdDate" AS "LtiMessageModel__LtiMessageModel_platform_createdDate" FROM "lti_message_model" "LtiMessageModel" LEFT JOIN "platform_model" "LtiMessageModel__LtiMessageModel_platform" ON "LtiMessageModel__LtiMessageModel_platform"."id"="LtiMessageModel"."platformId" WHERE (("LtiMessageModel"."id" = ?))) "distinctAlias" ORDER BY "LtiMessageModel_id" ASC LIMIT 1 -- PARAMETERS: ["a9cbd28a-00c1-4cd4-879f-0cf067d8ed56"]
query: SELECT "LtiMessageModel"."id" AS "LtiMessageModel_id", "LtiMessageModel"."nonce" AS "LtiMessageModel_nonce", "LtiMessageModel"."platformId" AS "LtiMessageModel_platformId", "LtiMessageModel__LtiMessageModel_platform"."id" AS "LtiMessageModel__LtiMessageModel_platform_id", "LtiMessageModel__LtiMessageModel_platform"."iss" AS "LtiMessageModel__LtiMessageModel_platform_iss", "LtiMessageModel__LtiMessageModel_platform"."client_id" AS "LtiMessageModel__LtiMessageModel_platform_client_id", "LtiMessageModel__LtiMessageModel_platform"."deployment_id" AS "LtiMessageModel__LtiMessageModel_platform_deployment_id", "LtiMessageModel__LtiMessageModel_platform"."authentication_request_url" AS "LtiMessageModel__LtiMessageModel_platform_authentication_request_url", "LtiMessageModel__LtiMessageModel_platform"."access_token_url" AS "LtiMessageModel__LtiMessageModel_platform_access_token_url", "LtiMessageModel__LtiMessageModel_platform"."jwks_url" AS "LtiMessageModel__LtiMessageModel_platform_jwks_url", "LtiMessageModel__LtiMessageModel_platform"."registrated" AS "LtiMessageModel__LtiMessageModel_platform_registrated", "LtiMessageModel__LtiMessageModel_platform"."associated_user" AS "LtiMessageModel__LtiMessageModel_platform_associated_user", "LtiMessageModel__LtiMessageModel_platform"."createdDate" AS "LtiMessageModel__LtiMessageModel_platform_createdDate" FROM "lti_message_model" "LtiMessageModel" LEFT JOIN "platform_model" "LtiMessageModel__LtiMessageModel_platform" ON "LtiMessageModel__LtiMessageModel_platform"."id"="LtiMessageModel"."platformId" WHERE ( (("LtiMessageModel"."id" = ?)) ) AND ( "LtiMessageModel"."id" IN (?) ) -- PARAMETERS: ["a9cbd28a-00c1-4cd4-879f-0cf067d8ed56","a9cbd28a-00c1-4cd4-879f-0cf067d8ed56"]
query: DELETE FROM "lti_message_model" WHERE "id" IN (?) -- PARAMETERS: ["a9cbd28a-00c1-4cd4-879f-0cf067d8ed56"]
query: INSERT INTO "lti_resource_model"("id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId") VALUES (?, ?, NULL, NULL, ?) ON CONFLICT DO NOTHING -- PARAMETERS: ["154eabd8-a97e-4c90-85e0-8f8cef5fec56","200d101f-2c14-434a-a0f3-57c2a42369fd","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT DISTINCT "distinctAlias"."LtiResourceModel_id" AS "ids_LtiResourceModel_id" FROM (SELECT "LtiResourceModel"."id" AS "LtiResourceModel_id", "LtiResourceModel"."resource_link_id" AS "LtiResourceModel_resource_link_id", "LtiResourceModel"."experiment_template_uri" AS "LtiResourceModel_experiment_template_uri", "LtiResourceModel"."namesServiceUrl" AS "LtiResourceModel_namesServiceUrl", "LtiResourceModel"."platformId" AS "LtiResourceModel_platformId", "LtiResourceModel__LtiResourceModel_platform"."id" AS "LtiResourceModel__LtiResourceModel_platform_id", "LtiResourceModel__LtiResourceModel_platform"."iss" AS "LtiResourceModel__LtiResourceModel_platform_iss", "LtiResourceModel__LtiResourceModel_platform"."client_id" AS "LtiResourceModel__LtiResourceModel_platform_client_id", "LtiResourceModel__LtiResourceModel_platform"."deployment_id" AS "LtiResourceModel__LtiResourceModel_platform_deployment_id", "LtiResourceModel__LtiResourceModel_platform"."authentication_request_url" AS "LtiResourceModel__LtiResourceModel_platform_authentication_request_url", "LtiResourceModel__LtiResourceModel_platform"."access_token_url" AS "LtiResourceModel__LtiResourceModel_platform_access_token_url", "LtiResourceModel__LtiResourceModel_platform"."jwks_url" AS "LtiResourceModel__LtiResourceModel_platform_jwks_url", "LtiResourceModel__LtiResourceModel_platform"."registrated" AS "LtiResourceModel__LtiResourceModel_platform_registrated", "LtiResourceModel__LtiResourceModel_platform"."associated_user" AS "LtiResourceModel__LtiResourceModel_platform_associated_user", "LtiResourceModel__LtiResourceModel_platform"."createdDate" AS "LtiResourceModel__LtiResourceModel_platform_createdDate" FROM "lti_resource_model" "LtiResourceModel" LEFT JOIN "platform_model" "LtiResourceModel__LtiResourceModel_platform" ON "LtiResourceModel__LtiResourceModel_platform"."id"="LtiResourceModel"."platformId" WHERE (((("LtiResourceModel__LtiResourceModel_platform"."id" = ?))) AND ("LtiResourceModel"."resource_link_id" = ?))) "distinctAlias" ORDER BY "LtiResourceModel_id" ASC LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","200d101f-2c14-434a-a0f3-57c2a42369fd"]
query: SELECT "LtiResourceModel"."id" AS "LtiResourceModel_id", "LtiResourceModel"."resource_link_id" AS "LtiResourceModel_resource_link_id", "LtiResourceModel"."experiment_template_uri" AS "LtiResourceModel_experiment_template_uri", "LtiResourceModel"."namesServiceUrl" AS "LtiResourceModel_namesServiceUrl", "LtiResourceModel"."platformId" AS "LtiResourceModel_platformId", "LtiResourceModel__LtiResourceModel_platform"."id" AS "LtiResourceModel__LtiResourceModel_platform_id", "LtiResourceModel__LtiResourceModel_platform"."iss" AS "LtiResourceModel__LtiResourceModel_platform_iss", "LtiResourceModel__LtiResourceModel_platform"."client_id" AS "LtiResourceModel__LtiResourceModel_platform_client_id", "LtiResourceModel__LtiResourceModel_platform"."deployment_id" AS "LtiResourceModel__LtiResourceModel_platform_deployment_id", "LtiResourceModel__LtiResourceModel_platform"."authentication_request_url" AS "LtiResourceModel__LtiResourceModel_platform_authentication_request_url", "LtiResourceModel__LtiResourceModel_platform"."access_token_url" AS "LtiResourceModel__LtiResourceModel_platform_access_token_url", "LtiResourceModel__LtiResourceModel_platform"."jwks_url" AS "LtiResourceModel__LtiResourceModel_platform_jwks_url", "LtiResourceModel__LtiResourceModel_platform"."registrated" AS "LtiResourceModel__LtiResourceModel_platform_registrated", "LtiResourceModel__LtiResourceModel_platform"."associated_user" AS "LtiResourceModel__LtiResourceModel_platform_associated_user", "LtiResourceModel__LtiResourceModel_platform"."createdDate" AS "LtiResourceModel__LtiResourceModel_platform_createdDate" FROM "lti_resource_model" "LtiResourceModel" LEFT JOIN "platform_model" "LtiResourceModel__LtiResourceModel_platform" ON "LtiResourceModel__LtiResourceModel_platform"."id"="LtiResourceModel"."platformId" WHERE ( (((("LtiResourceModel__LtiResourceModel_platform"."id" = ?))) AND ("LtiResourceModel"."resource_link_id" = ?)) ) AND ( "LtiResourceModel"."id" IN (?) ) -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","200d101f-2c14-434a-a0f3-57c2a42369fd","154eabd8-a97e-4c90-85e0-8f8cef5fec56"]
query: INSERT INTO "lti_session_model"("id", "launchMessage", "experiment_uri", "createdDate", "resourceId") VALUES (?, ?, NULL, datetime('now'), ?) -- PARAMETERS: ["ley1B38W8UDza8PQoflqrZYO0o9M9s3qrENOT5QwHAQ","{\"https://purl.imsglobal.org/spec/lti/claim/message_type\":\"LtiResourceLinkRequest\",\"https://purl.imsglobal.org/spec/lti/claim/roles\":[\"\\\"http://purl.imsglobal.org/vocab/lis/v2/institution/person#Student\"],\"https://purl.imsglobal.org/spec/lti/claim/resource_link\":{\"id\":\"200d101f-2c14-434a-a0f3-57c2a42369fd\",\"description\":\"Assignment to introduce who you are\",\"title\":\"Introduction Assignment\"},\"iss\":\"http://localhost:43213\",\"nonce\":\"tHL737LiZEE5qQt61o-xr_hF0pOfX5QelDAuEnpzUGA\",\"iat\":1725962432,\"exp\":1725962732}","154eabd8-a97e-4c90-85e0-8f8cef5fec56"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate" FROM "lti_session_model" "LtiSessionModel" WHERE "LtiSessionModel"."id" = ? -- PARAMETERS: ["ley1B38W8UDza8PQoflqrZYO0o9M9s3qrENOT5QwHAQ"]
query: SELECT DISTINCT "distinctAlias"."LtiSessionModel_id" AS "ids_LtiSessionModel_id" FROM (SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId", "LtiSessionModel__resource"."id" AS "LtiSessionModel__resource_id", "LtiSessionModel__resource"."resource_link_id" AS "LtiSessionModel__resource_resource_link_id", "LtiSessionModel__resource"."experiment_template_uri" AS "LtiSessionModel__resource_experiment_template_uri", "LtiSessionModel__resource"."namesServiceUrl" AS "LtiSessionModel__resource_namesServiceUrl", "LtiSessionModel__resource"."platformId" AS "LtiSessionModel__resource_platformId", "LtiSessionModel__resource__platform"."id" AS "LtiSessionModel__resource__platform_id", "LtiSessionModel__resource__platform"."iss" AS "LtiSessionModel__resource__platform_iss", "LtiSessionModel__resource__platform"."client_id" AS "LtiSessionModel__resource__platform_client_id", "LtiSessionModel__resource__platform"."deployment_id" AS "LtiSessionModel__resource__platform_deployment_id", "LtiSessionModel__resource__platform"."authentication_request_url" AS "LtiSessionModel__resource__platform_authentication_request_url", "LtiSessionModel__resource__platform"."access_token_url" AS "LtiSessionModel__resource__platform_access_token_url", "LtiSessionModel__resource__platform"."jwks_url" AS "LtiSessionModel__resource__platform_jwks_url", "LtiSessionModel__resource__platform"."registrated" AS "LtiSessionModel__resource__platform_registrated", "LtiSessionModel__resource__platform"."associated_user" AS "LtiSessionModel__resource__platform_associated_user", "LtiSessionModel__resource__platform"."createdDate" AS "LtiSessionModel__resource__platform_createdDate" FROM "lti_session_model" "LtiSessionModel" LEFT JOIN "lti_resource_model" "LtiSessionModel__resource" ON "LtiSessionModel__resource"."id"="LtiSessionModel"."resourceId"  LEFT JOIN "platform_model" "LtiSessionModel__resource__platform" ON "LtiSessionModel__resource__platform"."id"="LtiSessionModel__resource"."platformId" WHERE (("LtiSessionModel"."id" = ?))) "distinctAlias" ORDER BY "LtiSessionModel_id" ASC LIMIT 1 -- PARAMETERS: ["ley1B38W8UDza8PQoflqrZYO0o9M9s3qrENOT5QwHAQ"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId", "LtiSessionModel__resource"."id" AS "LtiSessionModel__resource_id", "LtiSessionModel__resource"."resource_link_id" AS "LtiSessionModel__resource_resource_link_id", "LtiSessionModel__resource"."experiment_template_uri" AS "LtiSessionModel__resource_experiment_template_uri", "LtiSessionModel__resource"."namesServiceUrl" AS "LtiSessionModel__resource_namesServiceUrl", "LtiSessionModel__resource"."platformId" AS "LtiSessionModel__resource_platformId", "LtiSessionModel__resource__platform"."id" AS "LtiSessionModel__resource__platform_id", "LtiSessionModel__resource__platform"."iss" AS "LtiSessionModel__resource__platform_iss", "LtiSessionModel__resource__platform"."client_id" AS "LtiSessionModel__resource__platform_client_id", "LtiSessionModel__resource__platform"."deployment_id" AS "LtiSessionModel__resource__platform_deployment_id", "LtiSessionModel__resource__platform"."authentication_request_url" AS "LtiSessionModel__resource__platform_authentication_request_url", "LtiSessionModel__resource__platform"."access_token_url" AS "LtiSessionModel__resource__platform_access_token_url", "LtiSessionModel__resource__platform"."jwks_url" AS "LtiSessionModel__resource__platform_jwks_url", "LtiSessionModel__resource__platform"."registrated" AS "LtiSessionModel__resource__platform_registrated", "LtiSessionModel__resource__platform"."associated_user" AS "LtiSessionModel__resource__platform_associated_user", "LtiSessionModel__resource__platform"."createdDate" AS "LtiSessionModel__resource__platform_createdDate" FROM "lti_session_model" "LtiSessionModel" LEFT JOIN "lti_resource_model" "LtiSessionModel__resource" ON "LtiSessionModel__resource"."id"="LtiSessionModel"."resourceId"  LEFT JOIN "platform_model" "LtiSessionModel__resource__platform" ON "LtiSessionModel__resource__platform"."id"="LtiSessionModel__resource"."platformId" WHERE ( (("LtiSessionModel"."id" = ?)) ) AND ( "LtiSessionModel"."id" IN (?) ) -- PARAMETERS: ["ley1B38W8UDza8PQoflqrZYO0o9M9s3qrENOT5QwHAQ","ley1B38W8UDza8PQoflqrZYO0o9M9s3qrENOT5QwHAQ"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId" FROM "lti_session_model" "LtiSessionModel" WHERE "LtiSessionModel"."id" IN (?) -- PARAMETERS: ["ley1B38W8UDza8PQoflqrZYO0o9M9s3qrENOT5QwHAQ"]
    ✔ should be able to launch (570ms)
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."id" = ?)) LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: BEGIN TRANSACTION
query: INSERT INTO "lti_message_model"("id", "nonce", "platformId") VALUES (?, ?, ?) -- PARAMETERS: ["b3d95abd-dfa6-4c2b-b085-49d588e7c2dc","qfabIVD70K0wAWAQ46ExFD127qoYj45XsGUM78kDVIk","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: COMMIT
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."id" = ?)) LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT DISTINCT "distinctAlias"."LtiMessageModel_id" AS "ids_LtiMessageModel_id" FROM (SELECT "LtiMessageModel"."id" AS "LtiMessageModel_id", "LtiMessageModel"."nonce" AS "LtiMessageModel_nonce", "LtiMessageModel"."platformId" AS "LtiMessageModel_platformId", "LtiMessageModel__LtiMessageModel_platform"."id" AS "LtiMessageModel__LtiMessageModel_platform_id", "LtiMessageModel__LtiMessageModel_platform"."iss" AS "LtiMessageModel__LtiMessageModel_platform_iss", "LtiMessageModel__LtiMessageModel_platform"."client_id" AS "LtiMessageModel__LtiMessageModel_platform_client_id", "LtiMessageModel__LtiMessageModel_platform"."deployment_id" AS "LtiMessageModel__LtiMessageModel_platform_deployment_id", "LtiMessageModel__LtiMessageModel_platform"."authentication_request_url" AS "LtiMessageModel__LtiMessageModel_platform_authentication_request_url", "LtiMessageModel__LtiMessageModel_platform"."access_token_url" AS "LtiMessageModel__LtiMessageModel_platform_access_token_url", "LtiMessageModel__LtiMessageModel_platform"."jwks_url" AS "LtiMessageModel__LtiMessageModel_platform_jwks_url", "LtiMessageModel__LtiMessageModel_platform"."registrated" AS "LtiMessageModel__LtiMessageModel_platform_registrated", "LtiMessageModel__LtiMessageModel_platform"."associated_user" AS "LtiMessageModel__LtiMessageModel_platform_associated_user", "LtiMessageModel__LtiMessageModel_platform"."createdDate" AS "LtiMessageModel__LtiMessageModel_platform_createdDate" FROM "lti_message_model" "LtiMessageModel" LEFT JOIN "platform_model" "LtiMessageModel__LtiMessageModel_platform" ON "LtiMessageModel__LtiMessageModel_platform"."id"="LtiMessageModel"."platformId" WHERE (("LtiMessageModel"."id" = ?))) "distinctAlias" ORDER BY "LtiMessageModel_id" ASC LIMIT 1 -- PARAMETERS: ["b3d95abd-dfa6-4c2b-b085-49d588e7c2dc"]
query: SELECT "LtiMessageModel"."id" AS "LtiMessageModel_id", "LtiMessageModel"."nonce" AS "LtiMessageModel_nonce", "LtiMessageModel"."platformId" AS "LtiMessageModel_platformId", "LtiMessageModel__LtiMessageModel_platform"."id" AS "LtiMessageModel__LtiMessageModel_platform_id", "LtiMessageModel__LtiMessageModel_platform"."iss" AS "LtiMessageModel__LtiMessageModel_platform_iss", "LtiMessageModel__LtiMessageModel_platform"."client_id" AS "LtiMessageModel__LtiMessageModel_platform_client_id", "LtiMessageModel__LtiMessageModel_platform"."deployment_id" AS "LtiMessageModel__LtiMessageModel_platform_deployment_id", "LtiMessageModel__LtiMessageModel_platform"."authentication_request_url" AS "LtiMessageModel__LtiMessageModel_platform_authentication_request_url", "LtiMessageModel__LtiMessageModel_platform"."access_token_url" AS "LtiMessageModel__LtiMessageModel_platform_access_token_url", "LtiMessageModel__LtiMessageModel_platform"."jwks_url" AS "LtiMessageModel__LtiMessageModel_platform_jwks_url", "LtiMessageModel__LtiMessageModel_platform"."registrated" AS "LtiMessageModel__LtiMessageModel_platform_registrated", "LtiMessageModel__LtiMessageModel_platform"."associated_user" AS "LtiMessageModel__LtiMessageModel_platform_associated_user", "LtiMessageModel__LtiMessageModel_platform"."createdDate" AS "LtiMessageModel__LtiMessageModel_platform_createdDate" FROM "lti_message_model" "LtiMessageModel" LEFT JOIN "platform_model" "LtiMessageModel__LtiMessageModel_platform" ON "LtiMessageModel__LtiMessageModel_platform"."id"="LtiMessageModel"."platformId" WHERE ( (("LtiMessageModel"."id" = ?)) ) AND ( "LtiMessageModel"."id" IN (?) ) -- PARAMETERS: ["b3d95abd-dfa6-4c2b-b085-49d588e7c2dc","b3d95abd-dfa6-4c2b-b085-49d588e7c2dc"]
query: DELETE FROM "lti_message_model" WHERE "id" IN (?) -- PARAMETERS: ["b3d95abd-dfa6-4c2b-b085-49d588e7c2dc"]
query: INSERT INTO "lti_resource_model"("id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId") VALUES (?, ?, NULL, NULL, ?) ON CONFLICT DO NOTHING -- PARAMETERS: ["93cc00e6-905c-4818-be65-1e5ffee9817d","200d101f-2c14-434a-a0f3-57c2a42369fd","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT DISTINCT "distinctAlias"."LtiResourceModel_id" AS "ids_LtiResourceModel_id" FROM (SELECT "LtiResourceModel"."id" AS "LtiResourceModel_id", "LtiResourceModel"."resource_link_id" AS "LtiResourceModel_resource_link_id", "LtiResourceModel"."experiment_template_uri" AS "LtiResourceModel_experiment_template_uri", "LtiResourceModel"."namesServiceUrl" AS "LtiResourceModel_namesServiceUrl", "LtiResourceModel"."platformId" AS "LtiResourceModel_platformId", "LtiResourceModel__LtiResourceModel_platform"."id" AS "LtiResourceModel__LtiResourceModel_platform_id", "LtiResourceModel__LtiResourceModel_platform"."iss" AS "LtiResourceModel__LtiResourceModel_platform_iss", "LtiResourceModel__LtiResourceModel_platform"."client_id" AS "LtiResourceModel__LtiResourceModel_platform_client_id", "LtiResourceModel__LtiResourceModel_platform"."deployment_id" AS "LtiResourceModel__LtiResourceModel_platform_deployment_id", "LtiResourceModel__LtiResourceModel_platform"."authentication_request_url" AS "LtiResourceModel__LtiResourceModel_platform_authentication_request_url", "LtiResourceModel__LtiResourceModel_platform"."access_token_url" AS "LtiResourceModel__LtiResourceModel_platform_access_token_url", "LtiResourceModel__LtiResourceModel_platform"."jwks_url" AS "LtiResourceModel__LtiResourceModel_platform_jwks_url", "LtiResourceModel__LtiResourceModel_platform"."registrated" AS "LtiResourceModel__LtiResourceModel_platform_registrated", "LtiResourceModel__LtiResourceModel_platform"."associated_user" AS "LtiResourceModel__LtiResourceModel_platform_associated_user", "LtiResourceModel__LtiResourceModel_platform"."createdDate" AS "LtiResourceModel__LtiResourceModel_platform_createdDate" FROM "lti_resource_model" "LtiResourceModel" LEFT JOIN "platform_model" "LtiResourceModel__LtiResourceModel_platform" ON "LtiResourceModel__LtiResourceModel_platform"."id"="LtiResourceModel"."platformId" WHERE (((("LtiResourceModel__LtiResourceModel_platform"."id" = ?))) AND ("LtiResourceModel"."resource_link_id" = ?))) "distinctAlias" ORDER BY "LtiResourceModel_id" ASC LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","200d101f-2c14-434a-a0f3-57c2a42369fd"]
query: SELECT "LtiResourceModel"."id" AS "LtiResourceModel_id", "LtiResourceModel"."resource_link_id" AS "LtiResourceModel_resource_link_id", "LtiResourceModel"."experiment_template_uri" AS "LtiResourceModel_experiment_template_uri", "LtiResourceModel"."namesServiceUrl" AS "LtiResourceModel_namesServiceUrl", "LtiResourceModel"."platformId" AS "LtiResourceModel_platformId", "LtiResourceModel__LtiResourceModel_platform"."id" AS "LtiResourceModel__LtiResourceModel_platform_id", "LtiResourceModel__LtiResourceModel_platform"."iss" AS "LtiResourceModel__LtiResourceModel_platform_iss", "LtiResourceModel__LtiResourceModel_platform"."client_id" AS "LtiResourceModel__LtiResourceModel_platform_client_id", "LtiResourceModel__LtiResourceModel_platform"."deployment_id" AS "LtiResourceModel__LtiResourceModel_platform_deployment_id", "LtiResourceModel__LtiResourceModel_platform"."authentication_request_url" AS "LtiResourceModel__LtiResourceModel_platform_authentication_request_url", "LtiResourceModel__LtiResourceModel_platform"."access_token_url" AS "LtiResourceModel__LtiResourceModel_platform_access_token_url", "LtiResourceModel__LtiResourceModel_platform"."jwks_url" AS "LtiResourceModel__LtiResourceModel_platform_jwks_url", "LtiResourceModel__LtiResourceModel_platform"."registrated" AS "LtiResourceModel__LtiResourceModel_platform_registrated", "LtiResourceModel__LtiResourceModel_platform"."associated_user" AS "LtiResourceModel__LtiResourceModel_platform_associated_user", "LtiResourceModel__LtiResourceModel_platform"."createdDate" AS "LtiResourceModel__LtiResourceModel_platform_createdDate" FROM "lti_resource_model" "LtiResourceModel" LEFT JOIN "platform_model" "LtiResourceModel__LtiResourceModel_platform" ON "LtiResourceModel__LtiResourceModel_platform"."id"="LtiResourceModel"."platformId" WHERE ( (((("LtiResourceModel__LtiResourceModel_platform"."id" = ?))) AND ("LtiResourceModel"."resource_link_id" = ?)) ) AND ( "LtiResourceModel"."id" IN (?) ) -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","200d101f-2c14-434a-a0f3-57c2a42369fd","154eabd8-a97e-4c90-85e0-8f8cef5fec56"]
query: INSERT INTO "lti_session_model"("id", "launchMessage", "experiment_uri", "createdDate", "resourceId") VALUES (?, ?, NULL, datetime('now'), ?) -- PARAMETERS: ["NcQ4aqdjJiBpdhY4soRUUbHioqJI58oiR9VNOe8OHKI","{\"https://purl.imsglobal.org/spec/lti/claim/message_type\":\"LtiResourceLinkRequest\",\"https://purl.imsglobal.org/spec/lti/claim/roles\":[\"\\\"http://purl.imsglobal.org/vocab/lis/v2/institution/person#Student\"],\"https://purl.imsglobal.org/spec/lti/claim/resource_link\":{\"id\":\"200d101f-2c14-434a-a0f3-57c2a42369fd\",\"description\":\"Assignment to introduce who you are\",\"title\":\"Introduction Assignment\"},\"iss\":\"http://localhost:43213\",\"nonce\":\"qfabIVD70K0wAWAQ46ExFD127qoYj45XsGUM78kDVIk\",\"iat\":1725962433,\"exp\":1725962733}","154eabd8-a97e-4c90-85e0-8f8cef5fec56"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate" FROM "lti_session_model" "LtiSessionModel" WHERE "LtiSessionModel"."id" = ? -- PARAMETERS: ["NcQ4aqdjJiBpdhY4soRUUbHioqJI58oiR9VNOe8OHKI"]
query: SELECT DISTINCT "distinctAlias"."LtiSessionModel_id" AS "ids_LtiSessionModel_id" FROM (SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId", "LtiSessionModel__resource"."id" AS "LtiSessionModel__resource_id", "LtiSessionModel__resource"."resource_link_id" AS "LtiSessionModel__resource_resource_link_id", "LtiSessionModel__resource"."experiment_template_uri" AS "LtiSessionModel__resource_experiment_template_uri", "LtiSessionModel__resource"."namesServiceUrl" AS "LtiSessionModel__resource_namesServiceUrl", "LtiSessionModel__resource"."platformId" AS "LtiSessionModel__resource_platformId", "LtiSessionModel__resource__platform"."id" AS "LtiSessionModel__resource__platform_id", "LtiSessionModel__resource__platform"."iss" AS "LtiSessionModel__resource__platform_iss", "LtiSessionModel__resource__platform"."client_id" AS "LtiSessionModel__resource__platform_client_id", "LtiSessionModel__resource__platform"."deployment_id" AS "LtiSessionModel__resource__platform_deployment_id", "LtiSessionModel__resource__platform"."authentication_request_url" AS "LtiSessionModel__resource__platform_authentication_request_url", "LtiSessionModel__resource__platform"."access_token_url" AS "LtiSessionModel__resource__platform_access_token_url", "LtiSessionModel__resource__platform"."jwks_url" AS "LtiSessionModel__resource__platform_jwks_url", "LtiSessionModel__resource__platform"."registrated" AS "LtiSessionModel__resource__platform_registrated", "LtiSessionModel__resource__platform"."associated_user" AS "LtiSessionModel__resource__platform_associated_user", "LtiSessionModel__resource__platform"."createdDate" AS "LtiSessionModel__resource__platform_createdDate" FROM "lti_session_model" "LtiSessionModel" LEFT JOIN "lti_resource_model" "LtiSessionModel__resource" ON "LtiSessionModel__resource"."id"="LtiSessionModel"."resourceId"  LEFT JOIN "platform_model" "LtiSessionModel__resource__platform" ON "LtiSessionModel__resource__platform"."id"="LtiSessionModel__resource"."platformId" WHERE (("LtiSessionModel"."id" = ?))) "distinctAlias" ORDER BY "LtiSessionModel_id" ASC LIMIT 1 -- PARAMETERS: ["NcQ4aqdjJiBpdhY4soRUUbHioqJI58oiR9VNOe8OHKI"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId", "LtiSessionModel__resource"."id" AS "LtiSessionModel__resource_id", "LtiSessionModel__resource"."resource_link_id" AS "LtiSessionModel__resource_resource_link_id", "LtiSessionModel__resource"."experiment_template_uri" AS "LtiSessionModel__resource_experiment_template_uri", "LtiSessionModel__resource"."namesServiceUrl" AS "LtiSessionModel__resource_namesServiceUrl", "LtiSessionModel__resource"."platformId" AS "LtiSessionModel__resource_platformId", "LtiSessionModel__resource__platform"."id" AS "LtiSessionModel__resource__platform_id", "LtiSessionModel__resource__platform"."iss" AS "LtiSessionModel__resource__platform_iss", "LtiSessionModel__resource__platform"."client_id" AS "LtiSessionModel__resource__platform_client_id", "LtiSessionModel__resource__platform"."deployment_id" AS "LtiSessionModel__resource__platform_deployment_id", "LtiSessionModel__resource__platform"."authentication_request_url" AS "LtiSessionModel__resource__platform_authentication_request_url", "LtiSessionModel__resource__platform"."access_token_url" AS "LtiSessionModel__resource__platform_access_token_url", "LtiSessionModel__resource__platform"."jwks_url" AS "LtiSessionModel__resource__platform_jwks_url", "LtiSessionModel__resource__platform"."registrated" AS "LtiSessionModel__resource__platform_registrated", "LtiSessionModel__resource__platform"."associated_user" AS "LtiSessionModel__resource__platform_associated_user", "LtiSessionModel__resource__platform"."createdDate" AS "LtiSessionModel__resource__platform_createdDate" FROM "lti_session_model" "LtiSessionModel" LEFT JOIN "lti_resource_model" "LtiSessionModel__resource" ON "LtiSessionModel__resource"."id"="LtiSessionModel"."resourceId"  LEFT JOIN "platform_model" "LtiSessionModel__resource__platform" ON "LtiSessionModel__resource__platform"."id"="LtiSessionModel__resource"."platformId" WHERE ( (("LtiSessionModel"."id" = ?)) ) AND ( "LtiSessionModel"."id" IN (?) ) -- PARAMETERS: ["NcQ4aqdjJiBpdhY4soRUUbHioqJI58oiR9VNOe8OHKI","NcQ4aqdjJiBpdhY4soRUUbHioqJI58oiR9VNOe8OHKI"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId" FROM "lti_session_model" "LtiSessionModel" WHERE "LtiSessionModel"."id" IN (?) -- PARAMETERS: ["NcQ4aqdjJiBpdhY4soRUUbHioqJI58oiR9VNOe8OHKI"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."id" = ?)) LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: BEGIN TRANSACTION
query: INSERT INTO "lti_message_model"("id", "nonce", "platformId") VALUES (?, ?, ?) -- PARAMETERS: ["654d4893-ee40-4ac4-9458-bb083db6fbf7","R67iIgf4_9H4hkulU2lcezOaG55_W1aHW6apLtI-Su8","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: COMMIT
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."id" = ?)) LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT DISTINCT "distinctAlias"."LtiMessageModel_id" AS "ids_LtiMessageModel_id" FROM (SELECT "LtiMessageModel"."id" AS "LtiMessageModel_id", "LtiMessageModel"."nonce" AS "LtiMessageModel_nonce", "LtiMessageModel"."platformId" AS "LtiMessageModel_platformId", "LtiMessageModel__LtiMessageModel_platform"."id" AS "LtiMessageModel__LtiMessageModel_platform_id", "LtiMessageModel__LtiMessageModel_platform"."iss" AS "LtiMessageModel__LtiMessageModel_platform_iss", "LtiMessageModel__LtiMessageModel_platform"."client_id" AS "LtiMessageModel__LtiMessageModel_platform_client_id", "LtiMessageModel__LtiMessageModel_platform"."deployment_id" AS "LtiMessageModel__LtiMessageModel_platform_deployment_id", "LtiMessageModel__LtiMessageModel_platform"."authentication_request_url" AS "LtiMessageModel__LtiMessageModel_platform_authentication_request_url", "LtiMessageModel__LtiMessageModel_platform"."access_token_url" AS "LtiMessageModel__LtiMessageModel_platform_access_token_url", "LtiMessageModel__LtiMessageModel_platform"."jwks_url" AS "LtiMessageModel__LtiMessageModel_platform_jwks_url", "LtiMessageModel__LtiMessageModel_platform"."registrated" AS "LtiMessageModel__LtiMessageModel_platform_registrated", "LtiMessageModel__LtiMessageModel_platform"."associated_user" AS "LtiMessageModel__LtiMessageModel_platform_associated_user", "LtiMessageModel__LtiMessageModel_platform"."createdDate" AS "LtiMessageModel__LtiMessageModel_platform_createdDate" FROM "lti_message_model" "LtiMessageModel" LEFT JOIN "platform_model" "LtiMessageModel__LtiMessageModel_platform" ON "LtiMessageModel__LtiMessageModel_platform"."id"="LtiMessageModel"."platformId" WHERE (("LtiMessageModel"."id" = ?))) "distinctAlias" ORDER BY "LtiMessageModel_id" ASC LIMIT 1 -- PARAMETERS: ["654d4893-ee40-4ac4-9458-bb083db6fbf7"]
query: SELECT "LtiMessageModel"."id" AS "LtiMessageModel_id", "LtiMessageModel"."nonce" AS "LtiMessageModel_nonce", "LtiMessageModel"."platformId" AS "LtiMessageModel_platformId", "LtiMessageModel__LtiMessageModel_platform"."id" AS "LtiMessageModel__LtiMessageModel_platform_id", "LtiMessageModel__LtiMessageModel_platform"."iss" AS "LtiMessageModel__LtiMessageModel_platform_iss", "LtiMessageModel__LtiMessageModel_platform"."client_id" AS "LtiMessageModel__LtiMessageModel_platform_client_id", "LtiMessageModel__LtiMessageModel_platform"."deployment_id" AS "LtiMessageModel__LtiMessageModel_platform_deployment_id", "LtiMessageModel__LtiMessageModel_platform"."authentication_request_url" AS "LtiMessageModel__LtiMessageModel_platform_authentication_request_url", "LtiMessageModel__LtiMessageModel_platform"."access_token_url" AS "LtiMessageModel__LtiMessageModel_platform_access_token_url", "LtiMessageModel__LtiMessageModel_platform"."jwks_url" AS "LtiMessageModel__LtiMessageModel_platform_jwks_url", "LtiMessageModel__LtiMessageModel_platform"."registrated" AS "LtiMessageModel__LtiMessageModel_platform_registrated", "LtiMessageModel__LtiMessageModel_platform"."associated_user" AS "LtiMessageModel__LtiMessageModel_platform_associated_user", "LtiMessageModel__LtiMessageModel_platform"."createdDate" AS "LtiMessageModel__LtiMessageModel_platform_createdDate" FROM "lti_message_model" "LtiMessageModel" LEFT JOIN "platform_model" "LtiMessageModel__LtiMessageModel_platform" ON "LtiMessageModel__LtiMessageModel_platform"."id"="LtiMessageModel"."platformId" WHERE ( (("LtiMessageModel"."id" = ?)) ) AND ( "LtiMessageModel"."id" IN (?) ) -- PARAMETERS: ["654d4893-ee40-4ac4-9458-bb083db6fbf7","654d4893-ee40-4ac4-9458-bb083db6fbf7"]
query: DELETE FROM "lti_message_model" WHERE "id" IN (?) -- PARAMETERS: ["654d4893-ee40-4ac4-9458-bb083db6fbf7"]
query: INSERT INTO "lti_resource_model"("id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId") VALUES (?, ?, NULL, NULL, ?) ON CONFLICT DO NOTHING -- PARAMETERS: ["ca684633-bcc0-48cb-a6ed-7aae87cc1126","200d101f-2c14-434a-a0f3-57c2a42369fd","37ab5769-4364-4d97-87a6-e60a4203526b"]
query: SELECT DISTINCT "distinctAlias"."LtiResourceModel_id" AS "ids_LtiResourceModel_id" FROM (SELECT "LtiResourceModel"."id" AS "LtiResourceModel_id", "LtiResourceModel"."resource_link_id" AS "LtiResourceModel_resource_link_id", "LtiResourceModel"."experiment_template_uri" AS "LtiResourceModel_experiment_template_uri", "LtiResourceModel"."namesServiceUrl" AS "LtiResourceModel_namesServiceUrl", "LtiResourceModel"."platformId" AS "LtiResourceModel_platformId", "LtiResourceModel__LtiResourceModel_platform"."id" AS "LtiResourceModel__LtiResourceModel_platform_id", "LtiResourceModel__LtiResourceModel_platform"."iss" AS "LtiResourceModel__LtiResourceModel_platform_iss", "LtiResourceModel__LtiResourceModel_platform"."client_id" AS "LtiResourceModel__LtiResourceModel_platform_client_id", "LtiResourceModel__LtiResourceModel_platform"."deployment_id" AS "LtiResourceModel__LtiResourceModel_platform_deployment_id", "LtiResourceModel__LtiResourceModel_platform"."authentication_request_url" AS "LtiResourceModel__LtiResourceModel_platform_authentication_request_url", "LtiResourceModel__LtiResourceModel_platform"."access_token_url" AS "LtiResourceModel__LtiResourceModel_platform_access_token_url", "LtiResourceModel__LtiResourceModel_platform"."jwks_url" AS "LtiResourceModel__LtiResourceModel_platform_jwks_url", "LtiResourceModel__LtiResourceModel_platform"."registrated" AS "LtiResourceModel__LtiResourceModel_platform_registrated", "LtiResourceModel__LtiResourceModel_platform"."associated_user" AS "LtiResourceModel__LtiResourceModel_platform_associated_user", "LtiResourceModel__LtiResourceModel_platform"."createdDate" AS "LtiResourceModel__LtiResourceModel_platform_createdDate" FROM "lti_resource_model" "LtiResourceModel" LEFT JOIN "platform_model" "LtiResourceModel__LtiResourceModel_platform" ON "LtiResourceModel__LtiResourceModel_platform"."id"="LtiResourceModel"."platformId" WHERE (((("LtiResourceModel__LtiResourceModel_platform"."id" = ?))) AND ("LtiResourceModel"."resource_link_id" = ?))) "distinctAlias" ORDER BY "LtiResourceModel_id" ASC LIMIT 1 -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","200d101f-2c14-434a-a0f3-57c2a42369fd"]
query: SELECT "LtiResourceModel"."id" AS "LtiResourceModel_id", "LtiResourceModel"."resource_link_id" AS "LtiResourceModel_resource_link_id", "LtiResourceModel"."experiment_template_uri" AS "LtiResourceModel_experiment_template_uri", "LtiResourceModel"."namesServiceUrl" AS "LtiResourceModel_namesServiceUrl", "LtiResourceModel"."platformId" AS "LtiResourceModel_platformId", "LtiResourceModel__LtiResourceModel_platform"."id" AS "LtiResourceModel__LtiResourceModel_platform_id", "LtiResourceModel__LtiResourceModel_platform"."iss" AS "LtiResourceModel__LtiResourceModel_platform_iss", "LtiResourceModel__LtiResourceModel_platform"."client_id" AS "LtiResourceModel__LtiResourceModel_platform_client_id", "LtiResourceModel__LtiResourceModel_platform"."deployment_id" AS "LtiResourceModel__LtiResourceModel_platform_deployment_id", "LtiResourceModel__LtiResourceModel_platform"."authentication_request_url" AS "LtiResourceModel__LtiResourceModel_platform_authentication_request_url", "LtiResourceModel__LtiResourceModel_platform"."access_token_url" AS "LtiResourceModel__LtiResourceModel_platform_access_token_url", "LtiResourceModel__LtiResourceModel_platform"."jwks_url" AS "LtiResourceModel__LtiResourceModel_platform_jwks_url", "LtiResourceModel__LtiResourceModel_platform"."registrated" AS "LtiResourceModel__LtiResourceModel_platform_registrated", "LtiResourceModel__LtiResourceModel_platform"."associated_user" AS "LtiResourceModel__LtiResourceModel_platform_associated_user", "LtiResourceModel__LtiResourceModel_platform"."createdDate" AS "LtiResourceModel__LtiResourceModel_platform_createdDate" FROM "lti_resource_model" "LtiResourceModel" LEFT JOIN "platform_model" "LtiResourceModel__LtiResourceModel_platform" ON "LtiResourceModel__LtiResourceModel_platform"."id"="LtiResourceModel"."platformId" WHERE ( (((("LtiResourceModel__LtiResourceModel_platform"."id" = ?))) AND ("LtiResourceModel"."resource_link_id" = ?)) ) AND ( "LtiResourceModel"."id" IN (?) ) -- PARAMETERS: ["37ab5769-4364-4d97-87a6-e60a4203526b","200d101f-2c14-434a-a0f3-57c2a42369fd","154eabd8-a97e-4c90-85e0-8f8cef5fec56"]
query: INSERT INTO "lti_session_model"("id", "launchMessage", "experiment_uri", "createdDate", "resourceId") VALUES (?, ?, NULL, datetime('now'), ?) -- PARAMETERS: ["mBSq9JYT2W6tw5ifzzBaJEBKd-aS7I8HHp4YgmaWUxo","{\"https://purl.imsglobal.org/spec/lti/claim/message_type\":\"LtiResourceLinkRequest\",\"https://purl.imsglobal.org/spec/lti/claim/roles\":[\"\\\"http://purl.imsglobal.org/vocab/lis/v2/institution/person#Student\"],\"https://purl.imsglobal.org/spec/lti/claim/resource_link\":{\"id\":\"200d101f-2c14-434a-a0f3-57c2a42369fd\",\"description\":\"Assignment to introduce who you are\",\"title\":\"Introduction Assignment\"},\"iss\":\"http://localhost:43213\",\"nonce\":\"R67iIgf4_9H4hkulU2lcezOaG55_W1aHW6apLtI-Su8\",\"iat\":1725962433,\"exp\":1725962733}","154eabd8-a97e-4c90-85e0-8f8cef5fec56"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate" FROM "lti_session_model" "LtiSessionModel" WHERE "LtiSessionModel"."id" = ? -- PARAMETERS: ["mBSq9JYT2W6tw5ifzzBaJEBKd-aS7I8HHp4YgmaWUxo"]
query: SELECT DISTINCT "distinctAlias"."LtiSessionModel_id" AS "ids_LtiSessionModel_id" FROM (SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId", "LtiSessionModel__resource"."id" AS "LtiSessionModel__resource_id", "LtiSessionModel__resource"."resource_link_id" AS "LtiSessionModel__resource_resource_link_id", "LtiSessionModel__resource"."experiment_template_uri" AS "LtiSessionModel__resource_experiment_template_uri", "LtiSessionModel__resource"."namesServiceUrl" AS "LtiSessionModel__resource_namesServiceUrl", "LtiSessionModel__resource"."platformId" AS "LtiSessionModel__resource_platformId", "LtiSessionModel__resource__platform"."id" AS "LtiSessionModel__resource__platform_id", "LtiSessionModel__resource__platform"."iss" AS "LtiSessionModel__resource__platform_iss", "LtiSessionModel__resource__platform"."client_id" AS "LtiSessionModel__resource__platform_client_id", "LtiSessionModel__resource__platform"."deployment_id" AS "LtiSessionModel__resource__platform_deployment_id", "LtiSessionModel__resource__platform"."authentication_request_url" AS "LtiSessionModel__resource__platform_authentication_request_url", "LtiSessionModel__resource__platform"."access_token_url" AS "LtiSessionModel__resource__platform_access_token_url", "LtiSessionModel__resource__platform"."jwks_url" AS "LtiSessionModel__resource__platform_jwks_url", "LtiSessionModel__resource__platform"."registrated" AS "LtiSessionModel__resource__platform_registrated", "LtiSessionModel__resource__platform"."associated_user" AS "LtiSessionModel__resource__platform_associated_user", "LtiSessionModel__resource__platform"."createdDate" AS "LtiSessionModel__resource__platform_createdDate" FROM "lti_session_model" "LtiSessionModel" LEFT JOIN "lti_resource_model" "LtiSessionModel__resource" ON "LtiSessionModel__resource"."id"="LtiSessionModel"."resourceId"  LEFT JOIN "platform_model" "LtiSessionModel__resource__platform" ON "LtiSessionModel__resource__platform"."id"="LtiSessionModel__resource"."platformId" WHERE (("LtiSessionModel"."id" = ?))) "distinctAlias" ORDER BY "LtiSessionModel_id" ASC LIMIT 1 -- PARAMETERS: ["mBSq9JYT2W6tw5ifzzBaJEBKd-aS7I8HHp4YgmaWUxo"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId", "LtiSessionModel__resource"."id" AS "LtiSessionModel__resource_id", "LtiSessionModel__resource"."resource_link_id" AS "LtiSessionModel__resource_resource_link_id", "LtiSessionModel__resource"."experiment_template_uri" AS "LtiSessionModel__resource_experiment_template_uri", "LtiSessionModel__resource"."namesServiceUrl" AS "LtiSessionModel__resource_namesServiceUrl", "LtiSessionModel__resource"."platformId" AS "LtiSessionModel__resource_platformId", "LtiSessionModel__resource__platform"."id" AS "LtiSessionModel__resource__platform_id", "LtiSessionModel__resource__platform"."iss" AS "LtiSessionModel__resource__platform_iss", "LtiSessionModel__resource__platform"."client_id" AS "LtiSessionModel__resource__platform_client_id", "LtiSessionModel__resource__platform"."deployment_id" AS "LtiSessionModel__resource__platform_deployment_id", "LtiSessionModel__resource__platform"."authentication_request_url" AS "LtiSessionModel__resource__platform_authentication_request_url", "LtiSessionModel__resource__platform"."access_token_url" AS "LtiSessionModel__resource__platform_access_token_url", "LtiSessionModel__resource__platform"."jwks_url" AS "LtiSessionModel__resource__platform_jwks_url", "LtiSessionModel__resource__platform"."registrated" AS "LtiSessionModel__resource__platform_registrated", "LtiSessionModel__resource__platform"."associated_user" AS "LtiSessionModel__resource__platform_associated_user", "LtiSessionModel__resource__platform"."createdDate" AS "LtiSessionModel__resource__platform_createdDate" FROM "lti_session_model" "LtiSessionModel" LEFT JOIN "lti_resource_model" "LtiSessionModel__resource" ON "LtiSessionModel__resource"."id"="LtiSessionModel"."resourceId"  LEFT JOIN "platform_model" "LtiSessionModel__resource__platform" ON "LtiSessionModel__resource__platform"."id"="LtiSessionModel__resource"."platformId" WHERE ( (("LtiSessionModel"."id" = ?)) ) AND ( "LtiSessionModel"."id" IN (?) ) -- PARAMETERS: ["mBSq9JYT2W6tw5ifzzBaJEBKd-aS7I8HHp4YgmaWUxo","mBSq9JYT2W6tw5ifzzBaJEBKd-aS7I8HHp4YgmaWUxo"]
query: SELECT "LtiSessionModel"."id" AS "LtiSessionModel_id", "LtiSessionModel"."launchMessage" AS "LtiSessionModel_launchMessage", "LtiSessionModel"."experiment_uri" AS "LtiSessionModel_experiment_uri", "LtiSessionModel"."createdDate" AS "LtiSessionModel_createdDate", "LtiSessionModel"."resourceId" AS "LtiSessionModel_resourceId" FROM "lti_session_model" "LtiSessionModel" WHERE "LtiSessionModel"."id" IN (?) -- PARAMETERS: ["mBSq9JYT2W6tw5ifzzBaJEBKd-aS7I8HHp4YgmaWUxo"]
    ✔ should be able to launch multiple times (332ms)

  Platform
query: PRAGMA foreign_keys = OFF
query: BEGIN TRANSACTION
query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" IN ('platform_model','lti_message_model','lti_resource_model','lti_session_model','lti_resource_student','lti_resource_student_role_map_model')
query: SELECT * FROM "sqlite_master" WHERE "type" = 'index' AND "tbl_name" IN ('platform_model','lti_message_model','lti_resource_model','lti_session_model','lti_resource_student','lti_resource_student_role_map_model')
query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'typeorm_metadata'
query: CREATE TABLE "platform_model" ("id" varchar PRIMARY KEY NOT NULL, "iss" varchar, "client_id" varchar, "deployment_id" varchar, "authentication_request_url" varchar, "access_token_url" varchar, "jwks_url" varchar, "registrated" boolean NOT NULL, "associated_user" varchar, "createdDate" datetime NOT NULL DEFAULT (datetime('now')))
query: CREATE TABLE "lti_message_model" ("id" varchar PRIMARY KEY NOT NULL, "nonce" varchar NOT NULL, "platformId" varchar)
query: CREATE TABLE "lti_resource_model" ("id" varchar PRIMARY KEY NOT NULL, "resource_link_id" varchar NOT NULL, "experiment_template_uri" varchar, "namesServiceUrl" varchar, "platformId" varchar, CONSTRAINT "UQ_b32c74da4904eb5a89e54cd10f0" UNIQUE ("resource_link_id", "platformId"))
query: CREATE TABLE "lti_session_model" ("id" varchar PRIMARY KEY NOT NULL, "launchMessage" text NOT NULL, "experiment_uri" varchar, "createdDate" datetime NOT NULL DEFAULT (datetime('now')), "resourceId" varchar)
query: CREATE TABLE "lti_resource_student" ("id" varchar PRIMARY KEY NOT NULL, "external_id" varchar NOT NULL, "name" varchar, "email" varchar, "resourceId" varchar, CONSTRAINT "UQ_0c5be18cabc4568deceed983a28" UNIQUE ("resourceId", "external_id"))
query: CREATE TABLE "lti_resource_student_role_map_model" ("id" varchar PRIMARY KEY NOT NULL, "role" varchar NOT NULL, "device" varchar NOT NULL, "studentId" varchar, CONSTRAINT "UQ_85227c7e05549f72ce80b9838cd" UNIQUE ("studentId", "role"))
query: CREATE TABLE "temporary_lti_message_model" ("id" varchar PRIMARY KEY NOT NULL, "nonce" varchar NOT NULL, "platformId" varchar, CONSTRAINT "FK_83b08a7ab0a613dd9291669b1b8" FOREIGN KEY ("platformId") REFERENCES "platform_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_message_model"("id", "nonce", "platformId") SELECT "id", "nonce", "platformId" FROM "lti_message_model"
query: DROP TABLE "lti_message_model"
query: ALTER TABLE "temporary_lti_message_model" RENAME TO "lti_message_model"
query: CREATE TABLE "temporary_lti_resource_model" ("id" varchar PRIMARY KEY NOT NULL, "resource_link_id" varchar NOT NULL, "experiment_template_uri" varchar, "namesServiceUrl" varchar, "platformId" varchar, CONSTRAINT "UQ_b32c74da4904eb5a89e54cd10f0" UNIQUE ("resource_link_id", "platformId"), CONSTRAINT "FK_28e63bcc54c528e6fbb8ce85e57" FOREIGN KEY ("platformId") REFERENCES "platform_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_resource_model"("id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId") SELECT "id", "resource_link_id", "experiment_template_uri", "namesServiceUrl", "platformId" FROM "lti_resource_model"
query: DROP TABLE "lti_resource_model"
query: ALTER TABLE "temporary_lti_resource_model" RENAME TO "lti_resource_model"
query: CREATE TABLE "temporary_lti_session_model" ("id" varchar PRIMARY KEY NOT NULL, "launchMessage" text NOT NULL, "experiment_uri" varchar, "createdDate" datetime NOT NULL DEFAULT (datetime('now')), "resourceId" varchar, CONSTRAINT "FK_1f00f22e8b8c4ac22385800114e" FOREIGN KEY ("resourceId") REFERENCES "lti_resource_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_session_model"("id", "launchMessage", "experiment_uri", "createdDate", "resourceId") SELECT "id", "launchMessage", "experiment_uri", "createdDate", "resourceId" FROM "lti_session_model"
query: DROP TABLE "lti_session_model"
query: ALTER TABLE "temporary_lti_session_model" RENAME TO "lti_session_model"
query: CREATE TABLE "temporary_lti_resource_student" ("id" varchar PRIMARY KEY NOT NULL, "external_id" varchar NOT NULL, "name" varchar, "email" varchar, "resourceId" varchar, CONSTRAINT "UQ_0c5be18cabc4568deceed983a28" UNIQUE ("resourceId", "external_id"), CONSTRAINT "FK_0e4e3416e03e35da792b1c37e97" FOREIGN KEY ("resourceId") REFERENCES "lti_resource_model" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_resource_student"("id", "external_id", "name", "email", "resourceId") SELECT "id", "external_id", "name", "email", "resourceId" FROM "lti_resource_student"
query: DROP TABLE "lti_resource_student"
query: ALTER TABLE "temporary_lti_resource_student" RENAME TO "lti_resource_student"
query: CREATE TABLE "temporary_lti_resource_student_role_map_model" ("id" varchar PRIMARY KEY NOT NULL, "role" varchar NOT NULL, "device" varchar NOT NULL, "studentId" varchar, CONSTRAINT "UQ_85227c7e05549f72ce80b9838cd" UNIQUE ("studentId", "role"), CONSTRAINT "FK_bb7977461bc0c66845b24084dae" FOREIGN KEY ("studentId") REFERENCES "lti_resource_student" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION)
query: INSERT INTO "temporary_lti_resource_student_role_map_model"("id", "role", "device", "studentId") SELECT "id", "role", "device", "studentId" FROM "lti_resource_student_role_map_model"
query: DROP TABLE "lti_resource_student_role_map_model"
query: ALTER TABLE "temporary_lti_resource_student_role_map_model" RENAME TO "lti_resource_student_role_map_model"
query: COMMIT
query: PRAGMA foreign_keys = ON
query: INSERT INTO "platform_model"("id", "iss", "client_id", "deployment_id", "authentication_request_url", "access_token_url", "jwks_url", "registrated", "associated_user", "createdDate") VALUES (?, NULL, NULL, NULL, NULL, NULL, NULL, 0, ?, datetime('now')) -- PARAMETERS: ["5453ef3e-9860-4550-b92b-12828c25e262","user1"]
query: INSERT INTO "platform_model"("id", "iss", "client_id", "deployment_id", "authentication_request_url", "access_token_url", "jwks_url", "registrated", "associated_user", "createdDate") VALUES (?, NULL, NULL, NULL, NULL, NULL, NULL, 0, ?, datetime('now')) -- PARAMETERS: ["b6202b9d-e334-47f7-aba3-bb22abf18566","user2"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" = ? -- PARAMETERS: ["5453ef3e-9860-4550-b92b-12828c25e262"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" = ? -- PARAMETERS: ["b6202b9d-e334-47f7-aba3-bb22abf18566"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" IN (?) -- PARAMETERS: ["5453ef3e-9860-4550-b92b-12828c25e262"]
query: BEGIN TRANSACTION
query: UPDATE "platform_model" SET "createdDate" = ? WHERE "id" IN (?) -- PARAMETERS: ["2024-01-01 00:00:00.000","5453ef3e-9860-4550-b92b-12828c25e262"]
query: COMMIT
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" IN (?) -- PARAMETERS: ["b6202b9d-e334-47f7-aba3-bb22abf18566"]
query: BEGIN TRANSACTION
query: UPDATE "platform_model" SET "createdDate" = ? WHERE "id" IN (?) -- PARAMETERS: ["2024-01-01 00:00:00.000","b6202b9d-e334-47f7-aba3-bb22abf18566"]
query: COMMIT
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" IN (?) -- PARAMETERS: ["5453ef3e-9860-4550-b92b-12828c25e262"]
query: BEGIN TRANSACTION
query: UPDATE "platform_model" SET "registrated" = 1 WHERE "id" IN (?) -- PARAMETERS: ["5453ef3e-9860-4550-b92b-12828c25e262"]
query: COMMIT
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE (("PlatformModel"."registrated" = ?)) -- PARAMETERS: [1]
    ✔ should list platforms when authorized (41ms)
query: DELETE FROM "platform_model" WHERE ("registrated" = ? AND "createdDate" < ?) -- PARAMETERS: [0,"2024-09-10 09:50:33.587"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."iss" AS "PlatformModel_iss", "PlatformModel"."client_id" AS "PlatformModel_client_id", "PlatformModel"."deployment_id" AS "PlatformModel_deployment_id", "PlatformModel"."authentication_request_url" AS "PlatformModel_authentication_request_url", "PlatformModel"."access_token_url" AS "PlatformModel_access_token_url", "PlatformModel"."jwks_url" AS "PlatformModel_jwks_url", "PlatformModel"."registrated" AS "PlatformModel_registrated", "PlatformModel"."associated_user" AS "PlatformModel_associated_user", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel"
    ✔ should delete not registered platforms from the database
query: INSERT INTO "platform_model"("id", "iss", "client_id", "deployment_id", "authentication_request_url", "access_token_url", "jwks_url", "registrated", "associated_user", "createdDate") VALUES (?, NULL, NULL, NULL, NULL, NULL, NULL, 0, ?, datetime('now')) -- PARAMETERS: ["67c527ff-0f3f-4669-b07b-0919f0ccd9c4","user"]
query: SELECT "PlatformModel"."id" AS "PlatformModel_id", "PlatformModel"."createdDate" AS "PlatformModel_createdDate" FROM "platform_model" "PlatformModel" WHERE "PlatformModel"."id" = ? -- PARAMETERS: ["67c527ff-0f3f-4669-b07b-0919f0ccd9c4"]
    ✔ should create a platform when authorized (39ms)
    ✔ should NOT create a platform when NOT authorized


  6 passing (1s)