python自动化测试学习笔记-9测试框架

时间:2022-10-10 18:26:59

学习了这么久的python,我们已经可以自己搭建一个简单的测试和框架了,先从简单的开始,有时我们编写接口的测试用例会用excel进行编写,以下面的接口测试用例模板为例,进行编写;

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA60AAABlCAIAAAAplJLMAAAgAElEQVR4nO1d3aotRZJer+Jr1LX0PMhASV/3fV8Ozl1dzjzBCKdBWqREBBGcg4MIIux9RKvpRqWlUcRHqLmoqsyIyMifqpWRP3vFh8g+tWplfRkZGfllZK6s26pQKBQKhUKhUDwebrUJKBQKhUKhUCgUFaA6WKFQKBQKhULxiFAdrFAoFAqFQqF4RKgOVigUCoVCoVA8IlQHKxQKhUKhUCgeEaqDFQqFQqFQKBSPiF0H//7773V53AnlXxfKvy565//NN9/8oHh4fPPNN7U98S703g17598p+jV7v8whfv/9910H//bbb3Wp3AnlXxfKvy565//111/X1mCK+vj6669re+Jd6L0b9s6/U/Rr9n6ZQ/z222+7Dv7111/rUrkTyr8ulH9d9M7/q6++qq3BFPXx1Vdf1fbEu9B7N+ydf6fo1+z9Mof49ddfdx38yy+/CD7n9btvv/3Oez8KPkGE/4/vvfM2gVQtBO0Pa/Hua6GHlLG/nA+V8h+pNpDyH64KEhX48ssva2uwevj6v/7tT394y/z3H//1v7UZ1cKXX36Z37d+fO8d4rPulUyQHUbFaBvI8peGvH2EkN/svM/nt46wbinUmr/88suug//1r3+JPeXH9955+9133xWtlAh/tyVevyukY6TsjwjLdIV1XQvZX3A6Vch/xCDlP6Wq8MUXX9TWYJXw6Z/f+tMf/u0v/7f/c9PEjyqFv/jii/y+VVAHSw6jJTqjLH9pdKuD85udmOLH996RGTkFHabs6Lnr4J9//lnqIVt9hGslwp/h/PpdGX+Ssb8j28X6QyH7i81DSvmPFKT6b6kqvH79urYGq4K//vGBVa+L168FfK2gDhYcRtcSnVGWvzS61cH5zY5MISVa1gK6Uap0hJ9//nnXwf/85z+FnmGqI9gaQvxZHSbTNCL8xVSji0L2F3OiUvylINV/S1Xh888/r63BaoAkgx8en3/+eX7fKqiD5YbRdS3RGWX5S6NbHZzf7NYUsiJA0GHKjp67Dv7pp59kHgGEi6QQFuHPbY4UqoEIf9GZB4aY/UlPkOocxfxHqGtL9V+3CjL8P/vss9oarAL+9y///taf/vDHT2vzaAafffZZft8quE1fbBhd17WEMpDlL41udXB+s++mENwJuUHQYQq25k8//bTr4B9++EHkCUiKCU5NRPjziQQRaSnCv6AOLmR/sc5Rir8UpPpvqSp8+ukjikGsg//vP//D/Fru3//zIc+R+/TTT/P7VsF88A9C3XCDfGeU5S+NbnVwfrP/+N47b7/zzjtvv/3ue1KSZV1XUYcpO3ruOvgf//iHQPmlfm0uxJ9flxepgQj/gvsiCtpfpFOX4i8Fmf5brgqffPJJVQFWCdy+iP/578fVwZ988kl+3yqog6W64Qb5zijLXxrd6uD8ZoeJYLHk3SrqMGVHz10H//3vf89ffMF8aiH+YjpMhD8jhKWkcSH7iyn7Uv4jBRn/KVeFjz/+uLYGqwLmd3KPrIM//vjj/L5VUAdLdcMN8p1Rlr8EoE261cH5zY5NIbc9QtBhyo6euw7+29/+lr10VrQICUkJ/m5LyM2sRPjvHcAwxv/KiiL2Fzw3rYz/yEHIf4pV4aOPPqqtwSrh0z+/9ac/vPXff93+te2UeFgd/NFHH+X3rYI6WKobbpDvjLL8RWBVhmTeUxb5zU5dRUoJCzpM2dFz18Hff/997sI9ilcmpSfAn93WIdUwIvw3vH5Xnn4h+8t1i1L+I1ULKf8pFYw+/PDD2hqsIv76R/gejQf+5dyHH36Y37cK6mDBML6W6Iyy/IVgB7guk8GrhNk979HIbiFBhyn4Fq3vv/9+18Hfffed0DPKQPnXhfKvi975f/DBB7U1mKI+Pvjgg9qeeBd674a98+8U/Zq9X+YQ33333a6Dv/3227pU7oTyrwvlXxe983///fdrazBFfbz//vu1PfEu9N4Ne+ffKfo1e7/MIb799ttdBz8/P9elcieUf10o/7ronf9beGOA/vew/9X2xLvQezfsnX+n6Nfs/TKHeH5+vr158+b5+fmVQqFQVEJ1+aX/NfJfbU9UKBQPhz0f/OrVq7qS/E48PT3VpnAXlH9dKP+66J2/Igt6dwPlr7iAfs3eL3OIp6cn1cFNQPnXhfKvi975K7KgdzdQ/ooL6Nfs/TKHiOrgebwxGKYl8OntdrvdxrlYJdZ1pe0xj4DAMg3bP5ZpOJgzt63rOo/484JA/AN2xbZ1aoTKKNkGgvzRTfYf6DJX2+2GZRpSDAH4c14Qt+buZYmPy45C/M9Ub+MxjzZeBCDF/+j8ewGH03DlHc8NxzyFJIwb4EYYpolrlGFaQHi3rYq+bBrO9V3eC5IiV4y/QDc0X2YpcuXO49mBGPH3fXmZBvvISKwHZZTg3yms2Q+vOWzsMSJweohlGoZpGlGwknV7SeaEn+8j8kCA5JjN6GBkEFgJplCfbiyswdbVo4O9FtrZNayDvVoRfTaPt3GmQ8YC7+OFS8CrGuNPC/DoYE5Smysp4o3h7w8NnO2OAWxZzkXvTMK5GP9lGhJ9x/SmwGynAP/t6fN4GyfoO1ynOHSwU35KDRQZ4KaXSP8gIZvzkXG2LQgajhmUPIKAxKfQ3UH+mbsh1JGEiJfa2eiC7X98m46jpAUCD4CfluDfKYDZ9xrDCGX8yPx/9cRhZpov7PaCzKOcyVfTLvtqweaD6VM9Zbaugzck5IOZWFW4Ald0JPjEHdiDbdCGDk7kv98WnfbRMk6JFzIAU892rOlnc9KHJHRwPv5pt42xnFDcGuX472sE6DbY/z21UR1cAmRYHYbBGYioG7H5YEcHo/lzyD+z5YPXNZ8bQ1LDNDGlhCNksiPzy9yhSJqkg4vx7xRUvQzTPA1GU7JqcuXkl9NQ4m4vxnylH1fVwaz1oNy/YDoR8Atq7Jh2zDtcsjCDVVkHh2D1IZCAps1t6KmpgzPxByXRuQzv5/5YGm5QbgDwlcWa7qrLyOhgU3Q2/udToqdmw6L8t4LMx/ZWsrfGyQcfn2s+uBD4fOS6cjGFHeBHZ61+V1hmzwtoSOF8MKhFDjd28qmgYFQWRzQxPF3XwbSWxt7+fLAA/04B1AtSIGE1uX2B9a2tKxRweyHm9DFzYHedzL4IXHe3B4RlvXtPITg6zL8E499V2pAOjudT59G0NPCEccY6mB1KxrGBfHAaf7cADnvNYJst03Amd3DwP6gEvB49FYqrG+NZ0P7m72UahnEcjliVUwfn5h8uIYhTnUiO/zze7IR4nNd1ngZ2f0RABysKgbqBExYOoPlwLB/szKZXfP+Kr/mRrIMlumFgX4FTIpNuS+qLXh3sFRlA1DK714I6WIB/p4C7bG/HuO1Xk3t7uKEJx6sSbi/DnGJjJxeK03WwccQOdPCmsIZh5DdneUd7NrYWwlkduUupI7cNslY+HWzD7UmJWJX/XsAw3MaJn/ex+/+s0kysJ+K/7Jv2vYBCCa2cmEX3cV6WBd2AdTDKiufOB2fkD4oMRUguWzdf3peSj79x+s07js/2wMUNG3S/OvNQhRicfPDWoDYsrE7TsflgZ18EzInxDby7csZ8cOZuuNMO/WbQRzV5QKbLqmTwZwo8pYPF+XcK6DbG6SNZVVZ8uReF3V6QOamDZzjxZ4Mdr/Ljbh3sJVBRB8/jMAy74ej+Mi4ffHUpXYp/ZHJ2JLWOAcJmEJC/UR2Mlkbm6vsiUvmDNW009LmbI5Bw3tt1mGYgOZP5s2HcVI0vbZmGXUIhy3p1MBipZXRwHv5OkScunRm9RPk77m5iNV6PcMSx5oMLg9PBeBjldHAsH3y5l53WXzJubEYoMASHtQqq74lo7+c/gUDKZXlDOrgc/07B/jyU1ZFUTZJZ4Ohk9oTdXoo5oXPky9xbAiE6PXq/wHzwMQm3SVAKXz54Hm/DMFWadrrzKv5fkLOt6jzezG9KeB3srLcJ6uCM/PeN92YsY0B0sK0oDMbR6noHAF7GIxzEjsfDO7w62Ll4H6T4M9U4wDhRsOVr8HcLsHHtWI6w9xqFtS0lhJ+qEACng7e/wTpSTAfjQDFMC3IDz48/3S96EHQEyW44g0ENzuL4fgYDf7rvsvxNR0fzRcKK2o7NB4vz7xTuauoyDWZ/bzyrCvUaVjTSbi/EfEWFgvmX4yg09XJp/Ano4M2Zj7HCFtm6Dp4nY38A3sqmmvv0ZG/EIoQJiI7ESiqkI31LURXzwTn5g09S8sGwYiSxd3EACyVyFrDbCQ/H7LaHKjr4Tv72ikOS6eWkrcE/YzFJjD+0L13LwmXv0WxPftGs/osfi5tAVAfj9CM/tINfP/gkFrnIu/KWpBrPHKYp2Q2Jjjxc2B9AlmOPRSp7lj8oH+sqzCoYzIvx7xRkVyewLVWMVE3OE86Uss2xQcTtpZmTMO0KF97vPBUO1MJzfjCyDzcPtBVyUVMHAwL+eY6z9GTNfSaJJcPfLybW1acj3WBCdTCuouT+4Kz8wW0pOhiWcKol3QFgngb+CC0Tw+lx5fDxJqFDzF5OB2fiv/ry6RxxanLkfSfnIXn4L/Ns1RLu7zSgmfd+gB9a84UrpODXweu68s12tA6cZXJzYTuIuTsNGVlq5kQzvHCKf/5uSPtSKJLP9vehd4ZBs6OX2OioQaBrBHWwAP9OwY6e83hzXy2B1OQ4DrQRwGAJRh05txdk7l0VuZEegrJdwE/vzwcDLGZ/pttr2fWeG6RSDIHzg9dlGrhTC+Hd6CM2+yUMy58ZgyM6cpmYg6ntKi+SXFuXCLy4pTH+5DYGJvHAjJBX+K/A5yOJnKQPgAqb7JRXWgdn48/FouML3CIVM9AP0xJdgJCzv4nn055fs4MvFvj7HhzPDFp1cAkEdDBIj/oWXNzxdzl2GN/wRX7AmunP0qFTkUE2gX9eN3Z05G4FZ/XGzWRxua0Y/3lMO1cooAFIxynBv1O4oydOn9Dc6kqmEKYRRrsLYQ94wm4vw9yM6OxTubwMEu1HoclqIKyD+dkaGNIazwc75oBGB7cyZL2jvxTg/mY2rWm9GLooIzG4SspDiD/sotz0boH7kLxSOcEe/P5mvNLDd6469qYQ4s9NERmDhgLP3iYR6wjydypA8m83c0SE2Q+h+eBKcI6B57OmK2g4J9rQPJjjkm4g8Q1YpwcyITdewM4Jbs6/DVdTpKc5eifA3wztIZ27R+h4PrgY/04Bpx/MkLiYH09a88DJhHvaBmdGEbcXYs5JXVIXvOWZvTm03EBrEcsHdwL+4MN+oPzrQvnXRe/8FVnQuxsof8UF9Gv2fplDqA5uBcq/LpR/XfTOX5EFvbuB8ldcQL9m75c5xNPT0+3NmzfPz8+vXr16UigUCoVCoVAoHgaaD24Cyr8ulH9d9M5fkQW9u4HyV1xAv2bvlzmE6uBWoPzrQvnXRe/8FVnQuxsof8UF9Gv2fplDxHUw+zvRggxTYduDnBkw2FfT0zOqAj+FLf6j1N79yfKPHqSDj9Jhjv/lznqTbs2XY/8+0Tt/RRb07gbKX3EB1OzoVN3AASJoQE0/LjcjXobD8DqY1bus/A1oHXpr7CSMO8G2xyGzlmkYBnsMcgw1HArr+JOHNN1zBq3E+bXOEwLmnMnLw3c/WRbnG6KteZf9T3E4611pfLzzQHce4B7y6/kMnvd4ZW5xBi8jnoYg5FfXymzjsD+AvXP34Aahs7Ax//0YqIRTeKWxcw4f4z2PN5a/uIvstCR6SF4E7XeiFiak7jcStwfn0fp1MDwNdj+broKXXeuw3JlpNeHNB6eI4DPXl+N1fVJujvORe59HJwebQ2iZ84SlR/kz/ItGg2yR7rQOTkwbl2rNiP3ve/PFPTI4ESH+0HbkQF08O8WnBTtnaEt6Zg8C6MXA9B/+8PQaeIE62HSXsPosgis6uNxA9GA62PQ68wdy++Ah+OgsfXMAP3hZQmEJc6nDNtAhMOI6mG0L9zYCen3zjXLj6H7i9sC/QIXJNVK2D6CD9zewmDcc3gdsf2RBrw4OPtY5e162NSV1cAEZHOZvLnk+s+fbu5ljcLvq4JcB0I7NjEgvWQc38BYWq9ECTJZpqKODD1q+93I1g2B3Sa0FKOQwMTQ7HhiD+WCrgyfyjrZi/nalw7Y330nSweQ7RAf7AL9SYGYM2sP7FhGY4EpIRxbNCvM6hn1fil1UmfZbsc6Z7It8Q/SXeT5SqvV0sKcZwDbgQq1J7e++z8rygsUt07C/wNLcvVI/h4ER/A1J291gTml+XQ4bOkkHe4uy2fWQL5TRwb4phzUXbEhngX+ZhmEct20zvu7AWx7cOoJXK7tvzWMoofKQy5p/8HXBr1ekFYyxinZ8N1aYq3vvIwl/xpl5tmxz0IugzqS72nz0VuzI6eBY45q/WeuRG1iA3BtZCPFWDW1zoAyDOrK+eaFl2XBYRwcz6K/p2TowRkZmdaZ/VPd6NC3Rwbetg5v2LydcsO6i7k0CzDINMJ3VjhY+oYPdP9bUfDD+NZRMGx3tsY3qs3dpYRyZd3TuzGq2C6cDgBfZP+1fW591dDB8e2VCjWrp4A1clwX3l2tNur+WGNubD6Z3R7jYv0njAiVKSvOKV9TQsX0RgWkodBQwJrv2q6mD2RhiP+bFPN8d/JYHtzobb7hn+cGY3NuvnS0KpIsHWEU6PhcrLD+3jVln9rF1m4O5CCs9DANc1GXrSdIZ0caFfkutF5vWoW+di7pel4jp4MrmjaINHdxl05+v3JqwDBLTwdtsdg81hlu5ZqP5x9DgFUzHVEURHYxG30R1dhoBHYaYkNkJHhlgixVeoWF0ANdheGOir9A1lwiK6GAkXtl03s17S5nWxPZ3bBjUwfw/OJqeqGYalSvNq4MRyaTfycV1MLpIlVJlHew8m+0g1DLh7sBanvubfVYIyzTg/FGYAF9+Miu2pp7Au49XoztrizozyjSyPsO00R63hmneBuijYErPSYxdbFzuZhZsMyZFXW+TsTqevVLFvFEE+ZdCn01/T+2M2T3joRPNOR28mPYvqF18DsPETV7YNIEMOtiH4xZmWJYwwgUdvKIMnk23bJPJKbLtNDOYAQD1LyCKnIsJcs2PIjo4oWMGMrglWjOiw9J0MBcS/TIY9QxGB++leXUw4pO0vzyiBdn7wUc1dfAKxwiYFqJyPyYdnS+mK07nWdyohedi4J9hAlxnP6mDuQ8DscIQxAqZcWbGXFxz8BeNE5sRex4ZeqwOTm5c1noxd+XFUjzqQjFEGUJBE+y0dcwbRZB/KfTZ9GdqF5g+uZbgCl/wL+RM9932jBRM4XknTs6UwRLrSwffbrf1/nwwPyvO31KODnNHKBpUzK3jOG6HWewb7Aqngtd1zZkP7kYH+xuJtFSJ1syigxlb+mQw6gXX8sHndTD3mSXC5Jvw/ZV18AG0+hm3DNeUYcsHFWcq5vG27ehJI8B29vt0MB8rnMEedCOf+7nmwhUNtNHm9RNIW05HLziRD16Zi6H5kmtSDjmTgjtO54PLmjeK9vLB3MUmmz4ZoMSjHF4H7596t/tuvZckKgpvu43lg9dj2FvwbscedLCrbokmDtxJrvt6cXap6XoSmdF6jG8Sh6a1qsjgjPuDe9LB4DpuLi7XK9qaCTqYW5VDM3ZeSMLQgKbLsG1haoiUllMHO0lKkEJ3sw/UfGV0MPVwx/5s/jLaBaA69Fg+Kp/ps7ywdPFfAQJsZ79PB3tjBboVzBU592PZss3Bt9G6kq2rw8A3ZGBfQTy+cdaLNxP4Fjsd9EZdx2c4QeM8v755o2htf3BHTZ8OU6L5g9HBZMRhWg8k/qEHldUvnvMJ0FAIp2rHjT3oYIJAAjiQzlvX1at4WXV8H7gZFfZgSoTMpqzQIlKhDC6dFzEyaw+d62BTuUBiRKI1Y/nIBWTO6N/br/XI44+Ggb2fisrjWzNqP1IajnPM0tIpHWxM4smow8+okQvpYOgDk53+WGaQlrnKJRuCTclYPvg15lkeoMmFccAIAbaz36mDuViBHmSHYxtHqDN72LLNwV6EyhubBujwKXheRKxxWeuluCs1ha8hGKosw6gOrmteaFnWidvQwWuPTc/WwfOZ+e7+ZG41G/OnUxlnDDTjXFn5QieuzlCIuIEbe9LBW5Xci+zfvnvK4NRO89s4Wx+lPgmKKdhYvZ9HDc/riMM/u3WvlmnNqweX5u3T10vr4eDVEHrn3zxSYkX9Aap3N4jr4KbGfwfN6ODHAlYv3n5qkj2kM5PpD1n0EUXSRprmPSkpH9wFXlIADcG3OlYbj2J/CtXBedA7/xZxOlbUH696dwPVwYoL6NftU3Rw+46kOrgVpPMHGdeEZDCfn82fRX4c+2OoDs6D3vm3iXOxooEBS8QNSsXAlX+tqbFoffNGEeTfIQo2/T3oN/pFdDDcQtgwnp6ebm/evHl+fn716tWTQqFQKBQKhULxMNB8cBNQ/nWh/Ouid/6KLOjdDZS/4gL6NXu/zCFUB7cC5V8Xyr8ueuevyILe3UD5Ky6gX7P3yxwiroPZH+gXZJgK2x5kS9BwvHZldXawBA4jKL6DqHd/MvyTDoyAW+a8ZwgzxZnT4sFX8PG3kefF+XcK5a94AejdDZS/4gKo2e1AuMBD5y3IWHecnVh+4/PLcBheB7N6l5W/AalDb3XO9sgLtj3gMa5D+qtWajgU1vEn95Vf+wEGe4DiVQT6Q+Cn6svxmnSvel3Qa2iIDsbHx/iajT+Rzctf4tcsgXOEU757mj8Bfh66gZSMv0yPu/WXeTfaiKfJBxF6TzAFV/kDjyNfB/eyZ5m+cLThBmGEnATz339nNtY/3nLnHPbvebyx/MV/5LTTav93hEH7pdfCiQzE7XFyx6OD6Vn5VWTwxQ67G6B2rzDw5oNvCSL4zPXjjGUxN7ftcQhuJLyNA6Pzp/0J4b508BWQd+fcW2Fvf/B05OMzPrVLb5nHm31z+n6fI68z5YNZ+wdOcU/APTI4ESH+sH1D75MjJnUOoZT0zDYEUKIOJvqA60rBM8vocdbcTM22jHNk/gtGG24QRqoONt2lgWPer+jgcrL0oXQwFxmQ24dXVE1M2BJIZrnb0TJlXO5Sh22gQ2DEdTDbFu5tBPT65hvlxtH9BYMD41DjvC5LuA26ywdfAHLFDI/09Yd5GrzGxPqAf426TwfzWyjE8sF36eACMjjM31zyfGbfQeJmjkna8tF18H6U/Tii18xFuhIudh5vwzAgz2ffntjWUFEGbbhBGKd1cCgVUAhWowWYLNNQRwcftPghoCEEe+WVWszuaxTxcBXMB9vBcYKvm0sa8DLhSodtb76TpIPJd4gO9gF+pcDMGLTHQl5BiGi4762Mzr2KgNcx7NKouThOE/d61en4PJl+hhdy8P1hHsfZFxaW/e2R4V3a/nxwXlD7H6wOtzWEyOs0l2kYpom+xI4KH5hyZVcj7G4wpzS/LocNnaSDvUXZxGPIDwrpYN6k/Nugk14/C3iTELB9bt9BeKxgcz65t8Y8kyIxmK6E87nLNJCMADc1am+oKAMunQHae5mGYRy3uAH/XrlQSW5gwW5oYaOu6yQcw6CObMCxQUlsEK2jgxn01/RsHcIjlYkMKHrTpaMEHXzbxIBp/3LCJRy3STRcpgEmJ9sJcCd0sPvHmpoPBv4gJoSP9thca/YuLWwvwGY4lJxEMeB0DFlvpRcPIUl0MHzDcFKNsqy7Mjp479LzuPVYdxMD3CizTKNPLSMdPDEKZQ95UYSsQffXEmN788H07ohn2b/ZfSlcaV7xiho6ti8iMA2FjgLGZNda5XSwa1LWXGxgYS7CLjUc6xN2WoU6VFpP8JiCdqV9WEUq2GnTPT+MRt95hFGsnQFDGsQNbLu4MzU0a+NCZWxah751LupSGcoIGl4Ht+7YbejgLpv+fBVtf/dnVWM6eJzNLYf8Lbr8EInbzljpTcdURREdjEbfDKlHFtiTuBTLyiw54MXJcIpGFoyOcQbLPbi5xkRfAXPiBEvHI8ZZ/pabidDTsizbtBXMpkEPRpNzLMQOHWxmv0d/Zye91ycz2P6ODYM6mP8Hx8nDzzQqV1okibvfl/Q7ubgORhepBCuog4MmRfkuljm9CF1n3oaJo2Daoa7rYG9XgmOq285oILVj2g3NcxpfL84Gz3QO6j7o9mys425mwbZ2UtQlItRe9Lmxe6VNxw7yL4U+m/4KjiY1ZucWorhozungxbR/wWgRi9vgIi9smkAGHezDcYtX4WSvCfhXkg5e0RBjR55tPJsim4gzgxkAUP8Cosi5mCDXeJxIgKXz3wsGQzsmjBf/eIa26ss0DNMMVoFMgcyX71gQ8u9LOaGDuZDol8GoZzA6eC/Nq4MRn6T95fxH/jhOhpMaOhjPERxlDwYOwMy9aExpxo3Z/MqaGee44chJ7bm5Pp/3zeZXSk4Kir+T7fuPAP90ztEf8G/WXDGz8WIpHnWhGKIMoaAJdtpKjh1DkH8p9Nn0l+BOnxyebOGLXSa1TbXsW65KTpqjcRsOoXZMbyyehXTw7XZb788H87Pi/C3l6DB3IHNHs/3WcRy3NfoJLVYURb58cKoO9qav7uRP8xaOOEUrfaYHo6oy0xU4QuD1P1yjxGb3879DBzMm98lgmgW8kA8+r4O5zywRJt+E76+hg7nhiBvUYxm0eeveZiI12eWK+/PBsa60FcuIa46xm3Bqb9wQw8Wfq3qTgkGz5UwKOvwT88GNOXZ7+WDuYpNNfwlBHbw/xZvd2cY7kqgovIsqYR1vG/bAaN1ePPOeH0zuI5o4cCe57uvF2aWm60lkRusxvpFYprXqrEHm2x+cpoNzV9SfSAgkaakwvG17It2U6p4WPfQatz7mR9IMOUEHs0+FM3ZeSMIaoukybFuYGiKl5dTB+8MwDbYuTkWjJd8Hz+9cDyOw5oL8zA3sxXVdyQZKe4oJ6VDndTDrhfDRrgOShBZ3J5otNjZsyIEfVuPxjQuVcd6/uOcAAAvdSURBVHcF32Kng96o68xajz/j+4PbduzW9gd31PSp4Po7/+saOOIwrQcS/9CDyuqXSNw2RCdQhV50MEEgAexLvx23eRSvQGTnZlTYgykRMpuymoxIhTK4dF7EyKw9pOlgNzd1Z4VDO/2TdPC6rmzAxhFn2LdHzJxA5ZHW6yI6+DC6eSb8e/vtJXGmo2Fg76ei8vgWqg0tDcc5ZmnplA7ei/E2O3KMgHrLDSqAqElZc0G6gCt7EeZskfq3ZQ/TdCEf7OtKlnF4GuO9015ua9CQhOe8CC6TRLzRDZUp7sqaPhh1sZNQhlEd3Ihj+1JRbejgtcemZ+vAfuY+mVvNDo+MzrhnVEtZ+RKL25gbuLGpkBbRwVuV3Ivs3757yuDUTvPbOON0C+kNa3kx3Pt51Hl08HE1tFKIN0lwAHHGbdjT/MPI26evl9bDwashNLEgq6iNF+TGHh3ctmM3o4MfC1i9eAc3k7ojwyKZ/uC5kSyS4nbznpSUD+4CLymAhuBbHauNR7E/hergPFAdrFhflBurDlakol+3T4nb7TuS6uBWkM4fZDsTksE0N5r8xZN4HPtjqA7OA9XBilXIjUvFwJXf12F8uQPHDvLvEAWb/h70G70jcRtuIWwYT09Ptzdv3jw/P7969epJoVAoFAqFQqF4GGg+uAko/7pQ/nXRO39FFvTuBspfcQH9mr1f5hCqg1uB8q8L5V8XvfNXZEHvbqD8FRfQr9n7ZQ4R18HscQsFGabCtgfZEjQcr11ZnR0sgaMliu8g6t2fDH9+RxYB3DKHzwWK7CTyHJNGHnq8EOVEg74Y+3eK3vkrsqB3N1D+igugZp/hmye5IZEOePuhm+U3Pr8Mh+F1MKt3WfkbkDr0Vudsj7xg2wMe4zqkv2qlhkNhHX9yX/m1H2Cwp1FeRaA/BI61MCcCe9VywjF4tmzfEW3LNMZqeJf9owicI5zy3dPnHwcnAegGUjL+snMQrrfMu/Ey4mkIQn7V/G9QTqEHNwidVon5778zG9s53jIGlr+4g+0Wbd+bgweVptfCGXmJ24NxzK+D6ZsPqsjgix12N0AzvcKbD74liOAz148zlsXc3LbHIbiR8DYOjBKKfpHVlw6+gNznr3n7g6cjH5+hbLD/pTnmCyMIELdxRsWT19Oxf8f5s/ZPfkEJi3tkcCJC/GFPCL1PjjiCcwhlofdoKB4XPbhBqg423aWhY95jYPmL46F0MDfyIrcPr6jaNwfur5Tal7sdLVPG5S512OY6RFwHs23h3kZAr2++UW4c3V8wODAONc7rsoTboLt88L3I4Je+/jBPg9eYWHZ537exsQOz3nHcc/tIJGO74Sl1vHaSOriADA7zN5c8n9k3ynjf5ecpORt6EEAKcfTgBqd1cMo8vBHU0cGHgQKvXGoDwYHySi32AqHZaeYnkA+2OniCr5uLby/Mhysdtr35TpIOJt8hOtgH+JUCM2PQHvQVhIiG/22o3rlXEfA6Jviax837d3EIdI7ZHJtI37Pn9ip/iHkcZ/9mhU3NRnZpHy4DZr3bXpfFzou3R5FcJkgTJ9SO2v9gdbitIURep7lMwzBN9JWE2M8hAfA383pjrjS/LocNnaSDvUXZtZJQgCqjg31TDn4bj/M2SDhR8nUH3vLg1m2hARfMPItz3eOr6L25NE/Evtma6ewxVtGO78aKtsGlM/yNa2fEnPXIDSxA7o0shFBPs1xG7uW6+7dDOrIHx66jgxn01/RsHcIjjwm9KPqh8jyalujgvYMbbVNOuGDdRQcvstK8TANMTrYTjk7oYPePNTUfDPxBTAgf7bG51uxdWthegB1dgC8OTgcAL7J/2r8OIUmGwxsrDHns3V5mf/Depedx3wKMyNCNMpEtvEd8QrEbJFvgAHCIDoJwJen+WmJsbz6Y3h3xLPs3aVygRElpXvGKGjq2LyIwDYWOAuzo+k5NHczGEPsxL+b57uC3PLjV2UbFPcsPxuTefr19znb2GKtIx+diRdsg6Yxo40K/pdaLTevQt85FXa9LnNfBbTl2Gzq4y6Y/X0U7KPmzqjEdPNpV0UP+UiktCpp/DA1ewXRMVRTRwWj0zbEXlQP2pIVffXaWHMicGLZY4RUaRgcgfiAt6hoTfQUmotIsLbI/2Nh608HLAoLwumWKQXswuhXP9bcciPv5UdowjqFVqegsB9vfsWFQB/P/4B7toTGPTni1//DqYEQy6XdycR2MLlI1XFkHO89mOwi1TLg7sJbn/mafFcIx0cO5XS8BvvxkVmxNiwTevPBM5041LnczC7YZk6Kut8lYHc9caNWxQ/yLoc+mv4Kj8Y3ZuRUmLppzOnjXv2W1i89hGPfihU0TyKCDfThu8Sqc7DUB/0rSwSvK4FmZtk0mp8gm4sxgBgDUv4Aoci4myLUwMmTp/faHwpSkpbzq1BCap1ReS3B31kkd7NgwTQdzhvTLYNQzGB28l+bVwYhP0v7yyJDJ3g8+qqmDVzhGeCZPzhAV+jtgeZ9ccJ7FjVp4Zg3+GSbAdfaTOpj7kCmzafinc8HGZa0XqzEvluJRF4ohyhAKmpC6bdWxQ/yLoc+mvwR3+uTwZAtf8C/ktrou07DtGSmYwvNOnJwpgyXWXigK6eDb7bbenw926xydq12Co8PcEYoMU/bWcRy3Nfp9G1XhVPC6rjnzwdV1MMlwOMLUPg32YDwsQOIoJKN/LMyhEPMINimZMDUV0cGMyX0yGPWCa/ng8zqY+8wSYTJT+P7KOvgAWv2MW4ZryrDlg4ozFfN42/ZnpRFgO/t9OvgF5YNX5mJIVrom5ZAzKejwdz/uwbHbywdzF5ts+ksI6uD9Kd7tvpvKIYmKwr08lg9ej2EP6PNedLCrbokmDtxJrvvWXLNLTdeTyIzWY3yTBjatVUUGZ9wfnKaDYcPkmEL6EwmBXftUGO7KwdXNJ3Ww87h4z0vQwdyqHJqx80LSYbiSe8GGEa60nDrYSVKCBRE3+0A7QxkdTD3csT/+fCcU7QJQHXosH1UZ9FleWLr4rwABtrPfp4PZWNE2+GE1Ht8468WbCXyLnQ56o67jM8efwf21HTh2a/uDO2r6VHAjL//rGjjiMIPabE5QQs1eVr94zidAQ+G8pRjRONNWKIq/T24NJoA9SdfbcZtH8QrkJrgZFfZgSoTMpqzAIlKhDC6dFzEyaw+JOhiWnaOyoZ3+STrYcmJ2FviBdTQ1FSgiEh1i+ci9eGNl+Pf220viTEfDwN5PReXxrRm1HykNxzlmaemUDqYGpXciYxObFdLB1jQoj2+ZQVrmKpdsCDYlY/ng15hneYAmFyacRAiwHnynDuZiRdvwnBcRa9yVs16Ku7JBMBh1h2niDg3Yr4R1ZPuO3YYOXntserYO7Gfuk7nV7PDI6Cgao1rKyhc6cXWGQsQN3NiTDt6q5F5k//bdUwandprfxhktztPesJYXw72fR51HBx9XE2u1xPLBzs47L64eXJq3T18vrYeDV0PonX/zaChWBNC7GzSjIy+id/6dAqsXbz81qTvSmfHE+7ixSNslbaRp3pOS8sFd4CUF0BD4dbT6eBT7U6gOzoPe+beIVmNFAL27Qe86snf+naJft0/Rwe07kurgVpDOH6yqJCR4wN0A0r9T7A+qg+uid/5t4lysaAAiblAqBq78vo62JQBG7/wpCjb9Peg3+kV0MNxC2DCenp5ub968eX5+fvXq1ZNCoVAoFAqFQvEw0HxwE1D+daH866J3/oos6N0NlL/iAvo1e7/MIVQHtwLlXxfKvy5656/Igt7dQPkrLqBfs/fLHEJ1cCtQ/nWh/Ouid/6KLOjdDZS/4gL6NXu/zCFUB7cC5V8Xyr8ueuevyILe3UD5Ky6gX7P3yxxCdXArUP51ofzronf+iizo3Q2Uv+IC+jV7v8whVAe3AuVfF8q/Lnrnr8iC3t1A+SsuoF+z98scQnVwK1D+daH866J3/oos6N0NlL/iAvo1e7/MIVQHtwLlXxfKvy5656/Igt7dQPkrLqBfs/fLHEJ1cCtQ/nWh/Ouid/6KLOjdDZS/4gL6NXu/zCGenp7+H3n/5aRxPN9BAAAAAElFTkSuQmCC" alt="" />

