Skip to content

Instantly share code, notes, and snippets.

View danilkuznetsov's full-sized avatar

Danil Kuznetsov danilkuznetsov

View GitHub Profile
@danilkuznetsov
danilkuznetsov / update_firefox_developer_edition.sh
Created January 3, 2019 05:51 — forked from grenade/update_firefox_developer_edition.sh
this script is based on another for Sublime Text (http://www.simonewebdesign.it/install-sublime-text-3-on-linux/). It will handle updates (detects the latest developer or nightly edition) and locale (using your $LANG environment variable) (only tested on a 64 bit, fedora system, feedback welcome).
#!/bin/sh
# Firefox Developer Edition install
# No need to download this script, just run it on your terminal:
# $ curl -L git.io/firefoxdev | sh
# When you need to update Firefox Developer Edition, run this script again.
START_CMD="firefox-dev"
INSTALLATION_DIR="/opt/${START_CMD}"
new Date().toISOString().slice(0,10);
@danilkuznetsov
danilkuznetsov / Export data from H2 database into CSV
Last active June 14, 2023 00:23
Export data from H2 database into CSV
CALL CSVWRITE('/home/<user>/downloads/<table_name>'.csv', 'SELECT * FROM <table_name>', 'charset=UTF-8 fieldSeparator=;');
Without field delimiter "
CALL CSVWRITE('/home/<user>/downloads/<table_name>'.csv', 'SELECT * FROM <table_name>', 'charset=UTF-8 fieldSeparator=; fieldDelimiter=');
@danilkuznetsov
danilkuznetsov / sbv2srt.py
Created January 30, 2017 22:55
convert sbv to srt subtitles
#!/usr/bin/env python
import glob
import os
from captionstransformer.sbv import Reader
from captionstransformer.srt import Writer
for source_filename in glob.glob('*.sbv'):
print source_filename
r = open(source_filename)
reader = Reader(r)
@danilkuznetsov
danilkuznetsov / backup.sh
Created January 30, 2017 19:42
start/stop docker container and backup data. remove backups older than 5 days
#!/bin/sh
DOCKER_CONTAINER_NAME="container name"
SOURCE_DATA_FOLDER="<path to source files>"
TEMP_FOLDER="/tmp/<folder_name>/"
BACKUP_STORAGE="<path to storage backup files>"
ARCHIVE_FILE_NAME=edx-mysql-$(date +%Y%m%d).tgz
echo "... Starting:"
@danilkuznetsov
danilkuznetsov / pr.md
Created December 12, 2016 07:03 — forked from piscisaureus/pr.md
Checkout github pull requests locally

Locate the section for your github remote in the .git/config file. It looks like this:

[remote "origin"]
	fetch = +refs/heads/*:refs/remotes/origin/*
	url = git@github.com:joyent/node.git

Now add the line fetch = +refs/pull/*/head:refs/remotes/origin/pr/* to this section. Obviously, change the github url to match your project's URL. It ends up looking like this:

@danilkuznetsov
danilkuznetsov / ListExample.java
Last active November 3, 2016 20:06
Examples for the ArrayList iteration
package com.tutorial.collections;
import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
/**
* Created by danil.kuznetsov
*/
public class ListExample {
@danilkuznetsov
danilkuznetsov / java_enviroment.sh
Created November 3, 2016 11:44
set JAVA_HOME and JRE_HOME depending on alternatives settings
JAVA_HOME=$(readlink -f /usr/bin/java | sed "s:/jre/bin/java::")
JRE_HOME=$JAVA_HOME/jre
export JAVA_HOME JRE_HOME
UPDATE mysql.user SET host = '%' WHERE host = 'localhost' AND user != 'root';
UPDATE mysql.db SET host = '%' WHERE host = 'localhost' AND user != 'root';
FLUSH PRIVILEGES;
sudo sed -i "s/mirrors\.digitalocean/archive.ubuntu/g" /etc/apt/sources.list