import 'reflect-metadata';
import { DataSource } from '../../../src/data-source/DataSource';
import {
	closeTestingConnections,
	createTestingConnections,
	reloadTestingDatabases,
} from '../../utils/test-utils';
import { Post } from './entity/Post';

describe('benchmark > bulk-save > case1', () => {
	let connections: DataSource[];
	before(
		async () =>
			(connections = await createTestingConnections({
				__dirname,
				enabledDrivers: ['postgres'],
			})),
	);
	beforeEach(() => reloadTestingDatabases(connections));
	after(() => closeTestingConnections(connections));

	it('testing bulk save of 10.000 objects', () =>
		Promise.all(
			connections.map(async (connection) => {
				const posts: Post[] = [];

				for (let i = 1; i <= 10000; i++) {
					const post = new Post();
					post.title = `Post #${i}`;
					post.text = `Post #${i} text`;
					post.likesCount = i;
					post.commentsCount = i;
					post.watchesCount = i;
					posts.push(post);
				}

				await connection.manager.save(posts);
				// await connection.manager.insert(Post, posts);
			}),
		));

	/**
	 * Before persistence refactoring
	 *
	 *  MySql
	 *
	 * √ testing bulk save of 1000 objects (2686ms)
	 * √ testing bulk save of 1000 objects (1579ms)
	 * √ testing bulk save of 1000 objects (1664ms)
	 * √ testing bulk save of 1000 objects (1426ms)
	 * √ testing bulk save of 1000 objects (1512ms)
	 * √ testing bulk save of 1000 objects (1526ms)
	 * √ testing bulk save of 1000 objects (1605ms)
	 * √ testing bulk save of 1000 objects (1914ms)
	 * √ testing bulk save of 1000 objects (1983ms)
	 * √ testing bulk save of 1000 objects (1500ms)
	 *
	 * Postgres
	 *
	 * √ testing bulk save of 1000 objects (3704ms)
	 * √ testing bulk save of 1000 objects (2080ms)
	 * √ testing bulk save of 1000 objects (2176ms)
	 * √ testing bulk save of 1000 objects (2447ms)
	 * √ testing bulk save of 1000 objects (2259ms)
	 * √ testing bulk save of 1000 objects (2112ms)
	 * √ testing bulk save of 1000 objects (2193ms)
	 * √ testing bulk save of 1000 objects (2211ms)
	 * √ testing bulk save of 1000 objects (2282ms)
	 * √ testing bulk save of 1000 objects (2551ms)
	 *
	 * SqlServer
	 *
	 * √ testing bulk save of 1000 objects (8098ms)
	 * √ testing bulk save of 1000 objects (6534ms)
	 * √ testing bulk save of 1000 objects (5789ms)
	 * √ testing bulk save of 1000 objects (5505ms)
	 * √ testing bulk save of 1000 objects (5813ms)
	 * √ testing bulk save of 1000 objects (5932ms)
	 * √ testing bulk save of 1000 objects (6114ms)
	 * √ testing bulk save of 1000 objects (5960ms)
	 * √ testing bulk save of 1000 objects (5755ms)
	 * √ testing bulk save of 1000 objects (5935ms)
	 */
});