Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add lifecycle date started_at when a new plan, plan regulation, plan proposition or plan feature is created #303

Open
Rikuoja opened this issue Jun 10, 2024 · 0 comments
Assignees

Comments

@Rikuoja
Copy link
Contributor

Rikuoja commented Jun 10, 2024

Creating the plan matter (#273 ) requires that a plan has non-zero initiation date.

So let's add a new trigger: when INSERTing NEW plan, let's save the current time in lifecycle_date with lifecycle_status "02" (vireilletullut).

Also, we want a date to be present for all regulations, propositions and plan objects, so let's add the trigger in all the tables with lifecycle status. However, the date should always have same status as plan, so let's set the lifecycle_status by looking at plan lifecycle_status.

Will have to do this now to get plan matter tests up and running. Or at the very least, will have to add statuses to newly created objects.

@Rikuoja Rikuoja changed the title Add lifecycle date started_at when a new plan is created Add lifecycle date started_at when a new plan, plan regulation, plan proposition or plan feature is created Jun 11, 2024
@Rikuoja Rikuoja changed the title Add lifecycle date started_at when a new plan, plan regulation, plan proposition or plan feature is created Add lifecycle date "vireilletullut" started_at when a new plan, plan regulation, plan proposition or plan feature is created Jun 11, 2024
@Rikuoja Rikuoja changed the title Add lifecycle date "vireilletullut" started_at when a new plan, plan regulation, plan proposition or plan feature is created Add lifecycle date started_at when a new plan, plan regulation, plan proposition or plan feature is created Jun 11, 2024
@Rikuoja Rikuoja assigned Rikuoja and unassigned msorvoja Jun 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: No status
Development

No branches or pull requests

2 participants