def del_ip(self, record):
'''delete ip that can not use'''
sql = "delete from proxy where IP='%s' and PORT='%s'" % (record[0],
record[1])
print sql
exec_sql(sql, **kwargs)
print record, " was deleted."
def create_table(dta, primary, tabel, **kwargs):
sql = 'create table if not exits ....'
ps = ['...' for x in data] + ([primary, ] if primary else [])
paras = ', '.join(ps)
SQL = sql % (table, paras)
exec_sql(SQL, **kwargs)
def insert_data(data_, tabel, **kwargs):
''' insert data into database '''
insertSQL = 'insert into ' + table + '...'
keys = data_.keys()
fields = ''.join(['...' %k for k in keys])
sql = insertSQL % (fields, qm)
data = [data_[k] for k in keys]
exec_sql(sql, data, **kwargs)
def __init__(self):
sql='''SELECT `IP`,`PORT`,`TYPE`
FROM `proxy`
WHERE `TYPE` REGEXP 'HTTP|HTTPS'
AND `SPEED`<5 OR `SPEED` IS NULL
ORDER BY `proxy`.`TYPE` ASC
LIMIT 50 '''
self.result = exec_sql(sql,**kwargs)
def del_ip(self,record):
'''delete ip that can not use'''
sql="delete from proxy where IP='%s' and PORT='%s'"%(record[0],record[1])
print sql
exec_sql(sql,**kwargs)
print record ," was deleted."
