2018_1_15

近来有好几天没有写博客了。一是上班比较忙（早八晚十，周末一休。后期可能不休）。近期工作以来，感悟还是蛮多的，不仅是关于工作还是关于自身的发展。

首先是工作忙，工作虽说时间很长，但是却不怎么累。每天就是拿着手机点点点，导导数据谢谢表格。在工作是经常性的会出现十多分钟的空缺时间。还有就是工作的内容，技术性的内容都被封装了。来这里这么久接触过最含技术性的东西也就是别人写的批处理文件（adb）。总体来说感觉这工作很适合养老，却一点而不适合我这样的应该学习大量知识技术的大好青年。

二是工作我要从一些文件中读取数据填到表格中，我感觉有点麻烦，然后就写了一个python的脚本，自动帮我从文件夹中读取文件自动填表。原本想着这个东西应该很简单，毕竟很多东西我之前看书都学过了。但是当我实际操作时，却出现了一个又一个问题。最后虽然做出来了，但是远远没有达到我想要的结果。

最近也时常关注着这个与python相关的公众号以及一些比较有名的工作号。其中看了一些文章感觉也非常好，特别有感觉。不过这样也有点浪费时间，毕竟自己的技术不行，不管看过多厉害的东西都没啥用。而且代码这东西主要是练出来的，光看也没啥用。

还是好好学习英语数学准备专升本吧。如果能升到本科，感觉很多东西都会不一样了。

最后附上写脚本的一些资料：

import re,openpyxl,time,os
'''
    获取imei号、初始vol、续航总时间
        利用正则表达式与list知识获取这些数据
    获取excel模板
        获取一个系统定义好的模板
    将数据填入excel模板
        将对应的数据填入
    保存文件
        修改文件名字时间
'''

class read_time(object):

    '''
        读取续航时间
        return 一个读取到的时间列表
     '''
    def read_run_time(self):
        with open('apk续航总时间1.txt', mode='r', encoding="UTF-8") as time1:
            str_time1 = time1.readline()
            str_time1 = str_time1[2:-2].replace("小时", ":")
        with open('apk续航总时间2.txt', mode='r', encoding="UTF-8") as time2:
            str_time2 = time2.readline()
            str_time2 = str_time2[2:-2].replace("小时", ":")
        with open('apk续航总时间3.txt', mode='r', encoding="UTF-8") as time3:
            str_time3 = time3.readline()
            str_time3 = str_time3[2:-2].replace("小时", ":")
        with open('apk续航总时间4.txt', mode='r', encoding="UTF-8") as time4:
            str_time4 = time4.readline()
            str_time4 = str_time4[2:-2].replace("小时", ":")
        with open('apk续航总时间5.txt', mode='r', encoding="UTF-8") as time5:
            str_time5 = time5.readline()
            str_time5 = str_time5[2:-2].replace("小时", ":")
        with open('apk续航总时间6.txt', mode='r', encoding="UTF-8") as time6:
            str_time6 = time6.readline()
            str_time6 = str_time6[2:-2].replace("小时", ":")
        with open('apk续航总时间7.txt', mode='r', encoding="UTF-8") as time7:
            str_time7 = time7.readline()
            str_time7 = str_time7[2:-2].replace("小时", ":")
        with open('apk续航总时间8.txt', mode='r', encoding="UTF-8") as time8:
            str_time8 = time8.readline()
            str_time8 = str_time8[2:-2].replace("小时", ":")
        str_run_time = [str_time1, str_time2, str_time3, str_time4, str_time5, str_time6, str_time7, str_time8]
        return str_run_time

    ''' 匹配vol '''
    def compile_regex(self,str):
        run_time_regex = re.compile(r'Voltage: \d\d\d\d')
        mo = run_time_regex.search(str)
        if mo:
            return mo.group()[-4:]
        else:
            return None

    ''' 
        读取imei、vol
        return imei、vlo列表 
    '''
    def read_run_ability(self):
        run_time_regex = re.compile(r'Voltage: \d\d\d\d')
        with open('续航能力测试1.txt', mode='r', encoding="UTF-8") as time1:
            self.str_time1_1 = time1.readline()
            self.str_time1_2 = time1.readline()
            mo = run_time_regex.search(self.str_time1_1)
            self.str_time1_1 = mo.group()[-4:]
            self.str_time1_2 = self.str_time1_2[-5:-1]
        with open('续航能力测试2.txt', mode='r', encoding="UTF-8") as time2:
            self.str_time2_1 = time2.readline()
            self.str_time2_2 = time2.readline()
            mo = run_time_regex.search(self.str_time2_1)
            self.str_time2_1 = mo.group()[-4:]
            self.str_time2_2 = self.str_time2_2[-5:-1]
        with open('续航能力测试3.txt', mode='r', encoding="UTF-8") as time3:
            self.str_time3_1 = time3.readline()
            self.str_time3_2 = time3.readline()
            mo = run_time_regex.search(self.str_time3_1)
            self.str_time3_1 = mo.group()[-4:]
            self.str_time3_2 = self.str_time3_2[-5:-1]
        with open('续航能力测试4.txt', mode='r', encoding="UTF-8") as time4:
            self.str_time4_1 = time4.readline()
            self.str_time4_2 = time4.readline()
            mo = run_time_regex.search(self.str_time4_1)
            self.str_time4_1 = mo.group()[-4:]
            self.str_time4_2 = self.str_time4_2[-5:-1]
        with open('续航能力测试5.txt', mode='r', encoding="UTF-8") as time5:
            self.str_time5_1 = time5.readline()
            self.str_time5_2 = time5.readline()
            mo = run_time_regex.search(self.str_time5_1)
            self.str_time5_1 = mo.group()[-4:]
            self.str_time5_2 = self.str_time5_2[-5:-1]
        with open('续航能力测试6.txt', mode='r', encoding="UTF-8") as time6:
            self.str_time6_1 = time6.readline()
            self.str_time6_2 = time6.readline()
            mo = run_time_regex.search(self.str_time6_1)
            self.str_time6_1 = mo.group()[-4:]
            self.str_time6_2 = self.str_time6_2[-5:-1]
        with open('续航能力测试7.txt', mode='r', encoding="UTF-8") as time7:
            self.str_time7_1 = time7.readline()
            self.str_time7_2 = time7.readline()
            mo = run_time_regex.search(self.str_time7_1)
            self.str_time7_1 = mo.group()[-4:]
            self.str_time7_2 = self.str_time7_2[-5:-1]
        with open('续航能力测试8.txt', mode='r', encoding="UTF-8") as time8:
            self.str_time8_1 = time8.readline()
            self.str_time8_2 = time8.readline()
            mo = run_time_regex.search(self.str_time8_1)
            self.str_time8_1 = mo.group()[-4:]
            self.str_time8_2 = self.str_time8_2[-5:-1]
        str_run_ability1 = [self.str_time1_1, self.str_time2_1, self.str_time3_1, self.str_time4_1, self.str_time5_1,
                            self.str_time6_1, self.str_time7_1, self.str_time8_1]
        str_run_ability2 = [self.str_time1_2, self.str_time2_2, self.str_time3_2, self.str_time4_2, self.str_time5_2,
                            self.str_time6_2, self.str_time7_2, self.str_time8_2]
        return str_run_ability1, str_run_ability2
