agiletiger / agiletiger/ojotas

investigate: using sql aliases to give hints to ojotas on how do the assemble

Abierto
#3 2 comentarios 0 reacciones 1 asignado Reclamado por @ivanlolivier Ver en GitHub
Lenguaje dominante
TypeScript
Estrellas
9
Forks
4
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

today ojotas needs a list of identifiers to know how to do the assemble when querying an entity with its relations
it also needs a config file, the ojotasrc.json with aliases and relations

another way would be to have sql queries like this one

```sql
select
u.name as 'name',
p.title as 'posts[].title',
p.content as 'posts[].content'
from
users u left join
posts p on u.id = p.user_id
;
```

with this we would not need the configuaration file and it will be more flexible like if we want to return a single post we could do

```sql
select
u.name as 'name',
p.title as 'lastPost.title',
p.content as 'lastPost.content'
from
users u left join
posts p on u.id = p.user_id
where
u.id = 1
order by p.createdAt desc
limit 1
;
```

instrad of having an array with just one post we could directy have an object lastPost.

I believe both ways could co exist depending on user preference on how to work

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.