Skip to content

Instantly share code, notes, and snippets.

@akhilesh26

akhilesh26/tests

Created May 16, 2019 09:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save akhilesh26/95803febadc3e62937b96aaa8fe49d0e to your computer and use it in GitHub Desktop.
Save akhilesh26/95803febadc3e62937b96aaa8fe49d0e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tests
46) achievement module
Fun Runner Achievement
should be given to someone with a revision a day for a week:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
47) achievement module
Fun Runner Achievement
shouldn't be given to someone without a revision a day for a week:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
48) achievement module
Hot Off the Press Achievement
should be given to someone with edition revision released this week:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
49) achievement module
Hot Off the Press Achievement
shouldn't be given when edition revision released a week ago:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
50) achievement module
Marathoner Achievement
should be given to someone with a revision a day for 30 days:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
51) achievement module
Marathoner Achievement
shouldn't be given to someone without a revision a day for 30 days:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
52) achievement module
Revisionist Achievement
I should be given to someone with a revision:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
53) achievement module
Revisionist Achievement
II should be given to someone with 50 revisions:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
54) achievement module
Revisionist Achievement
III should be given to someone with 250 revisions:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
55) achievement module
Revisionist Achievement
should not be given to someone without a revision:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
56) achievement module
Sprinter Achievement
should be given to someone with 10 revisions in an hour:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
57) achievement module
Sprinter Achievement
should not be given to someone with 9 revisions in an hour:
select "bookbrainz"."author_revision".* from "bookbrainz"."author_revision" inner join "bookbrainz"."revision" on "bookbrainz"."revision"."id" = "bookbrainz"."author_revision"."id" left outer join "bookbrainz"."revision_parent" on "bookbrainz"."revision_parent"."child_id" = "bookbrainz"."author_revision"."id" where "bookbrainz"."revision"."author_id" = $1 and "bookbrainz"."revision_parent"."parent_id" is null group by "author_revision"."id", "author_revision"."bbid", "revision"."id" - relation "bookbrainz.author_revision" does not exist
error: relation "bookbrainz.author_revision" does not exist
at Connection.parseE (node_modules/pg/lib/connection.js:601:11)
at Connection.parseMessage (node_modules/pg/lib/connection.js:398:19)
at Socket.<anonymous> (node_modules/pg/lib/connection.js:120:22)
at addChunk (_stream_readable.js:265:12)
at readableAddChunk (_stream_readable.js:252:11)
at Socket.Readable.push (_stream_readable.js:209:10)
at TCP.onread (net.js:598:20)
From previous event:
at Client_PG._query (node_modules/knex/lib/dialects/postgres/index.js:260:12)
at Client_PG.query (node_modules/knex/lib/client.js:202:17)
at Runner.<anonymous> (node_modules/knex/lib/runner.js:146:36)
From previous event:
at node_modules/knex/lib/runner.js:48:21
From previous event:
at Runner.run (node_modules/knex/lib/runner.js:34:31)
at Builder.Target.then (node_modules/knex/lib/interface.js:20:43)
58) GET /
should return 200:
Error: expected 200 "OK", got 500 "Internal Server Error"
at Test._assertStatus (node_modules/supertest/lib/test.js:268:12)
at Test._assertFunction (node_modules/supertest/lib/test.js:283:11)
at Test.assert (node_modules/supertest/lib/test.js:173:18)
at assert (node_modules/supertest/lib/test.js:131:12)
at node_modules/supertest/lib/test.js:128:5
at Test.Request.callback (node_modules/supertest/node_modules/superagent/lib/node/index.js:718:3)
at Stream.parser (node_modules/supertest/node_modules/superagent/lib/node/index.js:906:18)
at Unzip.unzip.on (node_modules/supertest/node_modules/superagent/lib/node/unzip.js:55:12)
at endReadableNT (_stream_readable.js:1054:12)
at _combinedTickCallback (internal/process/next_tick.js:138:11)
at process._tickCallback (internal/process/next_tick.js:180:9)
About to exit with code: 58
Cleaning up before closing
npm ERR! Test failed. See above for more details.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment