Skip to content

Latest commit

 

History

History
247 lines (199 loc) · 8.2 KB

README.md

File metadata and controls

247 lines (199 loc) · 8.2 KB

weekly44

Looking to have X as Code, the WIP long trip..

Local Environment - Postgres Api Ui ( alpine linux everywhere )

  • docker-compose.yaml
# Use postgres/example user/password credentials
version: '3.9'

services:

  db:
    image: postgres:13-alpine
    healthcheck:
      test: [ "CMD", "pg_isready", "-q", "-d", "postgres", "-U", "postgres" ]
      timeout: 45s
      interval: 10s
      retries: 10    
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: example
      APP_DB_USER: dev_user
      APP_DB_PASS: dev_user
      APP_DB_NAME: twitter_clone      
    ports:
      - "5432:5432"
    volumes: 
      - ./data:/var/lib/postgresql/data
      - ./db:/docker-entrypoint-initdb.d/
      - ./sql:/sql

  api:
    #build: 
    #  context: ../twitter-clone/
    #  dockerfile: api/Dockerfile.dev
    #  target: dev
    image: node:16-alpine
    command: sh -c "npm install && npm run start"
    working_dir: /api
    container_name: twitter_clone_api
    volumes:
      - ../twitter-clone/api:/api
      - ../twitter-clone/api/node_modules:/api/node_modules
    ports:
      - "4000:4000" 
      - "49155:49153"
    environment:
      - NODE_ENV=dev
    networks:
      - default     

  ui:
    #build: 
    #  context: ../twitter-clone/
    #  dockerfile: ui/Dockerfile.dev
    #  target: dev
    image: node:16-alpine
    command: sh -c "npm install && npm run start"
    working_dir: /ui
    container_name: twitter_clone_ui
    volumes:
      - ../twitter-clone/ui:/ui
      - ../twitter-clone/ui/node_modules:/ui/node_modules
    ports:
      - "4244:3000" 
      - "49153:49153"
    environment:
      - NODE_ENV=dev
    networks:
      - default     

networks:
  default:

Makefile - Actions / Commands self documented for developers.

Step by Step, Makefile to have clear doc/action running system.

Looking to have X as Code ( yes, yes, yes.. long trip, but here we are.. )

  • Makefile
include .env
#user=..
#servers=..
## Makefile variables
# servers-if-not-set-then-default?=localhost ## if servers not set, then set with value localhost
servers-exec-cmd!=hostname  ## execute command and set stdout to variable server
servers-exec-usr-id!=id  ## execute command and set stdout to variable server

.PHONY: view-hostname
step00 view-hostname:
	@echo $(servers-exec-cmd)
	@echo '$(servers-exec-usr-id)'

step200 graphql-api-init:
	cd ../ && git clone https://github.com/prisma/prisma-examples
	mv -R ../prisma-examples/typescript/graphql-auth api
	cd api && npm i
	
step201 graphql-ui-init:
	cd twitter-clone && npm uninstall -g create-react-app && npx create-react-app ui --template typescript

step202 graphql-compose-start:
	docker-compose -f docker/docker-compose.yml up --remove-orphans
	#docker-compose --verbose -f docker/docker-compose.yml up --remove-orphans

step203 docker-psql-ls:
	docker exec docker_db_1 psql -Upostgres -d postgres -c '\l'	

step203-t docker-psql-ls-twitter:
	docker exec docker_db_1 psql -Upostgres -d twitter-clone -c '\l'	

step204 docker-psql-exec-sql:
	docker exec docker_db_1 psql -Upostgres -d postgres --file=/sql/input.sql > docker/sql/output.sql
	@##docker exec docker_db_1 psql -Upostgres -d postgres --file=/sql/input.sql > docker/sql/output.sql 2> docker/sql/error.log
step205 docker-pg_dump:
	docker exec docker_db_1 pg_dump -Upostgres -d twitter_clone > docker/sql/create_tables.sql

step206 api-prisma-generate:
	cd twitter-clone/api && npx prisma generate

step207 api-prisma-migrate-dev:
	cd twitter-clone/api && npx prisma migrate dev --name init

step208 api-prisma-migrate-up:
	cd twitter-clone/api && npx prisma migrate resolve --applied 20210615195142_init

step209 api-prisma-introspect: 
	cd twitter-clone/api && npx prisma introspect ## check prisma - db

step210 api-npm-prisma-update: 
	cd twitter-clone/api && npm i -D prisma && npm i @prisma/client && npm audit fix;

step211 docker-psql-drop-database:
	docker exec docker_db_1 psql -Upostgres -d postgres -c "DROP DATABASE twitter_clone;"	

step212 docker-system-prune:
	docker system prune -af	

step213 graphql-ui-install:
	cd twitter-clone/ui && npm i @apollo/client graphql && npm audit fix --force ;

