public void GetOne()
{
Logsystem log = db.Logsystem.Select(e => e).FirstOrDefault();
UtilReflection.print_r(log);
Assert.IsNotNull(log);
}
public void InsertTestLogSystem()
{
//先默认插入10条Logsystem记录
Logsystem logsystem = new Logsystem();
int Count = db.Logsystem.Count();
for (int i = 0; i < 10; i++)
{
logsystem = new Logsystem();
logsystem.ID = new Guid(originalLogIDs[i]);
logsystem.Message = originalMessage;
logsystem.Ident = "4";
logsystem.Priority = "4";
logsystem.Logtime = DateTime.Now;
db.Logsystem.Add(logsystem);
}
for (int i = 0; i < 90; i++)
{
logsystem = new Logsystem();
logsystem.ID = Guid.NewGuid();
logsystem.Message = originalMessage;
logsystem.Ident = "4";
logsystem.Priority = "4";
logsystem.Logtime = DateTime.Now;
db.Logsystem.Add(logsystem);
}
db.SaveChanges();
Assert.IsTrue(Count == db.Logsystem.Count() - 100);
}
public void DeleteByID()
{
Guid logID = new Guid(originalLogIDs[0]);
Logsystem log = db.Logsystem.Find(logID);
Assert.IsNotNull(log);
db.Logsystem.Remove(log);
db.SaveChanges();
int Count = db.Logsystem.Count(e => e.ID.Equals(logID));
Assert.IsTrue(Count == 0);
}
public void GetByIDLogSystem()
{
Guid logID = new Guid(originalLogID);
Logsystem log = db.Logsystem.Find(logID);
if (log != null)
{
UtilReflection.print_r(log);
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
public void DeleteLogSystem()
{
//测试 2 获取第7，8条数据的GUID
string IDs = originalLogIDs[7] + "," + originalLogIDs[8];
int Count = db.Logsystem.Count();
string[] ID_Arr = IDs.Split(new char[1] {
','
}, StringSplitOptions.RemoveEmptyEntries);
foreach (var ID in ID_Arr)
{
Logsystem toDelete = db.Logsystem.Find(ID);
Console.WriteLine(toDelete.ID + toDelete.Message + ":" + toDelete.Logtime);
db.Logsystem.Remove(toDelete);
}
db.SaveChanges();
Assert.IsTrue(Count == db.Logsystem.Count() + 2);
}
public void SaveLogsystem()
{
Logsystem logsystem = new Logsystem();
logsystem.ID = new Guid(originalLogID);
logsystem.Message = originalMessage;
logsystem.Ident = "4";
logsystem.Priority = "4";
logsystem.Logtime = DateTime.Now;
db.Logsystem.Add(logsystem);
db.SaveChanges();
// Test 1
Assert.IsNotNull(logsystem.ID);
//Test 2
var newFound = db.Logsystem.Find(logsystem.ID);
Assert.IsNotNull(newFound);
}
