def getArticleRelevance(commentID):
if request.method == 'GET':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
if isinstance(commentID, int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(ArticleRelevance=0.0,
status="commentID Should be Numeric/Integer")
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
cursor.execute(
"select count(*) from comments where commentID = '" +
str(commentID) + "' ")
count = cursor.fetchall()[0][0]
if count < 1:
return jsonify(ArticleRelevance=0.0,
status="Invalid commentID")
cursor.execute(
"select ArticleRelevance from comments where commentID = '" +
commentID + "' ")
scores = cursor.fetchall()
rowsaffected = cursor.rowcount
cnx.close
if rowsaffected == 1:
status = "success"
ArticleRelevance = scores[0][0]
else:
status = "operation failed"
ArticleRelevance = 0.0
except:
ArticleRelevance = 0.0
status = error_name()
else:
ArticleRelevance = 0.0
status = "Operation failed - Use HTTP GET method"
return jsonify(ArticleRelevance=ArticleRelevance, status=status)
def updateArticle():
if request.method == 'POST':
try:
data = request.data
dataDict = json.loads(data)
articleID = dataDict['articleID']
if isinstance(articleID, int):
pass
elif articleID.isdigit():
pass
else:
return jsonify(status="articleID Should be Numeric/Integer")
if isinstance(dataDict['article_text'], basestring):
pass
else:
return jsonify(status="Enter Article Text as a string value")
article_text = escape_string(dataDict['article_text'].strip())
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
cursor.execute(
"select count(*) from articles where articleID = '" +
str(articleID) + "' ")
count = cursor.fetchall()[0][0]
if count < 1:
return jsonify(status="Invalid articleID")
update = "update articles set full_text = '"+ article_text +"' " \
" where articleID = '"+ str(articleID) +"' "
cursor.execute(update)
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Update Successful"
else:
status = "No Update performed"
except:
status = error_name()
else:
status = "Operation failed - use HTTP POST method"
return jsonify(status=status)
def updateArticle():
if request.method == 'POST':
try:
data = request.data
dataDict = json.loads(data)
articleID = dataDict['articleID']
if isinstance(articleID,int):
pass
elif articleID.isdigit():
pass
else:
return jsonify(status = "articleID Should be Numeric/Integer")
if isinstance(dataDict['article_text'],basestring):
pass
else:
return jsonify(status = "Enter Article Text as a string value")
article_text = escape_string(dataDict['article_text'].strip())
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from articles where articleID = '"+ str(articleID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(status = "Invalid articleID")
update = "update articles set full_text = '"+ article_text +"' " \
" where articleID = '"+ str(articleID) +"' "
cursor.execute(update)
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Update Successful"
else:
status = "No Update performed"
except:
status = error_name()
else:
status = "Operation failed - use HTTP POST method"
return jsonify(status = status)
def deleteComment(commentID):
if request.method == 'DELETE':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
if isinstance(commentID, int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(status="commentID Should be Numeric/Integer")
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
cursor.execute(
"select count(*) from comments where commentID = '" +
str(commentID) + "' ")
count = cursor.fetchall()[0][0]
if count < 1:
return jsonify(status="Invalid commentID")
delete = "delete from comments where commentID = '" + commentID + "'"
cursor.execute(delete)
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Delete successful"
else:
status = "Delete failed"
except:
status = error_name()
else:
status = "Operation failed - Use HTTP DELETE method"
return jsonify(status=status)
def getLength(commentID):
if request.method == 'GET':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
if isinstance(commentID,int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(Length = 0.0,status = "commentID Should be Numeric/Integer")
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from comments where commentID = '"+ str(commentID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(Length = 0.0,status = "Invalid commentID")
cursor.execute("select CommentLength from comments where commentID = '" + commentID + "' ")
scores = cursor.fetchall()
rowsaffected = cursor.rowcount
cnx.close
if rowsaffected == 1:
status = "success"
Length = scores[0][0]
else:
status = "operation failed"
Length = 0.0
except:
Length = 0.0
status = error_name()
else:
Length = 0.0
status = "Operation failed - Use HTTP GET method"
return jsonify(Length = Length, status = status)
def addArticle():
if request.method == 'POST':
try:
current_time = time.strftime("%Y-%m-%d %I:%M:%S")
data = request.data
dataDict = json.loads(data)
if isinstance(dataDict['article_text'], basestring):
pass
else:
return jsonify(articleID=None,
status="Enter Article Text as a string value")
article_text = escape_string(dataDict['article_text'].strip())
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
insert_query = "INSERT INTO articles (pubDate, full_text)" \
" VALUES('%s', '%s')" % \
(current_time, article_text)
cursor.execute(insert_query)
articleID = cursor.lastrowid
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Add Successful"
else:
status = "Add failed"
except:
articleID = None
status = error_name()
else:
articleID = None
status = "Operation failed - use HTTP POST method"
return jsonify(articleID=articleID, status=status)
def deleteComment(commentID):
if request.method == 'DELETE':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
if isinstance(commentID,int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(status = "commentID Should be Numeric/Integer")
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from comments where commentID = '"+ str(commentID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(status = "Invalid commentID")
delete = "delete from comments where commentID = '"+ commentID +"'"
cursor.execute(delete)
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Delete successful"
else:
status = "Delete failed"
except:
status = error_name()
else:
status = "Operation failed - Use HTTP DELETE method"
return jsonify(status = status)
def addArticle():
if request.method == 'POST':
try:
current_time = time.strftime("%Y-%m-%d %I:%M:%S")
data = request.data
dataDict = json.loads(data)
if isinstance(dataDict['article_text'],basestring):
pass
else:
return jsonify(articleID = None ,status = "Enter Article Text as a string value")
article_text = escape_string(dataDict['article_text'].strip())
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
insert_query = "INSERT INTO articles (pubDate, full_text)" \
" VALUES('%s', '%s')" % \
(current_time, article_text)
cursor.execute(insert_query)
articleID = cursor.lastrowid
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Add Successful"
else:
status = "Add failed"
except:
articleID = None
status = error_name()
else:
articleID = None
status = "Operation failed - use HTTP POST method"
return jsonify(articleID = articleID,status = status)
def getConversationalRelevance(commentID):
if request.method == 'GET':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from comments where commentID = '"+ str(commentID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(ConversationalRelevance = 0.0 , status = "Invalid commentID")
cursor.execute("select ConversationalRelevance from comments where commentID = '" + commentID + "' ")
scores = cursor.fetchall()
rowsaffected = cursor.rowcount
cnx.close
if rowsaffected == 1:
status = "success"
ConversationalRelevance = scores[0][0]
else:
status = "operation failed"
ConversationalRelevance = 0.0
except:
status = error_name()
ConversationalRelevance = 0.0
else:
ConversationalRelevance = 0.0
status = "Operation failed - Use HTTP GET method"
return jsonify(ConversationalRelevance = ConversationalRelevance, status = status)
def getScores(commentID):
if request.method == 'GET':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
if isinstance(commentID, int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "commentID Should be Numeric/Integer")
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
cursor.execute(
"select count(*) from comments where commentID = '" +
str(commentID) + "' ")
count = cursor.fetchall()[0][0]
if count < 1:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Invalid commentID")
cursor.execute("select ArticleRelevance,ConversationalRelevance,PersonalXP,Readability, CommentLength " \
"from comments where commentID = '" + commentID + "' ")
scores = cursor.fetchall()
rowsaffected = cursor.rowcount
cnx.close
if rowsaffected == 1:
status = "success"
ArticleRelevance = scores[0][0]
ConversationalRelevance = scores[0][1]
PersonalXP = scores[0][2]
Readability = scores[0][3]
Length = scores[0][4]
else:
status = "operation failed"
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
except:
status = error_name()
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
else:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = "Operation failed - Use HTTP GET method"
return jsonify(ArticleRelevance = ArticleRelevance, ConversationalRelevance = ConversationalRelevance, \
PersonalXP = PersonalXP, Readability = Readability, Length = Length, status = status)
def UpdateComments():
if request.method == 'POST':
try:
data = request.data
dataDict = json.loads(data)
commentID = dataDict['commentID']
if isinstance(commentID, int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "commentID Should be Numeric/Integer")
if isinstance(dataDict['commentBody'], basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Enter commentBody as a string value")
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
cursor.execute(
"select count(*) from comments where commentID = '" +
str(commentID) + "' ")
count = cursor.fetchall()[0][0]
if count < 1:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Invalid commentID")
cursor.execute(
"select commentDate,recommendationCount,username,location from comments where commentID = '"
+ str(commentID) + "'")
for row in cursor:
commentDate = row[0]
recommendationCount = row[1]
username = row[2]
location = row[3]
commentBody = escape_string(dataDict['commentBody'].strip())
if 'commentDate' in dataDict:
commentDate = dataDict['commentDate']
try:
datetime.datetime.strptime(commentDate,
'%Y-%m-%d %H:%M:%S')
except:
err_msg = "Incorrect date format, Correct format should be YYYY-MM-DD H:M:S"
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0 ,status = err_msg)
if 'recommendationCount' in dataDict:
recommendationCount = dataDict['recommendationCount']
if isinstance(recommendationCount, int):
pass
elif recommendationCount.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "recommendationCount Should be Numeric/Integer")
recommendationCount = int(recommendationCount)
if 'username' in dataDict:
username = dataDict['username']
if isinstance(username, basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0, status = "Enter username as a string value")
if 'location' in dataDict:
location = dataDict['location']
if isinstance(location, basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Enter Location as a string value")
# Call updateComment() function of subroutine - calculate_score to re-calculate all the scores
ArticleRelevance, ConversationalRelevance, PersonalXP, Readability, Length = \
updateComment(commentBody,commentID)
update = "update comments set ArticleRelevance = '"+ str(ArticleRelevance) +"', " \
"ConversationalRelevance = '"+ str(ConversationalRelevance) +"' , " \
"PersonalXP = '"+ str(PersonalXP) +"', Readability = '"+ str(Readability) +"'," \
"CommentLength = '"+ str(Length) +"', CommentBody = '" + commentBody + "' ," \
"commentDate = '"+ str(commentDate) +"', recommendationCount = '" + str(recommendationCount) + "', " \
"username = '******', location = '" + str(location) + "' " \
" where commentID = '"+ str(commentID) +"' "
cursor.execute(update)
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Update Successful"
else:
status = "No update performed"
except:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = error_name()
else:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = "Update Operation failed - use HTTP POST method"
return jsonify(ArticleRelevance = ArticleRelevance, ConversationalRelevance = ConversationalRelevance, \
PersonalXP = PersonalXP, Readability = Readability, Length = Length, status = status)
def AddComment():
if request.method == 'POST':
try:
data = request.data
dataDict = json.loads(data)
articleID = dataDict['articleID']
if isinstance(articleID, int):
pass
elif articleID.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "articleID Should be Numeric/Integer")
if isinstance(dataDict['commentBody'], basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Enter commentBody as a string value")
commentBody = escape_string(dataDict['commentBody'].strip())
if 'commentDate' in dataDict:
commentDate = dataDict['commentDate']
try:
datetime.datetime.strptime(commentDate,
'%Y-%m-%d %H:%M:%S')
except:
err_msg = "Incorrect date format, Correct format should be YYYY-MM-DD H:M:S"
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = err_msg)
else:
commentDate = time.strftime("%Y-%m-%d %H:%M:%S")
if 'recommendationCount' in dataDict:
recommendationCount = dataDict['recommendationCount']
if isinstance(recommendationCount, int):
pass
elif recommendationCount.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "recommendationCount Should be Numeric/Integer")
recommendationCount = int(dataDict['recommendationCount'])
else:
recommendationCount = 0
if 'username' in dataDict:
username = dataDict['username']
if isinstance(username, basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Enter username as a string value")
else:
username = ""
if 'location' in dataDict:
location = dataDict['location']
if isinstance(location, basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Enter Location as a string value")
else:
location = ""
cnx = mysql.connector.connect(user=user,
password=password,
host=host,
database=database)
cursor = cnx.cursor()
cursor.execute(
"select count(*) from articles where articleID = '" +
str(articleID) + "' ")
count = cursor.fetchall()[0][0]
if count < 1:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Invalid articleID")
else:
# Call addComment() function of subroutine - calculate_score to calculate all the scores
ArticleRelevance, ConversationalRelevance, PersonalXP, Readability, Length = \
addComment(commentBody,articleID)
insert_query = "INSERT INTO comments (commentBody, articleID," \
"commentDate,recommendationCount,username,location," \
"ArticleRelevance,ConversationalRelevance, PersonalXP, Readability, CommentLength)" \
"VALUES ('%s','%s','%s','%d','%s','%s','%s','%s','%s','%s','%s')" % \
(commentBody,articleID,commentDate,recommendationCount,username,location, \
str(ArticleRelevance),str(ConversationalRelevance),str(PersonalXP),str(Readability),str(Length))
cursor.execute(insert_query)
CommentID = cursor.lastrowid
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Add Successful"
else:
status = "Add failed"
except:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = error_name()
CommentID = None
else:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
CommentID = None
status = "Add operation failed - use HTTP POST method"
return jsonify(ArticleRelevance = ArticleRelevance, ConversationalRelevance = ConversationalRelevance, \
PersonalXP = PersonalXP, Readability = Readability, Length = Length, \
commentID = CommentID,status=status)
def getScores(commentID):
if request.method == 'GET':
try:
if isinstance(commentID, int):
commentID = str(commentID)
commentID = commentID.replace("'", '')
commentID = commentID.replace('"', '')
if isinstance(commentID,int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "commentID Should be Numeric/Integer")
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from comments where commentID = '"+ str(commentID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Invalid commentID")
cursor.execute("select ArticleRelevance,ConversationalRelevance,PersonalXP,Readability, CommentLength " \
"from comments where commentID = '" + commentID + "' ")
scores = cursor.fetchall()
rowsaffected = cursor.rowcount
cnx.close
if rowsaffected == 1:
status = "success"
ArticleRelevance = scores[0][0]
ConversationalRelevance = scores[0][1]
PersonalXP = scores[0][2]
Readability = scores[0][3]
Length = scores[0][4]
else:
status = "operation failed"
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
except:
status = error_name()
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
else:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = "Operation failed - Use HTTP GET method"
return jsonify(ArticleRelevance = ArticleRelevance, ConversationalRelevance = ConversationalRelevance, \
PersonalXP = PersonalXP, Readability = Readability, Length = Length, status = status)
def UpdateComments():
if request.method == 'POST':
try:
data = request.data
dataDict = json.loads(data)
commentID = dataDict['commentID']
if isinstance(commentID,int):
pass
elif commentID.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "commentID Should be Numeric/Integer")
if isinstance(dataDict['commentBody'],basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Enter commentBody as a string value")
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from comments where commentID = '"+ str(commentID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Invalid commentID")
cursor.execute("select commentDate,recommendationCount,username,location from comments where commentID = '"+ str(commentID) +"'")
for row in cursor:
commentDate = row[0]
recommendationCount = row[1]
username = row[2]
location = row[3]
commentBody = escape_string(dataDict['commentBody'].strip())
if 'commentDate' in dataDict:
commentDate = dataDict['commentDate']
try:
datetime.datetime.strptime(commentDate, '%Y-%m-%d %H:%M:%S')
except:
err_msg = "Incorrect date format, Correct format should be YYYY-MM-DD H:M:S"
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0 ,status = err_msg)
if 'recommendationCount' in dataDict:
recommendationCount = dataDict['recommendationCount']
if isinstance(recommendationCount,int):
pass
elif recommendationCount.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "recommendationCount Should be Numeric/Integer")
recommendationCount = int(recommendationCount)
if 'username' in dataDict:
username = dataDict['username']
if isinstance(username,basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0, status = "Enter username as a string value")
if 'location' in dataDict:
location = dataDict['location']
if isinstance(location,basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,status = "Enter Location as a string value")
# Call updateComment() function of subroutine - calculate_score to re-calculate all the scores
ArticleRelevance, ConversationalRelevance, PersonalXP, Readability, Length = \
updateComment(commentBody,commentID)
update = "update comments set ArticleRelevance = '"+ str(ArticleRelevance) +"', " \
"ConversationalRelevance = '"+ str(ConversationalRelevance) +"' , " \
"PersonalXP = '"+ str(PersonalXP) +"', Readability = '"+ str(Readability) +"'," \
"CommentLength = '"+ str(Length) +"', CommentBody = '" + commentBody + "' ," \
"commentDate = '"+ str(commentDate) +"', recommendationCount = '" + str(recommendationCount) + "', " \
"username = '******', location = '" + str(location) + "' " \
" where commentID = '"+ str(commentID) +"' "
cursor.execute(update)
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Update Successful"
else:
status = "No update performed"
except:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = error_name()
else:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = "Update Operation failed - use HTTP POST method"
return jsonify(ArticleRelevance = ArticleRelevance, ConversationalRelevance = ConversationalRelevance, \
PersonalXP = PersonalXP, Readability = Readability, Length = Length, status = status)
def AddComment():
if request.method == 'POST':
try:
data = request.data
dataDict = json.loads(data)
articleID = dataDict['articleID']
if isinstance(articleID,int):
pass
elif articleID.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "articleID Should be Numeric/Integer")
if isinstance(dataDict['commentBody'],basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Enter commentBody as a string value")
commentBody = escape_string(dataDict['commentBody'].strip())
if 'commentDate' in dataDict:
commentDate = dataDict['commentDate']
try:
datetime.datetime.strptime(commentDate, '%Y-%m-%d %H:%M:%S')
except:
err_msg = "Incorrect date format, Correct format should be YYYY-MM-DD H:M:S"
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = err_msg)
else:
commentDate = time.strftime("%Y-%m-%d %H:%M:%S")
if 'recommendationCount' in dataDict:
recommendationCount = dataDict['recommendationCount']
if isinstance(recommendationCount,int):
pass
elif recommendationCount.isdigit():
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "recommendationCount Should be Numeric/Integer")
recommendationCount = int(dataDict['recommendationCount'])
else:
recommendationCount = 0
if 'username' in dataDict:
username = dataDict['username']
if isinstance(username,basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Enter username as a string value")
else:
username = ""
if 'location' in dataDict:
location = dataDict['location']
if isinstance(location,basestring):
pass
else:
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Enter Location as a string value")
else:
location = ""
cnx = mysql.connector.connect(user=user, password=password, host=host, database=database)
cursor = cnx.cursor()
cursor.execute("select count(*) from articles where articleID = '"+ str(articleID) +"' ")
count = cursor.fetchall()[0][0]
if count < 1 :
return jsonify(ArticleRelevance = 0.0, ConversationalRelevance = 0.0 , PersonalXP = 0.0 , \
Readability = 0.0, Length = 0.0,commentID = None ,status = "Invalid articleID")
else:
# Call addComment() function of subroutine - calculate_score to calculate all the scores
ArticleRelevance, ConversationalRelevance, PersonalXP, Readability, Length = \
addComment(commentBody,articleID)
insert_query = "INSERT INTO comments (commentBody, articleID," \
"commentDate,recommendationCount,username,location," \
"ArticleRelevance,ConversationalRelevance, PersonalXP, Readability, CommentLength)" \
"VALUES ('%s','%s','%s','%d','%s','%s','%s','%s','%s','%s','%s')" % \
(commentBody,articleID,commentDate,recommendationCount,username,location, \
str(ArticleRelevance),str(ConversationalRelevance),str(PersonalXP),str(Readability),str(Length))
cursor.execute(insert_query)
CommentID = cursor.lastrowid
rowsaffected = cursor.rowcount
cnx.commit()
cnx.close
if rowsaffected == 1:
status = "Add Successful"
else:
status = "Add failed"
except:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
status = error_name()
CommentID = None
else:
ArticleRelevance = 0.0
ConversationalRelevance = 0.0
PersonalXP = 0.0
Readability = 0.0
Length = 0.0
CommentID = None
status = "Add operation failed - use HTTP POST method"
return jsonify(ArticleRelevance = ArticleRelevance, ConversationalRelevance = ConversationalRelevance, \
PersonalXP = PersonalXP, Readability = Readability, Length = Length, \
commentID = CommentID,status=status)
