Create an initial repository following the instructions below.
initial_repo.sh
#!/usr/bin/env sh
#!/usr/bin/env sh | |
# alternative to: openvpn-update-resolv-conf: aur package | |
# I don't want to install a openvpn script to just handle dns entries for a VPN connection | |
# So, I created this script to do it | |
if ps ax | grep "openvpn --config" | grep "OPENVPN_CONFIG_PROVIDED_BY_COMPANY.ovpn" > /dev/null | |
then | |
echo "VPN CONNECTED" | |
echo "restoring resolv.conf..." | |
sudo sed -i '/DNS_SERVER_IP/d' /etc/resolv.conf |
# case you dont have $BROWSER env. var defined | |
$ xdg-settings set default-web-browser firefox-developer-edition.desktop | |
$ xdg-mime default firefox-developer-edition.desktop x-scheme-handler/http | |
$ xdg-mime default firefox-developer-edition.desktop x-scheme-handler/http |
curl -i -X POST -H "Content-Type: multipart/form-data" \ | |
-F "file=@/home/USERNAME/YOUR_FILE_HERE.xlsx \ | |
-F "param1=4" \ | |
-F "param2=CALCULATED" \ | |
-F "period=1" \ | |
-F "effective_date=2020-31-31" \ | |
http://localhost:8080/entrypoint_x | |
// See the polkit(8) man page for more information | |
// about configuring polkit. | |
// SAVE IT ON: /etc/polkit-1/rules.d/ | |
// replace the ntfs-3g package: ntfs-3g-fuse | |
// Allow udisks2 to mount devices without authentication | |
// for users in the "wheel" group. | |
polkit.addRule(function(action, subject) { | |
if ((action.id == "org.freedesktop.udisks2.filesystem-mount-system" || | |
action.id == "org.freedesktop.udisks2.filesystem-mount") && |
This changes the postgresql idle connection timeout on Azure Postgres: ref: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/connection-handling-best-practice-with-postgresql/ba-p/790883
$ psql -h HOST -p 5432 -U USER DBNAME --set=sslmode=require
# to perform a dump with only the Data, not the schema ( using SSL) | |
$ PGSSLMODE=allow pg_dump -v -Fc --data-only -h HOST -p 5432 -U USERNAME DB_NAME --exclude-table-data NOT_THIS_TABLE > testing-data-only.sql | |
# to restore the dump | |
$ pg_restore -h localhost -p 5432 -U USERNAME -d DB_NAME < testing-data-only.sql |
# You should add the line | |
# `stdin_open: true` and | |
# `tty: true` on your docker-compose file. | |
# Then, just add the `__import__("ipdb").set_trace()` as | |
# usually you do in your python code. | |
version: "3" | |
services: | |
app_tests: | |
build: . |
from __future__ import with_statement | |
import sys,os | |
from logging.config import fileConfig | |
from sqlalchemy import engine_from_config | |
from sqlalchemy import pool | |
from alembic import context | |
sys.path.insert(0, os.path.dirname(os.path.dirname(__file__))) |
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM username; | |
REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public FROM username; | |
REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public FROM username; | |
DROP USER username; | |
DROP ROLE username; |