Skip to content

Instantly share code, notes, and snippets.

View zagorulkinde's full-sized avatar

zagorulkinde

View GitHub Profile
--
-- PostgreSQL database dump
--
-- Dumped from database version 13.1
-- Dumped by pg_dump version 13.1
--
-- TOC entry 17 (class 2615 OID 214191)
@zagorulkinde
zagorulkinde / dmidecode.sh
Last active April 29, 2019 17:02
Sum values in some column using awk (Find total installed RAM memory)
sudo dmidecode -t memory | grep Size: | sed -e 's/Size://g' | sed -e 's/ MB//g' | awk '{sum += $1} END {print sum}'
sudo dmidecode -t memory
# dmidecode 3.1
Getting SMBIOS data from sysfs.
SMBIOS 2.7 present.
Handle 0x0013, DMI type 16, 23 bytes
Physical Memory Array
Location: System Board Or Motherboard
Use: System Memory
Error Correction Type: Multi-bit ECC
@zagorulkinde
zagorulkinde / RestartingRunnableService.java
Created February 28, 2019 11:41
Restart runnable if error occurred and after deadline
private void start(Runnable consumer, long initialDelay, int step) {
LOG.info("launching consumer {} ...", consumer.getClass().getCanonicalName());
CompletableFuture<Object> promise = new CompletableFuture<>();
LOG.info("delayed with: {}", initialDelay + step);
scheduler.schedule(() -> promise.complete(null), initialDelay + step, TimeUnit.SECONDS);
// waiting when promise completes
CompletableFuture<Void> voidCompletableFuture = promise.thenRunAsync(consumer, executor)
.exceptionally((t) -> {
@zagorulkinde
zagorulkinde / java
Last active November 13, 2018 11:53
factorial as a stream
class StreamTest {
public static long factorial(long n) {
return LongStream.range(1, n+1).reduce(1, (a,b) -> a*b);
}
}
SELECT name, osm_id,
ST_Distance_Sphere(ST_Transform(way::geometry, 4326),ST_SetSRID(ST_MakePoint(47.217507, 56.113372), 4326)) as dist
FROM planet_osm_point WHERE ST_Distance_Sphere(ST_Transform(way::geometry, 4326), ST_SetSRID(ST_MakePoint(47.217507, 56.113372), 4326)) < 1500 limit 10;
SELECT points.name, points.dist, nodes.tags FROM
(SELECT name, osm_id, dist FROM
(SELECT name, osm_id, ST_Distance_Sphere(ST_Transform(way::geometry, 4326),
ST_SetSRID(ST_MakePoint(47.24982, 56.131380000000007), 4326)) AS dist
FROM planet_osm_point
WHERE ST_Within(ST_Transform(way::geometry, 4326),
@zagorulkinde
zagorulkinde / osm_postgis.sql
Last active March 29, 2017 11:59
postgis osm
SELECT name, osm_id,
ST_Distance_Sphere(ST_Transform(way::geometry, 4326),ST_SetSRID(ST_MakePoint(47.217507, 56.113372), 4326)) as dist
FROM planet_osm_point WHERE ST_Distance_Sphere(ST_Transform(way::geometry, 4326), ST_SetSRID(ST_MakePoint(47.217507, 56.113372), 4326)) < 1500 limit 10;
SELECT points.name, points.dist, nodes.tags FROM
(SELECT name, osm_id, dist FROM
(SELECT name, osm_id, ST_Distance_Sphere(ST_Transform(way::geometry, 4326),
ST_SetSRID(ST_MakePoint(47.24982, 56.131380000000007), 4326)) AS dist
FROM planet_osm_point
WHERE ST_Within(ST_Transform(way::geometry, 4326),
x = 1
y = 5
x ^= y
y ^= x
x ^= y
x = 5
y = 1
import re
from sys import argv
from time import time
class Login(object):
def __init__(self):
self.r = re.compile('^([a-z]|[a-z][a-z0-9-\.]{0,18}[a-z0-9])$', re.I)
self.charmap_min = ord('a')
self.charmap_max = ord('z')
self.charmap_min_dig = ord('0')
@zagorulkinde
zagorulkinde / lazy_zip
Created April 24, 2015 14:07
Python lazy zip gen
def zip_gen(list_key, list_value):
'''
>>> dict([(a,b) for (a,b) in zip_gen([1,2,3,4], ['a','b','c','d'])])
{1: 'a', 2: 'b', 3: 'c', 4: 'd'}
>>> dict([(a,b) for (a,b) in zip_gen([1,2], ['a','b','c','d'])])
{1: 'a', 2: 'b'}
>>> dict([(a,b) for (a,b) in zip_gen([1,2,3,4], ['a'])])
{1: 'a', 2: None, 3: None, 4: None}
'''