Self-referencing schema failing to create first db item

[EightArmCode]

Question

Hello! Thank you for the library. 🙏 I'm learning on my feet, so please forgive any newb mistakes.

The data I'm working with is very simple. The structure is a tree. There is a "root" element which has no parent, and the rest of the items reference another element as parent. For example, root element A has no parent. The next element is B and it refers to A as it's parent. I have attempted to model this in the schema (see below) by creating a self-referencing relation, and marking this field, parentName, as optional. It should be permitted to omit this property when a node does not have a parent, and thus it is only included when it exists.

I cannot proceed past creating the first item in the db. I have tried to create it in Prisma Studio, and there is some sort of bug rendering errors, that makes it quite difficult to debug. I have also turned on the debugger (output below). From what I can ascertain, it seems that prisma is failing because it is trying to reference another data point that does not yet exist. As I explained earlier, I have made that parentName field optional, since the root item has no parent. I still seem to be missing something, however.

This is the failing code:

const newLeaf = await prisma.leaf.create({
        data: {
          name: data.name,
          description: data.description,
          ...(data.parentName && {
            parent: {
              connect: {
                name: data.parentName,
              },
            },
          }),
        } as LeafInput,
      })

Here are the debug logs trying to save a new record in Prisma Studio:

prisma:client:request_handler {
  "name": "PrismaClientKnownRequestError",
  "code": "P2009",
  "clientVersion": "5.13.0",
  "meta": {
    "kind": "Union",
    "errors": [
      {
        "kind": "SomeFieldsMissing",
        "inputType": {
          "kind": "object",
          "name": "LeafWhereUniqueInput",
          "fields": [
            {
              "name": "parentName",
              "typeNames": [
                "String"
              ],
              "required": false
            },
            {
              "name": "name",
              "typeNames": [
                "String"
              ],
              "required": false
            },
            {
              "name": "AND",
              "typeNames": [
                "LeafWhereInput",
                "LeafWhereInput[]"
              ],
              "required": false
            },
            {
              "name": "OR",
              "typeNames": [
                "LeafWhereInput[]"
              ],
              "required": false
            },
            {
              "name": "NOT",
              "typeNames": [
                "LeafWhereInput",
                "LeafWhereInput[]"
              ],
              "required": false
            },
            {
              "name": "description",
              "typeNames": [
                "StringFilter",
                "String"
              ],
              "required": false
            },
            {
              "name": "parent",
              "typeNames": [
                "LeafNullableRelationFilter",
                "LeafWhereInput",
                "Null"
              ],
              "required": false
            },
            {
              "name": "children",
              "typeNames": [
                "LeafListRelationFilter"
              ],
              "required": false
            }
          ]
        },
        "argumentPath": [
          "data",
          "parent",
          "connect"
        ],
        "selectionPath": [
          "createOneLeaf"
        ],
        "constraints": {
          "minFieldCount": 1,
          "maxFieldCount": null,
          "requiredFields": [
            "name",
            "parentName",
            "name"
          ]
        }
      },
      {
        "kind": "RequiredArgumentMissing",
        "inputTypes": [
          {
            "kind": "scalar",
            "name": "String"
          }
        ],
        "argumentPath": [
          "data",
          "name"
        ],
        "selectionPath": [
          "createOneLeaf"
        ]
      }
    ]
  }
} +2ms
prisma:client:libraryEngine library stopping +24ms
prisma:client:libraryEngine library stopped +1ms
  prisma:studio-server Outgoing response:  {
  requestId: 5,
  channel: '-prisma',
  action: 'clientRequest',
  payload: {
    error: {
      type: undefined,
      code: undefined,
      message: '\n' +
        'Invalid `f=e.match(n5t)?.[1]??"",g=e.match(i5t)?.[1]??null,v=e.match(a5t)?.[1]??null,{getPrismaClient:E,PrismaClientKnownRequestError:b,PrismaClientRustPanicError:S,PrismaClientInitializationError:D,PrismaClientValidationError:C}=require(`${u.prismaClient}/runtime/${c}`),O=e,I=(0,h$.createHash)("sha256").update()` invocation in\n' +
        '/Users/kat/projects/2024-tree/node_modules/prisma/build/index.js:1922:10254\n' +
        '\n' +
        '  1919       }\n' +
        '  1920     }\n' +
        '  1921   }\n' +
        '→ 1922 `}});return Le.resourceList(a.workspaces)}};var Tbe=require("@prisma/engines");var n8e=require("buffer");function i8e(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var a8e={};i8e(a8e,"serializeRPCMessage",()=>RN);i8e(a8e,"deserializeRPCMessage",()=>kN);var ON="PrismaBigInt::",IN="PrismaBytes::";function RN(e){return JSON.stringify(e,(r,n)=>typeof n=="bigint"?ON+n:n?.type==="Buffer"&&Array.isArray(n?.data)?IN+n8e.Buffer.from(n.data).toString("base64"):n)}function kN(e){return JSON.parse(e,(r,n)=>typeof n=="string"&&n.startsWith(ON)?BigInt(n.substr(ON.length)):typeof n=="string"&&n.startsWith(IN)?n.substr(IN.length):n)}var vbe=M(d8e()),Eb=M(nbe()),ybe=M(require("http")),bbe=M(sbe()),wbe=require("zlib");var oo=require("path");var h$=require("crypto"),dbe=M(p$());function f$(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var fbe=globalThis,l$={},xb={},jl=fbe.parcelRequire1308;jl==null&&(jl=function(e){if(e in l$)return l$[e].exports;if(e in xb){var r=xb[e];delete xb[e];var n={id:e,exports:{}};return l$[e]=n,r.call(n.exports,n,n.exports),n.exports}var i=new Error("Cannot find module \'"+e+"\'");throw i.code="MODULE_NOT_FOUND",i},jl.register=function(r,n){xb[r]=n},fbe.parcelRequire1308=jl);var mbe=jl.register;mbe("9lTzd",function(module,exports){f$(module.exports,"guessEnginePaths",()=>guessEnginePaths),f$(module.exports,"guessPrismaClientPath",()=>guessPrismaClientPath);var $5COlq=jl("5COlq");async function guessEnginePaths({forceBinary,forceLibrary,resolveOverrides}){let queryEngineName,queryEngineType;if(forceLibrary?(queryEngineName=await(0,$5COlq.prismaEngineName)("query-engine","library"),queryEngineType="library"):forceBinary?(queryEngineName=await(0,$5COlq.prismaEngineName)("query-engine","binary"),queryEngineType="binary"):(queryEngineName=void 0,queryEngineType=void 0),!queryEngineName||!queryEngineType)return{queryEngine:void 0};let queryEnginePath;if(resolveOverrides[".prisma/client"])queryEnginePath=(0,oo.resolve)(resolveOverrides[".prisma/client"],`../${queryEngineName}`);else if(resolveOverrides["@prisma/engines"])queryEnginePath=(0,oo.resolve)(resolveOverrides["@prisma/engines"],`../../${queryEngineName}`);else{let atPrismaEnginesPath;try{atPrismaEnginesPath=eval("require.resolve(\'@prisma/engines\')")}catch(e){throw new Error("Unable to resolve Prisma engine paths. This is a bug.")}queryEnginePath=(0,oo.resolve)(atPrismaEnginesPath`../../${queryEngineName}`)}return{queryEngine:{type:queryEngineType,path:queryEnginePath}}}function guessPrismaClientPath({resolveOverrides}){let prismaClientPath=resolveOverrides["@prisma/client"]||eval("require.resolve(\'@prisma/client\')");return(0,oo.resolve)(prismaClientPath,"../")}});mbe("5COlq",function(e,r){f$(e.exports,"prismaEngineName",()=>n);async function n(i,a){let o=await Ir(),c=o==="windows"?".exe":"";if(a==="library")return ps(o,"fs");if(a==="binary")return`${i}-${o}${c}`;throw new Error(`Unknown engine type: ${a}`)}});function r5t(e){return{models:d$(e.models),enums:d$(e.enums),types:d$(e.types)}}function d$(e){let r={};for(let{name:n,...i}of e)r[n]=i;return r}var zg=(0,dbe.debug)("prisma:studio-pcw"),n5t=/^\\s*datasource\\s+([^\\s]+)\\s*{/m,i5t=/url *= *env\\("(.*)"\\)/,a5t=/url *= *"(.*)"/;async function s5t({schema:e,schemaPath:r,dmmf:n,datasourceProvider:i,previewFeatures:a,datasources:o,engineType:c,paths:u,directUrl:p,versions:l}){let f=e.match(n5t)?.[1]??"",g=e.match(i5t)?.[1]??null,v=e.match(a5t)?.[1]??null,{getPrismaClient:E,PrismaClientKnownRequestError:b,PrismaClientRustPanicError:S,PrismaClientInitializationError:D,PrismaClientValidationError:C}=require(`${u.prismaClient}/runtime/${c}`),O=e,I=(0,h$.createHash)("sha256").update({\n' +
        '         data: {\n' +
        '           parentName: null,\n' +
        '           description: "This is a description of A",\n' +
        '           parent: {\n' +
        '             connect: {\n' +
        '       ?       parentName?: String,\n' +
        '       ?       name?: String,\n' +
        '       ?       AND?: LeafWhereInput | LeafWhereInput[],\n' +
        '       ?       OR?: LeafWhereInput[],\n' +
        '       ?       NOT?: LeafWhereInput | LeafWhereInput[],\n' +
        '       ?       description?: StringFilter | String,\n' +
        '       ?       parent?: LeafNullableRelationFilter | LeafWhereInput | Null,\n' +
        '       ?       children?: LeafListRelationFilter\n' +
        '             }\n' +
        '           },\n' +
        '           children: {}\n' +
        '         },\n' +
        '         select: {\n' +
        '           name: true,\n' +
        '           parentName: true,\n' +
        '           description: true,\n' +
        '           parent: true,\n' +
        '           children: true\n' +
        '         }\n' +
        '       })\n' +
        '\n' +
        'Argument `connect` of type LeafWhereUniqueInput needs at least one of `name`, `parentName` or `name` arguments. Available options are marked with ?.',
      stack: '\n' +
        'Invalid `f=e.match(n5t)?.[1]??"",g=e.match(i5t)?.[1]??null,v=e.match(a5t)?.[1]??null,{getPrismaClient:E,PrismaClientKnownRequestError:b,PrismaClientRustPanicError:S,PrismaClientInitializationError:D,PrismaClientValidationError:C}=require(`${u.prismaClient}/runtime/${c}`),O=e,I=(0,h$.createHash)("sha256").update()` invocation in\n' +
        '/Users/kat/projects/2024-tree/node_modules/prisma/build/index.js:1922:10254\n' +
        '\n' +
        '  1919       }\n' +
        '  1920     }\n' +
        '  1921   }\n' +
        '→ 1922 `}});return Le.resourceList(a.workspaces)}};var Tbe=require("@prisma/engines");var n8e=require("buffer");function i8e(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var a8e={};i8e(a8e,"serializeRPCMessage",()=>RN);i8e(a8e,"deserializeRPCMessage",()=>kN);var ON="PrismaBigInt::",IN="PrismaBytes::";function RN(e){return JSON.stringify(e,(r,n)=>typeof n=="bigint"?ON+n:n?.type==="Buffer"&&Array.isArray(n?.data)?IN+n8e.Buffer.from(n.data).toString("base64"):n)}function kN(e){return JSON.parse(e,(r,n)=>typeof n=="string"&&n.startsWith(ON)?BigInt(n.substr(ON.length)):typeof n=="string"&&n.startsWith(IN)?n.substr(IN.length):n)}var vbe=M(d8e()),Eb=M(nbe()),ybe=M(require("http")),bbe=M(sbe()),wbe=require("zlib");var oo=require("path");var h$=require("crypto"),dbe=M(p$());function f$(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var fbe=globalThis,l$={},xb={},jl=fbe.parcelRequire1308;jl==null&&(jl=function(e){if(e in l$)return l$[e].exports;if(e in xb){var r=xb[e];delete xb[e];var n={id:e,exports:{}};return l$[e]=n,r.call(n.exports,n,n.exports),n.exports}var i=new Error("Cannot find module \'"+e+"\'");throw i.code="MODULE_NOT_FOUND",i},jl.register=function(r,n){xb[r]=n},fbe.parcelRequire1308=jl);var mbe=jl.register;mbe("9lTzd",function(module,exports){f$(module.exports,"guessEnginePaths",()=>guessEnginePaths),f$(module.exports,"guessPrismaClientPath",()=>guessPrismaClientPath);var $5COlq=jl("5COlq");async function guessEnginePaths({forceBinary,forceLibrary,resolveOverrides}){let queryEngineName,queryEngineType;if(forceLibrary?(queryEngineName=await(0,$5COlq.prismaEngineName)("query-engine","library"),queryEngineType="library"):forceBinary?(queryEngineName=await(0,$5COlq.prismaEngineName)("query-engine","binary"),queryEngineType="binary"):(queryEngineName=void 0,queryEngineType=void 0),!queryEngineName||!queryEngineType)return{queryEngine:void 0};let queryEnginePath;if(resolveOverrides[".prisma/client"])queryEnginePath=(0,oo.resolve)(resolveOverrides[".prisma/client"],`../${queryEngineName}`);else if(resolveOverrides["@prisma/engines"])queryEnginePath=(0,oo.resolve)(resolveOverrides["@prisma/engines"],`../../${queryEngineName}`);else{let atPrismaEnginesPath;try{atPrismaEnginesPath=eval("require.resolve(\'@prisma/engines\')")}catch(e){throw new Error("Unable to resolve Prisma engine paths. This is a bug.")}queryEnginePath=(0,oo.resolve)(atPrismaEnginesPath`../../${queryEngineName}`)}return{queryEngine:{type:queryEngineType,path:queryEnginePath}}}function guessPrismaClientPath({resolveOverrides}){let prismaClientPath=resolveOverrides["@prisma/client"]||eval("require.resolve(\'@prisma/client\')");return(0,oo.resolve)(prismaClientPath,"../")}});mbe("5COlq",function(e,r){f$(e.exports,"prismaEngineName",()=>n);async function n(i,a){let o=await Ir(),c=o==="windows"?".exe":"";if(a==="library")return ps(o,"fs");if(a==="binary")return`${i}-${o}${c}`;throw new Error(`Unknown engine type: ${a}`)}});function r5t(e){return{models:d$(e.models),enums:d$(e.enums),types:d$(e.types)}}function d$(e){let r={};for(let{name:n,...i}of e)r[n]=i;return r}var zg=(0,dbe.debug)("prisma:studio-pcw"),n5t=/^\\s*datasource\\s+([^\\s]+)\\s*{/m,i5t=/url *= *env\\("(.*)"\\)/,a5t=/url *= *"(.*)"/;async function s5t({schema:e,schemaPath:r,dmmf:n,datasourceProvider:i,previewFeatures:a,datasources:o,engineType:c,paths:u,directUrl:p,versions:l}){let f=e.match(n5t)?.[1]??"",g=e.match(i5t)?.[1]??null,v=e.match(a5t)?.[1]??null,{getPrismaClient:E,PrismaClientKnownRequestError:b,PrismaClientRustPanicError:S,PrismaClientInitializationError:D,PrismaClientValidationError:C}=require(`${u.prismaClient}/runtime/${c}`),O=e,I=(0,h$.createHash)("sha256").update({\n' +
        '         data: {\n' +
        '           parentName: null,\n' +
        '           description: "This is a description of A",\n' +
        '           parent: {\n' +
        '             connect: {\n' +
        '       ?       parentName?: String,\n' +
        '       ?       name?: String,\n' +
        '       ?       AND?: LeafWhereInput | LeafWhereInput[],\n' +
        '       ?       OR?: LeafWhereInput[],\n' +
        '       ?       NOT?: LeafWhereInput | LeafWhereInput[],\n' +
        '       ?       description?: StringFilter | String,\n' +
        '       ?       parent?: LeafNullableRelationFilter | LeafWhereInput | Null,\n' +
        '       ?       children?: LeafListRelationFilter\n' +
        '             }\n' +
        '           },\n' +
        '           children: {}\n' +
        '         },\n' +
        '         select: {\n' +
        '           name: true,\n' +
        '           parentName: true,\n' +
        '           description: true,\n' +
        '           parent: true,\n' +
        '           children: true\n' +
        '         }\n' +
        '       })\n' +
        '\n' +
        'Argument `connect` of type LeafWhereUniqueInput needs at least one of `name`, `parentName` or `name` arguments. Available options are marked with ?.'
    },
    data: null
  }
} +408ms
  prisma:studio-server Incoming request:  {"requestId":6,"channel":"telemetry","action":"send","payload":{"data":{"command":"error_throw","commandDetails":"{\"type\":\"client\",\"description\":\"Failed to commit changes: \\nInvalid `f=e.match(n5t)?.[1]??\\\"\\\",g=e.match(i5t)?.[1]??null,v=e.match(a5t)?.[1]??null,{getPrismaClient:E,PrismaClientKnownRequestError:b,PrismaClientRustPanicError:S,PrismaClientInitializationError:D,PrismaClientValidationError:C}=require(`${u.prismaClient}/runtime/${c}`),O=e,I=(0,h$.createHash)(\\\"sha256\\\").update()` invocation in\\n/Users/kat/projects/2024-tree/node_modules/prisma/build/index.js:1922:10254\\n\\n  1919       }\\n  1920     }\\n  1921   }\\n→ 1922 `}});return Le.resourceList(a.workspaces)}};var Tbe=require(\\\"@prisma/engines\\\");var n8e=require(\\\"buffer\\\");function i8e(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var a8e={};i8e(a8e,\\\"serializeRPCMessage\\\",()=>RN);i8e(a8e,\\\"deserializeRPCMessage\\\",()=>kN);var ON=\\\"PrismaBigInt::\\\",IN=\\\"PrismaBytes::\\\";function RN(e){return JSON.stringify(e,(r,n)=>typeof n==\\\"bigint\\\"?ON+n:n?.type===\\\"Buffer\\\"&&Array.isArray(n?.data)?IN+n8e.Buffer.from(n.data).toString(\\\"base64\\\"):n)}function kN(e){return JSON.parse(e,(r,n)=>typeof n==\\\"string\\\"&&n.startsWith(ON)?BigInt(n.substr(ON.length)):typeof n==\\\"string\\\"&&n.startsWith(IN)?n.substr(IN.length):n)}var vbe=M(d8e()),Eb=M(nbe()),ybe=M(require(\\\"http\\\")),bbe=M(sbe()),wbe=require(\\\"zlib\\\");var oo=require(\\\"path\\\");var h$=require(\\\"crypto\\\"),dbe=M(p$());function f$(e,r,n,i){Object.defineProperty(e,r,{get:n,set:i,enumerable:!0,configurable:!0})}var fbe=globalThis,l$={},xb={},jl=fbe.parcelRequire1308;jl==null&&(jl=function(e){if(e in l$)return l$[e].exports;if(e in xb){var r=xb[e];delete xb[e];var n={id:e,exports:{}};return l$[e]=n,r.call(n.exports,n,n.exports),n.exports}var i=new Error(\\\"Cannot find module '\\\"+e+\\\"'\\\");throw i.code=\\\"MODULE_NOT_FOUND\\\",i},jl.register=function(r,n){xb[r]=n},fbe.parcelRequire1308=jl);var mbe=jl.register;mbe(\\\"9lTzd\\\",function(module,exports){f$(module.exports,\\\"guessEnginePaths\\\",()=>guessEnginePaths),f$(module.exports,\\\"guessPrismaClientPath\\\",()=>guessPrismaClientPath);var $5COlq=jl(\\\"5COlq\\\");async function guessEnginePaths({forceBinary,forceLibrary,resolveOverrides}){let queryEngineName,queryEngineType;if(forceLibrary?(queryEngineName=await(0,$5COlq.prismaEngineName)(\\\"query-engine\\\",\\\"library\\\"),queryEngineType=\\\"library\\\"):forceBinary?(queryEngineName=await(0,$5COlq.prismaEngineName)(\\\"query-engine\\\",\\\"binary\\\"),queryEngineType=\\\"binary\\\"):(queryEngineName=void 0,queryEngineType=void 0),!queryEngineName||!queryEngineType)return{queryEngine:void 0};let queryEnginePath;if(resolveOverrides[\\\".prisma/client\\\"])queryEnginePath=(0,oo.resolve)(resolveOverrides[\\\".prisma/client\\\"],`../${queryEngineName}`);else if(resolveOverrides[\\\"@prisma/engines\\\"])queryEnginePath=(0,oo.resolve)(resolveOverrides[\\\"@prisma/engines\\\"],`../../${queryEngineName}`);else{let atPrismaEnginesPath;try{atPrismaEnginesPath=eval(\\\"require.resolve('@prisma/engines')\\\")}catch(e){throw new Error(\\\"Unable to resolve Prisma engine paths. This is a bug.\\\")}queryEnginePath=(0,oo.resolve)(atPrismaEnginesPath`../../${queryEngineName}`)}return{queryEngine:{type:queryEngineType,path:queryEnginePath}}}function guessPrismaClientPath({resolveOverrides}){let prismaClientPath=resolveOverrides[\\\"@prisma/client\\\"]||eval(\\\"require.resolve('@prisma/client')\\\");return(0,oo.resolve)(prismaClientPath,\\\"../\\\")}});mbe(\\\"5COlq\\\",function(e,r){f$(e.exports,\\\"prismaEngineName\\\",()=>n);async function n(i,a){let o=await Ir(),c=o===\\\"windows\\\"?\\\".exe\\\":\\\"\\\";if(a===\\\"library\\\")return ps(o,\\\"fs\\\");if(a===\\\"binary\\\")return`${i}-${o}${c}`;throw new Error(`Unknown engine type: ${a}`)}});function r5t(e){return{models:d$(e.models),enums:d$(e.enums),types:d$(e.types)}}function d$(e){let r={};for(let{name:n,...i}of e)r[n]=i;return r}var zg=(0,dbe.debug)(\\\"prisma:studio-pcw\\\"),n5t=/^\\\\s*datasource\\\\s+([^\\\\s]+)\\\\s*{/m,i5t=/url *= *env\\\\(\\\"(.*)\\\"\\\\)/,a5t=/url *= *\\\"(.*)\\\"/;async function s5t({schema:e,schemaPath:r,dmmf:n,datasourceProvider:i,previewFeatures:a,datasources:o,engineType:c,paths:u,directUrl:p,versions:l}){let f=e.match(n5t)?.[1]??\\\"\\\",g=e.match(i5t)?.[1]??null,v=e.match(a5t)?.[1]??null,{getPrismaClient:E,PrismaClientKnownRequestError:b,PrismaClientRustPanicError:S,PrismaClientInitializationError:D,PrismaClientValidationError:C}=require(`${u.prismaClient}/runtime/${c}`),O=e,I=(0,h$.createHash)(\\\"sha256\\\").update({\\n         data: {\\n           parentName: null,\\n           description: \\\"This is a description of A\\\",\\n           parent: {\\n             connect: {\\n       ?       parentName?: String,\\n       ?       name?: String,\\n       ?       AND?: LeafWhereInput | LeafWhereInput[],\\n       ?       OR?: LeafWhereInput[],\\n       ?       NOT?: LeafWhereInput | LeafWhereInput[],\\n       ?       description?: StringFilter | String,\\n       ?       parent?: LeafNullableRelationFilter | LeafWhereInput | Null,\\n       ?       children?: LeafListRelationFilter\\n             }\\n           },\\n           children: {}\\n         },\\n         select: {\\n           name: true,\\n           parentName: true,\\n           description: true,\\n           parent: true,\\n           children: true\\n         }\\n       })\\n\\nArgument `connect` of type LeafWhereUniqueInput needs at least one of `name`, `parentName` or `name` arguments. Available options are marked with ?.\"}","commandContext":"{\"model_count\":1}"}}} +6ms
  prisma:studio-server Outgoing response:  {
  requestId: 6,
  channel: '-telemetry',
  action: 'send',
  payload: { error: null, data: null }
} +2ms
  prisma:studio-server Incoming request:  {"requestId":7,"channel":"telemetry","action":"send","payload":{"data":{"command":"action_commit","commandDetails":"{\"pending_action_count\":2}","commandContext":"{\"model_count\":1}"}}} +1ms
  prisma:studio-server Outgoing response:  {
  requestId: 7,
  channel: '-telemetry',
  action: 'send',
  payload: { error: null, data: null }
} +1ms

