private void TestCreateTableWithVarcharColumn(IDbContext dbContext)
{
Initialize(dbContext);
TableDefinition tableDefinition = TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, _testTable);
_dbSchema.IsTable(tableDefinition.Name).Should().BeTrue();
}
protected void CreateTableWithAllColumns(bool addDeprecatedTypes)
{
if (!DbSchema.IsTable(TableName))
{
TestTableCreator.CreateTestTableWithAllTypes(DbContext, TableName, addDeprecatedTypes);
}
}
// TestMethod
protected void TestIndex()
{
TestTableCreator.CreateTestTableWithIndex(DbContext, TestTable);
WriteAndRead();
DbSchema.IsIndex("i_" + TestTable, TestTable).Should().BeTrue("because index should be recreated");
}
public virtual void Setup()
{
base.Setup("testview");
DbSchema.DropView(Testview);
DbSchema.DropTable(Asysview);
DbSchema.DropTable(Aagview);
TestTableCreator.CreateUnit4TestableWithAllTypes(DbContext, TestTable);
CreateViewTables();
}
public void TestBigInt()
{
_mssTableCreator.BigIntColumn();
WriteAndVerify(
"Int64",
TestTableCreator.GetInt64SqlValue());
ReadAndVerify("bigint", null, null, null);
}
public void TestTinyInt()
{
_mssTableCreator.TinyInt();
WriteAndVerify(
"Int8",
TestTableCreator.GetInt8SqlValue());
ReadAndVerify("tinyint", null, null, null);
}
public void TestSmallInt()
{
_mssTableCreator.SmallIntColumn();
WriteAndVerify(
"Int16",
TestTableCreator.GetInt16SqlValue());
ReadAndVerify("smallint", null, null, null);
}
public void TestSmallMoney()
{
_mssTableCreator.SmallMoneyColumn();
WriteAndVerify(
"SmallMoney",
TestTableCreator.GetSmallMoneySqlValue());
ReadAndVerify("smallmoney", null, null, null);
}
public void TestReal()
{
_mssTableCreator.Real();
WriteAndVerify(
"BinaryFloat",
TestTableCreator.GetBinaryFloatSqlValue());
ReadAndVerify("real", null, null, null);
}
public void TestMoney()
{
_mssTableCreator.MoneyColumn();
WriteAndVerify(
"Money",
TestTableCreator.GetMoneySqlValue());
ReadAndVerify("money", null, null, null);
}
public void TestInt()
{
_mssTableCreator.IntColumn();
WriteAndVerify(
"Int",
TestTableCreator.GetIntSqlValue());
ReadAndVerify("int", null, null, null);
}
public void TestBit()
{
_mssTableCreator.BitColumn();
WriteAndVerify(
"Bool",
TestTableCreator.GetBoolSqlValue());
ReadAndVerify("bit", null, null, null);
}
public void TestChar10()
{
_oraTableCreator.CharColumn(10);
WriteAndVerify(
"Char",
"Length", 10,
TestTableCreator.GetCharSqlValue());
ReadAndVerify("char", 10, null, null);
}
public void TestNumberWithPrecAndScale()
{
_oraTableCreator.Number("30", "15");
WriteAndVerify(
"Dec",
30, 15,
TestTableCreator.GetFloatSqlValue());
ReadAndVerify("number", null, 30, 15);
}
public void TestVarchar2()
{
_oraTableCreator.Varchar2(20);
WriteAndVerify(
"Varchar",
"Length", 20,
TestTableCreator.GetVarcharSqlValue());
ReadAndVerify("varchar2", 20, null, null);
}
public void TestNClob()
{
_oraTableCreator.NClobColumn();
WriteAndVerify(
"NLongText",
TestTableCreator.GetNLongTextSqlValue(DbContext));
CheckThatDetailDoesNotExist(_schemaFileName, "Length");
ReadAndVerify("nclob", null, null, null);
}
public void TestNumber()
{
_oraTableCreator.Number();
WriteAndVerify(
"Dec",
0, 0,
TestTableCreator.GetFloatSqlValue());
ReadAndVerify("number", null, 0, 0);
}
public void TestNChar10()
{
_oraTableCreator.NCharColumn(10);
WriteAndVerify(
"NChar",
"Length", 10,
TestTableCreator.GetNCharSqlValue(DbContext));
ReadAndVerify("nchar", 10, null, null);
}
public void TestVarcharMax()
{
_mssTableCreator.Varchar(-1);
WriteAndVerify(
"LongText",
TestTableCreator.GetLongTextSqlValue());
CheckThatDetailDoesNotExist(_schemaFileName, "Length");
ReadAndVerify("varchar", -1, null, null);
}
public void TestFloat20()
{
_oraTableCreator.FloatColumn(20);
WriteAndVerify(
"Float",
"Prec", 20,
TestTableCreator.GetBinaryFloatSqlValue());
ReadAndVerify("float", null, 20, null);
}
public void TestFloat()
{
_oraTableCreator.FloatColumn(0);
WriteAndVerify(
"Float",
TestTableCreator.GetBinaryDoubleSqlValue());
CheckThatDetailDoesNotExist(_schemaFileName, "Length");
ReadAndVerify("float", null, 126, null);
}
public void TestVarchar50()
{
_mssTableCreator.Varchar(50);
WriteAndVerify(
"Varchar",
"Length", 50,
TestTableCreator.GetLongTextSqlValue());
ReadAndVerify("varchar", 50, null, null);
}
public void TestClob()
{
_oraTableCreator.Clob();
WriteAndVerify(
"LongText",
TestTableCreator.GetLongTextSqlValue());
CheckThatDetailDoesNotExist(_schemaFileName, "Length");
ReadAndVerify("clob", null, null, null);
}
public void TestLong()
{
_oraTableCreator.LongColumn();
WriteAndVerify(
"OldText",
TestTableCreator.GetLongTextSqlValue());
CheckThatDetailDoesNotExist(_schemaFileName, "Length");
ReadAndVerify("long", null, null, null);
}
public void TestNumeric()
{
_mssTableCreator.NumericColumn(21, 5);
WriteAndVerify(
"Dec",
21, 5,
TestTableCreator.GetDecSqlValue());
ReadAndVerify("decimal", null, 21, 5);
}
public void TestFloat20()
{
_mssTableCreator.FloatColumn(20);
WriteAndVerify(
"BinaryFloat",
TestTableCreator.GetBinaryFloatSqlValue());
// OBS: Prec <= 24 will result in real and prec=24
// Prec > 24 will result in float(53)
ReadAndVerify("real", null, 24, null);
}
private IXmlSchema SetupXmlSchemaAndTable(bool setU4Indexes = true)
{
var xmlSchema = XmlSchemaFactory.CreateInstance(DbContext);
if (setU4Indexes)
{
var u4Indexes = U4IndexesFactory.CreateInstance(DbContext);
u4Indexes.AagTableName = Aagindex;
u4Indexes.AsysTableName = Asysindex;
xmlSchema.U4Indexes = u4Indexes;
}
xmlSchema.XmlWriter = AXmlFactory.CreateWriter();
TestTableCreator.CreateTestTableWithIndex(DbContext, TestTable);
TestTableCreator.CreateIndexTables(DbContext, Asysindex, Aagindex);
return(xmlSchema);
}
private void TestGetTableNames_When_Wildcard(IDbContext dbContext, string searchString, string shouldFind1, string shouldFind2)
{
Initialize(dbContext);
const string table1 = "htest0table";
const string table2 = "htestsometable";
try
{
TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, table1);
TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, table2);
TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, shouldFind1);
TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, shouldFind2);
List <ITableShortInfo> actual = _dbSchema.GetTableNames(searchString);
CompareToAcrparordAcrrepord(actual, shouldFind1, shouldFind2);
}
finally
{
_dbSchema.DropTable(table1);
_dbSchema.DropTable(table2);
_dbSchema.DropTable(shouldFind1);
_dbSchema.DropTable(shouldFind2);
}
}
private void TestIsTable_When_TableExists(IDbContext dbContext)
{
Initialize(dbContext);
TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, _testTable);
_dbSchema.IsTable(_testTable).Should().BeTrue($"because {_testTable} should exist");
}
private void TestExecuteNonQuery(IDbContext dbContext)
{
Initialize(dbContext);
TestTableCreator.CreateTableSomeColumnsAndOneRow(dbContext, _testTable);
_commands.ExecuteNonQuery($"update {_testTable} set val = 'AH'").Should().Be(1);
}
