aidan-harding

Integer nCallsToEquals = 0;

public class HashingTest {
    private String s;

    public HashingTest(HashingTest ht) {
        this.s = ht.s;
    }

    public HashingTest(String s) {

aidan-harding

String jsonPayload = new YouTubeApi().getPlaylistThumbnail('playlist-id');
String thumbnailUrl = new JsonReader(jsonPayload)
    .read('items[0].snippet.thumbnails.default.url'));

aidan-harding

public with sharing class AccountExclamation implements TriggerAction.BeforeUpdate {

    public void beforeUpdate(List<Account> newList, List<Account> oldList) {
        for(Account thisAccount : newList) {
            if(TriggerBase.idToNumberOfTimesSeenBeforeUpdate.get(thisAccount.Id) == 1 && !thisAccount.Name.endsWith('!')) {
                thisAccount.Name += '!';
            }
        }
    }
}

aidan-harding

function sleeper(value) {
    return new Promise(resolve => setTimeout(() => resolve(value), value * 100));
}

[5, 4, 3, 6, 1].forEach((value) => sleeper(value).then((value) => console.log(value)));

aidan-harding

#!/bin/zsh
#
# Check that sfdx force:source:status is clean before committing
# Put this into .git/hooks/pre-commit

if ! sfdx force:source:status --json | jq -r '.result | length' | grep '^0$' &> /dev/null;
then
        echo "Error: sfdx source is not synced with remote"
        exit 1
fi

aidan-harding

<?xml version="1.0"?>

<ruleset name="Salesforce Custom Rules"
    xmlns="http://pmd.sourceforge.net/ruleset/2.0.0"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://pmd.sourceforge.net/ruleset/2.0.0 https://pmd.sourceforge.io/ruleset_2_0_0.xsd">

    <description>
        My Salesforce rules
    </description>

aidan-harding

class MyClass {
    constructor() {
        const self = this;
        Object.getOwnPropertyNames( MyClass.prototype )
            .filter(name => name.indexOf('_') === 0)
            .filter(name => typeof self[name] === 'function')
            .forEach(function(name) {
                self[name.substr(1)] = function() {
                    self[name].apply(self, arguments);
                }

aidan-harding

<template>
    <lightning-datatable
            key-field="id"
            columns={columns}
            data={data}
            hide-checkbox-column
            default-sort-direction={dataTableSorter.defaultSortDirection}
            sorted-direction={dataTableSorter.sortDirection}
            sorted-by={dataTableSorter.sortedBy}
            onsort={dataTableSorter.sortData}>

aidan-harding

/**
 * @author aidan@nebulaconsulting.co.uk
 * @date 15/11/2021
 */

@IsTest
private class TransformationTest {

    @IsTest
    static void passThroughSObjectToOtherSObject() {

aidan-harding

I have a scenario where an external system is calling Salesforce API, causing a trigger to run. That trigger needs to delete EmailMessage records where the RelatedTo field is an Account.

We're getting UNABLE_TO_LOCK_ROW errors when the external system's API calls overlap and the trigger attempts to delete multiple emails on the same Account at the same time.

This is totally understandable based on how [record-locking works][1]. RelatedTo is either a required lookup or a Master-Detail so deleting the EmailMessage would require a lock on the related Account.

I tried to solve the problem by adding FOR UPDATE to the query in the trigger where it fetches the EmailMessage records.

But, we still observe UNABLE_TO_LOCK_ROW as a DmlException (if it were a QueryException, then that might be due to the 10-second limit timing out).