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."