Code For Days

A MySQL database can be queried from a python script with MySQLdb. Just download it here and install it, or if you are using FreeBSD it can be found under

/usr/ports/databases/py-MySQLdb.

In the python script import the MySQLdb module and declare a connection in cursor as in this example:

import MySQLdb
# Create a connection using your db info
db = MySQLdb.connect(host=”localhost”, user=”yourMysqlUser”, passwd=”youUserPass”,db=”yourDB”)
# Create a cursor, this can be used over and over
cursor = db.cursor()
# Build a query
q = “select user_id, user_name from users”
# run the query
cursor.execute(q)
# fetch the results
users = cursor.fetchall()
# loop through the results
for user in users:

print “ID %s Name: %s” % (user[0],user[1])

The cursor is created once from the connection and can be used for all queries in the script. The query selects two columns from the table and then script loops through them and prints them out. Each column is referenced by a number zero based as it comes back as a list. The order is set by the query.

Once you have built your Google Web Toolkit application run the -compile.cmd script, or hit the compile/browse button in the debugger. It will open in a browser window and you will be able to double check that it works properly as javascript. At this point you should also double check that it looks fine in multiple browsers such as IE/FireFox/Opera.

The compiled files will be written to the www/com.your.app in the GWT directory. Open this directory and you will notice several .cache.html and .cache.xml files, as well as the gwt.js file. There will also be several image files. You will need need all of these except tree_closed.gif, tree_open.gif, and tree_white.gif if you did not use a tree in your application.

After compiling out your Google Web Toolkit Ajax application everything is in the same www directory and works great. But what if you want to move all the GWT files to a different directory then the page you are calling it from? To do this you need to update 2 to 3 parts of your page that calls in the app.

First change to include the directory and an equals sign. For example, if I put my GWT app in a directory called webapps I would have the following:

Second change path of the gwt.js file to include the new directory as you normally would for a javascript file.

Third if you included the history.html file change the path on the iframe also to include the directory. If you do not wish to include history support you may leave the iframe out all together.