Reply to thread

Message

<blockquote data-quote="ge2301" data-source="post: 1295771" data-attributes="member: 145639">Yes, it was initially due to the token limitation, but then I changed it with manual limitation of media items. In the end a flexible solution, that counts the needed token and splits the query into jobs would be best. Also the merge into movieListText could be combined into the SQLite DB import function, it was just a trial to check if it'S generally doable <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" />Current code is as below:[CODE=csharp]using System;using System.Collections.Generic;using System.Data.SQLite;using System.Text;using System.Threading.Tasks;using System.Windows;using System.Windows.Controls;using OpenAI_API.Completions;using OpenAI_API;namespace MovieSearchApp{&nbsp; &nbsp; public partial class MainWindow : Window&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; private const string ConnectionString = &quot;Data Source=C:\\ProgramData\\Team MediaPortal\\MP2-Server\\Database\\Datastore.s3db;Version=3;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; private const string OpenAIApiKey = &quot;*******************&quot;;&nbsp; &nbsp; &nbsp; &nbsp; private string movieListText; // Variable to hold the concatenated movie titles&nbsp; &nbsp; &nbsp; &nbsp; public MainWindow()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; InitializeComponent();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PopulateMovieList();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private void PopulateMovieList()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string sql = &quot;SELECT MOVIENAME FROM M_MOVIEITEM;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (SQLiteCommand command = new SQLiteCommand(sql, connection))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (SQLiteDataReader reader = command.ExecuteReader())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (reader.Read())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string movieTitle = reader[&quot;MOVIENAME&quot;].ToString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; movieListBox.Items.Add(movieTitle);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Call the method to join ListBox items into a string&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; movieListText = JoinListBoxItemsToString(movieListBox);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; string JoinListBoxItemsToString(ListBox listBox)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Create a StringBuilder to efficiently concatenate strings&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; StringBuilder resultBuilder = new StringBuilder();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Iterate through each item in the ListBox&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //foreach (object item in listBox.Items)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Append the item to the StringBuilder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //&nbsp; &nbsp; resultBuilder.Append(item.ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Add &quot;;&quot; as a separator for the next item&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //&nbsp; &nbsp; resultBuilder.Append(&quot;;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Remove the trailing &quot;;&quot; if there are items in the ListBox&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //if (listBox.Items.Count &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //&nbsp; &nbsp; resultBuilder.Length--; // Remove the last character&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Limit the loop to the first 300 items&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int itemsToConcatenate = Math.Min(listBox.Items.Count, 300);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Iterate through each item in the ListBox&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (int i = 0; i &lt; itemsToConcatenate; i++)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Append the item to the StringBuilder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; resultBuilder.Append(listBox.Items[i].ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Add &quot;;&quot; as a separator for the next item&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; resultBuilder.Append(&quot;;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Remove the trailing &quot;;&quot; if there are items in the ListBox&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (itemsToConcatenate &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; resultBuilder.Length--; // Remove the last character&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Return the final joined string&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return resultBuilder.ToString();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private async void SearchButton_Click(object sender, RoutedEventArgs e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string searchQuery = searchTextBox.Text.Trim();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (string.IsNullOrEmpty(searchQuery))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show(&quot;Please enter a search query.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Use ChatGPT to generate responses based on the search question&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; List&lt;string&gt; bestMatches = await GetBestMovieMatches(searchQuery);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Display the results&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; resultListBox.ItemsSource = bestMatches;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception ex)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show($&quot;An error occurred: {ex.Message}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private async Task&lt;List&lt;string&gt;&gt; GetBestMovieMatches(string searchQuery)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Use ChatGPT to determine the matches&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string generatedText = await GenerateResponseWithGPT(searchQuery, movieListText);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Split the generated text into a list of matches&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; List&lt;string&gt; bestMatches = new List&lt;string&gt;(generatedText.Split(';'));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return bestMatches;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private async Task&lt;string&gt; GenerateResponseWithGPT(string searchQuery, string movieListText)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APIAuthentication aPIAuthentication = new APIAuthentication(OpenAIApiKey);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OpenAIAPI openAiApi = new OpenAIAPI(aPIAuthentication);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string prompt = $&quot;List all movies from the list fitting to the search query: {searchQuery}. Movies: {movieListText}&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string model = &quot;text-davinci-003&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; int maxTokens = 50;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var completionRequest = new CompletionRequest&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Prompt = prompt,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Model = model,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MaxTokens = maxTokens&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var completionResult = await openAiApi.Completions.CreateCompletionAsync(completionRequest);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var generatedText = completionResult.Completions[0].Text; //completionResult.Choices[0].Text.Trim();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return generatedText;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception ex)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MessageBox.Show($&quot;An error occurred: {ex.Message}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return &quot;error&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]</blockquote>

