Skip to content

Instantly share code, notes, and snippets.

@lamorbidamacchina
Created November 19, 2019 16:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lamorbidamacchina/765d80bf350d2f915e4786aa2887811b to your computer and use it in GitHub Desktop.
Save lamorbidamacchina/765d80bf350d2f915e4786aa2887811b to your computer and use it in GitHub Desktop.
# write to db
cursor = db.cursor()
sql = "INSERT INTO scrapes (name, screen_name, profile_image_url, description, statuses_count, friends_count, followers_count, account_age_days, average_tweets, most_mentioned_users, most_used_hashtags,processed_tweets, creation_date, creation_day) VALUES (%s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
try:
cursor.execute(sql,(user_name, screen_name, profile_image_url, description, statuses_count, friends_count, followers_count, account_age_days, average_tweets, most_mentioned_users, most_used_hashtags, processed_tweets, creation_date, creation_day))
db.commit()
except:
print(cursor._last_executed)
raise
db.rollback()
print(screen_name + " processed successfully.")
db.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment