RasaX and Mysql integration

[Deprecated] Rasa X Community Edition
1

Hello. Please forgive me but I have no other place to ask this question. I will like to create a Rasa chat-bot to tell me what I can cook with the ingredients that I have. I create an test database in MySQL in which I added two tables as fallows:

CREATE TABLE `Cake` (
  `Name:` varchar(255) NOT NULL,
  `Sugar` varchar(255) NOT NULL,
  `Milk` varchar(255) NOT NULL,
  `Eggs` varchar(255) NOT NULL,
  `Cacao` varchar(255) NOT NULL,
  `Flower` varchar(255) NOT NULL,
  UNIQUE KEY `Name:` (`Name:`),
  KEY `id` (`Name:`)
)

CREATE TABLE `Bread` (
  `Name:` varchar(255) NOT NULL,
  `Salt` varchar(255) NOT NULL,
  `Eggs` varchar(255) NOT NULL,
  `Flower` varchar(255) NOT NULL,
  UNIQUE KEY `Name:` (`Name:`),
  KEY `id` (`Name:`)
)

For now the Rasa X bot is giving me the greetings and ask me which ingredients I have. Can I use the bot to make a query into the database contain the column name in order to obtain the all the table names and to calculate the percentages??

Example:

If I will insert “Flower” for an example the bot should response that I have 25% ingredients to make Bread and 10 % ingredients to make a Cake.

Thank you for your support

2

Hello @WeissWilly,

welcome to the community!

If I understood correctly, the answer is yes.

You need to create a custom action and the return of this custom action would be whatever you want after applying any logic/treatment you need.

Cya!

3

Thank you

4

@WeissWilly

No problem, glad it helped you! :smiley:

Just mark the reply as solution to facilitate other to search answers (or topics to help).

Cya!