我们先来理一下思路:

1、我们需要获取文件,也就要知道文件的路径;

2、读取文件,取出要请求的URL,请求参数数据

3、用get或post方法调用接口

4、返回的数据与预期结果进行比较,判断用例结果

5、将请求报文、返回报文、测试结果、测试人员回写到excel中

6、生成测试报告

7、发送邮件

由此,我们来定义出框架的基本目录:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAKIAAACpCAIAAAAnV3GPAAAIp0lEQVR4nO2dP2/bRhiH9Tn8JTymGjolzWzARscgSwlk8lKoW4YORgdCUwEDBYxMGeLBCRxZbgqodlwkrfOnRiomiiUHzmBEcVzXcWNk7HWgRB55PPJ4IqXTvb8HHMjTHUPoyR2PvlcvKwwQoDLpCwDjoBTNaw+2+e1Fp1fGvwLUGYfmtQfbz9od5dbderVScZrBcdOpxHGag2p8AZAzJs2yLaFxt16tVqsJ4ppOpLBbr1br3eFuZbgPkpBqbjQaruvGCl3XbTQamScdRbNvL6aUMZammbGmA89pSDW7rus4Dm9aLJHBi2w9ftZ6/ExZ81Begjdo1idt0Oa9qjtmnObOwaFf0jk4VNIc6hLFYdDWJ+Pe7NtdXFxUd8w4zSenZ37JyemZimbereBZ1BzMwOA4g+wpWK5+7KPbm8U5Ne81bdAG6SjNtFWmXTya9+amI3iNPVhBsyYGPVDFLcdLoFkfgzSD8sDftElgkuZ+n12/zj590t8HEkzSPDfHtrbYwgLr9TT3gQSTNPf7jDHW6bArVzT3gQSTNIPSgGYSQDMJoJkE0EwCaCaBcZp1wwW79aTAIixF+5iuWTlcEJrTmALNasseEs2AMQbNRDBac55wQV9zGH8yUB7abzqVar3u0IwqMldzzgAjPzRs2J+DgISI5uHn9G7Y5mrOGS4YG7SHh7He3A0+heaJMkpvhmYZ5mrWuDcHnsMDaGaMGa4590zbic/AoNnHGs0gDeM0gzKAZhJAMwmgmQTQTAJoJgE0kwCaSQDNJIBmEhinWTfkD6RhumblkD+QxhRoxtLF6EAzCYzWnDNDYBjvN1hM5lKHBYElSWVCw+RqU4y5mjVyikVDBbp1h0slFw8m4RtG5EZDiyzBXM35Qv4kSTuFTul3XK6qkHJumDLUqjBfczXn682i5m69Ghm9xUSQshywSdWmHHM157w386nimvV6l/fHRwDW40FikRxzTUdWbboxWnO+mXY4QIdB94Nx2HECWcLvMrJmZRZItkozkGOcZlAG0EwCaCYBNJMAmklQ8QABoJkE0EwCaCYBNJPAOM23723y24Ot3yZ9RTZQlub19fWVlRWNhjHNt+9tbv66U/jlUaMszSsrK0tLSxqmRc2yrYzLtpUSB20909BcBuXemzVM8yLXNltrmy1Fze328sJwjXi2thErqVQWltvtYeFsbbk2G5QOa3Gt0ipknLkWr2wCpU/BXNddWlpaX19XrB9YbO088ktaO48yNfvfO//Nxkraywu+j4Gh2drGcLeysOx5XnujNpungvTMYeXZ2kZ7pO+uOMztzbtPn/slu0+fZ2teXvDFyEraoaXBB17Q/6L72RWUzrxRm6WhecR7c77erKRZzaKOZrEhDc2FzLTV783t4dDp79cGNqJDq+9idM1KZ6ahucDnZtUp2MZg0hSdE0kmSiNoVjszDc3a4IGqDIzTDMrAEs2vt7fP5uZePXli4L4JWKL538uXD2/dOr96tdtsGrU/6S9mgCWaX29ve57Xu3//olo1an8i34aIJZpBOojsJAE0kwCaSQDNJIBmEhineXJZ/ga/ZrfiZ+txTNc8tix/lmSfkDAFmseTrSAt1cz0U4rmRqPhum6s0HXdRqOR2Raay6AUza7rOo7DmxZLZBSZ5S+S9IvPHhN/wy9Xz86Bu6xBm/eq7pgVmeUvWhLmhUp+wy96sya+3cXFRXXHrMAsf/ESPhFYwssioVmfXP3Yp7AsfwmagxEamotGZdrFU1iWP3HQThAKzROiuCx/LG0KBs2TBVn+ysA4zaAMoJkE0EwCaCYBNJMAmkkAzSSAZhJYq7m9/4Yx9vPOH7Ft0tc1GezU3N5/4xuFZh8LNfuOx6eZW7Q2Fts0B46hmcc2zTEK1cwHf05ZIKhtmkWvey/3T8/OeycXr/ofj//+Z4RzQ7MxxBw/3N3bPTq/drczv+rNr3rX7na8DxdiK4W3/XJL119883Ul/Gw/NJ4QTBg9VbVeF5e1/fax19hF7wQjL4bbrLn16Gnn4O0d7/jm1qGveX7Vu+Mdx9sovu1X1psjmsVgQj6shX89aeSf5yJfhtW5S2g6o44c1mp+/Pyv3snFHe/4xydHN7cOv/3lYKD5j3us77KPm1wjxbf9qmgW4lJiHTGhX8b+l4mhiaNbtlfz0fsPwVjNb6ut79jeDHt5SWia+bbfMWsenKKQWYC1mk/PzkXHN9Zah79/yfZm2N5M2Ebxbb96mmWDdjiqh68dTjioOk61gKc1+zX/sPHTf3/ODNTyG4fi234HZcEInjgFE4IJ+TcMh1OwqGbHSX6RsPgjAz2s1Xz0/sONxn44Sse2hEF7LGQP2lnVtbBW88PdPX8K5r34PiK4N8/6LvvsjeuKuvVq5CFN0CbXXNzDubWa/a1z8Jb13dDx669YP8dPQIqBG/+TumayTP8+UtRfYGzTnMBnj728FI7V4+vHBkFAM4BmIkAzCaCZBNBMAmgmATSTwDjNuln+ClitsxjTNStn+YPmNKZAs3LuEWiWAs0kMFpzzkxC6Zll+PLE0DubMVdz/ix/YdydLLlfauidzZirOV+Wv0CzLLlfdkyWzZirWbM3y5L7QbNRjHxvTknuh0HbGIqYaUumYImhdzSwRnNOMGhbSmbonc3Q0ZwZemczlDQTBppJAM0kgGYSQDMJoJkE0EwCaCaBcZp1Q/5AGqZrVg75A2lMgeZSli50mLKUbzzQrA40F4duWAGXK4+LI4guVCTm0/NJXKLm6kcz+03duoe5mnMGCUVz5cnT9CXk05NGCcbOid5cHLohf1EH2Wn6mDQaMDl7o3g4TZirWaM3RzRnpOljqZq5jF3QXAaj3ZuDQ2mavqR8erIoQWguDd2ZtuAgIU1fSj69lCmYcEpMwUanzAeqKe6OI2Kc5jKBZhJAM7AaaCYBNJMAmkkAzSSAZhLk0Pzu+OTd8Ul5lwLK43+B3c7uT/ftBQAAAABJRU5ErkJggg==" alt="" />

