Skip to content

Instantly share code, notes, and snippets.

View ansmirnov's full-sized avatar
📚
Open-endedness

Andrey Smirnov ansmirnov

📚
Open-endedness
23 followers · 54 following
View GitHub Profile
@ansmirnov
ansmirnov / linux-tc-example.sh
Created June 22, 2016 07:17
#!/bin/bash
speedUp=$1
speedDown=$2
# Удаление очередей
/sbin/tc qdisc del dev eth1 ingress
/sbin/tc qdisc del dev eth1 root handle 1:
# Ограничение скорости отдачи
@ansmirnov
ansmirnov / check_oper_id.py
Last active January 14, 2016 09:15
#!/usr/bin/python
# -*- coding: utf-8 -*-
__author__ = 'Andrey Smirnov'
__email__ = '[email protected]'
import requests
import json
import sys
@ansmirnov
ansmirnov / menta-regex-example.java
Created January 14, 2016 08:22
import java.util.*;
import java.lang.*;
import java.io.*;
import org.mentaregex.*;
import java.util.Arrays;
class Main {
public static void main (String[] args) throws java.lang.Exception {
String[] matches = match("aa11bb22", "/(\\d+)/g" );
System.out.println(Arrays.toString(matches));
@ansmirnov
ansmirnov / aboncnt.sh
Created January 13, 2016 18:14
#!/bin/bash
# aboncnt.sh <areaid> <status_code>
DB_USER=...
DB_PASS=...
DB_NAME=...
ADDRESS_PID=...
/bin/echo "SELECT count(DISTINCT c.id) FROM contract_parameter_type_2 as p INNER JOIN contract as c ON p.cid=c.id WHERE p.hid in (SELECT id FROM address_house WHERE areaid=$1) AND c.status = $2 AND p.pid=${ADDRESS_PID};" | /usr/bin/mysql --skip-column-names -u${DB_USER} -p${DB_PASS} ${DB_NAME}
@ansmirnov
ansmirnov / coursework_title.tex
Created January 13, 2016 17:39
\begin{titlepage}
\thispagestyle{empty}
\centerline{Министерство образования и науки РФ}
\centerline{РЫБИНСКИЙ ГОСУДАРСТВЕННЫЙ АВИАЦИОННЫЙ}
\centerline{ТЕХНИЧЕСКИЙ УНИВЕРСИТЕТ имени П. А. Соловьева}
\vfill
@ansmirnov
ansmirnov / diplom_title.tex
Created January 13, 2016 17:36
\begin{titlepage}
\thispagestyle{empty}
\begin{small}
\renewcommand{\baselinestretch}{1.0} % Полуторный интервал
\centerline{Министерство образования и науки РФ}
\centerline{Федеральное государственное бюджетное образовательное учреждение}
@ansmirnov
ansmirnov / CryptoGuardOrderManager.java
Created January 13, 2016 13:34
package ru.bitel.bgbilling.modules.tv.dyn.cryptoguard;
import java.net.*;
import java.text.*;
import java.util.*;
import java.io.*;
import javax.annotation.Resource;
import org.apache.log4j.Logger;
@ansmirnov
ansmirnov / prepare_tex.py
Created January 13, 2016 13:25
#!/usr/bin/python
# prepare_tex.py
import sys
import re
def cat(fn):
return open(fn, 'rt').read().replace('\\', '====')
def prepare_tex(fn):
@ansmirnov
ansmirnov / torblock.sh
Created June 6, 2015 11:52
iptables: Блокировка входящего TOR-трафика
#!/bin/bash
# Block Tor Exit nodes
IPTABLES_TARGET="DROP"
IPTABLES_CHAINNAME="TOR"
EXTERNAL_IP="xx.xx.xx.xx"
if ! iptables -L TOR -n >/dev/null 2>&1 ; then
/sbin/iptables -N TOR >/dev/null 2>&1
/sbin/iptables -A INPUT -p tcp -j TOR 2>&1
fi
@ansmirnov
ansmirnov / bg_clean_old_tables.sh
Last active August 29, 2015 14:22
BGBilling: удаление старых таблиц из базы данных
#!/bin/bash
# Andrey Smirnov <[email protected]>
# http://blog.ansmirnov.ru/2015/06/05/bgbilling-clean-old-tables/
MYSQL_USER='***'
MYSQL_PASS='***'
MYSQL_DB='bgbilling'
MODULE_ID=7
START_DATE="201503"