#step01 app: ## Nestjs - GraphQL
#	mkdir app	
#step02 api-create: app
#	cd app && nest new api
#step03 api-install:
#	cd app/api && npm install @nestjs/graphql graphql-tools graphql apollo-server-express class-validator uuid
#step04 generate-types:
#	cd app/api && ./node_modules/.bin/ts-node src/scripts/generate.ts
#step05 api-test:
#	curl -X POST http://localhost:4000/graphql -H "Content-Type: application/json" -d '{ "query":"query { article(  id: 1 ){ id, title, content } }"}'

#ssh-manual-root-update: ## debian - dev-user:staff /usr/loca/bin
#	apt -y update; apt -y upgrade;
#	adduser dev-user; 
# usermod -g ssh dev-user; 
#	usermod -g staff dev-user;
# chown root:staff /usr/local/bin; chmod 775 /usr/local/bin;
# hostname [dev.domain];

step10 ssh-docker-install: ## debian - docker install
	$(foreach server, $(servers),  ssh root@$(server)	" apt -y install apt-transport-https software-properties-common ca-certificates curl gnupg lsb-release; echo  'deb [arch=amd64] https://download.docker.com/linux/debian  buster stable' | tee /etc/apt/sources.list.d/docker.list > /dev/null ;  curl -fsSL https://download.docker.com/linux/debian/gpg | apt-key add - ; add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/debian buster stable" ; apt -y update; apt -y remove docker docker-engine docker.io containerd runc; apt -y install docker-ce docker-ce-cli containerd.io; usermod -aG docker $(user) " \ ;)

step20 ssh-login:
	$(foreach server, $(servers),  ssh-copy-id  $(user)@$(server);)
	
step21 ssh-ls:
	$(foreach server, $(servers),  ssh $(user)@$(server) "ls -a";)

step22 ssh-docker-test:
	$(foreach server, $(servers),  ssh $(user)@$(server) "docker run hello-world";)

#step23 ssh-k3d-install:
#	$(foreach server, $(servers),  ssh root@$(server) "curl -s https://raw.githubusercontent.com/rancher/k3d/main/install.sh | bash";)
	
#step24 ssh-k3d-test:
#	$(foreach server, $(servers),  ssh $(user)@$(server) "k3d --help;";)

#kubectl-version!=curl -L -s https://dl.k8s.io/release/stable.txt
#step25 ssh-kubectl-install:
#	$(foreach server, $(servers),  ssh root@$(server) "curl -fsSLo /usr/share/keyrings/kubernetes-archive-keyring.gpg https://packages.cloud.google.com/apt/doc/apt-key.gpg; curl -LO 'https://dl.k8s.io/release/$(kubectl-version)/bin/linux/amd64/kubectl'; install -o root -g root -m 0755 kubectl /usr/local/bin/kubectl;";)

#step26 ssh-kubectl-test:
#	$(foreach server, $(servers),  ssh $(user)@$(server) "kubectl version";)

#step30 ui-create:
#	mkdir ui; cd ui; npm init -y; mkdir public; mkdir src; touch public/index.html; \
#	npm i -D typescript webpack webpack-cli http-server react react-dom @types/react @types/react-dom; \
#	npx tsc --init ;\
#	echo 'UI - Created - React Typescript';

## SSH Multi Server commands execute 
step100 ssh-arkade:
	$(foreach server, $(servers),  ssh $(user)@$(server) "curl -sLS https://dl.get-arkade.dev | sh";)

step101 ssh-ark-kubectl:
	$(foreach server, $(servers),  ssh $(user)@$(server) "ark get kubectl; mv ./.arkade/bin/kubectl /usr/local/bin/;";)

step102 ssh-kubectl-test:
	$(foreach server, $(servers),  ssh $(user)@$(server) "kubectl version";)

step103 ssh-ark-k3d:
	$(foreach server, $(servers),  ssh $(user)@$(server) "ark get k3d; mv ./.arkade/bin/k3d /usr/local/bin/;";)

step104 ssh-k3d-test:
	$(foreach server, $(servers),  ssh $(user)@$(server) "k3d version";)

## Default usage k3d - kubernetes cluster fast, simple, minimal
k3d-cluster-create:
	k3d cluster create
kubectl-cluster-info:
	kubectl cluster-info
k3d-cluster-delete:
	k3d cluster delete

## Kubernetes - interaction - cleaning
step150 kubectl-get-nodes:
	kubectl get nodes
step151 kubectl-get-sc:
	kubectl get sc
step152 kubectl-top-nodes:
	kubectl top nodes
step153 kubectl-kube-system-top-nodes:
	kubectl -n kube-system top nodes
step154 kubectl-get-componentstatus:
	kubectl get componentstatus

step170 kubectl-run-busybox:
	kubectl run -it --rm shell1 --image busybox

step171 docker-haproxy-sh:
	docker run -it haproxy:alpine /bin/sh
	
step180 kubectl-watch-get-pods:
	watch kubectl get pods -o wide

step190 kubectl-delete-all:
	kubectl delete all --all # delete all resources in all namespaces