NodeJS insert in mysql from array

Question

I has simple function in nodejs, which add result to MYSQL. But result is coming in array, and i can't correctly add this data to the table.

My functions:

function getPreviousGames() {
    const previousGames = [];
    let gameHash = generateHash(crashHash);

    for (let i = 0; i < 1; i++) {
        const gameResult = crashPointFromHash(gameHash);
        previousGames.push({ gameHash, gameResult });
        gameHash = generateHash(gameHash);

    }
    return previousGames;
}

function verifyCrash() {
    const gameResult = crashPointFromHash(crashHash);
    const previousHundredGames = getPreviousGames();

    for (let i = 0; i < 1; i++) {

        var sql = "INSERT INTO `admin_dev`.`crash_numbers` (`id`, `hash`, `multiplier`, `status`, `created_at`, `updated_at`) VALUES (NULL, '" + previousHundredGames(gameHash) + "', '" + gameResult + "', '0', now(), now());";

        connection.query(sql, function (err, result) {
            if (err) throw err;
            console.log("Success!");

        });
    }

    return { gameResult, previousHundredGames };
}

And i received result:

{
  previousHundredGames: [
    {
      gameHash: 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855',
      gameResult: 2.52
    }
  ]
}

And i can't correcly add this received data to mysql table.

I need add from previousHundredGames value gameHash to hash column, and gameResult value to multiplier column.

How i can correctly made it?

Charlie · Accepted Answer · 2021-04-10 06:44:21Z

1

If you are using a query, it is as simple as building an INSERT query.

//Start the query
let query= 'INSER INTO (hash, gameResult) VALUES ';

//Add multiple rows from the array
for (let aGame of previousGames)    
    query+= `( "${aGame.gameHash}", ${aGame.gameResult}),  `

//Remove the last comma
query= queryBuilder.substring(0, queryBuilder.length - 1)

Here is documentation on inserting multiple rows in a single query.

https://www.mysqltutorial.org/mysql-insert-multiple-rows/

answered Apr 10, 2021 at 6:44

Charlie

24k12 gold badges65 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yrbet Over a year ago

yes, it works! and I has one more question, how I can insert data if this not exist? because when I restart app and it insert data, it make duplicates all information, with new ID in column

Charlie Over a year ago

This question discusses your new scenario: stackoverflow.com/questions/1361340/…

Collectives™ on Stack Overflow

NodeJS insert in mysql from array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related