public void SelectMinValues()
{
int count = DataUtil.CountRows("Binary");
ObjectTransaction transaction = manager.BeginTransaction();
BinaryTestObject test = transaction.Select(typeof(BinaryTestObject), ZeroValues) as BinaryTestObject;
Assert.AreEqual(new Guid(ZeroValues), test.Id);
Assert.AreEqual(8, test.Binary.Length);
foreach (byte b in test.Binary)
{
Assert.AreEqual(Byte.MinValue, b);
}
Assert.AreEqual(16, test.VarBinary.Length);
foreach (byte b in test.VarBinary)
{
Assert.AreEqual(Byte.MinValue, b);
}
Assert.AreEqual(32, test.Image.Length);
foreach (byte b in test.Image)
{
Assert.AreEqual(Byte.MinValue, b);
}
Assert.AreEqual(count, DataUtil.CountRows("Binary"));
}
public void DeleteRandomValues()
{
Random random = new Random();
int count = DataUtil.CountRows("Binary");
ObjectTransaction transaction = manager.BeginTransaction();
BinaryTestObject test1 = transaction.Create(typeof(BinaryTestObject)) as BinaryTestObject;
test1.Binary = new byte[8];
random.NextBytes(test1.Binary);
test1.VarBinary = new byte[5];
random.NextBytes(test1.VarBinary);
test1.Image = new byte[1024];
random.NextBytes(test1.Image);
transaction.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("Binary"));
ObjectTransaction transaction2 = manager.BeginTransaction();
BinaryTestObject test2 = transaction2.Select(typeof(BinaryTestObject), test1.Id) as BinaryTestObject;
Assert.AreEqual(8, test2.Binary.Length);
Assert.AreEqual(5, test2.VarBinary.Length);
Assert.AreEqual(1024, test2.Image.Length);
transaction2.Delete(test2);
transaction2.Commit();
Assert.AreEqual(count, DataUtil.CountRows("Binary"));
}
public void UpdateRandomValues()
{
Random random = new Random();
int count = DataUtil.CountRows("Binary");
ObjectTransaction transaction = manager.BeginTransaction();
BinaryTestObject test1 = transaction.Select(typeof(BinaryTestObject), UpdateValue) as BinaryTestObject;
test1.Binary = new Byte[8];
random.NextBytes(test1.Binary);
byte b = test1.Binary[3];
test1.VarBinary[2] = 16;
test1.Image[1] = 69;
transaction.Commit();
Assert.AreEqual(count, DataUtil.CountRows("Binary"));
ObjectTransaction transaction2 = manager.BeginTransaction();
BinaryTestObject test2 = transaction2.Select(typeof(BinaryTestObject), UpdateValue) as BinaryTestObject;
Assert.AreEqual(b, test2.Binary[3]);
Assert.AreEqual(16, test2.VarBinary[2]);
Assert.AreEqual(69, test2.Image[1]);
transaction2.Commit();
Assert.AreEqual(count, DataUtil.CountRows("Binary"));
}
public void SelectNonExistantValues()
{
int count = DataUtil.CountRows("Binary");
ObjectTransaction transaction = manager.BeginTransaction();
BinaryTestObject test = transaction.Select(typeof(BinaryTestObject), DoesNotExistValues) as BinaryTestObject;
Assert.IsNull(test);
Assert.AreEqual(count, DataUtil.CountRows("Binary"));
}
public void InsertMissingValues()
{
Random random = new Random();
int count = DataUtil.CountRows("Binary");
ObjectTransaction transaction = manager.BeginTransaction();
BinaryTestObject test = transaction.Create(typeof(BinaryTestObject)) as BinaryTestObject;
test.Binary = new byte[8];
random.NextBytes(test.Binary);
test.VarBinary = new byte[16];
random.NextBytes(test.VarBinary);
transaction.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("Binary"));
}
