DBIx::Class insert nested hash

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I've been watching David Cross' "Database Programming with Perl and DBIx::Class" presentation
which has an example of an Artist who has many CD's and in slide 70 he inserts the associated cds with $bowie->add_to_cds{}
Isn't there a way to insert a nested Artist hash which would include another hash with the artist's cds in one go, populating both the Artist and its related CDs table?
I mean something like passing the nested Artist hash inside a create method which would then take care of inserting the data appropriately.

Comment on DBIx::Class insert nested hash Download Code

Replies are listed 'Best First'.
Re: DBIx::Class insert nested hash by bliako (Abbot) on Nov 16, 2021 at 09:03 UTC
Check this example from the official doc: https://metacpan.org/dist/DBIx-Class/view/lib/DBIx/Class/Manual/QuickStart.pod#Working-with-data . It is inserting a CD and a list of its tracks.	[reply]
Re^2: DBIx::Class insert nested hash by Anonymous Monk on Nov 16, 2021 at 12:48 UTC
thank you! Exactly what I was looking for!	[reply]