def onecol(self, n): # n 表示行数 # 写表头 row0 = ['phone'] sheet1.write(0, 0, row0) for i in range(1, n): colum = g.createPhone() # 括号里依次是行,列,值 sheet1.write(i, 0, colum) book.save(path)
def manyrow(self, n): # 写表头 row = ['phone', 'cardid', 'bankid', 'name'] for t in range(0, len(row)): sheet1.write(0, t, row[t]) # 写表数据 for i in range(1, n): colum = [ g.createPhone(), g.createidcard(), g.createbankid(), g.name() ] for j in range(0, len(colum)): # i行j列的数据 sheet1.write(i, j, colum[j]) book.save(path)
def test6(self): '''个人用户修改手机号''' user = method.modifymobile(self.gr['mobile'], '111111', generator.createPhone()) self.assertEqual('00000000', user['status'])
def test1(self): '''短信验证码不对''' user = method.modifymobile(self.gr['mobile'], '111111', generator.createPhone(), 1, '436436') self.assertEqual('20002014', user['status'])
def test2(self): '''短信验证码为空''' user = method.modifymobile(self.gr['mobile'], '111111', generator.createPhone(), 1, '') self.assertEqual('00000009', user['status'])
def test09(self): '''密码为空注册''' user = method.regist(g.name(), g.createPhone(), '', '111111') self.assertEqual('00000009', user['status'])
def test06(self): '''验证码不对注册''' user = method.regist(g.name(), g.createPhone(), '111111', '111111', 1, '989777') self.assertEqual('20002004', user['status'])
def test05(self): '''用户名已存在注册''' user = method.regist(self.gr['login_name'], g.createPhone(), '111111', '111111') self.assertEqual('20002021', user['status'])
def test03(self): '''两次密码不一致注册''' user = method.regist(g.name(), g.createPhone(), '123456', '111111') self.assertEqual('00000019', user['status'])
def test02(self): '''企业用户注册''' user = method.regist(g.name(), g.createPhone(), '111111', '111111', 2) self.assertEqual('00000000', user['status'])