'''

Created on Feb 11, 2016

@author: sumkuma2

'''

import MySQLdb

from DBUtil import DbUtil

#dbhost='localhost'

#dbname='pythondb'

#dbuser='root'

#dbpwd='root'

#dbutil = DbUtil(dbhost,dbuser,dbpwd,dbname)

dbutil = DbUtil()

con = dbutil.getMySQLConnection()

cursor = con.cursor()

try:

sql = "SELECT * FROM employee"

cursor.execute(sql)

'''Fetch all the rows in a list of lists.'''

results = cursor.fetchall()

print "empid,first_name,last_name,age,sex,income"

for row in results:

empid = row[0]

fname = row[1]

lname = row[2]

age = row[3]

sex = row[4]

income = row[5]

# Now print fetched result

print empid,",",fname,",",lname,",",age,",",sex,",",income

#print "empid=%d,fname=%s,lname=%s,age=%d,sex=%s,income=%d"%(empid,fname,lname,age,sex,income)

except MySQLdb.Error, e:

print "Error: unable to fecth data %s",e

finally:

cursor.close()

con.close()