Skip to content

Instantly share code, notes, and snippets.

View DaysJan's full-sized avatar

DaysJan

1 follower · 6 following
View GitHub Profile
@DaysJan
DaysJan / download-last-release-url.sh
Created August 21, 2019 03:47
Download github latest release asset
#!/bin/bash
# https://help.github.com/en/articles/linking-to-releases
# https://stackoverflow.com/questions/24987542/is-there-a-link-to-github-for-downloading-a-file-in-the-latest-release-of-a-repo
# https://gist.github.com/steinwaywhw/a4cd19cda655b8249d908261a62687f8
curl -s https://api.github.com/repos/owner/name/releases/latest | grep browser_download_url | cut -d '"' -f 4 | grep asset-name | wget -qi -
@DaysJan
DaysJan / bash.sh
Last active July 31, 2019 11:52
cheatsheet
# uniq line
awk '!seen[$0]++ {print $0}' file
# additional line
awk 'FNR==NR{a[$0];next}!($0 in a)' old new
@DaysJan
DaysJan / mysql.sql
Last active July 31, 2019 08:48
mysql cheatsheet
-- https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_unix-timestamp
SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19');
-- -> 1447431619
-- https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime
SELECT FROM_UNIXTIME(1447430881, '%Y-%m-%d %H:%i:%s');
-- -> '2015-11-13 10:08:01'
@DaysJan
DaysJan / run-goaccess-docker.sh
Created March 5, 2019 04:57
#!/bin/bash
mkdir -p /srv/goaccess/{data,html}
curl -o /srv/goaccess/data/goaccess.conf.default https://raw.githubusercontent.com/allinurl/goaccess/master/config/goaccess.conf
cp /srv/goaccess/data/goaccess.conf.default /srv/goaccess/data/goaccess.conf
docker run --restart=always -d -p 7890:7890 \
-v "/srv/goaccess/data:/srv/data" \
@DaysJan
DaysJan / run-goaccess-docker.sh
Created March 5, 2019 04:57
#!/bin/bash
mkdir -p /srv/goaccess/{data,html}
curl -o /srv/goaccess/data/goaccess.conf.default https://raw.githubusercontent.com/allinurl/goaccess/master/config/goaccess.conf
cp /srv/goaccess/data/goaccess.conf.default /srv/goaccess/data/goaccess.conf
docker run --restart=always -d -p 7890:7890 \
-v "/srv/goaccess/data:/srv/data" \
@DaysJan
DaysJan / run-goaccess-docker.sh
Created March 5, 2019 04:57
#!/bin/bash
mkdir -p /srv/goaccess/{data,html}
curl -o /srv/goaccess/data/goaccess.conf.default https://raw.githubusercontent.com/allinurl/goaccess/master/config/goaccess.conf
cp /srv/goaccess/data/goaccess.conf.default /srv/goaccess/data/goaccess.conf
docker run --restart=always -d -p 7890:7890 \
-v "/srv/goaccess/data:/srv/data" \
@DaysJan
DaysJan / run-goaccess-docker.sh
Created March 5, 2019 04:57
#!/bin/bash
mkdir -p /srv/goaccess/{data,html}
curl -o /srv/goaccess/data/goaccess.conf.default https://raw.githubusercontent.com/allinurl/goaccess/master/config/goaccess.conf
cp /srv/goaccess/data/goaccess.conf.default /srv/goaccess/data/goaccess.conf
docker run --restart=always -d -p 7890:7890 \
-v "/srv/goaccess/data:/srv/data" \
@DaysJan
DaysJan / run-db-docker.sh
Created March 5, 2019 02:47
#!/bin/bash
mkdir -p /data/mysql /data/redis
# mysql
docker run --name mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 -v /data/mysql:/var/lib/mysql -d --restart unless-stopped mysql:5.7 --general-log=1 --general_log_file=general.log
# redis
docker run --name redis -p 6379:6379 -v /data/redis:/data -d --restart unless-stopped redis:4.0-alpine redis-server --appendonly yes
@DaysJan
DaysJan / install-docker-on-centos.sh
Created March 4, 2019 11:54
#!/bin/bash
# https://docs.docker.com/install/linux/docker-ce/centos/
# uninstall docker ce
sudo yum remove -y docker-ce
# delete all images, containers, and volumes
#sudo rm -rf /var/lib/do
# uninstall old versions
@DaysJan
DaysJan / ProgressBar.php
Last active January 3, 2019 15:16
A simple php script progress bar.
<?php
function progress($done, $total) {
static $width;
static $block = 0;
if (! isset($width)) {
$width = (int) exec('tput cols');
}