Skip to content

Instantly share code, notes, and snippets.

Xavier Zwirtz xavierzwirtz

Block or report user

Report or block xavierzwirtz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View doc.md

So your system is on fire

First, check the BDTriggerAudit tables record counts:

select @sql
EXEC (@SQL)
GO
--SET ANSI_NULLS ON
--GO
View gist:dc6a81ec2759979563995b77448e150b
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[bd_purge_audit]
AS
DECLARE @SQL varchar(max)=''
select @SQL = @SQL + '
SET NOCOUNT ON;
View gist:c9fdb25d048b92a8fb5c9cf6973ca0f8
SET deadlock_priority low
UPDATE bdtriggerauditiminvloc_sql
SET syncflag = 1
WHERE ( auditid IN ( '7caa0b66-c3ec-4e33-9706-71c98ed01a30',
'fd6d2c24-8eb2-4dde-9a47-71c9bbc7f9d6'
,
'9d693302-dad5-4f3d-a33e-71c9c28d4bc1'
,
'4f8567c3-054f-4f77-b4ad-71ca16a18d89'
View gist:8ad3ff131ec390c4270cbca002526b5f
these derivations will be built:
/nix/store/24lw3dnbif9p6r11mq5nk6z3rgr209cb-bulk-layers.drv
/nix/store/3lgbww299v2mka7p9by84yxdd341wwzx-nginx-config.json.drv
/nix/store/8xsaixzaafay1vrbiif69as8l69jyh9i-nginx-customisation-layer.drv
/nix/store/ycwgfi9bgpq0dnxx8fc7732h1gjz9r8x-closure.drv
/nix/store/vgcij363wdayqvxhh5d7g0db6p1qvvrc-closure-paths.drv
/nix/store/zlbpl3x8s1siq093g34li4f0cxrq8r8n-store-path-to-layer.sh.drv
/nix/store/rasm8f1pr0miss2w0v9p2gb29w5jcwra-nginx-granular-docker-layers.drv
/nix/store/98a62c975gx89jmpy3knx0z276yh036y-docker-image-nginx.tar.gz.drv
/nix/store/ppdf7hillsy84h2l2qb30q1in698lwss-kubenix-generated.json.drv
View gist:c9494c3eb4960cceafeee25f02d9ce6d
these derivations will be built:
/nix/store/24lw3dnbif9p6r11mq5nk6z3rgr209cb-bulk-layers.drv
/nix/store/3lgbww299v2mka7p9by84yxdd341wwzx-nginx-config.json.drv
/nix/store/8xsaixzaafay1vrbiif69as8l69jyh9i-nginx-customisation-layer.drv
/nix/store/ycwgfi9bgpq0dnxx8fc7732h1gjz9r8x-closure.drv
/nix/store/vgcij363wdayqvxhh5d7g0db6p1qvvrc-closure-paths.drv
/nix/store/zlbpl3x8s1siq093g34li4f0cxrq8r8n-store-path-to-layer.sh.drv
/nix/store/rasm8f1pr0miss2w0v9p2gb29w5jcwra-nginx-granular-docker-layers.drv
/nix/store/98a62c975gx89jmpy3knx0z276yh036y-docker-image-nginx.tar.gz.drv
/nix/store/ppdf7hillsy84h2l2qb30q1in698lwss-kubenix-generated.json.drv
View gist:04c47d8e89efea05265ba7d71e4e0dec
these derivations will be built:
/nix/store/24lw3dnbif9p6r11mq5nk6z3rgr209cb-bulk-layers.drv
/nix/store/3lgbww299v2mka7p9by84yxdd341wwzx-nginx-config.json.drv
/nix/store/8xsaixzaafay1vrbiif69as8l69jyh9i-nginx-customisation-layer.drv
/nix/store/ycwgfi9bgpq0dnxx8fc7732h1gjz9r8x-closure.drv
/nix/store/vgcij363wdayqvxhh5d7g0db6p1qvvrc-closure-paths.drv
/nix/store/zlbpl3x8s1siq093g34li4f0cxrq8r8n-store-path-to-layer.sh.drv
/nix/store/rasm8f1pr0miss2w0v9p2gb29w5jcwra-nginx-granular-docker-layers.drv
/nix/store/98a62c975gx89jmpy3knx0z276yh036y-docker-image-nginx.tar.gz.drv
/nix/store/ppdf7hillsy84h2l2qb30q1in698lwss-kubenix-generated.json.drv
View gist:0dca81bc6d38f45496a93176f23609b1
DECLARE @p0 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p1 NVARCHAR(2) = 't1'
DECLARE @p2 UNIQUEIDENTIFIER = 'a343151a-03e8-4d79-9c59-3ccbab4fe73d'
DECLARE @p3 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p4 NVARCHAR(3) = 'ct0'
DECLARE @p5 UNIQUEIDENTIFIER = 'a343151a-03e8-4d79-9c59-3ccbab4fe73d'
SELECT [t1].[data_item_no],
CASE
WHEN [t1].[audit_bd_version] IS NULL THEN 0x0000000000000000
View gist:a51ae572e3b2514e289d27811db120e9
Imports BirdDogSoftware.Interfaces
Namespace Events
Public Class MagentoEvents
Public Shared Function GetItemQtyOnHand(
Connection As MagentoConnector.Connection,
Connector As IConnectorAccount,
Item As IItem
) as Maybe(Of Double)
View gist:10772ad482bca9e493de14f674351fd9
Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports BirdDogSoftware
Imports BirdDogSoftware.Utilities
Imports BirdDogSoftware.Utilities.Http
Imports BirdDogSoftware.Framework
Imports BirdDogSoftware.Interfaces
Imports Newtonsoft.Json.Linq
Imports Chessie.ErrorHandling.CSharp
View gist:3975e4a071696bbf72329c3abb74eb74
diff -r 7df128438c47 BirdDogFrameworkLayer/BirdDogSoftware.FrameWork/Connectors/Connectors/ServiceProConnector.vb
--- a/BirdDogFrameworkLayer/BirdDogSoftware.FrameWork/Connectors/Connectors/ServiceProConnector.vb Mon Oct 28 16:45:24 2019 -0500
+++ b/BirdDogFrameworkLayer/BirdDogSoftware.FrameWork/Connectors/Connectors/ServiceProConnector.vb Wed Oct 30 14:46:46 2019 -0500
@@ -2429,12 +2429,13 @@
ElseIf inspectionId.HasValue Then
Dim inspectionItemNo = lineData.Item("ItemNumber").ToObject(Of String)
- Return Tuple.Create(Choice.Choice2(Of Integer, String)(inspectionItemNo), IItem.ServiceProTypes.Inspection)
+ If ItemNoExists(inspectionItemNo) Then
+ Return Tuple.Create(Choice.Choice2(Of Integer, String)(inspectionItemNo), IItem.ServiceProTypes.Inspection)
You can’t perform that action at this time.