From b861c79f03429313d05ff0a8105b7715aec0ef4d Mon Sep 17 00:00:00 2001 From: jmreddy2106 Date: Tue, 3 May 2022 18:29:31 -0400 Subject: added geography controls --- interface/controllers/state.controller.js | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 interface/controllers/state.controller.js (limited to 'interface/controllers/state.controller.js') diff --git a/interface/controllers/state.controller.js b/interface/controllers/state.controller.js new file mode 100644 index 0000000..1a3a4ed --- /dev/null +++ b/interface/controllers/state.controller.js @@ -0,0 +1,13 @@ +const db = require("../models"); +const state = db.state_master; + +// function to get all states +exports.allStates = () => { + const query = "SELECT * FROM state_master"; + return db.sequelize.query(query, { type: db.sequelize.QueryTypes.SELECT }); + +}; + + + + -- cgit v1.2.3