第一部分:dos窗口操作,创建相应数据库、表
1、进入mysql :mysql -uroot -p
2、查看所有数据库:show batabases;
3、创建数据库:create batabase test;
4、选择数据库: use test;
5、创建user表: CREATE TABLE `user` ( `uid` INT PRIMARY KEY AUTO_INCREMENT, `uname` VARCHAR(30) NOT NULL, `pwd` VARCHAR(30) NOT NULL);
6、查看user表:desc user;
7、添加user表参数[uname,pwd] : insert into user(uname,pwd)values('tom','123');
异常示例:
第二部分:编写相应脚本
注意: pip install MySQLdb
import MySQLdb
import pytest
connect = MySQLdb.Connect('localhost', 'root', '123456', 'test', charset='utf8')
def get_data():
sql ='select uid,uname,pwd from user'
lst =[]
try:
cursor = connect.cursor() # 获取游标
cursor.execute(sql) # 执行sql
r = cursor.fetchall() # fetchall获取所有数据
for x in r:
u = (x[0],x[1],x[2]) # x[0],x[1],x[2] 表示第1/2/3列
lst.append(u)
return lst
finally:
cursor.close()
connect.close()
@pytest.mark.parametrize('uid,uname,pwd',get_data())
def test1(uid, uname, pwd):
print(uid, uname, pwd)
if __name__ == '__main__':
pytest.main(['-vs'])
异常:
TypeError: an integer is required (got type str) --- 添加charset='utf8'