A simple node program to create a bunch of tables inside of a questdb server running locally

quest_make_tables.js

const request = require('request');



function makeANewTable(idx, limit) {

	const urlEncodedQuery = encodeURIComponent(`CREATE TABLE IF NOT EXISTS trades${idx} (ts TIMESTAMP, date DATE, name STRING, value INT) timestamp(ts);`);

	const wholeUrl = 'http://localhost:9000/exec?query=' + urlEncodedQuery;

	request.get(wholeUrl)
		.on('response', function(response, a, data) {
			console.log(response.statusCode);
			const shouldMakeAnotherRequest = idx < limit
			if(shouldMakeAnotherRequest) {
				makeANewTable(idx + 1, limit);
			}
		})
		.on('error', function(response) {
			console.log(response);
		});
}

makeANewTable(6000, 9000);