[Manual QA] Test MongoDB Handler Manually

[Rutam21]

At MindsDB, we are driven by the open-source community 💚. So, this Hacktoberfest we aim to ask our community to review the MindsDB Database handlers in-depth and provide us with their feedback/observations.

What

Your task is to manually complete the following tasks using the MongoDB Handler.

• CREATE DATABASE

  This confirms that you are able to connect your Database. Please attach a screenshot once this step executes succesfully.

• CREATE PREDICTOR

  This confirms that you are able to create a Predictor model. Please attach a screenshot once this step executes succesfully.

• Predict Target value from Predictor using SELECT FROM

  This confirms that your predictor model is able predict the target values for you. Please attach a screenshot once this step executes succesfully.

How

Run the commands and record your observations in the following format in mindsdb/integrations/handlers/mongodb_handler/Manual_QA.md.

## Testing MongoDB Handler with [Dataset Name](URL to the Dataset)

1. Testing CREATE DATABASE

COMMAND THAT YOU RAN TO CREATE DATABASE. [Format it in code blocks using ```]

![CREATE_DATABASE](Image URL of the screenshot)

2. Testing CREATE PREDICTOR

COMMAND THAT YOU RAN TO CREATE PREDICTOR. [Format it in code blocks using ```]

![CREATE_PREDICTOR](Image URL of the screenshot)

3. Testing SELECT FROM PREDICTOR

COMMAND THAT YOU RAN TO DO A SELECT FROM. [Format it in code blocks using ```]

![SELECT_FROM](Image URL of the screenshot)

### Results

Drop a remark based on your observation.
- [ ] Works Great 💚 (This means that all the steps were executed successfuly and the expected outputs were returned.)
- [ ] There's a Bug 🪲 [Issue Title](URL To the Issue you created) (This means you encountered a Bug. Please open an issue with all the relevant details with the Bug Issue Template)

• NOTE: We are not assigning this issue, multiple people can make the PRs.
• But you must use an unique dataset for your QA test that's not already used.
• Simply drop a comment below mentioning the dataset you will be working on.
• Your entry in the QA file must have execution of the 3 required commands followed by the respective screenshots.
• Also, if you find a bug, it is mandatory for you to raise a Bug Issue and attach the Issue at the Result section as mentioned in the template above.

📢 Additional rewards 🏆

Each QA PR brings 1️⃣ : point and with every 10 points you get an entry into the draw for a 👇 :

• 💻 Razer Blade 15 Laptop
• 🎧 10 cool audio gadgets
• 👕 🐻 MindsDB Swag
• ℹ️ For more info check out https://mindsdb.com/hacktoberfest/ 👈

[rexdivakar]

Hey @ZoranPandovski i would like to work on this, kindly assign it to me!

[EshaanAgg]

Hey @ZoranPandovski! I would like to work on this issue as well. I would like to test it with the Titanic dataset.

[EshaanAgg]

Hey! I am using MongoDB Compass to host my database. I am able to connect to it, and I have given the user the role of AltasAdmin to ensure all permissions. Yet I get this error when I run this command. Can someone help me with this?

[ZoranPandovski]

@EshaanAgg you will need to use compass or mongo shell to connect to mindsdb since MindsDB Editor is only for SQL.

[Leigh-Ola]

@Rutam21 I'd love to work on this, please assign it to me

[Rutam21]

@Leigh-Ola This issue is open to all. Feel free to use a new dataset and complete the task. Thanks.

[sajdakabir]

@Rutam21 Can I work on this issue?

[Rutam21]

@sajdakabir Yes, feel free to work on this. Just mention the dataset you'll be using to test this handler. The dataset needs to be unique and not previously used by anyone else to test it here. All the best 👍

[ShruAgarwal]

Hey, @ZoranPandovski 👋

I kindly request you to please close this issue as it is fixed with this PR!

Thanks! :)