database-postgres.js

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

export class DatabasePostgres { 
    #videos = new Map(); 
    
    async read(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) {
        await sql`delete from videos where id = ${id}`; 
    }
    
}