Add E2E tests for Trino Data Source

[fredalai]

Summary

We need contributors to help develop end-to-end (E2E) tests for the Trino data source. The goal is to cover the entire onboarding process—from connecting Trino to reaching the home page after successful data source setup.

Description

The goal is to ensure the entire onboarding flow for Trino works as expected, including:

• Connect to Trino by selecting it as a data source and filling out the connection details (e.g., host, port, username, password...etc).
• Select all tables as data models.
• Accept all recommended relationships if they have.
• Successfully reach the home page after completing the setup process.

Develop

Note:

• You may run a Trino docker container locally and connect it.
  • local host Trino container, use: https://hub.docker.com/r/trinodb/trino
    • Default username: admin
    • no default password
• When development is complete, please execute CLI to run the tests and include the results in your PR. Ensure that at least the test you added is included, e.g.,: yarn test:e2e e2e/specs/connectTrino.spec.ts

References:

• Use Playwright for writing the E2E tests, please refer to the WrenAI E2E testing README to develop.
• Feel free to explore our existing codebase, we also have shared functions and test cases in our current test suite to help you get started: WrenAI E2E Specs

[princetoday]

I would like to work on this issue. Please assign it to me.

[fredalai]

Hi @princetoday

Thank you for your interest in the issues! We appreciate it.

However, for the Hacktoberfest events, we will only assign one ticket to the same person at a time.

Feel free to work on multiple issues simultaneously, but we will only assign one issue to a person at a time. This means you can submit two pull requests simultaneously, but we won't assign more than one issue to you at once.

Looking forward to your contribution!

[Tryxns]

Hi @fredalai, I want to resolve this issue, may I be the assignee?

[chilijung]

@Tryxns assigned.

[Tryxns]

Hi @chilijung @fredalai , I think I'm not ready yet to resolve this issue so I unassigned myself. Thanks for the chance given :pray:

[saai-syvendra]

Hi @fredalai!

When I selected all the tables from "tiny" Schema from the "tcph" Catalog, I got the following error message

"UNIQUE constraint failed: model_column.model_id, model_column.reference_name" with this error in the console.

Can you guide me on what this error is please

[fredalai]

@Tryxns It's fine. :) Thank you for taking the time to work on this issue. If you feel ready to take on similar tasks in the future, we’d be happy to have you involved again.

[onlyjackfrost]

@saai-syvendra Sorry about that, It's a bug on Wren Engine. https://github.com/Canner/wren-engine/issues/833 We'll fix it ASAP. Thanks for raising this =D

[ongdisheng]

Hi @fredalai, may I work on this issue if it's still available?

[onlyjackfrost]

@saai-syvendra https://github.com/Canner/wren-engine/issues/833 had been solved. You can pull the latest Wren Engine and continue setting it up.

[onlyjackfrost]

@saai-syvendra BTW were you working on this issue or just reporting the problem you encountered?

[saai-syvendra]

@onlyjackfrost alrights.. Yes, I encountered this while running the tests.. Will rerun the tests and make a PR

[fredalai]

Hi @ongdisheng, It seems like @saai-syvendra has been working on this issue and has submitted a PR.

Thank you for your interest and for keeping an eye on this!

[ongdisheng]

@fredalai, no worries.