Changeset f71994c

Timestamp:

10/11/21 13:48:08 (3 years ago)

Author:

Стојков Марко <mst@…>

Branches:

dev

Children:

7dd2ea2

Parents:

cba21c9

Message:

Add fulltext search

Location:

src/FinkiChattery

Files:

• FinkiChattery.Database/FullTextSearch/FullTextIndexQuestion.sql (modified) (1 diff)
• FinkiChattery.Database/dbo/Tables/Question.sql (modified) (1 diff)
• FinkiChattery.Persistence/Configurations/QuestionConfig.cs (modified) (1 diff)
• FinkiChattery.Persistence/Models/Question.cs (modified) (1 diff)

src/FinkiChattery/FinkiChattery.Database/FullTextSearch/FullTextIndexQuestion.sql

@@ -1 @@
-CREATE FULLTEXT INDEX ON [dbo].[Question] ([Title], [Text])
+CREATE FULLTEXT INDEX ON [dbo].[Question] ([Search])
 KEY INDEX [PK_Question] ON [QuestionFullTextCatalog]
-WITH (CHANGE_TRACKING AUTO, STOPLIST OFF)
+WITH (CHANGE_TRACKING AUTO)

src/FinkiChattery/FinkiChattery.Database/dbo/Tables/Question.sql

@@ -9 +9 @@
     [Views]        BIGINT           DEFAULT (CONVERT([bigint],(0))) NOT NULL,
     [LastActiveOn] SMALLDATETIME    NOT NULL,
+    [Search]       AS ([Title] + ' ' + [Text]), 
     CONSTRAINT [PK_Question] PRIMARY KEY CLUSTERED ([Id] ASC),
     CONSTRAINT [FK_Question_Student_StudentFk] FOREIGN KEY ([StudentFk]) REFERENCES [dbo].[Student] ([Id]),

src/FinkiChattery/FinkiChattery.Persistence/Configurations/QuestionConfig.cs

@@ -24 +24 @@
             builder.Property(x => x.Views).HasColumnName(@"Views").HasColumnType("bigint").IsRequired().HasDefaultValue(0);
             builder.Property(x => x.LastActiveOn).HasColumnName(@"LastActiveOn").HasColumnType("smalldatetime").IsRequired();
+            builder.Property(x => x.Search).HasColumnType(@"Search").HasColumnType("nvarchar").HasMaxLength(4000).IsRequired();
 
             builder.HasOne(x => x.Student).WithMany(x => x.Questions).HasForeignKey(x => x.StudentFk).OnDelete(DeleteBehavior.NoAction);

src/FinkiChattery/FinkiChattery.Persistence/Models/Question.cs

@@ -32 +32 @@
         public DateTime LastActiveOn { get; set; }
 
+        public string Search { get; set; }
+
         public virtual ICollection<Answer> Answers { get; set; }
 
         public virtual ICollection<QuestionCategory> QuestionCategories { get; set; }
-
-        // TODO: Pole po koe ke pravime queries
     }
 }