turicas

turicas

turicas

#!/usr/bin/env python3
"""
Securely delete directories, making file recovery via software tools (testdisk, photorec, extundelete etc.)
impractical.

Per-file strategy:
1. Overwrite contents 3x (zeros, ones, random), writing at least MIN_OVERWRITE_BYTES even for small files
2. Truncate to 0 bytes
3. Rename to a random name (destroys original directory entry)
4. Unlink

turicas

postgres table sizes

The result will be like this:

 schema |                table                | row_estimate  | total_size | index_size | toast_size | table_size | table_size_ratio | avg_row_size | total_bytes | index_bytes | toast_bytes | table_bytes 
--------+-------------------------------------+---------------+------------+------------+------------+------------+------------------+--------------+-------------+-------------+-------------+-------------
 public | estabelecimento                     | 5.4933384e+07 | 17 GB      | 4901 MB    | 8192 bytes | 12 GB      |             0.72 |       332.22 | 18249842688 |  5139447808 |        8192 | 13110386688
 public | empresa                             |  5.211064e+07 | 9883 MB    | 3985 MB    | 8192 bytes | 5898 MB    |             0.60 |       198.87 | 10363297792 |  4178649088 |        8192 |  6184640512

turicas

# pip install xlrd
import argparse
import csv
from functools import lru_cache
from pathlib import Path

import xlrd


@lru_cache(maxsize=64 * 1024)

turicas

#!/usr/bin/env python
# coding: utf-8

class AttrDict(object):
    def __init__(self, init=None):
        if init is not None:
            self.__dict__.update(init)

    def __getitem__(self, key):
        return self.__dict__[key]

turicas

Python versions in Debian, Ubuntu, Fedora, AlmaLinux and Alpine Linux official Docker images

The table below was made by installing the package python3 in each Docker image and then running python --version (see the python-versions.sh for more details). Release and end of life dates were taken from:

• Debian releases
• Ubuntu releases
• Fedora releases and end of life
• AlmaLinux releases
• Alpine Linux

turicas

turicas

# pip install python-keycloak
import os

from keycloak import KeycloakAdmin
from keycloak.exceptions import KeycloakGetError


server_url = "http://keycloak:8080/auth/"
admin_username = "admin"
admin_password = "admin"

turicas

import argparse
import os
import sys
from http.client import HTTPResponse
from urllib.error import HTTPError
from urllib.parse import urlencode
from urllib.request import Request, urlopen


def send_telegram_message(token: str, chat_id: int, message: str, parse_mode: str, timeout: float) -> HTTPResponse: