python + mysql + 크롤링

from bs4 import BeautifulSoup
import requests
import pymysql
def main():
    Label_list = ["Data", "Domain", "IP", "CC", "ASN", "Autom_system_name", "Virus_Total_MD5"]
    for i in range(1, 11):
        params = {
           'page':i
        }
        http_ = requests.get(url="http://malc0de.com/database/", params=params).text
        soup = BeautifulSoup(http_, 'html.parser')
        s = soup.select(' .class1')

        for i in s:
            n = 0
            element_list = list()
            conn = pymysql.connect(
                host   = "localhost",
                user   = "root",
                passwd = "1234",
                db     = "malware",
                charset= "utf8"
            )
            curs = conn.cursor() # 객체 생성
            for x in i.find_all(name='td'):
                print (Label_list[n],":", x.string)
                n = (n+1)%len(Label_list)
                element_list.append(x.string)
                if len(element_list) == 7:
                    sql = """insert into hash(Data, Domain, IP, CC, ASN, Autom_system_name, Virus_Total_MD5) 
                    values(%s, %s, %s, %s, %s, %s, %s)"""
                    curs.execute(sql, (element_list[0],element_list[1],element_list[2],
                                       element_list[3],element_list[4],element_list[5],
                                       element_list[6]))
                    element_list.clear()
                    conn.commit()
            conn.close()
            print ("=============================")
        #print (soup)
        # L = soup.find_all(name='a')
        # for i in L:
        #     #print (i.attrs['href'])
        #     if "https" in i.attrs['href']:
        #         print (i.string)
if __name__ == "__main__":
    main()