CREATE TABLE drillingRigs  (
    id INT(50) NOT NULL AUTO_INCREMENT,
    name VARCHAR(150),
    yearOfIssue DATE,
    beginOfWork DATE,
    endOfWork DATE,
    latitude FLOAT,
    longitude FLOAT,
    images VARCHAR(300) COLLATE utf8_general_ci,
    characteristics VARCHAR(300) COLLATE utf8_general_ci,
    PRIMARY KEY (id)
) DEFAULT COLLATE utf8_general_ci DEFAULT CHARSET utf8;


const upDateCharacteristics = (id, data) => {
    const jsonData = JSON.stringify(data);

    return new Promise((resolve, reject) => {
        const connection = mysql.createConnection({
            host: 'localhost',
            user: 'root',
            password: '',
            database: ''
        });

        connection.query(`UPDATE drillingRigs SET id = ?, characteristics = ?`, [id, jsonData], (err, result) => {
            if (err) reject(err);
            resolve(result);
        });
        connection.end();
    });
};

connection.query(`UPDATE drillingRigs SET characteristics = ? WHERE id = ?`, [jsonData, id], (err, result) => {
    if (err) reject(err);
    resolve(result);
});