danielestevez

CREATE TRIGGER complex_constraint BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
    IF /*complex constraint*/(NEW.field1 IS NOT NULL AND NEW.field2 IS NOT NULL) OR  (NEW.field1 IS NULL AND NEW.field2 IS NULL) THEN
    SIGNAL SQLSTATE '45000' 
        SET MESSAGE_TEXT = 'complex constraint exception message';
    END IF;
END 

danielestevez

# .bash_aliases
alias mvi='mvn clean install -Dtest.suite=none -Dit.suite=none -o -fae'
alias psg='ps -ef | grep $1'
alias sk='sudo kill -9 $1'
alias sshi='ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null'

danielestevez

function newbranch() {
    git submodule foreach git checkout ${1}
    git submodule foreach git pull origin ${1}
    git submodule foreach git co -b ${2}
    git submodule foreach git push origin ${2}
    git status
}


# newbranch master newbranchname

danielestevez

alias mvi='mvn clean install -Dtest.suite=none -Dit.suite=none -fae -T1C'
alias mvall='mvn clean install -Dtest.suite=all -Dit.suite=all -fae -T1C'
alias mvallf='mvan clean install -Dtest.suite=all -Dit.suite=all -ff -T1C'
alias mvndep='mvn cargo:deployer-redeploy'
alias psg='ps -ef | grep $1'
alias sk='sudo kill -9 $1'
alias sshi='ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null'

danielestevez

DROP  TABLE IF EXISTS `kinton`.`debug_msg`;
CREATE TABLE `debug_msg` (
  `msg` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;


INSERT INTO debug_msg (msg) VALUES (CONCAT('message: ',IFNULL(variable, 'NULL')));

danielestevez

Keybase proof

I hereby claim:

• I am danielestevez on github.
• I am destevez (https://keybase.io/destevez) on keybase.
• I have a public key whose fingerprint is D643 2F6B 354B B8A3 5A62 9875 4A38 23E7 0D46 E466

To claim this, I am signing this object:

danielestevez

 pager less -SFX
select * from table;

danielestevez

* Access JIRA with no SSO, just user/password 
https://[JIRA_URL]/jira/secure/Dashboard.jspa?os_username=[USER_NAME]&os_password=[USER_PASSWORD]

danielestevez

#include this in your .gitconfigure to perform a pull/push origin on the branch you are currently working
# avoids mistakes performing 'pull origin master' when you are in stable and so on
# 

[alias]
# Pushes/pulls to/from remote branch with corresponding name
pl = !git pull origin $(git symbolic-ref HEAD | sed -e 's,.*/\\(.*\\),\\1,')
ps = !git push origin $(git symbolic-ref HEAD | sed -e 's,.*/\\(.*\\),\\1,')

danielestevez

• Kills all process by name

sudo kill -9 $(pidof middleman)