blob: 5b215307a97d7b2406ac1809c86f6344574e3ee1 (
plain)
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 });
};
|