UpdateTopic.sql

--------------------------------------------------------------------------------------------------------------------------------
-- UPDATE TOPIC
--------------------------------------------------------------------------------------------------------------------------------
-- Used to update the attributes of a provided topic, including core, indexed, and extended attributes.
--------------------------------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[UpdateTopic]
	@TopicID		INT				,
	@Key		VARCHAR(128)		= NULL		,
	@ContentType		VARCHAR(128)		= NULL		,
	@Attributes		AttributeValues		READONLY		,
	@ExtendedAttributes	XML		= NULL		,
	@Version		DATETIME2(7)		= NULL		,
	@DeleteUnmatched	BIT		= 0
AS

--------------------------------------------------------------------------------------------------------------------------------
-- SET DEFAULT VERSION DATETIME
--------------------------------------------------------------------------------------------------------------------------------
IF	@Version		IS NULL
SET	@Version		= SYSUTCDATETIME()

--------------------------------------------------------------------------------------------------------------------------------
-- UPDATE KEY ATTRIBUTES
--------------------------------------------------------------------------------------------------------------------------------
IF @Key IS NOT NULL OR @ContentType IS NOT NULL
  BEGIN
    UPDATE	Topics
    SET	TopicKey		=
      CASE
        WHEN	@Key		IS NULL
        THEN	TopicKey
        ELSE	@Key
      END,
	ContentType		=
      CASE
        WHEN	@ContentType		IS NULL
        THEN	TopicKey
        ELSE	@ContentType
      END,
      LastModified		= @Version
    WHERE	TopicID		= @TopicID
  END

--------------------------------------------------------------------------------------------------------------------------------
-- UPDATE ATTRIBUTES
--------------------------------------------------------------------------------------------------------------------------------
IF EXISTS (SELECT TOP 1 NULL FROM @Attributes)
  BEGIN
    EXEC	UpdateAttributes	@TopicID,
			@Attributes,
			@Version,
			@DeleteUnmatched
  END

--------------------------------------------------------------------------------------------------------------------------------
-- ADD EXTENDED ATTRIBUTES, IF CHANGED
--------------------------------------------------------------------------------------------------------------------------------
IF @ExtendedAttributes IS NOT NULL
  BEGIN
    EXEC	UpdateExtendedAttributes	@TopicID,
			@ExtendedAttributes,
			@Version
  END

--------------------------------------------------------------------------------------------------------------------------------
-- RETURN TOPIC ID
--------------------------------------------------------------------------------------------------------------------------------
RETURN	@TopicID