import { pool } from "../modules/database.js"

async function getMediaInDatabase(mediaId) {
    try {
        const query = "SELECT * FROM asset WHERE id = $1"
        const values = [mediaId]
        const response = await pool.query(query, values)
        return response.rows
    } catch (error) {
        console.error("Erreur dans getMediaInDatabase:", error)
        throw error
    }
}

async function updateMediaPathInDatabase(mediaId, newPath) {
    try {
        const query = "UPDATE asset SET \"originalPath\" = $1 WHERE id = $2"
        const values = [newPath, mediaId]
        const response = await pool.query(query, values)
        return response.rows
    } catch (error) {
        console.error("Erreur dans updateMediaPathInDatabase:", error)
        throw error
    }
}


export default {
    getMediaInDatabase,
    updateMediaPathInDatabase
}