dgraph troubles

_README.md

Three files:

• schema.gql contains the type definitions I inserted into dgraph.
• seed.rdf contains the set definition used to populate the database with associated information.
• query.gql contains the dql query I'm trying to execute based on the examples...

When I run the query I get no results back. I've tried this at all sorts of different parts of the simple tree. Can't get any information anywhere. Can see data stored in the system just can't access it. Docs to the system aren't great. They reference a lot of things that seem deprecated / unavailable and the server doesn't return super useful error messages. (e.g. "undefined directive index" and yet, they use it everywhere.)

Version information

docker - dgraph/dgraph:latest

Dgraph version   : v21.03.0
Dgraph codename  : rocket
Dgraph SHA-256   : b4e4c77011e2938e9da197395dbce91d0c6ebb83d383b190f5b70201836a773f
Commit SHA-1     : a77bbe8ae
Commit timestamp : 2021-04-07 21:36:38 +0530
Branch           : HEAD
Go version       : go1.16.2
jemalloc enabled : true

For Dgraph official documentation, visit https://dgraph.io/docs.
For discussions about Dgraph     , visit https://discuss.dgraph.io.
For fully-managed Dgraph Cloud   , visit https://dgraph.io/cloud.

Licensed variously under the Apache Public License 2.0 and Dgraph Community License.
Copyright 2015-2021 Dgraph Labs, Inc.

docker - dgraph/ratel:latest

Ratel Version: 20.7.0
Commit ID: 
Commit Info: 

query.gql

query {
    cloud(func: eq(cloud.name, "aws")) {
        name
    
        regions {
            name
    
            zones {
                name
            }
        }
    }
}

schema.gql

type Cloud @dgraph(type: "cloud") {
    id: ID!
    name: String! @id
    regions: [Region!]! @hasInverse(field: cloud)
}

type Region @dgraph(type: "region") {
    id: ID!
    name: String! @id
    cloud: Cloud!
    zones: [Zone!]! @hasInverse(field: region)
}

type Zone @dgraph(type: "zone") {
    id: ID!
    name: String! @id
    cloud: Cloud!
    region: Region!
}

seed.rdf

{
    set {
        _:aws <dgraph.type> "cloud" .
        _:aws <cloud.name> "aws" .

        _:us-west-1 <dgraph.type> "region" .
        _:us-west-1 <region.name> "us-west-1" .
        _:us-west-1 <region.cloud> _:aws .

        _:us-west-1a <dgraph.type> "zone" .
        _:us-west-1a <zone.name> "us-west-1a" .
        _:us-west-1a <zone.region> _:us-west-1 .

        _:us-west-1b <dgraph.type> "zone" .
        _:us-west-1b <zone.name> "us-west-1b" .
        _:us-west-1b <zone.region> _:us-west-1 .

        _:us-west-1c <dgraph.type> "zone" .
        _:us-west-1c <zone.name> "us-west-1c" .
        _:us-west-1c <zone.region> _:us-west-1 .
    }
}

@mjpitz For these GraphQL mutations, you'd run them via GraphQL in a tool like GraphiQL, GraphQL Playground, or directly from the Dgraph Cloud dashboard for your cloud backend. Ratel doesn't accept these GraphQL queries today.

You can update nested components. In your original schema you wanted to establish a direct connection from the Zone to Cloud nodes. You can always traverse the relationships to get the data you need (from Zone to Region to Cloud, in this case).

If you want to run your seed.rdf DQL mutation in Ratel, then you'd need to tweak your mutation a bit. Here's what you'd need to change in your mutation:

1. The cloud.regions field needs to be set
2. The region.zones needs to be set

diff --git a/seed.rdf b/seed.rdf
index 5e2f851..255021a 100644
--- a/seed.rdf
+++ b/seed.rdf
@@ -2,10 +2,14 @@
     set {
         _:aws <dgraph.type> "cloud" .
         _:aws <cloud.name> "aws" .
+        _:aws <cloud.regions> _:us-west-1 .
 
         _:us-west-1 <dgraph.type> "region" .
         _:us-west-1 <region.name> "us-west-1" .
         _:us-west-1 <region.cloud> _:aws .
+        _:us-west-1 <region.zones> _:us-west-1a .
+        _:us-west-1 <region.zones> _:us-west-1b .
+        _:us-west-1 <region.zones> _:us-west-1c .
 
         _:us-west-1a <dgraph.type> "zone" .
         _:us-west-1a <zone.name> "us-west-1a" .

And here's the full copy for convenience:

{
    set {
        _:aws <dgraph.type> "cloud" .
        _:aws <cloud.name> "aws" .
        _:aws <cloud.regions> _:us-west-1 .

        _:us-west-1 <dgraph.type> "region" .
        _:us-west-1 <region.name> "us-west-1" .
        _:us-west-1 <region.cloud> _:aws .
        _:us-west-1 <region.zones> _:us-west-1a .
        _:us-west-1 <region.zones> _:us-west-1b .
        _:us-west-1 <region.zones> _:us-west-1c .

        _:us-west-1a <dgraph.type> "zone" .
        _:us-west-1a <zone.name> "us-west-1a" .
        _:us-west-1a <zone.region> _:us-west-1 .

        _:us-west-1b <dgraph.type> "zone" .
        _:us-west-1b <zone.name> "us-west-1b" .
        _:us-west-1b <zone.region> _:us-west-1 .

        _:us-west-1c <dgraph.type> "zone" .
        _:us-west-1c <zone.name> "us-west-1c" .
        _:us-west-1c <zone.region> _:us-west-1 .
    }
}

Similarly, for your DQL query, need to use the correct names for your query to return the data. The naming convention here stems from your GraphQL schema and follows the rules documented in the GraphQL to DQL schema mapping: https://dgraph.io/docs/graphql/dgraph/

diff --git a/query.gql b/query.gql
index d715c48..bd258cb 100644
--- a/query.gql
+++ b/query.gql
@@ -1,12 +1,12 @@
 query {
     cloud(func: eq(cloud.name, "aws")) {
-        name
+        cloud.name
     
-        regions {
-            name
+        cloud.regions {
+            region.name
     
-            zones {
-                name
+            region.zones {
+                zone.name
             }
         }
     }

And the full query:

query {
    cloud(func: eq(cloud.name, "aws")) {
        cloud.name
    
        cloud.regions {
            region.name
    
            region.zones {
                zone.name
            }
        }
    }
}

Query response:

{
  "data": {
    "cloud": [
      {
        "cloud.name": "aws",
        "cloud.regions": [
          {
            "region.name": "us-west-1",
            "region.zones": [
              {
                "zone.name": "us-west-1b"
              },
              {
                "zone.name": "us-west-1c"
              },
              {
                "zone.name": "us-west-1a"
              }
            ]
          }
        ]
      }
    ]
  }
}

I forgot that GitHub gists are forkable, so, instead of pasting diffs, I've forked this gist with the changes discussed above: https://gist.github.com/danielmai/7db7b0c9e971eb748ce3d483278e820c. I hope this helps.

OK. I think I understand the layers a lot better and I have this running. Thanks a lot for your help!

@mjpitz Awesome! Glad to hear that you have this running now.