My fix in deb0be4 for #1098 was to have Datasette deliberately pretend that compound foreign keys don't exist:

Lines 470 to 495 in deb0be4

    
           def get_outbound_foreign_keys(conn, table): 
        
               infos = conn.execute(f"PRAGMA foreign_key_list([{table}])").fetchall() 
        
               fks = [] 
        
               for info in infos: 
        
                   if info is not None: 
        
                       id, seq, table_name, from_, to_, on_update, on_delete, match = info 
        
                       fks.append( 
        
                           { 
        
                               "column": from_, 
        
                               "other_table": table_name, 
        
                               "other_column": to_, 
        
                               "id": id, 
        
                               "seq": seq, 
        
                           } 
        
                       ) 
        
               # Filter out compound foreign keys by removing any where "id" is not unique 
        
               id_counts = Counter(fk["id"] for fk in fks) 
        
               return [ 
        
                   { 
        
                       "column": fk["column"], 
        
                       "other_table": fk["other_table"], 
        
                       "other_column": fk["other_column"], 
        
                   } 
        
                   for fk in fks 
        
                   if id_counts[fk["id"]] == 1 
        
               ]

This workaround will need to be rethought to implement real support for them.

	def get_outbound_foreign_keys(conn, table):
	infos = conn.execute(f"PRAGMA foreign_key_list([{table}])").fetchall()
	fks = []
	for info in infos:
	if info is not None:
	id, seq, table_name, from_, to_, on_update, on_delete, match = info
	fks.append(
	{
	"column": from_,
	"other_table": table_name,
	"other_column": to_,
	"id": id,
	"seq": seq,
	}
	)
	# Filter out compound foreign keys by removing any where "id" is not unique
	id_counts = Counter(fk["id"] for fk in fks)
	return [
	{
	"column": fk["column"],
	"other_table": fk["other_table"],
	"other_column": fk["other_column"],
	}
	for fk in fks
	if id_counts[fk["id"]] == 1
	]

Uh oh!

Support linking to compound foreign keys #1099

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions