Skip to content

Instantly share code, notes, and snippets.

View skalahonza's full-sized avatar

Jan Skála skalahonza

37 followers · 58 following
View GitHub Profile
@skalahonza
skalahonza / SapDateTime.cs
Created October 27, 2020 14:00
Logic Apps expression for converting SAP datetime format into YYYY-MM-DD
using System;
using System.Linq;
namespace PasswordAttack
{
static class Program
{
const string EXPRESSION = "replace(concat(take(items('For_each')?['DATAB'],4),'-',take(skip(items('For_each')?['DATAB'],4),2),'-',take(skip(items('For_each')?['DATAB'],6),2)),'0000-00-00','1753-01-01')";
@skalahonza
skalahonza / OdataDateTimeQuery.cs
Created June 16, 2020 12:56
Construct OData date time query that compares date time part by part. Suitable for Logic Apps SQL server with Data Gateway
private static string GreaterOrEqual(string first, string second, string part) =>
$"{part}({first}) ge {part}({second})";
private static string GreaterThan(string first, string second, string part) =>
$"{part}({first}) gt {part}({second})";
private static string Equal(string first, string second, string part) =>
$"{part}({first}) eq {part}({second})";
/// <summary>
@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();
@skalahonza
skalahonza / STATNICE.md
Last active September 30, 2025 19:50

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]