Cześć, można tak na przykład:
app.use('/api/public/poi-types', require('./routes/public/poi-types'))
// routing
var express = require('express')
var router = express.Router()
var poiTypesMethods = require('../../methods/poi-types.js')
router.get('/:language', function (req, res) {
poiTypesMethods.getPoiTypes(req, res)
})
module.exports = router
// i metody udostępniające dane:
var db = require('../libraries/loco-data')
var sql = require('../libraries/sql')
module.exports = {
getPoiTypes: function (req, res) {
db.query(sql('select-poi-types'), [req.params.language], function (err, result) {
if (err) return res.status(500).send(err.message)
res.json(result)
})
}
}
gdzie sql('select-poi-types') to:
SELECT types.id, types.category_id, types.file_name, translations.translation AS name
FROM poi_types AS types
INNER JOIN poi_type_translations AS translations
ON types.id = translations.poi_type_id
WHERE translations.language = ?
ORDER BY name;
M.