Flackus’s gists

Flackus / procedures_solution.sql

Last active January 10, 2022 18:01

procedures_solution.sql

	use test;

	drop table if exists words;

	create table words (id int primary key auto_increment, adjective varchar(100) not null, noun varchar(100) not null);
	insert into words (adjective, noun) values
	("hot", "dog"),
	("fast", "banana"),
	("orange", "cloud"),
	("charming", "curtain"),

Flackus / gnuplot

Created March 30, 2016 13:56

	#!/usr/bin/env bash

	echo "set terminal png;\
	set datafile separator \",\";\
	set ylabel \"Mb\"; \
	set yrange [0:2000]; \
	plot \"mem.log\" using (\$0+1):(\$2/1000000) smooth csplines with line title \"rss\", \
	\"mem.log\" using (\$0+1):(\$3/1000000) smooth csplines with line title \"heapTotal\", \
	\"mem.log\" using (\$0+1):(\$4/1000000) smooth csplines with line title \"heapUsed\" \
	" \| gnuplot -p > out.png

Flackus / find-port.js

Last active February 3, 2016 18:13

Find unused port in node.js

	#!/usr/bin/env node
	'use strict';
	const net = require('net');
	const server = net.createServer();
	let port;

	server.listen(0, () => {
	port = server.address().port;
	server.once('close', () => {
	console.log(`Found unused port: ${port}`);

Flackus / gist:4614277

Created January 23, 2013 21:57

	Процессор: Core2 Duo E6850 @ 3.00 GHz
	Материнка: Gigabyte P35-S3G (Socket 775)
	Оперативка: 4,00 ГБ Dual-Channel DDR2 @ 399MHz
	Видео: GeForce 8800GT
	Винты:
	* Western Digital WD10EADS 1Tb
	* Seagate ST3750640AS 750Gb
	DVD-RW: LG GH22NP20
	Аудио: Intel HD Audio (лень смотреть какой, не используется)
	Корпус: лень искать, чёрный короче, модный до омерзения

Flackus / gist:4508973

Last active December 10, 2015 23:19

Вишлист

Flackus / dabblet.css

Created July 17, 2012 15:36 — forked from anonymous/dabblet.css

реализовать анимированную

	/*
	реализовать анимированную
	навигацию по div.a1
	без перезагрузки страницы
	с поддержкой истории послещений

	http://clck.ru/d/nEyP0z8x143w5
	*/
	body
	{

Flackus / new.sh

Created February 28, 2012 11:31

okay

	#!/bin/bash

	logfile=logfile.txt

	{
	echo -e "Текущее время:\n`date`"
	echo -e "\nПользователи в системе:\n`who`"
	echo -e "\nТекущий аптайм:\n`uptime`"
	} > "$logfile"

Flackus / exc.js

Created November 20, 2011 18:36

Exceptions

Flackus / hierarchy-from-flat.xsl

Created March 1, 2011 16:14

Nested list from flat tree

	<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" indent="yes"/>
	<xsl:strip-space elements="*"/>

	<xsl:template match="node() \| @*">
	<xsl:copy>
	<xsl:apply-templates select="node() \| @*"/>
	</xsl:copy>
	</xsl:template>

Flackus / reverse-xml.xsl

Created March 1, 2011 16:10

XML Reverser

	<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:output method="xml" indent="yes" omit-xml-declaration="yes"/>

	<!-- Паттерн на все элементы -->
	<xsl:template match="*">
	<!-- Реверсим локальную часть имени -->
	<xsl:variable name="thisName">
	<xsl:call-template name="checkNCName">
	<xsl:with-param name="string" select="local-name()"/>
	</xsl:call-template>

Alex Rybakov Flackus