namespace AutomationDAL.Query.ScriptSecretRef;

public static class ScriptSecretRefQB
{
    public const string INSERT = @"
        INSERT INTO AUTO.TSCRIPTSECRETREF
               (SCRIPTID, TENANTID, SECRETNAME, VAULTREFERENCE)
        VALUES (@ScriptId, @TenantId, @SecretName, @VaultReference);
        SELECT CAST(SCOPE_IDENTITY() AS INT);";

    // Covering index required: IX_TSCRIPTSECRETREF_SCRIPTID (SCRIPTID, TENANTID)
    public const string GET_BY_SCRIPT = @"
        SELECT SECRETREFID, SCRIPTID, SECRETNAME, VAULTREFERENCE, TENANTID
        FROM   AUTO.TSCRIPTSECRETREF
        WHERE  SCRIPTID = @ScriptId
        AND    TENANTID = @TenantId
        ORDER BY SECRETREFID";

    public const string DELETE = @"
        DELETE FROM AUTO.TSCRIPTSECRETREF
        WHERE  SECRETREFID = @SecretRefId
        AND    TENANTID    = @TenantId";
}