Database: Schema is missing violation type name

[KatrinaHoffert]

Database: Schema is missing violation type name

[KatrinaHoffert]

Once the schema and SQL generator is updated, the Violation.getViolations method needs to be updated.

[LujieDuan]

There isn't any violation name in the report. But there are detailed explanations on their website for each violation. http://www.health.gov.sk.ca/adx/aspx/adxGetMedia.aspx?DocID=9a42d80d-a17d-4b31-bd7b-4629220e6712&MediaID=3144&Filename=restaurant-inspections-critical-general-items.pdf&l=English

In the report, the violation is in form of: 1 - Refrigeration/Cooling/Thawing (must be 4°C/40°F or lower),
So I use 1 as ID and the rest as description, and no name.

We can use the explanation from the above link, then the DB will be:
ID: 1
Name: Refrigeration/Cooling/Thawing (must be 4°C/40°F or lower)
Description: Potentially hazardous foods and perishable foods must be stored at 4oC/40oF or below.
Hazardous foods must be thawed in a refrigerator or under cold, running water.

Do you want me to change the schema to that?

[KatrinaHoffert]

I see. My bad. You'll have to hard-code the descriptions into the violation
type using the data from the website.
On Feb 8, 2015 1:36 PM, "lujie duan" [email protected] wrote:

There isn't any violation name in the report. But there are detailed
explanations on their website for each violation.
http://www.health.gov.sk.ca/adx/aspx/adxGetMedia.aspx?DocID=9a42d80d-a17d-4b31-bd7b-4629220e6712&MediaID=3144&Filename=restaurant-inspections-critical-general-items.pdf&l=English

In the report, the violation is in form of: 1 -
Refrigeration/Cooling/Thawing (must be 4°C/40°F or lower),
So I use 1 as ID and the rest as description, and no name.

We can use the explanation from the above link, then the DB will be:
ID: 1
Name: Refrigeration/Cooling/Thawing (must be 4°C/40°F or lower)
Description: Potentially hazardous foods and perishable foods must be
stored at 4oC/40oF or below.
Hazardous foods must be thawed in a refrigerator or under cold, running
water.

Do you want me to change the schema to that?

—
Reply to this email directly or view it on GitHub
#23 (comment).

[LujieDuan]

please review the commits

[KatrinaHoffert]

Looks good. Closing as complete.