-
Notifications
You must be signed in to change notification settings - Fork 10
/
ExtractContentFromAsthmaPapers.py
30 lines (25 loc) · 1.27 KB
/
ExtractContentFromAsthmaPapers.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
from QueryDBClass import QueryDBCalss
queryclass = QueryDBCalss("localhost","root","","table_db", )
cursor = queryclass.db.cursor()
#Get tables
sql = """SELECT Content FROM table_db.article inner join arttable on arttable.Article_idArticle=article.idArticle inner
join cell on arttable.idTable=cell.Table_idTable where Title like '%asthma%' or Title like '%Asthma%' or Abstract like
'%asthma%' or Abstract like '%Asthma%';"""
cursor.execute(sql)
results = cursor.fetchall()
file = open("content_asthma.txt","w")
for res in results:
file.write(res[0].encode('utf-8')+'\n')
file.close()
print "Done Asthma"
sql = """SELECT Content FROM table_db.article inner join arttable on arttable.Article_idArticle=article.idArticle inner
join cell on arttable.idTable=cell.Table_idTable where Title like '%COPD%' or Title like '%copd%' or Abstract like
'%COPD%' or Abstract like '%copd%' or Title like '%chronic obstructive pulmonary disease%' or Title like '%Chronic obstructive pulmonary disease%' or
Abstract like '%Chronic obstructive pulmonary disease%' or Abstract like "%chronic obstructive pulmonary disease%";"""
cursor.execute(sql)
results = cursor.fetchall()
file = open("content_copd.txt","w")
for res in results:
file.write(res[0].encode('utf-8')+'\n')
file.close()
print "Done COPD"