[Platform] [User Notifications][TUS]Subscriptions are created when user performs certain actions

[becevka]

Summary
In order to support User Notifications, we need to subscribe users by default to the Idea of their interest.

Describe the solution you'd like
Subscription Collection should consist of the following fields:

• entityId, numeric id of the business-level entity (IdeaCard)
• entityType, enum value of business-level entity type (IdeaCard only for now)
• user, reference to the user subscribed to Business Entity
• createdDateTime, date when event was created
• active, boolean value, true by default, false when user unsubscribed
• unsubscribeDateTime, date when user deactivated subscription

When user creates idea, subscription for the new idea is automatically created.
When user posts comment to the idea, subscription for that idea is automatically created.
For now, we can disable API endpoints to Subscription.

Acceptance Criteria

Generated by Zenhub AI

• Scenario: Subscription is created when user creates an idea
  • Given a user creates an idea
  • When the idea is created
  • Then a subscription is automatically created for the user with the entityId of the idea, entityType as 'IdeaCard', and user as the user who created the idea
• Scenario: Subscription is created when user posts a comment to an idea
  • Given a user posts a comment on an idea
  • When the comment is posted
  • Then a subscription is automatically created for the user with the entityId of the idea, entityType as 'IdeaCard', and user as the user who posted the comment

[becevka]

@tiagopazhs Please start with creating a Subscription collection.

[j-peace]

@tiagopazhs Please start with creating a Subscription collection.

All rigth!

So, how it works?

If I create the collection in my strapi admin. Then push to my branch.

If you pull this, you will see the collection in your strapi admin? Is it imediatly or do you need to run a migration?

[becevka]

@tiagopazhs
After you add a collection in Admin locally, strapi will generate new files for you. You can commit those files and create PullRequest. We can review them together in github.

[j-peace]

Why we have a created time instead of subscribed time?

[j-peace]

I didn't understand very weel about this two ones:

• entityId, numeric id of the business-level entity (IdeaCard)
• entityType, enum value of business-level entity type (IdeaCard only for now)

[j-peace]

I just created the PR here with the other fields: #181

[j-peace]

So I have another question:
If I add a field to Subscription. What will happen with the other records in the database that doesn't have this new field.

[becevka]

Why we have a created time instead of subscribed time?

Could be subscribed time, I just thought it would be more consistent to have similar name in all collections

[becevka]

Also difference between createdDateTime and subscribedDateTime is that user can resubscribe, but that will just set active to true and unsubscribeDateTime to null, but createdDateTime will stay the same. I.e. createdDateTime is a time when record was created, just once, while user might resubscribe, we really not care much (at least for now) when they resubscribe.

[becevka]

entityType will be enum type with the name of the type of the data user subscribe to. For now it will have only one option - IdeaCard.
entityId is a numeric Id (not relationship reference) to the entity, user subscribed to. In case of IdeaCard, IdeaCard id.

[j-peace]

entityType will be enum type with the name of the type of the data user subscribe to. For now it will have only one option - IdeaCard. entityId is a numeric Id (not relationship reference) to the entity, user subscribed to. In case of IdeaCard, IdeaCard id.

In this case, should I create a field with normal integer type, right?
And before create or update, check if the id exists.

Looks good?

[j-peace]

Why we have a created time instead of subscribed time?

Could be subscribed time, I just thought it would be more consistent to have similar name in all collections

Is there a convetion here in the project for that? Something like:
createdAt or createdDateTime or createdTime or TimeCreated
wich one can adapt as well to the project?

Last question wich one looks better, camelCase or PascalCase

[j-peace]

Hey @becevka is it still open because we have to test the endpoints and pass all tests before to finalize the entire epic ?