yogananda-muthaiah

CREATE EXTENSION IF NOT EXISTS "unaccent"

CREATE OR REPLACE FUNCTION slugify("value" TEXT)
RETURNS TEXT AS $$
  -- removes accents (diacritic signs) from a given string --
  WITH "unaccented" AS (
    SELECT unaccent("value") AS "value"
  ),
  -- lowercases the string
  "lowercase" AS (

yogananda-muthaiah

Go Cheat Sheet

Credits

Most example code taken from A Tour of Go, which is an excellent introduction to Go. If you're new to Go, do that tour. Seriously.

Go in a Nutshell

• Imperative language

yogananda-muthaiah

class SAPCloudIntegration:

    def __init__(self, session, api_endpoint, base64AuthString): 
        self.sess = session
        self.api_endpoint = api_endpoint
        self.base64AuthString = base64AuthString
        
        self.CSRF_Token = self.get_csrf_token()

        print(f"Token {self.CSRF_Token}")

yogananda-muthaiah

https://tools.ietf.org/pdf/rfc6750.pdf | RFC 6750 - The OAuth 2.0 Authorization Framework: Bearer Token Usage
https://blog.codeship.com/the-top-four-exception-tracking-services/?utm_campaign=Weekly%20Newsletters&utm_source=hs_email&utm_medium=email&utm_content=59985837&_hsenc=p2ANqtz-9eT2r5GjNRlu9O6bQSTDNEthAwMghv8ae5YEW698E8LMw1pGJ3dfWYt6GuaXH1JdBYuvsxZ7T_KEkRJ2b0XHz5X19A_g&_hsmi=59986787 | The Top Four Exception Tracking Services - via @codeship | via @codeship
https://about.mattermost.com/customer-stories/how-uber-uses-mattermost-to-enhance-enterprise-wide-communications/ | Why Uber switched from Slack to Mattermost for enterprise collaboration – Mattermost
https://github.com/aws/aws-lambda-go/tree/master/events | aws-lambda-go/events at master · aws/aws-lambda-go
https://courses.edx.org/dashboard | Dashboard | edX
https://github.com/dastergon/awesome-chaos-engineering | dastergon/awesome-chaos-engineering: A curated list of awesome Chaos Engineering resources.
http://blog.kubernetes.io/2018/01/kubernetes-

yogananda-muthaiah

#!/usr/bin/env python
import os, os.path, stat, sys, base64

# TOTP lib inlined
import time, hmac, base64, hashlib, struct


def pack_counter(t):
    return struct.pack(">Q", t)

yogananda-muthaiah

People

:bowtie:	😄 :smile:	😆 :laughing:
😊 :blush:	😃 :smiley:	☺️ :relaxed:
😏 :smirk:	😍 :heart_eyes:	😘 :kissing_heart:
😚 :kissing_closed_eyes:	😳 :flushed:	😌 :relieved:
😆 :satisfied:	😁 :grin:	😉 :wink:
😜 :stuck_out_tongue_winking_eye:	😝 :stuck_out_tongue_closed_eyes:	😀 :grinning:
😗 :kissing:	😙 :kissing_smiling_eyes:	😛 :stuck_out_tongue:

yogananda-muthaiah

To find the top SQL statements that have caused most block buffer reads:

Select buffer_gets, sql_text
    from v$sqlarea
    where buffer_gets > 10000
    order by buffer_gets desc;
    
    
To find the most frequently executed SQL:

yogananda-muthaiah

select
c.host, c.user_name, c.connection_status, c.transaction_id, s.last_executed_time,
round(s.allocated_memory_size/1024/1024/1024,2) as "Alloc Mem (GB)",
round(s.used_memory_size/1024/1024/1024,2) as "Used Mem (GB)", s.statement_string
from
m_connections c, m_prepared_statements s
where
s.connection_id = c.connection_id and c.connection_status != 'IDLE'
order by
s.allocated_memory_size desc

yogananda-muthaiah

select * from tables
select * from public.tables
SELECT * FROM SYS.M_TABLES

SELECT * FROM SYS.TABLES
SELECT * FROM SYS.TABLE_COLUMNS
SELECT * FROM SYS.VIEWS
SELECT * FROM SYS.SYNONYMS

yogananda-muthaiah

https://sandbox.webcomcpq.com/setup/api/v1/admin/tenant
https://sandbox.webcomcpq.com/setup/api/v1/admin/users/current/data
https://sandbox.webcomcpq.com/api/rd/v1/Core/RefreshSession
https://sandbox.webcomcpq.com/api/v1/TenantResourceConsumption/GetResourceConsumptionInfoForCurrentTenant?_=1561904316235
https://sandbox.webcomcpq.com/api/v1/TenantResourceConsumption/GetBusinessPerformance?_=1561904892298
https://sandbox.webcomcpq.com/setup/api/v1/admin/translations/translate
https://sandbox.webcomcpq.com/setup/api/v1/admin/products?offset=0&limit=10
https://sandbox.webcomcpq.com/setup/api/v1/admin/users/current/data
https://sandbox.webcomcpq.com/setup/api/v1/admin/users?offset=0&limit=10
https://sandbox.webcomcpq.com/setup/api/v1/admin/permissionGroups?offset=0&limit=10