leshikus’s gists

leshikus / setup_wsl.sh

Created August 11, 2025 18:33

set env in wsl

	# specific settings go here

	export HTTPS_PROXY="$https_proxy"
	export EDITOR=vim

	cd
	export PS1="\[\033]0;$TITLEPREFIX:$PWD\007\]\n\[\033[32m\]\u@\h \[\033[35m\]$MSYSTEM \[\033[33m\]\w\[\033[36m\] `pwd -P`\[\033[0m\]\n$ "

	cat <<EOF >.vimrc
	syntax on

leshikus / 02933_group_by_memory_usage.sql

Created August 10, 2025 21:15

get info on specific test failures

select test_status, check_start_time from checks where test_status = 'FAIL' and test_name = '02933_group_by_memory_usage' and pull_request_number = 0 and check_start_time > now() - interval 2 month order by check_start_time desc;

leshikus / get_failed.sql

Last active August 10, 2025 13:30

Get failed ClickHouse tests

select test_name, count(test_name) from checks where test_status = 'FAIL' and pull_request_number = 0 and check_start_time > now() - interval 1 month group by test_name order by count(test_name) desc;

leshikus / soft-skills.txt

Created July 25, 2025 12:40

Soft skills video transcript

	00:00:00.080 такой человек, ну, как бы совсем ни разу
	00:00:02.320 не командный игрок. Его все хотят
	00:00:04.080 придушить. С другой стороны, ну, работа
	00:00:05.759 нужна. Не сойдётся с командой, команда
	00:00:07.680 не сойдётся с ним. С ним будет плохо
	00:00:09.440 работать, он не сможет вписаться. И это
	00:00:12.120 риски. Жун может быть
	00:00:14.080 приятным обобщении, а Синер токсичным,
	00:00:16.680 самоуверенным и вообще упырём. Там
	00:00:19.160 тонкая грань. Да ну его нафиг. Петя

leshikus / setup-grafana-kube.yaml

Created July 16, 2025 18:01

Setup grafana in kube

	---
	- name: Setup local Kubernetes cluster with Grafana
	hosts: localhost
	vars:
	arch: amd64
	cluster_name: kind-grafana
	kubectl_url: "https://dl.k8s.io/release/{{ lookup('url', 'https://dl.k8s.io/release/stable.txt') }}/bin/linux/{{ arch }}/kubectl"
	kind_url: "https://kind.sigs.k8s.io/dl/latest/kind-linux-{{ arch }}"
	helm_script_url: "https://raw.githubusercontent.com/helm/helm/main/scripts/get-helm-3"
	do_restart: true

leshikus / setup-grafana.yml

Last active July 16, 2025 12:13

Setup Grafana via Helm CLI

	---
	- name: Setup local Kubernetes cluster with Grafana
	hosts: localhost
	vars:
	arch: amd64
	cluster_name: kind-grafana
	kubectl_url: "https://dl.k8s.io/release/{{ lookup('url', 'https://dl.k8s.io/release/stable.txt') }}/bin/linux/{{ arch }}/kubectl"
	kind_url: "https://kind.sigs.k8s.io/dl/latest/kind-linux-{{ arch }}"
	helm_script_url: "https://raw.githubusercontent.com/helm/helm/main/scripts/get-helm-3"
	do_restart: false

leshikus / setup-kind-jupyterhub.yml

Created July 14, 2025 20:17

setup jupyterhub via kind

	---
	- name: Setup local Kubernetes cluster with JupyterHub
	hosts: localhost
	become: true
	vars:
	arch: amd64
	cluster_name: k8s-test
	kubectl_url: "https://dl.k8s.io/release/{{ lookup('url', 'https://dl.k8s.io/release/stable.txt') }}/bin/linux/{{ arch }}/kubectl"
	kind_url: "https://kind.sigs.k8s.io/dl/latest/kind-linux-{{ arch }}"
	helm_script_url: "https://raw.githubusercontent.com/helm/helm/main/scripts/get-helm-3"

leshikus / 47b.csv

Created April 18, 2025 16:18

quickfort pattern

We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 60 in line 1.

	#build start(15;15)
	Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,
	Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw, , , , , , , , , , , ,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,
	Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw, , , , , , , , , , , ,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,
	Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw, , , , , , , , , , , ,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,
	Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw, , , , , , , , , , , ,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,
	Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw,Cw, ,Cw, , , , , , , , , , , ,Cw,Cw,Cw,Cw,

leshikus / install-cluster.sh

Created April 4, 2025 07:54

Install multi-node k8s via kind locally

	#!/bin/sh

	set -e

	set_env() {
	arch=amd64
	cluster_name=k8s-test
	}

	install_exec() {

leshikus / plugin.py

Created August 20, 2024 20:48

a snipped from pytest_select plugin

	def pytest_collection_modifyitems(session, config, items):

	seen_test_names = set()
	for item in items:
	seen_test_names.add(item.name)
	seen_test_names.add(item.nodeid)

	selection_file_name = config.getoption("deselectfromfile")
	if selection_file_name is not None:

Alexei Fedotov leshikus