Database Table Discovery with Foreign Key Detection

Published On: Nov 4, 2014

My past couple of days have been filled with some very interesting code, and a problem that is something actually worthy of pulling out my computer science knowledge... The problem is one that is fairly simple:

"How do I insert data into tables dynamically so that I know all of the foreign key constraints are met."

Here are the assumptions that you know going into the problem:

  • You don't know what data you will be entering until you hit the block to add the data.
  • You don't know the schema of the database until you hit the block to add the data.

Comments