def addPost(self,aid,title,content,type,permission): cur = self.dbAdapter.getcursor() pid = Utility.getid() query = "INSERT INTO post VALUES('%s','%s',NULL,'%s','%s','%s','%s')"%(pid,aid,title,content,type,permission) try: cur.execute(query) except mysql.connector.Error as err: print("****************************************") print("SQLException from addPost():") print("Error code:", err.errno) print("SQLSTATE value:", err.sqlstate) print("Error message:", err.msg) print("Might be query issue:",query) print("****************************************") return None if cur.rowcount>0: return pid else: return False
def insertImage(self,path,aid,pid): cur = self.dbAdapter.getcursor() iid = Utility.getid() query = "INSERT INTO image VALUES('%s',NULL,'%s','%s','%s')"%(iid,path,aid,pid) try: cur.execute(query) except mysql.connector.Error as err: print("****************************************") print("SQLException from addNewCircle():") print("Error code:", err.errno) print("SQLSTATE value:", err.sqlstate) print("Error message:", err.msg) print("Query:",query) print("****************************************") return False return iid
def addServer(self,name,url,local): cur = self.dbAdapter.getcursor() sid =Utility.getid() query = ("INSERT INTO servers VALUES('%s','%s','%s',%s)")%(sid,name,url,local) try: cur.execute(query) except mysql.connector.Error as err: print("****************************************") print("SQLException from doesServerExists():") print("Error code:", err.errno) print("SQLSTATE value:", err.sqlstate) print("Error message:", err.msg) print("Query:",query) print("****************************************") return None if cur.rowcount > 0: return sid else: return False
def addAuthor(self,name,password,nickName,sid='cs410.cs.ualberta.ca:41070'): cur = self.dbAdapter.getcursor() aid =Utility.getid() query = ("INSERT INTO author(aid,name,nick_name,pwd,sid) " "VALUES('%s','%s','%s','%s','%s')")%(aid,name,nickName,password,sid) try: cur.execute(query) except mysql.connector.Error as err: print("****************************************") print("SQLException from addAuthor():") print("Error code:", err.errno) print("SQLSTATE value:", err.sqlstate) print("Error message:", err.msg) print("Might be query issue:",query) print("****************************************") return False return json.dumps({"aid":aid})
def addLocalTmpAuthor(self,authorName,password,nickName): """ # TODO: # [Success] return {'aid':xxxxx } (jason type) # [Exception Caught] return false # [Failed] return false """ cur = self.dbAdapter.getcursor() aid = Utility.getid() query = ("INSERT INTO author values('%s','%s','%s','%s','%s','','','','','',0)"%(aid,authorName,nickName,password,self.localSid)) try: cur.execute(query) except mysql.connector.Error as err: print("****************************************") print("SQLException from getFriendOfFriend():") print("Error code:", err.errno) print("SQLSTATE value:", err.sqlstate) print("Error message:", err.msg) print("Query:",query) print("******************************") return False return json.dumps({'aid':aid})