zagorulkinde’s gists

zagorulkinde / sql_solution.sql

Created September 9, 2023 16:44

	--
	-- PostgreSQL database dump
	--

	-- Dumped from database version 13.1
	-- Dumped by pg_dump version 13.1


	--
	-- TOC entry 17 (class 2615 OID 214191)

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}'

zagorulkinde / gist:9fd48224fc4c2706c6ae29e7544a9980

Created April 27, 2019 19:57

dmidecode

	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 / 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 / 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);
	}
	}

zagorulkinde / osm_postgis2.sql

Created March 29, 2017 13:44

	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 / 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),

zagorulkinde / python_swap

Created November 23, 2015 20:05

zagorulkinde / login.py

Created May 6, 2015 09:27

	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 / 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}

	'''