View difference between Paste ID: s41sT4E2 and uN2DwAjt

 #!/usr/bin/env python
 
 # Class handling MasterControl Data
 
 # Author: YoungJules with thanks to Matt and the guys at ENTS for the original MasterControl concept.
 
 # Class is a singleton and takes care of making a connection to the db and creating a cursor
 # This is part of a pluggable architecture which simplifies use of different databases and other data sources
 # To enable another database in MasterControl (e.g. postgreSQL)
 #	Clone MasterControlMySQL.py to MasterControlPostgres.py
 #       Adjust imports
 #       Adjust database connection params in connect()
 #       Adjust SQL statements where required (e.g. postgreSQL may have different syntax for joins...)
 #       Remove MasterControlMySQL.py from application path and rerun RFIDServer
 # Using other data sources (flat files, excel...)
 #	Follow pattern as above and adjust subroutines to get data from other datasource/update other datasource
 #	Ensure routines returning a 'row' return an appropriate array of data
 #       If you don't need to close anything at exit, just create a close() with pass, and similar for connect()
 
 # Example usage:
 # 	row = MCData().getMember( '117877', 'FobNumber' )
 
 # Available functions:
 #	getMember( fob number, fob field name )
 #	getLastUnlock( door number )
 #	createDoorLogFail( fob number, door number, command )
 #	createDoorLogAdmit( fob number, first name, last name, door number )
 #	getSeconds( last unlock )
 #	updateMember( fob number, fob field name, last unlock field name )
 
 # Specific imports for MySQL, your mileage may vary...
 import MySQLdb
 import MySQLdb.cursors
 
 class MCData(object):
 	conn = None
 	cursor = None
 
 	"""Use to create a singleton"""
 	def __new__(cls, *args, **kwds):
 		"""
 		>>> s = MCData()
 		>>> p = MCData()
 		>>> id(s) == id(p)
 		True
 		"""
 		self = "__self__"
 		if not hasattr(cls, self):
 			instance = object.__new__(cls)
 			instance.init(*args, **kwds)
 			setattr(cls, self, instance)
 		return getattr(cls, self)
 
-		#return conn, cursor
+
 		self.connect()
-	def close( self, conn, cursor ):
+
 	def connect( self ):
 		# Information about the database
 		database = "ENTS"
 		table = "members"
 		hostaddr = "localhost"
 		username = "mastercontrol"
-        	print "getLastUnlock"
+
 		password = "pass"
 		self.conn = MySQLdb.connect ( host = hostaddr, user = username, passwd = password, db = database, cursorclass=MySQLdb.cursors.DictCursor )
         	self.cursor = self.conn.cursor()
-		print "getLastUnlock returning row:"
+
-		print row
+	def close( self ):
 		self.cursor.close()
 		self.conn.close()
 
-		print "getMember"
+
 	# We match FobNumber on the members table with CardNum on the DoorLog table and search based on door number
 	def getLastUnlock( self, doorNum ):
 		# We use an inner join because we want to find at least one match on both tables
         	self.cursor.execute ("SELECT * from DoorLog inner join members ON members.FobNumber=DoorLog.CardNum where DoorNum = '"+str(doorNum)+"' order by EventDateTime DESC")
-                	#no match for that user cardNum, send
+
-                	#server.serve_forever()back fail message
+		#print "getLastUnlock returning row:"
 		#print row
-                	#print Exception
+
 
 	def getMember( self, fobNumber, fobField ):
         	self.cursor.execute ("SELECT * from members where "+fobField+" = '" + fobNumber+"'")
-		print "createDoorLogFail"
+
         		row = self.cursor.fetchone()                 #get the record for the current cardnum
         	except ValueError:              #Exception:
                 	#TODO: Something better than just printing a message!
                 	print "Major Failure \n"
 		return row
-		print "createDoorLogAdmit"
+
 	def createDoorLogFail( self, fobNumber, doorNumber, cmd ):
 		self.cursor.execute("insert into DoorLog values ("+fobNumber+
         	",'"+fobNumber+" Not in database: "+cmd+
         	"','"+doorNumber+"',now(),NULL)")
 
-		print "getSeconds"
+
         	self.cursor.execute("insert into DoorLog values ("+fobNumber+
         	",'"+firstName+" "+lastName+" unlocked door "+doorNumber+
         	"','"+doorNumber+"',now(),NULL)")
 
 	def getSeconds( self, lastUnlock ):
 		self.cursor.execute("select timestampdiff(second,'"+lastUnlock+"',now()) as seconds")
         	seconds = self.cursor.fetchone()['seconds']
-		print "updateMember"
+
 			seconds = 2000
 		return seconds
 
 	def updateMember( self, fobNumber, fobField, lastUnlockField ):
 		self.cursor.execute("update members set "+lastUnlockField+" =  now() where "+fobField+" = '"+fobNumber+"'")