动态ip

# -*- coding: utf-8 -*-
"""
Created on Mon Nov  9 16:16:23 2020

@author: Administrator
"""

import pymysql
import pandas as pd
from sqlalchemy import create_engine
import warnings
import ssl

ssl._create_default_https_context = ssl._create_unverified_context
warnings.filterwarnings("ignore")

class pdsql():
    def __init__(self, dbname):
        self.dbname = dbname
        connect_info = 'mysql+pymysql://wangpengju:123456@192.168.102.216:3306/{}?charset=utf8'.format(self.dbname)
        self.engine = create_engine(connect_info).connect()

    def to_sql(self, data: pd.DataFrame, tablename, dtype, method='append'):
        self.data = data
        self.data.to_sql(tablename,
                         con=self.engine,
                         if_exists=method,
                         index=False,
                         chunksize=10,
                         dtype=dtype)

    def read(self, sql):
        self.df = pd.read_sql(sql, con=self.engine)
        return self.df

    def close(self):
        self.engine.close()

class ipPool():
    def __init__(self):
        pass

    def freeIp(self):
        pass

    @staticmethod
    def getIp():
        sql = pdsql('ip')
        iplist = sql.read('select * from ip;')
        iplist = iplist['ip'].tolist()
        sql.close()
        return iplist

"""
需要安装mysql，ip.getIp()一次可以获得300条ip
"""
ip=ipPool()
ip.getIp()