conf 文件夹用来存放配置文件;

common用来存放工具和方法

cases 用来存放测试用例

bin目录用来存放执行文件

log目录存放日志文件

report目录存放测试报告

我们先在配置文件中定义一些通用的信息,定义一个setting.py

import os
#当前文件的父目录
BASE_PATH=os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
#测试用例的路径
CASE_PATH=os.path.join(BASE_PATH,'cases')
#生成测试报告的路径
REPORT_PATH=os.path.join(BASE_PATH,'report')
#生成日志的路径
LOG_PATH=os.path.join(BASE_PATH,'log','ATP.log')

#邮件的配置信息
USER_EMAIL='邮箱地址'
EMAIL_HOST='smtp.qq.com'#邮箱服务器
EMAIL_PASSWD='授权码'#QQ邮箱是授权码
RECV_EMAIL='接收邮件的地址'

#测试人员信息
TESTER='PYF'

common文件夹下写公用的方法信息等;

读取case信息,需要用到xlrd模块,调用接口需要用到requests模块,根据测试用例的格式,分理处data数据,将结果反写到excel中需要用到xlwt模块;

在编写的过程中可以一个方法一个方法的写,写完后自己测试一下是否能正常实现;

import xlrd
import xlwt
import os
import requests
from common.Mylog import log
from xlutils.copy import copy class Mycase(object):
#获取测试用例文件中的测试用例
def getcase(self,case_path):
if os.path.isdir(case_path):
all_cases = []
for f in os.listdir(case_path):
book=xlrd.open_workbook(os.path.join(case_path,f))
sheet=book.sheet_by_index(0)
rows=sheet.nrows
for row in range(1,rows):
all_cases.append(sheet.row_values(row)[:8])
print(all_cases)
return all_cases
else:
raise Exception('测试用例不存在')
@classmethod
#get方法请求
def get(self,url,data=None):
datas=self.strToDict(data)
try:
res=requests.get(url,data=datas).json()
except Exception as e:
log.error('调用接口出错url:%s,请求报文:%s'%(url,datas))
return res,datas @classmethod
#post方法请求
def post(self,url,data,reffer=None):
datas=self.strToDict(data)
try:
res=requests.post(url,data=datas).json()
except Exception as e:
log.error('调用接口出错url:%s,请求报文:%s'%(url,datas))
return res,datas
#将字符串转化成字典类型
@classmethod
def strToDict(self,data):
data_dict={}
for i in data.split('&'):
key=i.split('=')[0]
value=i.split('=')[1]
data_dict[key]=value
return data_dict def checkRes(res,check_res):
res=res.replace("':'",'=').replace("':",'=')
for i in check_res.split(','):
if i not in res:
test_status='失败'
else:
test_status='通过'
return test_status #all_res=[data,res,test_status,tester]
#将结果写入excel中
def write_excel(case_path,all_res):
book=xlrd.open_workbook(case_path)
book2=copy(book)
sheet=book2.get_sheet(0)
row=1
for res in all_res:
sheet.write(row,8,res[0])
sheet.write(row,9,res[1])
sheet.write(row,10,res[2])
sheet.write(row,11,res[3])
row+=1
book2.save(case_path)

