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

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

1．數據庫重構（Database Refactoring）

在《What is database refactoring?》這篇文章中，SachinRe對Database Refactoring作了如下解釋?zhuān)?SPAN lang=EN-US style="COLOR: #3366ff">

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的解釋?zhuān)?SPAN lang=EN-US>

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.

并且舉了一個(gè)簡(jiǎn)單的存儲過(guò)程單元測試的例子：

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://kjueaiud.com