Hi @benjie, just wanted to pop in and say that this project, your handling of it, the docs, support, and community is awesome all around. Postgraphile is a powerful, idomatic, and elegant tool. I may start using it for customer projects and if so, would eventually like to dive into the internals and maybe contribute a bit. Thanks for your efforts on this. Just learned a lot about my own use cases through reading a bunch of your answers in github issues
Contribution to the core would be welcome also; the API is pretty much fixed now so I think the thing that needs the most work is
graphile-utils to make plugin factories to make doing things a lot easier for people. For example, there really should be an inflector plugin factory that enables you to override the inflector. Anyway I'm getting ahead of myself.
And why
nodes: [Move]! node item not marked as not null? [Move!]!
flow types from schema (relay) are optional and I have many errors like this:
Cannot get allProducts.nodes because property nodes is missing in null or undefined [1].
Cannot get allProducts.nodes because property nodes is missing in null or undefined [1].
I really want a hubot in this channel so I can program a bunch of lookups like this 🙂
Also I'm doing the Reactiflux Q&A tonight if anyone's interested.
There's not many tags that are currently implemented; the infrastructures there in case you want to use it in a plugin (or in case we use it in future functionality).
Benjie is doing a Postgraphile Q&A session over on Reactiflux right now, come join us https://www.reactiflux.com/
mutation {
updateUserByUserId(input: {userId: "de5f6a1e-58ad-4c54-ab51-55fbca17ba55", userPatch: {address: ""}}) {
user {
userId
name
address
}
}
}{
"errors": [
{
"message": "cannot extract elements from a scalar",
"locations": [
{
"line": 2,
"column": 3
}
],
"path": [
"updateUserByUserId"
]
}
],
"data": {
"updateUserByUserId": null
}
}
address it is a jsonb type
I have a question regarding the aggregation functions (COUNT, AVG, ...).
are they supported by postgraphile?
We have count via
totalCount; the others can be added via plugins but we don't have any official plugins for that yet. I'm planning on adding them at some point in a similar way to computed columns, but using aggregate functions instead. You can also write custom queries or computed columns that do this; for example I just wrote this one:create function XXX_public."items_checklistItemCompletedCount"(i XXX_public.items) returns int as $$
select coalesce(
(select count(*)::int from XXX_public.items where "rootPostId" = i.id AND type = 'CHECKLIST_ITEM' and completed is true),
0
) where i.type = 'POST';
$$ language sql stable;
This adds the field
checklistItemCompletedCount to the Item type which does a count. You could replace the count with any aggregate function you like.
what my function looks like:
CREATE TYPE geo.grouped_value AS (value bigint, label text);
CREATE OR REPLACE FUNCTION geo.planet_osm_polygon_branchesCount(i geo.planet_osm_polygon) RETURNS setof geo.grouped_value AS
KaTeX parse error: Expected 'EOF', got '&' at position 88: WHERE poi.way &̲& i.way GROUP :
SELECT COUNT(*) AS value, shop as label FROM geo.planet_osm_point poi WHERE poi.way && i.way GROUP BY shop ORDER BY COUNT(*) DESC;
oops