app.js

const oracledb = require('oracledb');

async function runScript() {
	const tableName = "TESTING_NODEJS";
	let connection;
	async function prepareData() {

		const statement = `create table ${tableName} AS 
		WITH users AS (
			SELECT 'Roland' AS first_name, 'Higgins' AS last_name, 29 AS age FROM dual
			UNION
			SELECT 'Chelsea', 'Watson', 20 FROM dual
			UNION
			SELECT 'Amber', 'Ryan', 27 FROM dual
			UNION
			SELECT 'Michael', 'Jones', 24 FROM dual
			UNION
			SELECT 'Tiana', 'Jones', 28 FROM dual
			UNION
			SELECT 'Violet', 'Sullivan', 20 FROM dual
			UNION
			SELECT 'Dexter', 'Wilson', 29 FROM dual
			UNION
			SELECT 'Sophia', 'Carter', 27 FROM dual
			UNION
			SELECT 'Sienna', 'Johnson', 29 FROM dual
			UNION
			SELECT 'Dexter', 'Carroll', 19 FROM dual
			UNION
			SELECT 'Sarah', 'Casey', 20 FROM dual
			UNION
			SELECT 'Sarah', 'Harris', 20 FROM dual
			UNION
			SELECT 'Amelia', 'Williams', 27 FROM dual
			UNION
			SELECT 'Michael', 'Johnston', 27 FROM dual
			UNION
			SELECT 'Vincent', 'Campbell', 22 FROM dual
			UNION
			SELECT 'David','Morrison', 23 FROM dual
			UNION
			SELECT 'Sydney', 'Barrett', 20 FROM dual
			UNION
			SELECT 'Lucy', 'Richards', 19 FROM dual
			UNION
			SELECT 'Maximilian', 'Bailey', 28 FROM dual
			UNION
			SELECT 'Elian', 'Parker', 24 FROM dual
			UNION
			SELECT 'Olivia', 'Richards', 23 FROM dual
			UNION
			SELECT 'Paul', 'Nelson', 21 FROM dual
			UNION
			SELECT 'Richard', 'Henderson', 23 FROM dual
			UNION
			SELECT 'Sabrina', 'Montgomery', 28 FROM dual
			UNION
			SELECT 'Jessica', 'Turner', 30 FROM dual
			UNION
			SELECT 'Paige', 'Rogers', 25 FROM dual
			UNION
			SELECT 'Walter', 'Bennett', 18 FROM dual
			UNION
			SELECT 'Abraham', 'Clark', 18 FROM dual
			UNION
			SELECT 'Edwin', 'Myers', 30 FROM dual
			UNION
			SELECT 'Maddie', 'Rogers', 28 FROM dual
			UNION
			SELECT 'Daniel', 'Thomas', 21 FROM dual
			UNION
			SELECT 'Chester', 'Brooks', 29 FROM dual
			UNION
			SELECT 'Dale', 'Williams', 18 FROM dual
			UNION
			SELECT 'Aiden', 'Alexander', 18 FROM dual
			UNION
			SELECT 'Eddy', 'Martin', 22 FROM dual
			UNION
			SELECT 'Dainton', 'Roberts', 28 FROM dual
			UNION
			SELECT 'Michael', 'Warren', 20 FROM dual
			UNION
			SELECT 'Rosie', 'Jones', 21 FROM dual
			UNION
			SELECT 'Chester', 'Johnson', 25 FROM dual
			UNION
			SELECT 'Paul', 'Henderson', 18 FROM dual
			UNION
			SELECT 'Frederick', 'Nelson', 23 FROM dual
			UNION
			SELECT 'Adele', 'Carroll', 27 FROM dual
			UNION
			SELECT 'Agata', 'Perkins', 21 FROM dual
			UNION
			SELECT 'Thomas', 'Harris', 20 FROM dual
			UNION
			SELECT 'Amber', 'Reed', 24 FROM dual
			UNION
			SELECT 'Harold', 'Edwards', 25 FROM dual
			UNION
			SELECT 'Leonardo', 'Henderson', 25 FROM dual
			UNION
			SELECT 'Lucas', 'Thomas', 26 FROM dual
			UNION
			SELECT 'Paige', 'Davis', 27 FROM dual
			UNION
			SELECT 'Lucia', 'Douglas', 23 FROM dual
			UNION
			SELECT 'Dale', 'Sullivan', 19 FROM dual
			UNION
			SELECT 'Agata', 'Andrews', 20 FROM dual
			UNION
			SELECT 'Lana', 'Cole', 26 FROM dual
			UNION
			SELECT 'Aiden', 'Grant', 25 FROM dual
			UNION
			SELECT 'Natalie', 'West', 30 FROM dual
			UNION
			SELECT 'Derek', 'Grant', 26 FROM dual
			UNION
			SELECT 'Arthur', 'Watson', 19 FROM dual
			UNION
			SELECT 'Lucy', 'Wilson', 18 FROM dual
			UNION
			SELECT 'Adelaide', 'Dixon', 26 FROM dual
			UNION
			SELECT 'Frederick', 'Baker', 19 FROM dual
			UNION
			SELECT 'Vanessa', 'Kelly', 29 FROM dual
			UNION
			SELECT 'Sarah', 'Rogers', 30 FROM dual
			UNION
			SELECT 'Adison', 'Gibson', 30 FROM dual
			UNION
			SELECT 'Lydia', 'Kelly', 29 FROM dual
			UNION
			SELECT 'Henry', 'Russell', 30 FROM dual
			UNION
			SELECT 'William', 'Bailey', 22 FROM dual
			UNION
			SELECT 'Cherry', 'Martin', 27 FROM dual
			UNION
			SELECT 'Rebecca', 'Hill', 20 FROM dual
			UNION
			SELECT 'Chelsea', 'Taylor', 25 FROM dual
			UNION
			SELECT 'Daryl', 'Richardson', 21 FROM dual
			UNION
			SELECT 'Bruce', 'Warren', 21 FROM dual
			UNION
			SELECT 'Edward', 'Chapman', 18 FROM dual
			UNION
			SELECT 'Sydney', 'Cooper', 18 FROM dual
			UNION
			SELECT 'Aldus', 'Thompson', 24 FROM dual
			UNION
			SELECT 'Amber', 'Chapman', 20 FROM dual
			UNION
			SELECT 'Fiona', 'Davis', 24 FROM dual
			UNION
			SELECT 'Isabella', 'Morgan', 19 FROM dual
			UNION
			SELECT 'Aida', 'Taylor', 28 FROM dual
			UNION
			SELECT 'Isabella', 'Casey', 20 FROM dual
			UNION
			SELECT 'Garry', 'Robinson', 28 FROM dual
			UNION
			SELECT 'James', 'Morgan', 20 FROM dual
			UNION
			SELECT 'Paul', 'Jones', 21 FROM dual
			UNION
			SELECT 'Lydia', 'Johnston', 30 FROM dual
			UNION
			SELECT 'Ryan', 'Cameron', 29 FROM dual
			UNION
			SELECT 'John', 'Anderson', 28 FROM dual
			UNION
			SELECT 'Savana', 'Wright', 30 FROM dual
			UNION
			SELECT 'Edward', 'Spencer', 24 FROM dual
			UNION
			SELECT 'Dexter', 'Ross', 30 FROM dual
			UNION
			SELECT 'Brooke', 'Johnson', 18 FROM dual
			UNION
			SELECT 'Rubie', 'Edwards', 19 FROM dual
			UNION
			SELECT 'Adison', 'Smith', 19 FROM dual
			UNION
			SELECT 'Cadie', 'Nelson', 29 FROM dual
			UNION
			SELECT 'Tyler', 'Parker', 19 FROM dual
			UNION
			SELECT 'Alina', 'Barnes', 18 FROM dual
			UNION
			SELECT 'Belinda', 'Harper', 28 FROM dual
			UNION
			SELECT 'Natalie', 'Foster', 18 FROM dual
			UNION
			SELECT 'Darcy', 'Douglas', 22 FROM dual
			UNION
			SELECT 'Frederick', 'West', 24 FROM dual
			UNION
			SELECT 'Joyce', 'Morgan', 20 FROM dual
			UNION
			SELECT 'Catherine', 'Farrell', 30 FROM dual
		)
		SELECT * from users`;

		try {
			try {
				await connection.execute(`DROP table ${tableName}`);
			}
			catch (error) {
				console.log(error);
			}
			await connection.execute(statement);
			console.log(`Finished creating ${tableName} table`);
		} catch (err) {
			console.error(err);
		}
	}

	const dbConfig = {
		user: process.env.DB_USER || process.argv[2],
		password: process.env.DB_PASS || process.argv[3],
		connectString: process.env.DB_CONNECTION || process.argv[4]
	}

	if(!connection) {
		connection = await oracledb.getConnection(dbConfig);
	}

	try {
		await prepareData();
		const users = [
			{
				lastName: "Jones",
				age: 21
			}, {
				lastName: "Johnson",
				age: 27
			}, {
				lastName: "Casey",
				age: 21
			}, {
				lastName: "Douglas",
				age: 21
			}, {
				lastName: "Thompson",
				age: 22
			}, {
				lastName: "Anderson",
				age: 28
			}, {
				lastName: "Russell",
				age: 28
			}, {
				lastName: "Ryan",
				age: 27
			}, {
				lastName: "Sullivan",
				age: 20
			}, {
				lastName: "Morgan",
				age: 19
			}, {
				lastName: "Henderson",
				age: 23
			}, {
				lastName: "Warren",
				age: 29
			}, {
				lastName: "Grant",
				age: 29
			}, {
				lastName: "Morgan",
				age: 29
			}, {
				lastName: "Rogers",
				age: 30
			}, {
				lastName: "Parker",
				age: 24
			}, {
				lastName: "Chapman",
				age: 20
			}, {
				lastName: "Nelson",
				age: 29
			}, {
				lastName: "Henderson",
				age: 18
			}, {
				lastName: "Davis",
				age: 24
			}
		];

		const query = `WITH users /* testing 100 */ AS (
			${Array(30).join(0).split(0).map((item, i) =>
			`${i == 0 ? `` : ` UNION `} SELECT :age${i} AS age, :last_name${i} AS last_name FROM dual`).join('')}
			)
		SELECT * from ${tableName}`;
		async function runQuery(users) {
			try {
				const binds = [];
				users.forEach(user => {
					binds.push(user.age);
					binds.push(user.lastName);
				});
				Array(30 - users.length).join(0).split(0).forEach((item, i) => {
					binds.push(-9);
					binds.push('DUMMY');
				});

				console.log("Running query");
				const result = await connection.execute(query, binds, {outFormat: oracledb.OBJECT});
				console.log(result);
			} catch (error) {
				console.error(error);
			}	
		}

		for (let j = 0; j < 100; j++) {
			setTimeout(async() => await users.forEach(async(user) => {
				const randomNumber = Math.floor(Math.random() * 19) + 1;

				await runQuery(users.sort(() => randomNumber).slice(0, randomNumber));
			}), j * 10000);
		}
		

	} catch (err) {
		console.error(err);
	}

}
runScript();