1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| import requests
import sys, sqlite3
import os, time
x =requests.get('http://sslproxies.org')
files ="source.txt"
open(files,"w").write(x.text)
name_ =time.strftime("%A_%Y_%H:%M")
dbname ="ips/{}".format(name_)
conn =sqlite3.connect(dbname)
cur =conn.cursor()
print(name_)
try:
cur.execute("CREATE TABLE IP('{}' TEXT)".format(name_))
except:
pass
obj_fichier = open('source.txt', 'r')
begin_balise = '<td>'
end_balise = '</td>'
while True:
ligne = obj_fichier.readline()
pos_begin = ligne.find(begin_balise)
pos_end = ligne.find(end_balise)
if pos_begin != -1:
l = len(begin_balise)
extract = ligne[pos_begin + l:pos_end]
print(extract)
cur.execute("INSERT INTO IP('{}') VALUES('{}')".format(name_, extract))
conn.commit
obj_fichier.close() |
Partager