avivijay19 / fampay-backend-assignment Goto Github PK

Connection with MySQL database

Add support for supplying multiple API keys so that if quota is exhausted on one, it automatically uses the next available key.

Server should call the YouTube API continuously in background (async) with some interval (say 10 seconds) for fetching the latest videos for a predefined search query and should store the data of videos
specifically these fields -

• Video title,
• description,
• publishing datetime,
• thumbnails URLs
• and any other fields you require)
  in a database with proper indexes.

Integration of GitHub Action.

A basic search API to search the stored videos using their

• Title
• Description.

Optimise search api, so that it's able to search videos containing partial match for the search query in either video title or description.

Ex 1: A video with title How to make tea? should match for the search query tea how

Make a dashboard to view the stored videos with filters and sorting options (optional)

A GET API which returns the stored video data in a paginated response sorted in descending order of published datetime.

• Create Github Actions docker yaml script
• Create a registry in docker hub