rpromyshlennikov

SELECT *
FROM information_schema.columns
WHERE table_schema = 'public'; -- describes tables, a lot of info, column name, type, is nullable, additional info (length of data, etc)


SELECT *
FROM information_schema.constraint_column_usage
WHERE table_schema = 'public'; -- names of key constraints by columns, only can help to check constraints names

rpromyshlennikov

router.Walk(
	func(route *mux.Route, router *mux.Router, ancestors []*mux.Route) error {
		fmt.Println(route.GetPathRegexp())
		fmt.Println(route.GetHostTemplate())
		fmt.Println(route.GetPathTemplate())
		fmt.Println(route.GetMethods())
		return nil
	})

rpromyshlennikov

Create user to run 3proxy

sudo adduser --system --no-create-home --disabled-login --group proxy3

Clone and build

git clone [email protected]:z3APA3A/3proxy.git
cd 3proxy
make -f Makefile.Linux

rpromyshlennikov

• wget https://github.com/pgmodeler/pgmodeler/archive/v0.9.1.zip
• unzip v0.9.1.zip
• mv pgmodeler-0.9.1/ pgmodeler
• cd pgmodeler/
• sudo apt install qt5-default libpq-dev libxml2-dev qttools5-dev-tools clang qt5-image-formats-plugins libqt5svg5 libqt5svg5-dev
• ./linuxdeploy.sh
• cd dist/
• tar -xzvf pgmodeler-0.9.1-linux64.tgz
• mv pgmodeler-0.9.1-linux64 /opt/pgmodeler/
• /opt/pgmodeler/pgmodeler-0.9.1-linux64/start-pgmodeler.sh

rpromyshlennikov

find /home/user/work/ -mindepth 1 -maxdepth 2 -type d -exec git -C {} fetch --all \;

rpromyshlennikov

GRANT CONNECT ON DATABASE "db-name" TO "user-name";
\c "db-name"; -- REQUIRED!!
GRANT USAGE ON SCHEMA "schema-name" TO "user-name";
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA "schema-name" TO "user-name";
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA "schema-name" TO "user-name";
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA "schema-name" TO "user-name";
GRANT ALL PRIVILEGES ON DATABASE "db-name" TO "user-name";


REVOKE USAGE ON SCHEMA "schema-name" FROM "user-name";

rpromyshlennikov

#!/usr/bin/env bash
set -e

xfce4-terminal -e 'env PROMPT_COMMAND="unset PROMPT_COMMAND;docker start <docker_id>" bash'
xfce4-terminal --tab -T nService \
-e 'env PROMPT_COMMAND="unset PROMPT_COMMAND; cd work_dir/nService; source ../prepare_env_.sh; make build && ./nService -console" bash' \
--tab -T mService \
-e 'env PROMPT_COMMAND="unset PROMPT_COMMAND; cd work_dir/mService; source ../prepare_env_.sh; make build && ./mService -console" bash'

rpromyshlennikov

csv = []
var rows = document.querySelectorAll("table tr");
	
for (var i = 0; i < rows.length; i++) {
  var row = [], cols = rows[i].querySelectorAll("td, th");
  for (var j = 0; j < cols.length; j++) 
      row.push(cols[j].innerText);

  csv.push(row.join("|"));		
}

rpromyshlennikov

#!/usr/bin/env bash

# Released under MIT License
# Copyright (c) 2020 Rodion Promyshlennikov
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
# copies of the Software, and to permit persons to whom the Software is

rpromyshlennikov

find ~/work/go/ \( -name 'workspace.xml' -o -name 'misc.xml' \) -type f | xargs grep GOROOT | cut -d':'  -f 1 | grep -v old_repos | xargs sed -e 's/go1.\([0-9]\+\).\([0-9]\+\)/go1.15.7/g' | grep GOROOT
find ~/work/go/ \( -name 'workspace.xml' -o -name 'misc.xml' \) -type f | xargs grep GOROOT | cut -d':'  -f 1 | grep -v old_repos | xargs sed -i -e 's/go1.\([0-9]\+\).\([0-9]\+\)/go1.15.7/g'