[TestMethod()] public void TestLoadAndSaveEmployeeTrainingHistory()
{
ModelContext.beginTrans();
try {
OracleMappers.EmployeeTrainingHistoryDBMapper pdb = new OracleMappers.EmployeeTrainingHistoryDBMapper();
long count = pdb.RecordCount();
if (pdb.SelectFromObjectName != pdb.ManagedTableName)
{
long countFromSelectObject = pdb.dbConn.getLngValue("select count(*) from " + pdb.SelectFromObjectName);
Assert.AreEqual(count, countFromSelectObject,
"Count of records in managedTableName {0} and SelectFromObjectName {1} should be equal, as there needs to be exactly 1 to 1 match between records in managed table and selectFromObject.",
pdb.ManagedTableName, pdb.SelectFromObjectName);
}
if (count == 0)
{
Assert.Inconclusive("No EmployeeTrainingHistory in database, table is empty");
}
else
{
/**
* using (DataContext ctx = DBUtils.Current().dbContext()) {
*
* var query = ctx.ExecuteQuery<EmployeeTrainingHistory>(@"SELECT * FROM " + pdb.SelectFromObjectName ).Skip(1).Take(1);
* var lst = query.ToList();
*
* Assert.AreEqual(lst.Count, 1, "Expected to receive 1 record, got: " + lst.Count);
*
* }
* todo: fix boolean fields by generating properties of original fields
**/
object pid = ModelContext.CurrentDBUtils.getObjectValue("select top 1 " + pdb.pkFieldName + " from " + pdb.ManagedTableName);
EmployeeTrainingHistory p = pdb.findByKey(pid);
EmployeeTrainingHistory p2 = (EmployeeTrainingHistory)p.copy();
//Test equality and hash codes
Assert.AreEqual(p.GetHashCode(), p2.GetHashCode());
Assert.AreEqual(p, p2);
p.isDirty = true; // force save
pdb.save(p);
// now reload object from database
p = null;
p = pdb.findByKey(pid);
//test fields to be equal before and after save
Assert.IsTrue(p.PrEmployeeTrainingHistoryId == p2.PrEmployeeTrainingHistoryId, "Expected Field EmployeeTrainingHistoryId to be equal");
Assert.IsTrue(p.PrEmployeeId.GetValueOrDefault() == p2.PrEmployeeId.GetValueOrDefault(), "Expected Field EmployeeId to be equal");
Assert.IsTrue(p.PrDateFrom.GetValueOrDefault() == p2.PrDateFrom.GetValueOrDefault(), "Expected Field DateFrom to be equal");
Assert.IsTrue(p.PrDateTo.GetValueOrDefault() == p2.PrDateTo.GetValueOrDefault(), "Expected Field DateTo to be equal");
Assert.IsTrue(p.PrTrainingCourseCode == p2.PrTrainingCourseCode, "Expected Field TrainingCourseCode to be equal");
p.isDirty = true; //to force save
ModelContext.Current.saveModelObject(p);
p = ModelContext.Current.loadModelObject <EmployeeTrainingHistory>(p.Id);
p.loadObjectHierarchy();
string json = JsonConvert.SerializeObject(p, Formatting.Indented,
new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
System.IO.FileInfo jf = new System.IO.FileInfo(".\\EmployeeTrainingHistory.json");
System.IO.File.WriteAllText(jf.FullName, json);
if (pdb.isPrimaryKeyAutogenerated)
{
p.isNew = true;
p.isDirty = true;
try {
pdb.save(p);
} catch (System.Exception e) {
Assert.IsTrue(e.Message.ToUpper().Contains("UNIQUE INDEX") || e.Message.Contains("Violation of UNIQUE KEY constraint"),
"Insert statement produced error other than violation of unique key:" + e.Message);
}
}
}
} finally {
ModelContext.rollbackTrans(); // 'Nothing should be saved to the database!
}
}
/// <summary>
/// Convinience method to save a EmployeeTrainingHistory Object.
/// Important note: DO NOT CALL THIS IN A LOOP!
/// </summary>
/// <param name="EmployeeTrainingHistoryObj"></param>
/// <remarks>
/// Important note: DO NOT CALL THIS IN A LOOP!
/// This method simply instantiates a EmployeeTrainingHistoryDBMapper and calls the save method
/// </remarks>
public static void saveEmployeeTrainingHistory(params EmployeeTrainingHistory[] EmployeeTrainingHistoryObj)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
dbm.saveList(EmployeeTrainingHistoryObj.ToList());
}
public static void deleteEmployeeTrainingHistory(EmployeeTrainingHistory EmployeeTrainingHistoryObj)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
dbm.delete(EmployeeTrainingHistoryObj);
}
public static List <EmployeeTrainingHistory> findList(string @where, List <IDataParameter> listOfIParams)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
return(dbm.findList(@where, listOfIParams));
}
public static EmployeeTrainingHistory findOne(string @where, params object[] @params)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
return((EmployeeTrainingHistory)dbm.findWhere(@where, @params));
}
public static List<EmployeeTrainingHistory> findList(string @where, List<IDataParameter> listOfIParams)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
return dbm.findList(@where,listOfIParams);
}
public static List <EmployeeTrainingHistory> findList(string @where, params object[] @params)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
return(dbm.findList(@where, @params));
}
public static List<EmployeeTrainingHistory> findList(string @where, params object[] @params)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
return dbm.findList(@where, @params);
}
public static void deleteEmployeeTrainingHistory(EmployeeTrainingHistory EmployeeTrainingHistoryObj)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
dbm.delete(EmployeeTrainingHistoryObj);
}
/// <summary>
/// Convinience method to save a EmployeeTrainingHistory Object.
/// Important note: DO NOT CALL THIS IN A LOOP!
/// </summary>
/// <param name="EmployeeTrainingHistoryObj"></param>
/// <remarks>
/// Important note: DO NOT CALL THIS IN A LOOP!
/// This method simply instantiates a EmployeeTrainingHistoryDBMapper and calls the save method
/// </remarks>
public static void saveEmployeeTrainingHistory(params EmployeeTrainingHistory[] EmployeeTrainingHistoryObj)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
dbm.saveList(EmployeeTrainingHistoryObj.ToList());
}
public static EmployeeTrainingHistory findOne(string @where, params object[] @params)
{
EmployeeTrainingHistoryDBMapper dbm = new EmployeeTrainingHistoryDBMapper();
return (EmployeeTrainingHistory)dbm.findWhere(@where, @params);
}
public void TestLoadAndSaveEmployeeTrainingHistory()
{
ModelContext.beginTrans();
try {
OracleMappers.EmployeeTrainingHistoryDBMapper pdb = new OracleMappers.EmployeeTrainingHistoryDBMapper();
long count = pdb.RecordCount();
if (pdb.SelectFromObjectName != pdb.ManagedTableName) {
long countFromSelectObject = pdb.dbConn.getLngValue("select count(*) from " + pdb.SelectFromObjectName);
Assert.AreEqual(count, countFromSelectObject,
"Count of records in managedTableName {0} and SelectFromObjectName {1} should be equal, as there needs to be exactly 1 to 1 match between records in managed table and selectFromObject.",
pdb.ManagedTableName, pdb.SelectFromObjectName);
}
if (count == 0) {
Assert.Inconclusive("No EmployeeTrainingHistory in database, table is empty");
} else {
/**
using (DataContext ctx = DBUtils.Current().dbContext()) {
var query = ctx.ExecuteQuery<EmployeeTrainingHistory>(@"SELECT * FROM " + pdb.SelectFromObjectName ).Skip(1).Take(1);
var lst = query.ToList();
Assert.AreEqual(lst.Count, 1, "Expected to receive 1 record, got: " + lst.Count);
}
todo: fix boolean fields by generating properties of original fields
**/
object pid = ModelContext.CurrentDBUtils.getObjectValue("select top 1 " + pdb.pkFieldName + " from " + pdb.ManagedTableName);
EmployeeTrainingHistory p = pdb.findByKey(pid);
EmployeeTrainingHistory p2 = (EmployeeTrainingHistory)p.copy();
//Test equality and hash codes
Assert.AreEqual(p.GetHashCode(), p2.GetHashCode());
Assert.AreEqual(p, p2);
p.isDirty = true ; // force save
pdb.save(p);
// now reload object from database
p = null;
p = pdb.findByKey(pid);
//test fields to be equal before and after save
Assert.IsTrue(p.PrEmployeeTrainingHistoryId==p2.PrEmployeeTrainingHistoryId,"Expected Field EmployeeTrainingHistoryId to be equal");
Assert.IsTrue(p.PrEmployeeId.GetValueOrDefault() ==p2.PrEmployeeId.GetValueOrDefault(),"Expected Field EmployeeId to be equal");
Assert.IsTrue(p.PrDateFrom.GetValueOrDefault() ==p2.PrDateFrom.GetValueOrDefault(),"Expected Field DateFrom to be equal");
Assert.IsTrue(p.PrDateTo.GetValueOrDefault() ==p2.PrDateTo.GetValueOrDefault(),"Expected Field DateTo to be equal");
Assert.IsTrue(p.PrTrainingCourseCode==p2.PrTrainingCourseCode,"Expected Field TrainingCourseCode to be equal");
p.isDirty = true; //to force save
ModelContext.Current.saveModelObject(p);
p = ModelContext.Current.loadModelObject< EmployeeTrainingHistory >(p.Id);
p.loadObjectHierarchy();
string json = JsonConvert.SerializeObject(p,Formatting.Indented,
new JsonSerializerSettings(){
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
System.IO.FileInfo jf = new System.IO.FileInfo(".\\EmployeeTrainingHistory.json");
System.IO.File.WriteAllText(jf.FullName,json);
if (pdb.isPrimaryKeyAutogenerated) {
p.isNew = true;
p.isDirty = true;
try {
pdb.save(p);
} catch (System.Exception e) {
Assert.IsTrue(e.Message.ToUpper().Contains("UNIQUE INDEX")||e.Message.Contains("Violation of UNIQUE KEY constraint"),
"Insert statement produced error other than violation of unique key:"+e.Message);
}
}
}
} finally {
ModelContext.rollbackTrans(); // 'Nothing should be saved to the database!
}
}