在run.py文件中编写执行测试用例的代码,整合各个方法:

import os,sys
import time
from conf.setting import TESTER
#添加环境变量
BASE_PATH=os.path.dirname(
os.path.dirname(
os.path.abspath(__file__)
)
)
sys.path.insert(0,BASE_PATH)
from common.GetCase import Mycase
from conf.setting import CASE_PATH
import common.GetCase class RunCase(object):
#找到测试用例
def find_case(self):
mycase=Mycase()
self.all_cases,self.case_file = mycase.getcase(CASE_PATH)
self.run_case(self.all_cases)
#运行测试用例
def run_case(self,all_cases):
excel_res=[]
for case in all_cases:
self.object=case[0]
self.mode=case[1]
self.case_id=case[2]
self.description=case[3]
self.url=case[4]
self.case_method=case[5]
self.data=case[6]
self.check_res=case[7]
if self.case_method.upper=='GET':
res,data=Mycase.get(url=self.url,data=self.data)
else:
res,data=Mycase.post(url=self.url,data=self.data)
test_status=common.GetCase.checkRes(res,check_res=self.check_res)
#根据写入excel的list格式,传入需要的参数
excel_res.append([data, res,test_status,TESTER])
print(excel_res)
common.GetCase.write_excel(self.case_file,excel_res)

