Skip to content

Instantly share code, notes, and snippets.

View skalahonza's full-sized avatar

Jan Skála skalahonza

View GitHub Profile
@skalahonza
skalahonza / add_ssh_cert.sh
Created May 13, 2020 13:37
Add public SSH certiphicate to remote host
cat ~/.ssh/id_rsa.pub | ssh user@hostname 'cat >> .ssh/authorized_keys'
@skalahonza
skalahonza / TableRowsCount.sql
Created April 30, 2020 06:42
Get row count for all tables
SELECT
QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName]
, SUM(sPTN.Rows) AS [RowCount]
FROM
sys.objects AS sOBJ
INNER JOIN sys.partitions AS sPTN
ON sOBJ.object_id = sPTN.object_id
WHERE
sOBJ.type = 'U'
AND sOBJ.is_ms_shipped = 0x0
@skalahonza
skalahonza / tosjon.ps1
Created March 4, 2020 14:08
Converts PowerShell object to JSON. Prevents default PowerShell escaping that breaks the JSON syntax.
# Convert to json string - prevent default powershell escaping
$templateOut = $template | ConvertTo-Json -Depth 100 | ForEach-Object {
[Regex]::Replace($_,
"\\u(?<Value>[a-zA-Z0-9]{4})", {
param($m) ([char]([int]::Parse($m.Groups['Value'].Value,
[System.Globalization.NumberStyles]::HexNumber))).ToString() } ) }
@skalahonza
skalahonza / mem.cmd
Created November 25, 2019 14:33
Windows - get RAM memory info
wmic memorychip get devicelocator, manufacturer, partnumber, capacity, speed, memorytype, serialnumber
@skalahonza
skalahonza / Makefile
Created October 10, 2019 16:28
Makefile for automatic testing against the test data.
VALGRIND := "0"
SHELL := /bin/bash
CFLAGS+= -std=c++14 -O3
TESTS := $(shell ls data | grep .in | grep -Po '\d+' | sed ':a;N;$!ba;s/\n/\" \"/g' ; )
objects := $(patsubst %.c,%.o,$(wildcard *.cpp))
TESTOUTPUT = "tests/"
program: $(objects)
g++ -o program $(objects)
# ${CC} ${CFLAGS} -o program $(objects)
@skalahonza
skalahonza / Batchify.cs
Last active January 19, 2021 12:38
How to split huge payload into multiple batches
public static class IEnumerableExtensions
{
/// <summary>
/// Split source into batches of limited size
/// </summary>
/// <param name="limit">Batch size limit</param>
/// <returns></returns>
public static IEnumerable<T[]> Batchify<T>(this IEnumerable<T> source, int limit)
{
var batch = source.Take(limit).ToArray();

Odkazy na statnicove otazky na Dropboxu

Zdravím!

Níže najdete odkazy na jednotlivé státnicové otázky programu OI 2016. Odkazy vedou na Dropbox kde můžete doplňovat, komentovat atd.

Jak tisknout

V Dropbox Paper nahoře vpravo > ... > print. V nastavení tisku dejte další možnosti a dejte velikost na 80%, defaultní velikost je strašně velká. Taky doporučuji vypnout všehny informace v zápatí a záhlaví. Defaultně je tam URL, čas apod.

@skalahonza
skalahonza / RajceDownloader.ps1
Created April 27, 2019 09:39
Rajce.Net album downloader
# $url = "https://zapik86.rajce.idnes.cz/Zlata_sedesata_aneb_caj_o_pate_s_JGDIX"
# $folder = ".\Rajce"
function Download-RajceAlbum($url, $folder){
$data = Invoke-WebRequest -UseBasicParsing -Uri $url
$links = $data.Links | Where-Object {$_.href -ne $null -and $_.href.Contains("images")} | select -ExpandProperty href # | select -ExcludeProperty {"http://"+$_.substring(2)}
foreach ($link in $links) {
Write-Host $link
$splitted = $link.Split("/")
$name = $splitted[$splitted.Length-1]
@skalahonza
skalahonza / ExceptionMiddleware.cs
Created April 22, 2019 09:06
Middle for caching exceptions on .net core web API.
public class ErrorHandlingMiddleware
{
private readonly RequestDelegate _next;
public ErrorHandlingMiddleware(RequestDelegate next)
{
_next = next;
}
public async Task Invoke(HttpContext context)
@skalahonza
skalahonza / sm.hs
Last active January 3, 2019 14:59
State machine solving a language problem
-- http://math.feld.cvut.cz/demlova/teaching/jag/cjag812.pdf cviceni 12.1
automat :: String -> Bool
automat input = automat_h input 0 False
automat2 :: String -> Bool
automat2 input = automat_h2 input ['z'] 1
automat_h :: String -> Int -> Bool -> Bool
automat_h ('a':xs) count False = automat_h xs (count + 1) False