SQLA Demo: Beatles Database -- Inserting Records into a Bridge Table
In this video we add to our Beatles database example a WTForms page that has two multi-selects -- one lists the artists and allows the user to choose more than one and the other lists the songs and again allows the user to choose more than one. The Flask/Python upon receiving the response from the user performs a nested loop through both lists and for each pair of (artist id, song id) inserts a record into the bridge table.
play_arrow
More Database Introduction: Database Categories and Codd's Rules for Relational Databases
play_arrow
Finding More Patterns in the Perfect-Shuffle (Riffle) Integer Sequence with Wolfram-Cloud