blob: 0a488d40470744f21f2ebc60ed572a8aad614936 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
const db = require("../models");
const village = db.village_master;
exports.allVillages = () => {
return village.findAll({
attributes: ['village_id', 'village_name']
})
};
exports.allVillagesByMandalId = (mandal_id) => {
const query =`SELECT * FROM village_master WHERE mandal_id = ${mandal_id}`;
return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT });
};
|
