如何重复执行nodejs mysql查询直到得到想要的结果？

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'database_name'
});

// 执行查询函数
function executeQuery(query, callback) {
  connection.query(query, (error, results) => {
    if (error) {
      callback(error, null);
    } else {
      callback(null, results);
    }
  });
}

// 定义查询条件和期望结果
const query = 'SELECT * FROM table_name WHERE condition';
const expectedResults = 'desired_results';

// 定义重复执行查询的函数
function repeatQuery() {
  executeQuery(query, (error, results) => {
    if (error) {
      console.error(error);
    } else {
      if (results === expectedResults) {
        console.log('Desired results obtained:', results);
        connection.end(); // 关闭数据库连接
      } else {
        console.log('Results not yet obtained. Repeating query...');
        repeatQuery(); // 继续重复执行查询
      }
    }
  });
}

// 开始重复执行查询
repeatQuery();