Skip to content

Instantly share code, notes, and snippets.

@dedecej
dedecej / arc.swift
Created October 6, 2017 08:58
Reference counting demo
import Foundation
// Retain count of object
var object = NSObject()
CFGetRetainCount(object)
let nextObject = object
----------------------------------- ANALYZA CHYBOVOSTI VZHLEDEM KE SLUŽBĚ ---------------------------------------
--> extrakce zasazene sluzby (`serviceName`) podle jeji domeny (`requestDomain`)
-- DATA_CENTER:
-- * EU (eu1.concursolutions.com): cetnost statuscodes a errorrate kodu 500 dle service_name v REQUEST v EU domene pro vsechny entity za celou dobu
-- * US (www.concursolutions.com): cetnost statuscodes a errorrate kodu 500 dle service_name v REQUEST v US domene pro vsechny entity za celou dobu
SELECT UPPER((SPLIT_PART(REQUESTPATH, '/', 3))) AS SERVICE_NAME
, COUNT(*) AS COUNT_ALL
, COUNT(CASE WHEN STATUSCODE = 200 THEN 1 ELSE NULL END) AS COUNT_200