You're browsing snippets anonymously. Log in or create an account to save and manage your own snippets.

Public Snippets

Showing 13 snippets

Django Query Stats per request

# stats.py
import time

from django.db import connection
from loguru import logger

class StatsMiddleware:
    def __init__(self, get_response):
        self.get_response = get_response

def __call__(self, request):
        """Capture stats about each request
        """
        start_time = time.time()

# Needed in upper environments to get the SQL queries stats
        # Otherwise only works when DEBUG="true"
        connection.force_debug_cursor = True

queries_before = len(connection.queries)
        response = self.get_response(request)
        queries_after = len(connection.queries)

duration = time.time() - start_time

num_queries = queries_after - queries_before

try:
            total_query_time = sum(float(query["time"]) for query in connection.queries)
            logger.info(
                f"Time taken: {duration * 1_000:.2f} ms, "
                f"SQL queries executed: {num_queries}, "
                f"Total query time: {total_query_time * 1_000:.2f} ms",
                num_queries=num_queries,
                duration=duration,
                total_query_time_ms=int(total_query_time * 1_000),
                request_body=request.body.decode("utf-8"),
                request_method=request.method,
                request_path=request.path,
            )

# Add some stats to the header so that we can see them in the clients
            response["X-Response-Time-ms"] = int(duration * 1_000)
            response["X-Total-Queries-Time-ms"] = int(total_query_time * 1_000)
            response["X-Total-Queries"] = num_queries

except Exception:
            # Never expect this to have an exception
            # but better to catch and log, rather then breaking the response
            logger.exception("Error logging request stats")

return response

Python Public

# stats.py
import time

from django.db import connection
from loguru import logger


class StatsMiddleware:
    def __init__(self, get_response):
        self.get_response = get_response

 ...

By xtream1101 • Created 2025-05-11 00:03 • Updated 2025-05-11 00:04

Reset default python log handlers

Python Public aws lambda logging

import logging

formatter = logging.Formatter('FOO: %(message)s')

root_logger = logging.getLogger()
root_logger.setLevel(logging.INFO)

# This is the key line that removes the double logging
...

By xtream1101 • Created 2025-03-02 15:43 • Updated 2025-03-04 18:33

Check if a server has strictsni enabled

Bash Public

curl -v -k https://1.2.3.4

By xtream1101 • Created 2025-02-13 20:52 • Updated 2025-02-28 14:13

Firefox hide tab bar

/* Source file https://github.com/MrOtherGuy/firefox-csshacks/tree/master/chrome/hide_tabs_toolbar_v2.css made available under Mozilla Public License v. 2.0
See the above repository for updates as well as full license text. */

/* This requires Firefox 133+ to work */

/* chrome/userChrome.css */

@media (-moz-bool-pref: "sidebar.verticalTabs"),
       -moz-pref("sidebar.verticalTabs"){
  #sidebar-main{
    visibility: collapse;
  }
}
@media (-moz-bool-pref: "userchrome.force-window-controls-on-left.enabled"),
       -moz-pref("userchrome.force-window-controls-on-left.enabled"){
  #nav-bar > .titlebar-buttonbox-container{
    order: -1 !important;
    > .titlebar-buttonbox{
      flex-direction: row-reverse;
    }
  }
}
@media not (-moz-bool-pref: "sidebar.verticalTabs"),
       not -moz-pref("sidebar.verticalTabs"){
  #TabsToolbar:not([customizing]){
    visibility: collapse;
  }
  :root[sizemode="fullscreen"] #nav-bar > .titlebar-buttonbox-container{
    display: flex !important;
  }
  :root:is([tabsintitlebar],[customtitlebar]) #toolbar-menubar:not([autohide="false"]) ~ #nav-bar{
    > .titlebar-buttonbox-container{
      display: flex !important;
    }
    :root[sizemode="normal"] & {
      > .titlebar-spacer{
        display: flex !important;
      }
    }
    :root[sizemode="maximized"] & {
      > .titlebar-spacer[type="post-tabs"]{
        display: flex !important;
      }
      @media (-moz-bool-pref: "userchrome.force-window-controls-on-left.enabled"),
        -moz-pref("userchrome.force-window-controls-on-left.enabled"),
        (-moz-gtk-csd-reversed-placement),
        (-moz-platform: macos){
        > .titlebar-spacer[type="post-tabs"]{
          display: none !important;
        }
        > .titlebar-spacer[type="pre-tabs"]{
          display: flex !important;
        }
      }
    }
  }
}

CSS Public

