Delete from json file in node

Question

I got caught on how to delete an element from my json file in node.

Im displaying all my elements from my json file that i have made like this

var json = require('./test.json');

  app.get('/courses', function(req, res) {
    res.render('courses', {
        title: "Hello",
        name: "Fredrik",
        js: json
    });
});

This below is my test.json file

[
{
"id":1,"courseId":"DT162G","courseName":"Javascript-baserad webbutveckling","coursePeriod":1
},
{
"id":2,"courseId":"IK060G","courseName":"Projektledning","coursePeriod":1
},
{
"id":3,"courseId":"DT071G","courseName":"Programmering i C#.NET","coursePeriod":2
}
]

And now i want to be able to delete singel elements that i have looped through in my view

I made this so far but im stuck. And how should the path be in my view?

 <td><a href="/courses/:id">Delete</a></td>

app.delete('/courses/:id', function(req, res) {
  if(json.length <= req.params.id) {
    res.statusCode = 404;
    return res.send('Error 404: No quote found');
  }

  json.splice(req.params.id, 1);

});

ram hemasri · Accepted Answer · 2015-09-16 14:05:39Z

3

I hope this helps

var fs = require('fs');

app.delete('/courses/:id', function(req, res) {
var indexOfCouseInJson = json.map(function(item) { return item.id; }).indexOf(req.params.id); //find the index of :id
  if(indexOfCouseInJson === -1) {
    res.statusCode = 404;
    return res.send('Error 404: No quote found');
  }

  var result = json.splice(indexOfCouseInJson,1);
  fs.writeFile(jsonFilePath, JSON.stringify(result), function(err){
   if(err) throw err;
   res.json(true);
 });

});

answered Sep 16, 2015 at 14:05

ram hemasri

1,63611 silver badges14 bronze badges

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

Comments

DevAlien · Accepted Answer · 2015-09-16 13:25:58Z

0

Why having a json FILE with dynamic data inside? You should use a database (mongodb uses json for example) or you have to store it in another way.

But if you still want to save the data in your file, what you did is correct but after you removed the element you wanted you have to save the file again, I guess.

answered Sep 16, 2015 at 13:25

DevAlien

2,48617 silver badges18 bronze badges

2 Comments

Fredrik_Swe Over a year ago

Hi Im doing a exercise for school and this is the start of the course. So now we are just supposed to work with a json file and the next course it is with Mongo.

DevAlien Over a year ago

Ah ok, then you have to save the file again after that, if you want to read it again.

rweye · Accepted Answer · 2015-09-16 17:27:22Z

0

To add on ram's answer, You can use the method readJsonSync as var YourFile = Fs.readJsonSync('file.json'); and now do delete YourFile.element; reset your elements as YourFile.id = 23; and in the end do a Fs.writeJsonSync('file.json');

answered Sep 16, 2015 at 17:27

rweye

831 silver badge6 bronze badges

Collectives™ on Stack Overflow

Delete from json file in node

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related