import pip._internal as pip_new

return pip.main(['install'] + pkgs)
return pip.main(['uninstall', '-y'] + pkgs)

return pip_new.main(['install'] + pkgs)
return pip_new.main(['uninstall', '-y'] + pkgs)

# -*- coding=utf-8 -*-
import time

import sys

import win32gui

import win32con
from selenium import webdriver

reload(sys)
sys.setdefaultencoding('utf-8')

class ChromeDriver:
    def __init__(self, chrome_driver_path):
        self.chrome_driver = None
        self.chrome_driver_path = chrome_driver_path

    def start(self):
        print "启动chrome"
        # 启动chrome
        self.chrome_driver = webdriver.Chrome(self.chrome_driver_path)

    def stop(self):
        print "关闭chrome"
        # 关闭chrome
        if self.chrome_driver is not None:
            self.chrome_driver.quit()

    def open_web_page(self, url):
        print "打开网页 [%s]" % url
        # 模拟打开网页
        self.chrome_driver.get(url)
        time.sleep(2)

    def search_pic_for_baidu(self, pic_path):
        """
        使用baidu查询图片数据
        :param pic_path:
        :return:
        """
        self.open_web_page("https://www.baidu.com/")

        # 1.打开上传对话框
        self.chrome_driver.find_element_by_class_name("soutu-btn").click()
        time.sleep(1)
        self.chrome_driver.find_element_by_class_name("upload-pic").click()
        time.sleep(2)

        # 2.提交图片
        dialog = win32gui.FindWindow('#32770', u'打开')
        comboBoxEx32 = win32gui.FindWindowEx(dialog, 0, 'ComboBoxEx32', None)
        comboBox = win32gui.FindWindowEx(comboBoxEx32, 0, 'ComboBox', None)

        # 上面三句依次寻找对象，直到找到输入框Edit对象的句柄
        edit = win32gui.FindWindowEx(comboBox, 0, 'Edit', None)

        # 确定按钮Button
        button = win32gui.FindWindowEx(dialog, 0, 'Button', None)
        time.sleep(3)

        # 往输入框输入绝对地址
        win32gui.SendMessage(edit, win32con.WM_SETTEXT, None, pic_path)

        # 按button
        win32gui.SendMessage(dialog, win32con.WM_COMMAND, 1, button)
        time.sleep(1)

    # 使用百度查找内容
    def search_key_for_baidu(self, content, page_count):
        """
        使用baidu查找内容, 最多获取 page_count页
        :param content:
        :param page_count:
        :return:
        """
        self.chrome_driver.find_element_by_id("kw").clear()
        time.sleep(1)

        self.chrome_driver.find_element_by_id("kw").send_keys(content)
        self.chrome_driver.find_element_by_id("su").click()
        time.sleep(3)

        return self._get_key_search_data(page_count)

    # 获取搜索出的内容
    def _get_key_search_data(self, page_count):
        # 打开页数
        if page_count == 0:
            return

        result_list = self.chrome_driver.find_elements_by_class_name("result")
        for d in result_list:
            if d is not None:
                t = d.find_element_by_class_name("t")
                print t.text

        page = self.chrome_driver.find_element_by_id("page")
        if page is not None:
            _as = page.find_elements_by_tag_name("a")
            if len(_as) > 0:
                _next_url = _as[-1].get_attribute("href")
                page_count -= 1
                self.open_web_page(_next_url)
        else:
            page_count = 0

        # 递归调用
        self._get_key_search_data(page_count)


if __name__ == '__main__':
    driver_path = "chrome_driver路径"
    cd = ChromeDriver(driver_path)
    cd.start()

    # 使用baidu搜索关键词
    cd.open_web_page("https://www.baidu.com/")
    cd.search_key_for_baidu("python", 2)

    # 使用baidu搜索图片
    cd.search_pic_for_baidu("图片路径")

    # 休眠
    time.sleep(10)

    cd.stop()

# coding=utf8

import xlwt
import xlrd


