Python tweet_to_insert_stringの例

コード例 #1

ファイル: scrape_pgh311.py プロジェクト: defi-ventures/scrape_social_media_in_area

 def save_to_postgres(self, tweet):
     insert_str = utils.tweet_to_insert_string(tweet, self.psql_table, self.psql_cursor)
     try:
         self.psql_cursor.execute(insert_str)
         self.psql_connection.commit()
    
     except Exception as e:
         print "Error running this command: %s" % insert_str
         traceback.print_exc()
         traceback.print_stack()
         self.psql_connection.rollback() # just ignore the error

コード例 #2

ファイル: pull_historic_user.py プロジェクト: CMUChimpsLab/geotweetstreamer

def save_to_postgres(tweet, table, connection, cursor):
    if 'coordinates' not in tweet or tweet['coordinates'] == None or 'coordinates' not in tweet['coordinates']:
        tweet['coordinates'] = {'coordinates': [-999, -999]}
    insert_str = utils.tweet_to_insert_string(tweet, table, cursor)
    try:
        cursor.execute(insert_str)
        connection.commit()
   
    except Exception as e:
        print "Error running this command: %s" % insert_str
        traceback.print_exc()
        traceback.print_stack()
        connection.rollback() # just ignore the error

コード例 #3

ファイル: pull_historic_user.py プロジェクト: defi-ventures/scrape_social_media_in_area

def save_to_postgres(tweet, table, connection, cursor):
    if 'coordinates' not in tweet or tweet[
            'coordinates'] == None or 'coordinates' not in tweet['coordinates']:
        tweet['coordinates'] = {'coordinates': [-999, -999]}
    insert_str = utils.tweet_to_insert_string(tweet, table, cursor)
    try:
        cursor.execute(insert_str)
        connection.commit()

    except Exception as e:
        print "Error running this command: %s" % insert_str
        traceback.print_exc()
        traceback.print_stack()
        connection.rollback()  # just ignore the error