How to reproduce (optional)

Expected behavior (optional)

Please help me figure out what I may have missed or do not understand about the self-referencing 1-M relation so that I can add that first data element, which does not refer to another element as it's parent.

Information about Prisma Schema, Client Queries and Environment (optional)

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "cockroachdb"
  url      = env("DATABASE_URL")
}


model Leaf {
  parentName  String? @unique
  name      String @id @unique
  description String
  parent    Leaf? @relation("LeafToLeaf", fields: [name], references: [parentName], onUpdate: Cascade, onDelete: Restrict)
  children  Leaf[] @relation("LeafToLeaf")
}

<!-- Paste your Prisma Client queries below. -->
```ts
// Add any relevant Prisma Client queries here
const newLeaf = await prisma.leaf.create({
        data: {
          name: data.name,
          description: data.description,
          ...(data.parentName && {
            parent: {
              connect: {
                name: data.parentName,
              },
            },
          }),
        } as LeafInput,
      })

• OS: MacOS Sonoma 14.4
• Database: CockroachDB
• Node.js version:
  v20.10.0
• Run prisma -v to see your Prisma version and paste it

yarn prisma -v
Environment variables loaded from .env
prisma                  : 5.13.0
@prisma/client          : 5.13.0
Computed binaryTarget   : darwin-arm64
Operating System        : darwin
Architecture            : arm64
Node.js                 : v20.10.0
Query Engine (Node-API) : libquery-engine b9a39a7ee606c28e3455d0fd60e78c3ba82b1a2b (at node_modules/@prisma/engines/libquery_engine-darwin-arm64.dylib.node)
Schema Engine           : schema-engine-cli b9a39a7ee606c28e3455d0fd60e78c3ba82b1a2b (at node_modules/@prisma/engines/schema-engine-darwin-arm64)
Schema Wasm             : @prisma/prisma-schema-wasm 5.13.0-23.b9a39a7ee606c28e3455d0fd60e78c3ba82b1a2b
Default Engines Hash    : b9a39a7ee606c28e3455d0fd60e78c3ba82b1a2b

[EightArmCode]

I think I found the issue. I removed the @unique directive from parentName. Since a parent can have multiple children, this was invalid. The final schema, should anyone care to see it:

model Leaf {
  name      String @id @unique
  parentName  String?
  description String
  parent    Leaf? @relation("LeafToLeaf", fields: [parentName], references: [name], onUpdate: Cascade, onDelete: Restrict)
  children  Leaf[] @relation("LeafToLeaf")
}