Specify foreign key against compound key in other table

[ryanfox]

When inserting rows via the library, is it possible to specify a foreign key to a compound primary key?

For example, suppose I create a table:

db = Database('events.db')
db['events'].insert_all([
    {'venue': 'Times Square', 'date': '2022-12-31', 'title': 'Rockin New Year Eve'},
    {'venue': 'Wembley Stadium', 'date': '2022-06-05', 'title': 'FA Cup'},
    {'venue': 'Times Square', 'date': '2021-12-31', 'title': 'Rockin New Year Eve'},
], pk=('date', 'venue'))

And I want to add related data in another table:

act = {'name': 'Rick Astley', 'venue': 'Times Square', 'date': '2021-12-31' }
db['performers'].insert(act, pk=<???>)

Is it possible to specify a value for pk that will point to the compound primary key in events?

SQLite does support it:
https://www.sqlite.org/foreignkeys.html#fk_composite

[simonw]

This isn't supported yet - there's an older issue for that here:

• Support for compound (composite) foreign keys #117

[ryanfox]

Perfect. Apologies, I searched but didn’t see that one for some reason. Thank you.

…

On Fri, Sep 9, 2022 at 3:04 PM Simon Willison ***@***.***> wrote: This isn't supported yet - there's an older issue for that here: - #117 <#117> — Reply to this email directly, view it on GitHub <#487 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEECKBODHZCKWTN5OO6RI3V5OJ5RANCNFSM6AAAAAAQIV3YIU> . You are receiving this because you authored the thread.Message ID: ***@***.***>