Beginner PyGTK and MySQL abuse request

[Tom Wesley]

Hey,

I've spent far too long being spoilt by a relatively simplistic "just do 
it" style of database application in use at work and have decided to try 
my hand at some Python + MySQL + GTK over the next few days.

I've managed to steal/write a short script that asks for some input and 
searches a database and print the results and was wondering if people 
would have the time to suggest better ways of doing the limited set of 
things it does?

---search.py---
#!/usr/bin/env python

import pygtk
pygtk.require('2.0')
import gtk
import adodb

class AddressSearch:
	def delete_event(self, widget, data=None):
		gtk.main_quit()
		return gtk.FALSE
		
	def btn_search(self, widget, data=None):
		conn = adodb.NewADOConnection('mysql')
		conn.Connect('localhost','root','','rtl')
		
		sql = "select * from address where match(Address1, Address2, Address3, 
Address4, Address5) against('+" + self.entry_address1.get_text() + "+" + 
self.entry_address2.get_text() + "+" + self.entry_address3.get_text() + 
"' in boolean mode);"
		print sql
		cursor = conn.Execute(sql)
		while not cursor.EOF:
			arr = cursor.GetRowAssoc(0)
			print arr['rtlforename'], arr['rtlsurname']
			cursor.MoveNext()
		
		cursor.Close()
		conn.Close()

	def __init__(self):
		self.window = gtk.Window(gtk.WINDOW_TOPLEVEL)
		self.window.set_title("Address search")
		self.window.connect("delete_event", self.delete_event)
		self.window.set_border_width(20)

		table = gtk.Table(5, 2, gtk.TRUE)
		self.window.add(table)

		label = gtk.Label("Address:")
		table.attach(label, 0, 1, 1, 5)
		self.entry_address1 = gtk.Entry(max=80)
		table.attach(self.entry_address1, 1, 2, 0, 1)
		self.entry_address2 = gtk.Entry(max=80)
		table.attach(self.entry_address2, 1, 2, 1, 2)
		self.entry_address3 = gtk.Entry(max=80)
		table.attach(self.entry_address3, 1, 2, 2, 3)

		button = gtk.Button(label='Search', stock=gtk.STOCK_OK)
		button.connect("clicked", self.btn_search)
		table.attach(button, 0, 1, 3, 4)

		button = gtk.Button(label="Quit", stock=gtk.STOCK_QUIT)
		button.connect("clicked", self.delete_event)
		table.attach(button, 1, 2, 3, 4)

		self.window.show_all()

def main():
	gtk.main()
	return 0

if __name__ == "__main__":
	AddressSearch()
	main()
---end---


Cheers,
Tom