private void Test_IsView() { const string testView = "vitestview"; _dbSchema.DropView(testView); _commands.ExecuteNonQuery(string.Format("create view {0} as select 'a' as col1 from {1}", testView, _testTable)); bool viewExists = _dbSchema.IsView(testView); _dbSchema.DropView(testView); viewExists.Should().BeTrue("because view was created"); }
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++; } } }