How to use pymysql Direct connection Database in python Interface Automation Test

This article introduces how to use pymysql direct connection database in python interface automation testing. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

Implement step 1 PyMySQL installation

Start the command line and type the command on the premise of networking: pip install pymysql

2 introduction to the basic implementation process of PyMySQL

Import a third party

Import pymysql

Create a connection and configure the connection information conn = pymysql.Connect (host= "127.0.0.1", port=3306, database= "books")

User= "root", password= "root"

Charset= "utf8")

Create a data manipulation carrier object _ cursor = conn.cursor ()

Write and execute sql statements as required

First, declare the SQL statement

Sql = "select * from t_book"

Then, send the SQL statement to the database through the cursor object

Cursor.execute (sql)

Finally, the response result is obtained through the cursor object

Print ("number of rows:", cursor.rowcount) # gets the number of rows

Print ("first item:", cursor.fetchone ()) # get a single piece of data

Finally release resources

Cursor.close ()

Conn.close ()

About python interface automation testing how to use pymysql direct connection database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.