Enzo Volkmann evolkmann

evolkmann / postgres_serial_to_uuid.sql

Created October 25, 2021 21:01

Change a serial ID column to a UUID column with predictable values

	alter table example_table
	alter column id drop default,
	alter column id set data type uuid using uuid_generate_v5(uuid_ns_url(), id::text),
	alter column id set default gen_random_uuid();

evolkmann / currencies-german.sql

Created April 14, 2021 12:09

SQL with currency codes and german labels (https://de.wikipedia.org/wiki/ISO_4217#Listen_der_W%C3%A4hrungscodes)

	insert into currencies (code, "name") values
	('AED', 'VAE-Dirham'),
	('AFN', 'Afghani'),
	('ALL', 'Albanischer Lek'),
	('AMD', 'Armenischer Dram'),
	('ANG', 'Antillen-Gulden'),
	('AOA', 'Kwanza'),
	('ARS', 'Argentinischer Peso'),
	('AUD', 'Australischer Dollar'),
	('AWG', 'Aruba-Florin'),

evolkmann / countries-and-codes-german.sql

Created April 14, 2021 11:44

SQL with three-letter-codes and names according to https://laendercode.net/de/countries.html

	insert into countries ("name", code) values
	('Afghanistan', 'AFG'),
	('Åland', 'ALA'),
	('Albanien', 'ALB'),
	('Algerien', 'DZA'),
	('Amerikanisch-Samoa', 'ASM'),
	('Andorra', 'AND'),
	('Angola', 'AGO'),
	('Anguilla', 'AIA'),
	('Antarktis', 'ATA'),

evolkmann / makes-and-models.sql

Last active April 14, 2021 16:10

Vehicle Makes and Models (SQL and Generator Script)

	-- Generated on 2021-04-08

	insert into "make" ("id", "name") values (1, 'Abarth');
	insert into "model" ("brand", "name") values (1, '124 Spider');
	insert into "model" ("brand", "name") values (1, '500');
	insert into "model" ("brand", "name") values (1, '500C');
	insert into "model" ("brand", "name") values (1, '595');
	insert into "model" ("brand", "name") values (1, '595 Competizione');
	insert into "model" ("brand", "name") values (1, '595 Turismo');
	insert into "model" ("brand", "name") values (1, '595C');

evolkmann / countries.enum.ts

Last active November 3, 2023 16:56

TypeScript Enum Country Codes ISO 3166

	// Inspired by https://gist.github.com/kyranjamie/646386d5edc174e8b549111572897f81
	// see https://gist.github.com/KingDarBoja/cf664cc395c4d95e645fd1f720c13746 for the three-letter-variant
	export enum Country {
	AF = 'Afghanistan',
	AX = 'AlandIslands',
	AL = 'Albania',
	DZ = 'Algeria',
	AS = 'American Samoa',
	AD = 'Andorra',
	AO = 'Angola',

evolkmann / importing.module.ts

Created January 4, 2019 15:34

Create Nest.js modules with custom config

	import { Module } from '@nestjs/common';
	import { MyLibModule } from './my-lib.module';

	@Module({
	imports: [
	MyLibModule.register({ name: 'Enzo' }),
	]
	})
	export class ImportingModule {}

evolkmann / a-no-decoration.html

Created October 23, 2018 20:06

evolkmann / request.js

Created April 25, 2018 05:38

	const performARequest = () => {
	const httpRequest = new XMLHttpRequest();
	httpRequest.onreadystatechange = () => {
	if (httpRequest.readyState === 4 && httpRequest.status === 200) {
	console.log('Request successful!');
	}
	};

	httpRequest.open('GET', window.ENVIRONMENT.backendUrl + '/users/john');
	httpRequest.send();

evolkmann / prod.environment.js

Created April 24, 2018 16:37

	/**
	* Represents the environment variables for PRODUCTION environment.
	*/
	(function (window) {
	'use strict';

	window['ENVIRONMENT'] = {
	backendUrl: 'https://prod.my-backend.com'
	};

evolkmann / index.html

Created April 24, 2018 16:36

	<!DOCTYPE html>
	<html lang="de">
	<head>

	<!-- Some more stuff here... -->

	<!-- Our environment variables will be injected here -->
	<!-- build:environment-vars --><!-- endbuild -->
	</head>
	<body>