Cannot Write into SQLite3 during unit test

[aditya-mitra]

Bug report

Describe the bug

I was following the strapi testing documentation when this arose.

I was trying to test a strapi endpoint and inserting user data into the db when it can gave an error that data could not be inserted into read-only db

I have just copied this test - https://strapi.io/documentation/developer-docs/latest/guides/unit-testing.html#testing-auth-endpoint-controller

const userData = {
  username: 'tester',
  email: 'tester@strapi.com',
  provider: 'local',
  password: '1234abc',
  confirmed: true,
  blocked: null,
};

beforeEach(async () => {
			await strapi.plugins['users-permissions'].services.user.add({
				...userData,
			});
		});

The error was this

"before each" hook for "blank request does not give 2xx status code":
     insert into `users-permissions_user` (`blocked`, `confirmed`, `created_at`, `email`, `password`, `provider`, `updated_at`, `username`) values (NULL, true, '2021-01-10 20:15:14.452', 'testing@strapi.app', '$2a$10$o/DBLodkVtamQOK.4HHm3Opi6lkB33EVOzswaVOsipEfwtByNaOGW', 'local', '2021-01-10 20:15:14.452', 'tester') - SQLITE_READONLY: attempt to write a readonly database              
  Error: SQLITE_READONLY: attempt to write a readonly database

Steps to reproduce the behavior

Follow the testing documentation - https://strapi.io/documentation/developer-docs/latest/guides/unit-testing.html

Expected behavior

Data to be inserted in the db.

Screenshots

Code snippets

My test config for the db is this:

{
		defaultConnection: 'default',
		connections: {
			default: {
				connector: 'bookshelf',
				settings: {
					client: 'postgres',
					database: dbConfig.database,
					host: dbConfig.host,
					port: dbConfig.port,
					username: dbConfig.user,
					password: dbConfig.password,
					ssl: {
						rejectUnauthorized: false,
					},
				},
				options: {
					ssl: true,
				},
			},
		},
	};

System

• Node.js version: 12.20.1
• NPM version: 6.14.10
• Strapi version: 3.4.1
• Database: SQLite3
• Operating system: Ubuntu 20.04

Additional context

Add any other context about the problem here.

[aditya-mitra]

@derrickmehaffy
Does following the unit testing documentation not reproduce the problem?

[derrickmehaffy]

@derrickmehaffy
Does following the unit testing documentation not reproduce the problem?

The pending reproduction status is just a note that I've read through the issue and understand it, but that I need a dedicated amount of time to test and validate.

Sorry it's quite a busy start to the quarter.

[derrickmehaffy]

Moving this to documentation, the unit-test docs are likely just wrong

[meganelacheny]

Hello,

Sorry for not replying earlier, we unfortunately didn't have time to focus on issues before now.

We are no longer maintaining the Strapi v3 documentation, except for security-related issues, as the EOL (end of life) for Strapi v3 is due to end of 2022 (see Security file for more information). The Strapi Documentation team also doesn't actively maintain this guide anymore, but here is a WIP contribution of a community member who is working on improving the Unit Testing guide, it may be helpful to you.

Now, we would suggest v3 users to use the various migration resources below to upgrade projects from Strapi v3 to Strapi v4:

• Code Migration Guide and/or Codemods project
• Data Migration Guide and/or Data Migration Scripts
• Plugin Migration Guide

I will now mark this issue as closed.

Thank you!