CI/CD with AWS

app.get("/products", async (req, res) => {
  const search = req.query.search || "";

  let query = `SELECT * FROM products WHERE name ILIKE $1`;

  if (!search) {
    query += ` LIMIT 5;`;
  }

  const { rows } = await pgPool.query(query, [`%${search}%`]);

  res.json(rows);
});

app.post("/checkout", async (req, res) => {
  const { email, items, total } = req.body;
  // Logic: Clear cart, create order
  const result = await pgPool.query(
    "INSERT INTO orders (email, total) VALUES ($1, $2) RETURNING id",
    [email, total]
  );
  const orderId = result.rows[0].id;

  for (const item of items) {
    await pgPool.query(
      "INSERT INTO order_items (order_id, product_id, quantity) VALUES ($1, $2, $3)",
      [orderId, item.id, item.quantity]
    );
  }
  // Send email
  const orderDetails = items
    .map(
      (item, idx) =>
        `${idx + 1}. Product ID: ${item.id}, Product Name: ${
          item.name
        }, Quantity: ${item.quantity}`
    )
    .join("\n");

  const emailBody = `Order confirmed!\n\nOrder ID: ${orderId}\nTotal: $${total}\n\nItems:\n${orderDetails}`;

  const params = {
    Destination: { ToAddresses: [email] },
    Message: {
      Body: { Text: { Data: emailBody } },
      Subject: { Data: "E-commerce Order Confirmation" },
    },
    Source: process.env.SES_SOURCE,
  };

  await ses.sendEmail(params).promise();

  res.send("Checkout complete");
});

#!/bin/bash
sudo apt update -y && sudo apt upgrade -y


# Install Java
sudo apt-get install fontconfig openjdk-17-jre -y


# Download Jenkins
sudo wget -O /usr/share/keyrings/jenkins-keyring.asc \
 https://pkg.jenkins.io/debian-stable/jenkins.io-2023.key
echo "deb [signed-by=/usr/share/keyrings/jenkins-keyring.asc]" \
 https://pkg.jenkins.io/debian-stable binary/ | sudo tee \
 /etc/apt/sources.list.d/jenkins.list > /dev/null
sudo apt-get update -y


# Install Jenkins
sudo apt-get install jenkins -y
sudo systemctl enable jenkins
sudo systemctl start jenkins


# Download & Install Docker (Optinal if need Docker as a builder)
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc
echo \
 "deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
 $(. /etc/os-release && echo "${UBUNTU_CODENAME:-$VERSION_CODENAME}") stable" | \
 sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update -y
sudo apt-get install -y docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
sudo systemctl enable docker
sudo systemctl start docker


# Add the Jenkins User to the Docker Group
# sudo chmod 666 /var/run/docker.sock (Less Recommended)
sudo usermod -aG docker jenkins
sudo systemctl restart docker
sudo systemctl restart jenkins


# Installing AWS CLI
curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
sudo apt install unzip -y
unzip awscliv2.zip
sudo ./aws/install

environment {
       AWS_REGION = "ap-southeast-2"
       AWS_ACCOUNT_ID = "412381745022"
       AWS_ECR_REGISTRY = "${AWS_ACCOUNT_ID}.dkr.ecr.${AWS_REGION}.amazonaws.com"
      
       CLIENT_REPO_NAME = "ecommerce-cicd-project/client"
       CLIENT_REPO_URL = "${AWS_ECR_REGISTRY}/${CLIENT_REPO_NAME}"
      
       PRODUCT_SERVICE_REPO_NAME = "ecommerce-cicd-project/product-service"
       PRODUCT_SERVICE_REPO_URL = "${AWS_ECR_REGISTRY}/${PRODUCT_SERVICE_REPO_NAME}"


       CHECKOUT_SERVICE_REPO_NAME = "ecommerce-cicd-project/checkout-service"
       CHECKOUT_SERVICE_REPO_URL = "${AWS_ECR_REGISTRY}/${CHECKOUT_SERVICE_REPO_NAME}"


       CLUSTER_NAME = "ecommerce-cicd-project"
       CLIENT_SERVICE = "ecommerce-client-service"
       PRODUCT_SERVICE = "ecommerce-product-service"
       CHECKOUT_SERVICE = "ecommerce-checkout-service"
 }

stage ("Docker Login") {
	steps {
		sh "aws ecr get-login-password --region ${AWS_REGION} | docker login --username AWS --password-stdin ${AWS_ECR_REGISTRY}"
	}
}

stage ("Build Docker Images & Push To ECR") {
	parallel {
		stage ("Client") {
			when {
				changeset "client/**"
			}
				steps {
					echo "************************ Client ************************"
                    sh "docker build -t ${CLIENT_REPO_URL}:latest ./client"
                    sh "docker push ${CLIENT_REPO_URL}:latest"
               	}
    		}
             
		stage ("Product Service") {
			when {
				changeset "product-service/**"
			}
				steps {
 					echo "************************ Product Service ************************"
                  	sh "docker build -t ${PRODUCT_SERVICE_REPO_URL}:latest ./product-service"
                   	sh "docker push ${PRODUCT_SERVICE_REPO_URL}:latest"
                    }
                }

     	stage ("Checkout Service") {
          	when {
               	changeset "checkout-service/**"
           	}
         		steps {
            		echo "************************ Checkout Service ************************"
                	sh "docker build -t ${CHECKOUT_SERVICE_REPO_URL}:latest ./checkout-service"
                   	sh "docker push ${CHECKOUT_SERVICE_REPO_URL}:latest"
        	}
    	}
	}
}

stage ("Deploy") {
 	parallel {
     	stage ("Client") {
     		when {
             	changeset "client/**"
           	}
        	steps {
           		echo "************************ Client ************************"
               	sh "aws ecs update-service --cluster ${CLUSTER_NAME} --service ${CLIENT_SERVICE} --force-new-deployment"
         	}
   		}

     	stage ("Product Service") {
           	when {
              	changeset "product-service/**"
          	}
        	steps {
             	echo "************************ Product Service ************************"
              	sh "aws ecs update-service --cluster ${CLUSTER_NAME} --service ${PRODUCT_SERVICE} --force-new-deployment"
        	}
     	}

   		stage ("Checkout Service") {
           	when {
               	changeset "checkout-service/**"
          	}
         	steps {
              	echo "************************ Checkout Service ************************"
            	sh "aws ecs update-service --cluster ${CLUSTER_NAME} --service ${CHECKOUT_SERVICE} --force-new-deployment"
          	}
     	}
  	}
}

post {
   	always {
  		sh "docker logout ${AWS_ECR_REGISTRY}"
	}
}