Tuesday, August 17, 2010

Book List

I have a list of books that I want to import into a DB, so I can sort them, group them, and just generally use them as sample data. This doesn't seem like it should be that big of a deal.

Right?

Okay, well, perhaps the list is a little unscrubbed because I both pulled some entries from the Internets and hand entered some others into this list. Still, it shouldn't be that big of a deal, right?

Ha! You'd like to think so, wouldn't you?

So, the simple version of the project plan looks like this:
  1. Take multiple files, filled with some combination of
  • Author
  • Title
  • Other Spacing / Whitespace
  1. Import said files into a SQL 2008 DB
  2. Validate that authors are really authors, titles are really titles
  3. Run a single select to indicate the distinct list of books in the set
  4. BONUS: Add a column indicating ownership status
  5. BONUS: Add a column indicating "have read" status