astrodbtoolkit / astrodbtoolkit/AstrodbKit

Consider adding way to control table insert order

Open
#93 1 comment 0 reactions 1 assignee Claimed by @dr-rodriguez View on GitHub
bug enhancement
Dominant language
Python
Stars
12
Forks
5
PR merge metrics
No merged PRs in 30d

Description

Currently, the JSON file for a source is written with the primary table first and then the rest of the tables as fetched from `self.metadata.tables`. This appears to be sorted alphabetically.

In circumstances where object tables refer to each other, such as a CompanionRelationship table that contains entries that a CompanionParameters table points to, this causes an error as the "R" is after "P" in the table. That is, a foreign key error will occur because the CompanionRelationship table is not loaded before CompanionParameters.

This DB generally assumes that object tables will point back to either the primary table or lookup tables, not to each other. If we want to support this we may need to provide a list of the order to use.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.