/* Source file https://github.com/MrOtherGuy/firefox-csshacks/tree/master/chrome/hide_tabs_toolbar_v2.css made available under Mozilla Public License v. 2.0
See the above repository for updates as we...

By xtream1101 • Created 2025-02-27 21:28 • Updated 2025-02-27 21:45

Get domain cert details in cli

Bash Public ssl cert cli

DOMAIN=yourdomain.tld
echo | openssl s_client -showcerts -servername $DOMAIN -connect $DOMAIN:443 2>/dev/null | openssl x509 -inform pem -noout -text

By xtream1101 • Created 2025-02-12 19:48 • Updated 2025-02-12 19:48

List mounted drives

Bash Public linux

df -h --output=target,size,used,avail,pcent,source | grep -e Mounted -e $1 |  awk 'NR<2{print $0;next}{print $0| "sort"}'

By xtream1101 • Created 2025-02-08 19:15 • Updated 2025-02-08 22:44

Django graphene mutation input validation

import graphene

class ScratchpadMutation(graphene.relay.ClientIDMutation):
    class Input:
        created_by = graphene.String(required=True)
        foobar = graphene.String()

test = graphene.String()
    test2 = graphene.String()

@classmethod
    def validate_created_by(cls, value: str) -> str:
        if "foo" in value:
            raise ValueError("No foo's allowed")
        return value.strip().upper()

@classmethod
    def validate_combinations(cls, input: dict) -> dict:
        if input.get("created_by") == "TEST" and input.get("foobar") == "TEST":
            raise ValueError("Cannot have both created_by and foobar as TEST")

return input

@classmethod
    def validate_inputs(cls, input: dict) -> dict:
        validated_inputs = input.copy()
        for key, value in input.items():
            validation_method = f"validate_{key}"
            # Check if the method exists and run if so
            if hasattr(cls, validation_method):
                method = getattr(cls, validation_method)
                validated_inputs[key] = method(value)

# Run other validations on all the inputs after the pre-validate/cleaning
        validated_inputs = cls.validate_combinations(validated_inputs)

return validated_inputs

@classmethod
    def mutate_and_get_payload(cls, root, info, **input):
        # Need to update since not all fields may have a validation method
        input = cls.validate_inputs(input)
        
        # do somthing with the inputs here
        
        return ScratchpadMutation(
            test=input.get("created_by"), test2=input.get("foobar")
        )

Python Public django graphene graphql validation

import graphene

class ScratchpadMutation(graphene.relay.ClientIDMutation):
    class Input:
        created_by = graphene.String(required=True)
        foobar = graphene.String()

    test = g...

By xtream1101 • Created 2025-02-06 14:13 • Updated 2025-02-06 14:13

Try, try again - Multiple try/except blocks in a flat format

Python Public exceptions

data = {'some_key': 'key value'}
key_data = None
for _ in range(1):
    try:
        key_data = data['someKey']
    except Exception: pass
    else: break  # It worked

    try:
        key_d...

By xtream1101 • Created 2025-02-06 13:35 • Updated 2025-02-06 13:43

Multi key sort on a list of dicts

Python Public sorting

data = [
    {'name': 'Alice', 'age': 25, 'city': 'New York'},
    {'name': 'Bob', 'age': 30, 'city': 'London'},
    {'name': 'Charlie', 'age': 20, 'city': 'New York'}
]

# Sort by 'city' first,...

By xtream1101 • Created 2025-02-06 13:16 • Updated 2025-02-06 13:27

Convert image to dxf file

Bash Public

inkscape --export-type=dxf my-image.svg

By xtream1101 • Created 2025-02-06 05:18 • Updated 2025-02-06 05:18

Clean up empty dirs

Bash Public linux

# List/print empty dirs (does not delete)
find /mnt/my-data/ -type d -empty -print

# Delete empty dirs
find /mnt/my-data/ -type d -empty -delete

By xtream1101 • Created 2025-02-06 05:15 • Updated 2025-02-06 05:15

Bash command test

Bash Public

# Access individual arguments
echo "The first argument is: $1"
echo "The second argument is: $2"

# Access all arguments
echo "All arguments: $@"

# Access the number of arguments
echo "Number...

By xtream1101 • Created 2025-02-06 05:13 • Updated 2025-02-06 05:13

Python command test

Python Public

import sys

if __name__ == "__main__":
	print(f"args passed in: {sys.argv[1:]}")

By xtream1101 • Created 2025-02-06 05:12 • Updated 2025-02-06 05:12

Showing 13 snippets

Django Query Stats per request

# stats.py
import time

from django.db import connection
from loguru import logger

class StatsMiddleware:
    def __init__(self, get_response):
        self.get_response = get_response

def __call__(self, request):
        """Capture stats about each request
        """
        start_time = time.time()

# Needed in upper environments to get the SQL queries stats
        # Otherwise only works when DEBUG="true"
        connection.force_debug_cursor = True

queries_before = len(connection.queries)
        response = self.get_response(request)
        queries_after = len(connection.queries)

duration = time.time() - start_time

num_queries = queries_after - queries_before

return response

Python Public

Snippet

# stats.py
import time

from django.db import connection
from loguru import logger


class StatsMiddleware:
    def __init__(self, get_response):
        self.get_response = get_response

    def __call__(self, request):
        """Capture stats about each request
        """
        start_time = time.time()

        # Needed in upper environments to get the SQL queries stats
        # Otherwise only works when DEBUG="true"
        connection.force_debug_cursor = True

        queries_before = len(connection.queries)
        response = self.get_response(request)
        queries_after = len(connection.queries)

        duration = time.time() - start_time

        num_queries = queries_after - queries_before

        try:
            total_query_time = sum(float(query["time"]) for query in connection.queries)
            logger.info(
                f"Time taken: {duration * 1_000:.2f} ms, "
                f"SQL queries executed: {num_queries}, "
                f"Total query time: {total_query_time * 1_000:.2f} ms",
                num_queries=num_queries,
                duration=duration,
                total_query_time_ms=int(total_query_time * 1_000),
                request_body=request.body.decode("utf-8"),
                request_method=request.method,
                request_path=request.path,
            )

            # Add some stats to the header so that we can see them in the clients
            response["X-Response-Time-ms"] = int(duration * 1_000)
            response["X-Total-Queries-Time-ms"] = int(total_query_time * 1_000)
            response["X-Total-Queries"] = num_queries

        except Exception:
            # Never expect this to have an exception
            # but better to catch and log, rather then breaking the response
            logger.exception("Error logging request stats")

        return response

Description

Be sure to add it to your settings.py middleware

MIDDLEWARE = [
    # ...
    "my_app.stats.StatsMiddleware",
]

By xtream1101 • Created 2025-05-11 00:03 • Updated 2025-05-11 00:04