SeaQL / SeaQL/sea-orm

Expect GROUP_CONCAT aggregration funciton

Open
#3,186 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Rust
Stars
9.9k
Forks
734
Avg merge
6h 36m
Merged PRs (30d)
8

Description

Expect Column api to support concatenate string of aggregation function
Since there are different usage and function name between sqlite, postgresql, mysql

e.g

fn group_conncat<C>(&self, separator: Option<&str>, order_by: Option<C>) -> Expr {
    todo!()
}

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the Column API and existing aggregation-function support, then compare how SQLite, PostgreSQL, and MySQL express string aggregation. Define how separator and order_by should map across those dialects; done means the API supports the requested GROUP_CONCAT-style operation for the named databases with coverage for its generated SQL.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, postgresql, rust, sqlite
Domain
backend-api-design, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.