截止目前枢析,應該已經(jīng)成功獲取到了真實的地址
為了避免多次調(diào)用接口契邀,將地址存入數(shù)據(jù)庫
(以前沒寫過python徐鹤,所以語法啥的不太好看可能听绳,能用就行O(∩_∩)O哈哈~)
寫python的時候if一定要注意開頭的空格颂碘!
db = MySQLdb.connect("localhost", "root", "root", "yingshi", charset='utf8' )
cursor = db.cursor()
sql_query = "select * from source where url =\'%s\' and domain =\'%s\' and source = \'%s\'" % (url,domain,source)
count=cursor.execute(sql_query)
count=int(count)
if count == 0:
#更新
#result = cursor.fetchone()
#sql_update="update source set url=\'%s\' , domain =\'%s\' , source = \'%s\'" % (url,domain,source) %"where id = %s " % result[0]
#增加
sql = "INSERT INTO SOURCE(URL, DOMAIN, SOURCE) VALUES (\'%s\', \'%s\', \'%s\')" % (url,domain,source)
cursor.execute(sql)