Function getTestForRepositoryWithDatabase

src/Repositories/CrudRepository.test.ts:126–488

(DatabaseClass: any, config: any, primaryKeyAttributes: SqlQuery)

}, sql`PRIMARY KEY AUTOINCREMENT`));

function getTestForRepositoryWithDatabase(DatabaseClass: any, config: any, primaryKeyAttributes: SqlQuery) {
	return () => {
		let db: DatabaseInterface;
		let repository: TestRepository;
		let scopedRepository: TestScopedRepository;
		let relatedTestRepository: RelatedTestRepository;
		let repositoryWithDuplicates: TestWithDuplicatesRepository;

		beforeEach(async () => {
			db = new DatabaseClass(config);

			await db.query(sql`
				CREATE TEMPORARY TABLE ${new QueryIdentifier('Test')} (
					${new QueryIdentifier('id')} INTEGER NOT NULL ${primaryKeyAttributes},
					${new QueryIdentifier('text')} TEXT NOT NULL,
					${new QueryIdentifier('number')} INTEGER NOT NULL,
					${new QueryIdentifier('date')} DATE NOT NULL
				);
			`);
			await db.query(sql`
				CREATE TEMPORARY TABLE ${new QueryIdentifier('RelatedTest')} (
					${new QueryIdentifier('id')} INTEGER NOT NULL ${primaryKeyAttributes},
					${new QueryIdentifier('testId')} INTEGER NOT NULL
				);
			`);
			await db.query(sql`
				CREATE TEMPORARY TABLE ${new QueryIdentifier('ManyManyTest')} (
					${new QueryIdentifier('testId')} INTEGER NOT NULL,
					${new QueryIdentifier('relatedTestId')} INTEGER NOT NULL
				);
			`);
			await db.query(sql`
				CREATE TEMPORARY TABLE ${new QueryIdentifier('TestWithDuplicates')} (
					${new QueryIdentifier('id')} INTEGER NOT NULL,
					${new QueryIdentifier('text')} TEXT NOT NULL,
					${new QueryIdentifier('number')} INTEGER NOT NULL,
					${new QueryIdentifier('date')} DATE NOT NULL
				);
			`);

			repository = new TestRepository(db);
			scopedRepository = new TestScopedRepository(db);
			relatedTestRepository = new RelatedTestRepository(db);
			repositoryWithDuplicates = new TestWithDuplicatesRepository(db);
		});
		afterEach(async () => {
			await db.query(sql`DROP TABLE ${new QueryIdentifier('Test')};`);
			await db.query(sql`DROP TABLE ${new QueryIdentifier('RelatedTest')};`);
			await db.query(sql`DROP TABLE ${new QueryIdentifier('ManyManyTest')};`);
			await db.query(sql`DROP TABLE ${new QueryIdentifier('TestWithDuplicates')};`);
			await db.disconnect();
		});

		it('get - normal case', async () => {
			await db.query(sql`
				INSERT INTO ${new QueryIdentifier('Test')} VALUES
					(1, 'test 1', 11, DATE('2020-01-01')),
					(2, 'test 2', 12, DATE('2020-01-03'));