Return MySQL data as dictionaries to avoid confusion

[vilhelmprytz]

Queries in the current setup returns lists, which can make it confusing concerning which key is which. Using dictionaries, we can avoid confusion during coding (refactoring, doesn't necessarily change anything for the end user).

Right now, querying for the class of a student looks like this.

result = sql_query("SELECT * FROM students WHERE id=0")

print(result[0][4])

The first [0] is the element of the "search query" (which in this case should only consist of one element, as the id should always be unique) and the second [4] refers to the fourth column, which in this case is the class of the student row.

See this StackOverflow question for more information on how to do this.

[vilhelmprytz]

Too much of main codebase is based on using tuples. We've decided to not fix this until we're finished with a "stable" initial release.