league.service.js

const model = require("../../db/models");
const Sequelize = require("sequelize")

 
 const getLeaguesByRadiusRaw = async(request) => {
    return await model.sequelize.query(
        `SELECT  name, location, price   
        FROM "Leagues" 
        WHERE ST_DWithin(location, ST_MakePoint(${request.body.longitude},${request.body.latitude})::geography, ${request.body.radius * 1609.344})
        AND price BETWEEN 0 AND ${request.body.budget}
        ORDER BY price ASC`, {
            type: model.sequelize.QueryTypes.SELECT
        }
    )
 };




 module.exports = {
     getLeaguesByRadiusRaw
 }