Skip to main content

Peter Marshall

Peter Marshall

Call Service Fabric endpoint internally

1 min read

        private async Task CallServiceAsync()
        {
            string schedulerServiceName = "fabric:/DataServices/Scheduler";
            var resolver = ServicePartitionResolver.GetDefault();
            var partition = await resolver.ResolveAsync(new Uri(schedulerServiceName), ServicePartitionKey.Singleton, CancellationToken.None);
            var endpoints = JObject.Parse(partition.GetEndpoint().Address)["Endpoints"];
            var endpoint = endpoints[""].ToString().TrimEnd('/');
            string method = "/api/scheduler/classes/sync";
            var client = new HttpClient();
            client.DefaultRequestHeaders.Accept.Clear();
            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            var getTask = client.GetAsync(endpoint + method);
            var msg = await getTask;
        }

Peter Marshall

Peter Marshall

Adding an existing project to GitHub using the command line - User Documentation

Was a great help this morning gettig this stuff into github

Peter Marshall

Call Service Fabric endpoint internally

1 min read

        private async Task CallServiceAsync()
        {
            string schedulerServiceName = "fabric:/DataServices/Scheduler";
            var resolver = ServicePartitionResolver.GetDefault();
            var partition = await resolver.ResolveAsync(new Uri(schedulerServiceName), ServicePartitionKey.Singleton, CancellationToken.None);
            var endpoints = JObject.Parse(partition.GetEndpoint().Address)["Endpoints"];
            var endpoint = endpoints[""].ToString().TrimEnd('/');
            string method = "/api/scheduler/classes/sync";
            var client = new HttpClient();
            client.DefaultRequestHeaders.Accept.Clear();
            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            var getTask = client.GetAsync(endpoint + method);
            var msg = await getTask;
        }

Peter Marshall

Debug Jest tests in Visual Studio Code

1 min read

    {
      "type": "node",
      "request": "launch",
      "name": "Jest All",
      "program": "${workspaceFolder}/node_modules/.bin/jest",
      "args": ["--runInBand"],
      "console": "integratedTerminal",
      "internalConsoleOptions": "neverOpen",
      "windows": {
        "program": "${workspaceFolder}/node_modules/jest/bin/jest",
      }
    }

Peter Marshall

removing duplicates in sql server

1 min read

Find your duplicates

  SELECT    [col1], [col2], COUNT(*)
  FROM      [db].[mstar].[table1]
  GROUP BY  [col1], [col2]
  HAVING    COUNT(*) > 1
THEN
begin transaction
SET NOCOUNT ON
SET ROWCOUNT 1
while 1 = 1
 BEGIN
   DELETE  
   FROM [mstar].[InvalidFundShareClassAttribute]
   WHERE [FundShareClassId]+ [CustomState] IN
        (SELECT  [FundShareClassId]+ [CustomState]
         FROM    [mstar].[InvalidFundShareClassAttribute]
         GROUP BY [FundShareClassId]+ [CustomState]
         HAVING  COUNT(*) > 1)
      IF @@Rowcount = 0
      BREAK ;
end;
 SET ROWCOUNT 0
 rollback;
or commit;

 

There is another way

;WITH CTE AS 
(
    SELECT EmpName, ROW_NUMBER() OVER 
    (
        PARTITION BY EmpName ORDER BY EmpID
    ) RowNumber
    FROM  dbo.Employee
)
SELECT *FROM CTE WHERE RowNumber > 1
Then
;WITH CTE AS 
(
SELECT EmpName, ROW_NUMBER() OVER 
(
    PARTITION BY EmpName ORDER BY EmpID
) RowNumber
FROM  dbo.Employee
)
DELETE FROM CTE WHERE RowNumber > 1

Peter Marshall

Peter Marshall

remove duplicates in sql server

1 min read

Find your duplicates

  SELECT    [col1], [col2], COUNT(*)
  FROM      [db].[mstar].[table1]
  GROUP BY  [col1], [col2]
  HAVING    COUNT(*) > 1
THEN
begin transaction
SET NOCOUNT ON
SET ROWCOUNT 1
while 1 = 1
 BEGIN
   DELETE  
   FROM [mstar].[InvalidFundShareClassAttribute]
   WHERE [FundShareClassId]+ [CustomState] IN
        (SELECT  [FundShareClassId]+ [CustomState]
         FROM    [mstar].[InvalidFundShareClassAttribute]
         GROUP BY [FundShareClassId]+ [CustomState]
         HAVING  COUNT(*) > 1)
      IF @@Rowcount = 0
      BREAK ;
end;
 SET ROWCOUNT 0
 rollback;
or commit;

 

There is another way

;WITH CTE AS 
(
    SELECT EmpName, ROW_NUMBER() OVER 
    (
        PARTITION BY EmpName ORDER BY EmpID
    ) RowNumber
    FROM  dbo.Employee
)
SELECT *FROM CTE WHERE RowNumber > 1
Then
;WITH CTE AS 
(
SELECT EmpName, ROW_NUMBER() OVER 
(
    PARTITION BY EmpName ORDER BY EmpID
) RowNumber
FROM  dbo.Employee
)
DELETE FROM CTE WHERE RowNumber > 1

Peter Marshall