Skip to main content

A construct for working with RDS SQL servers

Project description

RDS Tools

---

cdk-constructs: Developer Preview

The APIs of higher level constructs in this module are in developer preview before they become stable. We will only make breaking changes to address unforeseen API issues. Therefore, these APIs are not subject to Semantic Versioning, and breaking changes will be announced in release notes. This means that while you may use them, you may need to update your source code when upgrading to a newer version of this package.


There are multiple versions of this library published. You should be using the v0.X.X versions for now. There are versions published that match the CDK version they depend on, but don't use those.

This is a collection of CDK constructs you can use with RDS.

Developer Preview

DatabaseScript

Provides a Custom Resource and backing Lambda Function that will run a given script against a given database.

const databaseInstance = new DatabaseInstance(stack, 'test-database', {
  engine: DatabaseInstanceEngine.sqlServerWeb({ version: SqlServerEngineVersion.VER_15_00_4043_16_V1 }),
  vpc: vpc,
});


// ...


new DatabaseScript(stack2, 'test', {
  databaseInstance,
  script: 'SELECT 1',
})
  .bind(databaseInstance.connections.securityGroups[0]); // bind for security access

DatabaseUser

There was once a construct called DatabaseUser. However, it is better to use the standard code from the CDK directly:

const myUserSecret = new rds.DatabaseSecret(this, 'MyUserSecret', {
  username: 'myuser',
  masterSecret: instance.secret,
  excludeCharacters: '{}[]()\'"/\\', // defaults to the set " %+~`#$&*()|[]{}:;<>?!'/@\"\\"
});
const myUserSecretAttached = myUserSecret.attach(instance); // Adds DB connections information in the secret
instance.addRotationMultiUser('MyUser', { // Add rotation using the multi user scheme
  secret: myUserSecretAttached,
});

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mbonig.rds-tools-2.0.19.tar.gz (73.4 kB view details)

Uploaded Source

Built Distribution

mbonig.rds_tools-2.0.19-py3-none-any.whl (72.0 kB view details)

Uploaded Python 3

File details

Details for the file mbonig.rds-tools-2.0.19.tar.gz.

File metadata

  • Download URL: mbonig.rds-tools-2.0.19.tar.gz
  • Upload date:
  • Size: 73.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.11.6

File hashes

Hashes for mbonig.rds-tools-2.0.19.tar.gz
Algorithm Hash digest
SHA256 2a25f739ba73689f13a087a7894cc7e349b42ed3206b2e6c5cb54c162372749a
MD5 1a2355679e2fa04ff212c179dc3eb55c
BLAKE2b-256 1f8cfced03389a1fd708affabe71bb3c3bb349df48ecc5763ffb6cefdfdc01e7

See more details on using hashes here.

File details

Details for the file mbonig.rds_tools-2.0.19-py3-none-any.whl.

File metadata

File hashes

Hashes for mbonig.rds_tools-2.0.19-py3-none-any.whl
Algorithm Hash digest
SHA256 a56776c1fd0aebd0436ae684d28e7c7e1c42e0f3436a4955305f788e8af40aba
MD5 35aeaa29e28b7981da59d340b7428153
BLAKE2b-256 747ae51217cd7dfd48eabc1b71273597287024179bc50eb650864980fd53b457

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page