Implement cross-sheet joins - Githubissues

ackwell / manacutter

Potential implementation of XIVAPI v4.

1 stars 0 forks source link

Implement cross-sheet joins #8

Open ackwell opened 3 years ago

ackwell commented 3 years ago

Being a somewhat-relational database, numeric columns can be interpreted as a foreign key field, joining to rows in other sheets.

Some complications arise from the game's current usage of these fields:

If the target sheet supports subrows, the field will only reference the primary row id - effectively making it a many:many join. We'll need to return a list of all subrows within the primary row in this situation.
Some joins target different sheets depending on another column. We'll need some way to link to multiple sheets in this case. For GQL, this will probably involve unions or similar.

ackwell commented 3 years ago

In progress @ https://github.com/ackwell/manacutter/tree/references