private static void ValidateColumn(
InformationSchemaColumn column,
string name,
string type,
bool isNullable,
byte?numericPrecision = null,
int?numericScale = null,
int?charMaxLength = null)
{
if (column == null)
{
throw new ArgumentNullException(nameof(column));
}
column.COLUMN_NAME.Should().Be(name);
column.DATA_TYPE.Should().Be(type);
column.IS_NULLABLE.Should().Be(isNullable ? "YES" : "NO");
if (numericPrecision.HasValue)
{
column.NUMERIC_PRECISION.Should().Be(numericPrecision.Value);
}
if (numericScale.HasValue)
{
column.NUMERIC_SCALE.Should().Be(numericScale.Value);
}
if (charMaxLength.HasValue)
{
column.CHARACTER_MAXIMUM_LENGTH.Should().Be(charMaxLength.Value);
}
}
private void A_tabela_de_log_deve_ter_criar_esse_campo_tambem()
{
var infomationColumn = new InformationSchemaColumn {
DBName = _tableWithlog.DBName
};
infomationColumn.GetByKey(_tableWithlog.TableName + "Log", newFeldAdd.Name).Should().Be.True();;
}
private void A_tabela_de_log_deve_ser_criada()
{
var infosSchema = new InformationSchemaColumn {
DBName = _tableWithlog.DBName
};
infosSchema.GetByKey("FakeLog", TableAdapterLog.FieldsName.InstanceLog)
.Should().Be.True();
}
private Boolean ExistField(string field)
{
var infoTable = new InformationSchemaColumn();
infoTable.SetConnection(Connection.Instance);
infoTable.DBName = _tableLog.DBName;
return(infoTable.GetByKey(_tableLog.TableName, field));
}
private void CreateUserCacheTable()
{
InformationSchemaColumn infoSchema = new InformationSchemaColumn();
UserCache myUser = new UserCache();
infoSchema.DBName = myUser.DBName;
if (!infoSchema.GetByKey(UserCache.Definition.TableName, UserCache.FieldsName.ID))
{
myUser.Create();
}
}
/// <summary>
/// Cria a tabela caso a mesma não exista
/// </summary>
private void CreateNotExists()
{
var table = CreateUserControlProperty();
var schema = new InformationSchemaColumn()
{
DBName = db.DataBaseName
};
if (!schema.GetByKey(table.TableName, table.Collumns.First().Name))
{
table.Create();
}
}
private bool ExistTable()
{
SetTableAndDbNameLogFor(_tableLogBase);
var infoTable = new InformationSchemaColumn();
infoTable.SetConnection(Connection.Instance);
infoTable.DBName = _tableLog.DBName;
var tableQuery = new TableQuery(infoTable);
tableQuery.Where.Add(
new QueryParam(infoTable.Collumns[InformationSchemaColumn.FieldsName.TableName],
_tableLog.TableName));
var list = infoTable.FillCollection <InformationSchemaColumn>(tableQuery);
return(!list.IsEmpty());
}
