aws_codedeploy
- Components
- Code examples
Tables​
    codedeploy_application
    codedeploy_deployment
    codedeploy_deployment_group
Functions​
    start_deploy
Enums​
    compute_platform
    deployment_status
    revision_type
    deployment_config_type
    deployment_option
    deployment_type
    ec2_tag_filter_type
Manage Codedeploy
--- installs the codedeploy module and dependencies
SELECT * FROM iasql_install('<modules>');
--- adds a new codedeploy role
INSERT INTO iam_role (role_name, assume_role_policy_document, attached_policies_arns)
VALUES ('<roleName>', '<codedeployRolePolicy>', array['<codedeployPolicyArn>', '<deployEC2PolicyArn>']);
--- adds a new codedeploy role for lambda
INSERT INTO iam_role (role_name, assume_role_policy_document, attached_policies_arns)
VALUES ('<lambdaRoleName>', '<codedeployRolePolicy>', array['<codedeployPolicyArn>', '<deployLambdaPolicyArn>']);
--- adds a new ec2 role
INSERT INTO iam_role (role_name, assume_role_policy_document, attached_policies_arns)
VALUES ('<ec2RoleName>', '<ec2RolePolicy>', array['<deployEC2PolicyArn>', '<ssmPolicyArn>']);
--- adds a new security group
INSERT INTO security_group (description, group_name)
VALUES ('CodedeploySecurity Group', '<sgGroupName>');
--- adds security group rules
INSERT INTO security_group_rule (is_egress, ip_protocol, from_port, to_port, cidr_ipv4, description, security_group_id)
SELECT false, 'tcp', 22, 22, '0.0.0.0/0', '<prefix>codedeploy_rule_ssh', id
FROM security_group
WHERE group_name = '<sgGroupName>';
INSERT INTO security_group_rule (is_egress, ip_protocol, from_port, to_port, cidr_ipv4, description, security_group_id)
SELECT false, 'tcp', 80, 80, '0.0.0.0/0', '<prefix>codedeploy_rule_http', id
FROM security_group
WHERE group_name = '<sgGroupName>';
INSERT INTO security_group_rule (is_egress, ip_protocol, from_port, to_port, cidr_ipv4, description, security_group_id)
SELECT true, 'tcp', 1, 65335, '0.0.0.0/0', '<prefix>codedeploy_rule_egress', id
FROM security_group
WHERE group_name = '<sgGroupName>';
--- adds a new codedeploy_application
INSERT INTO codedeploy_application (name, compute_platform)
VALUES ('<applicationName>', 'Server');
--- check codedeploy_application is available
SELECT * FROM codedeploy_application WHERE name='<applicationName>';
--- delete application
DELETE FROM codedeploy_application
WHERE name = '<applicationName>';
--- adds a new codedeploy_application for deployment
INSERT INTO codedeploy_application (name, compute_platform)
VALUES ('<applicationNameForDeployment>', 'Server');
--- adds a new deployment_group
INSERT INTO codedeploy_deployment_group (application_id, name, role_name)
VALUES ((SELECT id FROM codedeploy_application WHERE name = '<applicationNameForDeployment>'), '<deploymentGroupName>', '<roleName>');
--- check codedeploy_deployment_group is available
SELECT * FROM codedeploy_deployment_group WHERE name='<deploymentGroupName>';