From 45ed5c37a3ec4155616334b7e09a2c1679b3fb52 Mon Sep 17 00:00:00 2001 From: Bobby Date: Tue, 3 May 2022 15:25:08 -0400 Subject: working edit --- interface/controllers/citizens.controller.js | 26 ++++++++++---------------- 1 file changed, 10 insertions(+), 16 deletions(-) (limited to 'interface/controllers/citizens.controller.js') diff --git a/interface/controllers/citizens.controller.js b/interface/controllers/citizens.controller.js index 9eaf153..ee9355b 100644 --- a/interface/controllers/citizens.controller.js +++ b/interface/controllers/citizens.controller.js @@ -1,35 +1,29 @@ -const req = require("express/lib/request"); const db = require("../models"); const citizens = db.citizens; -const village_master = db.village_master; const {QueryTypes} = require('sequelize'); const { sequelize } = require("../models"); // Retrieve all citizens from the database. Limit the number of citizens returned to 10. exports.findXCitizens = () => { - /** - * select c.first_name, c.last_name, c.address, c.mobile_num, c.dob, c.gender, c.marital_status, v.village_name - from citizens c - join village_master v - on c.village_id = v.village_id - limit 10 - */ - const limit = 10; - // Raw query in Sequelize - query = `select c.citizen_id, c.first_name, c.last_name, c.address, c.mobile_num, c.dob, c.gender, c.marital_status, c.village_id, v.village_name from citizens c join village_master v on c.village_id = v.village_id - limit 10` + order by citizen_id limit 10;`; return sequelize.query(query, { type: QueryTypes.SELECT }) }; - - - +exports.editCitizen = (citizen_id, address, mobile_num, dob, marital_status) => { + return citizens.update({ + address, mobile_num, dob, marital_status + }, { + where: { + citizen_id + } + }); +}; // Get total number of male and female citizens exports.findGenderDistribution = () => { -- cgit v1.2.3