Checking for Extra Resources
Sometimes I'll create a query, and then deprecate it, but forget to remove it. Its not in the sitemap, so how do I know its not being used? Instead of making sure that every query file is getting used, I use these command line scripts:
grep 'query' ./sitemap.xml | awk '{ print $2}'| sed s/src=\"//g | sed s/\"//g | grep data | sort | uniq > data_files
find data/sql/ | grep -v .svn | grep -v default_table | sort > data_files2
diff data_files data_files2
rm data_files data_files2
Blog Posts
- [http://www.nexista.org/blog/2008/11/30/checking-for-extra-resources/ Checking for Extra Resources]