vyach-vasiliev

@echo off

net session >nul 2>&1
if %errorlevel% neq 0 (
    echo Requesting administrative privileges...
    powershell -Command "Start-Process '%~f0' -Verb RunAs"
    exit /b
)

wsl sudo fstrim --all; echo "Exit status: $?";

vyach-vasiliev

SELECT pg_size_pretty(sum(pg_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename)))::bigint) FROM pg_tables 
WHERE schemaname = 'yourschema'

vyach-vasiliev

export GITHUB_USER=user
export GITHUB_TOKEN=secret
export GITHUB_REPOSITORY=owner/repo-path
git clone https://${GITHUB_USER}:${GITHUB_TOKEN}@github.com/${GITHUB_REPOSITORY}

# or
git clone ${GITHUB_TOKEN}@github.com/{GITHUB_REPOSITORY}.git

vyach-vasiliev

Semantic Commit Messages

See how a minor change to your commit message style can make you a better programmer.

Format: <type>(<scope>): <subject>

<scope> is optional

Example

vyach-vasiliev

from django.contrib import admin
from django import forms

class MyModelAdmin(admin.ModelAdmin):
    # ...
    def get_form(self, request, obj=None, **kwargs):
        form_factory = super(MyModelAdmin, self).get_form(request, obj, **kwargs)
        form_factory.base_fields['my_custom_field'] = forms.CharField(widget=forms.Textarea(), required=True)
    # ...
    def save_model(self, request, obj, form, change):

vyach-vasiliev

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

vyach-vasiliev

export function funci() {
    return "AHH HHHHAAA";
}

vyach-vasiliev

#!/bin/bash

pip freeze --local >pipfreeze.txt
pip install --upgrade --force-reinstall -r pipfreeze.txt


# second variant
#apt-get install libxml2-dev libssl-dev libffi-dev libxslt1-dev python-dev libjpeg-dev
#pip freeze --local >pipfreeze.txt
#tr '\n' ' ' < pipfreeze.txt >pipfreeze2.txt

vyach-vasiliev

### 1: Drop invalid packets ###
/sbin/iptables -t mangle -A PREROUTING -m conntrack --ctstate INVALID -j DROP

### 2: Drop TCP packets that are new and are not SYN ###
/sbin/iptables -t mangle -A PREROUTING -p tcp ! --syn -m conntrack --ctstate NEW -j DROP

### 3: Drop SYN packets with suspicious MSS value ###
/sbin/iptables -t mangle -A PREROUTING -p tcp -m conntrack --ctstate NEW -m tcpmss ! --mss 536:65535 -j DROP

### 4: Block packets with bogus TCP flags ###

vyach-vasiliev

    ## Block SQL injections
    set $block_sql_injections 0;
    if ($query_string ~ "union.*select.*\(") {
        set $block_sql_injections 1;
    }
    
    if ($query_string ~ "union.*all.*select.*") {
        set $block_sql_injections 1;
    }