[Adapdev-commits] Adapdev/src/Adapdev.Data.Tests SchemaBuilderTest.cs,1.3,1.4

[Sean M. <int...@us...>]

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.Data.Tests
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2143/src/Adapdev.Data.Tests

Modified Files:
	SchemaBuilderTest.cs 
Log Message:
- Broke up SchemaBuilder into multiple implementations
- Upgraded mySql driver to 1.0.5

Index: SchemaBuilderTest.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data.Tests/SchemaBuilderTest.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** SchemaBuilderTest.cs	13 Apr 2005 04:23:36 -0000	1.3
--- SchemaBuilderTest.cs	18 Sep 2005 03:04:45 -0000	1.4
***************
*** 15,30 ****
  	{
  
! 		private string _connectionString = "Provider=sqloledb;Data Source=localhost;Initial Catalog=northwind;User Id=sa;Password=;";
  
! 		[Test,Ignore("")]
! 		public void PrintForeignKeys()
  		{
! 			Console.WriteLine(SchemaBuilder.PrintOleDbSchema(this._connectionString, System.Data.OleDb.OleDbSchemaGuid.Foreign_Keys).ToString());
  		}
  
  		[Test]
! 		public void BuildSchema()
  		{
! 			DatabaseSchema ds = SchemaBuilder.CreateDatabaseSchema(this._connectionString);
  			Assert.AreEqual(29, ds.Tables.Count, "Northwind should have 29 tables / views.");
  			Assert.IsTrue(ds.Tables.Contains("Orders"));
--- 15,34 ----
  	{
  
! 		private string _oledbConnectionString = "Provider=sqloledb;Data Source=localhost;Initial Catalog=northwind;User Id=sa;Password=;";
! 		private string _sqlserverConnectionString = "Data Source=localhost; Initial Catalog=northwind; User ID=sa; Password=; Trusted_Connection=false;";
! 		private string _mysqlConnectionString = "Data Source=localhost;Database=codus_test;User ID=;Password=;";
  
! 		[Test]
! 		public void BuildOleDbSchema()
  		{
! 			DatabaseSchema ds = SchemaBuilder.CreateDatabaseSchema(this._oledbConnectionString, Adapdev.Data.DbType.SQLSERVER, Adapdev.Data.DbProviderType.OLEDB);
! 			Assert.AreEqual(29, ds.Tables.Count, "Northwind should have 29 tables / views.");
! 			Assert.IsTrue(ds.Tables.Contains("Orders"));
  		}
  
  		[Test]
! 		public void BuildSqlServerSchema()
  		{
! 			DatabaseSchema ds = SchemaBuilder.CreateDatabaseSchema(this._oledbConnectionString, Adapdev.Data.DbType.SQLSERVER, Adapdev.Data.DbProviderType.OLEDB);
  			Assert.AreEqual(29, ds.Tables.Count, "Northwind should have 29 tables / views.");
  			Assert.IsTrue(ds.Tables.Contains("Orders"));
***************
*** 32,35 ****
--- 36,55 ----
  
  		[Test]
+ 		public void BuildMySqlSchema()
+ 		{
+ 			DatabaseSchema ds = SchemaBuilder.CreateDatabaseSchema(this._mysqlConnectionString, Adapdev.Data.DbType.MYSQL, Adapdev.Data.DbProviderType.MYSQL);
+ 			Assert.AreEqual(4, ds.Tables.Count, "codus_test should have 4 tables");
+ 			Assert.IsTrue(ds.Tables.Contains("alldatatypes"));
+ 		}
+ 
+ 		[Test,Ignore("")]
+ 		public void PrintMySqlSchema()
+ 		{
+ 			int i = 0;
+ 			Console.WriteLine(new MySqlSchemaBuilder(null, ref i).PrintReaderSchema(this._mysqlConnectionString, "alldatatypes"));
+ 		}
+ 
+ 
+ 		[Test]
  		public void ProviderConfig() {
  			ProviderConfig pc = new ProviderConfig();