Skip to content

Instantly share code, notes, and snippets.

View padak's full-sized avatar

Petr Simecek padak

25 followers · 4 following
View GitHub Profile
@padak
padak / keybase.md
Created December 7, 2018 21:15

Keybase proof

I hereby claim:

  • I am padak on github.
  • I am padak (https://keybase.io/padak) on keybase.
  • I have a public key ASCDsURWc4N4Bu6wU7TcWSChEcMVxqlCutXG_0CnybPJ-Qo

To claim this, I am signing this object:

@padak
padak / run_00_sap_erp_scheduler.sh
Created November 21, 2018 07:35
## Run
curl -X "POST" "https://syrup.eu-central-1.keboola.com/orchestrator/orchestrations/12564592/jobs" \
-H 'x-storageapi-token: 154-3963-xxx' \
-H 'Content-Type: application/json'
@padak
padak / weather.json
Created August 14, 2018 12:34
{"latitude":37.8267,"longitude":-122.423,"timezone":"America/Los_Angeles","currently":{"time":1534250042,"summary":"Mostly Cloudy","icon":"partly-cloudy-night","nearestStormDistance":3,"nearestStormBearing":226,"precipIntensity":0,"precipProbability":0,"temperature":55.72,"apparentTemperature":55.72,"dewPoint":54.05,"humidity":0.94,"pressure":1013.03,"windSpeed":5.41,"windGust":9.62,"windBearing":227,"cloudCover":0.81,"uvIndex":0,"visibility":9.99,"ozone":301.96},"minutely":{"summary":"Mostly cloudy for the hour.","icon":"partly-cloudy-night","data":[{"time":1534250040,"precipIntensity":0,"precipProbability":0},{"time":1534250100,"precipIntensity":0,"precipProbability":0},{"time":1534250160,"precipIntensity":0,"precipProbability":0},{"time":1534250220,"precipIntensity":0,"precipProbability":0},{"time":1534250280,"precipIntensity":0,"precipProbability":0},{"time":1534250340,"precipIntensity":0,"precipProbability":0},{"time":1534250400,"precipIntensity":0,"precipProbability":0},{"time":1534250460,"precipIntensi
@padak
padak / info.md
Last active April 2, 2019 17:53

Goal

Dynamically generate list of consecutive dates.

Usecase

List of dates can be joined to sparse time series data. Having generated dates (fully covered your MIN(orderDate) TO MAX(orderDate) interval) left joined with (i.e.) Orders produce backfilled dates.

Strategy

@padak
padak / ddd-in-snowflake.sql
Created June 28, 2018 21:04
/* tohle vygeneruje číselnou řadu 7500 čísel, které pak přičtu k poslednímu datumu
*/
CREATE TABLE "sekvence" AS
SELECT seq2() + 1 AS "seq"
FROM table(generator(rowcount => 7500));
/* tohle mi vezme poslední datum statistik, odečte to -33 dní (abych měl řadu co je určitě od začátku měsíce, a pak k
tomu přičte číslo z řady (joinuju to jako kartézák - jedno datum se všema 70 číslama) - takže mám řadu datumů
33 dní dozadu a od toho 70 dní dopředu
*/
@padak
padak / _zadani.md
Last active March 13, 2018 10:31

Podívej se na tabulku pva_pohovor a spočítej sumu value, ale jen pro objednávky, které neobsahují produkt typu (itemtype) 'Z'. Jde to bez vnoženého SELECTu! Čili ne takto:

SELECT orderid,
       sum(value)
FROM pva_pohovor
WHERE orderid NOT IN
    (SELECT orderid
 FROM pva_pohovor
@padak
padak / hash_over_films.csv
Last active March 12, 2018 19:45
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 8 columns, instead of 1. in line 7.
TITLE,COUNTRY,DURATION,TITLE_COUNTRY_DURATION,HASH(TITLE),HASH(COUNTRY),HASH(DURATION),HASH(TITLE||'-'||COUNTRY||'-'||DURATION)
Cannibal Holocaust,New Zealand,98,Cannibal Holocaust-New Zealand-98,-1601204309656643272,2036112869232829833,7338918106602415339,5288839991858621185
I Spit on Your Grave,Ireland,122,I Spit on Your Grave-Ireland-122,3014945125397368830,-6971372092926158838,3392492876407035749,-8150979255504859178
I Spit on Your Grave,Ireland,77,I Spit on Your Grave-Ireland-77,3014945125397368830,-6971372092926158838,-5980709635818720242,-8258666183221233039
Sweetness of Spirit - Halawet Rooh,Egypt,121,Sweetness of Spirit - Halawet Rooh-Egypt-121,8164173066761965620,1751424115462514396,5726818838546094492,-8073959077440497528
Noah,Indonesia,109,Noah-Indonesia-109,1092035266774786189,-1921382501271571452,-6314821653280887795,-8083143972931148564
The Raid 2: Berandal,Malaysia,151,The Raid 2: Berandal-Malaysia-151,-303945063906681582,-6022003878452176079,8419243739902537123,6573197503826478207
High School
@padak
padak / orchestrator-response.json
Created March 9, 2018 21:56
[
{
"id": 599842,
"name": "Orch #1 - OK",
"crontabRecord": "0 0 * * *",
"createdTime": "2018-03-08T20:15:02+00:00",
"lastScheduledTime": null,
"nextScheduledTime": "2018-03-09T00:00:00+00:00",
"token": {
"id": "558",
@padak
padak / waiting_job.sql
Created March 1, 2018 15:45
select
DATE,
SUM(CNT) as daily_sum
FROM (
/* spusť jen tohle pro výpis projektů v konkrétní den sestupně podle počtu čekajících jobů */
SELECT
job_created::DATE as date,
project_id,
-- HOUR(job_created::timestamp) as hr,
COUNT(run_id) AS cnt
@padak
padak / slack_ex_generic.json
Last active February 16, 2018 11:23
{
"parameters": {
"api": {
"baseUrl": "https://slack.com/api/",
"authentication": {
"type": "url.query"
},
"query": {
"token": {
"attr": "#token"