anonrig

SELECT 
"SubscriberID",
"StandardSubscriptionDuration" as "SubscriptionDuration",
MIN("EventDate") as "FirstTransaction", 
MAX("EventDate") as "LastTransaction",
"ApplicationId",
CASE 
WHEN MAX("EventDate") BETWEEN LOCALTIMESTAMP - ("StandardSubscriptionDuration")::interval AND LOCALTIMESTAMP THEN true ELSE false
END AS "isActive"
FROM "Subscriptions"

ezy

# Replace <sentry_key>, <sentry-url> and <project-id> to formulate your CURL request. Don't forget to add a trailing slash to URL otherwise you'll get wierd CSRF errors!

curl -X POST --data '{ "exception": [{ "type": "$ErrorMessage"}] }' -H 'Content-Type: application/json' -H "X-Sentry-Auth: Sentry sentry_version=7, sentry_key=<sentry_key>, sentry_client=raven-bash/0.1" https://<sentry-url>/api/<project-id>/store/

JamalK

#!/usr/bin/env swift

//swiftc facetime_cli.swift -o facetime_cli
// sudo cp facetime_cli /usr/bin
// Enjoy! usage: facetime_cli $PHONE_NUMBER or $APPLE_ID

import Foundation
import Cocoa

extension Array {

hogelog