Migrate current harness tests to sqlness

[ShiKaiWi]

Describe This Problem

sqlness has been created as a separated repo, but ceresdb doesn't use it now.

Proposal

Let's migrate the harness tests to the sqlness.

Additional Context

No response

[jiacai2050]

There is no docs for sqlness, so this may not very friendly for volunteers...

[dust1]

maybe I can do it. Can you assign it to me?

[jiacai2050]

Yeah, go ahead.

There is a pending PR to update client, we will merge this soon, you can first figure out how to use sqlness framework since there are no docs for it.

[dust1]

ok, I will create a new project to using sqlness.

[ShiKaiWi]

ok, I will create a new project to using sqlness.

Actually, sqlness is almost same as the codes in the https://github.com/CeresDB/ceresdb/tree/main/tests/harness, maybe there is no need to create a new project?

[dust1]

Actually, sqlness is almost same as the codes in the https://github.com/CeresDB/ceresdb/tree/main/tests/harness, maybe there is no need to create a new project?

yes, I mean i will try sqlness in another new project before this pr merge

[jiacai2050]

@dust1 I have bump client to latest version in this PR #409, so there is nothing blocking this.

[waynexia]

There is no docs for sqlness, so this may not very friendly for volunteers...

Currently, it only contains docs within the doc comment (///). Since this crate is not published yet, you need to run cargo doc --open to open it 🥲 Not very convenient but it should be better after our first publish.

[jiacai2050]

Got it, I will try to publish to crates.io when #473 is finished(ensure everything works as expected, and CeresDB can be used for demonstration).

[dust1]

Do you need to add a new environment if you want to demonstrate? Currently only local

[jiacai2050]

Multiple envs demo is required before publish, we can add it in sqlness repo.

We can create a demo project here, such as

$tree examples/
examples/
├── distributed
│   └── select.sql
└── local
    └── select.sql