djheru

Git Workflow

Scenario 1: Merging into Master

1. Create a new feature branch

• git checkout master && git pull upstream master
• git checkout -b my-codez

2. Do work and make a bunch of commits

• Make sure your commits are descriptive and meaningful

djheru

//Place expressions here that evaluate to a boolean value where "true" means it's a touchscreen
var touchConditionalsArray = [
    ('ontouchstart' in window),
    (navigator.MaxTouchPoints > 0),
    (navigator.msMaxTouchPoints > 0)
];
//Find if any of the conditions indicating a touchscreen are true
this.staticState.touch = (touchConditionalsArray.indexOf(true) >= 0);
console.log((this.staticState.touch) ? 'yay' : 'noes');

djheru

#!/usr/bin/env bash

echo "--- Good morning, bro. Let's get to work. Installing now. ---"

echo "--- Updating packages list ---"
sudo apt-get update

echo "--- MySQL time ---"
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password root'
sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password root'

djheru

CREATE TABLE audit_log (
    username text, -- who did the change
    event_time_utc timestamp, -- when the event was recorded
    table_name text, -- contains schema-qualified table name
    operation text, -- INSERT, UPDATE, DELETE or TRUNCATE
    before_value json, -- the OLD tuple value
    after_value json -- the NEW tuple value
);

CREATE OR REPLACE FUNCTION audit_trigger() 

djheru

WITH RECURSIVE recursetree(base_order_id, parent_order_id, term_cd) AS (
    SELECT 
     base_order_id, NULL::bigint[] || parent_order_id, term_cd, contract_start_date 
    FROM om."BASE_ORDERS" 
    WHERE parent_order_id IS NOT NULL
  UNION ALL
    SELECT 
    t.base_order_id, 
    rt.parent_order_id || t.parent_order_id, 
    t.term_cd

djheru

mysql -u usernm -h db.somehost.com -ps0s3kur3 --database=dbname --batch -e "SELECT * FROM table WHERE foo='bar';" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > ~/DATA_EXPORT.csv

djheru

mysql -u username -h mysqlhost -pyourpasswd --database=thedb --batch \ 
-e "select * from foo" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > outfile.csv

djheru

select d.id as deal_id, d.name as deal_name, 
	parent_c.id as parent_company_id, parent_c.name as parent_company_name, 
	child_c.id as child_company_id, child_c.name as child_company_name, child_c.location_id as child_location_id
from deals d
	inner join partner_deals pd on pd.deal_id = d.id
	inner join partners p on p.id = pd.partner_id
	inner join partner_companies pc on pc.partner_id = p.id
	inner join companies parent_c on parent_c.id = pc.company_id
	inner join companies child_c on child_c.parent_id = parent_c.id
where parent_c.enterprise = 'Y'

djheru

      div.input-row.col-xs-10.col-xs-offset-1
        div.opponent-box.row(data-ng-show="controller.event.opponent !== null")
          div.letter.col-xs-1
            school-letter(school="controller.event.opponent")
          div.truncate.col-xs-10
            div.event-opponent-name.text-center {{controller.event.opponent.name}}
          div.close.col-xs-1
            i.remove-opponent(data-ng-click="controller.removeOpponent(controller.event.opponent)")

djheru

upstream localnode_upstream {
    server 127.0.0.1:3000;
    keepalive 64;
}

server {
    listen 80;
    listen [::]:80 default_server ipv6only=on;
    #listen 443 ssl;
    #listen [::]:443 default_server ipv6only=on;