public void HasTypeTest()
{
TypeNames names = new TypeNames();
Assert.IsFalse(names.HasType(DbType.Int32));
names.Put(DbType.Int32, string.Empty);
Assert.IsTrue(names.HasType(DbType.Int32));
}
public void PutAndGetDecimalByColumnTypeTest()
{
TypeNames names = new TypeNames();
names.Put(DbType.Decimal, "NUMBER");
names.Put(DbType.Decimal, 18, "NUMBER($l, $s)");
Assert.AreEqual("NUMBER(11, 2)", names.Get(DbType.Decimal.WithSize(11, 2)));
Assert.AreEqual("NUMBER(8, $s)", names.Get(DbType.Decimal.WithSize(8))); // will cause trouble
}
public void PutAndGetDecimalTest()
{
TypeNames names = new TypeNames();
names.Put(DbType.Decimal, "NUMBER");
names.Put(DbType.Decimal, 18, "NUMBER($l, $s)");
Assert.AreEqual("NUMBER", names.Get(DbType.Decimal));
Assert.AreEqual("NUMBER(10, 5)", names.Get(DbType.Decimal, 10, 5));
Assert.AreEqual("NUMBER(7, $s)", names.Get(DbType.Decimal, 7)); // will cause trouble
}
public void PutAndGetByColumnTypeTest2()
{
TypeNames names = new TypeNames();
names.Put(DbType.AnsiString, "VARCHAR($l)");
Assert.AreEqual("VARCHAR($l)", names.Get(new ColumnType(DbType.AnsiString))); // will cause trouble
Assert.AreEqual("VARCHAR(100)", names.Get(DbType.AnsiString.WithSize(100)));
Assert.AreEqual("VARCHAR(1000)", names.Get(DbType.AnsiString.WithSize(1000)));
Assert.AreEqual("VARCHAR(10000)", names.Get(DbType.AnsiString.WithSize(10000)));
}
public void PutAndGetTest()
{
TypeNames names = new TypeNames();
names.Put(DbType.AnsiString, "TEXT");
names.Put(DbType.AnsiString, 255, "VARCHAR($l)");
names.Put(DbType.AnsiString, 65534, "LONGVARCHAR($l)");
Assert.AreEqual("TEXT", names.Get(DbType.AnsiString)); // default
Assert.AreEqual("VARCHAR(100)", names.Get(DbType.AnsiString, 100)); // 100 is in [0:255]
Assert.AreEqual("LONGVARCHAR(1000)", names.Get(DbType.AnsiString, 1000)); // 100 is in [256:65534])
Assert.AreEqual("TEXT", names.Get(DbType.AnsiString, 100000)); // default
}
public void PutAndGetTest2()
{
TypeNames names = new TypeNames();
names.Put(DbType.AnsiString, "VARCHAR($l)");
Assert.AreEqual("VARCHAR($l)", names.Get(DbType.AnsiString)); // will cause trouble
Assert.AreEqual("VARCHAR(100)", names.Get(DbType.AnsiString, 100));
Assert.AreEqual("VARCHAR(1000)", names.Get(DbType.AnsiString, 1000));
Assert.AreEqual("VARCHAR(10000)", names.Get(DbType.AnsiString, 10000));
}
public void HasTypeWithLengthTest()
{
TypeNames names = new TypeNames();
names.Put(DbType.Int32, 4, string.Empty);
Assert.IsTrue(names.HasType(DbType.Int32));
}
public void ReplacingWithDefaultScaleTest()
{
TypeNames names = new TypeNames();
names.Put(DbType.Xml, 20, "foo($l, $s)", 5);
Assert.AreEqual("foo(12, 7)", names.Get(DbType.Xml, 12, 7));
Assert.AreEqual("foo(12, 5)", names.Get(DbType.Xml, 12));
}