def deleteRudundancyData():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute('delete from literatureToWetland where wetland_name=%s or wetland_name=%s or wetland_name=%s',('Coll','Anda','PODA'))
cur.close()
conn.commit()
conn.close()
def getRelation():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute('select * from literatureToWetland ')
cur.close()
conn.close()
return cur.fetchall()
def getPlantsSynonym():
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute('select 物种名称,拉丁名_全称,别名,异名 from 中国湿地植物别名与异名')
results = cur.fetchall()
# print results
return results
def findLocation():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute('select 湿地编码,湿地名称,大致位置 from 湿地公约')
results = cur.fetchall()
cur.close()
conn.close()
return results
def findAll():
conn = mysqlConnector.getConn()
cur = conn.cursor()
results = cur.execute('select * from 湿地公约')
results = cur.fetchall()
cur.close()
conn.close()
return results
def findDescription():
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute('select 湿地编码,湿地名称,地理坐标,大致位置,海拔,面积,植物区系,动物区系 from 湿地公约')
results = cur.fetchall()
cur.close()
conn.close()
#print results
return results
def findauthors():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute("select AAID,AU from 6W湿地文献")
results = cur.fetchall()
print results
cur.close()
conn.close()
return results
def getMetadata():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute(
'select Id,Title,Abstract,Keywords_authors,Keywords_Plus,Combined_Keywords_Phrases from 2497文献元数据'
)
results = cur.fetchall()
cur.close()
cur.close()
return results
def add(name, description, wetland_id, wetland_name):
conn = mysqlConnector.getConn()
cur = conn.cursor()
T = (name, description, wetland_id, wetland_name, 'has')
#cur.execute('create table if not exists plantToWetland(id int, name varchar(255),description VARCHAR(255),relationship varchar(10))')
cur.execute(
"insert into plantToWetland(name,description,relationship) values(%s,%s,%s,%d,%s)",
T)
conn.commit()
cur.close()
conn.close()
def getPlantsSciName():
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute('select Scientific_name from 中国植物志')
print count
results = cur.fetchall()
name = []
for r in results:
for n in r:
name.append(n)
cur.close()
conn.close()
return name
def addAnimalRelation(AAID , title, sci_name, w):
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute('select * from literatureToAnimal where AAID=%s and sci_name=%s',(AAID,sci_name))
T=(AAID,title,sci_name,w)
S=(w,title,AAID,sci_name)
if count == 1:
cur.execute('update literatureToAnimal set description=%s where title=%s and AAID=%s and sci_name=%s',S)
elif count == 0:
cur.execute('insert into literatureToAnimal(AAID,title,sci_name,description)values(%s,%s,%s,%s)',T)
cur.close()
conn.commit()
conn.close()
def addRelation(AAID, title, wetland_id, wetland_name,description):
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute('select * from literatureToWetland where AAID=%s and wetland_id=%s',(AAID,wetland_id))
T=(AAID,title,wetland_id,wetland_name,description)
S=(title,wetland_name,description,AAID,wetland_id,)
if count == 1:
cur.execute('update literatureToWetland set title=%s,wetland_name=%s,description=%s where AAID=%s and wetland_id=%s',S)
elif count == 0:
cur.execute('insert into literatureToWetland(AAID,title,wetland_id,wetland_name,description)values(%s,%s,%s,%s,%s)',T)
cur.close()
conn.commit()
conn.close()
def addRelation(geoname, wetland):
conn = mysqlConnector.getConn()
cur = conn.cursor()
T=geoname+wetland
count = cur.execute('select geonameid from geonameToWetland where geonameid=%s and wetland_id=%s',(geoname[0],wetland[0]))
if count == 1:
return
elif count == 0:
cur.execute('insert into geonameToWetland(geonameid,name,asciiname,alternatenames,latitude,longitude,wetland_id,'
'wetland_name,location) values(%s,%s,%s,%s,%s,%s,%s,%s,%s)',T)
conn.commit()
cur.close()
conn.close()
return None
def addSynonymNameToLiterature(sciname, synname, description, AAID, title):
conn = mysqlConnector.getConn()
cur = conn.cursor()
T = (sciname, synname, description, AAID, title)
count = cur.execute(
'select * from literatureToSynname where AAID=%s and sciname=%s',
(AAID, sciname))
if count == 1:
return
elif count == 0:
cur.execute(
'insert into literatureToSynname(sciname,synname,description,AAID,title) values(%s,%s,%s,%s,%s)',
T)
conn.commit()
cur.close()
conn.close()
return None
def addSynonymName(sciname, synname, description, wetland_id, wetland_name):
conn = mysqlConnector.getConn()
cur = conn.cursor()
T = (sciname, synname, description, wetland_id, wetland_name)
count = cur.execute(
'select * from plantSynToWetland where wetland_id=%s and sciname=%s',
(wetland_id, sciname))
if count == 1:
return
elif count == 0:
cur.execute(
'insert into plantSynToWetland(sciname,synname,description,wetland_id,wetland_name) values(%s,%s,%s,%s,%s)',
T)
conn.commit()
cur.close()
conn.close()
return None
def addSynonymNameToMetadata(sciname, synname, description, metadata_id,
title):
conn = mysqlConnector.getConn()
cur = conn.cursor()
T = (sciname, synname, description, metadata_id, title)
count = cur.execute(
'select * from metadataToSynname where metadata_id=%s and sciname=%s',
(metadata_id, sciname))
if count == 1:
return
elif count == 0:
cur.execute(
'insert into metadataToSynname(sciname,synname,description,metadata_id,title) values(%s,%s,%s,%s,%s)',
T)
conn.commit()
cur.close()
conn.close()
return None
def insertIntoExcept(wetland_id, wetland_name, coordinate):
conn = mysqlConnector.getConn()
cur = conn.cursor()
S = (wetland_id, wetland_name, coordinate)
count = cur.execute(
'select * from wetlandGeoFeatures_copy1 where wetland_id=(%s)',
(wetland_id, ))
if count == 1:
T = (coordinate, wetland_id)
cur.execute(
'update wetlandGeoFeatures_copy1 set coordinate=%s where wetland_id=%s',
T)
elif count == 0:
cur.execute(
'insert into wetlandGeoFeatures_copy1(wetland_id,wetland_name,coordinate) values(%s,%s,%s)',
S)
cur.close()
conn.commit()
conn.close()
def geoFeatureAdd(wetland_id, wetland_name, position, altitude, area):
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute(
"select * from wetlandGeoFeatures where wetland_id=(%s)",
(wetland_id, ))
if count == 1:
T = (wetland_name, position, altitude, area, wetland_id)
cur.execute(
"update wetlandGeoFeatures set wetland_name=%s,position=%s,altitude=%s,area=%s where wetland_id=%s",
T)
elif count == 0:
T = (wetland_id, wetland_name, position, altitude, area)
cur.execute(
"insert into wetlandGeoFeatures(wetland_id,wetland_name,position,altitude,area) values(%s,%s,%s,%s,%s)",
T)
cur.close()
conn.commit()
conn.close()
def addPosition(wetland_id, wetland_name, position):
conn = mysqlConnector.getConn()
cur = conn.cursor()
count = cur.execute(
"select * from wetlandGeoFeatures where wetland_id=(%s)",
(wetland_id, ))
if count == 1:
T = (position, wetland_id)
cur.execute(
"update wetlandGeoFeatures set position=%s where wetland_id=(%s)",
(wetland_id, ))
elif count == 0:
T = (wetland_id, wetland_name, position)
cur.execute(
"insert into wetlandGeoFeatures(wetland_id,wetland_name,position)",
T)
cur.close
conn.commit()
conn.close()
def findStandard():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute('select * from wetlandGeoFeatures')
return cur.fetchall()
def getAnimalSciName():
conn = mysqlConnector.getConn()
cur = conn.cursor()
cur.execute('select 序号,动物名称,所属分类,拉丁文名称,英文名称,物种国内分布情况 from 中国湿地动物物种_汇总')
result = cur.fetchall()
return result
