/
mysqlqueries.py
106 lines (99 loc) · 5.37 KB
/
mysqlqueries.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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
# coding: utf-8
def submittedarticlesofauthor(author):
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE status = 'submitted' AND author = \'"+str(author)+"\'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status, newsness, most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr
def allarticlesofauthor(author):
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE author = \'"+str(author)+"\'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status, newsness, most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr
def publishedarticlesofauthor(author):
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE status = 'approved' AND author = \'"+str(author)+"\'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status, newsness, most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr
def rejectedarticlesofauthor(author):
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE status = 'rejected' AND author = \'"+str(author)+"\'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status, newsness, most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr
def draftarticlesofauthor(author):
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE status = 'draft' AND author = \'"+str(author)+"\'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status, newsness, most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr
def allsubmittedarticles():
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE status = 'submitted'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status, newsness, most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr
def articlebyid(aid):
import mysql.connector
cnx = mysql.connector.connect(host='192.168.137.1',port='3306',database='newsness',user='root',password='pratik')
print cnx
curA = cnx.cursor(buffered=True)
curB = cnx.cursor(buffered=True)
query = (" SELECT * FROM articles WHERE aid = \'"+str(aid)+"\'")
curA.execute(query)
article_arr = []
for (aid,author,title,sdate,description,text,status,newsness,most_rel) in curA:
print aid,author,title,sdate,description,text,status, newsness, most_rel
a = {"aid":aid,"author":author,"title":title,"sdate":sdate,"description":description,"text":text,"status":status, "newsness":newsness, "most_rel":most_rel}
article_arr.append(a)
return article_arr