Seed tasks executed but database is not affected

[nemanjam]

I have seed singleton class that works when called from backend code or as yarn script but fails only when called as Cypress task. And to be more weird seed/teardown functions are called, console.logs are executed but Prisma calls fail silently without exceptions and process.env.DEBUG = '*' logs nothing unusual.

// cypress/plugins/index.js

on('task', {
  'db:seed': async () => {
    await seedInstance.handledSeed(); // both functions work from backend and as yarn seed
    return null;
  },
  'db:teardown': async () => {
    await seedInstance.handledDeleteAllTables();
    return null;
  },
});

// call in cypress/e2e/post.test.ts

  before(() => {
    cy.task('db:seed'); // js invoked but sql not affected
    cy.loginAsAdmin();
  });

  after(() => {
    cy.task('db:teardown'); // same
  });

Here is example log:

Why you should do it regularly:
https://github.com/browserslist/browserslist#browsers-data-updating
GET /__cypress/tests?p=cypress/e2e/post.test.ts 200 8044.491 ms - -
GET /__cypress/tests?p=cypress/support/index.js 200 8161.252 ms - -
GET /__cypress/runner/fonts/fa-regular-400.woff2 200 1.425 ms - 13600
Start seeding ... // SEED IS CALLED, BUT NO DATA IN DB
Deleting avatars ... 
Deleting headers ... 
Deleting tables ...
  prisma:client Prisma Client call: +21s
  prisma:client prisma.post.deleteMany(undefined) +1ms
  prisma:client Generated request: +1ms
  prisma:client mutation {
  prisma:client   deleteManyPost {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client Prisma Client call: +1ms
  prisma:client prisma.account.deleteMany(undefined) +0ms
  prisma:client Generated request: +0ms
  prisma:client mutation {
  prisma:client   deleteManyAccount {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client Prisma Client call: +0ms
  prisma:client prisma.session.deleteMany(undefined) +0ms
  prisma:client Generated request: +0ms
  prisma:client mutation {
  prisma:client   deleteManySession {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +1ms
  prisma:client Prisma Client call: +0ms
  prisma:client prisma.verificationToken.deleteMany(undefined) +0ms
  prisma:client Generated request: +0ms
  prisma:client mutation {
  prisma:client   deleteManyVerificationToken {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client Prisma Client call: +1ms
  prisma:client prisma.user.deleteMany(undefined) +0ms
  prisma:client Generated request: +0ms
  prisma:client mutation {
  prisma:client   deleteManyUser {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client:libraryEngine requestBatch +20s
  prisma:client:libraryEngine library starting +2ms
  prisma:client:libraryEngine library started +58ms
Tables deleted.
  prisma:client Prisma Client call: +97ms
  prisma:client prisma.user.create({
  prisma:client   data: {
  prisma:client     name: 'user3 name',
  prisma:client     username: 'user3',
  prisma:client     email: '[email protected]',
  prisma:client     image: undefined,
  prisma:client     headerImage: undefined,
  prisma:client     password: '$2a$10$Y7isARSc7aQzZu1uY2af0.jNJi8VnPgidQS2H8pZcqSaLnl/exiLS',
  prisma:client     bio: 'Aut tempore deleniti consequatur minima. Ab architecto et recusandae. Eos voluptates placeat vel accusantium et.',
  prisma:client     role: 'user',
  prisma:client     posts: {
  prisma:client       create: [
  prisma:client         {
  prisma:client           title: 'Fugiat labore occaecati optio.',
  prisma:client           content: 'Autem aut sit. Autem et eos libero a cumque ut. Quia voluptatem voluptates et voluptas animi blanditiis nemo. Magni sit facilis ullam repellendus expedita ducimus. Perferendis optio est delectus ab rerum ullam ut.\nCulpa occaecati ipsam sunt est quaerat odit. Omnis temporibus quisquam. Illo quia accusantium soluta error aut nesciunt veritatis.\nVoluptatum non rerum ut occaecati et et molestiae. Minus reprehenderit quos dolorem ipsum quaerat ab exercitationem. Dignissimos quo sunt. Eos excepturi ad suscipit consequatur inventore et nisi impedit.',
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: 'Doloribus similique qui odit.',
  prisma:client           content: 'Sed dolorum aspernatur sit vero asperiores blanditiis error quaerat. Nihil ut nobis excepturi omnis voluptas incidunt consequatur. Numquam qui debitis vel quas consectetur tempore quia.\nEum quibusdam aut nisi quae et dolores autem nemo. Nesciunt nihil autem non autem praesentium aut earum eaque. Iure reiciendis quaerat vitae eligendi. Sed alias ex consectetur quos sit assumenda velit dignissimos qui. Vel neque similique et dolorem ea corrupti dolores occaecati.',
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: 'Deserunt inventore quos.',
  prisma:client           content: 'Et excepturi et sit non eos sit neque dignissimos. Autem voluptates vel. Perferendis dolorem eum aut. Magni dolor sequi quod. Amet adipisci ipsam animi pariatur similique vero a. Unde nisi illum eum.\nSit corrupti nihil maxime aliquid iusto quo qui quam. Provident quia debitis nostrum laudantium est possimus. Dignissimos quasi perferendis voluptate sunt aspernatur.\nNatus quia et et quia expedita. Omnis est quo ut eligendi aperiam et exercitationem est. Maxime quisquam itaque ut cum dolores delectus.',
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: 'Iure laboriosam sed cumque.',
  prisma:client           content: 'Sequi vitae incidunt quas deleniti id eum repellendus. In eos aut quo impedit dicta veritatis ipsam repudiandae eum. Enim eius culpa dicta. Laboriosam ut commodi esse at nihil quisquam magni impedit. Fugit ducimus sed perspiciatis quis quasi. Assumenda quidem libero sit.\nQuia voluptatem tempore saepe nam ut. Rem nemo ab. Eum veniam vitae dolorem magnam. Ut incidunt nemo a ut quas laborum odit at iure. Facilis doloremque maxime.',
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: 'Veritatis fugit dicta.',
  prisma:client           content: 'Ad doloremque itaque. Doloribus aliquam vitae quisquam ratione. Quis voluptatem aut velit. Corrupti et fugiat hic consectetur velit perferendis qui temporibus earum.\nQuisquam ratione asperiores dolorum. Autem explicabo saepe at suscipit nihil autem ut. Consequuntur voluptas rerum temporibus. Voluptates cupiditate impedit. Molestiae ullam voluptate. Totam quam eius omnis.\nQuasi soluta dolorem. Quod vitae facere ducimus. Quibusdam qui molestias nihil. In est voluptates perferendis vitae aut est. Natus tempore quas consectetur. Optio aspernatur labore tempora doloribus.',
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: 'Voluptatum molestias est.',
  prisma:client           content: 'Illum recusandae rem vitae modi quo quo totam. Voluptatem labore qui in odit ea. Aliquid tempore recusandae dolorem. Voluptate repellendus dolores minus error explicabo rerum. Quo illum voluptatibus itaque suscipit repellendus sunt.\nVoluptatum error animi temporibus autem corporis quaerat. Atque ut perspiciatis voluptas minus sed. Sed vel itaque et ipsum. Recusandae non sit similique minus. Aut voluptatem reprehenderit. Molestiae rerum voluptatem voluptas odit.\nQuis sed sint sed est ut. Illum aut nihil. Ea optio velit assumenda sapiente distinctio culpa ut unde. Officia voluptas et qui facere dolor magnam non eius. Voluptatum error voluptatem nemo ut consectetur sit ipsa qui culpa.',
  prisma:client           published: true
  prisma:client         }
  prisma:client       ]
  prisma:client     }
  prisma:client   }
  
  ...
  
  prisma:client }) +1ms
  prisma:client Generated request: +1ms
  prisma:client mutation {
  prisma:client   createOneUser(data: {
  prisma:client     name: "user0 name"
  prisma:client     username: "user0"
  prisma:client     email: "[email protected]"
  prisma:client     image: "avatar0.jpg"
  prisma:client     headerImage: "header0.jpg"
  prisma:client     password: "$2a$10$Y7isARSc7aQzZu1uY2af0.jNJi8VnPgidQS2H8pZcqSaLnl/exiLS"
  prisma:client     bio: "Maiores qui consequatur quasi adipisci atque nemo sapiente alias. Ut ut eos quis aut. Quia necessitatibus voluptatem consequatur omnis vel autem."
  prisma:client     role: "admin"
  prisma:client     posts: {
  prisma:client       create: [
  prisma:client         {
  prisma:client           title: "Corrupti id perferendis sit autem dignissimos."
  prisma:client           content: "Quos in doloribus. Aspernatur maiores sapiente. Facilis rerum qui in molestiae. Velit labore odio provident voluptatibus repellat molestiae.\nRepellat laudantium saepe quidem animi impedit ex et. Amet quo autem eius delectus maiores rerum atque ipsa. Voluptatem mollitia totam sint. Quae in tempora consequatur enim rem mollitia minus rerum sed.\nDolor vitae voluptas et nostrum rerum doloribus provident voluptatem quas. Omnis modi earum corporis et. Distinctio sit adipisci."
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: "Ipsa vitae sint."
  prisma:client           content: "Cum et nisi repudiandae non officia voluptas voluptate. Nemo dolorem atque culpa. Saepe aliquam reprehenderit quas unde est et dolores quo. Debitis et reiciendis voluptas mollitia. Natus qui possimus magni voluptatem et ut. Sed odio omnis quis ea rerum ea fugiat enim.\nUt ex explicabo dolor aut eaque. Aut tempora sunt eveniet voluptatem reiciendis enim excepturi voluptatum. Voluptatem labore odit impedit voluptate odit nihil sed suscipit. Est dolorem et maiores quia modi et impedit. Cum sint iure quisquam dolorem occaecati qui sed beatae. Neque nam quibusdam harum."
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: "Mollitia omnis ut error exercitationem."
  prisma:client           content: "Itaque consectetur ea explicabo cum aut aliquid perferendis. Aut vel eligendi est quas dolore modi. Et rerum recusandae et rerum. At omnis repellendus saepe omnis consectetur rem autem."
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: "Ea et facilis tempora et consequatur."
  prisma:client           content: "Sunt soluta voluptatem error aut iusto aut accusamus. Ut dolore est. Ut voluptas iure molestiae. Qui est vel consequatur quos et facere qui nisi dolor."
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: "Molestias incidunt dolores iure est laborum quaerat est."
  prisma:client           content: "Sint tempore blanditiis sit sunt hic est inventore quia porro. Consequatur officiis nulla molestiae fugit optio cum consequatur est laudantium. Facere qui sint numquam voluptatibus ea. Natus eius est alias cumque in. Modi quod cumque ipsa hic. Nisi distinctio rerum vel delectus quas sapiente odio sunt."
  prisma:client           published: true
  prisma:client         },
  prisma:client         {
  prisma:client           title: "Facere ut modi et consectetur beatae excepturi quia dolores."
  prisma:client           content: "Dolorem esse voluptatibus qui necessitatibus distinctio consequuntur. Rerum voluptas commodi facere sunt pariatur et eius reiciendis. Dolorem quidem aut sunt atque illum occaecati. Quae molestias dolor corrupti est deleniti qui voluptate dicta.\nEst quo eum repellendus magnam quis illum veritatis eum quae. Delectus vel praesentium consequatur illum asperiores sit est beatae voluptatum. Culpa eveniet aut molestiae dolore. Autem illo molestiae occaecati sit. Labore est enim omnis occaecati quae ipsum odio corporis. Id iusto vel placeat doloremque cupiditate quia velit facilis praesentium.\nSunt quibusdam eaque quos eum doloremque enim. Consequatur qui exercitationem nihil voluptate id laboriosam aut sequi. Id qui ipsam et aliquam laboriosam exercitationem. Reprehenderit eum numquam est sit."
  prisma:client           published: true
  prisma:client         }
  prisma:client       ]
  prisma:client     }
  prisma:client   }) {
  prisma:client     id
  prisma:client     name
  prisma:client     email
  prisma:client     username
  prisma:client     provider
  prisma:client     password
  prisma:client     emailVerified
  prisma:client     image
  prisma:client     headerImage
  prisma:client     bio
  prisma:client     role
  prisma:client     createdAt
  prisma:client     updatedAt
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client:libraryEngine sending request, this.libraryStarted: true +14ms
Created user with email: [email protected]
Seeding finished.
GET / 200 25.842 ms - -
GET /_next/static/css/91fdf8e27ef66c04.css 200 161.522 ms - -
GET /_next/static/chunks/webpack-cf813b4a69127d4f.js 200 217.413 ms - -
GET /_next/static/chunks/1bfc9850-20cb08922fb5d929.js 200 204.774 ms - -
GET /_next/static/-X9bz3RiG2e6mze2eopzx/_ssgManifest.js 200 232.747 ms - -
GET /_next/static/-X9bz3RiG2e6mze2eopzx/_middlewareManifest.js 200 223.125 ms - -
GET /_next/static/chunks/ae51ba48-9a5e8f2082ed0926.js 200 309.260 ms - -
GET /_next/static/chunks/d7eeaac4-675a82cdfea8c592.js 200 303.975 ms - -
GET /_next/static/chunks/584-e542ad78e4b10dd6.js 200 295.019 ms - -
GET /_next/static/chunks/10-5c515c9aeea75373.js 200 284.691 ms - -
GET /_next/static/chunks/78e521c3-7c4f33d3f8c6756f.js 200 330.485 ms - -
GET /_next/static/chunks/0c428ae2-059fd4feef6ba076.js 200 325.306 ms - -
GET /_next/static/chunks/695-b6d55be6ba0a8678.js 200 293.952 ms - -
GET /_next/static/-X9bz3RiG2e6mze2eopzx/_buildManifest.js 200 289.942 ms - -
GET /_next/static/chunks/459-7acdffd75680476b.js 200 305.502 ms - -
GET /_next/static/chunks/pages/index-a426bd265b0d8976.js 200 303.511 ms - -
GET /_next/static/chunks/75fc9c18-2be6c4e45cff1557.js 200 301.836 ms - -
GET /_next/static/chunks/164-1133fac99390b042.js 200 294.357 ms - -
GET /_next/static/chunks/main-f78e1a6ebfd10c75.js 200 295.702 ms - -
GET /_next/static/chunks/framework-5644b7f9cc9a7b07.js 200 213.935 ms - -
GET /_next/static/chunks/131-cd3a4bdb9dd54a34.js 200 308.791 ms - -
GET /_next/static/chunks/pages/_app-7d19ad39394989ad.js 200 322.229 ms - -
GET /api/auth/session 308 12.553 ms - 53
GET /_next/static/chunks/pages/users-e2d3e3c41c28a4e9.js 200 18.085 ms - -
GET /api/auth/session/ 200 13.205 ms - -
GET /_next/static/chunks/pages/auth/login-1e7b8e8f1c34f8e0.js 200 19.322 ms - -
GET /_next/static/chunks/pages/auth/register-03a6e48327622593.js 200 17.819 ms - -
GET /_next/static/chunks/471-9248df46b015bcb0.js 200 25.547 ms - -
GET /_next/data/-X9bz3RiG2e6mze2eopzx/auth/login.json 200 40.258 ms - -
GET /api/auth/providers 308 10.130 ms - 55
GET /api/auth/providers/ 200 18.121 ms - -
GET /api/auth/csrf 308 13.964 ms - 50
GET /api/auth/csrf/ 200 12.674 ms - -
POST /api/auth/callback/credentials? 308 13.018 ms - 66
POST /api/auth/callback/credentials/ 200 81.861 ms - -
GET /api/auth/session/ 304 18.946 ms - -
GET /_next/data/-X9bz3RiG2e6mze2eopzx/index.json 200 38.708 ms - -

Deleting tables ...  // TEARDOWN IS CALLED BUT DB IS NOT AFFECTED
  prisma:client Prisma Client call: +7s
  prisma:client prisma.post.deleteMany(undefined) +0ms
  prisma:client Generated request: +0ms
  prisma:client mutation {
  prisma:client   deleteManyPost {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client Prisma Client call: +1ms
  prisma:client prisma.account.deleteMany(undefined) +0ms
  prisma:client Generated request: +1ms
  prisma:client mutation {
  prisma:client   deleteManyAccount {
  prisma:client     count
  prisma:client   }
  prisma:client }
 ...

  prisma:client  +0ms
  prisma:client Prisma Client call: +0ms
  prisma:client prisma.user.deleteMany(undefined) +0ms
  prisma:client Generated request: +0ms
  prisma:client mutation {
  prisma:client   deleteManyUser {
  prisma:client     count
  prisma:client   }
  prisma:client }
  prisma:client  +0ms
  prisma:client:libraryEngine requestBatch +7s
Tables deleted.
GET /__cypress/runner/fonts/mulish-latin-700-normal.woff2 200 1.697 ms - 31176

[nemanjam]

I see where is the mistake, I passed wrong .env file and connected to dev database instead of test database.

It can be seen npb-db-dev in the log above:

Start seeding ...
DATABASE_URL: postgresql://postgres_user:password@localhost:5432/npb-db-dev?schema=public
Deleting avatars ... 

I will close this discussion.