6 kyu
E-commerce: Categories with Decreased Product Stock
Loading description...
SQL
Databases
This comment has been reported as {{ abuseKindText }}.
Show
This comment has been hidden. You can view it now .
This comment can not be viewed.
- |
- Reply
- Edit
- View Solution
- Expand 1 Reply Expand {{ comments?.length }} replies
- Collapse
- Spoiler
- Remove
- Remove comment & replies
- Report
{{ fetchSolutionsError }}
-
-
Your rendered github-flavored markdown will appear here.
-
Label this discussion...
-
No Label
Keep the comment unlabeled if none of the below applies.
-
Issue
Use the issue label when reporting problems with the kata.
Be sure to explain the problem clearly and include the steps to reproduce. -
Suggestion
Use the suggestion label if you have feedback on how this kata can be improved.
-
Question
Use the question label if you have questions and/or need help solving the kata.
Don't forget to mention the language you're using, and mark as having spoiler if you include your solution.
-
No Label
- Cancel
Commenting is not allowed on this discussion
You cannot view this solution
There is no solution to show
Please sign in or sign up to leave a comment.
This comment has been hidden.
It is not specified whether products can have a "deleted_at" field set in the future. For instance, for obsolete products, that are bound to become inactive. Such products should still be considered active today.
Haven't thought about that. Updated the description, tests and ref. solution to consider such a case. Thanks for the feedback!
Random test doesn't check the boundary conditions well enough. It also often expects only 1 row to be returned.
Fixed test has the same problems too, so these conditions are often untested.
Voilà, and static, as well as random tests, are updated to check the boundary conditions well enough :) Thanks for the feedback and solving the kata!