Python conn Examples

Example #1

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

Example #2

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

Example #3

def autoproxy():

    session = conn(PROXYDB)
    print session.query(Proxy).count()