public static void QueryInsertQuery(ICrudDataStore store)
{
var query = new Query("CRUD.Queries.Patient.List")
{
new Query.Param("LN", "%loff")
};
var result = store.Load(query);
Aver.AreEqual(1, result.Count);
var rowset = result[0];
Aver.AreEqual(0, rowset.Count);
var row = new DynamicDoc(rowset.Schema);
row["ssn"] = "999-88-9012";
row["First_Name"] = "Jack";
row["Last_Name"] = "Kozloff";
row["DOB"] = new DateTime(1980, 1, 12);
Aver.IsNull(row.Validate());
store.Insert(row);
result = store.Load(query);
Aver.AreEqual(1, result.Count);
rowset = result[0];
Aver.AreEqual(1, rowset.Count);
Aver.AreObjectsEqual("Jack", rowset[0]["First_Name"]);
}
public static void InsertInTransaction_Rollback_TypedRow(ICrudDataStore store)
{
var transaction = store.BeginTransaction();
for (var i = 0; i < 25; i++)
{
transaction.Insert(new Patient
{
SSN = "999-88-9012",
First_Name = "Jack",
Last_Name = "Kozloff" + i,
DOB = new DateTime(1980, 1, 12)
});
}
var result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff%")
})[0];
Aver.AreEqual(0, result.Count);
transaction.Rollback();
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff%")
})[0];
Aver.AreEqual(0, result.Count);
}
public static void QueryInsertQuery_TypedRowDerived(ICrudDataStore store)
{
var query = new Query("CRUD.Queries.Patient.List", typeof(SuperPatient))
{
new Query.Param("LN", "%loff")
};
var result = store.Load(query);
Aver.AreEqual(1, result.Count);
var rowset = result[0];
Aver.AreEqual(0, rowset.Count);
var row = new SuperPatient();
row.SSN = "999-88-9012";
row.First_Name = "Jack";
row.Last_Name = "Kozloff";
row.DOB = new DateTime(1980, 1, 12);
row.Superman = true;
Aver.IsNull(row.Validate());
store.Insert(row);
result = store.Load(query);
Aver.AreEqual(1, result.Count);
rowset = result[0];
Aver.AreEqual(1, rowset.Count);
Aver.IsTrue(rowset[0] is SuperPatient);
Aver.AreObjectsEqual("Jack", rowset[0]["First_Name"]);
}
public static void QueryInsertQuery_DynamicRow(ICrudDataStore store)
{
var query = new Query <DynamicDoc>("CRUD.Queries.Patient.List")
{
new Query.Param("LN", "%ruman")
};
var result = store.Load(query);
Aver.AreEqual(1, result.Count);
var rowset = result[0];
Aver.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);
Aver.IsNull(row.Validate());
store.Insert(row);
var row2 = store.LoadDoc(query);
Aver.IsNotNull(row2);
Aver.IsTrue(row2 is DynamicDoc);
Aver.AreObjectsEqual("Mans", row2["First_Name"]);
}
public static void InsertManyUsingLogChanges_TypedRow(ICrudDataStore store)
{
var rowset = new Rowset(Schema.GetForTypedDoc(typeof(Patient)));
rowset.LogChanges = true;
for (var i = 0; i < 1000; i++)
{
rowset.Insert(new Patient
{
SSN = "999-88-9012",
First_Name = "Jack",
Last_Name = "Kozloff" + i,
DOB = new DateTime(1980, 1, 12)
});
}
for (var i = 0; i < 327; i++)
{
rowset.Insert(new Patient
{
SSN = "999-88-9012",
First_Name = "Jack",
Last_Name = "Abramovich" + i,
DOB = new DateTime(2001, 1, 12)
});
}
store.Save(rowset);
var result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff%")
})[0];
Aver.AreEqual(1000, result.Count);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%ovich%")
})[0];
Aver.AreEqual(327, result.Count);
}
public static async Task ASYNC_InsertThenUpdate_TypedRow(ICrudDataStore store)
{
for (var i = 0; i < 10; i++)
{
await store.InsertAsync(new Patient
{
SSN = i.ToString(),
First_Name = "Jack",
Last_Name = "Kozloff_" + i,
DOB = new DateTime(1980, 1, 12)
});
}
var result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Aver.AreEqual(1, result.Count);
var row = result[0] as Patient;
Aver.AreEqual("5", row.SSN.Trim());
row.Last_Name = "Gagarin";
await store.UpdateAsync(row);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Aver.AreEqual(0, result.Count);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%garin")
})[0];
Aver.AreEqual(1, result.Count);
Aver.AreObjectsEqual("5", result[0]["SSN"].AsString().Trim());
Aver.AreObjectsEqual("Gagarin", result[0]["Last_Name"]);
}
public static void InsertThenDelete_TypedRow(ICrudDataStore store)
{
for (var i = 0; i < 10; i++)
{
store.Insert(new Patient
{
SSN = i.ToString(),
First_Name = "Jack",
Last_Name = "Kozloff_" + i,
DOB = new DateTime(1980, 1, 12)
});
}
var result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Aver.AreEqual(1, result.Count);
var row = result[0] as Patient;
Aver.AreEqual("5", row.SSN.Trim());
store.Delete(row);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Aver.AreEqual(0, result.Count);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_%")
})[0];
Aver.AreEqual(9, result.Count);
}
public static void ExecuteCustomCommandHandler(ICrudDataStore store)
{
var query = new Query("CustomTestCommandHandler")
{
new Query.Param("Msg", "we are on the moon!")
};
var result = store.Load(query);
Aver.AreEqual(1, result.Count);
var rowset = result[0];
Aver.AreEqual(2, rowset.Count);
Aver.AreEqual("Jack", rowset[0]["First_Name"].AsString());
Aver.AreEqual("Mary", rowset[1]["First_Name"].AsString());
Aver.AreEqual("we are on the moon!", rowset[1]["Address1"].AsString());
}
public static async Task ASYNC_InsertThenUpsert_TypedRow(ICrudDataStore store)
{
for (var i = 0; i < 10; i++)
{
await store.InsertAsync(new Patient
{
SSN = i.ToString(),
First_Name = "Jack",
Last_Name = "Kozloff_" + i,
DOB = new DateTime(1980, 1, 12)
});
}
var result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Aver.AreEqual(1, result.Count);
var row = result[0] as Patient;
Aver.AreEqual("5", row.SSN.Trim());
Aver.AreEqual(null, row.Phone);
row.Phone = "22-94-92";
await store.UpsertAsync(row);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Aver.AreEqual(1, result.Count);
Aver.AreObjectsEqual("22-94-92", result[0]["Phone"]);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_%")
})[0];
Aver.AreEqual(10, result.Count);
row = new Patient
{
SSN = "-100",
First_Name = "Vlad",
Last_Name = "Lenin",
DOB = new DateTime(1871, 4, 20)
};
await store.UpsertAsync(row);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%")
})[0];
Aver.AreEqual(11, result.Count);
result = store.Load(new Query("CRUD.Queries.Patient.List", typeof(Patient))
{
new Query.Param("LN", "Lenin")
})[0];
Aver.AreEqual(1, result.Count);
Aver.AreObjectsEqual("Vlad", result[0]["First_Name"]);
}