yrsdi

{
    "configurations": [
        {
            "name": "Mac",
            "includePath": [
                "/usr/include",
                "/usr/local/include",
                "${workspaceRoot}"
            ],
            "defines": [],

yrsdi

Setting up a polite Golang project

By polite I mean not interfering in any other projects (even Golang ones), not polluting or forcing your global workspace (no matter how it is organized), and being reproducible on any other machine. For reasons out of the scope of this document, that's not an easy task to accomplish when working with Golang.

These are my notes, not a generic solution. They are not meant to work anywhere outside my machines.

Installing everything needed the first time

Install asdf and its golang plugin, then install golang

yrsdi

-module (listAcc).
-compile(export_all).

%% Sources : https://stackoverflow.com/questions/22189296/list-accumulators-in-erlang

%% There are two functions - odds_and_evens_acc/1 and odds_and_evens_acc/3
%% First function. It takes a list of integers and splits it on two lists - 
%%   odds and evens. 
%% The function calls odds_and_evens_acc/3 with three arguments - 
%%   given List of integers and two empty lists which are

yrsdi

MySQL

Getting started:

• http://www.sqlteaching.com/
• https://www.codecademy.com/courses/learn-sql

Related tutorials:

• MySQL-CLI
• Analyzing Business Metrics

yrsdi

SELECT GROUP_CONCAT('kill ',id SEPARATOR '; ') AS kill_list
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE command='Sleep';

yrsdi

#!/bin/bash

set -e
set -u

PSQL=/usr/bin/psql

DB_USER=postgres
DB_HOST=0.0.0.0
DB_NAME=name_of_db

yrsdi

git cheat-sheet

The git command-line utility has plenty of inconsistencies http://steveko.wordpress.com/2012/02/24/10-things-i-hate-about-git/

A GUI like http://sourcetreeapp.com is often helpful, but staying on the command line usually quicker. This is a list of the commands I use most frequently, listed by funcional category:

current state

git status list which (unstaged) files have changed

yrsdi

-- export mysql data to csv with header

select 'created_date','disk_space_100','disk_space_101','disk_space_116','disk_space_117' 
union all (select created_date, disk_space_100, disk_space_101, disk_space_116,disk_space_117 
           from bdc_tibco_diskSpace where date_format(created_date, '%Y-%m')='2018-08'
           into outfile '/var/lib/mysql/data/tibco_disk_space.csv' 
           fields terminated by ','
           enclosed by '"'
           lines terminated by '\n')

yrsdi

#!/bin/bash

dateNow=$(date -d "-1 days" +"%Y%m%d");
REMOTE_IP='10.0.0.0'
SCP_PASSWORD="pas1212121"
SCP_DIR="/var/www/html/"
SCP_FILE="NAMEOFFILE-$dateNow.txt"
SCP_REMOTE="username@$REMOTE_IP:$SCP_DIR/$SCP_FILE"
TARGET_IP='10.0.0.1'
TARGET_SCP_PASSWORD='pas12121212'

yrsdi

#!/bin/bash
PASS=`pwgen -s 40 1`

mysql -uroot <<MYSQL_SCRIPT
CREATE DATABASE $1;
CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';
GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';
FLUSH PRIVILEGES;
MYSQL_SCRIPT