New model for storing project types in the database

[vikasrohit]

Till date we are maintaining the project types (aka categories) in JSON mapping in each project we need it. Now we are moving it to the database to make all services independent of keeping them in sync for this JSON mapping.

Requirements:

1. New model ProjectType backed by table project_types with only two fields key and displayName
2. Simple CRUD operations on top of it
   1. GET /v4/projectTypes to list all available project types (no filtering and no sorting)
   2. GET /v4/projectTypes/{key} to fetch specific project type details
   3. POST /v4/projectTypes to create new project type
   4. PATCH /v4/projectTypes/{key} to update existing project type
   5. DELETE /v4/projectTypes/{key} to delete existing project type
3. Only users with administrator or Connect Admin roles should be able to allow create new project type or update/delete existing one.

[ngoctay]

@vikasrohit @coderReview

key will be something like app_dev, generic, visual_prototype, visual_design, website, app, quality_assurance, or chatbot. Right?

[coderReview]

@ngoctay I think key can be any string. I don't we have to limit it.

[vikasrohit]

Yes, those are currently possible values, but this table is a look up table, so we don't have to limit the values.

…

On May 31, 2018 7:05 AM, "Paulo Vitor Magacho" ***@***.***> wrote: @ngoctay <https://github.com/ngoctay> I think key can be any string. I don't we have to limit it. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#87 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACTj4IQgBg-avilqoSKfT0Uka9nVV392ks5t30jQgaJpZM4UP5ji> .

[ngoctay]

I made PR. Please help to review.

#88

[coderReview]

@ngoctay will look into this. Thanks

[ngoctay]

I still added this endpoint. Please let me know if I need to remove it.

2. GET /v4/projectTypes/{key} to fetch specific project type details

[vikasrohit]

Thanks ngoctay for coming back in 48 hours. Let's keep that endpoint as well. We will take care of it internally. On Jun 1, 2018 1:31 AM, "ngoctay" <notifications@github.com> wrote: I still added this endpoint. Please let me know if I need to remove it. 2. GET /v4/projectTypes/{key} to fetch specific project type details — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#87 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACTj4Bt1J9wOX-7CO_-92yiu96H070M3ks5t4Ew0gaJpZM4UP5ji> .

[vikasrohit]

Closing as it is finished.