(aws-appsync): RdsDataSource misses option to set dataBaseName

[monholm]

Creating seperate issues for #12503 to improve structure.

It seems like there's no way to add the databasename to a RdsDataSource, which results in a "No database selected" error when running a resolver.

Reproduction Steps

const api = new GraphqlApi(stack, 'api', {
  name: 'graphqlApi',
  schema: Schema.fromAsset('./testSchema.graphql'),
});

const serverless = new ServerlessCluster(stack, 'cluster', {
  engine: DatabaseClusterEngine.AURORA_MYSQL,
  vpc: new Vpc(stack, 'vpc'),
});

api.addRdsDataSource('rdsDS', serverless, serverless.secret!);

What did you expect to happen?

addRdsDataSource to include a prop for databaseName.

What actually happened?

There's no prop for databaseName.

Environment

• CDK CLI Version: 1.84.0
• Framework Version: 1.84.0
• Node.js Version: 14.5.4
• OS: MacOS 10.15.7
• Language (Version): TypeScript (3.9.7)

---

This is 🐛 Bug Report

[BerndWessels]

this is still not resolved in "@aws-cdk/aws-appsync": "^1.89.0", and renders RdsDataSource useless.

[BerndWessels]

@Simon-TechForm my workaround here is as follows. But I really hope AWS is not neglecting the CDK and will take your PRs soon.

        /**
         * Database Data Source
         * TODO: Missing databaseName and databaseSchema https://github.com/aws/aws-cdk/issues/12572
         */
        const databaseDataSource = api.addRdsDataSource(
            "DatabaseDataSource",
            (databaseCluster as unknown) as rds.IDatabaseCluster,
            databaseCluster.secret as secretsManager.ISecret,
            {
                description: "My Product Serverless Aurora RDS Database Data Source",
                name: "MyProductDatabaseDataSource",
            }
        );

        /**
         * TODO: Missing databaseName and databaseSchema https://github.com/aws/aws-cdk/issues/12572
         */
        const cfnDataSource = databaseDataSource.node.defaultChild as appsync.CfnDataSource;
        cfnDataSource.addPropertyOverride("RelationalDatabaseConfig.RdsHttpEndpointConfig.DatabaseName", "my_product");
        cfnDataSource.addPropertyOverride("RelationalDatabaseConfig.RdsHttpEndpointConfig.Schema", "public");

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.