def main():
conn = gc.connection()
cursor = conn.cursor()
os.chdir("/home/christopher/popdoxa/PopDoxa/data")
rebuild(cursor)
conn.commit()
def main():
conn = gc.connection()
cursor = conn.cursor()
os.chdir("/home/christopher/popdoxa/PopDoxa/data")
rebuild(cursor)
conn.commit()
def main(users):
conn = gc.connection()
try:
print "Creating users..."
gu.start(conn, users)
print "Creating posts..."
gp.start(conn, users * 2)
print "Creating replies..."
gr.start(conn, users * 3)
print "Creating user opinions..."
guo.start(users)
print "Creating poll replies..."
gpr2.start(conn, users * .5)
print "Creating poll results..."
gpr.start(conn)
except Exception as e:
print e
conn.commit()
def main(users): conn = gc.connection() try: print "Creating users..." gu.start(conn, users) print "Creating posts..." gp.start(conn, users * 2) print "Creating replies..." gr.start(conn, users * 3) print "Creating user opinions..." guo.start(users) print "Creating poll replies..." gpr2.start(conn, users * .5) print "Creating poll results..." gpr.start(conn) except Exception as e: print e conn.commit()
import os, sys, json
import get_connection as gc
conn = gc.connection()
cursor = conn.cursor()
def get_titles_and_questions(keyword):
stmt = "SELECT id, title from posts;"
to_return = {}
cursor.execute(stmt)
if not cursor.rowcount:
return
for row in cursor:
if keyword in row[1]:
to_return[row[0]] = str(row[1])
print json.dumps(to_return)
def main():
if len(sys.argv) < 2:
return
get_titles_and_questions(sys.argv[1])
main()