class ExcelWrite:
    def __init__(self):
        # 创建workbook和sheet对象
        self.workbook = xlwt.Workbook()

        # 构建一个sheet页  (cell_overwrite_ok: true->单元格内容被覆盖)
        self.sheet = self.workbook.add_sheet(u"Sheet名字", cell_overwrite_ok=True)

        # 写入自定义的标题内容
        self._write_title()

    # 保存文件
    def save(self, file_name):
        self.workbook.save(file_name)

    # 写入内容
    def write_text(self, row_data_list):
        """
        写入数据
        :param row_data_list: 准备写入excel文件的数据(定义了一个二维数组结构)
        :return:
        """
        # 从第2行开始, 第一行为标题行
        for i in range(0, len(row_data_list)):
            self._write_row_text(i+1, row_data_list[i])

    # 写入行内容
    def _write_row_text(self, row_index, col_data_list):
        """
        写数据到指定行中
        :param list_data: 对应行中每一列的数据
        :return:
        """
        for i in range(0, len(col_data_list)):
            self.sheet.write(row_index, i, col_data_list[i])

    # 写入标题
    def _write_title(self):
        title_list = [u"列1", u"列2", u"列3"]
        for i in range(0, len(title_list)):
            self.sheet.write(0, i, title_list[i])


class ExcelRead:
    def __init__(self):
        pass

    def read_excel(self, file_name):
        # 打开excel文件
        data = xlrd.open_workbook(file_name)

        # 获取sheet标签
        table = data.sheet_by_name("Sheet名字")

        # sheet标签中的行数
        rows = table.nrows
        # sheet标签中的列数
        cols = table.ncols

        # 获取每行的数据
        for i in range(0, rows):
            print(table.row_values(i))

        # 获取每列的数据
        for x in range(0, cols):
            print(table.col_values(x))
        #
        # # 逐个获取单元格数据
        for i in range(0, rows):
            for j in range(cols):
                print(table.cell(i, j).value)


if __name__ == '__main__':
    eo = ExcelWrite()

    col_list = ["aaa", "bbb", "ccc"]
    col_list1 = ["aaa111", "bbb111", "ccc111"]
    col_list2 = ["aaa222", "bbb222", "ccc222"]

    data_list = list()
    data_list.append(col_list)
    data_list.append(col_list1)
    data_list.append(col_list2)

    # 写入数据
    eo.write_text(data_list)
    # 保存文件
    eo.save("111.xls")

    # 读取文件
    er = ExcelRead()
    er.read_excel("111.xls")

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header

import logging


class EMailOpr:
    def __init__(self):
        self.sender = '发送者邮箱'
        self.receivers = ['接受者邮箱1', "接受者邮箱2"]
        self.cc = ['抄送1', '抄送2']
        self.hide = ["暗抄1", "暗抄2"]
        self.smtp = 'smtp.****.com'
        self.smtp_port = 25
        self.user = "发送者账号"
        self.passwd = "发送者密码"

    # 发送邮件
    def send(self, subject, content="", att_path=""):
        """
        发送邮件
        :param subject: 邮件主题
        :param content: 邮件内容
        :param att_path: 邮件附件地址
        :return:
        """
        # 创建一个带附件的实例
        message = MIMEMultipart()
        message['From'] = self.sender
        message['To'] = ",".join(self.receivers)
        message['Cc'] = ",".join(self.cc)
        message['Subject'] = Header(subject, 'utf-8')

        # 邮件正文内容
        message.attach(MIMEText(content, 'plain', 'utf-8'))

        # 添加附件
        if att_path != "":
            # 构造附件1
            att1 = MIMEText(open(att_path, 'rb').read(), 'base64', 'utf-8')
            att1["Content-Type"] = 'application/octet-stream'
            # 这里的filename可以任意写，写什么名字，邮件中显示什么名字
            att1["Content-Disposition"] = 'attachment; filename=%s' % att_path[att_path.rfind("/")+1:]
            message.attach(att1)

        try:
            smtpObj = smtplib.SMTP()
            smtpObj.connect(self.smtp, self.smtp_port)
            smtpObj.login(self.user, self.passwd)
            smtpObj.sendmail(self.sender, self.receivers+self.cc+self.hide, message.as_string())
            print u"邮件发送成功"
        except smtplib.SMTPException:
            print u"Error: 无法发送邮件"

if __name__ == '__main__':
    file_name = "附件文件路径"
    email = EMailOpr()
    email.send("主题", "内容", file_name)