azwdevops
azwdevops
/ gist:5995cac82aa31606f612960d17f0de53
Created
April 19, 2024 07:06
An SQL gist to create company table and run various queries to extract data from MYSQL DB
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE DATABASE company_db; | |
| USE company_db; | |
| -- CREATE TABLES | |
| CREATE TABLE employee( | |
| emp_id INT PRIMARY KEY, | |
| first_name VARCHAR(20), | |
| last_name VARCHAR(20), | |
| birth_date DATE, | |
| sex VARCHAR(1), | |
| salary INT, |
azwdevops
/ gist:d74adcc22c810c9d5f978a3d053ceb52
Created
February 24, 2024 06:41
a simple gist for aws buildspec to create a code build in aws
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version: 0.2 | |
| env: | |
| parameter-store: | |
| DOCKER_REGISTRY_USERNAME: /myapp/docker-credentials/username | |
| DOCKER_REGISTRY_PASSWORD: /myapp/docker-credentials/password | |
| DOCKER_REGISTRY_URL: /myapp/docker-registry/url | |
| phases: | |
| install: |