def addName():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select * from plantvername")
results = cur.fetchall()
cur.close()
conn.close()
return results
def findRemotesensing():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select * from remotesensing ")
results = cur.fetchall()
cur.close()
conn.close()
return results
def updateeverglades(result, id):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("update everglades set Value=%s where Id=%s", (result, id))
conn.commit()
cur.close()
conn.close()
pass
def findAllPapaerId():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select ID from article")
results = cur.fetchall()
cur.close()
conn.close()
return results
def findAuthorFromArticle():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select ID,Title from article")
results = cur.fetchall()
cur.close()
conn.close()
return results
def findallwetland():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select * from information_all")
results = cur.fetchall()
cur.close()
conn.close()
return results
def findAllID():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute(
"update ArticlePerson inner join article on ArticlePerson.ArticleID=article.ID set ArticlePerson.title=article.Title"
)
conn.commit()
cur.close()
conn.close()
def findAuthorFromOrganization():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select * from organization")
results = cur.fetchall()
conn.commit()
cur.close()
conn.close()
return results
def changePlantLevel():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute(
"update plant left JOIN plantrank on Plant.PlantRankID=plantrank.RankID set Level = plantrank.ChineseName"
)
conn.commit()
cur.close()
conn.close()
def findSC():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute("select * from everglades where Property='SC'")
results = cur.fetchall()
conn.commit()
cur.close()
conn.close()
return results
def addToEverglades(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
cur.execute(
"insert into everglades(Term,Property,Value,ThesauName) VALUE (%s,%s,%s,%s)",
(result[1], result[2], result[3], result[4]))
conn.commit()
cur.close()
conn.close()
def findAuthorFromArticlePerson():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute(
"SELECT AuthorID,CONCAT(GROUP_CONCAT(title)) FROM ArticlePerson GROUP BY AuthorID;"
)
results = cur.fetchall()
cur.close()
conn.close()
return results
def findAuthorFromPersonorganization():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute(
"select RepAuthorID,CONCAT(GROUP_CONCAT(OrganizationName)) FROM personorganization GROUP BY RepAuthorID"
)
results = cur.fetchall()
cur.close()
conn.close()
return results
def updatePersonJoin():
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
cur.execute(
"select ArticlePerson.AuthorID ,CONCAT(GROUP_CONCAT(article_copy.title)) FROM "
"(person right join ArticlePerson on(person.AuthorID=ArticlePerson.AuthorID) LEFT JOIN article_copy on (ArticlePerson.ArticleID=article_copy.ID)) "
"GROUP BY ArticlePerson.AuthorID")
results = cur.fetchall()
cur.close()
conn.close()
return results
def updatewetland(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
count = cur.execute("select * from wetlandprotectarea where WetlandProtectAreaID=%s",(result[2]))
if count == 1:
cur.execute("update wetlandprotectarea set Administative_region=%s,National_legal_designation=%s,Country=%s where WetlandProtectAreaID=%s",(result[7],result[8],result[1],result[2]))
conn.commit()
cur.close()
conn.close()
def updatePerson(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
count = cur.execute("select * from person where AuthorID=%s",
(result[0], ))
if count == 1:
cur.execute("update person set Organization=%s where AuthorID=%s",
(result[1], result[0]))
conn.commit()
cur.close()
conn.close()
def updateauthors(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
count = cur.execute("select * from article where ID=%s ", (result[0]))
if count != 0:
cur.execute("update article set Authors=%s where ID=%s",
(result[1], result[0]))
else:
continue
conn.commit()
cur.close()
conn.close()
def updateArticlePerson(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
print results
for result in results:
count = cur.execute(
"select ArticleID from ArticlePerson where ArticleID=%s",
(result[0]))
if count != 0:
cur.execute("update ArticlePerson set title=%s where ArticleID=%s",
(result[1], result[0]))
conn.commit()
cur.close()
conn.close()
def updatePersonorganization(results):
#print type(results)
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
count = cur.execute(
"select * from personorganization where OrganizationID=%s",
(result[0]))
if count != 0:
cur.execute(
"update personorganization set OrganizationName=%s where OrganizationID=%s",
(result[1], result[0]))
conn.commit()
cur.close()
conn.close()
def change(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
count1 = cur.execute("select * from articleanimal where ArticleID=%s",(result[0],))
print count1
count2 = cur.execute("select * from articleplant where ArticleID=%s",(result[0],))
print count2
count3 = cur.execute("select * from wetlandprotectareaarticle where ArticleID=%s",(result[0],))
count = count1+count2+count3
if count ==0:
cur.execute("delete from article where ID=%s",(result[0],))
else:
continue
conn.commit()
cur.close()
conn.close()
def updateName(results):
conn = mysqlConnector.getMacLocalConn()
cur = conn.cursor()
for result in results:
count = cur.execute("select * from plant where ScientificName=%s",
(result[0], ))
if count == 0:
continue
elif count == 1:
if result[2] == 'LA':
cur.execute(
"update plant set PopularEName=%s where ScientificName=%s",
(result[1], result[0]))
elif result[2] == 'CH':
cur.execute(
"update plant set PopularCName=%s where ScientificName=%s",
(result[1], result[0]))
conn.commit()
cur.close
conn.close
