#! /usr/bin/env python

""" import """
import MySQLdb


""" connecting """
db = MySQLdb.connect(user="se4_2006", passwd="return", db="se4_2006")


""" create a cursor """
cursor = db.cursor()

class Dataclass:
	def usernameExists(self, user):
		cursor.execute("SELECT * FROM E_Users WHERE username = %s", user)
		users = cursor.fetchone()
		print users
		cursor.execute("SELECT * FROM E_Events WHERE eventID = %s", user)
		events = cursor.fetchone()
		print events
		return (users != None) | (events != None)
					
	def getAccount(self, user):
		if self.usernameExists(user):
			cursor.execute("SELECT password FROM E_Accounts WHERE username = %s", user)
			result = cursor.fetchone()
			print result[0]
		else:
			print 'error: user does not exist'


x = Dataclass()

bool = x.usernameExists('kmollema')
print bool
bool = x.usernameExists('papa')
print bool
x.getAccount('kmollema')
x.getAccount('papa')