Skip to content

Instantly share code, notes, and snippets.

View andboson's full-sized avatar
🌴

Andrii Bosonchenko andboson

🌴
26 followers · 35 following
  • Cherkasy, UKR \ Alicante, SP
View GitHub Profile
@andboson
andboson / postgres insert from sellect, random
Created July 29, 2016 07:31
insert into questions(article, name, email, text, hash, sale_location_id, created_at, updated_at ) select 1111111 as article, 'drew' as name, 'i@s.com' as email, md5(generate_series(1,10)::text) as text, md5(generate_series(1,10)::text) as hash, 'shop_r002' as sale_location_id, to_date(now()::text, 'YYYY-MM-DD HH:MI:SS') as created_at, to_date(now()::text, 'YYYY-MM-DD HH:MI:SS') as updated_at;
@andboson
andboson / vuejs tabs
Created August 20, 2016 07:42
<div class="tabs">
<ul>
<li v-for="int in 2" class="ui-tabs-tab ui-corner-top ui-state-default ui-tab"
v-bind:class="[ picked == $index ? 'ui-state-active' : '']">
<label class="ui-tabs-anchor">Tab-${ $index }
<input type="radio" name="tabs" value="${ $index }" v-model="picked" v-show="false">
</label>
</li>
</ul>
<div v-for="w_type in wizard_types" v-show="( picked == $index )">
@andboson
andboson / sample-js-web-sock
Created December 1, 2016 18:18
min js-web-socket
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
@andboson
andboson / gist:37726aecbfcee90e370ca4085c6bec5e
Last active December 7, 2016 08:58
go redis expired watch
const REFRESH_EXPIRED_MINUTES = 1
// somewhere (maybe in main.go) run: go WatchExpired(); go RefreshExpired();
func WatchExpired() {
services.RClient.ConfigSet("notify-keyspace-events", "Ex")
pub := services.RClient.PubSub()
pub.PSubscribe("__key*__:*")
debug, _ := conf.AppConfig.Bool("debug")
@andboson
andboson / catch_cmd_output.go
Created December 18, 2016 18:50
catch_cmd_output
package main
import (
"io"
"os"
"log"
"os/exec"
)
func main() {
@andboson
andboson / postgres.sql
Created March 7, 2017 14:41
insert record with random field
insert into cups(reg_id, code, is_enabled, created_at, updated_at )
select
1 as reg_id,
UPPER(substr(md5(''||now()::text||random()::text), 1,8)) as code,
true as is_enabled,
to_date(now()::text,
'YYYY-MM-DD HH24:MI:SS') as created_at,
to_date(now()::text, 'YYYY-MM-DD HH24:MI:SS') as updated_at
from generate_series(1,4000000) on conflict DO NOTHING;
@andboson
andboson / slack.js
Created March 21, 2017 18:06
toggle Slack channels list
var channels = document.querySelector('.channel_list_header_label');
var list = document.querySelector('#channel-list');
channels.addEventListener('click', function(e){
e.preventDefault();e.stopImmediatePropagation();
if (list.style.height != '20px') {
list.style.height = '20px';list.style.overflowY = 'scroll';
} else {
list.style.height = 'auto';list.style.overflowY = 'auto';
}
@andboson
andboson / xhprof
Created February 3, 2015 15:38
laravel xhprof snip wget http://pecl.php.net/get/xhprof-0.9.4.tgz tar xvf xhprof-0.9.4.tgz php -S localhost:9999
define("XHPROF_ROOT", '/var/www/xhprof-0.9.4');
App::before(function(){
xhprof_enable(XHPROF_FLAGS_CPU + XHPROF_FLAGS_MEMORY);
});
App::after(function(){
require_once (XHPROF_ROOT . '/xhprof_lib/utils/xhprof_lib.php');
require_once (XHPROF_ROOT . '/xhprof_lib/utils/xhprof_runs.php');
@andboson
andboson / .zshrc
Last active August 8, 2019 09:00
GOPATH
export GOPATH=`pwd`
export PATH="$PATH:$GOPATH/bin"
echo -e "\033[0;32m CURRENT GOPATH IS: $GOPATH \e[0m"
alias rp='source ~/.zshrc'
@andboson
andboson / checkvpn.sh
Last active March 20, 2020 12:34
check is any pptp-vpn running
#!/bin/bash
# sudo apt install libnotify-bin
vpn=`ifconfig | grep POINTOPOINT`
if [ -z "$vpn" ]
then
notify-send -t 0 "VPN is down";
fi