Pimpelkram Haruki

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

## sql_case.sql
 select has.id HAS_ID,
               htf.id HTF_ID,
               htfbew.halmv_id HAS_MSN_ID,
               case
                 when htfbew.bew = 1 and hv.bew_von is not null and hv.bew_bis is not null then
                  1
                 else
                  0
               end HTF_BEW,

## VSC_cursor.txt
"editor.cursorBlinking": "solid"

## hyper-mingw.txt
    shell: 'C:\\Program Files\\Git\\git-cmd.exe',

    // for setting shell arguments (i.e. for using interactive shellArgs: ['-i'])
    // by default ['--login'] will be used
    shellArgs: ['--command=usr/bin/bash.exe', '-l', '-i'],

## windows_utf8_conversion_powershell.txt
Get-Content .\test.txt | Set-Content -Encoding utf8 test-utf8.txt

## caddy.sh
apt install curl
curl https://getcaddy.com | bash -s cors,expires,filemanager,git,hugo,ipfilter,jsonp,jwt,locale,mailout,minify,multipass,prometheus,ratelimit,realip,search,upload
chown root:root /usr/local/bin/caddy
chmod 755 /usr/local/bin/caddy
setcap 'cap_net_bind_service=+ep' /usr/local/bin/caddy
mkdir /etc/caddy
chown -R root:www-data /etc/caddy
mkdir /etc/ssl/caddy
chown -R www-data:root /etc/ssl/caddy
chmod 0770 /etc/ssl/caddy

## ffmpeg_copy_noaudio.txt
ffmpeg -ss 00:10:56 -i in.mp4 -t 00:00:05 -vcodec copy -an -y out.mp4

## git_diff_merge_tools_config.txt
git config --global diff.tool p4merge
git config --global difftool.p4merge.cmd 'p4merge.exe $LOCAL $REMOTE'
git config --global difftool.prompt false

git config --global merge.tool p4merge
git config --global mergetool.p4merge.cmd 'p4merge.exe $BASE $LOCAL $REMOTE $MERGED'
git config --global mergetool.prompt false
git config --global mergetool.trustExitCode false
git config --global mergetool.keepBackup false

## oracle_undo_use.txt
select count(segment_name),sum(bytes/1024/1024),status from dba_undo_extents group by status;

## prevent_windows_shutdown.txt
gpedit.msc > Local Computer Policy > Computer Configuration > Windows Settings > Security Settings > Local Policies > User Rights Assignments > Shutdown the system
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console
	select has.id HAS_ID,
	htf.id HTF_ID,
	htfbew.halmv_id HAS_MSN_ID,
	case
	when htfbew.bew = 1 and hv.bew_von is not null and hv.bew_bis is not null then
	1
	else
	0
	end HTF_BEW,
	shell: 'C:\\Program Files\\Git\\git-cmd.exe',

	// for setting shell arguments (i.e. for using interactive shellArgs: ['-i'])
	// by default ['--login'] will be used
	shellArgs: ['--command=usr/bin/bash.exe', '-l', '-i'],
	apt install curl
	curl https://getcaddy.com \| bash -s cors,expires,filemanager,git,hugo,ipfilter,jsonp,jwt,locale,mailout,minify,multipass,prometheus,ratelimit,realip,search,upload
	chown root:root /usr/local/bin/caddy
	chmod 755 /usr/local/bin/caddy
	setcap 'cap_net_bind_service=+ep' /usr/local/bin/caddy
	mkdir /etc/caddy
	chown -R root:www-data /etc/caddy
	mkdir /etc/ssl/caddy
	chown -R www-data:root /etc/ssl/caddy
	chmod 0770 /etc/ssl/caddy
	git config --global diff.tool p4merge
	git config --global difftool.p4merge.cmd 'p4merge.exe $LOCAL $REMOTE'
	git config --global difftool.prompt false

	git config --global merge.tool p4merge
	git config --global mergetool.p4merge.cmd 'p4merge.exe $BASE $LOCAL $REMOTE $MERGED'
	git config --global mergetool.prompt false
	git config --global mergetool.trustExitCode false
	git config --global mergetool.keepBackup false