database-postgres.js

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

export class DatabasePostgres {
   

    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 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) {
        //  const {title, description, duration } = video

        await sql`DELETE FROM videos WHERE id = ${id}`
    }
}