Skip to content

Instantly share code, notes, and snippets.

View julietaansola's full-sized avatar

Julieta Ansola julietaansola

View GitHub Profile
@julietaansola
julietaansola / urlParser.js
Created December 16, 2023 15:15
DevOps Engineer - Rotunda Software - Julieta Ansola
function extractVariables(urlFormat, urlInstance) {
// Input validation for string types
if (typeof urlFormat !== 'string' || typeof urlInstance !== 'string') {
throw new Error('Both URLs must be strings.');
}
// Split URLs into parts
const formatParts = urlFormat.split('/');
const instanceParts = urlInstance.split('/');
Estos querys creo q son los personalizados
/* QuickSight c428a729-2b98-457d-a02a-04fa82489efd */
SELECT *
FROM (
SELECT "transaction" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.transaction", "transaction_id" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.transaction_id", "transaction_date" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.transaction_date", "transaction_dia" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.transaction_dia", "transaction_hour" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.transaction_hour", "movement_tx" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.movement_tx", "movement_id" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.movement_id", "description_ok" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.description_ok", "amount" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.amount", "amount_abs" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.amount_abs", "is_qr" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.is_qr", "details" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.details", "origin_id" AS "08c4c336-917f-4f61-8afd-75b7a963d90f.origin_id", "ex
@julietaansola
julietaansola / devops_best_practices.md
Created May 17, 2021 15:41 — forked from jpswade/devops_best_practices.md
Devops Best Practices Checklist

Find the original here article here: Devops Best Practices

DevOps started out as "Agile Systems Administration". In 2008, Andrew Shafer did a talk called "Agile Infrastucture" addressing issues around involving more of the company in the same disciplines as programmers.

In 2009, Patrick Debois created "DevOpsDays" conference to help to bring it to light. However, it wouldn't begin to trend until about 2010, when people would begin to describe it as a standalone discipline.

Today, DevOps goes beyond just developers, systems administration and infrastructure, its about [dev, ops, agile, cloud

Keybase proof

I hereby claim:

  • I am julietaansola on github.
  • I am jansola (https://keybase.io/jansola) on keybase.
  • I have a public key ASAnoS_TbmJwTOUiQRg4WjGejmoqIgJDLyFVOz7vyojo6go

To claim this, I am signing this object:

@julietaansola
julietaansola / sql
Created April 23, 2021 17:24
vw_sellos_rewards
WITH tabla_dias AS (
SELECT dia.dia::date AS dia
FROM generate_series('2020-10-01'::date::timestamp with time zone, now()::date::timestamp with time zone, '1 day'::interval) dia(dia)
)
SELECT td.dia,
se.id_sello,
se.fecha_sello,
se.id_cliente AS cliente_sello,
se.telefono_cliente AS telef_cliente_sello,
se.usuario_tap AS usuario_tap_sello,
@julietaansola
julietaansola / sql
Created April 20, 2021 19:13
vw_aux_description
SELECT tr.created_at AS transaction_date,
tr.transaction_id AS transaction,
CASE
WHEN m1.id IS NOT NULL AND tr.transaction_id IS NULL THEN concat(m1.id, '-D')
ELSE tr.id::text
END AS transaction_id,
tr.transaction_type_id,
tt.description,
CASE
WHEN tt.description = 'WORKER ACCOUNT BALANCER'::text AND lower(m1.details) ~~ '%a tu cvu%'::text THEN 'EXTERNAL TRANSFER'::text
CREATE INDEX account_index ON app.account(account_id)
CREATE INDEX movement_index ON app.movement(movement_id)
CREATE INDEX business_index ON app.business_sector(business_sector_id)
CREATE INDEX company_index ON app.company(company_id)
CREATE INDEX person_index ON app.person(account_id)
CREATE INDEX movement_index ON ledger.movement(id)
CREATE INDEX transaction_index ON ledger.transaction(transaction_id)
CREATE INDEX transaction_type_index ON ledger.transaction_type(transaction_type_id)
import React from "react";
function Task(props) {
return <li>{props.task}</li>;
}
export default Task;