测试驱动开发例子学习-Using TDD with ADO.NET

设计模式 前端之家
前端之家收集整理的这篇文章主要介绍了测试驱动开发例子学习-Using TDD with ADO.NET，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
1. 连接字符串的测试驱动范例：
DataBase -sql Server 2000:
1.Connecting to the Database
2.XML 应用程序的配置文件:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="Catalog.Connection"
value="server=(local);database=catalog;Trusted_Connection=true" />
</appSettings>
</configuration>
using System;
using System.Data;
using System.Data.sqlClient;
using NUnit.Framework;
[TestFixture]
public class sqlConnectionFixture
{
[Test]
public void ConnectionIsOpen()
{
// 使用配置文件定义连接字符串
//string connectionString =
// ConfigurationSettings.AppSettings.Get("Catalog.Connection");
//Assert.IsNotNull(connectionString);
sqlConnection connection =
new sqlConnection(
@"server=(local);database=catalog;Trusted_Connection=true");
connection.Open();
Assert.AreEqual(ConnectionState.Open,connection.State);
connection.Close();
}
}
2. 连接字符串的测试驱动优化范例：

以上代码可以替换为:
[TestFixture]
public class sqlConnectionFixture
{
private string connectionString;
[SetUp]
public void RetrieveConnectionString()
{
connectionString =
ConfigurationSettings.AppSettings.Get("Catalog.Connection");
}
[Test]
public void CanRetrieveConnectionString()
{
Assert.IsNotNull(connectionString);
}
[Test]
public void ConnectionIsOpen()
{
sqlConnection connection =
new sqlConnection(connectionString);
connection.Open();
Assert.AreEqual(ConnectionState.Open,connection.State);
connection.Close();
}
}
3. ArtistGateway实现数据访问层的一个范例
对数据表artist 的通用操作 
using System;
using System.Data;
using System.Data.sqlClient;
 

namespace DataAccessLayer
 

{
 

 public class ArtistGateway
 

 {
 

 private sqlDataAdapter adapter; 
 

private sqlConnection connection;
 

 private sqlCommand command;
 

 private sqlCommandBuilder builder;
 

 

 public ArtistGateway(sqlConnection connection)
 

 {
 

 this.connection = connection;
 

 

 command = new sqlCommand(
 

 "select id,name from artist where id = @id",
 

 connection);
 

 command.Parameters.Add("@id",sqlDbType.BigInt);
 

 

 adapter = new sqlDataAdapter(command);
 

 builder = new sqlCommandBuilder(adapter);
 

 }
 

 

 public long Insert(
 

RecordingDataSet recordingDataSet,string artistName)
 

 {
 

 long artistId = 
 

GetNextId(recordingDataSet.Artists.TableName);
 

 
 

RecordingDataSet.Artist artistRow = 
 

recordingDataSet.Artists.NewArtist();
 

 artistRow.Id = artistId;
 

 artistRow.Name = artistName;
 

 recordingDataSet.Artists.AddArtist(artistRow);
 

 

 adapter.Update(recordingDataSet,
 

recordingDataSet.Artists.TableName);
 

 

 return artistId;
 

 }
 

 

 public RecordingDataSet.Artist 
 

FindById(long artistId,RecordingDataSet recordingDataSet)
 

 {
 

 command.Parameters["@id"].Value = artistId;
 

 adapter.Fill(recordingDataSet,
 

recordingDataSet.Artists.TableName);
 

 DataRow[] rows = recordingDataSet.Artists.Select(
 

 String.Format("id={0}",artistId));
 

 
 

if(rows.Length < 1) return null;
 

 return (RecordingDataSet.Artist)rows[0]; 
 

}
 

 

 public long GetNextId(string tableName)
 

 {
 

 sqlTransaction transaction = 
 

connection.BeginTransaction(
 

 IsolationLevel.Serializable,"GenerateId");
 

 

 sqlCommand selectCommand = new sqlCommand(
 

 "select nextId from PKSequence where tableName = @tableName",
 

connection,transaction);
 

 selectCommand.Parameters.Add("@tableName",
 

sqlDbType.VarChar).Value=tableName;
 

 

 long nextId = (long)selectCommand.ExecuteScalar();
 

 sqlCommand updateCommand = new sqlCommand(
 

 "update PKSequence set nextId = @nextId where tableName=@tableName",
 

 connection,transaction);
 

 updateCommand.Parameters.Add("@tableName",
 

sqlDbType.VarChar).Value=tableName;
 

 updateCommand.Parameters.Add("@nextId",
 

sqlDbType.BigInt).Value=nextId+1;
 

 updateCommand.ExecuteNonQuery();
 

 transaction.Commit();
 

 

 return nextId;
 

 }
 

 
 4. ArtistFixture.cs 数据访问层代理类的测试用例 

 

using System;
 

using System.Configuration;
 

using System.Data;
 

using System.Data.sqlClient;
 

using DataAccessLayer;
 

using NUnit.Framework;
 

 

[TestFixture]
 

public class ArtistFixture
 

{
 

