Add ads:inspect Command or test

[joefusco]

It would be really nice to have a console command or a test that can tell us if there are any common issues in the ADS, for example:

• tier2 or tier3 tables lacking created_at or updated_at columns
• tier2 or tier3 tables with columns that contain "ID" but aren't wired up in a foreign key relationship

I'm sure there are other things we'd want to check, but this would be a good start.

[sbeal333]

Would these be best as console commands, or do you think they might be better as some sort of default suite of tests that get created via a console command?

[joefusco]

I'm thinking it might be best as a console command. Something similar to this:

https://github.com/beyondcode/laravel-self-diagnosis

[joefusco]

to capture table names and aliases: (from|join)\s[a-zA-Z0-9_-]*\s[a-zA-Z0-9_-]*(?=\s)

to capture join criteria: (on)\s[a-zA-Z0-9._-\s!=<>]*(?=inner|where|left|right|cross|full|join|union|;)

to capture where clause criteria: (where|and|or)\s[a-zA-Z0-9][.][a-zA-Z0-9]*\s