Skip to content

Instantly share code, notes, and snippets.

View jeremyforan's full-sized avatar

Jeremy Foran jeremyforan

  • Blue Flag Consulting
  • Ontario
View GitHub Profile
#let img1 = sys.inputs.at("imageOne", default: "top.jpg")
#let img2 = sys.inputs.at("imageTwo", default: "middle.jpg")
#let img3 = sys.inputs.at("imageThree", default: "bottom.jpg")
#let img4 = sys.inputs.at("imageFour", default: "top.jpg")
// CONFIGURATION ///////////////////////////////////////
#let pageHeight = 6in
#let pageWidth = 4in
// the ratio is the native aspect ratio of the images
{
"rules": [
{
"rule-type": "selection",
"rule-id": "1",
"rule-name": "1",
"object-locator": {
"schema-name": "%",
"table-name": "%"
},
update dbo.earth set node =
case
when node = '\' then '0'
else '0' || replace(left(node, length(node) - 1 ),'\', '.')
end;
alter table dbo.earth
alter column node type ltree using node::ltree;
create schema dbo;
create extension ltree schema public;
create table dbo.earth (
id serial primary key,
node character varying(20),
name character varying(20)
);
create database migrationdemo;
GO
use migrationdemo
GO
create table earth (
id int identity(1,1) primary key,
node hierarchyid,
name varchar(20)
@jeremyforan
jeremyforan / main.go
Created December 30, 2020 02:00
Batching with timer
package main
import (
"fmt"
"math/rand"
"sync"
"time"
)
type Message struct {