ATIC Form

On Thursday I was working on bug fixes that mainly just involved stupid errors especially one where there was a misplaced comma in the rebase statements so that it thought that there was a template called 'layout.tpl,' and it took a long time to notice that one little comma.

On Friday I worked on styling and adding finishing touches to the form. I styled it and made the formatting much better. It still doesn't look very pretty but it's a lot more user friendly. If you want to take a look at it just go to the projects tab. Here is a link to my branch so you can see for yourself.

ATIC Form Progress

I'm still working on the ATIC form and I keep getting different errors but I've been able to slowly fix them up to this point and you helped me with the database problem. I've gotten some errors like where I had the wrong directory in the rebase line and other stuff but I've been slowly fixing them all.

ATIC Add Projects

I think I am nearly done with setting up the form for ATIC and I'm pretty sure I can get it done before the week is over. I finished setting up a template for the page for adding a project and I set up the add project function. I actually have an SQL related question that I'll ask you tomorrow but I should be able to demonstrate the form soon.

ATIC

I started working on the form for ATIC and I'm pretty sure I finished setting up all the templates. I also made the database so all I need to do now is finish the submit buttons. I'm going to test it once the submit buttons are done and I'll blog about how that goes.

More Fruits and Veggies

I worked more on the fruits and veggies database and it now has a hierarchy so that if you go into addfruit and hit submit it will go to '/addfruit/submit' instead of just '/submit'. I also changed it so that you can't leave the food name field empty. I also accidentally added a fruit with no name that I couldn't delete so I just added in the line "cur.execute('DELETE FROM food WHERE name=""')" temporarily in run.py. The next thing I should do is add buttons to return to the table when a fruit is removed.

Fruits and Veggies

On Thursday I worked on bottle zoo and I was looking at run.py to get the submit button working. I had an idea of what to do by looking at the sql delete statement and the function on how to add fruits.

During NHS Alex and Sam helped me and we got the submit button working. Alex also suggested that I change the URLs so it forms a hierarchy like '/addfruits/added' instead of two seperate URLs for both. Also you can currently add in blank strings which should probably be fixed.

SQL and HTML

So I was working on the fruit table in bottle zoo and I figured out how to display the page with your help although now it won't submit so I need to learn how to allow users to make changes.

To delete something in SQL you just write
DELETE FROM table WHERE column=columndata;
for example
DELETE FROM Movies WHERE Title='Big Trouble in Little China';


To let the user remove something from the table you would use an html form where the user would select what they want deleted and then submit it. I need to read about cursors but I guess the cursor goes through the database and makes the changes.

Bottle Form

Dylan and I got a form set up so now we have to try and set it up so data can be submitted. We kind of have an idea but the bottle zoo you showed us should be really helpful.

ATIC set up

On Wednesday I worked with Dylan to try and get the form web page working but we didn't really make any progress but I realize now that the problem was that we were messing up the rebase line.

Jack helped me with github so now I have my own branch and everything is installed so ATIC is fully functional! So I got a form webpage working and the reason it was not working before was because we had the wrong path in the "%rebase" line.

Webfaction Instructions

1. Log into webfaction and choose application under the domain/website tab
2. Choose mod_wsgi for category, use latest python for app type, and name obviously(we are calling it ATIC). Then hit save.
3. Go into websites tab and make sure the domain and apps are set
4. Log into webfaction using the command line(ssh atic@ip)
5. Go from the home directory to "webapps" then into "atic"
6. Then make a directory called lib/python3.4 and install bottle in that directory using
   $ export PYTHONPATH=$PWD/lib/python3.4
   and
   $ easy_install-3.4 -s $PWD/bin -d $PWD/lib/python3.4 bottle
7. Put adapter.wsgi into main directory and add the line
   "WSGIScriptAlias / /home/atic/webapps/atic/adapter.wsgi"
   in apache2/conf/httpd.conf
8. Then move attic.py, static, and templates into lib/python3.4 although Matt said this was not good practice

You can also look at this post for reference as well


Also, I didn't have a lot of time yesterday to blog but that was when you were helping Dylan and I with bottle. Alex also linked me his math_drill project for help.

https://github.com/ahirschberg/math_drill/blob/master/run.py#L160-L173

https://github.com/ahirschberg/math_drill/blob/master/template/students.tpl

Cordova

I spent most of the day just reading random documentation about Cordova. I found some interesting links about optimization although I can't really apply it, it is still neat stuff. I found a page which talked about design, testing, good practices, etc and it also linked to these two pages about increasing performance for apps. I didn't understand a lot of it but apparently onclick events are a big problem that can make an app unresponsive.

Cordova

I did the setup for building Firefox OS apps which didn't take long and it worked perfectly fine and the OS looks cool. When I was doing the setup for android apps it was taking a lot longer because the Oracle Java 7 JDK was taking a long time to install. Anyway, I finished installing Android Studio but I couldn't run it which seems really weird and I don't think I screwed anything up but I'm not sure.

Still More Bottle

I reviewed some of the beginning of the bottle tutorial and continued on to the later stuff. Some of it mostly makes perfect sense while some other stuff I have to reread a lot and I still don't get it. I understand stuff like how to make custom error pages and how to mess around with downloading files and suggesting file names but I don't really understand what it is talking about with stuff like generating content. I'll also take a look at the form example some more since that is what we are trying to do.