Forem: StuartCreed

How to return old data in same query as updating a table in postgres

StuartCreed — Tue, 11 Feb 2025 08:30:46 +0000

WITH
    "old_data" AS (
        SELECT
            "id",
            "colour"
        FROM
            "random_table"
        WHERE
            "random_table"."id" IN (643)
    )
UPDATE "random_table" AS "ti"
SET
    "colour" = 'blue'
FROM
    "old_data" AS "od"
WHERE
    "ti"."id" = "od"."id"
RETURNING
    "ti"."id",
    "ti"."status",
    "od"."status" AS "old_status"

How to turn off bixby talkback on Samsung

StuartCreed — Thu, 05 Sep 2024 11:58:51 +0000

Hold all three buttons down for a while. On the top left one it is the upper side that you need to hold down

nvm

StuartCreed — Mon, 20 May 2024 07:59:29 +0000

nvm ls to view all installed versions of node.
nvm install 20 to install node version 20

Using local node variables

StuartCreed — Tue, 09 Apr 2024 14:51:15 +0000

To print all node variables currently in your terminal:
printenv

To add a node variable:
export NEW_ENVIRONMENT_VARIABLE='something....'

You can also:

echo $DB_ then tab to can parameters

SourceMaps with React

StuartCreed — Sun, 17 Dec 2023 20:56:41 +0000

https://javascript.plainenglish.io/debug-your-react-app-like-a-ninja-with-source-maps-c63010b3a6e7

Note that if we are using babel this will be translated to _this2
https://medium.com/@tommarren/the-mystery-of-this2-2af4ed10dd28

why this sometimes shows as undefined in devtools:
https://stackoverflow.com/questions/47530878/why-chrome-dev-tools-cant-reflect-this-correctly-in-a-promise?rq=4

Serve your REACT site on AWS S3

StuartCreed — Sun, 10 Dec 2023 22:47:07 +0000

Overview is SPA architecture and example is here: https://aws.amazon.com/blogs/networking-and-content-delivery/improve-single-page-application-spa-performance-with-a-same-domain-policy-using-amazon-cloudfront/

NOTE THIS ONLY WORKS WITH REST API ON API GATEWAY. THIS WON'T WORK WITH HTTP API (THE CHEAPER OPTION).

https://docs.aws.amazon.com/AmazonS3/latest/userguide/HostingWebsiteOnS3Setup.html
https://docs.aws.amazon.com/AmazonS3/latest/userguide/website-hosting-custom-domain-walkthrough.html
https://repost.aws/knowledge-center/cloudfront-https-requests-s3

WITH GATEWAY INVOLVED:
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/deploy-a-react-based-single-page-application-to-amazon-s3-and-cloudfront.html

https://github.com/aws-samples/react-cors-spa/tree/main
To make cloudfront work in SPA mode:
https://stackoverflow.com/questions/16267339/s3-static-website-hosting-route-all-paths-to-index-html

Cloudfront setup would look like this:

To hide your invoke url of API to the public (to ensure that all traffic is going through cloudfront - with WAF protection):
https://docs.aws.amazon.com/apigateway/latest/developerguide/apigateway-use-lambda-authorizer.html
https://docs.aws.amazon.com/apigateway/latest/developerguide/apigateway-use-lambda-authorizer.html#api-gateway-lambda-authorizer-create

Create a lambda authoriser with the following lambda definition:

