dinushchathurya

Push the Branch to Your Fork (origin)

git push origin NEW-BRANCH-NAME

Push the Branch to the Original Repository (upstream)

git push upstream NEW-BRANCH-NAME

dinushchathurya

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "ec2:DescribeVolumes",
        "ec2:DescribeSnapshots",
        "ec2:CreateTags",
        "ec2:CreateVolume",

dinushchathurya

Here is an example of a schema migration SQL file for a production database, following best practices:

Example: Adding a New Column to a Table

File: 2025_01_06_add_phone_to_users.sql

-- Migration: Add `phone` column to `users` table
-- Created on: 2025-01-06
-- Author: Your Name
-- Description: Adds a nullable `phone` column to the `users` table for storing user phone numbers.

dinushchathurya

# Examples of Using `CAST` and `CONVERT` in SQL with Scenarios

---

## **1. Using `CAST` to Fix Data Type Mismatch in a Join**

### Scenario
The `users` table has an `id` column of type `INT`, and the `orders` table has a `user_id` column of type `VARCHAR(10)`. You need to join these tables.

dinushchathurya

apiVersion: v1
kind: ServiceAccount
metadata:
  name: tekton-triggers-sa
---
apiVersion: rbac.authorization.k8s.io/v1
kind: Role
metadata:
  name: tekton-triggers-example-minimal
rules:

dinushchathurya

apiVersion: v1
kind: List
items:
  - apiVersion: argoproj.io/v1alpha1
    kind: Application
    metadata:
      name: argo-rollouts
      labels:
        type: infrastructure
    spec:

dinushchathurya

curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.34.0/install.sh | bash

. ~/.nvm/nvm.sh

nvm install node

node -e "console.log('Running Node.js ' + process.version)"

dinushchathurya

Deploy nodejs app with gitlab.com and pm2
=========================================

This manual is about setting up an automatic deploy workflow using [nodejs](https://nodejs.org/en/),
[PM2](http://pm2.keymetrics.io/), [nginx](https://nginx.org/) and
[GitLab CI](https://about.gitlab.com/features/gitlab-ci-cd/). It is tested on:

*   Target server: **Ubuntu 16.04 x64.** This is suitable for Ubuntu 14.x.
*   **Windows 10** on my PC to work.

dinushchathurya

Docker: 

  *[Docker Cheatsheet](https://dockerlabs.collabnix.com/).
  *[12 Factor Apps](https://12factor.net/).
  *https://pagertree.com/2020/01/06/docker-cheat-sheet/
  *https://buddy.works/tutorials/docker-commands-cheat-sheet
  *

dinushchathurya

sudo gitlab-runner status

Docker-Image: docker:19.03.12

sudo vim /etc/gitlab-runner/config.toml

privileged: ture

sudo apt-get install docker docker-compose -y