22 lines
526 B
JavaScript
22 lines
526 B
JavaScript
const arrayFormatting = require("../util/databaseArrayFormatting.js")
|
|
|
|
module.exports = async (dbConn, id) => {
|
|
const region_nearby = await dbConn.query(
|
|
`SELECT id as place_id,
|
|
region_id as region_id,
|
|
name as place_name,
|
|
lon as lon,
|
|
lat as lat,
|
|
rating as rating,
|
|
vicinity as vicinity,
|
|
photo_reference as photo_reference,
|
|
img_url as img_url
|
|
FROM regions_nearby
|
|
WHERE region_id = ?`,
|
|
[id]
|
|
);
|
|
|
|
return region_nearby;
|
|
};
|
|
|