Skip to content

Instantly share code, notes, and snippets.

@vparitskiy
vparitskiy / add-remove-public-read-s3.txt
Created March 28, 2024 10:49 — forked from anuragmathur1/add-remove-public-read-s3.txt
s3cmd examples to add and remove public-read access for s3 buckets, folders and objects within.
## You may choose to remove --recursive if is required only for the bucket or folder and not for objects within.
s3cmd setacl --acl-private --recursive s3://mybucket-name
s3cmd setacl --acl-private --recursive s3://mybucket-name/folder-name
s3cmd setacl --acl-private --recursive s3://mybucket-name/folder-name/object-name
s3cmd setacl --acl-public --recursive s3://mybucket-name
s3cmd setacl --acl-public --recursive s3://mybucket-name/folder-name
s3cmd setacl --acl-public --recursive s3://mybucket-name/folder-name/object-name
@vparitskiy
vparitskiy / report.sql
Last active January 12, 2024 13:50
pg table size report
SELECT schema_name,
relname,
pg_size_pretty(table_size) AS size,
table_size
FROM (SELECT pg_catalog.pg_namespace.nspname AS schema_name,
relname,
pg_relation_size(pg_catalog.pg_class.oid) AS table_size
FROM pg_catalog.pg_class
@vparitskiy
vparitskiy / blackd.service
Last active January 4, 2022 12:01 — forked from xgenvn/blackd.service
BlackD Formatter as service
# /etc/systemd/system/blackd.service
# sudo systemctl start blackd
# sudo systemctl enable blackd
# sudo systemctl status blackd
[Unit]
Description=Black Formatter Service
[Service]
# User=<user> # specify user if black[d] installed into local pythonpath
@vparitskiy
vparitskiy / mysql-docker.sh
Created February 22, 2021 11:12 — forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
@vparitskiy
vparitskiy / to_fixtures.py
Last active January 18, 2018 11:08
Dumps cascade deleted items to fixtures. Can be used to restore accidentally deleted item from the backup
from __future__ import unicode_literals
from django.apps import apps
from django.contrib.admin.utils import NestedObjects
from django.core import serializers
from django.core.exceptions import ObjectDoesNotExist
from django.utils.encoding import force_unicode
def restore(model, pk, srl_format='json'):
@vparitskiy
vparitskiy / request.py
Created November 14, 2017 01:04
get Django request everywhere using threading.local
# -*- coding: utf-8 -*-
import logging
from threading import local
from django.contrib.auth.models import AnonymousUser
_thread_locals = local()
logger = logging.getLogger(__name__)
@vparitskiy
vparitskiy / A slack_logger.py
Created July 20, 2017 18:31 — forked from DominikSerafin/01_info
Django Slack Logger
import requests
import json
import time
import math
from copy import copy
from django.conf import settings
from django.utils.log import AdminEmailHandler
from django.views.debug import ExceptionReporter
class SlackExceptionHandler(AdminEmailHandler):