blob: 43842fef3c2b74b3531424b19f108774139b7662 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
const db = require("../models");
const mandal = db.mandal_master;
exports.allMandals = () => {
return mandal.findAll({
attributes: ['mandal_id', 'mandal_name']
})
};
exports.allMandalsByDistrictId = (district_id) => {
const query =`SELECT * FROM mandal_master WHERE district_id = ${district_id}`;
return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });
};
|
