I have already written code in the nodejs which uses SQL as a database, now I want to use neo4j as a database.
So I am trying to convert the sql INSERT query to CREATE query in the neo4j, but it shows the error so please help.
Code in the SQL:
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"
}
})
}
Code in the neo4j:
const express = require('express');
const router = express.Router();
const neo4j = require('neo4j-driver').v1;
const md5 = require('md5');
const multer = require('multer');
const driver = neo4j.driver('bolt://localhost:7687', neo4j.auth.basic(neo4j, neo4j));
const session = driver.session();
session.run(` CREATE (n:voters { id: '${userData.voterId}', name: '${userData.name}', fname: '${userData.fatherName}', gender: '${userData.gender}', address: '${userData.address}', pincode:'${userData.pincode}', city:'${userData.city}', state:'${userData.state}', pic:'${file.originalname}', dob:'${userData.dob}',password:'${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"
}
})
}
})