public void CheckPrefix(CSV.Log log, DbProvider provider)
{
var builder = provider.Builder;
var factory = new DbFactory(provider);
if (builder == null)
{
log.Debug("此数据库节点配置器未有管理器");
return;
}
var sqler = factory.Sqler(1, false);
log.Info("检测前缀", provider.Prefixion);
var Delimiter = provider.Delimiter;
if (String.Equals(Delimiter, ".") && String.IsNullOrEmpty(provider.Prefixion) == false)
{
var prefixion = String.Format("{0}{1}{2}", provider.QuotePrefix, provider.Prefixion, provider.QuoteSuffix);
var schemaSQL = builder.Schema(prefixion);
if (String.IsNullOrEmpty(schemaSQL) == false)
{
try
{
sqler.ExecuteNonQuery(schemaSQL);
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
}
}
public void Check(CSV.Log log, DbProvider provider)
{
var builder = provider.Builder;
if (builder == null)
{
log.Debug("此数据库节点配置器未有管理器");
return;
}
var factory = new DbFactory(provider);
var sqler = factory.Sqler(1, false);
var em = dictionary.GetEnumerator();
while (em.MoveNext())
{
CheckTable(sqler, provider, log, em.Current.Key, em.Current.Value);
}
}
public void Setup(IDictionary args, CSV.Log log, DbProvider provider)
{
var builder = provider.Builder;
if (builder == null)
{
log.Debug("此数据库节点配置器未有管理器");
log.End("操作结束");
return;
}
var factory = new DbFactory(provider);
var sqler = factory.Sqler(1, false);
var em = dictionary.GetEnumerator();
var Delimiter = provider.Delimiter;
log.Info("数据前缀", provider.Prefixion);
if (String.Equals(Delimiter, ".") && String.IsNullOrEmpty(provider.Prefixion) == false)
{
var prefixion = String.Format("{0}{1}{2}", provider.QuotePrefix, provider.Prefixion, provider.QuoteSuffix);
var schemaSQL = builder.Schema(prefixion);
if (String.IsNullOrEmpty(schemaSQL) == false)
{
try
{
sqler.ExecuteNonQuery(schemaSQL);
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
}
while (em.MoveNext())
{
CreateTable(sqler, provider, log, em.Current.Key, em.Current.Value);
}
this.Setup(args, factory);
}
