Skip to content

Instantly share code, notes, and snippets.

View hpgsantos's full-sized avatar
💭
coding

Henrique Pires hpgsantos

💭
coding
View GitHub Profile
@hpgsantos
hpgsantos / sql_hacks.md
Last active January 14, 2020 22:26
SQL hakcs

Vanilla

  --- Common table expression on the fly
  WITH cte_usuario AS (
    SELECT * FROM (
      VALUES  (1,GETDATE(),'Pessoa 1')
      ,       (2,GETDATE(),'Pessoa 2')
    ) a(id,created_at,name)
  ) SELECT * FROM cte_usuario CTU
dev_install () {
yum -y update
yum -y upgrade
yum install -y \
wget \
gcc \
gcc-c++ \
openssl \
python27-devel \
python27-virtualenv \

Look in node_modules global for exisint paths

build_command_lambda_local=$(getPathFromModulesNode mongoose,express,mongoose)
echo $build_command_lambda_local 

Recover global dir for node_modules

{
"keys": [
{
"kty": "RSA",
"alg": "RS256",
"use": "sig",
"kid": "27819fd1-d87b-4a72-b7e5-de2f737b1557",
"n": "t_Lr4yTiQU_JAmIWOzXv9KgQrIMGxelLRgfSxN-OUSjkljMGIe82flhLNyy9V27SFMIZZve2b0rIVdNZpqCbanULIvM3FgHZKXM19eFxX0WZseH2DM-KQq0f-NwYQBvDVi3FEhUdx2VxEjR5Qa3GBhbL72MMoLgawsjeArWrM21bgdoP_07hFrxkaCQl3yzcvVpnFIzCHWdiBcYvO0xsTnmtJCupEYCsNfeaH3seDqyPlkEr0vrWIwCN2Y33jn7dAbFJ0ljUjTsvLKFvmF26P2RpNhFXjQ__Q6y_mzCKprKa2MF8M4-mXZYtYIPA_3JPmohk1uMnqze3Bk_dKn4V_w",
"e": "AQAB"
}