Max Karelov maxkarelov

## jql
project = SP and reporter IN (admin, admin2) AND summary ~ task AND description ~ text AND status = "to do"

## gen_sonarqube_report.py
import mysql.connector

config = {
    'user': 'root',
    'password': 'root',
    'host': '127.0.0.10',
    'db': 'sonar',
    'project': ''
}

## jenkins-create-job.sh
java -jar jenkins-cli.jar -s http://server create-job newmyjob < myjob.xml

## get_list_of_paths.sh
# get one line comma-separated list of project paths with zero integration test coverage

mysql -h127.0.0.1 -uroot -proot sonar -e "SELECT concat(projects.long_name,'/*,') FROM snapshots JOIN projects ON snapshots.project_id=projects.id JOIN project_measures as m1 ON m1.snapshot_id=snapshots.id JOIN project_measures as m2 ON m2.snapshot_id=snapshots.id WHERE snapshots.islast=1 AND snapshots.scope=\"DIR\" AND m1.metric_id=59 AND m1.value=0 AND m2.metric_id=3;" > /tmp/list.txt
sed -i '1d' /tmp/list.txt
cat /tmp/list.txt | tr -d ' ' | tr -d "\n" > /tmp/complete_list.txt

# or remove leading characters (jenkins limit 300k)
cat /tmp/classes.txt | awk -F"/" '{ print "**/" $(NF-1) "/" $NF }'

# update property in database

## ssh-over-http.sh
# corkscrew
ssh -i key user@host -o "ProxyCommand corkscrew proxy.host proxy.port host port"

# connect-proxy
ssh -i key user@host -o "ProxyCommand connect-proxy -H proxy.host:proxy.port host port"

## get_ip_address.sh
ifconfig eth1|grep 'inet addr:'|cut -d: -f2|cut -d' ' -f1|awk '{ print $1 }'

## parsing_snippets.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                maxkarelov
                / parsing_snippets.md
            
            
              Last active
              November 11, 2015 11:09
            
              
                parsing snippets patterns grep bash curl
              
          
    get xml tag content

grep -oPm1 "(?<=<title>)[^<]+"


## readme.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                maxkarelov
                / readme.md
            
            
              Last active
              November 5, 2015 21:30
            
              
                oracle jdk installation
              
          
    FOR JDK 8u60

RPM:

wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie" http://download.oracle.com/otn-pub/java/jdk/8u60-b27/jdk-8u60-linux-x64.rpm

TAR GZ:

wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie"  http://download.oracle.com/otn-pub/java/jdk/8u60-b27/jdk-8u60-linux-x64.tar.gz


## oraInst.loc
inventory_loc=/opt/oraInventory
inst_group=

## gist:46ac0006378014ff815f
Failed StepArgumentException with 'requirement failed: No keystore provided'

########################### MANIFEST ################################

version: "1.1"
header: {}
launch:
  steps:
    provisionMicroUbuntuAmazon:
      action: provisionVms
	import mysql.connector

	config = {
	'user': 'root',
	'password': 'root',
	'host': '127.0.0.10',
	'db': 'sonar',
	'project': ''
	}
	# get one line comma-separated list of project paths with zero integration test coverage

	mysql -h127.0.0.1 -uroot -proot sonar -e "SELECT concat(projects.long_name,'/*,') FROM snapshots JOIN projects ON snapshots.project_id=projects.id JOIN project_measures as m1 ON m1.snapshot_id=snapshots.id JOIN project_measures as m2 ON m2.snapshot_id=snapshots.id WHERE snapshots.islast=1 AND snapshots.scope=\"DIR\" AND m1.metric_id=59 AND m1.value=0 AND m2.metric_id=3;" > /tmp/list.txt
	sed -i '1d' /tmp/list.txt
	cat /tmp/list.txt \| tr -d ' ' \| tr -d "\n" > /tmp/complete_list.txt

	# or remove leading characters (jenkins limit 300k)
	cat /tmp/classes.txt \| awk -F"/" '{ print "**/" $(NF-1) "/" $NF }'

	# update property in database
	# corkscrew
	ssh -i key user@host -o "ProxyCommand corkscrew proxy.host proxy.port host port"

	# connect-proxy
	ssh -i key user@host -o "ProxyCommand connect-proxy -H proxy.host:proxy.port host port"
	Failed StepArgumentException with 'requirement failed: No keystore provided'

	########################### MANIFEST ################################

	version: "1.1"
	header: {}
	launch:
	steps:
	provisionMicroUbuntuAmazon:
	action: provisionVms