运行查看结果:

mycase=RunCase()
mycase.find_case()

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZoAAABXCAIAAACyZRTqAAARQklEQVR4nO1dy2odPRI+r/K/Rq9NHqXNrPMOQ5a9nEcwnIUZY9oYgwlkjCFrh5B0SEhCQshL9Cy6W6oqlS590aXPqY/wc9wXdalU+lQqqfQf+r7v+/79+/ffC8J///X61T///s//cssB8f79+16wHj+uLi/ePOWWYr/4+/fv9oWajfLj6vIiSjtFkb/vj8dj3/eH4Y/n5+fcdAFRIp09Pz/HaIazg9DZOvz582f7Qkmj/Li6vLi8+rH9d/pI8hM6e3p6yk0XECXS2dOT9MEtIHS2Dr9//96+UNQoT2+icVkfSX5CZ+/evctNFxAl0tm7d+9iNMPZQehsHX79+rV9obpRnt7EmWMqRJGf0Nnbt29z0wVEiXT29u3bGM1wdhA6W4efP39uX+jYKNECZgBR5Cd09vj4mJsuIEqks8fHxxjNcHYQOluH79+/b1/oj6vLi8vLy4uLN1cRw2Z930eSn9DZw8NDbrqAKJHOHh4eYjTD2UHobB2+ffu2faHQLYu5DtBHkp/Q2f39fW66gCiRzu7v72M0w1kAUpjQ2Tp8/fp1+0Jxo0Sdc0aRn9DZ3d1dbrqAKJHO7u7uYjTDeUAHmCOP/aePL1++bF8oHWMiEloU+Qmd3d7e5qYLiBLp7Pb2NkYznAue3lyMENdsFT5//rx9oZZttDHaKor8hM5ubm5y00XpuLm5idEMAsEsfPr0KbcIqxBJfkRn19fXuemidFxfX8doBoFgFj5+/JhbhFWIJD+is39ev5J/3n8xmkEgmIUPHz7kFmEVIsk/0tnxeDwej9mZYhf/jgKBoCRAOjsej6N39vLyEoMyTwmiIkEJ2Lsdbii/0NlyiIoEJWDvdhiPznoVOwPfaOuq6ch7bX2oW2fJXVPVbd93TWU8qV5u64MJrty25q9nBVKRTb6uqXSt2PqydT8RFQkSQNvh1FMno7NY1dg1KbqmqpqmPsDebnZfruc77dprlBvKH0JnUzF2oU2603TWdUZHg32VyGWlSY4WMwOPKpOApCmQ0O5BAN49ERUJEgDY4WgCsL+rvqv+Oz5ndNquqaqmQwbG2JqFzvQ1+x/x5Q+jM9NDM8SkvdhC1JASq6ZhSqmaLqwwlkRTgneSJ6PgEERnp6QiQQJgO2zrqmmbSpECSwc9N+cyLFdfsFqbYwqBH0kjfyidTc+HdxqLRzjWHrseoGBUFtf9HeUmxnI6o4ocXnB6Z/tUkSABlB2qHt4F0MHwgoOElCG3aP4Z0TtbL7+XzqZuRLooKyaaVWJ/kK+jt7IsBZfSVa10ZiV8wE26XtBsQiabBEWrSJAAMPZ0AMElCx2MBmqOuXggBlTBR4rwNTtmxc5Wyh/mnU1BQitU2Tp+M3y1arrhR912HeC24SW2SKfzEcL2qQBGFSC4SSZa5ll0dgoqEiQA7KqDMfm9G255j7moHTOesYhde/6IL/8MOqM9ziNv11RjqAx8WLkuwPVwVx/Ft7Hbmxt2FTVNxTZ1CJ2dlIoECWDOEmxEQOkAzyTqGlvWwqWl2cPphvLPpzMrRaPH1Y0O9GyjwqoD6zkz60OqkopyO1gVKTrhZumLY2d7VZEgAcxNCF1TqdiX37uB64XAemBfV1M8s+cHrgGmkX9b7wxOa4Fu2hrXyAgMDXNme2dUE1eHUtKDURGoAraGfrq2NHa2TxUJEgDaIbAh5KfzdNA2eGMGa58DzEuMF9Y11eDj1dxcMIH8M+isbaq6tnpndFpJY0gdN//SgnRNZe2MAxvW9APZwapIRbsIyU9KcoxTnqWAPapIkAB435aOdRl7YjEd1HVFrXJ6XfVdPcVo3XQGRlMYMwkyxg3lD6azoYPOiJ05ui7tq6P3Rp24ycExHeAyJlRkRab2R62cK0CoYieiIkECaDsEEQ89f+T2F6ChUVklmNSNozKaQ/DmOrxt2ckBw04p5A+iM8SZaAZJamJoxwBeZVXrd3itYAilO5RgqDALzP0yLroam97vnZ2SigQJQJKE6GKQXpM70PmRaVzTNS4eHrJXy3E9hfyzttEKEERFghKwdztMnIIu4CEqEpSAvdthXDp7EQgEgh1CvLPlEBUJSsDe7XBD+YXOlkNUJCgBe7dDobMiICoSlABgh3gngwlbWvGELKcXpKezcfU2YGtVWXBnMLruuvOFuqY61KyKohvDKHT5+UxO3c+oBUliTQsi5wKtR3iF7E9Adgi13jX19JNsWGRT5frsdMaQMMgY5HaEkczN0H1nav/tudCZGwadpWOXM6MztaNSb61MifV0Fk0mBeLdgE3ybT11dG4fWe04YDplN8d0hiWdKAv+0s9qrhvfmkdnWch7DdwCL69ORjqbhGaPSCkJTjoLrQUoJAuVEDlLoDNDBnayZiEqj/AFeGfk+yQLeroLswXcdDZU2tVX4d/wt1YhOUYCq7Jrqqqux0PQmkrtcIevMQnc+NHaOEqH/Ra44Z5XUhkghZuVzUhnDHwaVr976M8Da4APsAD+PM3TI82tZYGRCWemyPQE00BIrQXMDagxGNXXNtlQh85m6o6vmK+Qhuia6nBQdggnoWZeuS1pnPTsculMExpOfVrsnTF/69/A2vRPfRs7h1xetWZfwMPax6SPgsvU6cTV9YGVwU9nhzLoLEjDcMChYx16gAV4CzW3OWziZLuV7dKbxlwOnYVU36Qz09SdX3Fb5nQJeWcw7dHineHQG2Kw4uiMKqqtD4eqwlY0M3ZmfMRKZxz5m+ZIHUX3bEIZsc0nZOMac0yflcFPZ5VLRcmwXMPcwyxYXbJFoSdh+UspqVg6C6q+SWdhE2f3K8YPG525vLMOrAXgy7npjMBocRpDmznZ5D1UlljAkABdAyqcj5eMF8PpzKkIG+zTycDJ5uyk2w0xS8Oov7HDgOULpi65ovCTkM4WtUtvWlcxdOavvqFea6+xf8VtmZMMc70z+NgA8v8cSQznZNOA+czMyWagdwbAOMYBr7OD0kLvbA5W01kx3hl30TX2hIW3t/TO5iL3UgDBWu9sUzrbyjsDyDIwJ6YzswQSIzA4CN8HnpqzXeGwA1og1DtjvxUCT2G2yhayFDBHw9bYmVt0EjvTC+e0KF/sbIGaMm/UIOCsYk7sbFM6Y2NngFoBiU3LCeqbhM60B51BxdnpTFcf/X9tPSub3DDL/9barZo2mAW5bwEhgnbM2riRVLYgOutnaLjHqg33esCEUT9qFgUu4qNEre0C62C5x6yKZpt2UsVaq68XdiPS2fg5bYdToNzTnl1TGfH0jMhPZ4JeVJQRYL97qUhHuSCGCxf+LahbGClzPJZCdCz/egidLYeoKBcKZTM+3hIde88dzpazKf0V4tRUxA/WhcxI9gGgwgC9baRwoTMFOb5RIBCcCOSAoOUQFQlKwN7tcEP5hc6WQ1QkKAF7t0OhsyIgKhKUAGCHrRzfSH4XfnzjuP7tXgand617r/BeJlss1vI6q6LoxtCe13lnlnbR+7vA2+xFdSeHtuI1Fij5hdtG2/doAbiV4xvVDbhdf4d0RoiGO67DucROTEENgayKouOs6MzSLmyqgD1/IN+ic3o6g/kAcnxj8cc36mZ0SKLuDsRd1TVKHDDzhLlPgL8q+JS6nYfOurM6vpEtkE3k5LM7GQNIiXiNBUpmJ2ueFHRPqUnhojN4CQ5TcJxbnRXQNVXVNEbyCVQhc9FwmLAzCQ1QV0BT81Asne+63bSubWm6JwKz2REqamxf9Lr20/PQGQMjDag7leMbiQhm8i6f6K4L8xlAYnRN5TuClO0v+rHGrImyw1aOb1xKZ6oFlBPITeKgleqfzEU4ylZVpeyWlMzOof2wWDPWijIapChjrjB6awc5vjHB8Y26igdLkqmHzgwl5QW0X3K6gru/oAi/jc7GJ3wHBEHWIwxWHJ1Rf2PKSuXz55cd34ivcKaC3CpuNscNE2MzVE07KHUqGBnnovAdJ6K1F8POyZ/lYXpnJbBZj/s27PxeInCqlFU5WxTbUm6iCQfi3x3TGbQk4zfXNahWQ+nM5Z11Z3N8I/kG46ES61DqRtKYEw0STicXh1JUhFL9l3S3bejM6eXp1QbDJUFwqigVqAUYfRv+ZuOGc8LxGlxRfEuxEi6Bk7lOhM56s2tYZ1YT5npn8LHpk5yrlgrOyaYBp3O1nXeGtM6Rjs9Ra4dzmZSPpk4e2to7882uhk8w9mA3o0K8M+6i7TdPBBy29M7WYMlSACdtRgQ1zAi4UhvVO8PfPHk6czs3k35JLMWxAYK92BtRs6oyH9ogdsY6G2TRhNynY+f4u7TYmf7pojA2duYWncTOjDBCcOxstpos7QJ7utkylvWdPdAZ3zXmxM7AyILdBDwgd3J8IymgrvHkQasEnLloWamxL9+At5iVHXwo4Pign946ThzTpbe1KOPcHQ6lLAX0oE6ce0Ikg61k82VMsNoxi+ptLWVIyNWBvWdpF1Wg9yJTxxUBvJUI8M7sXeNw4HeyazucAuWe9uwaOb7RoLMCBru8KIbOBDNR6HlpIWCoGMRw4aKpBXJ8o9AZC6GznWJnbGYLzkzYe+5wdDr75/Ur+Rf4b9JeK8c3CiIBtAzTHEJnCvzxjdk5Ykf/Njh0TiAQbAGXd7YVZZ4qREuCEvAi3tkEobPlEC0JSoDQmYLQ2XKIlgQlgNIBSmfhgrkkSDrtPswVJU1PZ20xxzfOg3uHkeuue6mya3qqpVRLAe05nXfWW/ZhgY1Y4G32orqTQ1vxGguUTOgAHEZkpzOasJmRzeIf30joTLVGvv2HC7Gcztww6CxdfzkrOrPsUZiZFZBv0Tk9nbn2kgFyGNKjh1y+mjnGMWU3f3Fso9Xb6WnquTYN7zZaG51Z2L5cuAVeXp2MdNbJ8Y0zcjaH3n0+xzfipEund6bprIG+T/q0TRed0XwJLlVxMZ0xf9N8RpPcjdSTDh8uCM6zw5m2B/wefrTmjr6zp7l455VUBnf+Y0Y6Y+DTsBzfWIovG2DDniQn1/GNBn1ZqInQ2VisIo3Uw2QonWlCg2QWi86AQQJzUrexOaLRkySzG/MKc/6sk9xZM8fV9YGVYTd0FqRhY0JGauqWnaSgs21ELwKlLm0XVMWDJcnUQ2eGkvLCa8NsJ5qTgo7go7NancLVg7P9UivKN9mEV6asVD5/Pih25sxxYu2bfRJZHjRNdy60alWbTzj9dhu0A6wM8+isBDbrZ2qYe5gFq0u2KPRkGNGEgz8CZH905rJhthNRrVrpzJWqCV0+js46dWRq8hhGwFIAAI2hzfTOGIa3NQrQJwpdEOG8bUpfDKczpyJssBBWOJ2lDzdozNIw6hjsMGD5gqlLrij8JCSaRe1C4WSuE6Gz3uxE1pnVBJt3Bl1BegMuAqjPDJGJ5BFZ52TTgPnMzMlmoHcGwA+kvtcRg8CwywLvbA5W01kx3hl30TX2mETAYUvvbA2WLAVw0mZEUMOMgCu1Yd4Z9ylrKGwYZYz4XAYtJaYzswQymTc4CN+nYZc5HjcJMHhZkH4rBJ7C+Mr25cXO/Bq2xs7copPYmV44p0X5Ymez1UQWswz7CtuosR864zvR/NgZiTAwjNbqk+thV8uxESs7nekJBDgD27uyyQ2e/G89PwEnQc5y1GmreFc2PdxIKlsQnfUzNNxj1bpClhhgwqgfNYsCF+X4Rg4BNuxZ2XQe36gfZborKQ6V0tYHfaZ0akPOT2cCAlHRnrCzA88gGCrGSwHOUftwGIJm1N1AL+lJSBqkTnKSvkpAzgjqRUW7ws7YjJ+BakgKuoKkoC+BSWfTJGHPlAbmdVssRAo2A2gZpjmEzhTk+MbZ/3qDzqKfSicQCAIgh2tvQGdbjS0CwQK8iHc2Ieh/fSIgEDoTlIO9d1WhsyIgKhKUgL3bodBZERAVCUrA3u1Q6KwIiIoEJWDvdhiVzv4PEyACEqQx6goAAAAASUVORK5CYII=" alt="" />

可以看到excel中已经写入了相应的信息,接下来就是完善测试报告,发送邮件信息