Skip to content

Instantly share code, notes, and snippets.

View havarnov's full-sized avatar

Håvar Nøvik havarnov

11 followers · 0 following
View GitHub Profile
@havarnov
havarnov / mssql-timezone.sql
Created March 1, 2024 10:34
DECLARE @Timestamp AS DATETIMEOFFSET = '2024-03-03T23:05:00.000Z'
--DECLARE @TimeZone AS NVARCHAR(MAX) = 'Central Europe Standard Time';
DECLARE @TimeZone AS NVARCHAR(MAX) = 'GMT Standard Time';
SELECT DATEPART(
ISO_WEEK,
CONVERT(
DATETIMEOFFSET,
SWITCHOFFSET(
@Timestamp,
@havarnov
havarnov / gist:ebfc4d5bd5c52eaa5a4beda0f78b4230
Created January 16, 2024 19:21
Minecraft Bedrock - fly.io
========= run.sh ==========
#!/bin/bash
socat UDP4-LISTEN:23191,fork,reuseaddr,bind=fly-global-services UDP4:127.0.0.1:19132 &
/opt/bedrock-entry.sh &
# Wait for any process to exit
wait -n
@havarnov
havarnov / ringbuffer.fs
Created December 14, 2023 10:02
type RingBuffer<'a> = private {
buffer: 'a option array
size: int
index: int
}
module RingBuffer =
open System
let create size = {
@havarnov
havarnov / aop-benchmark.cs
Created September 21, 2023 08:42
using AspectCore.Configuration;
using AspectCore.DynamicProxy;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Running;
_ = BenchmarkRunner.Run<Benchmark>();
public class LoggerInterceptor : AbstractInterceptor
{
public override async Task Invoke(AspectContext context, AspectDelegate next)
@havarnov
havarnov / aop-playground.cs
Created September 21, 2023 08:29
using System;
using System.Threading.Tasks;
using AspectCore.Configuration;
using AspectCore.DynamicProxy;
using Microsoft.Extensions.Logging;
var loggerFactory = LoggerFactory.Create(c => c.AddSimpleConsole());
var generator = new ProxyGeneratorBuilder()
.Configure(c =>
{
@havarnov
havarnov / relations.csv
Created December 2, 2019 09:50
We can't make this file beautiful and searchable because it's too large.
:START_ID,:END_ID,:TYPE
255126,CN_255127,CONDUCTING
255176,CN_255177,CONDUCTING
255268,CN_255269,CONDUCTING
255323,CN_255324,CONDUCTING
255654,CN_255655,CONDUCTING
256051,CN_256052,CONDUCTING
256475,CN_256476,CONDUCTING
256567,CN_256568,CONDUCTING
256613,CN_256614,CONDUCTING
@havarnov
havarnov / nodes.csv
Created December 2, 2019 09:49
We can't make this file beautiful and searchable because it's too large.
conductingId:ID,:LABEL
255126,BusbarSection
255176,BusbarSection
255268,BusbarSection
255323,BusbarSection
255654,BusbarSection
256051,BusbarSection
256475,BusbarSection
256567,BusbarSection
256613,BusbarSection
@havarnov
havarnov / cn_c.csv
Created November 28, 2019 14:11
We can't make this file beautiful and searchable because it's too large.
ConnectivityNodeId,ConductingId
CN_255127,255126
CN_255177,255176
CN_255269,255268
CN_255324,255323
CN_255655,255654
CN_256052,256051
CN_256476,256475
CN_256568,256567
CN_256614,256613
@havarnov
havarnov / res3.csv
Last active November 19, 2019 14:59
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
r_id,r_type,r_source,r_target,r_data,depth,visited,source_e,target_e,source_type,target_type
2efe837c-74a2-4b90-a9e5-fc6b3d982314,conducting,93466a23-c448-46e2-9c62-ac27c41f57c6,478d7002-4eea-4202-8a30-99ced47f9510,{},0,"""{2efe837c-74a2-4b90-a9e5-fc6b3d982314,6700da7e-98fd-4cfc-8cbe-4f1dc25822ad}""",bafc5c6c-51de-4c2e-b9fb-d66ee088bd9c,000145f8-8f60-4e83-a2cd-c3c358bfeabc,eSmart.Utility.Models.Conductor,eSmart.Utility.Models.UnknownEntity
6700da7e-98fd-4cfc-8cbe-4f1dc25822ad,conducting,e2174c41-2d61-4aeb-8039-eb1d79bf24df,478d7002-4eea-4202-8a30-99ced47f9510,{},0,"""{2efe837c-74a2-4b90-a9e5-fc6b3d982314,6700da7e-98fd-4cfc-8cbe-4f1dc25822ad}""",5b73c611-8bd5-46d3-89ba-2c5d58d28d8d,000145f8-8f60-4e83-a2cd-c3c358bfeabc,eSmart.Utility.Models.UnknownEntity,eSmart.Utility.Models.UnknownEntity
29035c88-fa5c-4a9c-baf3-ebad7cd40195,conducting,93466a23-c448-46e2-9c62-ac27c41f57c6,946e96ff-ea44-4a44-a738-5067504afaa2,{},1,"""{2efe837c-74a2-4b90-a9e5-fc6b3d982314,6700da7e-98fd-4cfc-8cbe-4f1dc25822ad,29035c88-fa5c-4a9c-b
@havarnov
havarnov / gist:92fd9a7e8a1dda351b31322bc564d8fb
Created November 19, 2019 14:45
r_id,r_type,r_source,r_target,r_data,depth,visited,source_e,target_e,type,type
2efe837c-74a2-4b90-a9e5-fc6b3d982314,conducting,93466a23-c448-46e2-9c62-ac27c41f57c6,478d7002-4eea-4202-8a30-99ced47f9510,{},0,"""{2efe837c-74a2-4b90-a9e5-fc6b3d982314,6700da7e-98fd-4cfc-8cbe-4f1dc25822ad}""",bafc5c6c-51de-4c2e-b9fb-d66ee088bd9c,000145f8-8f60-4e83-a2cd-c3c358bfeabc,eSmart.Utility.Models.Conductor,eSmart.Utility.Models.UnknownEntity
6700da7e-98fd-4cfc-8cbe-4f1dc25822ad,conducting,e2174c41-2d61-4aeb-8039-eb1d79bf24df,478d7002-4eea-4202-8a30-99ced47f9510,{},0,"""{2efe837c-74a2-4b90-a9e5-fc6b3d982314,6700da7e-98fd-4cfc-8cbe-4f1dc25822ad}""",5b73c611-8bd5-46d3-89ba-2c5d58d28d8d,000145f8-8f60-4e83-a2cd-c3c358bfeabc,eSmart.Utility.Models.UnknownEntity,eSmart.Utility.Models.UnknownEntity
29035c88-fa5c-4a9c-baf3-ebad7cd40195,conducting,93466a23-c448-46e2-9c62-ac27c41f57c6,946e96ff-ea44-4a44-a738-5067504afaa2,{},1,"""{2efe837c-74a2-4b90-a9e5-fc6b3d982314,6700da7e-98fd-4cfc-8cbe-4f1dc25822ad,29035c88-fa5c-4a9c-baf3-ebad7cd401