public static void QueryInsertQuery_TypedRow(ICRUDDataStore store) { var query = new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff") }; var result = store.Load( query ); Assert.AreEqual(1, result.Count); var rowset = result[0]; Assert.AreEqual(0, rowset.Count); var row = new Patient(); row.SSN = "999-88-9012"; row.First_Name = "Jack"; row.Last_Name = "Kozloff"; row.DOB = new DateTime(1980, 1, 12); Assert.IsNull( row.Validate()); store.Insert(row); result = store.Load( query ); Assert.AreEqual(1, result.Count); rowset = result[0]; Assert.AreEqual(1, rowset.Count); Assert.IsInstanceOf<Patient>( rowset[0] ); Assert.AreEqual("Jack", rowset[0]["First_Name"]); }
public static void QueryInsertQuery_DynamicRow(ICRUDDataStore store) { var query = new Query<DynamicRow>("CRUD.Patient.List") { new Query.Param("LN", "%ruman") }; var result = store.Load( query ); Assert.AreEqual(1, result.Count); var rowset = result[0]; Assert.AreEqual(0, rowset.Count); var row = new Patient(); row.SSN = "999-88-9012"; row.First_Name = "Mans"; row.Last_Name = "Skolopendruman"; row.DOB = new DateTime(1970, 1, 12); Assert.IsNull( row.Validate()); store.Insert(row); var row2 = store.LoadRow( query ); Assert.IsNotNull(row2); Assert.IsInstanceOf<DynamicRow>( row2 ); Assert.AreEqual("Mans", row2["First_Name"]); }
public static void ASYNC_InsertThenUpsert_TypedRow(ICRUDDataStore store) { for(var i=0; i<10; i++) { store.InsertAsync( new Patient { SSN = i.ToString(), First_Name = "Jack", Last_Name = "Kozloff_"+i, DOB = new DateTime(1980, 1, 12) }).Wait(); } var result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_5") } )[0]; Assert.AreEqual(1, result.Count); var row = result[0] as Patient; Assert.AreEqual("5", row.SSN); Assert.AreEqual(null, row.Phone); row.Phone = "22-94-92"; store.UpsertAsync( row ).Wait(); result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_5") } )[0]; Assert.AreEqual(1, result.Count); Assert.AreEqual("22-94-92", result[0]["Phone"]); result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_%") } )[0]; Assert.AreEqual(10, result.Count); row = new Patient { SSN = "-100", First_Name = "Vlad", Last_Name = "Lenin", DOB = new DateTime(1871, 4, 20) }; store.UpsertAsync(row).Wait(); result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%") } )[0]; Assert.AreEqual(11, result.Count); result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "Lenin") } )[0]; Assert.AreEqual(1, result.Count); Assert.AreEqual("Vlad", result[0]["First_Name"]); }
public static Patient GetDefaultPatient() { var patient = new Patient { First_Name = "Ivan", Last_Name ="Poddubny", SSN = "123456", City = "New York", Address1 = "addr_1", Address2 = "addr_2", Amount = 123, Phone = "(123)456-78-90", State = "NY", DOB = new DateTime(1984, 11, 12), Note = "...", Zip = "350004" }; return patient; }