mirror of
https://github.com/ngthanhvu/kr-phim.git
synced 2026-08-10 17:47:47 +00:00
ngthanhvu
ad8d577493
- Implemented movie CRUD operations with endpoints for creating, retrieving, updating, and deleting movies. - Added pagination and filtering capabilities for movie retrieval. - Integrated Redis caching for improved performance on movie data retrieval. - Created database schema for movies with necessary fields and types. - Added migration files for initial movie table creation and subsequent updates. - Configured database connection using Drizzle ORM with MySQL. - Established Redis connection utility for caching.
19 lines
509 B
TypeScript
19 lines
509 B
TypeScript
import { movies } from '../../../database/schema'
|
|
import { eq } from 'drizzle-orm'
|
|
|
|
export default defineEventHandler(async (event) => {
|
|
const db = useDb()
|
|
const id = Number(getRouterParam(event, 'id'))
|
|
|
|
if (!id) {
|
|
throw createError({ statusCode: 400, message: 'Thiếu ID phim' })
|
|
}
|
|
|
|
const result = await db.select().from(movies).where(eq(movies.id, id)).limit(1)
|
|
if (!result.length) {
|
|
throw createError({ statusCode: 404, message: 'Không tìm thấy phim' })
|
|
}
|
|
|
|
return result[0]
|
|
})
|