Skip to content

Instantly share code, notes, and snippets.

@goryszewskig
goryszewskig / create_sitemap.py
Created August 12, 2022 07:43 — forked from nomadrat/create_sitemap.py
create sitemap. python
#
# this is part of https://abstractkitchen.com/blog/sitemaps-for-devs
#
import os
import gzip
from xml.etree import cElementTree
@goryszewskig
goryszewskig / docker-cheat-sheet.md
Created July 28, 2022 13:23 — forked from rcmorano/docker-cheat-sheet.md
my miscelaneous docker cheat sheet

rcmorano docker cheat sheet

Remove recursively zombie containers

In e.g.: you 'docker run -t -i' a 'bash' session and '.bashrc' is fucked up, container will forever respawn disallowing you to 'docker rmi' the used image .

docker rmi triangle/ubuntu-saucy-with-rvm 2>&1|grep ^Error|awk '{print $10}'|xargs docker rm
@goryszewskig
goryszewskig / docker_bash_aliases
Created July 28, 2022 13:23 — forked from rcmorano/docker_bash_aliases
docker bash aliases
alias docker-container-most-recent='docker ps| grep -v ^CONTAINER | head -n1 | awk "{print \$1}"'
alias docker-container-diff-most-recent='LAST_CONTAINER=$(docker-container-most-recent); if [ ! -z "$LAST_CONTAINER" ]; then docker diff $LAST_CONTAINER; else echo "There are no running containers!"; fi'
alias docker-container-inspect-most-recent='LAST_CONTAINER=$(docker-container-most-recent); if [ ! -z "$LAST_CONTAINER" ]; then docker inspect $LAST_CONTAINER; else echo "There are no running containers!"; fi'
alias docker-container-remove-all='docker ps -a | grep -v ^CONTAINER|awk "{print \$1}" | xargs -I % sh -c "docker kill %; docker rm %"'
alias docker-container-remove-all-non-running='docker ps -a | grep -v ^CONTAINER | grep Exit | awk "{print \$1}" | xargs -I % sh -c "docker kill %; docker rm %"'
alias docker-image-remove-all='docker-container-remove-all; docker images -a | grep -v ^REPOSITORY | awk "{print \$3}" | xargs docker rmi'
alias docker-image-remove-orphan='docker images | grep "<none>" | awk "{pri
(?i)((access_key|access_token|admin_pass|admin_user|algolia_admin_key|algolia_api_key|alias_pass|alicloud_access_key|amazon_secret_access_key|amazonaws|ansible_vault_password|aos_key|api_key|api_key_secret|api_key_sid|api_secret|api.googlemaps AIza|apidocs|apikey|apiSecret|app_debug|app_id|app_key|app_log_level|app_secret|appkey|appkeysecret|application_key|appsecret|appspot|auth_token|authorizationToken|authsecret|aws_access|aws_access_key_id|aws_bucket|aws_key|aws_secret|aws_secret_key|aws_token|AWSSecretKey|b2_app_key|bashrc password|bintray_apikey|bintray_gpg_password|bintray_key|bintraykey|bluemix_api_key|bluemix_pass|browserstack_access_key|bucket_password|bucketeer_aws_access_key_id|bucketeer_aws_secret_access_key|built_branch_deploy_key|bx_password|cache_driver|cache_s3_secret_key|cattle_access_key|cattle_secret_key|certificate_password|ci_deploy_password|client_secret|client_zpk_secret_key|clojars_password|cloud_api_key|cloud_watch_aws_access_key|cloudant_password|cloudflare_api_key|cloudflare_auth_k
@goryszewskig
goryszewskig / docker_build_orarepo.md
Created March 1, 2022 15:44 — forked from oehrlis/docker_build_orarepo.md
Docker build using local software repository

Oracle Software usually can not be downloaded during build without providing some credentials. If the binaries are downloaded using curl or wget the credentials will remain in the docker image. One solution would be to keep the binaries in the docker build context and use squash or multi stage builds. Alternatively it is also possible to use a local web server (docker container) to download the files locally.

  • Start a simple web server to locally share the software during docker build.
docker run -dit \
  --hostname orarepo \
  --name orarepo \
  -p 80:80 \
 -v /data/docker/volumes/orarepo:/www \

Simple alias to execute base in docker container with some terminal settings

alias deo='function _deo() { if [ -n "${1}" ]; then docker exec -e COLUMNS="`tput cols`" -e LINES="`tput lines`" -it -u oracle ${1} bash --login; else echo "No docker container specified"; fi } ; _deo'
alias der='function _der() { if [ -n "${1}" ]; then docker exec -e COLUMNS="`tput cols`" -e LINES="`tput lines`" -it -u root ${1} bash --login; else echo "No docker container specified"; fi } ; _deo'
@goryszewskig
goryszewskig / output.sql
Created February 1, 2022 13:32 — forked from mvelikikh/output.sql
SQL Trace with filter by FORCE_MATCHING_SIGNATURE
SQL> @q
SQL>
SQL> conn / as sysdba
Connected.
SQL>
SQL> alter session set container=pdb;
Session altered.
SQL>
#myspecialtaggg
WITH ids AS (
SELECT usage, type, name, line, col, usage_id, usage_context_id
FROM user_identifiers ids
WHERE object_type = 'PROCEDURE'
AND object_name = 'P2'
)
SELECT lpad(' ', 3 * (level - 1)) || ids.usage AS usage,
ids.type,
ids.name,
[oracle@db-21 ~]$ sqlplus /nolog @q
SQL*Plus: Release 21.0.0.0.0 - Production on Tue Dec 21 15:54:22 2021
Version 21.4.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> alter session set container=pdb;
#!/usr/bin/awk -f
{ pid=$2;
time=$4;
action=$5;
state=$7;
# backend states
backend_state[0]="undefined";
backend_state[1]="idle";
backend_state[2]="running";