Update GetTopics to use new(er) GetTopicIDByUniqueKey function

JeremyCaney · JeremyCaney · commit a0f1a325136c · 2020-12-21T13:47:24.000-08:00
In a previous update, `SqlTopicRepository` was updated to use the new(er) `GetTopicIDByUniqueKey` function over the legacy `GetTopicID` function, thus operating off the `UniqueKey` instead of just finding the first instance of a key (4c3d30f). In that commit, we also ensured that `ITopicRepository.Load(string)` calls relied on a fully qualified path (e.g., `Root:Configuration:ContentTypes`). In this update, we extend that to by the default when calling the `GetTopics` stored procedure directly, as well. As with the previous commit, the associated parameter is renamed from `@TopicKey` to `@UniqueKey` to ensure this expected value is clear.
diff --git a/OnTopic.Data.Sql.Database/Stored Procedures/GetTopics.sql b/OnTopic.Data.Sql.Database/Stored Procedures/GetTopics.sql
@@ -8,20 +8,20 @@
 CREATE PROCEDURE [dbo].[GetTopics]
 	@TopicID		int	= -1,
 	@DeepLoad		bit	= 1,
-	@TopicKey		nvarchar(255)	= null
+	@UniqueKey		nvarchar(255)	= null
 AS
 
 --------------------------------------------------------------------------------------------------------------------------------
 -- GET TOPIC ID IF UNKNOWN.
 --------------------------------------------------------------------------------------------------------------------------------
-IF @TopicKey IS NOT NULL
+IF @UniqueKey IS NOT NULL
   BEGIN
-    SET	@TopicID		= dbo.GetTopicID(@TopicKey)
+    SET	@TopicID		= dbo.GetTopicIDByUniqueKey(@UniqueKey)
   END
 
 IF @TopicID < 0
   BEGIN
-    SET	@TopicID		= dbo.GetTopicID('Root')
+    SET	@TopicID		= dbo.GetTopicIDByUniqueKey('Root')
   END
 
 --------------------------------------------------------------------------------------------------------------------------------
