craw_ptt.py 文件源码

 复制代码def catch_ptt_history_date_time(ptt_class_name,sql_name):
    conn = ( pymysql.connect(host = '114.34.138.146',
                             port = 3306,
                             user = user,
                             password = password,
                             database = database,  
                             charset="utf8") )
    cursor = conn.cursor()
    cursor.execute('SELECT * FROM `'+ sql_name +'` ORDER BY id DESC LIMIT 1;')
    data = cursor.fetchone()     

    date_time  = date_to_numeric( data[1] )

    cursor.close()
    conn.close()    

    return date_time  
#---------------------------------------------------------------------------------            
# ?????? index, index ???????, ????????? index