public void Test_if_database_was_mapped_to_Fake_and_saved_in_XML() { // Test for SQL Server 13.0.4422.0 var dbConn = new DatabaseConnectionMSSQL() { Database = FakeDatabaseFactory.NewDatabase("Name_which_will_be_replaced_after_mapping"), Connection = new SqlConnection() { ConnectionString = $"" + $"Server=mssql6.gear.host;" + $"Database=testdb49;" + $"User Id=testdb49;" + $"Password=;" } }; dbConn.ToFake("testdb49"); // This weird name is an actual Database Name var fakeDb = dbConn.Database; var fileStream = new FileStream("db_mssql.xml", FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); using (var writer = XmlWriter.Create(fileStream)) { var serializer = new FakeDbSerializer <XmlReader, XmlWriter>() { Database = fakeDb, Configuration = new FakeDbXMLByColumnConfiguration() }; serializer.WriteDatabase(writer); } Assert.True(fakeDb.Tables.Count() > 0); }
public void Test_if_database_was_mapped_to_Fake_and_saved_in_XML() { var dbConn = new DatabaseConnectionMySQL() { Database = FakeDatabaseFactory.NewDatabase("Name_which_will_be_replaced_after_mapping"), Connection = new MySqlConnection() { ConnectionString = $"" + $"Data Source=sql11.freemysqlhosting.net;" + $"Initial Catalog=INFORMATION_SCHEMA;" + // Start in Database where all required informations about all Databases on Server are stored $"User id=sql11192873;" + $"Password=;" } }; dbConn.ToFake("sql11192873"); // This weird name is an actual Database Name var fakeDb = dbConn.Database; var fileStream = new FileStream("db_mysql.xml", FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); using (var writer = XmlWriter.Create(fileStream)) { var serializer = new FakeDbSerializer <XmlReader, XmlWriter>() { Database = fakeDb, Configuration = new FakeDbXMLByColumnConfiguration() }; serializer.WriteDatabase(writer); } Assert.True(fakeDb.Tables.Count() > 0); }
public void Try_to_write_Database_to_JSON() { try { File.Delete(PATH); } catch (Exception) { } var db = FakeDatabaseData.GetDatabaseWithData(); using (JsonWriter writer = new JsonTextWriter(File.CreateText(PATH))) { var serializer = new FakeDbSerializer <JsonReader, JsonWriter>() { Database = db, Configuration = new FakeDbJSONByColumnConfiguration() }; serializer.WriteDatabase(writer); } Assert.True(db != null); }
public void Test_if_IFakeDatabase_was_saved_to_file_using_DataSet() { try { File.Delete(PATH); } catch (Exception) { } var db = FakeDatabaseData.GetDatabaseWithData(); var fileStream = new FileStream(PATH, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); using (var writer = XmlWriter.Create(fileStream)) { var serializer = new FakeDbSerializer <XmlReader, XmlWriter>() { Database = db, Configuration = new FakeDbDataSetConfiguration() }; serializer.WriteDatabase(writer); } Assert.True(fileStream != null); }
public void Try_to_read_IFakeDatabase_from_file_using_DataSet() { try { File.Delete(PATH_2); } catch (Exception) { } var db = FakeDatabaseData.GetDatabaseWithData(); var fileStream = new FileStream(PATH_2, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); var serializer = new FakeDbSerializer <XmlReader, XmlWriter>() { Database = db, Configuration = new FakeDbDataSetConfiguration() }; lock (new object()) { serializer.WriteDatabase(XmlWriter.Create(fileStream)); fileStream.Flush(); fileStream.Close(); } // Prepare to read serializer.Database = FakeDatabaseFactory.NewDatabase("New empty Database for Read Test"); fileStream = new FileStream(PATH_2, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite); serializer.ReadDatabase(XmlReader.Create(fileStream)); var dbReaded = serializer.Database; Assert.True(db != null); Assert.Equal("Test Database", db.Name); Assert.True(db.Tables.Count() == 2); Assert.Equal("Poland", db["Countries"]["CountryName"][0]); }