private OracleDataStore GetTestStore()
{
var store = new OracleDataStore(GetInfo());
store.EnsureCompatibility();
return(store);
}
public void ManualDS_QueryInsertQuery_TypedRow()
{
using (var store = new OracleDataStore(NOPApplication.Instance, getConnectString()))
{
store.QueryResolver.ScriptAssembly = SCRIPT_ASM;
clearAllTables();
TestLogic.QueryInsertQuery_TypedRow(store);
}
}
public void ManualDS_ASYNC_Populate_OpenCursor()
{
using (var store = new OracleDataStore(NOPApplication.Instance, getConnectString()))
{
store.QueryResolver.ScriptAssembly = SCRIPT_ASM;
clearAllTables();
TestLogic.Populate_ASYNC_OpenCursor(store);
clearAllTables();
}
}
public void ManualDS_GetSchemaAndTestFullGDID()
{
using (var store = new OracleDataStore(NOPApplication.Instance, getConnectString()))
{
store.StringBool = false;
store.FullGDIDS = true;
store.QueryResolver.ScriptAssembly = SCRIPT_ASM;
clearAllTables();
TestLogic.GetSchemaAndTestFullGDID(store);
}
}
public void ManualDS_TypedRowTestVariousTypes()
{
using (var store = new OracleDataStore(NOPApplication.Instance, getConnectString()))
{
store.StringBool = false;
store.FullGDIDS = false;
store.QueryResolver.ScriptAssembly = SCRIPT_ASM;
clearAllTables();
TestLogic.TypedRowTestVariousTypes(store);
}
}
public void SimpleCRUDTest()
{
bool beforeInsert = false;
bool afterInsert = false;
bool beforeUpdate = false;
bool afterUpdate = false;
bool beforeDelete = false;
bool afterDelete = false;
var info = new OracleConnectionInfo("192.168.10.246", 1521, "XE", "system", "password");
var store = new OracleDataStore(info);
store.AddType <TestItem>();
store.BeforeInsert += delegate
{
beforeInsert = true;
};
store.AfterInsert += delegate
{
afterInsert = true;
};
store.BeforeUpdate += delegate
{
beforeUpdate = true;
};
store.AfterUpdate += delegate
{
afterUpdate = true;
};
store.BeforeDelete += delegate
{
beforeDelete = true;
};
store.AfterDelete += delegate
{
afterDelete = true;
};
store.TruncateTable("TestItem");
var itemA = new TestItem("ItemA");
itemA.ID = 1;
itemA.UUID = Guid.NewGuid();
itemA.ITest = 5;
itemA.FTest = 3.14F;
itemA.DBTest = 1.4D;
itemA.DETest = 2.678M;
var itemB = new TestItem("ItemB");
itemB.ID = 2;
var itemC = new TestItem("ItemC");
itemC.ID = 3;
// INSERT
store.Insert(itemA);
Assert.IsTrue(beforeInsert, "BeforeInsert never fired");
Assert.IsTrue(afterInsert, "AfterInsert never fired");
store.Insert(itemB);
store.Insert(itemC);
// COUNT
var count = store.Count <TestItem>();
Assert.AreEqual(3, count);
// SELECT
var items = store.Select <TestItem>();
Assert.AreEqual(3, items.Count());
var item = store.Select <TestItem>("Name", itemB.Name).FirstOrDefault();
Assert.IsTrue(item.Equals(itemB));
item = store.Select <TestItem>(itemC.ID);
Assert.IsTrue(item.Equals(itemC));
// FETCH
// UPDATE
itemC.Name = "NewItem";
itemC.Address = "Changed Address";
itemC.TS = new TimeSpan(8, 23, 30);
itemC.BigString = "little string";
// test rollback
store.BeginTransaction();
store.Update(itemC);
item = store.Select <TestItem>(itemC.ID);
Assert.IsTrue(item.Name == itemC.Name);
store.Rollback();
item = store.Select <TestItem>(itemC.ID);
Assert.IsTrue(item.Name != itemC.Name);
// test commit
store.BeginTransaction(System.Data.IsolationLevel.Unspecified);
store.Update(itemC);
store.Commit();
Assert.IsTrue(beforeUpdate, "BeforeUpdate never fired");
Assert.IsTrue(afterUpdate, "AfterUpdate never fired");
item = store.Select <TestItem>("Name", "ItemC").FirstOrDefault();
Assert.IsNull(item);
item = store.Select <TestItem>("Name", itemC.Name).FirstOrDefault();
Assert.IsTrue(item.Equals(itemC));
// CONTAINS
var exists = store.Contains(itemA);
Assert.IsTrue(exists);
// DELETE
store.Delete(itemA);
Assert.IsTrue(beforeDelete, "BeforeDelete never fired");
Assert.IsTrue(afterDelete, "AfterDelete never fired");
item = store.Select <TestItem>("Name", itemA.Name).FirstOrDefault();
Assert.IsNull(item);
// CONTAINS
exists = store.Contains(itemA);
Assert.IsFalse(exists);
// COUNT
count = store.Count <TestItem>();
Assert.AreEqual(2, count);
// this will create the table in newer versions of ORM
store.AddType <LateAddItem>();
var newitems = store.Select <LateAddItem>(false);
Assert.IsNotNull(newitems);
}
public void TestMethod1()
{
var info = new OracleConnectionInfo("192.168.10.246", 1521, "XE", "system", "password");
var store = new OracleDataStore(info);
}
