Randy Burden randyburden

## Updating Apple Pay Certificates.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              3 stars
            
          
                randyburden
                / Updating Apple Pay Certificates.md
            
            
              Created
              October 3, 2022 15:52
            
              
                How to update Apple Pay certificates that are expiring
              
          
    Updating Apple Pay Certificates

Overview

This document covers how to update the following Apple Pay certificates:

Apple Pay Payment Processing Certificate

Used to decrypt Apple Pay requests


Apple Pay Merchant Identity Certificate

Used to make requests to Apple Pay APIs


## windows_to_iana_time_zone.sql
/* MySQL table for converting from a Windows TimeZone name to a IANA TimeZone name */

CREATE TABLE IF NOT EXISTS `windows_to_iana_time_zone` (
    `windows_time_zone` varchar(50) NOT NULL,
    `iana_time_zone` varchar(50) NOT NULL,
    PRIMARY KEY (`windows_time_zone`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO windows_to_iana_time_zone (windows_time_zone, iana_time_zone) VALUES
('Afghanistan Standard Time', 'Asia/Kabul'),

## time_zone.sql
/* MySQL TimeZone name table for converting between Windows TimeZone name and IANA TimeZone name */

CREATE TABLE IF NOT EXISTS `time_zone` (
    `id` bigint(20) NOT NULL,
    `iana_time_zone` varchar(50) NOT NULL,
    `windows_time_zone` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO time_zone (id, iana_time_zone, windows_time_zone) VALUES

## CodeMirror_CurlyBraceWrappedText_Demo
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8">
		<title>CurlyBraceWrappedText Demo</title>
		<style type="text/css">
		  .CodeMirror {border: 1px solid black;}
		  .cm-CurlyBraceWrappedText {color: #CC0000; font-weight: bold;}
		</style>
		<link rel="stylesheet" href="css/codemirror.css">

## RoundRobinList.cs
using System;
using System.Collections.Generic;
using System.Linq;

namespace Helpers
{
    /// <summary>
    /// Creates a round robin list that uses a simple, thread-safe, round-robin
    /// load balancing algorithm where it provides the next item in the list each
    /// time <see cref="Next"/> is called and starts back at the top of the list

## HttpClient.js
httpClient = {
	get: function( url, data, callback ) {
		var xhr = new XMLHttpRequest();

		xhr.onreadystatechange = function () {
			var readyState = xhr.readyState;

			if (readyState == 4) {
				callback(xhr);
			}

## create_country_table_mysql.sql
CREATE TABLE IF NOT EXISTS `country` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `iso2` char(2) NOT NULL,
    `iso3` char(3) DEFAULT NULL,
    `countrycodenumeric` int(5) NOT NULL,
    `countrycode` nvarchar(5) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

## ConsoleColorExtensions.cs
using System;

namespace Utilities.Extensions
{
    public static class ConsoleColorExtensions
    {
        /// <summary>
        /// Writes the specified string value, followed by the current line terminator, to the standard output stream.
        /// </summary>
        /// <example>

## Add_Yourself_As_A_Sql_Server_Express_SysAdmin.txt
Adding Yourself as SQL Server Express SysAdmin
----------------------------------------------

Problem:

The help desk installs SQL Server on our developer machines under their own user accounts meaning you aren't a
sysadmin on your own SQL Server Express instance which in turn means you can't create a new database.

Solution:

## BooleanJsonConverter.cs
using System;
using Newtonsoft.Json;

namespace JsonConverters
{
    /// <summary>
    /// Handles converting JSON string values into a C# boolean data type.
    /// </summary>
    public class BooleanJsonConverter : JsonConverter
    {
	/* MySQL table for converting from a Windows TimeZone name to a IANA TimeZone name */

	CREATE TABLE IF NOT EXISTS `windows_to_iana_time_zone` (
	`windows_time_zone` varchar(50) NOT NULL,
	`iana_time_zone` varchar(50) NOT NULL,
	PRIMARY KEY (`windows_time_zone`)
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;

	INSERT INTO windows_to_iana_time_zone (windows_time_zone, iana_time_zone) VALUES
	('Afghanistan Standard Time', 'Asia/Kabul'),
	/* MySQL TimeZone name table for converting between Windows TimeZone name and IANA TimeZone name */

	CREATE TABLE IF NOT EXISTS `time_zone` (
	`id` bigint(20) NOT NULL,
	`iana_time_zone` varchar(50) NOT NULL,
	`windows_time_zone` varchar(50) NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;

	INSERT INTO time_zone (id, iana_time_zone, windows_time_zone) VALUES
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<title>CurlyBraceWrappedText Demo</title>
	<style type="text/css">
	.CodeMirror {border: 1px solid black;}
	.cm-CurlyBraceWrappedText {color: #CC0000; font-weight: bold;}
	</style>
	<link rel="stylesheet" href="css/codemirror.css">
	using System;
	using System.Collections.Generic;
	using System.Linq;

	namespace Helpers
	{
	/// <summary>
	/// Creates a round robin list that uses a simple, thread-safe, round-robin
	/// load balancing algorithm where it provides the next item in the list each
	/// time <see cref="Next"/> is called and starts back at the top of the list
	httpClient = {
	get: function( url, data, callback ) {
	var xhr = new XMLHttpRequest();

	xhr.onreadystatechange = function () {
	var readyState = xhr.readyState;

	if (readyState == 4) {
	callback(xhr);
	}
	CREATE TABLE IF NOT EXISTS `country` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(100) NOT NULL,
	`iso2` char(2) NOT NULL,
	`iso3` char(3) DEFAULT NULL,
	`countrycodenumeric` int(5) NOT NULL,
	`countrycode` nvarchar(5) NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
	using System;

	namespace Utilities.Extensions
	{
	public static class ConsoleColorExtensions
	{
	/// <summary>
	/// Writes the specified string value, followed by the current line terminator, to the standard output stream.
	/// </summary>
	/// <example>
	Adding Yourself as SQL Server Express SysAdmin
	----------------------------------------------

	Problem:

	The help desk installs SQL Server on our developer machines under their own user accounts meaning you aren't a
	sysadmin on your own SQL Server Express instance which in turn means you can't create a new database.

	Solution:
	using System;
	using Newtonsoft.Json;

	namespace JsonConverters
	{
	/// <summary>
	/// Handles converting JSON string values into a C# boolean data type.
	/// </summary>
	public class BooleanJsonConverter : JsonConverter
	{