QuickCore/Quick.Core.Extensions.HealthChecks.SqlServer.pas at master · exilon/QuickCore · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
{ ***************************************************************************

  Copyright (c) 2016-2026 Kike Perez

  Unit        : Quick.Core.Extensions.HealthChecks.SqlServer
  Description : Core Extensions SqlServer Health Checks
  Author      : Kike Perez
  Version     : 1.0
  Created     : 12/02/2021
  Modified    : 21/02/2021

  This file is part of QuickCore: https://github.com/exilon/QuickCore

 ***************************************************************************

  Licensed under the Apache License, Version 2.0 (the "License");
  you may not use this file except in compliance with the License.
  You may obtain a copy of the License at

  http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.

 *************************************************************************** }

unit Quick.Core.Extensions.HealthChecks.SqlServer;

{$i QuickCore.inc}

interface

uses
  System.SysUtils,
  System.TimeSpan,
  Quick.Commons,
  Quick.Core.Entity,
  Quick.Core.DependencyInjection,
  Quick.Core.Extensions.HealthChecks;

type
  TSqlServerHealthCheck = class(THealthCheck)
  private
    fEntityDatabase : TEntityDatabase;
    fServer : string;
    fDatabase : string;
  public
    constructor Create(aDataBase : TEntityDatabase; aTimeSpan : TTimeSpan);
    destructor Destroy; override;
    function GetCheckKind : string; override;
    function GetTags : string; override;
    procedure Check; override;
  end;

  TSqlServerHealthChecksExtension = class(THealthChecksExtension)
    class function AddSqlServerCheck<T : TDBContext>(const aName : string; aTimeSpan : TTimeSpan) : THealthChecksService;
  end;

implementation

{ TSqlServerHealthChecksExtension }

class function TSqlServerHealthChecksExtension.AddSqlServerCheck<T>(const aName : string; aTimeSpan : TTimeSpan) : THealthChecksService;
var
  check : IHealthCheck;
  dbContext : T;
begin
  Result := HealthChecksService;
  dbContext := HealthChecksService.ServiceCollection.Resolve<T>();
  check := TSqlServerHealthCheck.Create(dbContext.Database,aTimeSpan);
  check.Name := aName;
  Result := HealthChecksService.AddCheck(check);
end;

{ TSqlServerHealthCheck }

procedure TSqlServerHealthCheck.Check;
begin
  inherited;
  fEntityDatabase.Connect;
  if not fEntityDatabase.IsConnected then raise Exception.CreateFmt('Error connection to "%s" database!',[fEntityDatabase.Connection.Database]);
end;

constructor TSqlServerHealthCheck.Create(aDataBase : TEntityDatabase; aTimeSpan : TTimeSpan);
begin
  inherited Create(aTimeSpan);
  fName := 'SqlServer';
  fEntityDatabase := aDataBase.Clone;
  fServer := fEntityDatabase.Connection.Server;
  fDatabase := fEntityDatabase.Connection.Database;
end;

function TSqlServerHealthCheck.GetCheckKind: string;
begin
  Result := 'sqlserver';
end;

function TSqlServerHealthCheck.GetTags: string;
begin
  Result := Format('{"server":"%s","database":"%s"}',[fServer, fDatabase]);
end;

destructor TSqlServerHealthCheck.Destroy;
begin
  fEntityDatabase.Free;
  inherited;
end;

end.