Skip to content

Instantly share code, notes, and snippets.

View maxkarelov's full-sized avatar
🏠
Working from home

Max Karelov maxkarelov

🏠
Working from home
14 followers · 1 following
View GitHub Profile
@maxkarelov
maxkarelov / jql
Created December 10, 2015 10:30
project = SP and reporter IN (admin, admin2) AND summary ~ task AND description ~ text AND status = "to do"
@maxkarelov
maxkarelov / gen_sonarqube_report.py
Created December 2, 2015 16:25
python script for generating sonarqube project report
import mysql.connector
config = {
'user': 'root',
'password': 'root',
'host': '127.0.0.10',
'db': 'sonar',
'project': ''
}
@maxkarelov
maxkarelov / jenkins-create-job.sh
Created December 1, 2015 15:59
create jenkins job from xml file
java -jar jenkins-cli.jar -s http://server create-job newmyjob < myjob.xml
@maxkarelov
maxkarelov / get_list_of_paths.sh
Last active December 2, 2015 10:52
SQL queries to SonarQube 5.2 database for retrieve information
# 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
@maxkarelov
maxkarelov / ssh-over-http.sh
Created November 27, 2015 15:28
corkscrew and connect-proxy user examples
# 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"
@maxkarelov
maxkarelov / get_ip_address.sh
Created November 23, 2015 13:11
get private ip address snippet
ifconfig eth1|grep 'inet addr:'|cut -d: -f2|cut -d' ' -f1|awk '{ print $1 }'
@maxkarelov
maxkarelov / parsing_snippets.md
Last active November 11, 2015 11:09
parsing snippets patterns grep bash curl

get xml tag content

grep -oPm1 "(?<=<title>)[^<]+"
@maxkarelov
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
@maxkarelov
maxkarelov / oraInst.loc
Last active November 5, 2015 21:37
Instruction for weblogic silent mode installation
inventory_loc=/opt/oraInventory
inst_group=
@maxkarelov
maxkarelov / gist:46ac0006378014ff815f
Created October 26, 2015 19:07
Failed StepArgumentException with 'requirement failed: No keystore provided'
########################### MANIFEST ################################
version: "1.1"
header: {}
launch:
steps:
provisionMicroUbuntuAmazon:
action: provisionVms