node-mysql-requery's Introduction

ATTENTION! All people, who used the old version of example should update it! I missed some callback things, sorry)))) ATTENTION 2! I've added the unicorn emoji-icon after the word "debug" in the README.md

— Omg why did u do it ohhh???
— Because I need to recall query if it returns an error, arrrrr

node-mysql-requery

The crutch-function to start query again, if mysql returns an error. It's very useful and innovation

Works with node-mysql

Example:

requery('SELECT * FROM `table` WHERE `field` = 0 LIMIT 1', function (results) {
    console.log(results);
});

Function source:

function requery(query, callback) {
    connection.query(query, function (error, results) {
        if (error) {
            setTimeout(function () {
                requery(query, callback);
            }, 1000);
        } else {
            callback(0, results);
        }
    });
}

Function source with the wonderful debug🦄:

function requery(query, callback) {
    connection.query(query, function (error, results) {
        if (error) {
            console.log(error);
            setTimeout(function () {
                console.log(query);
                requery(query, callback);
            }, 1000);
        } else {
            callback(0, results);
        }
    });
}

Recommend Projects