[QUOTE="ge2301, post: 1295771, member: 145639"] Yes, it was initially due to the token limitation, but then I changed it with manual limitation of media items. In the end a flexible solution, that counts the needed token and splits the query into jobs would be best. Also the merge into movieListText could be combined into the SQLite DB import function, it was just a trial to check if it'S generally doable ;) Current code is as below: [CODE=csharp]using System; using System.Collections.Generic; using System.Data.SQLite; using System.Text; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using OpenAI_API.Completions; using OpenAI_API; namespace MovieSearchApp { public partial class MainWindow : Window { private const string ConnectionString = "Data Source=C:\\ProgramData\\Team MediaPortal\\MP2-Server\\Database\\Datastore.s3db;Version=3;"; private const string OpenAIApiKey = "*******************"; private string movieListText; // Variable to hold the concatenated movie titles public MainWindow() { InitializeComponent(); PopulateMovieList(); } private void PopulateMovieList() { using (SQLiteConnection connection = new SQLiteConnection(ConnectionString)) { connection.Open(); string sql = "SELECT MOVIENAME FROM M_MOVIEITEM;"; using (SQLiteCommand command = new SQLiteCommand(sql, connection)) using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { string movieTitle = reader["MOVIENAME"].ToString(); movieListBox.Items.Add(movieTitle); } } } // Call the method to join ListBox items into a string movieListText = JoinListBoxItemsToString(movieListBox); } string JoinListBoxItemsToString(ListBox listBox) { // Create a StringBuilder to efficiently concatenate strings StringBuilder resultBuilder = new StringBuilder(); // Iterate through each item in the ListBox //foreach (object item in listBox.Items) //{ // Append the item to the StringBuilder // resultBuilder.Append(item.ToString()); // Add ";" as a separator for the next item // resultBuilder.Append(";"); //} // Remove the trailing ";" if there are items in the ListBox //if (listBox.Items.Count > 0) // // resultBuilder.Length--; // Remove the last character //} // Limit the loop to the first 300 items int itemsToConcatenate = Math.Min(listBox.Items.Count, 300); // Iterate through each item in the ListBox for (int i = 0; i < itemsToConcatenate; i++) { // Append the item to the StringBuilder resultBuilder.Append(listBox.Items[i].ToString()); // Add ";" as a separator for the next item resultBuilder.Append(";"); } // Remove the trailing ";" if there are items in the ListBox if (itemsToConcatenate > 0) { resultBuilder.Length--; // Remove the last character } // Return the final joined string return resultBuilder.ToString(); } private async void SearchButton_Click(object sender, RoutedEventArgs e) { try { string searchQuery = searchTextBox.Text.Trim(); if (string.IsNullOrEmpty(searchQuery)) { MessageBox.Show("Please enter a search query."); return; } // Use ChatGPT to generate responses based on the search question List<string> bestMatches = await GetBestMovieMatches(searchQuery); // Display the results resultListBox.ItemsSource = bestMatches; } catch (Exception ex) { MessageBox.Show($"An error occurred: {ex.Message}"); } } private async Task<List<string>> GetBestMovieMatches(string searchQuery) { // Use ChatGPT to determine the matches string generatedText = await GenerateResponseWithGPT(searchQuery, movieListText); // Split the generated text into a list of matches List<string> bestMatches = new List<string>(generatedText.Split(';')); return bestMatches; } private async Task<string> GenerateResponseWithGPT(string searchQuery, string movieListText) { APIAuthentication aPIAuthentication = new APIAuthentication(OpenAIApiKey); OpenAIAPI openAiApi = new OpenAIAPI(aPIAuthentication); try { string prompt = $"List all movies from the list fitting to the search query: {searchQuery}. Movies: {movieListText}"; string model = "text-davinci-003"; int maxTokens = 50; var completionRequest = new CompletionRequest { Prompt = prompt, Model = model, MaxTokens = maxTokens }; var completionResult = await openAiApi.Completions.CreateCompletionAsync(completionRequest); var generatedText = completionResult.Completions[0].Text; //completionResult.Choices[0].Text.Trim(); return generatedText; } catch (Exception ex) { MessageBox.Show($"An error occurred: {ex.Message}"); return "error"; } } } }[/CODE] [/QUOTE]

Verification