Adjacency list

[Lelouch1]

Hello, tell me please does it support adjacency list in schema definition? It looks like in same table, we have parent id, which refers to an id in the same table.

i try'd like this, but something went wrong...

[
  {
    "database": "test-db",
    "index": "test-index",
    "nodes": {
      "table": "table_for_example",
      "schema": "public",
      "columns": [],
      "children" : [
        {
          "table": "table_for_example",
          "relationship": {
            "variant": "object",
            "type": "one_to_many",
            "foreign_key": {
              "child": ["id"],
              "parent": ["parent_id"]
            }
          }
        }
      ]
    }
  }
]

[Wild-Soul]

Hi @Lelouch1 , I think this comment might help you.

[toluaina]

This is not supported yet. It was also requested here. I am still working on this

[Lelouch1]

@toluaina Thank you, I'll be waiting

[Lelouch1]

@toluaina hi, saw the new release, do you solved the problem? thx:)

[toluaina]

• I'm afraid this was not solved in the new release.
• Its a bit delicate which is why it wasn't done to start with.
• I have started working on this as you can see from some of the files commited.

[skantrus]

Hi! Discover same error when try to add children from same table. Want to make flat architecture from inheritance with adjacency list schema

{
	"label": "children",
	"table": "same_table",
	"columns": [
		"id",
		"detail"
	],
	"relationship": {
		"type": "one_to_many",
		"variant": "object",
		"foreign_key": {
			"child": [
				"parent_id"
			],
			"parent": [
				"id"
			]
		}
	}
}

@toluaina May bee I can help you, if you look at this code fix example: But still it wont track update parent if new child was added