Function getTeams

app/draft/draft.service.js:2–11

()

module.exports = (db) => {
    const getTeams = async () => {
        let teams = await db.any(`SELECT * FROM draft_team ORDER BY location`);

        return teams.map(t => ({
            location: t.location,
            nickname: t.mascot,
            displayName: t.display_name,
            logo: t.logo
        }));
    };

    const getPositions = async () => {
        let positions = await db.any(`SELECT DISTINCT name, abbreviation FROM draft_position ORDER BY name`);