Skip to content

Instantly share code, notes, and snippets.

View tulik's full-sized avatar
:octocat:
Kubernetes!

Lukasz D. Tulikowski tulik

:octocat:
Kubernetes!
View GitHub Profile
@tulik
tulik / foo.sh
Created August 31, 2018 10:03
My shell cheats
# Rename all files in directory to start with upper case letter
for i in *; do first=$(echo "${i:0:1}" | tr '[:lower:]' '[:upper:]'); new=$first${i:1}; mv "$i" "$new"; done
@import url(https://fonts.googleapis.com/css?family=Roboto:400,700,500,300);@import url(https://fonts.googleapis.com/css?family=Roboto+Mono:400,700,500,300);@keyframes a{0%{transform:rotate(0deg)}to{transform:rotate(1turn)}}@keyframes b{0%{opacity:1}50%{opacity:0}to{opacity:1}}[src$="blue.png"]{background-image:url(data:image/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjE4IiB2aWV3Qm94PSIwIDAgMjQgMjQiIHdpZHRoPSIxOCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48cGF0aCBmaWxsPSIjMDA5Njg4IiBkPSJNMTIgMkM2LjQ4IDIgMiA2LjQ4IDIgMTJzNC40OCAxMCAxMCAxMCAxMC00LjQ4IDEwLTEwUzE3LjUyIDIgMTIgMnptLTIgMTVsLTUtNSAxLjQxLTEuNDFMMTAgMTQuMTdsNy41OS03LjU5TDE5IDhsLTkgOXoiLz48L3N2Zz4=)}[src$="red.png"]{background-image:url(data:image/svg+xml;base64,PHN2ZyBoZWlnaHQ9IjE4IiB2aWV3Qm94PSIwIDAgMjQgMjQiIHdpZHRoPSIxOCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48cGF0aCBmaWxsPSIjRjQ0MzM2IiBkPSJNMTIgMkM2LjQ4IDIgMiA2LjQ4IDIgMTJzNC40OCAxMCAxMCAxMCAxMC00LjQ4IDEwLTEwUzE3LjUyIDIgMTIgMnptMSAxNWgtMnYtMmgydjJ6bTAtNGgtMlY3aDJ2NnoiLz48L3N2Zz4=)}[src$="yellow.png
@tulik
tulik / tic-tac-toe.sql
Created October 2, 2018 16:23
TicTacToe in SQL (Postgres)
--- Introduced by Mariusz Krynski.
with recursive rnd_move(move) as (
select *, random() rnd from generate_series(1, 9) move
), winning_positions(a, b, c) as (
values (1, 2, 3), (4, 5, 6), (7, 8, 9), -- rows
(1, 4, 7), (2, 5, 8), (3, 6, 9), -- cols
(1, 5, 9), (3, 5, 7) -- diagonals
), game as (
select 'O' as who_next, ARRAY['.', '.', '.', '.', '.', '.', '.', '.', '.'] as board
apiVersion: v1
kind: Pod
metadata:
creationTimestamp: 2018-10-04T16:55:29Z
generateName: symfony-blackfire-76b6d644ff-
labels:
app: symfony-blackfire
pod-template-hash: "3262820099"
release: symfony-4-docker-runtime-env
name: symfony-blackfire-76b6d644ff-tj989
<?xml version="1.0" encoding="UTF-8"?>
<Response>
<Hangup/>
</Response>
@tulik
tulik / voice.xml
Last active September 27, 2019 10:13
<?xml version="1.0" encoding="UTF-8"?>
<Response>
<Hangup>
</Response>
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 68 columns, instead of 40 in line 1.
DATE,USD_11,USD_10,USD_9,USD_8,USD_7,EUR_11,EUR_10,EUR_9,EUR_8,EUR_7,CHF_11,CHF_10,CHF_9,CHF_8,CHF_7,LIBOR_CHF_1W_11,LIBOR_CHF_1W_10,LIBOR_CHF_1W_9,LIBOR_CHF_1W_8,LIBOR_CHF_1W_7,LIBOR_CHF_1M_11,LIBOR_CHF_1M_10,LIBOR_CHF_1M_9,LIBOR_CHF_1M_8,LIBOR_CHF_1M_7,LIBOR_CHF_3M_11,LIBOR_CHF_3M_10,LIBOR_CHF_3M_9,LIBOR_CHF_3M_8,LIBOR_CHF_3M_7,LIBOR_CHF_6M_11,LIBOR_CHF_6M_10,LIBOR_CHF_6M_9,LIBOR_CHF_6M_8,LIBOR_CHF_6M_7,LIBOR_CHF_1R_11,LIBOR_CHF_1R_10,LIBOR_CHF_1R_9,LIBOR_CHF_1R_8,LIBOR_CHF_1R_7,WIBOR_1W_11,WIBOR_1W_10,WIBOR_1W_9,WIBOR_1W_8,WIBOR_1W_7,WIBOR_1M_11,WIBOR_1M_10,WIBOR_1M_9,WIBOR_1M_8,WIBOR_1M_7,WIBOR_3M_11,WIBOR_3M_10,WIBOR_3M_9,WIBOR_3M_8,WIBOR_3M_7,WIBOR_6M_11,WIBOR_6M_10,WIBOR_6M_9,WIBOR_6M_8,WIBOR_6M_7,WIBOR_1R_11,WIBOR_1R_10,WIBOR_1R_9,WIBOR_1R_8,WIBOR_1R_7,WY_CHF,ID
1/17/2001,4.0961,4.0727,4.1212,4.0846,4.0991,3.8741,3.8881,3.9035,3.8969,3.9029,2.5445,2.554,2.5655,2.5497,2.5523,0,0,0,3.5,3.5,3.3666,3.3666,3.4767,3.3917,3.365,3.37,3.37,3.315,3.3533,3.3217,3.37,3.37,3.305,3.2917,3.24,3.3683,3.3683,3.24,3.29
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 68 columns, instead of 40 in line 1.
DATE,USD_11,USD_10,USD_9,USD_8,USD_7,EUR_11,EUR_10,EUR_9,EUR_8,EUR_7,CHF_11,CHF_10,CHF_9,CHF_8,CHF_7,LIBOR_CHF_1W_11,LIBOR_CHF_1W_10,LIBOR_CHF_1W_9,LIBOR_CHF_1W_8,LIBOR_CHF_1W_7,LIBOR_CHF_1M_11,LIBOR_CHF_1M_10,LIBOR_CHF_1M_9,LIBOR_CHF_1M_8,LIBOR_CHF_1M_7,LIBOR_CHF_3M_11,LIBOR_CHF_3M_10,LIBOR_CHF_3M_9,LIBOR_CHF_3M_8,LIBOR_CHF_3M_7,LIBOR_CHF_6M_11,LIBOR_CHF_6M_10,LIBOR_CHF_6M_9,LIBOR_CHF_6M_8,LIBOR_CHF_6M_7,LIBOR_CHF_1R_11,LIBOR_CHF_1R_10,LIBOR_CHF_1R_9,LIBOR_CHF_1R_8,LIBOR_CHF_1R_7,WIBOR_1W_11,WIBOR_1W_10,WIBOR_1W_9,WIBOR_1W_8,WIBOR_1W_7,WIBOR_1M_11,WIBOR_1M_10,WIBOR_1M_9,WIBOR_1M_8,WIBOR_1M_7,WIBOR_3M_11,WIBOR_3M_10,WIBOR_3M_9,WIBOR_3M_8,WIBOR_3M_7,WIBOR_6M_11,WIBOR_6M_10,WIBOR_6M_9,WIBOR_6M_8,WIBOR_6M_7,WIBOR_1R_11,WIBOR_1R_10,WIBOR_1R_9,WIBOR_1R_8,WIBOR_1R_7,WY_CHF,ID
2001-01-17,4.0961,4.0727,4.1212,4.0846,4.0991,3.8741,3.8881,3.9035,3.8969,3.9029,2.5445,2.554,2.5655,2.5497,2.5523,0,0,0,3.5,3.5,3.3666,3.3666,3.4767,3.3917,3.365,3.37,3.37,3.315,3.3533,3.3217,3.37,3.37,3.305,3.2917,3.24,3.3683,3.3683,3.24,3.2
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 68 columns, instead of 36 in line 1.
DATE,USD_11,USD_10,USD_9,USD_8,USD_7,EUR_11,EUR_10,EUR_9,EUR_8,EUR_7,CHF_11,CHF_10,CHF_9,CHF_8,CHF_7,LIBOR_CHF_1W_11,LIBOR_CHF_1W_10,LIBOR_CHF_1W_9,LIBOR_CHF_1W_8,LIBOR_CHF_1W_7,LIBOR_CHF_1M_11,LIBOR_CHF_1M_10,LIBOR_CHF_1M_9,LIBOR_CHF_1M_8,LIBOR_CHF_1M_7,LIBOR_CHF_3M_11,LIBOR_CHF_3M_10,LIBOR_CHF_3M_9,LIBOR_CHF_3M_8,LIBOR_CHF_3M_7,LIBOR_CHF_6M_11,LIBOR_CHF_6M_10,LIBOR_CHF_6M_9,LIBOR_CHF_6M_8,LIBOR_CHF_6M_7,LIBOR_CHF_1R_11,LIBOR_CHF_1R_10,LIBOR_CHF_1R_9,LIBOR_CHF_1R_8,LIBOR_CHF_1R_7,WIBOR_1W_11,WIBOR_1W_10,WIBOR_1W_9,WIBOR_1W_8,WIBOR_1W_7,WIBOR_1M_11,WIBOR_1M_10,WIBOR_1M_9,WIBOR_1M_8,WIBOR_1M_7,WIBOR_3M_11,WIBOR_3M_10,WIBOR_3M_9,WIBOR_3M_8,WIBOR_3M_7,WIBOR_6M_11,WIBOR_6M_10,WIBOR_6M_9,WIBOR_6M_8,WIBOR_6M_7,WIBOR_1R_11,WIBOR_1R_10,WIBOR_1R_9,WIBOR_1R_8,WIBOR_1R_7,WY_CHF,ID
2001-01-30,4.1087,4.1016,4.1004,4.1125,4.082,3.8806,3.8626,3.8492,3.8561,3.8533,2.512,2.5101,2.5028,2.5223,2.5243,3.55,3.5367,3.4733,3.4333,3.5883,3.475,3.4683,3.4417,3.4367,3.4833,3.425,3.4117,3.4083,3.4017,3.4183,3.37,3.355,3.3617,3.3567,3.3
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 20 columns, instead of 13 in line 2.
Row_Number,Time,Main_Engine_Fuel_Consumption_MT_day,Main_Engine_Using_HFO_bool,Main_Engine_Using_MGO_bool,Draft_Forward_meters,Draft_Aft_meters,Draft_Mid_1_meters,Draft_Mid_2_meters,Speed_Over_Ground_knots,Speed_Through_Water_knots,Heading_degrees,Rudder_Angle_degrees,Weather_Service_Apparent_Wind_Speed_knots,Weather_Service_Apparent_Wind_Direction_degrees_from_bow,Weather_Service_True_Wind_Speed_knots,Weather_Service_True_Wind_Direction_degrees_from_north,Weather_Service_Temperature_celsius,Water_Depth_meters,id
9347,2018-08-03T16:00:00,10.913841492649835,0.0,1.0,5.89235741589783,8.017753112339147,6.805289620956243,6.8274737795711555,11.53482996976405,10.674355944895282,353.28414232614733,359.6009471542625,13.247325692122882,336.24394744704824,5.369116709200043,76.97491656310808,20.777613234293653,31.840821457731494,10
9348,2018-08-03T17:00:00,10.909833830163013,0.0,1.0,5.883866744298486,8.005327431655886,6.808095018775865,6.835383609315669,11.24691954924996,10.575995892722792,4.992563061978614,359.253737992