Can you please give some suggestion for the following query as well:
My SQL code is:
let userData = req.body;
connection.query(`INSERT INTO register (name,fname,voterid,gender,address,pincode,city,state,pic,dob,password) VALUES ('${userData.name}','${userData.fatherName}','${userData.voterId}','${userData.gender}','${userData.address}','${userData.pincode}','${userData.city}','${userData.state}','${file.originalname}','${userData.dob}','${md5(userData.password)}')`,(err,res0)=>{
if(err){
console.log(err);
res.send({
swal : {
type : "error",
text : "registration failed"
}
})
}else{
res.send({
swal : {
type : "success",
text : "registration successful"
}
})
}
Now the code which I written in neo4j is:
let fatherName = req.body.fatherName;
let id = req.body.voterId;
let name = req.body.name;
let address = req.body.address;
let city = req.body.city;
let state = req.body.state;
let dob = req.body.dob;
let gender = req.body.gender;
let pincode = req.body.pincode;
let password = md5(req.body.password);
let pic = file.originalname;
session.run(` CREATE (n:voters { id:{idParam}, name:{nameParam}, fname:{fnameParam}, gender:{genderParam}, address:{addressParam}, pincode:{pincodeParam}, city:{cityParam}, state:{stateParam}, pic:{picParam}, dob:{dobParam},password:{passwordParam}}) RETURN n.id`,{idParam:id, nameParam: name, fnameParam: fatherName, genderParam: gender, addressParam:address, pincodeParam:pincode, cityParam: city, stateParam:state, picParam:pic, dobParam: dob, passwordParam:password})
.then(function(result){
res.send({
swal : {
type : "error",
text : "registration failed"
}
})
})
.catch(function(err){
console.log(err)
});
But it is giving me the following error:
{ Neo4jError: Unable to pack the given value: function driver(url, authToken) {
var config = arguments.length > 2 && arguments[2] !== undefined ? arguments[2] : {};
(0, _util.assertString)(url, 'Bolt URL');
var parsedUrl = _urlUtil["default"].parseDatabaseUrl(url);
if (['bolt+routing', 'neo4j'].indexOf(parsedUrl.scheme) !== -1) {
return new _routingDriver["default"](_serverAddress["default"].fromUrl(parsedUrl.hostAndPort), parsedUrl.query, USER_AGENT, authToken, config);
} else if (parsedUrl.scheme === 'bolt') {
if (!(0, _util.isEmptyObjectOrNull)(parsedUrl.query)) {
throw new Error("Parameters are not supported with scheme 'bolt'. Given URL: '".concat(url, "'"));
}
return new _driver.Driver(_serverAddress["default"].fromUrl(parsedUrl.hostAndPort), USER_AGENT, authToken, config);
} else if (parsedUrl.scheme === 'http' || parsedUrl.scheme === 'https') {
return new _httpDriver["default"](parsedUrl, USER_AGENT, authToken, config);
} else {
throw new Error("Unknown scheme: ".concat(parsedUrl.scheme));
}
}
at captureStacktrace (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\neo4j-driver\lib\v1\result.js:199:15)
at new Result (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\neo4j-driver\lib\v1\result.js:65:19)
at Session._run (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\neo4j-driver\lib\v1\session.js:152:14)
at Session.run (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\neo4j-driver\lib\v1\session.js:130:19)
at router.post (C:\Users\NISHU\Angular\voters - Copy\backend\services.js:52:17)
at Layer.handle [as handle_request] (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\express\lib\router\layer.js:95:5)
at next (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\express\lib\router\route.js:137:13)
at Immediate._onImmediate (C:\Users\NISHU\Angular\voters - Copy\backend\node_modules\multer\lib\make-middleware.js:53:37)
at runCallback (timers.js:706:11)
at tryOnImmediate (timers.js:676:5) code: 'ProtocolError', name: 'Neo4jError' }
So Please Help!!!