 [Test]
 

 public void RetrieveArtistFromDatabase()
 

 {
 

 string artistName = "Artist";
 

 

 sqlConnection connection = 
 

new sqlConnection(
 

 ConfigurationSettings.AppSettings.Get(
 

"Catalog.Connection"));
 

 connection.Open();
 

 

 ArtistGateway gateway = new ArtistGateway(connection);
 

 long artistId = 
 

gateway.Insert(new RecordingDataSet(),artistName);
 

 
 

RecordingDataSet loadedFromDB = new RecordingDataSet();
 

 RecordingDataSet.Artist loadedArtist = 
 

gateway.FindById(artistId,loadedFromDB);
 

 

 Assert.AreEqual(artistId,loadedArtist.Id);
 

 Assert.AreEqual(artistName,loadedArtist.Name);
 

 

 gateway.Delete(loadedFromDB,artistId); //删除功能的驱动
 

connection.Close();
 

 }
 

}
 

 
 5. 删除驱动所形成的实现代码： 

 

 
 public void Delete(RecordingDataSet recordingDataSet,long artistId) 

 

 
  { 

 

 
  RecordingDataSet.Artist loadedArtist =  

 

 
  FindById(artistId,recordingDataSet); 

 


   

 

 
  loadedArtist.Delete(); 

 

 
   

 

 
  adapter.Update(recordingDataSet, 

 

 
  recordingDataSet.Artists.TableName);  

 

 
  } 

 


   

 

 
 6. 有了完整的测试用例，以及实现的代码，可以进行重构： 

 


  //首先优化测试的代码： 

 

[TestFixture]
 

public class ArtistFixture
 

{
 

 private static readonly string artistName = "Artist";
 

 private sqlConnection connection;
 

 private ArtistGateway gateway; 
 

private RecordingDataSet recordingDataSet;
 

 private long artistId; 
 

 

 [SetUp]
 

 public void SetUp()
 

 {
 

 connection = new sqlConnection(
 

 ConfigurationSettings.AppSettings.Get(
 

 "Catalog.Connection"));
 

 connection.Open();
 

 

 recordingDataSet = new RecordingDataSet();
 

 gateway = new ArtistGateway(connection);
 

 

 artistId = gateway.Insert(recordingDataSet,artistName);
 

 }
 

 

 [TearDown]
 

 public void TearDown()
 

 {
 

 gateway.Delete(recordingDataSet,artistId);
 

 connection.Close();
 

 }
 

 

 [Test]
 

 public void RetrieveArtistFromDatabase()
 

 {
 

 RecordingDataSet loadedFromDB = new RecordingDataSet();
 

 RecordingDataSet.Artist loadedArtist = 
 

gateway.FindById(artistId,loadedArtist.Name); 
 

}
 

 

 [Test]
 

 public void DeleteArtistFromDatabase()
 

 {
 

 RecordingDataSet emptyDataSet = new RecordingDataSet();
 

 long deletedArtistId = gateway.Insert(emptyDataSet,"Deleted Artist");
 

 gateway.Delete(emptyDataSet,deletedArtistId);
 

 

 RecordingDataSet.Artist deleletedArtist = 
 

gateway.FindById(deletedArtistId,emptyDataSet);
 

 Assert.IsNull(deleletedArtist);
 

 }
 

}
 


   

 

 
 7. 在重构的基础上加入更新方法：. 

 

[Test]
 

public void UpdateArtistInDatabase()
 

{
 

 RecordingDataSet.Artist artist = recordingDataSet.Artists[0];
 

 artist.Name = "Modified Name";
 

 gateway.Update(recordingDataSet);
 

 

 RecordingDataSet updatedDataSet = new RecordingDataSet();
 

 RecordingDataSet.Artist updatedArtist = 
 

gateway.FindById(artistId,updatedDataSet);
 

 Assert.AreEqual("Modified Name",updatedArtist.Name);
 

}
 

 
 //The following is the implementation of Update: 

 

 public void Update(RecordingDataSet recordingDataSet)
 

 {
 

 adapter.Update(recordingDataSet,
 

 recordingDataSet.Artists.TableName);
 

 }
 

 

 
 8. Genre Gateway 另一个测试驱动的例子（类似于artists） 

 

[TestFixture]
 

public class GenreFixture
 

{
 

