def start():
Database = cpssdb.cpssdb()
cursor = Database.cursor()
cursor.execute("""SELECT prop.proposalid, prop.carmaid, prop.user
FROM proposals as prop
WHERE prop.user NOT IN(SELECT email FROM users)
ORDER BY prop.carmaid""")
while (1):
result = cursor.fetchone()
if (result != None):
print result
else:
break
cursor.close()
#ddt
cursor = Database.cursor()
cursor.execute("""SELECT prop.proposalid, prop.carmaid, prop.user
FROM ddt_proposals as prop
WHERE prop.user NOT IN(SELECT email FROM users)
ORDER BY prop.carmaid""")
while (1):
result = cursor.fetchone()
if (result != None):
print result
else:
break
cursor.close()
#summerschool
cursor = Database.cursor()
cursor.execute("""SELECT prop.proposalid, prop.carmaid, prop.user
FROM cs_proposals as prop
WHERE prop.user NOT IN(SELECT email FROM users)
ORDER BY prop.carmaid""")
while (1):
result = cursor.fetchone()
if (result != None):
print result
else:
break
cursor.close()
Database.close()
def start():
Database = cpssdb.cpssdb()
#main
cursor = Database.dictcursor()
cursor.execute("""SELECT * FROM `images`WHERE `images`.`proposalid` NOT IN (SELECT `proposalid` FROM `proposals`) """)
while (1):
result = cursor.fetchone()
if (result != None):
print "%s.%s.gz" % (result['proposalid'], result['numb'])
else:
break
cursor.close()
Database.close()
def start(carmaid):
Database = cpssdb.cpssdb()
cursor = Database.cursor()
sql = ("""SELECT *
FROM (SELECT * FROM `proposals` UNION
SELECT * FROM `cs_proposals` UNION
SELECT * FROM `ddt_proposals`) AS t1, `users`
WHERE t1.carmaid='%s' AND
`t1`.`user`=`users`.`email`""" % carmaid)
cursor.execute(sql)
while (1):
result = cursor.fetchone()
if (result != None):
print result
else:
break
cursor.close()
Database.close()
def start(emails):
string = "IN('" + "', '".join(emails) + "')"
Database = cpssdb.cpssdb()
#main
cursor = Database.cursor()
cursor.execute("""SELECT *
FROM (SELECT * FROM `proposals` UNION
SELECT * FROM `cs_proposals` UNION
SELECT * FROM `ddt_proposals`) AS t1
WHERE `t1`.`user` %s
ORDER BY `t1`.`carmaid`""" % string)
while (1):
result = cursor.fetchone()
if (result != None):
print result
else:
break
cursor.close()
Database.close()
def start():
Database = cpssdb.cpssdb()
cursor = Database.dictcursor()
cursor.execute("""SELECT `proposalid` FROM `proposals`""")
just = []
while (1):
result = cursor.fetchone()
if (result != None):
just.append(result['proposalid'])
else:
break
justfiles = os.listdir('/home/carmaweb/cpss-data/justifications/')
for i in xrange(len(justfiles)):
justfiles[i] = int(justfiles[i][:-4])
for i in justfiles:
if i not in just:
print str(i) + '.pdf'
cursor.close()
Database.close()
