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