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})
