export const SQL_USER_ID_QUERY = (`
    SELECT id
    FROM users
    WHERE unique_id=?
`);

export const SQL_ROOM_EXISTS_QUERY = (`
    SELECT room_id
    FROM streams
    WHERE room_id=?
`);

export const SQL_IMAGE_BADGE_ID_QUERY = (`
    SELECT id
    FROM image_badges
    WHERE url=?
`);

export const SQL_TEXT_BADGE_ID_QUERY = (`
    SELECT id
    FROM text_badges
    WHERE label=?
`);

export const SQL_INSERT_SNAPSHOT_IMAGE_BADGE_QUERY = (`
    INSERT INTO
    snapshot_image_badges (user_snapshot_id, image_badge_id)
    VALUES
    (?, ?)
`);

export const SQL_INSERT_SNAPSHOT_TEXT_BADGE_QUERY = (`
    INSERT INTO
    snapshot_text_badges (user_snapshot_id, text_badge_id)
    VALUES
    (?, ?)
`);

export const SQL_INSERT_TEXT_BADGE_QUERY = (`
    INSERT INTO text_badges (label, name)
    OUTPUT INSERTED.id
    VALUES (?, ?)
`);

export const SQL_INSERT_IMAGE_BADGE_QUERY = (`
    INSERT INTO image_badges (url, label, name)
    OUTPUT INSERTED.id
    VALUES (?, ?, ?)
`);


export const SQL_INSERT_USER_QUERY = (`
    INSERT INTO users (unique_id)
    OUTPUT INSERTED.id
    VALUES (?)
`);


export const SQL_INSERT_MIC_BATTLE_QUERY = (`
    INSERT INTO mic_battle (room_id, status)
    OUTPUT INSERTED.id
    VALUES (?, ?)
`);

export const SQL_INSERT_ARMY_SNAPSHOT_QUERY = (`
    INSERT INTO army_snapshots (mic_battle_id, host_user_id, points)
    OUTPUT INSERTED.id
    VALUES (?, ?, ?)
`);