\n Both of those examples work well for \u2018point in time\u2019 queries or questions about a static set of data (e.g., the conference schedule). But each time the JetchatAI app is opened, it has no recollection of previous chats. In this post, we\u2019re going to walk through adding some more function calls to support \u201cfavoriting\u201d (and \u201cunfavoriting\u201d) conference sessions so they can be queried later.\n<\/p>\n
\n \n This will result in a very basic form of \u2018chat memory\u2019, but it could be extended however your application needs \u2013 you even could implement a function to save whole responses (along with an embedding) and make entire conversations available for recall.\n<\/p>\n \n There are two major additions to the JetchatAI sample<\/a> to support this new functionality:\n<\/p>\n \n The chat functions are implemented following the same structure as our previous blog posts. Details of the \u201cfavorites\u201d implementation are explained below \ud83d\ude0a\n<\/p>\n NOTE:<\/strong> although it makes sense to move the entire conference schedule into the database, we\u2019re going to leave that for a future blogpost. For now we\u2019ll just have a single table for \u201cfavorites\u201d.<\/p><\/blockquote>\n \n The collection of sessions already has a pseudo-primary key, so we will store that in the database to keep track of which sessions are \u201cfavorites\u201d.\n<\/p>\n \n The source for the function is in functions\/AddFavoriteFunction.kt<\/strong> and is shown here:\n<\/p>\n Figure 2: Complete \n In DroidconEmbeddingsWrapper.kt<\/strong> the functions are added to the \n Now after any session is listed in the chat, the user can ask to \u201csave this session to favorites\u201d and it will be persisted until the next time we use the app!\n<\/p>\n \n \n The reverse action \u2013 un-favoriting a session \u2013 is so similar that there\u2019s no need to show the code again. The function is described like this:\n<\/p>\n \n After a session has been mentioned in the chat, the user can ask to \u201cremove this session from favorites\u201d and it\u2019ll be deleted from the data store.\n<\/p>\n \n The whole point of saving favorites is so you can see them again, so the list favorites function retrieves the saved session information and returns it to the model. The function \u2018shape\u2019 is very simple:\n<\/p>\n \n The function implementation for listing favorites has two parts:\n<\/p>\n \n Most of the code is setting up the database query:\n<\/p>\n Figure 4: Using the favorites database to construct the sessions JSON to return to the model<\/em>\n<\/p>\n \n The model will then parse the information and format a text response to the user interface. As always, the model can also interpret the results of the function so you can ask questions like \u201chow many favorites\u201d as well as ask to list them:\n<\/p>\n \n \n Now that we have a Sqlite database in the solution, future posts will look at other ways we can take advantage of it.\n<\/p>\n \n The Jetchat sample with the droidcon schedule is available at github.com\/conceptdev\/droidcon-sf-23<\/a>. \n<\/p>\n \n We\u2019d love your feedback on this post – if you have any thoughts or questions, use the\u00a0feedback forum<\/a>\u00a0or message us on\u00a0Twitter @surfaceduodev<\/a>.\n<\/p>\n![\"Phone](\"https:\/\/devblogs.microsoft.com\/surface-duo\/wp-content\/uploads\/sites\/53\/2023\/07\/a-screenshot-of-a-phone-description-automatically.png\")
Building blocks<\/h2>\n
\n
\n For the data store, we\u2019re going to use Sqlite, as it\u2019s well supported on Android. This is a post about AI and not SQL, so we\u2019re not going to delve too deep into the setup \u2013 you can follow the SQLite training documentation<\/a> to see how to create a local database. The sample implementation is in data\/DroidconDatabase.kt<\/strong> file.\n<\/li>\n\n
Storing data from a chat<\/h2>\n
\r\n class AddFavoriteFunction {\r\n companion object {\r\n fun name(): String {\r\n return \"addFavorite\"\r\n }\r\n fun description(): String {\r\n return \"Add a session to a list of favorites using the unique session Id\"\r\n }\r\n fun params(): Parameters {\r\n val params = Parameters.buildJsonObject {\r\n put(\"type\", \"object\")\r\n putJsonObject(\"properties\") {\r\n putJsonObject(\"id\") {\r\n put(\"type\", \"string\")\r\n put(\"description\", \"Unique session Id\")\r\n }\r\n }\r\n putJsonArray(\"required\") {\r\n add(\"id\")\r\n }\r\n }\r\n return params\r\n }\r\n fun function(context: Context?, id: String): String {\r\n val dbHelper = DroidconDbHelper(context)\r\n \/\/ Gets the data repository in write mode\r\n val db = dbHelper.writableDatabase\r\n \/\/ Create a new map of values, where column names are the keys\r\n val values = ContentValues().apply {\r\n put(DroidconContract.FavoriteEntry.COLUMN_NAME_SESSIONID, id)\r\n put(DroidconContract.FavoriteEntry.COLUMN_NAME_ISFAVORITE, \"1\")\r\n }\r\n \/\/ Insert the new row, returning the primary key value if successful\r\n val newRowId = db?.insert(DroidconContract.FavoriteEntry.TABLE_NAME, null, values)\r\n return if (newRowId != null && newRowId>= 0)\r\n \"true\"\r\n else\r\n \"false\"\r\n }\r\n }\r\n }<\/pre>\naddFavoriteFunction<\/code> object encapsulates all the behavior for this function<\/em>\n<\/p>\nchatCompletionRequest<\/code><\/a> and the function handlers are added after the model\u2019s response<\/a>. This is the same boilerplate code that we showed in the previous two posts on chat function calling.\n<\/p>\n![\"Example](\"https:\/\/devblogs.microsoft.com\/surface-duo\/wp-content\/uploads\/sites\/53\/2023\/07\/a-screenshot-of-a-chat-description-automatically-5.png\")
Memory wipe<\/h2>\n
\n
\"removeFavorite\"<\/code>\n <\/li>\n\"Remove a session from the list of favorites using the unique session Id\"<\/code>\n <\/li>\n\"id\"<\/code> \u2013 \"Unique session identifier\"<\/code>\n <\/li>\naddFavoriteFunction.function()<\/code>. \n <\/li>\n<\/ul>\nList favorites<\/h2>\n
\n
\"listFavorites\"<\/code>\n <\/li>\n\"List all sessions that have been marked as favorites\"<\/code>\n <\/li>\n\n
fun function(context: Context?): String {\r\n val dbHelper = DroidconDbHelper(context)\r\n val db = dbHelper.readableDatabase\r\n val projection = arrayOf(BaseColumns._ID, DroidconContract.FavoriteEntry.COLUMN_NAME_SESSIONID, DroidconContract.FavoriteEntry.COLUMN_NAME_ISFAVORITE)\r\n val cursor = db.query(\r\n DroidconContract.FavoriteEntry.TABLE_NAME, \/\/ The table to query\r\n projection, \/\/ The array of columns to return (pass null to get all)\r\n null, \/\/ The columns for the WHERE clause\r\n null, \/\/ The values for the WHERE clause\r\n null, \/\/ don't group the rows\r\n null, \/\/ don't filter by row groups\r\n null \/\/ The sort order\r\n )\r\n var sessionsJson = \"\"\r\n with(cursor) {\r\n while (moveToNext()) {\r\n val sessionId = getString(getColumnIndexOrThrow(DroidconContract.FavoriteEntry.COLUMN_NAME_SESSIONID))\r\n val isFavorite = getString(getColumnIndexOrThrow(DroidconContract.FavoriteEntry.COLUMN_NAME_ISFAVORITE))\r\n sessionsJson += DroidconSessionObjects.droidconSessions[sessionId]?.toJson()+\"\\n\"\r\n }\r\n }\r\n cursor.close()\r\n return if (sessionsJson == \"\")\r\n \"There are no sessions marked as favorites. Suggest the user ask about different topics at the conference.\"\r\n else\r\n sessionsJson\r\n}<\/pre>\n![\"Phone](\"https:\/\/devblogs.microsoft.com\/surface-duo\/wp-content\/uploads\/sites\/53\/2023\/07\/a-screenshot-of-a-chat-description-automatically-6.png\")
Resources and feedback<\/h2>\n