xavierzwirtz

-- run this for both tables
-- BDTriggerAuditBDPageHits
-- BDTriggerAuditBDCarts

SET NOCOUNT ON;
 
DECLARE @r INT;
 
SET @r = 1;
 

xavierzwirtz

❯ nix run -f .. esy -c esy build-plan -p @opam/ocamlfind
warning: unknown setting 'experimental-features'
{
  "id": "opam__s__ocamlfind-opam__c__1.8.1-c7c7ac83",
  "name": "@opam/ocamlfind",
  "version": "opam:1.8.1",
  "sourceType": "immutable",
  "buildType": "in-source",
  "build": [
    [ "bash", "-c", "true" ],

xavierzwirtz

❯ nix run -f .. esy -c esy
warning: unknown setting 'experimental-features'
info esy 0.6.6 (using package.json)
info building @opam/ocamlbuild@opam:0.14.0@6ac75d03
info building @opam/cmdliner@opam:1.0.4@93208aac
info building @opam/ocamlfind@opam:1.8.1@ff07b0f9
error: build failed with exit code: 1
  build log:
    # esy-build-package: building: @opam/ocamlfind@opam:1.8.1
    # esy-build-package: pwd: /home/xavier/.esy/3/b/opam__s__ocamlfind-opam__c__1.8.1-c7c7ac83

xavierzwirtz

select schema_name(fk_tab.schema_id) as foreign_schema,
 fk_tab.name as foreign_table,
    schema_name(pk_tab.schema_id) as primary_schema,
   pk_tab.name as primary_table
from sys.foreign_keys fk
    inner join sys.tables fk_tab
        on fk_tab.object_id = fk.parent_object_id
    inner join sys.tables pk_tab
        on pk_tab.object_id = fk.referenced_object_id
    cross apply (select col.[name] + ', '

xavierzwirtz

sudo MSSQL_SA_PASSWORD="Zwirtz823@" NIX_REDIRECTS="/var/opt/=/var/lib/" strace -f -v -s 256 ./mssql-server/bin/sqlservr --accept-eula --reset-sa-password
execve("./mssql-server/bin/sqlservr", ["./mssql-server/bin/sqlservr", "--accept-eula", "--reset-sa-password"], ["COLORTERM=truecolor", "DISPLAY=:0", "LANG=en_US.UTF-8", "PATH=/home/xavier/bin:/run/wrappers/bin:/home/xavier/.nix-profile/bin:/etc/profiles/per-user/xavier/bin:/nix/var/nix/profiles/default/bin:/run/current-system/sw/bin", "SSH_AUTH_SOCK=/run/user/1000/ssh-agent", "TERM=alacritty", "TERMINFO_DIRS=/home/xavier/.nix-profile/share/terminfo:/etc/profiles/per-user/xavier/share/terminfo:/nix/var/nix/profiles/default/share/terminfo:/run/current-system/sw/share/terminfo", "XAUTHORITY=/home/xavier/.Xauthority", "MAIL=/var/mail/root", "LOGNAME=root", "USER=root", "HOME=/root", "SHELL=/run/current-system/sw/bin/bash", "SUDO_COMMAND=/run/current-system/sw/bin/strace -f -v -s 256 ./mssql-server/bin/sqlservr --accept-eula --reset-sa-password", "SUDO_USER=xavie

xavierzwirtz

Imports BirdDogSoftware.Interfaces

Namespace Events
    Public Class OrderEvents

        Public Shared Sub Placed(
            Order As IOrder
        )
            Order.Shipping_Date = System.DateTime.Now
        End Sub

xavierzwirtz

// this bit is pseudo code to describe the filter expression


type ComparisonMethod =
| Contains
| Equals

type FieldValue = 
    { Name : string

xavierzwirtz

 DECLARE @p0 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p1 NVARCHAR(2) = 't1'
DECLARE @p2 UNIQUEIDENTIFIER = '8251d2e8-f988-49fe-933a-af54f2e53532'
DECLARE @p3 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p4 NVARCHAR(3) = 'ct0'
DECLARE @p5 UNIQUEIDENTIFIER = '8251d2e8-f988-49fe-933a-af54f2e53532'
DECLARE @p6 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p7 NVARCHAR(3) = 'ct1'
DECLARE @p8 UNIQUEIDENTIFIER = '8251d2e8-f988-49fe-933a-af54f2e53532'

xavierzwirtz

<?xml version="1.0"?>
<!-- Rename this file to BirdDogSoftware.Jobmaster.exe.config -->
<configuration>
  <configSections>
    <section name="jobdatabaseInfo" type="BirdDogSoftware.Library.Services.DatabasesSectionHandler,BirdDogSoftware.Library"/>
    <section name="emailnotifierInfo" type="BirdDogSoftware.Library.Services.EmailSectionHandler,BirdDogSoftware.Library"/>
  </configSections>
  <appSettings>
    <add key="LoggingLevel" value="3"/>
  </appSettings>

xavierzwirtz

[nix-shell:~]$ cat /nix/store/hdpxb5ikmckryx3ks5mxkcmykdmkr70w-named.conf
options {
  directory "/run/named";
  pid-file "/run/named/named.pid";
};
zone "atlas.birddogsw.local" {
  type master;
  file "/nix/store/brjzwsdrdq7m15g8h1q7lihiv6x2vvgq-atlas.zone";
};