using Amazon.CDK;
using Constructs;
using Amazon.CDK.AWS.EC2;
using Amazon.CDK.AWS.RDS;
using Amazon.CDK.AWS.SSM;

namespace SharedInfrastructure.Production;

public class DatabaseStackProps : StackProps
{
    public Vpc Vpc { get; set; }
}

public class DatabaseStack : Stack
{
    private const int DatabasePort = 1433;

    public DatabaseInstance Database { get; set; }

    internal DatabaseStack(Construct scope, string id, DatabaseStackProps props) : base(scope, id, props)
    {
        var dbSG = new SecurityGroup(this, "DatabaseSecurityGroup", new SecurityGroupProps
        {
            Vpc = props.Vpc,
            Description = "Allow access to the SQL Server instance from the website",
        });

        Database = new DatabaseInstance(this, $"{Constants.AppName}SqlDb", new DatabaseInstanceProps
        {
            Vpc = props.Vpc,
            VpcSubnets = new SubnetSelection
            {
                SubnetType = SubnetType.PRIVATE_WITH_EGRESS
            },
            // SQL Server 2017 Express Edition, in conjunction with a db.t2.micro instance type,
            // fits inside the free tier for new accounts
            Engine = DatabaseInstanceEngine.SqlServerEx(new SqlServerExInstanceEngineProps
            {
                Version = SqlServerEngineVersion.VER_14
            }),
            StorageType = StorageType.GP3,
            AllocatedStorage = 20,            
            Port = DatabasePort,
            SecurityGroups = new[]
            {
                dbSG
            },
            InstanceType = InstanceType.Of(InstanceClass.BURSTABLE2, InstanceSize.MICRO),
            InstanceIdentifier = $"{Constants.AppName}Database",
            // As this is a sample app, turn off automated backups to avoid any storage costs
            // of automated backup snapshots. It also helps the stack launch a little faster by
            // avoiding an initial backup.
            BackupRetention = Duration.Seconds(0)
        });

        // The secret, in Secrets Manager, holds the auto-generated database credentials. Because
        // the secret name will have a random string suffix, we add a deterministic parameter in
        // Systems Manager to contain the actual secret name.
        _ = new StringParameter(this, $"{Constants.AppName}DbSecret", new StringParameterProps
        {
            ParameterName = $"/{Constants.AppName}/dbsecretsname",
            StringValue = Database.Secret.SecretName
        });
    }
}