數據庫重構與數據庫單元測試

MILY: 宋體">提起代碼重構和單元測試，相信大家都不陌生，重構和單元測試也成為了大家開發中必不可少的一部分，但是您知道數據庫重構（Database Refactoring）嗎？您知道數據庫單元測試（Database Unit Testing）嗎？看看SachinRe是怎么說的。

1．數據庫重構（Database Refactoring）

在《What is database refactoring?》這篇文章中，SachinRe對Database Refactoring作了如下解釋：

Database refactoring is merely extending this concept of refactoring from the application code to your database code. Much in the same way, you can imagine a database rename refactoring would rename a database object and all of its references in the database. Similarly, an extract stored procedure refactoring would pull out a SQL fragment from a stored procedure and place it in its own reusable procedure.

2．數據庫單元測試（Database Unit Testing）

在《What is database unit testing?》文章中，SachinRe對Database Unit Testing的解釋：

How does this all relate to database development? The direct analog of application unit tests in the database world are tests of a database’s programmability objects. These include, for example, a database’s stored procedures, functions, and triggers.

并且舉了一個簡單的存儲過程單元測試的例子：

DECLARE @CustomerId nchar(5)

SELECT @CustomerId = 'EASTC'

EXEC dbo.CustOrderHist @CustomerId
 

IF (@@ROWCOUNT <> 19)

RAISERROR('Actual Rowcount not equal to expected 19',1,1)

原文轉自：http://www.kjueaiud.com