CmM3zCzv

1app.post('/test', (req, res) => {
2  const { coinname } = req.body;
3  db.select('*').from('vps')
4    .then(vpsdb => {
5      vpsdb.forEach(node => {
6        if(node.mn1 === coinname){
7          console.log(node.ip)
8        } else if (node.mn1 === null){
9          console.log(node.id)
10          return true;
11          db('vps').where('id', '=', node.id)
12            .returning('*')
13            .update({
14              mn1: coinname
15            })
16            .catch(err => console.log(err))
17        }
18      })
19    })
20    .catch(err => console.log(err))
21})
22	
23[
24    {
25        "id": 1,
26        "ip": "192.168.1.12",
27        "mn1": "xap",
28        "mn2": null,
29        "mn3": null,
30        "mn4": null,
31        "mn5": null,
32        "mn6": null,
33        "mn7": null,
34        "mn8": null,
35        "mn9": null,
36        "mn10": null
37    },
38    {
39        "id": 2,
40        "ip": "192.168.1.12",
41        "mn1": "xap",
42        "mn2": null,
43        "mn3": null,
44        "mn4": null,
45        "mn5": null,
46        "mn6": null,
47        "mn7": null,
48        "mn8": null,
49        "mn9": null,
50        "mn10": null
51    }
52]