Introdução ao Semantic Kernel da Microsoft em C# e MongoDB Atlas

1
using Microsoft.SemanticKernel.Memory;
2
3
#pragma warning disable SKEXP0001, SKEXP0010, SKEXP0020, SKEXP0050
4
public static class Program {
5
    static string TextEmbeddingModelName = "text-embedding-ada-002";
6
    static string OpenAIAPIKey = "<YOUR OPENAI PROJECT API KEY>";
7
  
8
    static string MongoDBAtlasConnectionString = "<YOUR ATLAS CONNECTION STRING>";
9
    static string SearchIndexName = "default";
10
    static string DatabaseName = "semantic-kernel";
11
    static string CollectionName = "movies";
12
    static MemoryBuilder memoryBuilder;
13
14
    public static async Task Main(string[] args) {
15
16
    }
17
}

1
memoryBuilder = new MemoryBuilder();
2
3
        memoryBuilder.WithOpenAITextEmbeddingGeneration(
4
            TextEmbeddingModelName,
5
            OpenAIAPIKey
6
            );

1
using Microsoft.SemanticKernel;
2
using Microsoft.SemanticKernel.Connectors.MongoDB;
3
using Microsoft.SemanticKernel.Connectors.OpenAI;
4
using Microsoft.SemanticKernel.Memory;
5
using MongoDB.Driver;
6
using Kernel = Microsoft.SemanticKernel.Kernel;

1
var mongoDBMemoryStore = new MongoDBMemoryStore(MongoDBAtlasConnectionString, DatabaseName, SearchIndexName);
2
        memoryBuilder.WithMemoryStore(mongoDBMemoryStore);       
3
        var memory = memoryBuilder.Build();

1
public class Movie
2
{
3
    [BsonId]
4
    [BsonRepresentation(BsonType.ObjectId)]
5
    public string Id { get; set; }
6
7
    [BsonElement("plot")]
8
    public string Plot { get; set; }
9
10
    [BsonElement("genres")]
11
    public List<string> Genres { get; set; }
12
13
    [BsonElement("runtime")]
14
    public int Runtime { get; set; }
15
16
    [BsonElement("cast")]
17
    public List<string> Cast { get; set; }
18
19
    [BsonElement("num_mflix_comments")]
20
    public int NumMflixComments { get; set; }
21
22
    [BsonElement("poster")]
23
    public string Poster { get; set; }
24
25
    [BsonElement("title")]
26
    public string Title { get; set; }
27
28
    [BsonElement("fullplot")]
29
    public string Fullplot { get; set; }
30
31
    [BsonElement("languages")]
32
    public List<string> Languages { get; set; }
33
34
    [BsonElement("released")]
35
    public DateTime Released { get; set; }
36
37
    [BsonElement("directors")]
38
    public List<string> Directors { get; set; }
39
40
    [BsonElement("writers")]
41
    public List<string> Writers { get; set; }
42
43
    [BsonElement("awards")]
44
    public Awards Awards { get; set; }
45
46
    [BsonElement("rated")]
47
    public string? Rated { get; set; }
48
49
    [BsonElement("lastupdated")]
50
    public string Lastupdated { get; set; }
51
52
53
    [BsonElement("year")]
54
    public object Year { get; set; }
55
56
    [BsonElement("imdb")]
57
    public Imdb Imdb { get; set; }
58
59
    [BsonElement("countries")]
60
    public List<string> Countries { get; set; }
61
62
    [BsonElement("type")]
63
    public string Type { get; set; }
64
65
    [BsonElement("tomatoes")]
66
    public Tomatoes Tomatoes { get; set; }
67
68
    [BsonElement("metacritic")]
69
    public int? Metacritic { get; set; }
70
71
    [BsonElement("awesome")]
72
    public bool? Awesome { get; set; }
73
}
74
75
public class Awards
76
{
77
    [BsonElement("wins")]
78
    public int Wins { get; set; }
79
80
    [BsonElement("nominations")]
81
    public int Nominations { get; set; }
82
83
    [BsonElement("text")]
84
    public string Text { get; set; }
85
}
86
87
public class Imdb
88
{
89
    [BsonElement("id")]
90
    public object ImdbId { get; set; }
91
92
    [BsonElement("votes")]
93
    public object Votes { get; set; }
94
95
    [BsonElement("rating")]
96
    public object Rating { get; set; }
97
}
98
99
public class Tomatoes
100
{
101
    [BsonElement("viewer")]
102
    public Viewer Viewer { get; set; }
103
104
    [BsonElement("lastUpdated")]
105
    public DateTime LastUpdated { get; set; }
106
107
    [BsonElement("dvd")]
108
    public DateTime? DVD { get; set; }
109
110
    [BsonElement("website")]
111
    public string? Website { get; set; }
112
113
    [BsonElement("production")]
114
    public string? Production { get; set; }
115
116
    [BsonElement("critic")]
117
    public Critic? Critic { get; set; }
118
119
    [BsonElement("rotten")]
120
    public int? Rotten { get; set; }
121
122
    [BsonElement("fresh")]
123
    public int? Fresh { get; set; }
124
125
    [BsonElement("boxOffice")]
126
    public string? BoxOffice { get; set; }
127
128
    [BsonElement("consensus")]
129
    public string? Consensus { get; set; }
130
131
}
132
133
public class Viewer
134
{
135
    [BsonElement("rating")]
136
    public double Rating { get; set; }
137
138
    [BsonElement("numReviews")]
139
    public int NumReviews { get; set; }
140
141
    [BsonElement("meter")]
142
    public int Meter { get; set; }
143
}
144
145
public class Critic
146
{
147
    [BsonElement("rating")]
148
    public double Rating { get; set; }
149
150
    [BsonElement("numReviews")]
151
    public int NumReviews { get; set; }
152
153
    [BsonElement("meter")]
154
    public int Meter { get; set; }
155
}

