@id and @hasinverse on specific type

[chewxy]

Hi there @lzr , welcome to the Dgraph community!

I noticed something strange about your schema: you have TWO @hasInverses .

Based on what you want to do, the following schema is more than enough:

type Account {
    email: String! @id @search(by: [hash, regexp])
    sessions: [Session] @hasInverse(field: account)
}

type Session {
    id: ID!
    account: Account! # THIS WAS REMOVED.
    mail_to: String! @search(by: [hash, regexp])
    mail_from: String! @search(by: [hash, regexp])
    mail_text: String!
    mail_html: String!
    mail_subject: String! @search(by: [hash, regexp])
    mail_original: String!
}

Now on to your questions:

@lzr

In theory, if I insert an account, the email is the only id (when i’m querying dgraph, I always end up with uid that are generated … is that normal?

It’s normal.

@lzr

so in my case if I create several time an account with the SAME email I end up with several time the SAME email in dgraph … with the @id there sshould be only one no ?)

That’s funny. That shouldn’t happen. I will try to reproduce based on your queries/code

@lzr

If I create a session with an account linked to it, when I query that account, I’m suppose to get an array of session ?
in my case when I request account, I don’t get the array of sessions :

I noticed you used expand(_all_). That function only expands terminal nodes. To get the sessions, you need to do this:

{
  node(func: type(Account)) @recurse(depth:3){
    uid
    expand(_all_)
    Account.sessions {}
  }
}