Skip to content

Instantly share code, notes, and snippets.

View valentimaraujo's full-sized avatar
🏠
Working from home

Valentim Araújo valentimaraujo

🏠
Working from home
View GitHub Profile
@singledigit
singledigit / cognito.yaml
Last active September 20, 2025 17:27
Create a Cognito Authentication Backend via CloudFormation
AWSTemplateFormatVersion: '2010-09-09'
Description: Cognito Stack
Parameters:
AuthName:
Type: String
Description: Unique Auth Name for Cognito Resources
Resources:
# Creates a role that allows Cognito to send SNS messages
SNSRole:
---------GET FAMILY TREE MYSQL CUSTOM FUNCTION------------------
DELIMITER $$
DROP FUNCTION IF EXISTS `GetChildren` $$
CREATE FUNCTION `GetChildren` (GivenID INT) RETURNS TEXT CHARSET latin1
DETERMINISTIC
BEGIN
DECLARE rv,q,strq,queue,queue_children TEXT;