Skip to content

Instantly share code, notes, and snippets.

View akrisanov's full-sized avatar

Andrey Krisanov akrisanov

91 followers · 127 following
View GitHub Profile
@akrisanov
akrisanov / pgex.md
Last active April 7, 2022 20:43
Postgres Intro Exercises

Postgres Intro Exercises

Простые запросы

Задача #1

Кто летел позавчера рейсом Москва (SVO) — Новосибирск (OVB) на месте 1A, и когда он забронировал свой билет?

select t.passenger_name,
@akrisanov
akrisanov / profiling.md
Created August 28, 2020 13:31

pprof

$ go test -bench=. -benchmem -cpuprofile=cpu.out -memprofile=mem.out -x .

$ go tool pprof 13_pprof_console.test cpu.out

$ go tool pprof 13_pprof_console.test mem.out
@akrisanov
akrisanov / cURL.md
Created August 22, 2020 13:41
cURL Cheatsheet 
$ curl -I --http2 --insecure https://localhost:8080/
@akrisanov
akrisanov / formatting.md
Last active August 16, 2020 17:20
Go: Formatting

Основные флаги форматирования в Go

Общие

  • %v – представление по умолчанию для типа
  • %#v – вывести как Go код (удобно для структур)
  • %T – вывести тип переменной
  • %% - вывести символ %

Целые

@akrisanov
akrisanov / conftest1.py
Created May 4, 2020 18:19
Pytest Fixtures
import pytest
# Environment Variables
@pytest.fixture(autouse=True)
def env_setup(monkeypatch):
monkeypatch.setenv('MY_SETTING', 'some-value')
@akrisanov
akrisanov / ruby.md
Last active March 12, 2020 19:56
Ruby Resources
@akrisanov
akrisanov / gogc.md
Last active May 4, 2020 18:20
Go GC Resources
@akrisanov
akrisanov / sprint3_1.py
Last active April 18, 2023 17:45
Yandex.Praktikum 🍂
import pandas as pd
data = pd.read_csv("/datasets/visits.csv", sep="\t")
data['local_time'] = (
pd.to_datetime(data['date_time'], format='%Y-%m-%dT%H:%M:%S')
+ pd.Timedelta(hours=3)
)
data['date_hour'] = data['local_time'].dt.round('1H')
data['too_fast'] = data['time_spent'] < 60
data['too_slow'] = data['time_spent'] > 1000
@akrisanov
akrisanov / sprint_2_theme_3_task_3.py
Last active November 8, 2022 11:09
Yandex.Praktikum 🍂
import pandas as pd
stock = pd.read_csv('/datasets/stock_upd.csv')
stock['item_lowercase'] = stock['item'].str.lower()
apple = stock[stock['item_lowercase'].str.contains('apple')]['count'].sum()
samsung = stock[stock['item_lowercase'].str.contains('samsung')]['count'].sum()
stock['item_lowercase'] = stock['item_lowercase'].drop_duplicates()
stock = stock.dropna().reset_index(drop=True)
@akrisanov
akrisanov / options-ssl-nginx.conf
Created September 1, 2019 11:05
Let's Encrypt, Ruby on Rails 5.2, Content Security Policy and Nginx – Gist 2
# ...
add_header Strict-Transport-Security "max-age=15768000; includeSubdomains; preload;";
add_header Content-Security-Policy "default-src 'none'; frame-ancestors 'none'; script-src 'self'; img-src 'self'; style-src 'self'; base-uri 'self'; form-action 'self';";
add_header Referrer-Policy "no-referrer, strict-origin-when-cross-origin";
add_header X-Frame-Options SAMEORIGIN;
add_header X-Content-Type-Options nosniff;
add_header X-XSS-Protection "1; mode=block";