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