1
using MongoDB.Bson;
2
using MongoDB.Bson.Serialization.Attributes;

1
private static async Task FetchAndSaveMovieDocuments(ISemanticTextMemory memory, int limitSize)
2
    {
3
        MongoClient mongoClient = new MongoClient(MongoDBAtlasConnectionString);
4
        var movieDB = mongoClient.GetDatabase("sample_mflix");
5
        var movieCollection = movieDB.GetCollection<Movie>("movies");
6
        List<Movie> movieDocuments;
7
8
        Console.WriteLine("Fetching documents from MongoDB...");
9
10
        movieDocuments = movieCollection.Find(m => true).Limit(limitSize).ToList();
11
12
        movieDocuments.ForEach(movie =>
13
        {
14
            if (movie.Plot == null)
15
            {
16
                movie.Plot = "UNKNOWN";
17
            }
18
        });
19
20
        foreach (var movie in movieDocuments)
21
        {
22
            try
23
            {
24
                await memory.SaveReferenceAsync(
25
                collection: CollectionName,
26
                description: movie.Plot,
27
                text: movie.Plot,
28
                externalId: movie.Title,
29
                externalSourceName: "Sample_Mflix_Movies",
30
                additionalMetadata: movie.Year.ToString());
31
            }
32
            catch (Exception ex)
33
            {
34
                Console.WriteLine(ex.Message);
35
36
            }
37
        }
38
    }

1
{
2
  "fields": [
3
    {
4
      "numDimensions": 1536,
5
      "path": "embedding",
6
      "similarity": "dotProduct",
7
      "type": "vector"
8
    }
9
  ]
10
}

1
Console.WriteLine("Welcome to the Movie Recommendation System!");
2
Console.WriteLine("Type 'x' and press Enter to exit.");
3
Console.WriteLine("============================================");
4
Console.WriteLine();
5
6
while(true)
7
{
8
    Console.WriteLine("Tell me what sort of film you want to watch..");
9
    Console.WriteLine();
10
11
    Console.Write("> ");
12
13
    var userInput = Console.ReadLine();
14
15
    if(userInput.ToLower() == "x")
16
    {
17
        Console.WriteLine("Exiting application..");
18
        break;
19
    }
20
21
    Console.WriteLine();
22
23
    var memories = memory.SearchAsync(CollectionName, userInput, limit: 3, minRelevanceScore: 0.6);
24
25
    Console.WriteLine(String.Format("{0,-20} {1,-50} {2,-10} {3,-15}", "Title", "Plot", "Year", "Relevance (0 - 1)"));
26
    Console.WriteLine(new String('-', 95)); // Adjust the length based on your column widths
27
28
    await foreach (var mem in memories)
29
    {
30
        Console.WriteLine(String.Format("{0,-20} {1,-50} {2,-10} {3,-15}", 
31
            mem.Metadata.Id, 
32
            mem.Metadata.Description.Length > 47 ? mem.Metadata.Description.Substring(0, 47) + "..." : mem.Metadata.Description, // Truncate long descriptions
33
            mem.Metadata.AdditionalMetadata, 
34
            mem.Relevance.ToString("0.00"))); // Format relevance score to two decimal places
35
    }
36
}