public void TestI() { var obj = new DbTable(new string[] { "Name", "Age", "Job" }); string[] Names = { "Mike", "Nike", "Jess", "Eric", "Tram" }; string[][] Values = { new string[] { "Mike", "15", "Student" }, new string[] { "Nike", "12", "Student" }, new string[] { "Jess", "12", "Student" }, new string[] { "Eric", "11", "Student" }, new string[] { "Tram", "12", "Teacher" } }; obj.AddEntry(Names, Values); Assert.IsTrue(obj.Count == 5); obj.Export("test.dbtable"); obj.Dispose(); obj = new DbTable("test.dbtable"); Assert.IsTrue(obj.Count == 5); Assert.IsTrue(obj.GetFieldLength == 3); Assert.IsTrue(obj.GetEntriesNames.Length == 5); Assert.IsTrue(obj.GetEntriesNames[0] == "Mike"); Assert.IsTrue(obj.GetEntriesNames[1] == "Nike"); Assert.IsTrue(obj.GetEntriesNames[4] == "Tram"); obj.Dispose(); }
public void TestE() { var obj = new DbTable(new string[] { "Name", "Age", "Job" }); // Add multiple entries at the same time string[] Names = { "Mike", "Nike", "Jess", "Eric", "Tram" }; string[][] Values = { new string[] { "Mike", "15", "Student" }, new string[] { "Nike", "12", "Student" }, new string[] { "Jess", "12", "Student" }, new string[] { "Eric", "11", "Student" }, new string[] { "Tram", "12", "Teacher" } }; obj.AddEntry(Names, Values); Assert.IsTrue(obj.Count == 5); Assert.IsTrue(obj.GetFieldLength == 3); // Remove multiple entries obj.RemoveEntry(Names); Assert.IsTrue(obj.Count == 0); Assert.IsTrue(obj.GetFieldLength == 3); obj.Dispose(); }
public void TestC() { DbTable obj = new DbTable(new string[] { "Name", "Age", "Job" }); // Add entries one by one obj.AddEntry("Mike", new string[] { "Mike", "15", "Student" }); obj.AddEntry("Nike", new string[] { "Nike", "12", "Student" }); obj.AddEntry("Jess", new string[] { "Jess", "12", "Student" }); obj.AddEntry("Eric", new string[] { "Eric", "11", "Student" }); obj.AddEntry("Tram", new string[] { "Tram", "12", "Teacher" }); Assert.IsTrue(obj.Count == 5); Assert.IsTrue(obj.GetFieldLength == 3); Assert.IsTrue(obj.GetEntriesNames.Length == 5); Assert.IsTrue(obj.GetEntriesNames[0] == "Mike"); Assert.IsTrue(obj.GetEntriesNames[1] == "Nike"); Assert.IsTrue(obj.GetEntriesNames[4] == "Tram"); obj.Dispose(); obj = new DbTable(new string[] { "Name", "Age", "Job" }); // Add multiple entries at the same time string[] Names = { "Mike", "Nike", "Jess", "Eric", "Tram" }; string[][] Values = { new string[] { "Mike", "15", "Student" }, new string[] { "Nike", "12", "Student" }, new string[] { "Jess", "12", "Student" }, new string[] { "Eric", "11", "Student" }, new string[] { "Tram", "12", "Teacher" } }; obj.AddEntry(Names, Values); Assert.IsTrue(obj.Count == 5); Assert.IsTrue(obj.GetFieldLength == 3); Assert.IsTrue(obj.GetEntriesNames.Length == 5); Assert.IsTrue(obj.GetEntriesNames[0] == "Mike"); Assert.IsTrue(obj.GetEntriesNames[1] == "Nike"); Assert.IsTrue(obj.GetEntriesNames[4] == "Tram"); obj.Dispose(); }
public void TestA() { DbTable obj = new DbTable(new string[] { "Name", "Age" }); Assert.IsTrue(obj.FieldNames[0] == "Name"); Assert.IsFalse(obj.FieldNames[1] != "Age"); Assert.IsTrue(obj.GetFieldLength == 2); Assert.IsTrue(obj.Count == 0); obj.Dispose(); }
public void TestB() { DbTable obj = new DbTable(new string[] { "Name", "Age" }); obj.AddEntry("Mike", new string[] { "Mike", "15" }); Assert.IsTrue(obj.Count == 1); Assert.IsTrue(obj.GetFieldLength == 2); Assert.IsTrue(obj["Mike"][0] == "Mike"); Assert.IsTrue(obj["Mike"][1] == "15"); obj.Dispose(); }
public void TestF() { var obj = new DbTable(new string[] { "Name", "Age", "Job" }); // Add multiple entries at the same time string[] Names = { "Mike", "Nike", "Jess", "Eric", "Tram" }; string[][] Values = { new string[] { "Mike", "15", "Student" }, new string[] { "Nike", "12", "Student" }, new string[] { "Jess", "12", "Student" }, new string[] { "Eric", "11", "Student" }, new string[] { "Tram", "12", "Teacher" } }; obj.AddEntry(Names, Values); Assert.IsTrue(obj["Mike"][1] == "15"); Assert.IsTrue(obj["Nike"][1] == "12"); Assert.IsTrue(obj["Nike"][2] == "Student"); // Replace single entry string[] Single = { "Mike", "30", "Lawyers" }; obj.ReplaceEntry("Mike", Single); Assert.IsTrue(obj["Mike"][1] == "30"); Assert.IsTrue(obj["Mike"][2] == "Lawyers"); // Replace multiple entries string[][] NewValues = { new string[] { "Mike", "10", "Student" }, new string[] { "Nike", "25", "Hackers" }, new string[] { "Jess", "11", "Student" }, new string[] { "Eric", "09", "Student" }, new string[] { "Tram", "10", "Teacher" } }; obj.ReplaceEntry(Names, NewValues); Assert.IsTrue(obj["Mike"][1] == "10"); Assert.IsTrue(obj["Nike"][1] == "25"); Assert.IsTrue(obj["Nike"][2] == "Hackers"); obj.Dispose(); }
public void TestD() { DbTable obj = new DbTable(new string[] { "Name", "Age" }); // Add a single entry obj.AddEntry("Mike", new string[] { "Mike", "15" }); Assert.IsTrue(obj.Count == 1); Assert.IsTrue(obj.GetFieldLength == 2); Assert.IsTrue(obj["Mike"][0] == "Mike"); Assert.IsTrue(obj["Mike"][1] == "15"); // Remove that entry obj.RemoveEntry("Mike"); Assert.IsTrue(obj.Count == 0); Assert.IsTrue(obj.GetFieldLength == 2); obj.Dispose(); }