lilywd / nodejs-assessment Goto Github PK

books. The API should support the following operations: • Create a new book. • Retrieve a specific book by its ID. • Update an existing book. • Delete a book.

such as Sequelize or Mongoose. Design the book schema with the following properties: • ID (auto-generated) • Title (string) • Author (string) • Genre (string) • Published Date (date) • Description (text)

Implement the following: • User registration endpoint (/api/register) to create a new user. • User login endpoint (/api/login) to authenticate and generate a JWT. • Protect the book management endpoints by verifying the JWT.

script that performs the following tasks efficiently: a) Reads the dataset from a file. b) Filters the books based on a specific genre. c) Sorts the filtered books by the published date in descending order. d) Writes the sorted books to a new file in JSON format. The script should be optimized to handle large datasets efficiently and minimize memory usage.

Assume you have an existing PostgreSQL database with a table named "orders" that has the following columns: • id (integer), • customer_id (integer), • order_date (date), • total_amount (decimal). Optimize the following SQL query to improve its performance: sqlCopy code SELECT * FROM orders WHERE customer_id = 123 ORDER BY order_date DESC;

Imagine you are building a microservices architecture for an e-commerce platform. The system should handle the following functionalities: • User management (registration, authentication, and authorization). Product catalog (creation, retrieval, and updating product information). • Shopping cart management (add/remove items, calculate total price). • Order processing (place an order, payment integration). • Describe the high-level architecture of the system, including the communication between microservices, data storage, and any other components needed.

Given a Node.js application that is failing to start and throws an error, analyze the provided error message, review the codebase, and identify and fix the issue causing the error.