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 / efektivita_trasovani.sql
Created March 10, 2021 16:40
CREATE VIEW EFEKTIVITA_TRASOVANI AS
SELECT
RECORD_CREATED::DATE AS CREATED,
replace(split_part(QUEUE_NAME,']',1),'[','') AS KHS,
RECORD_ID AS POZITIVNI,
KONTAKT AS KONTAKT
FROM "CAMPAIGN_RECORDS_PII"
LEFT JOIN (
SELECT
REPLACE(REPLACE(FK_RECORD_ID,'["',''),'"]','') AS "POZITIVNI",
@padak
padak / hlidacshopu-yankee.sql
Last active November 28, 2019 22:19
SELECT
shop,
date,
itemId,
itemName,
itemUrl,
currentPrice
FROM
`hlidacshopu.hlidacshopu.allshops_uniq`
WHERE
@padak
padak / hlidac.json
Created November 5, 2019 12:47
[
{
"count_all": "16509",
"count_bf": "",
"declared_sale": "",
"key": "rohlik",
"percent_bf": "",
"real_sale": ""
},
{
@padak
padak / kbc_copy_cfgs.py
Created May 31, 2019 07:22
import subprocess
import sys
import json
subprocess.call([sys.executable, '-m', 'pip', 'install', 'git+https://github.com/keboola/sapi-python-client.git'])
from kbcstorage.base import Endpoint
sourceEndpoint = Endpoint('https://connection.keboola.com', 'components', 'xxx-yyyy-zzzzz')
destinationEndpoint = Endpoint('https://connection.keboola.com', 'components', 'aaa-bbbb-ccccc')
@padak
padak / wather.json
Created May 17, 2019 18:20
{
"latitude": 37.8267,
"longitude": -122.423,
"timezone": "America/Los_Angeles",
"currently": {
"time": 1558117094,
"summary": "Mostly Cloudy",
"icon": "partly-cloudy-day",
"nearestStormDistance": 5,
"nearestStormBearing": 211,
@padak
padak / oracle_fetch.sql
Created May 2, 2019 08:12
SELECT TABS.TABLE_NAME ,
TABS.TABLESPACE_NAME ,
TABS.OWNER ,
TABS.NUM_ROWS ,
COLS.COLUMN_NAME ,
COLS.DATA_LENGTH ,
COLS.DATA_PRECISION ,
COLS.DATA_SCALE ,
COLS.COLUMN_ID ,
COLS.DATA_TYPE ,
@padak
padak / peter_simecek_fips_yubico.key
Created April 24, 2019 19:35
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQDhvEcRs/sW1LKPCW2/nVx/xs2yUAe5QegP0jaqrEEbhAgXnqKBh1IIIOeEPY0NLT4iMT6jxAoKaHvpWr9nlcI4azRnk8wXLQhwlLnSPZpX0OnmvoOyg3tzWSesf7DN9O0/ecmOpC1JxI3j/yWDPU2aKLLM+sPsuRZd8XwB+DvKPQkSAb58pe1WYOIgchIOrf0SZ6pyVP4g3wR0R0YEvsaFExR4WccpOKYjDKhYsDFtoZL7tkuFD5ESzZ44bPNP2pREUqA9hi7OfDY757Vq3jNuDUEdrxQ/AYs711b7jXuLjBTdoEweGapW6qU8fk+lnQMgj2PfUBGxIYfV8NVDPC/kihtNAd2uiF31M7D0fBW6vyDdEzCE3Lcw4Fgff85ZAxHh/DGCLZuWRUuqzFwrawj/wxDYe5x+T89Kq/sJ3J3FThIDk2HksEnGSvbznVWW8FLhaAKsuq5aSLvN8pXq4/HFDapOmmTznkgKk7uA6qXN+97Xkx8wJJofE8oyCh8RW5S1bkzkELF548Ca/m2aFRZ7uOtZ5EMyTqnyo4bFj3qiD1sp0uzjaCQufQR7ei5MYCe+WsyjH3S2CvH7NhvD0j1K9lI1aC8N8erx7igE4hwLH6yXB1/KwvjGG8siTLS2kJwxw+OIe0TbdwHUbo0AXT/F4PHVMeP16onTL7QOGRiBMQ== cardno:000608603345
@padak
padak / snowflake_clone_fast_filter.sql
Created April 20, 2019 17:39
/* X days as a WHERE filter */
SET back = to_char(TIMEADD("hours", -240, CURRENT_DATE ()),'yyyy-mm-dd');
/* in this case, DATE_COL has `2017-08-10 13:05:20.395000` format */
CREATE TABLE "data_10days" AS
SELECT
*
FROM "big_table"
WHERE "DATE_COL" >= $back;
@padak
padak / keboola >$5 mo
Created March 12, 2019 19:11
S3
Lambda
Data Transfer
RDS
EC2
DynamoDB
ECR
API gw
R53
Config
@padak
padak / wework.md
Created December 12, 2018 16:07

"If, according to law, the services provided by us to you pursuant to this Agreement are at any time found to be exempt from VAT, then we will credit the VAT charged to you and collected by us. In addition, in such event, the membership fee charged to you will be retroactively increased by an amount equal to the VAT amount that is to be credited to you. Such credits and accompanying membership fee increase will offset each other and the total amount paid to us by you will remain the same."