Updated DataSet and DataTable generation to support foreign key relationships

logiclrd commented 3 years ago

This PR:

Adds unit tests that exercise more complicated scenarios where tables within a DataSet have relations configured that can only be satisfied by populating tables in a specific order and making sure that certain columns are given values that match existing records in other tables.
Updates DataSetGenerator.cs to ensure that the order in which tables are generated doesn't violate foreign key relationships.
Updates DataTableGenerator.cs to ensure that column data respects foreign key relationships, including situations where columns are marked Unique and tables that reference themselves.

NOTE: This branch is based on the JDG_DataTableRowCount branch, so the changes from PR #55 will appear here too, but should disappear after that PR is merged.

chriszoryk commented 3 years ago

@nickdodd79 I know you're probably super busy but any chance this could be merged in please?

It would fix quite a big issue with this library.

Thanks!

logiclrd commented 3 years ago

If you have a private artifacts server, then as a temporary work-around you can pull the mainline, merge in the PRs manually in your local copy, and then build and publish a prerelease version for your internal use. This is what we have been doing. I look forward to getting back to regular published versions, but it's tiding us over. :-)

chriszoryk commented 3 years ago

@logiclrd, That's what we ended up doing in the end.

Cheers for making the PR!

logiclrd commented 3 years ago

I have rebased this change onto master now that #55 is merged.

nickdodd79 / AutoBogus

Updated DataSet and DataTable generation to support foreign key relationships #58