public void GivenInitialDataset()
{
using (var ctx = new GlossaryEntities())
{
if (ctx.Definitions.Any())
{
var defs = from d in ctx.Definitions select d;
ctx.Definitions.RemoveRange(defs);
}
ctx.Definitions.AddRange(
new Definition[]
{
new Definition {
Term = "abyssal plain", TermDefinition = "The ocean floor off the continental margin, usually very flat with a slight slope."
},
new Definition {
Term = "accrete", TermDefinition = "To add terranes (small land masses or pieces of crust) to another, usually larger, land mass."
},
new Definition {
Term = "alkaline", TermDefinition = "Term pertaining to highly basic, as opposed to acidic, substance"
}
});
ctx.SaveChanges();
}
}
public void ListDefinitions()
{
using (var ctx = new GlossaryEntities())
{
var defs = (from d in ctx.Definitions select d).ToList();
defs.ForEach(d => Debug.WriteLine($"{d.DefinitionId} {d.Term} {d.TermDefinition}"));
Assert.IsTrue(defs.Count >= 3);
}
}
private void InitializeDatabase()
{
using (var db = new GlossaryEntities())
{
foreach (var item in db.Glossary.ToList())
{
db.Glossary.Remove(item);
}
db.SaveChanges();
}
}
public void CreateTest()
{
var item = new Glossary {
Term = "Term1", Definition = "Def1"
};
var result = (JsonResult)controller.Create(new DataSourceRequest(), item);
using (var db = new GlossaryEntities())
{
var glossaryRecords = db.Glossary.ToList();
Assert.IsNotNull(glossaryRecords);
Assert.AreEqual(glossaryRecords.Count, 1);
Assert.AreEqual(glossaryRecords.First().Term, "Term1");
Assert.AreEqual(glossaryRecords.First().Definition, "Def1");
}
}
public void UpdateTest()
{
using (var db = new GlossaryEntities())
{
db.Glossary.Add(new Glossary {
Term = "Term1", Definition = "Def1"
});
db.SaveChanges();
var item = db.Glossary.First();
item.Term = "Term2";
var result = (JsonResult)controller.Update(new DataSourceRequest(), item);
var item2 = db.Glossary.FirstOrDefault(q => q.Id == item.Id);
Assert.IsNotNull(item2);
Assert.AreEqual(item2.Term, "Term2");
}
}
private void ReadInitialDefs()
{
using (var db = new GlossaryEntities())
{
foreach (var def in GivenTerms())
{
var existing = (from d in db.Definitions where d.Term == def.Term select d).FirstOrDefault();
if (existing == null)
{
db.Definitions.Add(new Definition {
Term = def.Term, TermDefinition = def.TermDefinition
});
}
else
{
existing.TermDefinition = def.TermDefinition;
}
}
db.SaveChanges();
}
}
public void ReadTest()
{
using (var db = new GlossaryEntities())
{
db.Glossary.Add(new Glossary {
Term = "Term1", Definition = "Def1"
});
db.Glossary.Add(new Glossary {
Term = "Term2", Definition = "Def2"
});
db.SaveChanges();
}
var result = (JsonResult)controller.Read(new DataSourceRequest());
Assert.IsNotNull(result);
Assert.IsInstanceOfType(result.Data, typeof(DataSourceResult));
Assert.IsNotNull(result.Data);
Assert.IsInstanceOfType(((DataSourceResult)result.Data).Data, typeof(IEnumerable));
Assert.IsNotNull(((DataSourceResult)result.Data).Data);
Assert.AreEqual(((List <Glossary>)((DataSourceResult)result.Data).Data).Count, 2);
}
