Skip to content

Instantly share code, notes, and snippets.

View ap-Codkelden's full-sized avatar
🏠
Working from home

Renat ap-Codkelden

🏠
Working from home
View GitHub Profile
@ap-Codkelden
ap-Codkelden / arch_news.py
Last active July 22, 2020 00:34
Check a date of last news at archlinux.org and compare it with saved
import re
import sys
import os.path
import datetime
import urllib.request
from os.path import expanduser
def get_news_page():
try:
@ap-Codkelden
ap-Codkelden / vim100.tex
Last active July 11, 2018 18:54
100 vim commands
\documentclass[9pt, notumble]{leaflet}
\usepackage{amssymb}
\usepackage[T1]{fontenc}
\usepackage[russian]{babel}
\usepackage[useregional]{datetime2}
\usepackage[utf8]{inputenc}
\usepackage{graphicx}
\usepackage{stix}
\usepackage{textcomp}
\usepackage[unicode=true,colorlinks=true]{hyperref}
# Based on https://gist.github.com/fernandoaleman/5083680
# Start the old vagrant
$ vagrant init ubuntu_saucy
$ vagrant up
# You should see a message like:
# [default] The guest additions on this VM do not match the install version of
# VirtualBox! This may cause things such as forwarded ports, shared
# folders, and more to not work properly. If any of those things fail on
@ap-Codkelden
ap-Codkelden / fail2ban-allstatus.sh
Created August 6, 2016 12:15 — forked from kamermans/fail2ban-allstatus.sh
Show status of all fail2ban jails at once
#!/bin/bash
JAILS=`fail2ban-client status | grep "Jail list" | sed -E 's/^[^:]+:[ \t]+//' | sed 's/,//g'`
for JAIL in $JAILS
do
fail2ban-client status $JAIL
done
@ap-Codkelden
ap-Codkelden / map.py
Last active October 9, 2016 10:49
Process map data from ATO map at infolight.org.ua
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# Process map data from ATO map
# map URL is:
# http://infolight.org.ua/thememap/karta-obstriliv-ta-boyovyh-diy-u-zoni-ato-second-edition
"""
The MIT License (MIT)
Copyright (c) 2016 Renat Nasridinov, <[email protected]>
@ap-Codkelden
ap-Codkelden / reestr_regex.py
Created November 18, 2016 00:14
Court view example
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import re
from os import scandir
import sys
reg_exp = re.compile('в (м.\s?[А-Я][а-яіїє]+?)\s.+(по\s+[А-Я][а-яіїє]+?\sшосе\,?\s?\d{1,2}[а-яіїє]?)')
@ap-Codkelden
ap-Codkelden / edrpou.py
Last active December 19, 2017 12:31
Check digit for EDRPOU code
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# edrpou.py
"""
Перевірка контрольних розрядів:
ЄДРПОУ
ІПН
ТРДПАУ
@ap-Codkelden
ap-Codkelden / icu_howto_md
Last active May 17, 2017 09:19
ICU How To
# Регистронезависимый LIKE в SQLite для кириллицы
Original is [here](https://medium.com/@eigenein/%D1%80%D0%B5%D0%B3%D0%B8%D1%81%D1%82%D1%80%D0%BE%D0%BD%D0%B5%D0%B7%D0%B0%D0%B2%D0%B8%D1%81%D0%B8%D0%BC%D1%8B%D0%B9-like-%D0%B2-sqlite-%D0%B4%D0%BB%D1%8F-%D0%BA%D0%B8%D1%80%D0%B8%D0%BB%D0%BB%D0%B8%D1%86%D1%8B-95e3e33e8ad)
При использовании `LIKE` или `ORDER BY` в SQLite с Unicode-символами может возникнуть проблема, связанная с неспособностью SQLite по умолчанию правильно воспринимать разные регистры одной и той же буквы:
sqlite> select "ы" like "ы";
1
sqlite> select "Ы" like "ы";
0
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# Copyright (c) 2017 Renat Nasridinov
# This software may be freely distributed under the MIT license.
# https://opensource.org/licenses/MIT The MIT License (MIT)
import argparse
import json
import os
@ap-Codkelden
ap-Codkelden / quotationreplace.vb
Last active September 13, 2017 11:56
Change straight quotes to curly quotes and vice versa
' Adapted to MSO 2016 with Windows-1251 solution from
' https://goo.gl/FwYgMp
Public Sub ToggleSmartQuotes()
Dim rCell As Range
Dim sText As String
Dim sPattern1 As String
Dim sPattern2 As String
sPattern1 = "*[" & Chr(34) & Chr(39) & "]*"