search

berenddeboer / cdk-rds-sql

A CDK construct that allows creating roles and databases an on Aurora Serverless Postgresql cluster.
Apache License 2.0
23 stars 11 forks source link

Add ability to inject SQL before built-in statements #6

Open moltar opened 1 year ago

moltar commented 1 year ago

My request is rather a niche one, so I can see how this may not be desired.

I need an "escape hatch" and run some SQL before the role is created.

https://github.com/berenddeboer/cdk-rds-sql/blob/2ee7dd1e969bb7b0d7291faa0d6b66f49c34498b/src/handler.ts#L86

This is related to the following issue, where in QuickSight the new password encryption is not supported and needs to be downgraded:

https://stackoverflow.com/a/74527856/1566758

Basically, I need to run this, before role creation:

set password_encryption = 'md5';
berenddeboer commented 6 months ago

Happy to see a PR for this with this as an option.