public static void ASYNC_GetSchemaAndTestVariousTypes(ICRUDDataStore store)
{
var schema = store.GetSchemaAsync(new Query("CRUD.Types.Load")).Result;
var row = new DynamicRow(schema);
row["GDID"] = new GDID(0, 145);
row["SCREEN_NAME"] = "User1";
row["STRING_NAME"] = "Some user 1";
row["CHAR_NAME"] = "Some user 2";
row["BOOL_CHAR"] = 'T';
row["BOOL_BOOL"] = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980,12,1);
store.Insert( row );
var row2 = store.LoadOneRow(new Query("CRUD.Types.Load", new GDID(0, 145)));
Assert.NotNull(row2);
Assert.AreEqual(145, row2["GDID"]);
Assert.AreEqual("User1", row2["Screen_Name"]);
Assert.AreEqual("Some user 1", row2["String_Name"]);
Assert.AreEqual("Some user 2", row2["Char_Name"]);
Assert.AreEqual(true, row2["BOOL_Char"].AsBool());
Assert.AreEqual(true, row2["BOOL_BOOL"].AsBool());
Assert.AreEqual(145670.23m, row2["Amount"]);
Assert.AreEqual(1980, row2["DOB"].AsDateTime().Year);
}
public static void UpsertWithPredicate(ICRUDDataStore store)
{
var patient = TestLogic.GetDefaultPatient();
var affected = store.Insert(patient);
Assert.AreEqual(1, affected);
var query = new Query <Patient>("CRUD.Patient.List")
{
new Query.Param("LN", "%%")
};
var persisted = store.LoadRow(query);
persisted.Zip = "010203";
persisted.First_Name = "John";
persisted.Last_Name = "Smith";
affected = store.Upsert(persisted, (r, k, f) => f.Name != "Zip");
Assert.AreEqual(2, affected);
var updated = store.LoadRow(query);
Assert.IsNotNull(updated);
Assert.AreEqual(persisted.SSN, updated.SSN);
Assert.AreEqual(persisted.City, updated.City);
Assert.AreEqual(persisted.Address1, updated.Address1);
Assert.AreEqual(persisted.Address2, updated.Address2);
Assert.AreEqual(persisted.Amount, updated.Amount);
Assert.AreEqual(persisted.Doctor_Phone, updated.Doctor_Phone);
Assert.AreEqual(persisted.Phone, updated.Phone);
Assert.AreEqual(persisted.DOB, updated.DOB);
Assert.AreEqual(persisted.Note, updated.Note);
Assert.AreEqual(persisted.First_Name, updated.First_Name);
Assert.AreEqual(persisted.Last_Name, updated.Last_Name);
Assert.AreEqual(patient.Zip, updated.Zip); // notice ZIP remains the same
}
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 InsertWithPredicate(ICRUDDataStore store)
{
var patient = TestLogic.GetDefaultPatient();
var affected = store.Insert(patient, (r, k, f) => f.Name != "State" && f.Name != "Zip");
Assert.AreEqual(1, affected);
var query = new Query <Patient>("CRUD.Patient.List")
{
new Query.Param("LN", "%%")
};
var persisted = store.LoadRow(query);
Assert.IsNotNull(persisted);
Assert.AreEqual(patient.First_Name, persisted.First_Name);
Assert.AreEqual(patient.Last_Name, persisted.Last_Name);
Assert.AreEqual(patient.SSN, persisted.SSN);
Assert.AreEqual(patient.City, persisted.City);
Assert.AreEqual(patient.Address1, persisted.Address1);
Assert.AreEqual(patient.Address2, persisted.Address2);
Assert.AreEqual(patient.Amount, persisted.Amount);
Assert.AreEqual(patient.Doctor_Phone, persisted.Doctor_Phone);
Assert.AreEqual(patient.Phone, persisted.Phone);
Assert.AreEqual(patient.DOB, persisted.DOB);
Assert.AreEqual(patient.Note, persisted.Note);
Assert.IsNull(persisted.State);
Assert.IsNull(persisted.Zip);
}
public static void QueryInsertQuery(ICRUDDataStore store)
{
var query = new Query("CRUD.Patient.List")
{
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 DynamicRow(rowset.Schema);
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.AreEqual("Jack", rowset[0]["First_Name"]);
}
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 TypedRowTestVariousTypes(ICRUDDataStore store)
{
var row = new Types();
row["GDID"] = new GDID(0, 234);
row["SCREEN_NAME"] = "User1";
row["STRING_NAME"] = "Some user 1";
row["CHAR_NAME"] = "Some user 2";
row["BOOL_CHAR"] = true; //notice TRUE for both char and bool columns below
row["BOOL_BOOL"] = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980, 12, 1);
store.Insert(row);
var row2 = store.LoadOneRow(new Query("CRUD.Types.Load", new GDID(0, 234)));
Assert.NotNull(row2);
Assert.AreEqual(234, row2["GDID"]);
Assert.AreEqual("User1", row2["Screen_Name"]);
Assert.AreEqual("Some user 1", row2["String_Name"]);
Assert.AreEqual("Some user 2", row2["Char_Name"]);
Assert.AreEqual(true, row2["BOOL_Char"].AsBool());
Assert.AreEqual(true, row2["BOOL_BOOL"].AsBool());
Assert.AreEqual(145670.23m, row2["Amount"]);
Assert.AreEqual(1980, row2["DOB"].AsDateTime().Year);
}
public static void GetSchemaAndTestVariousTypes(ICRUDDataStore store)
{
var schema = store.GetSchema(new Query("CRUD.Types.Load"));
var row = new DynamicRow(schema);
row["GDID"] = new GDID(0, 145);
row["SCREEN_NAME"] = "User1";
row["STRING_NAME"] = "Some user 1";
row["CHAR_NAME"] = "Some user 2";
row["BOOL_CHAR"] = 'T';
row["BOOL_BOOL"] = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980, 12, 1);
store.Insert(row);
var row2 = store.LoadOneRow(new Query("CRUD.Types.Load", new GDID(0, 145)));
Assert.NotNull(row2);
Assert.AreEqual(145, row2["GDID"]);
Assert.AreEqual("User1", row2["Screen_Name"]);
Assert.AreEqual("Some user 1", row2["String_Name"]);
Assert.AreEqual("Some user 2", row2["Char_Name"]);
Assert.AreEqual(true, row2["BOOL_Char"].AsBool());
Assert.AreEqual(true, row2["BOOL_BOOL"].AsBool());
Assert.AreEqual(145670.23m, row2["Amount"]);
Assert.AreEqual(1980, row2["DOB"].AsDateTime().Year);
}
public static void QueryInsertQuery(ICRUDDataStore store)
{
var query = new Query("CRUD.Patient.List") { 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 DynamicRow(rowset.Schema);
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.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 UpdateWithPredicate(ICRUDDataStore store)
{
var patient = TestLogic.GetDefaultPatient();
var affected = store.Insert(patient);
Aver.AreEqual(1, affected);
var query = new Query <Patient>("CRUD.Queries.Patient.List")
{
new Query.Param("LN", "%%")
};
var persisted = store.LoadDoc(query);
persisted.Zip = "010203";
persisted.First_Name = "John";
persisted.Last_Name = "Smith";
affected = store.Update(persisted, null, (r, k, f) => f.Name != "First_Name" && f.Name != "Zip");
Aver.AreEqual(1, affected);
var updated = store.LoadDoc(query);
Aver.IsNotNull(updated);
Aver.AreEqual(persisted.SSN, updated.SSN.Trim());
Aver.AreEqual(persisted.City, updated.City);
Aver.AreEqual(persisted.Address1, updated.Address1);
Aver.AreEqual(persisted.Address2, updated.Address2);
Aver.AreEqual(persisted.Amount, updated.Amount);
Aver.AreEqual(persisted.Doctor_Phone, updated.Doctor_Phone.Trim());
Aver.AreEqual(persisted.Phone, updated.Phone.Trim());
Aver.AreEqual(persisted.DOB, updated.DOB);
Aver.AreEqual(persisted.Note, updated.Note);
Aver.AreEqual(patient.First_Name, updated.First_Name);
Aver.AreEqual(persisted.Last_Name, updated.Last_Name);
Aver.AreEqual(patient.Zip, updated.Zip);
}
public static void ASYNC_GetSchemaAndTestVariousTypes(ICRUDDataStore store)
{
var schema = store.GetSchemaAsync(new Query("CRUD.Queries.Types.Load")).Result;
var row = new DynamicDoc(schema);
row["GDID"] = new GDID(0, 145);
row["SCREEN_NAME"] = "User1";
row["STRING_NAME"] = "Some user 1";
row["CHAR_NAME"] = "Some user 2";
row["BOOL_CHAR"] = 'T';
row["BOOL_BOOL"] = 'T';
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980, 12, 1);
store.Insert(row);
var row2 = store.LoadOneDoc(new Query("CRUD.Queries.Types.Load", new GDID(0, 145)));
Aver.IsNotNull(row2);
Aver.AreObjectsEqual(145, row2["GDID"].AsInt());
Aver.AreObjectsEqual("User1", row2["Screen_Name"].AsString().Trim());
Aver.AreObjectsEqual("Some user 1", row2["String_Name"].AsString().Trim());
Aver.AreObjectsEqual("Some user 2", row2["Char_Name"].AsString().Trim());
Aver.AreEqual(true, row2["BOOL_Char"].AsBool());
Aver.AreEqual(true, row2["BOOL_BOOL"].AsBool());
Aver.AreObjectsEqual(145670.23m, row2["Amount"].AsDecimal());
Aver.AreEqual(1980, row2["DOB"].AsDateTime().Year);
}
public static void GetSchemaAndTestFullGDID(ICRUDDataStore store)
{
var schema = store.GetSchema(new Query("CRUD.FullGDID.Load"));
var row = new DynamicRow(schema);
var key = new GDID(179, 1, 1234567890);
Console.WriteLine(key.Bytes.ToDumpString(DumpFormat.Hex));
row["GDID"] = new GDID(179, 1, 1234567890);
Console.WriteLine(((byte[])row["GDID"]).ToDumpString(DumpFormat.Hex));
row["VARGDID"] = new GDID(12, 9, 9876543210);
row["STRING_NAME"] = "DA DA DA!";
store.Insert(row);
var row2 = store.LoadOneRow(new Query("CRUD.FullGDID.Load", key, typeof(FullGDID))) as FullGDID;
Assert.NotNull(row2);
Assert.AreEqual(key, row2.GDID);
Assert.AreEqual(new GDID(12, 9, 9876543210), row2.VARGDID);
Assert.AreEqual("DA DA DA!", row2["String_Name"]);
}
public static void TypedRowTestVariousTypes(ICRUDDataStore store)
{
var row = new Types();
row.GDID = new GDID(0, 234);
row.Screen_Name = "User1";
row.String_Name = "Some user 1";
row.Char_Name = "Some user 2";
row.Bool_Char = true; //notice TRUE for both char and bool columns below
row.Bool_Bool = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980, 12, 1);
row["Age"] = 145;
store.Insert(row);
var row2 = store.LoadRow(new Query <Types>("CRUD.Types.Load", new GDID(0, 234)));
Assert.NotNull(row2);
Assert.AreEqual(new GDID(0, 0, 234), row2.GDID);
Assert.AreEqual("User1", row2.Screen_Name);
Assert.AreEqual("Some user 1", row2.String_Name);
Assert.AreEqual("Some user 2", row2.Char_Name);
Assert.AreEqual(true, row2.Bool_Char.Value);
Assert.AreEqual(true, row2.Bool_Bool.Value);
Assert.AreEqual(145670.23m, row2.Amount);
Assert.AreEqual(1980, row2.DOB.Value.Year);
Assert.AreEqual(145, row2.Age);
row.Age = null;
row.Bool_Bool = null;
row.DOB = null;
store.Update(row);
var row3 = store.LoadRow(new Query <Types>("CRUD.Types.Load", new GDID(0, 234)));
Assert.IsFalse(row3.Age.HasValue);
Assert.IsFalse(row3.Bool_Bool.HasValue);
Assert.IsFalse(row3.DOB.HasValue);
Assert.IsNull(row3["Age"].AsNullableInt());
Assert.IsNull(row3["DOB"].AsNullableDateTime());
Assert.IsNull(row3["Bool_Bool"].AsNullableBool());
}
public static void TypedRowTest_FullGDID(ICRUDDataStore store)
{
var row = new FullGDID();
row.GDID = new GDID(123, 2, 8907893234);
row.VARGDID = row.GDID;
row["STRING_NAME"] = "AAA";
store.Insert(row);
var row2 = store.LoadOneRow(new Query("CRUD.FullGDID.Load", new GDID(123, 2, 8907893234), typeof(FullGDID))) as FullGDID;
Assert.NotNull(row2);
Assert.AreEqual(new GDID(123, 2, 8907893234), row2.GDID);
Assert.AreEqual(new GDID(123, 2, 8907893234), row2.VARGDID);
Assert.AreEqual("AAA", row2["String_Name"]);
}
public static void InsertThenUpdate_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.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);
row.Last_Name = "Gagarin";
store.Update(row);
result = store.Load(new Query("CRUD.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%loff_5")
})[0];
Assert.AreEqual(0, result.Count);
result = store.Load(new Query("CRUD.Patient.List", typeof(Patient))
{
new Query.Param("LN", "%garin")
})[0];
Assert.AreEqual(1, result.Count);
Assert.AreEqual("5", result[0]["SSN"]);
Assert.AreEqual("Gagarin", result[0]["Last_Name"]);
}
public static void Populate_ASYNC_OpenCursor(ICRUDDataStore store)
{
const int CNT = 1000;
for (var i = 0; i < CNT; i++)
{
var patient = new TupleData
{
COUNTER = i,
DATA = i.ToString() + "-DATA"
};
store.Insert(patient);
}
var query = new Query <TupleData>("CRUD.Tuple.LoadAll");
var result = store.LoadOneRowset(query);
Assert.AreEqual(CNT, result.Count);
Assert.AreEqual(0, result[0]["COUNTER"]);
Assert.AreEqual(CNT - 1, result[result.Count - 1]["COUNTER"]);
var task = store.OpenCursorAsync(query)
.ContinueWith(antecedent =>
{
var cursor = antecedent.Result;;
Assert.IsFalse(cursor.Disposed);
var cnt = 0;
foreach (var row in cursor.AsEnumerableOf <TupleData>())
{
cnt++;
}
Assert.AreEqual(CNT, cnt);
Assert.IsTrue(cursor.Disposed); //foreach must have closed the cursor
});
task.Wait();
}
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 TypedRowTest_FullGDID(ICRUDDataStore store)
{
var row = new FullGDID();
row.GDID = new GDID(123, 2, 8907893234);
row.VARGDID = row.GDID;
row["STRING_NAME"] = "AAA";
store.Insert( row );
var row2 = store.LoadOneRow(new Query("CRUD.FullGDID.Load", new GDID(123, 2, 8907893234), typeof(FullGDID))) as FullGDID;
Assert.NotNull(row2);
Assert.AreEqual(new GDID(123, 2, 8907893234), row2.GDID);
Assert.AreEqual(new GDID(123, 2, 8907893234), row2.VARGDID);
Assert.AreEqual("AAA", row2["String_Name"]);
}
public static void TypedRowTestVariousTypes(ICRUDDataStore store)
{
var row = new Types();
row["GDID"] = new GDID(0, 234);
row["SCREEN_NAME"] = "User1";
row["STRING_NAME"] = "Some user 1";
row["CHAR_NAME"] = "Some user 2";
row["BOOL_CHAR"] = true; //notice TRUE for both char and bool columns below
row["BOOL_BOOL"] = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980,12,1);
store.Insert( row );
var row2 = store.LoadOneRow(new Query("CRUD.Types.Load", new GDID(0, 234)));
Assert.NotNull(row2);
Assert.AreEqual(234, row2["GDID"]);
Assert.AreEqual("User1", row2["Screen_Name"]);
Assert.AreEqual("Some user 1", row2["String_Name"]);
Assert.AreEqual("Some user 2", row2["Char_Name"]);
Assert.AreEqual(true, row2["BOOL_Char"].AsBool());
Assert.AreEqual(true, row2["BOOL_BOOL"].AsBool());
Assert.AreEqual(145670.23m, row2["Amount"]);
Assert.AreEqual(1980, row2["DOB"].AsDateTime().Year);
}
public static void InsertThenUpsert_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.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.Upsert( row );
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.Upsert(row);
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 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.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);
store.Delete( row );
result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_5") } )[0];
Assert.AreEqual(0, result.Count);
result = store.Load( new Query("CRUD.Patient.List", typeof(Patient) ) { new Query.Param("LN", "%loff_%") } )[0];
Assert.AreEqual(9, result.Count);
}
public static void InsertThenUpsert_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.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.Upsert(row);
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.Upsert(row);
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 void GetSchemaAndTestFullGDID(ICRUDDataStore store)
{
var schema = store.GetSchema(new Query("CRUD.FullGDID.Load"));
var row = new DynamicRow(schema);
var key = new GDID(179, 1, 1234567890);
Console.WriteLine( key.Bytes.ToDumpString(DumpFormat.Hex));
row["GDID"] = new GDID(179, 1, 1234567890);
Console.WriteLine( ((byte[])row["GDID"]).ToDumpString(DumpFormat.Hex) );
row["VARGDID"] = new GDID(12, 9, 9876543210);
row["STRING_NAME"] = "DA DA DA!";
store.Insert( row );
var row2 = store.LoadOneRow(new Query("CRUD.FullGDID.Load", key, typeof(FullGDID))) as FullGDID;
Assert.NotNull(row2);
Assert.AreEqual(key, row2.GDID);
Assert.AreEqual(new GDID(12, 9, 9876543210), row2.VARGDID);
Assert.AreEqual("DA DA DA!", row2["String_Name"]);
}
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 TypedRowTestVariousTypes(ICRUDDataStore store)
{
var row = new Types();
row.GDID = new GDID(0, 234);
row.Screen_Name = "User1";
row.String_Name = "Some user 1";
row.Char_Name = "Some user 2";
row.Bool_Char = true; //notice TRUE for both char and bool columns below
row.Bool_Bool = true;
row["AMOUNT"] = 145670.23m;
row["DOB"] = new DateTime(1980,12,1);
row["Age"] = 145;
store.Insert( row );
var row2 = store.LoadRow(new Query<Types>("CRUD.Types.Load", new GDID(0, 234)));
Assert.NotNull(row2);
Assert.AreEqual(new GDID(0,0,234), row2.GDID);
Assert.AreEqual("User1", row2.Screen_Name);
Assert.AreEqual("Some user 1", row2.String_Name);
Assert.AreEqual("Some user 2", row2.Char_Name);
Assert.AreEqual(true, row2.Bool_Char.Value);
Assert.AreEqual(true, row2.Bool_Bool.Value);
Assert.AreEqual(145670.23m, row2.Amount);
Assert.AreEqual(1980, row2.DOB.Value.Year);
Assert.AreEqual(145, row2.Age);
row.Age = null;
row.Bool_Bool = null;
row.DOB = null;
store.Update(row);
var row3 = store.LoadRow(new Query<Types>("CRUD.Types.Load", new GDID(0, 234)));
Assert.IsFalse(row3.Age.HasValue);
Assert.IsFalse(row3.Bool_Bool.HasValue);
Assert.IsFalse(row3.DOB.HasValue);
Assert.IsNull( row3["Age"].AsNullableInt());
Assert.IsNull( row3["DOB"].AsNullableDateTime());
Assert.IsNull( row3["Bool_Bool"].AsNullableBool());
}
public static void UpsertWithPredicate(ICRUDDataStore store)
{
var patient = TestLogic.GetDefaultPatient();
var affected = store.Insert(patient);
Assert.AreEqual(1, affected);
var query = new Query<Patient>("CRUD.Patient.List") { new Query.Param("LN", "%%") };
var persisted = store.LoadRow(query);
persisted.Zip = "010203";
persisted.First_Name = "John";
persisted.Last_Name = "Smith";
affected = store.Upsert(persisted, (r, k, f) => f.Name != "Zip");
Assert.AreEqual(2, affected);
var updated = store.LoadRow(query);
Assert.IsNotNull(updated);
Assert.AreEqual(persisted.SSN, updated.SSN);
Assert.AreEqual(persisted.City, updated.City);
Assert.AreEqual(persisted.Address1, updated.Address1);
Assert.AreEqual(persisted.Address2, updated.Address2);
Assert.AreEqual(persisted.Amount, updated.Amount);
Assert.AreEqual(persisted.Doctor_Phone, updated.Doctor_Phone);
Assert.AreEqual(persisted.Phone, updated.Phone);
Assert.AreEqual(persisted.DOB, updated.DOB);
Assert.AreEqual(persisted.Note, updated.Note);
Assert.AreEqual(persisted.First_Name, updated.First_Name);
Assert.AreEqual(persisted.Last_Name, updated.Last_Name);
Assert.AreEqual(patient.Zip, updated.Zip); // notice ZIP remains the same
}
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 Populate_OpenCursor(ICRUDDataStore store)
{
const int CNT = 1000;
for(var i=0; i<CNT; i++)
{
var patient = new TupleData
{
COUNTER = i,
DATA = i.ToString()+"-DATA"
};
store.Insert( patient );
}
var query = new Query<TupleData>("CRUD.Tuple.LoadAll");
var result = store.LoadOneRowset( query );
Assert.AreEqual(CNT, result.Count);
Assert.AreEqual(0, result[0]["COUNTER"]);
Assert.AreEqual(CNT-1, result[result.Count-1]["COUNTER"]);
{
using(var cursor = store.OpenCursor( query ))
{
Assert.IsFalse( cursor.Disposed );
var cnt = 0;
foreach(var row in cursor.AsEnumerableOf<TupleData>())
cnt++;
Assert.AreEqual(CNT, cnt);
Assert.IsTrue( cursor.Disposed );//foreach must have closed the cursor
}
}
{
var cursor = store.OpenCursor( query );
Assert.IsFalse( cursor.Disposed );
var cen = cursor.GetEnumerator();
cen.MoveNext();
Assert.IsNotNull( cen.Current );
Console.WriteLine( cen.Current.Schema.ToJSON(JSONWritingOptions.PrettyPrintRowsAsMap) );
Assert.AreEqual(0, cen.Current["COUNTER"]);
Assert.AreEqual("0-DATA", cen.Current["DATA"]);
cen.MoveNext();
Assert.IsNotNull( cen.Current );
Assert.AreEqual(1, cen.Current["COUNTER"]);
Assert.AreEqual("1-DATA", cen.Current["DATA"]);
cen.MoveNext();
Assert.IsNotNull( cen.Current );
Assert.AreEqual(2, cen.Current["COUNTER"]);
Assert.AreEqual("2-DATA", cen.Current["DATA"]);
cursor.Dispose();
Assert.IsTrue( cursor.Disposed );
}
{
using(var cursor = store.OpenCursor( query ))
{
Assert.IsFalse( cursor.Disposed );
var cnt = 0;
foreach(var row in cursor.AsEnumerableOf<TupleData>())
cnt++;
Assert.AreEqual(CNT, cnt);
Assert.IsTrue( cursor.Disposed );//foreach must have closed the cursor
try
{
foreach(var row in cursor.AsEnumerableOf<TupleData>())
Assert.Fail("Must have failed");
}
catch
{
}
}
}
{
var cursor = store.OpenCursor( query );
Assert.IsFalse( cursor.Disposed );
var cen = cursor.GetEnumerator();
cen.MoveNext();
Assert.IsNotNull( cen.Current );
Assert.AreEqual(0, cen.Current["COUNTER"]);
try
{
Assert.IsFalse( cursor.Disposed );
var cen2 = cursor.GetEnumerator();
Assert.Fail("This should not have heppened as cant iterate cursor the second time");
}
catch
{
}
cursor.Dispose();
Assert.IsTrue( cursor.Disposed );
}
}
public static void Populate_OpenCursor(ICRUDDataStore store)
{
const int CNT = 1000;
for (var i = 0; i < CNT; i++)
{
var patient = new TupleData
{
COUNTER = i,
DATA = i.ToString() + "-DATA"
};
store.Insert(patient);
}
var query = new Query <TupleData>("CRUD.Tuple.LoadAll");
var result = store.LoadOneRowset(query);
Assert.AreEqual(CNT, result.Count);
Assert.AreEqual(0, result[0]["COUNTER"]);
Assert.AreEqual(CNT - 1, result[result.Count - 1]["COUNTER"]);
{
using (var cursor = store.OpenCursor(query))
{
Assert.IsFalse(cursor.Disposed);
var cnt = 0;
foreach (var row in cursor.AsEnumerableOf <TupleData>())
{
cnt++;
}
Assert.AreEqual(CNT, cnt);
Assert.IsTrue(cursor.Disposed); //foreach must have closed the cursor
}
}
{
var cursor = store.OpenCursor(query);
Assert.IsFalse(cursor.Disposed);
var cen = cursor.GetEnumerator();
cen.MoveNext();
Assert.IsNotNull(cen.Current);
Console.WriteLine(cen.Current.Schema.ToJSON(JSONWritingOptions.PrettyPrintRowsAsMap));
Assert.AreEqual(0, cen.Current["COUNTER"]);
Assert.AreEqual("0-DATA", cen.Current["DATA"]);
cen.MoveNext();
Assert.IsNotNull(cen.Current);
Assert.AreEqual(1, cen.Current["COUNTER"]);
Assert.AreEqual("1-DATA", cen.Current["DATA"]);
cen.MoveNext();
Assert.IsNotNull(cen.Current);
Assert.AreEqual(2, cen.Current["COUNTER"]);
Assert.AreEqual("2-DATA", cen.Current["DATA"]);
cursor.Dispose();
Assert.IsTrue(cursor.Disposed);
}
{
using (var cursor = store.OpenCursor(query))
{
Assert.IsFalse(cursor.Disposed);
var cnt = 0;
foreach (var row in cursor.AsEnumerableOf <TupleData>())
{
cnt++;
}
Assert.AreEqual(CNT, cnt);
Assert.IsTrue(cursor.Disposed); //foreach must have closed the cursor
try
{
foreach (var row in cursor.AsEnumerableOf <TupleData>())
{
Assert.Fail("Must have failed");
}
}
catch
{
}
}
}
{
var cursor = store.OpenCursor(query);
Assert.IsFalse(cursor.Disposed);
var cen = cursor.GetEnumerator();
cen.MoveNext();
Assert.IsNotNull(cen.Current);
Assert.AreEqual(0, cen.Current["COUNTER"]);
try
{
Assert.IsFalse(cursor.Disposed);
var cen2 = cursor.GetEnumerator();
Assert.Fail("This should not have heppened as cant iterate cursor the second time");
}
catch
{
}
cursor.Dispose();
Assert.IsTrue(cursor.Disposed);
}
}
public static void Populate_ASYNC_OpenCursor(ICRUDDataStore store)
{
const int CNT = 1000;
for(var i=0; i<CNT; i++)
{
var patient = new TupleData
{
COUNTER = i,
DATA = i.ToString()+"-DATA"
};
store.Insert( patient );
}
var query = new Query<TupleData>("CRUD.Tuple.LoadAll");
var result = store.LoadOneRowset( query );
Assert.AreEqual(CNT, result.Count);
Assert.AreEqual(0, result[0]["COUNTER"]);
Assert.AreEqual(CNT-1, result[result.Count-1]["COUNTER"]);
var task = store.OpenCursorAsync( query )
.ContinueWith( antecedent =>
{
var cursor = antecedent.Result;;
Assert.IsFalse( cursor.Disposed );
var cnt = 0;
foreach(var row in cursor.AsEnumerableOf<TupleData>())
cnt++;
Assert.AreEqual(CNT, cnt);
Assert.IsTrue( cursor.Disposed );//foreach must have closed the cursor
});
task.Wait();
}
public static void InsertWithPredicate(ICRUDDataStore store)
{
var patient = TestLogic.GetDefaultPatient();
var affected = store.Insert(patient, (r, k, f) => f.Name != "State" && f.Name != "Zip");
Assert.AreEqual(1, affected);
var query = new Query<Patient>("CRUD.Patient.List") { new Query.Param("LN", "%%") };
var persisted = store.LoadRow(query);
Assert.IsNotNull(persisted);
Assert.AreEqual(patient.First_Name, persisted.First_Name);
Assert.AreEqual(patient.Last_Name, persisted.Last_Name);
Assert.AreEqual(patient.SSN, persisted.SSN);
Assert.AreEqual(patient.City, persisted.City);
Assert.AreEqual(patient.Address1, persisted.Address1);
Assert.AreEqual(patient.Address2, persisted.Address2);
Assert.AreEqual(patient.Amount, persisted.Amount);
Assert.AreEqual(patient.Doctor_Phone, persisted.Doctor_Phone);
Assert.AreEqual(patient.Phone, persisted.Phone);
Assert.AreEqual(patient.DOB, persisted.DOB);
Assert.AreEqual(patient.Note, persisted.Note);
Assert.IsNull(persisted.State);
Assert.IsNull(persisted.Zip);
}