interface/controllers/district.controller.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

const db = require("../models");
const district = db.district_master;

exports.allDistricts = () => {
    return district.findAll({
        attributes: ['district_id', 'district_name']
    })
};


exports.allDistrictsByStateId = (state_id) => {
    const query =`SELECT * FROM district_master WHERE state_id = ${state_id}`;
    return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT }).then(districts => {
        if (districts) {
            return districts;
        }
        return null;
    });
};