Source Code – https://github.com/ehelin/TGIMBA
Ever since starting The Globe In My Bucket Application (TGIMBA), I have been anxious to explore algorithms and other cool software widgets. Well, with this blog entry, I am starting the first of what I hope will be many algorithm releases. This will be one in a series of blog posts on a TGIMBA Traveling Salesman and Permutation algorithm implementation. I did a POC on these two earlier (https://erichelin.wordpress.com/2016/06/08/tgimba-automation-the-traveling-salesman-and-permutation-algorithm-proof-of-concept/).
This first phase is to update the website to be backwards compatible. With commit ‘dca070801c57e129e6c7b563a3491b9fcf9f4dd8’, I updated the existing SQL script(s) to only insert existing columns columns. I did this because I noticed that nothing worked when I did a quick trial and added Latitude and Longitude columns to the bucket list item table in production. When I tested, I got an error. The number of columns didn’t match what existed (i.e. the two new columns). The ‘fix’ for this was to use named columns.
The last step of this phase was to complete modifying the existing Jquery code to handle the two new fields. I will admit, my original implementation is not as good as I once thought it was. My code is hard to follow. Something I will remedy (at some point). This step is represented by commits ‘b74d205489d9724767403536cadca655da25d06d’ and ’32c89685e070409909da7fc9eb20ea25de21e0f3′.