Alex sabahtalateh

## gl_alias.sh
alias gl="git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit"

## archive.sh
git archive --format=zip -0 -o vanare-2016-2q.zip `git rev-list -n 1 --before="2016-07-01 00:00" develop`

## jira_history
status in (Resolved, Closed) AND resolved >= 2016-11-01 AND resolved <= 2016-11-30 AND assignee was in (currentUser()) ORDER BY updated DESC

## restore_grant.sql
REVOKE ALL
ON ALL TABLES IN SCHEMA public
FROM PUBLIC;

GRANT SELECT, INSERT, UPDATE, DELETE
ON ALL TABLES IN SCHEMA public
TO user_name;

## serialise_object.js
$.fn.serializeObject = function()
{
    var o = {};
    var a = this.serializeArray();
    $.each(a, function() {
        if (o[this.name] !== undefined) {
            if (!o[this.name].push) {
                o[this.name] = [o[this.name]];
            }
            o[this.name].push(this.value || '');

## forwarding.sh
// Сделать так чтобы с https://localhost проксировалось к instapi-alpha.advisorservices.com на машине 172.24.16.163
sudo ssh -L 443:instapi-alpha.advisorservices.com:443 deploy@172.24.16.163 -N

## git_archive.sh
git archive --format=zip -0 -o vanare-2017-2q.zip `git rev-list -n 1 --before="2017-06-30 00:00" master`

## pg_dump
pg_dump --format=c --dbname=db_name --file=/where/to/save --username=username --host=host --no-owner --port=port

## pg_restore
pg_restore --no-owner --role=role_name -d db_name ~/path/to/dump.dump

## show_branchers.sh
git branch --all --sort=creatordate --format "%(creatordate:relative);%(committername);%(refname)" | grep -v ";HEAD$" | column -s ";" -t
	REVOKE ALL
	ON ALL TABLES IN SCHEMA public
	FROM PUBLIC;

	GRANT SELECT, INSERT, UPDATE, DELETE
	ON ALL TABLES IN SCHEMA public
	TO user_name;
	$.fn.serializeObject = function()
	{
	var o = {};
	var a = this.serializeArray();
	$.each(a, function() {
	if (o[this.name] !== undefined) {
	if (!o[this.name].push) {
	o[this.name] = [o[this.name]];
	}
	o[this.name].push(this.value \|\| '');
	// Сделать так чтобы с https://localhost проксировалось к instapi-alpha.advisorservices.com на машине 172.24.16.163
	sudo ssh -L 443:instapi-alpha.advisorservices.com:443 deploy@172.24.16.163 -N