feat: support for random password

[codezninja]

Description

Add support to create a random password

Motivation and Context

Rather than having the parent project create it I wanted to follow a similiar pattern that was established in terraform-aws-rds-aurora.

Breaking Changes

• No

How Has This Been Tested?

• currently using this forked version of the module so I don't have to create the password. The complexity was simple enough to validate the password change.
• Confirmed can still set password
• Confirmed if no password set, random password is create if create_random_password flag is set
• Confirmed if password set, random password was used instead if create_random_password flag is set

[codezninja]

@bryantbiggs do we think this feature could be added to the next release?

[bryantbiggs]

overall looks good - if you could update the complete examples when you get a chance, I run through a couple tests and we should be good to go

[codezninja]

@bryantbiggs do you want me to add the create_password to all the complete examples AND create a new example like random_password

nvm i'll add random password module to all the complete examples

[bryantbiggs]

@bondezbond no no - I've added two instances to the complete-mysql and complete-postgresql to test two scenarios:

1. complete setup of RDS instance which enables most features/functionality https://github.com/bryantbiggs/terraform-aws-rds/blob/a9f87a5cdae69d11d6653309659dc69cb6de9a1a/examples/complete-mysql/main.tf#L61
2. default setup of RDS instance which relies on the module defaults with the minimum amount of required input https://github.com/bryantbiggs/terraform-aws-rds/blob/a9f87a5cdae69d11d6653309659dc69cb6de9a1a/examples/complete-mysql/main.tf#L112

so if you could just add the following to both complete-mysql and complete-postgresql to the first instance (see 1 above) to show how users can utilize this functionality and also for us to use in testing

	create_random_password = true
	random_password_length = 16

and also add an output to the examples for this_db_instance_master_password

[codezninja]

@bryantbiggs I opted to create its own module resource to show how you can create a random password without setting password. Found a bug that way. I'm hoping thats okay to leave as is. I tested by running terraform plan -target=module.db_random_password in both repos

[codezninja]

@bryantbiggs is there anything else you need for this PR?

[codezninja]

kk I've removed the second resource

[bryantbiggs]

validated with complete-postgresql - good to go @antonbabenko 👍🏼 - thanks @bondezbond 🎉

[codezninja]

thanks for validating!

[antonbabenko]

Thanks @bondezbond for this one!

v2.32.0 has been just released.

[github-actions]

I'm going to lock this pull request because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems related to this change, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.