jay-johnson

[root@mysql1 db-loaders]# cat /tmp/dbreload.log

Creating Database(stocks) on Env(Local)

Dropping Targeted Database(stocks) Address(127.0.0.1) User(dbadmin) Pass(dbadmin123) Schema(/opt/db-loaders/schema/db_schema.py) Init(/opt/db-loaders/schema/initialize_db.py)
/opt/db-loaders/schema/drop_database.sh stocks dbadmin 127.0.0.1 dbadmin123 3306
Creating Targeted Database(stocks) Address(127.0.0.1) User(dbadmin) Pass(dbadmin123) Schema(/opt/db-loaders/schema/db_schema.py) Init(/opt/db-loaders/schema/initialize_db.py)
/opt/db-loaders/schema/create_database.sh stocks dbadmin 127.0.0.1 dbadmin123 3306
Adding Records with Initializer(/opt/db-loaders/schema/initialize_db.py)

jay-johnson

version: '2'

services:
  db:
    image: jayjohnson/schemaprototyping
    container_name: "schemaprototyping"
    hostname: "mysql1"
    networks:
      - dbprototyping
    environment:

jay-johnson

Clone the Repo

$ git clone https://github.com/jay-johnson/docker-schema-prototyping-with-mysql.git

Start the Composition

$ ./start_composition.sh 

jay-johnson

Run this on EC2 host

1. Set these attributes in /etc/ssh/sshd_config

# cat /etc/ssh/sshd_config  | grep X11
X11Forwarding yes 
X11DisplayOffset 10
X11UseLocalhost yes 

jay-johnson

#!/bin/bash

repo="<DEBIAN REPO FQDN>"
outputDir="<DIRECTORY TO STORE DEBIAN FILES>"
arch="<ARCH like binary-i386 or binary-amd64>"

echo "Download All Debs from Repository($repo) to dir($outputDir)"

pushd $outputDir >> /dev/null
packagenames=`wget -q -O - http://$repo/pool/main/h | grep deb | grep href | sed -e 's/\/"/ /g' | sed -e 's/"/ /g' | awk '{print $3}'`

jay-johnson

A list of python data transformations

String to Datetime

1. String to Datetime and then compare

#!/usr/bin/python

import datetime

jay-johnson

node {
    
    // Setup the Docker Registry (Docker Hub) + Credentials 
    env.REGISTRY_URL = "https://index.docker.io/v1/" // Docker Hub
    env.DOCKER_CREDS_ID = "jayjohnson-DockerHub" // name of the Jenkins Credentials ID
    env.BUILD_TAG = "testing" // default tag to push for to the registry
    
    stage 'Checking out GitHub Repo'
    git url: 'https://github.com/jay-johnson/docker-django-nginx-slack-sphinx.git'
    

jay-johnson

DEMO TITLE

jay-johnson

$ docker run -p 8080:8080 -p 50000:50000 -d --name cje -v /var/run/docker.sock:/var/run/docker.sock -v /usr/local/bin/docker:/usr/local/bin/docker cloudbees/jenkins-enterprise

jay-johnson

registry_url = "https://index.docker.io/v1/" // Docker Hub
docker_creds_id = "jayjohnson-DockerHub" // name of the Jenkins Credentials ID
build_tag = "testing" // default tag to push for to the registry