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()
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()