4lexvav / hit-the-goal Goto Github PK

Methods:

• Post to create new card
• Get list of columns
• Patch for partial update of card: rename, reorder (change position)
• Delete cards

Requirements:

• Columns in a list are sorted by their position specified by User;
• Column name must be unique;
• when a Column is deleted its tasks are moved to the Column to the left of the current.
• User must be able to move a Column left or right.
• User must be able to rename a Column

Methods:

• Post to create new tasks
• Get list of all tasks
• Patch for partial update: name, description, status, priority (order) within column, change column
• Delete task

Requirements:

• Task can be created only within a Column;
• User can view Tasks in all Columns of a Project;
• User can update the name and the description of the Task;
• User can delete the Task, with all Comments related to this Task.
• User must be able to move a Task across the Columns (left or right) to change its status.
• User must be able to move a Task within the Column (up and down) to prioritize it.

Tables:

• projects

  • id
  • name (1-500 characters)
  • description Description (0-1000 characters)
  • updated_at
  • created_at

• lists

  • id
  • name (1-255 characters, unique)
  • status
  • project_id
  • updated_at
  • created_at

• tasks

  • id
  • name (1-500 characters)
  • description (0-5000 characters)
  • list_id
  • updated_at
  • created_at

• comments

  • id
  • text (1-5000 characters)
  • task_id
  • updated_at
  • created_at

Requirements:

• use PostgreSQL
• use docker-compose

Methods

• Post to create new project
• Get to view single project
• Get to view list of projects
• Patch for partial update of the project
• Delete project

DoD

• Return list of projects sorted by name
• Create default list when creating new project

Requirements:

• Projects in a list are sorted by name.
• Project must contain at least one column:
  • the first column created by default when a Project created;
  • the last column cannot be deleted.

Methods:

• Post to create a new comment
• Get a list of comments
• Patch to update comment' text
• Delete comment

Requirements:

• Comment can be created only within a Task;
• Comments in a list are sorted by their creation date (from newest to oldest);
• User can view Comments related to a Task;
• User can update the Comment text;
• User can delete the Comment.