let d = [];
let db = "sql.0";
let database = "iobroker";

$('ems-esp.0.recordings.*').each(function (id, i) {
    d.push(id);
});
main();

async function main() {
    let id1,query;
    for (let i = 0;i<d.length;i++) {
        
        id1 = await getid(d[i],db);
        if (id1 != 0) {
            console.log(d[i]+ "   " +id1);
            query = "delete from " + database + '.ts_number where id = "' + id1 + '";';
            sendTo(db, "query", query, function (result,reject) {});
            query = "delete from " + database + '.datapoints where id = "' + id1 + '";';
            sendTo(db, "query", query, function (result,reject) {});
        }
    }
}


async function getid(field,db) {
	return new Promise(function(resolve) {
		const query = "select id from " + database + '.datapoints where name = "' + field + '";';
		sendTo(db, "query", query, function (result,reject) {
			if (result.error || result.result[0] == null)
			{
				resolve(0);
			} else {
				resolve(result.result[0].id);
			}
		});
	});
}