Andy Allison AndrewAllison

Software Dev with more years of experience than I care to remember. Hacking away with all kinds of languages and tech stacks.

AndrewAllison / search-fundtions.ts

Created November 2, 2021 11:13

Mongo Snippets

	// This allows an exact search to be used on an indexed
	const scotNamedCharity = await oscrCollection.find({
	$text: { $search: `\"${removeStopWords(fund.funderName)}\"` }
	}).toArray();

AndrewAllison / array-functions.spec.ts

Last active August 19, 2021 14:14

Some commonly used javascript functions

	import { compare } from './array-functions';

	describe('array-functions', () => {
	it('should sort and array', () => {
	const unsortedArray = [
	{ order: 0, name: 'item 1' },
	{ order: 2, name: 'item 3' },
	{ order: 1, name: 'item 2' },
	];
	const resultsArray = unsortedArray.sort((a, b) =>

AndrewAllison / release_extract_files.yml

Created June 9, 2021 10:39

React to Azure Blob Storage Deploy Via Pipelines

	steps:
	- task: ExtractFiles@1
	displayName: 'Extract files '
	inputs:
	archiveFilePatterns: '**/$(Build.BuildId).zip'
	destinationFolder: '$(agent.builddirectory)'
	overwriteExistingFiles: true

AndrewAllison / gormmet-sample.jsx

Created November 18, 2020 20:46

Playing with gormmet

	import React, { useState } from 'react';
	// eslint-disable-next-line no-unused-vars
	import {
	Box, Button, Collapsible, Grommet, Heading, Layer, ResponsiveContext,
	} from 'grommet';
	import PropTypes from 'prop-types';
	import { FormClose, Notification } from 'grommet-icons';

	const theme = {
	global: {

AndrewAllison / PollyPolicyWithRetry.cs

Created September 30, 2020 09:50

Using Polly lib with C# For retries.

	var processingPolicy = Policy
	.Handle<SageLockingException>()
	.Or<SageProductException>()
	.WaitAndRetry(delay, onRetry: (exception, timeSpan, context) =>
	{
	HandleException(result, orderToProcess, exception);
	});
	var orderResults = processingPolicy.Execute(() => sageOrderHandler.ProcessNewOrder(sageOrder));

AndrewAllison / azure-devops-deploy.yml

Created September 10, 2020 13:54

AndrewAllison / build_deploy_ready.yml

Created July 10, 2020 08:32

Gists relating to yml for azure devops

AndrewAllison / view_row_count.sql

Created July 8, 2020 09:53

	/*
	Object Sizes

	Modified from http://stackoverflow.com/questions/15896564/get-table-and-index-storage-size-in-sql-server
	*/

	SELECT
	@@SERVERNAME as InstanceName
	, DB_NAME() as DatabaseName
	, ISNULL(s.name+'.'+t.NAME, 'TOTAL') AS TableName

AndrewAllison / serilog.json

Created June 26, 2020 15:09

SeriLogger

AndrewAllison / firebase-example.ts

Created June 7, 2020 11:56

Example of using Firebase with React

	import React, { useEffect } from 'react';
	import { Link } from "@reach/router";
	import { db } from "../_core/firebase";

	const HomePage = () => {
	const init = async () => {

	await db.collection('customers')
	.onSnapshot(function (doc) {
	let count = 0;