test functions on common database

[eneemann]

When ready, we need to test the different aspects of each function against a common SDE database to ensure everything is working correctly.

Greg's test database is probably a good place to do this

[steveoh]

I would suggest doing this on a local fgdb that can be included in the project as long as the errors can be reproduced in that environment. Otherwise I would suggest some other portable db type. Maybe sqlite. Last resort would be to run a local sql server db and have scripts to hydrate it in a consistent manner.

[steveoh]

I would love to see some tests as it can be tricky to create the broken data.

[stdavis]

I have some experience setting up data tests with pytest in forklift. If someone wants to post some test data, I'd be happy to take a crack at it.

[ZachBeck]

I can help as well, every now and then I come across funky addresses that are valid.