Monday, 24 April 2017

Node jjs-MySql : Insert query doesn't work

In a connectsql.js file, I have made some queries, in order to insert some datas in a MySQL db :

function upvector()
{
    for (i=0; i<names.length; i++)
    {
        connection.query('INSERT INTO vector (idv, type) VALUES ('+i+','+names[i]+');', function (err, row, fields){

        });
    }

}

function updata()
{
    for (i=0; i<names1.length; i++)
    {

        for (j=0; j<names1[i].length; j++)
        {
            for(k=0; k<names1[i][j].length; k++)
            {
                for(l=0; l<names1[i][j][k].length; l++)
                {

                    connection.query('INSERT INTO data (dept, day, hour, expected, higherexpected, muchhigherexpected, vector_id) VALUES ('+j+","+l+","+k+","+
                        names1[i][j][k][l].expected+","+names1[i][j][k][l].higherExpected+","+names1[i][j][k][l].muchHigherExpected+","+i+');', function (err, row, fields){

                    });
                }
            }
        }
    }
}

I have tried with a console.log, the values inserted in the function are defined.

In a server.js file, i do this :

var db1 = require(__dirname+'/connectsql.js');

db1.upvector();
db1.updata();

But, when I check the database, it is still empty. Why ?



via Simon Girard

No comments:

Post a Comment