export const handler = function(event, context, callback) {
    console.log('Received event:', JSON.stringify(event, null, 2));

    // A simple request-based authorizer example to demonstrate how to use request 
    // parameters to allow or deny a request. In this example, a request is  
    // authorized if the client-supplied headerauth1 header, QueryString1
    // query parameter, and stage variable of StageVar1 all match
    // specified values of 'headerValue1', 'queryValue1', and 'stageValue1',
    // respectively.

    // Retrieve request parameters from the Lambda function input:
    var headers = event.headers;
    var queryStringParameters = event.queryStringParameters;
    var pathParameters = event.pathParameters;
    var stageVariables = event.stageVariables;

    // Parse the input for the parameter values
    var tmp = event.methodArn.split(':');
    var apiGatewayArnTmp = tmp[5].split('/');
    var awsAccountId = tmp[4];
    var region = tmp[3];
    var restApiId = apiGatewayArnTmp[0];
    var stage = apiGatewayArnTmp[1];
    var method = apiGatewayArnTmp[2];
    var resource = '/'; // root resource
    if (apiGatewayArnTmp[3]) {
        resource += apiGatewayArnTmp[3];
    }

    // Perform authorization to return the Allow policy for correct parameters and 
    // the 'Unauthorized' error, otherwise.
    var authResponse = {};
    var condition = {};
    condition.IpAddress = {};

    if (headers.headerauth1 === "headerValue1"
        && queryStringParameters.QueryString1 === "queryValue1"
        && stageVariables.StageVar1 === "stageValue1") {
        callback(null, generateAllow('me', event.methodArn));
    }  else {
        callback("Unauthorized");
    }
}

// Help function to generate an IAM policy
var generatePolicy = function(principalId, effect, resource) {
    // Required output:
    var authResponse = {};
    authResponse.principalId = principalId;
    if (effect && resource) {
        var policyDocument = {};
        policyDocument.Version = '2012-10-17'; // default version
        policyDocument.Statement = [];
        var statementOne = {};
        statementOne.Action = 'execute-api:Invoke'; // default action
        statementOne.Effect = effect;
        statementOne.Resource = resource;
        policyDocument.Statement[0] = statementOne;
        authResponse.policyDocument = policyDocument;
    }
    // Optional output with custom properties of the String, Number or Boolean type.
    authResponse.context = {
        "stringKey": "stringval",
        "numberKey": 123,
        "booleanKey": true
    };
    return authResponse;
}

var generateAllow = function(principalId, resource) {
    return generatePolicy(principalId, 'Allow', resource);
}

var generateDeny = function(principalId, resource) {
    return generatePolicy(principalId, 'Deny', resource);
}

Then update the API gateway to use a new authoriser:
https://docs.aws.amazon.com/apigateway/latest/developerguide/configure-api-gateway-lambda-authorization-with-console.html

Notes for later on cloudfront functions to strip /api prefix:
https://docs.aws.amazon.com/AmazonCloudFront/latest/DeveloperGuide/function-code-choose-purpose.html

function handler(event) {
    var request = event.request;
    var uri = request.uri;

    // Remove /api from the URI
    if (uri.startsWith('/api')) {
        request.uri = uri.replace('/api', '');
    }

    return request;
}

GraphQL with Apollo - in progress

StuartCreed — Sat, 09 Dec 2023 10:41:20 +0000

n+1 issues for overfetching
https://medium.com/paypal-tech/graphql-resolvers-best-practices-cd36fdbcef55

https://www.apollographql.com/docs/apollo-server/data/fetching-data/#batching-and-caching

List all of your buckets in Lambda

StuartCreed — Wed, 06 Dec 2023 20:22:45 +0000

import {S3Client, ListBucketsCommand} from '@aws-sdk/client-s3';
const s3 = new S3Client({region: 'us-west-2'});

export const handler = async (event) => {
const data = await s3.send(new ListBucketsCommand({}));
return data.Buckets;
};

Example HTML response Lambda

StuartCreed — Wed, 06 Dec 2023 19:34:42 +0000

export const handler = async (event) => {
const response = {
statusCode: 200,
headers: {
"Content-Type": "text/html"
},
body: <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body><div>test</div></body></html>
};
return response;
};

Visual Studio Code Setup

StuartCreed — Wed, 28 Dec 2022 21:27:21 +0000

autosave on and autoformat using prettier in settings cmd + ,. Install gitlens and eslint.

mssql cheatsheet - in progress

StuartCreed — Wed, 28 Dec 2022 21:00:31 +0000

To find the structural information about a table in mssql:

sp_help table_name

Use the top helper like select top 10 * from table_name to limit the number of results from a select wildcard

Handy codepens on flex grow, shrink and basis

StuartCreed — Tue, 19 Apr 2022 10:14:59 +0000

https://codepen.io/JayTutorials/pen/eeqGMr
https://codepen.io/marshath/pen/qZOxoN/

flex grow default = 0
flex shrink default = 1