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; |