Python table_SQL Examples

Example #1

File: CRF_SQL_insert.py Project: hvdthong/Transportation_NEC

def load_data_ID(command):
    if command == 'twitter':
        sql = 'select tweetID from tweet_2015 order by tweetID;'
    elif command == 'sgforums':
        sql = 'select id_str from sgforums_2015 order by post_id;'
    elif command == 'facebook':
        sql = 'select facebookID from facebook_2015 order by facebookID;'

    list_id = table_SQL(sql)
    return list_id

Example #2

File: mult_process.py Project: hvdthong/Transportation_NEC

    #
    # print len(list_line_)
    # running_road(command='twitter')
    # running_bussstop(command='twitter')

    #######################################################################################
    #######################################################################################
    # SGFORUMS
    # sql = load_sql(command='sgforums')
    # list_row = table_SQL(sql)
    # list_line = filtering_text_demo(list_row, 'sgforums')
    # list_line_ = list_line
    # path_write = 'D:/Project/Transportation_SMU-NEC_collaboration/Data_demo_Dec_2015/sgforums/crf_features'
    #
    # print len(list_line_)
    # running_road(command='sgforums')
    # running_bussstop(command='sgforums')

    #######################################################################################
    #######################################################################################
    # FACEBOOK
    sql = load_sql(command='facebook')
    list_row = table_SQL(sql)
    list_line = filtering_text_demo(list_row, 'facebook')
    list_line_ = list_line
    path_write = 'D:/Project/Transportation_SMU-NEC_collaboration/Data_demo_Dec_2015/facebook/crf_features'

    print len(list_line_)
    # running_road(command='facebook')
    running_bussstop(command='facebook')

Example #3

File: CRF_model_pred.py Project: hvdthong/Transportation_NEC

def load_demo_text(command):
    sql = load_sql(command)
    list_row = table_SQL(sql)
    return list_row