databasePostgres.js

import { randomUUID } from "node:crypto"
import { sql } from "./db.js"

export class DatabasePostgres {
    #videos = new Map()

    async list(search) {
        let videos

        if (search) {
            videos = await sql`select * from videos where title ilike ${'%' + search + '%'}`
        } else {
            videos = await sql`select * from videos`
        }

        return videos
    }

    async listByID(searchID) {
        let videos
        
        if (searchID) {
            videos = await sql`select * from videos where id ilike ${'%' + searchID + '%'}`
        } else {
            videos = await sql`select * from videos`
        }
        
        return videos
    }

    async create(video) {
       const videoID = randomUUID()

       const { title, description, duration } = video

       await sql `insert into videos (id, title, description, duration) values (${videoID}, ${title}, ${description}, ${duration})`

    }

    async update(id, video) {
        const { title, description, duration } = video

        await sql `update videos set title = ${title}, description = ${description}, duration = ${duration} where id = ${id}`

    }

    async delete(id) {
        await sql `delete from videos where id = ${id}`
    }
}