From fc6c6db3dd3864049a1be73953c06cd244138c33 Mon Sep 17 00:00:00 2001 From: Bobby Date: Mon, 25 Apr 2022 14:52:09 -0400 Subject: basic api using postgres and sequelize --- interface/controllers/citizens.controller.js | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 interface/controllers/citizens.controller.js (limited to 'interface/controllers/citizens.controller.js') diff --git a/interface/controllers/citizens.controller.js b/interface/controllers/citizens.controller.js new file mode 100644 index 0000000..fef549d --- /dev/null +++ b/interface/controllers/citizens.controller.js @@ -0,0 +1,17 @@ +const db = require("../models"); +const citizens = db.citizens; +const op = db.Sequelize.Op; + +// Retrieve all citizens from the database. Limit the number of citizens returned to 10. +exports.findXCitizens = (req, res) => { + const limit = 10; + citizens.findAll({ + limit: limit + }).then(citizens => { + res.send(citizens); + }).catch(err => { + res.status(500).send({ + message: err.message || "Some error occurred while retrieving citizens." + }); + }); +} -- cgit v1.2.3