public static IAReader CreateInstance(IDbContext dbContext, IALogger logger = null)
{
if (logger == null)
{
return(new AReader(dbContext, new TestLogger()));
}
return(new AReader(dbContext, logger));
}
public void OnException(ExceptionContext context)
{
var errorBr = new Br <string>(context.Exception.Message, -1, context.Exception.Message, stackTrance: context.Exception.StackTrace);
context.Result = new JsonResult(errorBr);
context.ExceptionHandled = true;
IALogger logger = ServiceResolver.GetService <IALogger>(context);
logger.Exception(context.Exception);
}
public OracleContext(IALogger logger = null)
: base(new OraclePowerPlant(), logger)
{
DbType = DbTypeName.Oracle; var currDir =
Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().Location) + "\\";
PowerPlant.DbContext = this;
ColumnTypeConverterForWrite =
PowerPlant.CreateColumnTypeConverter(currDir + ConversionFileForWrite);
ColumnTypeConverterForRead =
PowerPlant.CreateColumnTypeConverter(currDir + ConversionFileForRead);
}
public void DoViews(out int totalViews, out int failedViews, IALogger tmpLogger = null)
{
IALogger logger = tmpLogger ?? new TestLogger();
totalViews = 0;
failedViews = 0;
List <IViewDefinition> viewDefinitions = new List <IViewDefinition>();
viewDefinitions.AddRange(GetViewsFromAagView());
viewDefinitions.AddRange(GetViewsFromAsysViewThatAreNotInAagView());
ICommands cmd = _dbContext.PowerPlant.CreateCommands();
IDbSchema schema = _dbContext.PowerPlant.CreateDbSchema();
IASTNodeFactory nodeFactory = new ASTNodeFactory();
IAParser parser = AParserFactory.CreateInstance(nodeFactory);
if (_dbContext.DbType == DbTypeName.Oracle)
{
parser.ExpandEmptyStrings = true;
}
IATranslator translator = ATranslatorFactory.CreateInstance(_dbContext.DbType, nodeFactory);
foreach (var view in viewDefinitions)
{
if (view.DbType != DbTypeName.Any && view.DbType != _dbContext.DbType)
{
continue;
}
totalViews++;
try
{
schema.DropView(view.ViewName);
CreateView(cmd, parser, translator, view);
logger.Write(string.Format("View '{0}' created", view.ViewName));
}
catch (Exception ex)
{
logger.Write(string.Format("ERROR: Can't create view '{0}'", view.ViewName));
logger.Write(ex.Message);
failedViews++;
}
}
}
public AReader(IDbContext dbContext, IALogger logger)
{
_dbContext = dbContext;
_dbSchema = _dbContext.PowerPlant.CreateDbSchema();
_logger = logger;
}
protected DbContext(IPowerPlant powerPlant, IALogger logger)
{
PowerPlant = powerPlant;
Logger = logger ?? new ConsoleLogger();
}
protected DbContext(string connectionString, IPowerPlant powerPlant, IALogger logger) : this(powerPlant, logger)
{
ConnectionString = connectionString;
}
private static void CreateViews(IDbContext dbContext, out int totalViews, out int failedViews, IALogger logger)
{
totalViews = 0;
failedViews = 0;
try
{
IU4Views views = U4ViewFactory.CreateInstance(dbContext);
if (!views.HasViewsSource)
{
logger.Write(string.Format("ERROR: Can't create views without tables {0} and {1}", views.AagTableName, views.AsysTableName));
return;
}
views.DoViews(out totalViews, out failedViews, logger);
}
catch (Exception ex)
{
logger.Write(ex);
}
}
public OracleContext(string connectionString, IALogger logger = null)
: this(logger)
{
ConnectionString = connectionString;
}
public SqlServerContext(string conectionString, IALogger logger = null)
: this(logger)
{
ConnectionString = conectionString;
}