def flushNum(): session = conn(PROXYDB) global PROXY_NUM if PROXY_NUM == '-1': proxy_num = session.query(Proxy).count() PROXY_NUM = proxy_num return PROXY_NUM
def add_proxys(list): """ 添加proxy 到sqlite数据库 :param list: 代理列表 :return: """ session = conn(PROXYDB) for p in list: type = "socks5" try: proxy = Proxy(type=type, ip_port=p, failnum=0) session.add(proxy) session.commit() except Exception, e: print e pass
def autoproxy(): session = conn(PROXYDB) print session.query(Proxy).count()