if __name__ == "__main__":
    s = read_time()
    str_run_time = s.read_run_time()
    str_vol, str_imei = s.read_run_ability()
    project_name = os.getcwd()
    project_name = project_name[-5:]
    wb = openpyxl.load_workbook(r'F:\excel模板\xxxxx PVT  APK续航测试用例报告_V3.2_timetimetime.xlsx')
    sheet = wb.get_sheet_by_name("详细报告")
    sheet['A1'] = project_name + sheet['A1'].value
    sheet['B3'] = str_imei[0]
    sheet['B4'] = str_imei[1]
    sheet['B5'] = str_imei[2]
    sheet['B6'] = str_imei[3]

    sheet['B8'] = str_imei[4]
    sheet['B9'] = str_imei[5]
    sheet['B10'] = str_imei[6]
    sheet['B11'] = str_imei[7]

    sheet['C3'] = str_vol[0]
    sheet['C4'] = str_vol[1]
    sheet['C5'] = str_vol[2]
    sheet['C6'] = str_vol[3]

    sheet['C8'] = str_vol[4]
    sheet['C9'] = str_vol[5]
    sheet['C10'] = str_vol[6]
    sheet['C11'] = str_vol[7]

    sheet['D3'] = str_run_time[0]
    sheet['D4'] = str_run_time[1]
    sheet['D5'] = str_run_time[2]
    sheet['D6'] = str_run_time[3]

    sheet['D8'] = str_run_time[4]
    sheet['D9'] = str_run_time[5]
    sheet['D10'] = str_run_time[6]
    sheet['D11'] = str_run_time[7]

    wb.save(project_name + ' PVT  APK续航测试用例报告_V3.2_'+time.strftime("%Y%m%d",time.localtime())+'.xlsx')