Python 单元测试:如何对包含数据库操作的模块进行单元测试? [英] Python Unit Test : How to unit test the module which contains database operations?

问题描述

我使用 pymysql 客户端库连接到真实数据库.我在模块中有一个函数，我使用 pymysql 连接到数据库，并且只执行数据库插入操作.如何在 python 中对这个函数进行单元测试而不影响真正的数据库?

I am using pymysql client library to connect to the real database. I have a function in module, where I connect to the database using pymysql and do only database insert operations.How to unit test this function in python without hitting the real database?

import pymysql

def connectDB(self):

# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='passwd',
                             db='db')

try:
    with connection.cursor() as cursor:
        # Create a new record
        sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
        cursor.execute(sql, ('[e-mail]', 'newpassword'))


    connection.commit()

我的 python 版本是 2.7.

My python version is 2.7.

推荐答案

你可以使用patch，像这样:

from unittest.mock import patch, MagicMock

@patch('mypackage.mymodule.pymysql')
def test(self, mock_sql):
    self.assertIs(mypackage.mymodule.pymysql, mock_sql)

    conn = Mock()
    mock_sql.connect.return_value = conn

    cursor      = MagicMock()
    mock_result = MagicMock()

    cursor.__enter__.return_value = mock_result
    cursor.__exit___              = MagicMock()

    conn.cursor.return_value = cursor

    connectDB()

    mock_sql.connect.assert_called_with(host='localhost',
                                        user='user',
                                        password='passwd',
                                        db='db')

    mock_result.execute.assert_called_with("sql request", ("user", "pass"))

这篇关于Python 单元测试:如何对包含数据库操作的模块进行单元测试?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！