-- AB Legacy (PCCC / SLC-500, MicroLogix) e2e smoke seed — v3 schema (DriverInstance → Device → Tag).
--
-- Idempotent DELETE-and-recreate pointing at the fixture (ab://127.0.0.1:44818/1,0). To target real
-- hardware, edit the Device's DeviceConfig HostAddress to end with /<empty> (trailing slash, no path).
-- v3: the ConfigGeneration/Namespace model + sp_PublishGeneration are gone; the per-device HostAddress
-- moved from DriverConfig.Devices[] into the Device's DeviceConfig (the deviceHostAddress tag key is
-- dropped — the tag's DeviceId FK owns placement now).

SET NOCOUNT ON;
SET XACT_ABORT ON;
SET QUOTED_IDENTIFIER ON;
SET ANSI_NULLS ON;

DECLARE @ClusterId nvarchar(64) = 'ablegacy-smoke';
DECLARE @NodeId    nvarchar(64) = 'ablegacy-smoke-node';
DECLARE @DrvId     nvarchar(64) = 'ablegacy-smoke-drv';
DECLARE @DevId     nvarchar(64) = 'ablegacy-smoke-dev';
DECLARE @AreaId    nvarchar(64) = 'ablegacy-smoke-area';
DECLARE @LineId    nvarchar(64) = 'ablegacy-smoke-line';
DECLARE @EqId      nvarchar(64) = 'ablegacy-smoke-eq';
DECLARE @EqUuid    uniqueidentifier = 'AB1E9AC0-AB1E-45E0-9AB1-E9AC0AB1E9AC';
DECLARE @Tag       nvarchar(64) = 'ablegacy-smoke-tag-n7-5';
DECLARE @RefId     nvarchar(64) = 'ablegacy-smoke-ref-n7-5';

BEGIN TRAN;

DELETE FROM dbo.UnsTagReference       WHERE UnsTagReferenceId = @RefId;
DELETE FROM dbo.Tag                   WHERE TagId = @Tag;
DELETE FROM dbo.Equipment             WHERE EquipmentId = @EqId;
DELETE FROM dbo.UnsLine               WHERE UnsLineId = @LineId;
DELETE FROM dbo.UnsArea               WHERE UnsAreaId = @AreaId;
DELETE FROM dbo.Device                WHERE DeviceId = @DevId;
DELETE FROM dbo.DriverInstance        WHERE DriverInstanceId = @DrvId;
DELETE FROM dbo.ClusterNodeCredential WHERE NodeId = @NodeId;
DELETE FROM dbo.ClusterNode           WHERE NodeId = @NodeId;
DELETE FROM dbo.ServerCluster         WHERE ClusterId = @ClusterId;
DELETE FROM dbo.ClusterNodeCredential WHERE Kind = 'SqlLogin' AND Value = 'sa';

INSERT dbo.ServerCluster(ClusterId, Name, Enterprise, Site, NodeCount, RedundancyMode, Enabled, CreatedBy)
VALUES (@ClusterId, 'AbLegacy Smoke', 'zb', 'lab', 1, 'None', 1, 'ablegacy-smoke');

INSERT dbo.ClusterNode(NodeId, ClusterId, Host, OpcUaPort, DashboardPort,
                       ApplicationUri, ServiceLevelBase, Enabled, CreatedBy)
VALUES (@NodeId, @ClusterId, 'localhost', 4840, 15050, 'urn:OtOpcUa:ablegacy-smoke-node', 200, 1, 'ablegacy-smoke');

INSERT dbo.ClusterNodeCredential(NodeId, Kind, Value, Enabled, CreatedBy)
VALUES (@NodeId, 'SqlLogin', 'sa', 1, 'ablegacy-smoke');

-- DriverConfig keeps protocol/channel settings; per-device HostAddress moves to DeviceConfig.
INSERT dbo.DriverInstance(DriverInstanceId, ClusterId, RawFolderId, Name, DriverType, DriverConfig, Enabled)
VALUES (@DrvId, @ClusterId, NULL, 'slc-smoke', 'AbLegacy', N'{
  "ProbeTimeoutSeconds": 5,
  "Probe": { "Enabled": true, "IntervalMs": 5000, "TimeoutMs": 2000, "ProbeAddress": "S:0" }
}', 1);

-- DeviceConfig shape finalized against reworked options in Wave B (WP5).
INSERT dbo.Device(DeviceId, DriverInstanceId, Name, Enabled, DeviceConfig)
VALUES (@DevId, @DrvId, 'plc', 1, N'{ "HostAddress": "ab://127.0.0.1:44818/1,0" }');

INSERT dbo.Tag(TagId, DeviceId, TagGroupId, Name, DataType, AccessLevel, WriteIdempotent, TagConfig)
VALUES (@Tag, @DevId, NULL, 'N7_5', 'Int', 'ReadWrite', 1,
        N'{ "address": "N7:5", "dataType": "Int" }');

INSERT dbo.UnsArea(UnsAreaId, ClusterId, Name)          VALUES (@AreaId, @ClusterId, 'lab-floor');
INSERT dbo.UnsLine(UnsLineId, UnsAreaId, Name)          VALUES (@LineId, @AreaId, 'ablegacy-line');
INSERT dbo.Equipment(EquipmentId, EquipmentUuid, UnsLineId, Name, MachineCode, Enabled)
VALUES (@EqId, @EqUuid, @LineId, 'slc-sim', 'ablegacy-001', 1);

INSERT dbo.UnsTagReference(UnsTagReferenceId, EquipmentId, TagId, SortOrder)
VALUES (@RefId, @EqId, @Tag, 0);

COMMIT;

PRINT 'AbLegacy smoke seed complete (v3 schema). Cluster: ' + @ClusterId + '  Node: ' + @NodeId;
