API: Add secret rotation

[rajdip-b]

Description

Secrets have a rotateAfter field. We would like to scan through all secrets and rotate the values. The values will be automatically generated. For now, we would like to run a cron job every 1 hour and rotate the values of the secrets conditionally.

Criteria for autogenerated value:

• Must me a minimum of 20 characters
• Should have atleaset 1 character in a-z
• Should have atleaset 1 character in A-Z
• Should have atleaset 1 character in 0-9
• Should have atleaset 1 character in !@#$%^&*

Solution

• Add a rotatedAt field in the Secret model that will store the last time the values were rotated
• Create a cron job in secret.service.ts that will rotate the values.
• Run this query every 1 hour: Create new versions across every secretId-environmentId pair in SecretVersion where the Secret has rotateAfter != never and currentTime > rotatedAt+rotateAfter.

[MelloB1989]

Hey I am Kartik Deshmukh. I am one of the participants in the FOSS Hack. We want to contribute to this issue and I feel confident my contribution will help!
/attempt

[NangunooriAbhinav]

/attempt

[github-actions]

Assigned the issue to @NangunooriAbhinav!

[Allan2000-Git]

/attempt. I'd love to work on this issue. I'm not sure, but i'll try to crack this.

[github-actions]

Assigned the issue to @Allan2000-Git!

[rajdip-b]

@Allan2000-Git I'm unassigning you for the moment. Feel free to pick this up when you can.