anitnilay20 / anitnilay20/beatrix

Implement MySQL aggregation and window functions

Aperta
#22 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub
mysql query-builder
Lingua principale
Rust
Stelle
1
Fork
0
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

## Description
Add MySQL aggregation functions and window functions support.

## Requirements
- [ ] Basic aggregations (COUNT, SUM, AVG, MIN, MAX)
- [ ] GROUP BY with ROLLUP, CUBE
- [ ] Window functions (ROW_NUMBER, RANK, DENSE_RANK)
- [ ] MySQL-specific functions (GROUP_CONCAT)
- [ ] JSON aggregation functions
- [ ] Write comprehensive tests

## Acceptance Criteria
- Full aggregation support for MySQL
- Window functions available
- MySQL-specific aggregation functions
- JSON aggregation support

## Files to modify
- `beatrix_core/src/relational/aggregation.rs`
- `beatrix_core/src/relational/functions/mysql.rs`

## Example Usage
```rust
let results = Order::select()
.select_field(group_concat(Order::product_name()).separator(", "))
.select_field(row_number().over().order_by(Order::total().desc()))
.group_by(Order::user_id())
.fetch_all(&db).await?;
```

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.