Advertisement
Guest User

Untitled

a guest
Jan 3rd, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. conn = pymysql.connect(user = 'root', password = '', unix_socket = "/tmp/mysql.sock", database = 'abc' )
  2. cursor = conn.cursor()
  3. query2 = """INSERT INTO paragraphVector (termId, termFreq, kgram) VALUES ((SELECT termId FROM term WHERE term = %s AND kgram = %s), %s, %s)"""
  4.  
  5. insertDocVec = [(str(term), str(kgram), tf[kgram][term], str(kgram)) for kgram in tf for term in tf[kgram]]
  6. cursor.executemany(query2, insertDocVec)
  7. conn.commit()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement