sqcTm5Gd

1axios
2  .post('/add', contactData)
3  .then(res =>
4    console.log(`Contact ${contactData.name} added successfully`)
5  )
6  .catch(err => console.log('Error encountered: ', err));
7	
8const express = require('express');
9const sqlite3 = require('sqlite3');
10const path = require('path');
11const cors = require('cors');
12
13const dbName = 'my.db';
14const tableName = 'Contacts';
15const dbPath = path.resolve(__dirname, dbName);
16
17const app = express();
18
19const port = process.env.PORT || 5000;
20
21app.use(cors());
22
23app.listen(port, () => console.log(`Server running on port ${port}`));
24
25app.get('/all', (req, res) => {
26  let db = new sqlite3.Database(dbPath);
27
28  let sql = `SELECT number FROM ${tableName}`;
29
30  db.run(
31    `CREATE TABLE IF NOT EXISTS ${tableName}(name text, number text, address text)`
32  );
33
34  db.all(sql, [], (err, rows) => {
35    if (err) {
36      return res.status(500).json(err);
37    } else {
38      return res.json(rows);
39    }
40  });
41});
42
43app.post('/add', (req, res) => {
44  let db = new sqlite3.Database(dbPath);
45
46  db.run(
47    `INSERT INTO ${tableName}(name, number, address) VALUES(${req.name},${
48      req.number
49    },${req.address})`,
50    [],
51    err => {
52      if (err) return res.status(500).json(err);
53    }
54  );
55
56  return res.json({ msg: 'success' });
57});