DB code

[ras120]

db.zip

변경/추가 부분

1. petName

-Register.py

self.petName = None

def insertUserData(self, user_key, serial, email):
self.openDB()
self.curs = self.conn.cursor()

if self.checkRegistedUser(user_key) == True:
	return exception.REGISTERD_USER

try:
	if self.checkRegistedSerial(serial) == False:
		return exception.NO_REGISTERD_SERIAL
		self.curs.execute(insert.userTable(user_key,serial, email, self.petName))
	self.conn.commit()
	self.closeDB()
	return message.SUCESS_IST_USER
except:
	self.closeDB()
	return exception.DONT_REGIST

def getPetName(self, user_key):
self.openDB()
self.curs = self.conn.cursor()

try:
	self.curs.execute(select.petNameByUserKey(user_key))
	rows = self.curs.fetchone()
	result = " ".join(rows)
	print(result)
	self.closeDB()
	self.petName = result
	return result
except:
	self.closeDB()
	return exception.FAIL_TO_SELECT

2. oldimagelist

-delete.py
def oldimagelistByAddr

-select.py
def oldimagelistByAddr

-Register.py

def checkoldimagelistByAddr(self, addr):
	self.curs = self.conn.cursor()
	try:
		self.curs.execute(select.oldimagelistByAddr(addr))
		rows = self.curs.fetchall()
		if len(rows) > 0:
			return True
		else :
			return False
	except:
		return False

def insertoldimagelist(self, addr, serial):
	self.openDB()
	self.curs = self.conn.cursor()

	if self.checkRegistedSerial(serial) == False:
		return exception.NO_REGISTERD_SERIAL

	try:
		self.curs.execute(insert.oldimagelistTable(addr, serial))
		self.conn.commit()
		self.closeDB()
		return message.SUCESS_IST_OLD_IMAGE
	except:
		self.closeDB()
		return exception.FAIL_TO_IST_OLD_IMAGE

def deleteoldimagelist(self, addr):
	self.openDB()
	self.curs = self.conn.cursor()

	if self.checkoldimagelistByAddr(addr) == False:
		return False
	try:
		self.curs.execute(delete.oldimagelistByAddr(addr))
		self.conn.commit()
		self.closeDB()
		return True
	except:
		return False

def getoldimagelistFromSerial(self, serial):
	self.openDB()
	self.curs = self.conn.cursor()

	if self.checkRegistedSerial(serial) == False:
		return exception.NO_REGISTERD_SERIAL

	try:
		self.curs.execute(select.pathBySerial(serial))
		rows = self.curs.fetchall()
		image_list = []

		for row in rows:
			print(row[0])
			image_list.append(row[0])

		self.closeDB()
		return image_list

	except:
		self.closeDB()
		return exception.SELECT_FROM_CHECKING_SERIAL

3.home system
-select.py
def petCountBySerial(serial):
return "select * from %s where %s.serial = "%s";" %(
util.SERIAL_TABLE_NAME, util.SERIAL_TABLE_NAME, serial)

-update.py
def petCountBySerial(serial):
return "UPDATE %s SET %s WHERE %s.serial = '%s';" %(
util.SERIAL_TABLE_NAME, util.SERIAL_TABLE_NAME, util.SERIAL_TABLE_NAME, serial)

-Register.py

def getPetCountFromSerial(self,serial):
	self.openDB()
	self.curs = self.conn.cursor()
	if self.checkRegistedSerial(serial) == False:
		self.closeDB()
		return exception.NO_REGISTERD_SERIAL
	try:
		#petCNT = self.curs.execute(select.petCountBySerial(serial))
		petCNT = 0
		self.closeDB()
		print("petCount was deleted")
		return petCNT
	except:
		self.closeDB()
		return  -1

def updatePetCount(self, user_key):
	self.openDB()
	self.curs = self.conn.cursor()

	try:
		self.curs.execute(select.userSerialByUserKey(user_key))
		rows = self.curs.fetchall()
		if len(rows) <= 0:
			return False

		serial = rows[0][0]

		if self.checkRegistedSerial(serial=serial) == False:
			return False

		print(update.petCountBySerial(serial=serial))
		self.curs.execute(update.petCountBySerial(serial=serial))
		self.conn.commit()
		self.closeDB()
		return True
	except:
		self.closeDB()
		return False

[ras120]

flask.zip

[ras120]

https://github.com/kuj0210/Smart-mobile/blob/master/SMS1011.zip