craw_ptt.py 文件源码

def creat_sql_file(sql_string,dataset_name):

    conn = ( pymysql.connect(host = '114.34.138.146',# SQL IP
                             port = 3306,
                             user = user,# ??
                             password = password,# ??
                             database = database,  # ?????
                             charset="utf8") )   #  ??           
    c=conn.cursor()
    c.execute( sql_string )# ???? SQL file
    c.execute('ALTER TABLE `'+dataset_name+'` ADD id BIGINT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY;')
    c.close() # ??? SQL ???
    conn.close()# ??? SQL ???
#---------------------------------------------------------------------------------    
# ? ptt ??