def add_new_record_to_db(tweet, sentiment, img_hash, proc_txt): timestamp = prt.convert_twitter_date_to_datetime(tweet['created_at']) connection = mysql.connect() with connection.cursor() as cursor: sql = 'INSERT INTO Original_tweets (' \ 'tweet_id, username, text, processed_text, image_url, ' \ 'tweet_sentiment, unclear_sentiment, created_ts, image_hash) ' \ 'VALUES (%s, %s, %s, %s, %s, %s, 0, %s, %s)' cursor.execute(sql, (int(tweet['id']), tweet['user']['screen_name'], tweet['text'], proc_txt, tweet['extended_entities']['media'][0]['media_url'], sentiment, timestamp, img_hash)) connection.commit() connection.close()
def write_response_to_mysql(tweet): """ Saves tweet data to SQL :param tweet: dictionary :return: nothing """ connection = mysql_connection() try: with connection.cursor() as cursor: id = tweet['id'] tweet_txt = tweet['text'] timestamp = prt.convert_twitter_date_to_datetime(tweet['created_at']) username = tweet['user']['screen_name'] sql = "INSERT INTO Reply_tweets (tweet_id, username, text, created_ts) VALUES (%s, %s, %s, %s, %s)" cursor.execute(sql, (id, username, tweet_txt, timestamp)) except: pass connection.close()
def add_dupe_to_db(dupe_tweet, match_id, dupe_sentiment, img_hash, proc_txt): timestamp = prt.convert_twitter_date_to_datetime(dupe_tweet['created_at']) connection = mysql.connect() with connection.cursor() as cursor: sql = 'INSERT INTO Duplicate_images ( ' \ 'tweet_id, primary_tweet, username, text, processed_text, ' \ 'image_url, tweet_sentiment, created_ts, image_hash, ' \ 'unclear_sentiment) ' \ 'VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, 0)' cursor.execute(sql, (int(dupe_tweet['id']), int(match_id), dupe_tweet['user']['screen_name'], dupe_tweet['text'], proc_txt, dupe_tweet['extended_entities']['media'][0]['media_url'], dupe_sentiment, timestamp, img_hash)) connection.commit() connection.close()