 private static readonly string genreName = "Rock";
 

 private sqlConnection connection;
 

 private GenreGateway gateway; 
 

private RecordingDataSet recordingDataSet;
 

 private long genreId; 
 

 

 [SetUp]
 

 public void SetUp()
 

 {
 

 connection = new sqlConnection(
 

 ConfigurationSettings.AppSettings.Get(
 

 "Catalog.Connection"));
 

 connection.Open();
 

 

 recordingDataSet = new RecordingDataSet();
 

 gateway = new GenreGateway(connection);
 

 

 genreId = gateway.Insert(recordingDataSet,genreName);
 

 }
 

 

 [TearDown]
 

 public void TearDown()
 

 {
 

 gateway.Delete(recordingDataSet,genreId);
 

 connection.Close();
 

 }
 

 

 [Test]
 

 public void RetrieveGenreFromDatabase()
 

 {
 

 RecordingDataSet loadedFromDB = new RecordingDataSet();
 

 RecordingDataSet.Genre loadedGenre = 
 

gateway.FindById(genreId,loadedFromDB);
 

 

 Assert.AreEqual(genreId,loadedGenre.Id);
 

 Assert.AreEqual(genreName,loadedGenre.Name); 
 

}
 

}
 

 
 9. 实现部分Genre Gateway：  

 

public class GenreGateway
 

 {
 

 private sqlDataAdapter adapter; 
 

private sqlConnection connection;
 

 private sqlCommand command;
 

 private sqlCommandBuilder builder;
 

 

 public GenreGateway(sqlConnection connection)
 

 {
 

 this.connection = connection;
 

 

 command = new sqlCommand(
 

 "select id,name from Genre where id = @id",sqlDbType.BigInt);
 

 

 adapter = new sqlDataAdapter(command);
 

 builder = new sqlCommandBuilder(adapter);
 

 }
 

 

 public long Insert(RecordingDataSet recordingDataSet,
 

string genreName)
 

 {
 

 long genreId = GetNextId(recordingDataSet.Genres.TableName);
 

 
 

RecordingDataSet.Genre genreRow = 
 

recordingDataSet.Genres.NewGenre();
 

 genreRow.Id = genreId;
 

 genreRow.Name = genreName;
 

 recordingDataSet.Genres.AddGenre(genreRow);
 

 

 adapter.Update(recordingDataSet,
 

recordingDataSet.Genres.TableName);
 

 

 return genreId;
 

 }
 

 

 public RecordingDataSet.Genre 
 

FindById(long genreId,RecordingDataSet recordingDataSet)
 

 {
 

 command.Parameters["@id"].Value = genreId;
 

 adapter.Fill(recordingDataSet,
 

recordingDataSet.Genres.TableName);
 

 DataRow[] rows = recordingDataSet.Genres.Select(
 

 String.Format("id={0}",genreId));
 

 
 

if(rows.Length < 1) return null;
 

 return (RecordingDataSet.Genre)rows[0];
 

 }
 

 

 public void Delete(RecordingDataSet recordingDataSet,
 

long genreId)
 

 {
 

 RecordingDataSet.Genre loadedGenre = 
 

FindById(genreId,recordingDataSet);
 

 loadedGenre.Delete();
 

 adapter.Update(recordingDataSet,
 

recordingDataSet.Genres.TableName);
 

 }
 

 

 public long GetNextId(string tableName)
 

 { /* same as in ArtistGateway */ }
 

 }
 

 

 
 10.获取下一个ID 

 

[TestFixture]
 

public class IdGeneratorFixture
 

{
 

 private sqlConnection connection;
 

 

 [SetUp]
 

 public void OpenConnection()
 

 {
 

 connection = new sqlConnection(
 

 ConfigurationSettings.AppSettings.Get(
 

 "Catalog.Connection"));
 

 connection.Open();
 

 }
 

 

 [Test]
 

 public void GetNextIdIncrement()
 

 {
 

 sqlCommand sqlCommand = new sqlCommand(
 

 "select nextId from PKSequence where tableName=@tableName",
 

 connection);
 

 
 

sqlCommand.Parameters.Add(
 

 "@tableName",sqlDbType.VarChar).Value="Artist";
 

 
 

long nextId = (long)sqlCommand.ExecuteScalar();
 

 long nextIdFromGenerator = 
 

IdGenerator.GetNextId("Artist",connection);
 

 Assert.AreEqual(nextId,nextIdFromGenerator);
 

 nextId = (long)sqlCommand.ExecuteScalar();
 

 Assert.AreEqual(nextId,nextIdFromGenerator + 1);
 

 }
 

 

 [TearDown]
 

 public void CloseConnection()
 

