public void DeleteRandomValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction1 = manager.BeginTransaction();
IntegerTestObject test1 = transaction1.Create(typeof(IntegerTestObject)) as IntegerTestObject;
test1.Boolean = false;
test1.TinyInt = 1;
test1.Int = 123;
test1.SmallInt = 56;
test1.BigInt = 169;
transaction1.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("Integers"));
ObjectTransaction transaction2 = manager.BeginTransaction();
IntegerTestObject test2 = transaction2.Select(typeof(IntegerTestObject), test1.Id) as IntegerTestObject;
Assert.AreEqual(false, test2.Boolean);
Assert.AreEqual(1, test2.TinyInt);
Assert.AreEqual(123, test2.Int);
Assert.AreEqual(56, test2.SmallInt);
Assert.AreEqual(169, test2.BigInt);
transaction2.Delete(test2);
transaction2.Commit();
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
}
public void UpdateValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction = manager.BeginTransaction();
IntegerTestObject test1 = transaction.Select(typeof(IntegerTestObject), UpdateValue) as IntegerTestObject;
Assert.AreEqual(true, test1.Boolean);
Assert.AreEqual(1, test1.TinyInt);
Assert.AreEqual(1, test1.SmallInt);
Assert.AreEqual(1, test1.Int);
Assert.AreEqual(1, test1.BigInt);
test1.Boolean = false;
test1.TinyInt = 2;
test1.SmallInt = 3;
test1.Int = 4;
test1.BigInt = 5;
transaction.Commit();
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
ObjectTransaction transaction2 = manager.BeginTransaction();
IntegerTestObject test2 = transaction2.Select(typeof(IntegerTestObject), UpdateValue) as IntegerTestObject;
Assert.AreEqual(false, test2.Boolean);
Assert.AreEqual(2, test2.TinyInt);
Assert.AreEqual(3, test2.SmallInt);
Assert.AreEqual(4, test2.Int);
Assert.AreEqual(5, test2.BigInt);
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
}
public void SelectNonExistantValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction = manager.BeginTransaction();
IntegerTestObject test = transaction.Select(typeof(IntegerTestObject), DoesNotExistValues) as IntegerTestObject;
Assert.IsNull(test);
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
}
public void InsertMissingValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction = manager.BeginTransaction();
IntegerTestObject test = transaction.Create(typeof(IntegerTestObject)) as IntegerTestObject;
test.TinyInt = 1;
test.Int = 123;
test.SmallInt = 56;
transaction.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("Integers"));
}
public void SelectZeroValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction = manager.BeginTransaction();
IntegerTestObject test = transaction.Select(typeof(IntegerTestObject), ZeroValues) as IntegerTestObject;
Assert.AreEqual(new Guid(ZeroValues), test.Id);
Assert.AreEqual(false, test.Boolean);
Assert.AreEqual(0, test.TinyInt);
Assert.AreEqual(0, test.SmallInt);
Assert.AreEqual(0, test.Int);
Assert.AreEqual(0, test.BigInt);
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
}
public void SelectMaxValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction = manager.BeginTransaction();
IntegerTestObject test = transaction.Select(typeof(IntegerTestObject), MaxValues) as IntegerTestObject;
Assert.AreEqual(new Guid(MaxValues), test.Id);
Assert.AreEqual(true, test.Boolean);
Assert.AreEqual(Byte.MaxValue, test.TinyInt);
Assert.AreEqual(Int16.MaxValue, test.SmallInt);
Assert.AreEqual(Int32.MaxValue, test.Int);
Assert.AreEqual(Int64.MaxValue, test.BigInt);
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
}
