Skip to content

Instantly share code, notes, and snippets.

View 62mkv's full-sized avatar

Kirill M 62mkv

  • Breakwater Technology
  • Tallinn, Estonia
View GitHub Profile
@62mkv
62mkv / find-class-in-jar
Last active May 13, 2019 07:31
Find class in a set of JAR files
sudo find /path/to/ -name "*.jar" -exec sh -c 'jar -tf {}| grep -H --label {} package' \;
@62mkv
62mkv / oracle.md
Last active February 4, 2020 11:01
Oracle cheatsheet
  • Show table DDL:
    select dbms_metadata.get_ddl('TABLE', '<your table name>') from dual

  • List all of the (available) tables: select * from user_tables

@62mkv
62mkv / Search-and-Replace-Structurally.md
Last active February 21, 2022 16:27
IntelliJ IDEA Receipts

Examples of Structural Search and Replace (IntelliJ IDEA 2017)

Use case 1 (Search)

Find all *DTO classes, that have a (at least one) public field that is neither @ApiModelProperty, nor a @JsonIgnore

  1. Open Edit->Find->Search structurally

  2. Paste this into Search template field:

@62mkv
62mkv / README.md
Last active August 30, 2017 04:24
NHP KMS recipes for KIOSK

подключение к БД на киоске

запускаем psql

sudo -u postgres psql

показываем доступные СУБД

\l

подключаемся к нужной (с номером нужного паблиша)

\c kms_1478787944

@62mkv
62mkv / gist:8f476e3a3477dddda563dbbbda3dc81f
Last active April 14, 2017 06:21
bash: sed: how to print X lines of a file starting with a line N
# show lines 1000-1010 in "filename" file
sed -n '{1000,+100p}' filename
# another option is more simplistic syntax:
sed -n 1000,+10p filename
# also display line numbers:
sed -n '1000,+10{p;=}' filename
# other useful one-liners are available here: http://sed.sourceforge.net/sed1line.txt
@62mkv
62mkv / gist:51398dc2511fcf684ff87d3f044d95b9
Last active September 29, 2017 09:47
How to update Android SDK components (this is necessary to accept licenses)
# cd to ANDROID_SDK folder:
cd /opt/android-sdk-linux
# show which packages are available for install (for example, for Build Tools 25:)
./tools/android list sdk --all | grep Build | grep 25
# 3- Android SDK Build-tools, revision 25.0.2
# 4- Android SDK Build-tools, revision 25.0.1
# 5- Android SDK Build-tools, revision 25
# 25- Android SDK Build-tools, revision 19.0.2 (Obsolete)
@62mkv
62mkv / gist:43dfeee66991442d674e6b4aa5f5d7ca
Created December 27, 2016 04:00
how to run a debug-mode SSH on a separate port
/usr/sbin/sshd -p 2222 -ddd
@62mkv
62mkv / check-web.sh
Created November 19, 2016 13:22
check if web-server responds on request
#!/bin/bash
curl -v http://u.rl/path/; echo $?
# -v prints headers; $? is an exit code of last called command
@62mkv
62mkv / gist:26be598fe65251ebdc5fbc424f75031d
Created November 3, 2016 02:45
Show size of each subfolder
du -BM -s * | sort
@62mkv
62mkv / extract-property-from-xml.ps1
Created October 26, 2016 06:04
Select only one property of every element of a given type in an XML-file (in PowerShell)
Select-XML -XPath "response/action/provider/@fullName" -Path providers.xml | Select-Object -ExpandProperty Node