 {
 

 connection.Close();
 

 }
 

}
 


  //实现部分 

 

public class IdGenerator
 

{
 

 public static long GetNextId(string tableName,
 

sqlConnection connection)
 

 {
 

 sqlTransaction transaction = connection.BeginTransaction(
 

IsolationLevel.Serializable,"GenerateId");
 

 

 sqlCommand selectCommand = new sqlCommand(
 

 "select nextId from PKSequence where tableName = @tableName",
 

 sqlDbType.VarChar).Value=tableName;
 

 

 long nextId = (long)selectCommand.ExecuteScalar();
 

 sqlCommand updateCommand = new sqlCommand(
 

 "update PKSequence set nextId = @nextId where tableName=@tableName",sqlDbType.VarChar).Value=tableName;
 

 updateCommand.Parameters.Add("@nextId",sqlDbType.BigInt).Value=nextId+1;
 

 updateCommand.ExecuteNonQuery();
 

 transaction.Commit();
 

 return nextId;
 

 }
 

}
 

 
 11.IdGeneratorFixture.cs优化过得实现： 

 

using System;
 

using System.Configuration;
 

using System.Data;
 

using System.Data.sqlClient;
 

using NUnit.Framework;
 

using DataAccessLayer;
 

 

[TestFixture]
 

public class IdGeneratorFixture : ConnectionFixture
 

{
 

 [Test]
 

 public void GetNextIdIncrement()
 

 {
 

 sqlCommand sqlCommand = 
 

new sqlCommand(
 

 "select nextId from PKSequence where tableName=@tableName",
 

 Connection);
 

 sqlCommand.Parameters.Add("@tableName",sqlDbType.VarChar).Value="Artist";
 

 
 

long nextId = (long)sqlCommand.ExecuteScalar();
 

 long nextIdFromGenerator = IdGenerator.GetNextId("Artist",Connection);
 

 Assert.AreEqual(nextId,nextIdFromGenerator + 1);
 

 }
 

}
 原文链接：https://www.f2er.com/javaschema/288168.html

      

      
                 
              

            

          

          
          
          

            

              




            

          


          

            

              

                  
    
猜你在找的设计模式相关文章



                                    
适配器模式-让不兼容的接口得以适配

                                
适配器模式将一个类的接口转换成客户期望的另一个接口，使得原本接口不兼容的类可以相互合...

                                
                                
                            



                                    
策略模式-定义一个算法族

                                
策略模式定义了一系列算法族，并封装在类中，它们之间可以互相替换，此模式让算法的变化独...

                                
                                
                            



                                    
设计模式之高质量代码

                                
设计模式讲的是如何编写可扩展、可维护、可读的高质量代码，它是针对软件开发中经常遇到的...

                                
                                
                            



                                    
模板方法模式-封装一套算法流程

                                
模板方法模式在一个方法中定义一个算法的骨架，而将一些步骤延迟到子类中，使得子类可以在...

                                
                                
                            



                                    
迭代器模式-统一集合的遍历方式

                                
迭代器模式提供了一种方法，用于遍历集合对象中的元素，而又不暴露其内部的细节。

                                
                                
                            







                                    
单例模式的五种实现方式及优缺点

                                
单例模式（Singleton Design Pattern）保证一个类只能有一个实例，并提供一个全局访问点。

                                
                                
                            



                                    
组合模式-统一的处理个别对象与组合对象

                                
组合模式可以将对象组合成树形结构来表示“整体-部分”的层次结构，使得客户可以用一致的方...

                                
                                
                            



                                    
装饰者模式-动态的包装原有对象的行为

                                
装饰者模式能够更灵活的，动态的给对象添加其它功能，而不需要修改任何现有的底层代码。

                                
                                
                            



                                    
观察者模式-将消息通知给观察者

                                
观察者模式（Observer Design Pattern）定义了对象之间的一对多依赖，当对象状态改变的时候...

                                
                                
                            



                                    
代理模式-访问对象的代理而非其本身

                                
代理模式为对象提供一个代理，来控制对该对象的访问。代理模式在不改变原始类代码的情况下...

                                
                                
                            







            

          

        

        
        
        
        

          
          

            

              

                
                
算法设计模式多媒体技术正则表达式ElasticsearchFlinkHadoopIDE

                

              

            

          

          
         
          

            

              
 



              

            

          

          
          
          
          

            

              

                
                
              

            

          

          


          
          

            

              

                
                
受约束摘*day25Java常用类库置信lamda留存持续录入年后正则表达式303.17regularexpre匹多模适20130322基础理论pathmunge涵义reectok需要转义的特资源分享validationex简明魔法里弄形如源码实现完备actionscript