[Manual Test] Create and run tests on the Crate DB integration

[martyna-mindsdb]

MindsDB integrates with numerous data sources, ML frameworks, and AI models. All MindsDB integrations can be found here.

Task

The task is to test all available features of the Crate DB handler whose code is available here.

Deliverables

✅ If the tests are successful, please share the screenshots below in the comment section of this issue.

❌ If the tests fail, please create a bug issue describing the failed tests.

:loudspeaker: Additional rewards :trophy:

This issue brings :three: :zero: points for SWAG and entry into the draw for a :point_down: :

• :three: :x: :computer: Razer Blade 16 Gaming Laptop
• :shirt: :bear: MindsDB Swag

:information_source: For more info check out https://mindsdb.com/hacktoberfest :point_left:

---

NOTE: Multiple contributors can work on this issue simultaneously without being assigned. Upon completion, share the screenshots below (if tests succeeded) or create a bug issue (if tests failed).

[Sekhar-Kumar-Dash]

database creation

select query not working for crate database hosted on cloud

[ritwickrajmakhal]

Works fine on localhost ✅

Screencast from 2024-10-19 02-27-25.webm

Works fine on remote host with http ✅

Screencast from 2024-10-19 13-00-25.webm

[Better-Boy]

This handler is working fine after the fix.

[mohitrajsinha]

crateDB.webm

[Rutam21]

Test Complete and Successful

The following tasks were carried out during testing.

• Creating a CrateDB datasource on MindsDB.
• Viewing tables present in CrateDB on the MindsDB console.
• Executing a SELECT on all items of the Table.
• Executing a SELECT with LIMITS.
• Executing a SELECT with WHERE Clause.
• Executing INSERT for a Single Row.
• Executing INSERT for Multiple Rows.
• Executing DELETE for a Single Row.
• Executing DELETE for Multiple Rows.
• Executing DROP to delete the CrateDB datasource.

Here's an attached video for confirmation.

https://github.com/user-attachments/assets/2b6bd1da-cac8-4010-987a-535d0283fd52

cc: @martyna-mindsdb