Skip to content

Instantly share code, notes, and snippets.

View tad-lispy's full-sized avatar

Tad Lispy tad-lispy

View GitHub Profile
@tad-lispy
tad-lispy / Nazwy stron z odmianą fleksyjną pogrupowane wg. sprawy i roli.sql
Last active January 3, 2016 03:39
SQL query to Currenda Sawa DB to get parties to the lawsuit (plaintiff and defendant), with group concatenated names for each side separated by colon, and with inflexion cases (dative for defendant and genitive for plaintiff) and count for each side.
-- Use this variable to limit scope of search to defendants last name or name in case of corporations
declare @search as varchar(32)
set @search = 'Kowalski'
-- Find lawsuits where pozwany matches search criteria
-- This will be used to limit scope of search.
-- ATM the query is very inefficient. Without this limit and for large data set it can take very long time to execute.
declare @sprawy table (
ident integer
);
@tad-lispy
tad-lispy / ..ONCE.sh
Last active February 3, 2016 19:19
My linux config files with color prompts, autocompletions and other good stuff. This is mainly for me to easily set up things on new systems.
npm set prefix $HOME/.node_modules/ # for installing global node modules in home directory
read -p 'Your e-mail: ' email
git config --global user.email "$email"
git config --global user.name "Tadeusz Łazurski"
git config --global core.editor vim
curl https://raw.github.com/git/git/master/contrib/completion/git-prompt.sh > ~/.git-prompt.sh