Implement Android App Sms Gateway App Continuously Use Getsms Returns Oldest Unsent Messag Q43857287
Implement an Android app (SMS Gateway APP) that continuouslyuse:
– getSMS() – returns the oldest unsent message as a JSON object;e.g., {id: 10, phone:”00000000”, body:”hgdfhghdsgfhjs” }: GET
-sentSMS(msg_id): GET
in order to deliver the SMS messages. Use Postman to simulatethe client that calls sendSMS API to request sending an SMSmessage.
Note: sendSMS(phone, message_body): POST
Here is the 3 APIs sendSMS, getSMS, sentSMS
var express = require(‘express’);
var router = express.Router();
var bodyParser = require(‘body-parser’);
var db = require(‘../db’);
router.use(bodyParser.urlencoded({ extended: true }));
router.use(bodyParser.json());
router.post(“/sendSMS”, function (req, res) {
var sql =”INSERT INTO smsQ(phone, body, sentFlag) values(?,?,0)”;// “INSERT I INTO smsQ (phone, body) VALUES (“+req.phone+”,”+req.body+”)”;
db.mycon.query(sql,[req.body.phone,req.body.body] ,function (err,result) {
if(err){
res.send(err);
}else {
//my code
return res.send(result);
}
});
});
router.get(“/getSMS”, function (req, res) {
var sql =”SELECT body, phone, id FROM smsQ WHERE sentFlag = 0HAVING min(timeStamp)”; //sent == 1
db.mycon.query(sql, function (err, result) {
if(err){
res.send(err);
}else {
//my code
return res.send(result);
}
});
});
router.get(“/sentSMS”, function (req, res) {
var sql =”UPDATE smsQ SET sentFlag = 1 WHERE ID = ?”;
db.mycon.query(sql, [req.query.id],function (err, result) {
if(err){
res.send(err);
}else {
//my code
return res.send(result);
}
});
});
module.exports = router;
//CREATE TABLE smsQ(ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,sentFlag SMALLINT, timeStamp TIMESTAMP, phone VARCHAR(10), bodyTEXT);
//
Expert Answer
Answer to Implement an Android app (SMS Gateway APP) that continuously use: – getSMS() – returns the oldest unsent message as a …
OR