aboutsummaryrefslogtreecommitdiff
path: root/interface/controllers/state.controller.js
diff options
context:
space:
mode:
authorjmreddy2106 <[email protected]>2022-05-03 18:29:31 -0400
committerjmreddy2106 <[email protected]>2022-05-03 18:29:31 -0400
commitb861c79f03429313d05ff0a8105b7715aec0ef4d (patch)
treeb0dcfa8cbf2cc5ce3fda7af854c1ce84ff053cf2 /interface/controllers/state.controller.js
parentf807467dca2f08060b0bd4aa6b30ed231bb383b7 (diff)
downloadWelfare-Schemes-DMQL-b861c79f03429313d05ff0a8105b7715aec0ef4d.tar.xz
Welfare-Schemes-DMQL-b861c79f03429313d05ff0a8105b7715aec0ef4d.zip
added geography controls
Diffstat (limited to 'interface/controllers/state.controller.js')
-rw-r--r--interface/controllers/state.controller.js13
1 files changed, 13 insertions, 0 deletions
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 });
+
+};
+
+
+
+