A CDK seeder for SQLServer
Project description
aws-cdk-sqlserver-seeder
A simple CDK seeder for SQL Server RDS databases.
cdk-sqlserver-seeder library is a AWS CDK construct that provides a way to execute custom SQL scripts on RDS SQL Server resource creation/deletion.
The construct relies on Invoke-SqlCmd cmdlet to run the scripts and handle possible errors. Provides a way to handle transient errors during stack provisioning.
Usage
# Example automatically generated without compilation. See https://github.com/aws/jsii/issues/826
import aws_cdk.core as cdk
import aws_cdk.aws_ec2 as ec2
import aws_cdk.aws_rds as rds
from cdk_sqlserver_seeder import SqlServerSeeder
class DatabaseStack(cdk.Stack):
def __init__(self, scope, id, *, description=None, env=None, stackName=None, tags=None, synthesizer=None, terminationProtection=None):
super().__init__(scope, id, description=description, env=env, stackName=stackName, tags=tags, synthesizer=synthesizer, terminationProtection=terminationProtection)
sql_server = rds.DatabaseInstance(self, "Instance",
engine=rds.DatabaseInstanceEngine.SQL_SERVER_WEB
)
seeder = SqlSeederSecret(self, "SqlSeederSecret",
database=sql_server,
port=1433,
vpc=vpc,
create_script_path="./SQL/v1.0.0.sql", # script to be executed on resource creation
delete_script_path="./SQL/cleanup.sql"
)
Acknowledgements
The whole project inspired by aws-cdk-dynamodb-seeder. I though it would be very helpful to have a similar way to seed initial schema to more traditional SQL Server databases.
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
Built Distribution
Close
Hashes for cdk-sqlserver-seeder-0.1.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0114da32ac5c554ac595a7960eae97e21525f8f156917635fb18c4906d59ba18 |
|
MD5 | 9737bb3de2d6ec63ba3598512a3eb9f4 |
|
BLAKE2b-256 | d8cb66b4e5486abc66db1895a301132a9dcc4ac656b3073c4d9867a50f961ac1 |
Close
Hashes for cdk_sqlserver_seeder-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e1974ef4fda1cf2d9be3a434ac0143a02e0983cec80f7fc117128d4c442a05c6 |
|
MD5 | f56ed275f95fd63724747819027d630f |
|
BLAKE2b-256 | 0a19110191e4fe2dcd73b1574dd66d84c1acab8c9f4e6639565ff81936bb93c8 |