[Issue] SDL Generators Not Mapping relationship

[BurnedChris]

Good Afternoon,

After a debugging session with @RobertBroersma (thank you!)
We have found out that when using the command rw g XXX --crud

if you have relationships it is possible for them not to be mapped properly resulting in the field returning as null.

example sdl

export const schema = gql`
  type User {
    id: Int!
    email: String!
    publicAddress: String!
    issuer: String!
    firstName: String
    secondName: String
    avatarPublicId: String
    onboarding: UserOnboarding
    onboardingId: Int
    createdAt: DateTime!
    updatedAt: DateTime!
  }

  type UserOnboarding {
    id: Int!
    hasAvatar: Boolean!
    hasName: Boolean!
    hasTeam: Boolean!
    user: User
  }

  type Query {
    users: [User!]!
    user(id: Int!): User!
  }

  input CreateUserInput {
    email: String!
    publicAddress: String!
    issuer: String!
    firstName: String
    secondName: String
    avatarPublicId: String
    onboardingId: Int
    updatedAt: DateTime!
  }

  input UpdateUserInput {
    email: String
    publicAddress: String
    issuer: String
    firstName: String
    secondName: String
    avatarPublicId: String
    onboardingId: Int
    updatedAt: DateTime
  }

  type Mutation {
    createUser(input: CreateUserInput!): User!
    updateUser(id: Int!, input: UpdateUserInput!): User!
    deleteUser(id: Int!): User!
  }
`

Function that returns null

import { db } from 'src/lib/db'

export const users = () => {
  return db.user.findMany()
}

export const user = ({ id }) => {
  return db.user.findOne({
    where: { id },
  })
}

// export const createUser = ({ input }) => {}
// export const updateUser = ({ id, input }) => {}
// export const deleteUser = ({ id }) => {}

export const User = {
  userOnboarding: (_obj, { root }) => db.user.findOne({ where: { id: root.id } }).userOnboarding(),
}

Function Fixed that returns data from relationship

import { db } from 'src/lib/db'

export const users = () => {
  return db.user.findMany()
}

export const user = ({ id }) => {
  return db.user.findOne({
    where: { id },
  })
}

// export const createUser = ({ input }) => {}
// export const updateUser = ({ id, input }) => {}
// export const deleteUser = ({ id }) => {}

export const User = {
  onboarding: (_obj, { root }) =>
    db.user.findOne({ where: { id: root.id } }).onboarding(),
}

Notice that Inside the User table the crud commands generate userOnboarding but it needs to be replaced with onboarding to work

[cannikin]

Hmmm...looks like the generator might be using the name of the foreign table itself UserOnboarding rather than the of the name of the relationship onboarding. That's not correct! Marking as a bug.

[cannikin]

I'm guessing it's happening in here: https://github.com/redwoodjs/redwood/blob/master/packages/cli/src/commands/generate/helpers.js#L109-L116

[jtoar]

Fixed in #813 I believe!