public async Task Missing_primary_key() { using (var testStore = SqliteTestStore.CreateScratch()) { testStore.ExecuteNonQuery("CREATE TABLE Alicia ( Keys TEXT );"); var results = await Generator.GenerateAsync(new ReverseEngineeringConfiguration { ConnectionString = testStore.ConnectionString, ProjectPath = TestProjectPath, ProjectRootNamespace = "E2E.Sqlite", UseFluentApiOnly = UseFluentApiOnly, TableSelectionSet = TableSelectionSet.All }); var errorMessage = RelationalDesignStrings.UnableToGenerateEntityType("Alicia"); var expectedLog = new LoggerMessages { Warn = { RelationalDesignStrings.MissingPrimaryKey("Alicia"), errorMessage } }; AssertLog(expectedLog); Assert.Contains(errorMessage, InMemoryFiles.RetrieveFileContents(TestProjectFullPath, Path.GetFileName(results.ContextFile))); } }
public async void Missing_primary_key() { using (var testStore = SqliteTestStore.CreateScratch()) { testStore.ExecuteNonQuery("CREATE TABLE Alicia ( Keys TEXT );"); var results = await Generator.GenerateAsync(new ReverseEngineeringConfiguration { ConnectionString = testStore.Connection.ConnectionString, ProjectPath = "testout", ProjectRootNamespace = "E2E.Sqlite", UseFluentApiOnly = UseFluentApiOnly }); var errorMessage = SqliteDesignStrings.MissingPrimaryKey("Alicia"); var expectedLog = new LoggerMessages { Warn = { errorMessage } }; AssertLog(expectedLog); Assert.Contains(errorMessage, InMemoryFiles.RetrieveFileContents("testout", "Alicia.cs")); } }
public SqliteMetadataModelProviderTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceCollection = new ServiceCollection(); serviceCollection.AddLogging(); new SqliteDesignTimeMetadataProviderFactory().AddMetadataProviderServices(serviceCollection); serviceCollection.AddScoped(typeof(ILogger), sp => { return(_logger = new TestLogger()); }); serviceCollection.AddScoped <IFileService, FileSystemFileService>(); _metadataModelProvider = serviceCollection .BuildServiceProvider() .GetService <IDatabaseMetadataModelProvider>() as SqliteMetadataModelProvider; }
public void It_handles_unsafe_names() { using (var testStore = SqliteTestStore.CreateScratch()) { testStore.ExecuteNonQuery(@" CREATE TABLE IF NOT EXISTS 'Named with space' ( Id PRIMARY KEY ); CREATE TABLE IF NOT EXISTS '123 Invalid Class Name' ( Id PRIMARY KEY); CREATE TABLE IF NOT EXISTS 'Bad characters `~!@#$%^&*()+=-[];''"",.<>/?|\ ' ( Id PRIMARY KEY); CREATE TABLE IF NOT EXISTS ' Bad columns ' ( 'Space jam' PRIMARY KEY, '123 Go`', 'Bad to the bone. `~!@#$%^&*()+=-[];''"",.<>/?|\ ', 'Next one is all bad', '@#$%^&*()' ); CREATE TABLE IF NOT EXISTS Keywords ( namespace PRIMARY KEY, virtual, public, class, string, FOREIGN KEY (class) REFERENCES string (string) ); CREATE TABLE IF NOT EXISTS String ( string PRIMARY KEY, FOREIGN KEY (string) REFERENCES String (string) ); "); var results = Generator.Generate( testStore.ConnectionString, Enumerable.Empty <string>(), Enumerable.Empty <string>(), TestProjectPath, outputPath: null, rootNamespace: "E2E.Sqlite", contextName: null, useDataAnnotations: UseDataAnnotations, overwriteFiles: false, useDatabaseNames: false); Assert.Empty(_reporter.Messages.Where(m => m.StartsWith("warn: "))); var files = new FileSet(InMemoryFiles, TestProjectFullPath) { Files = Enumerable.Repeat(results.ContextFile, 1).Concat(results.EntityTypeFiles).Select(Path.GetFileName).ToList() }; AssertCompile(files); } }
public SqliteDatabaseModelFactoryTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceProvider = new SqliteDesignTimeServices() .ConfigureDesignTimeServices(new ServiceCollection().AddLogging()) .BuildServiceProvider(); var logger = new TestLogger(); serviceProvider.GetService <ILoggerFactory>().AddProvider(new TestLoggerProvider(logger)); _factory = serviceProvider .GetService <IDatabaseModelFactory>() as SqliteDatabaseModelFactory; }
public SqliteScaffoldingModelFactoryTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceProvider = new SqliteDesignTimeServices() .ConfigureDesignTimeServices( new ServiceCollection().AddScaffolding().AddLogging()) .AddSingleton <IFileService, FileSystemFileService>() .BuildServiceProvider(); _logger = new TestLogger(); serviceProvider.GetService <ILoggerFactory>().AddProvider(new TestLoggerProvider(_logger)); _scaffoldingModelFactory = serviceProvider .GetService <IScaffoldingModelFactory>() as RelationalScaffoldingModelFactory; }
public async void It_handles_unsafe_names() { using (var testStore = SqliteTestStore.CreateScratch()) { testStore.ExecuteNonQuery(@" CREATE TABLE 'Named with space' ( Id PRIMARY KEY ); CREATE TABLE '123 Invalid Class Name' ( Id PRIMARY KEY); CREATE TABLE 'Bad characters `~!@#$%^&*()+=-[];''"",.<>/?|\ ' ( Id PRIMARY KEY); CREATE TABLE ' Bad columns ' ( 'Space jam' PRIMARY KEY, '123 Go`', 'Bad to the bone. `~!@#$%^&*()+=-[];''"",.<>/?|\ ', 'Next one is all bad', '@#$%^&*()' ); CREATE TABLE Keywords ( namespace PRIMARY KEY, virtual, public, class, string, FOREIGN KEY (class) REFERENCES string (string) ); CREATE TABLE String ( string PRIMARY KEY, FOREIGN KEY (string) REFERENCES String (string) ); "); var results = await Generator.GenerateAsync(new ReverseEngineeringConfiguration { ConnectionString = testStore.Connection.ConnectionString, ProjectPath = "testout", ProjectRootNamespace = "E2E.Sqlite", UseFluentApiOnly = UseFluentApiOnly, TableSelectionSet = TableSelectionSet.All }); AssertLog(new LoggerMessages()); var files = new FileSet(InMemoryFiles, "testout") { Files = Enumerable.Repeat(results.ContextFile, 1).Concat(results.EntityTypeFiles).Select(Path.GetFileName).ToList() }; AssertCompile(files); } }
public async void It_uses_templates() { var dbContextFileName = "EntityFramework.Sqlite.Design." + ReverseEngineeringGenerator.DbContextTemplateFileName; var entityTypeFileName = "EntityFramework.Sqlite.Design." + ReverseEngineeringGenerator.EntityTypeTemplateFileName; var entityTemplate = "This is an entity type template! (For real)"; var contextTemplate = "Also a 100% legit template"; var outputDir = "gen"; var templatesDir = "templates"; using (var testStore = SqliteTestStore.CreateScratch()) { testStore.ExecuteNonQuery("CREATE TABLE RealMccoy ( Col1 text PRIMARY KEY); "); InMemoryFiles.OutputFile(templatesDir, dbContextFileName, contextTemplate); InMemoryFiles.OutputFile(templatesDir, entityTypeFileName, entityTemplate); var config = new ReverseEngineeringConfiguration { ConnectionString = testStore.Connection.ConnectionString, Provider = MetadataModelProvider, Namespace = "Test", OutputPath = outputDir, CustomTemplatePath = templatesDir }; var filePaths = await Generator.GenerateAsync(config); var expectedLog = new LoggerMessages { Info = { "Using custom template " + Path.Combine(templatesDir, dbContextFileName), "Using custom template " + Path.Combine(templatesDir, entityTypeFileName) } }; AssertLog(expectedLog); Assert.Equal(2, filePaths.Count); foreach (var fileName in filePaths.Select(Path.GetFileName)) { var fileContents = InMemoryFiles.RetrieveFileContents(outputDir, fileName); var contents = fileName.EndsWith("Context.cs") ? contextTemplate : entityTemplate; Assert.Equal(contents, fileContents); } } }
public SqliteMetadataModelProviderTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceCollection = new ServiceCollection(); serviceCollection.AddLogging(); new SqliteDesignTimeMetadataProviderFactory().AddMetadataProviderServices(serviceCollection); serviceCollection.AddSingleton <IFileService, FileSystemFileService>(); var serviceProvider = serviceCollection .BuildServiceProvider(); _logger = new TestLogger(); serviceProvider.GetService <ILoggerFactory>().AddProvider(new TestLoggerProvider(_logger)); _metadataModelProvider = serviceProvider .GetService <IDatabaseMetadataModelProvider>() as SqliteMetadataModelProvider; }
public override TestStore CreateTestStore(Type testStoreType) { if (testStoreType == typeof(InMemoryTestStore)) { return(new InMemoryTestStore()); } if (testStoreType == typeof(SqlServerTestStore)) { return(SqlServerTestStore.Create("SharedCrossStore")); } if (testStoreType == typeof(SqliteTestStore)) { return(SqliteTestStore.CreateScratch()); } throw new NotImplementedException(); }
public SqliteDatabaseModelFactoryTest() { _testStore = SqliteTestStore.CreateScratch(); var serviceCollection = new ServiceCollection().AddLogging(); new SqliteDesignTimeServices().ConfigureDesignTimeServices(serviceCollection); serviceCollection .AddSingleton <ILoggingOptions, LoggingOptions>() .AddSingleton(typeof(IInterceptingLogger <>), typeof(InterceptingLogger <>)); var serviceProvider = serviceCollection.BuildServiceProvider(); var logger = new TestLogger(); serviceProvider.GetService <ILoggerFactory>().AddProvider(new TestLoggerProvider(logger)); _factory = serviceProvider .GetService <IDatabaseModelFactory>() as SqliteDatabaseModelFactory; }
public OwnedQuerySqliteFixture() { var serviceProvider = new ServiceCollection() .AddEntityFrameworkSqlite() .AddSingleton(TestModelSource.GetFactory(OnModelCreating)) .AddSingleton <ILoggerFactory>(TestSqlLoggerFactory) .BuildServiceProvider(validateScopes: true); _testStore = SqliteTestStore.CreateScratch(); _options = new DbContextOptionsBuilder() .UseSqlite(_testStore.ConnectionString) .UseInternalServiceProvider(serviceProvider) .Options; using (var context = new DbContext(_options)) { context.Database.EnsureClean(); AddTestData(context); } }
public void Missing_primary_key() { using (var testStore = SqliteTestStore.CreateScratch()) { testStore.ExecuteNonQuery("CREATE TABLE Alicia ( Keys TEXT );"); var results = Generator.Generate( testStore.ConnectionString, Enumerable.Empty <string>(), Enumerable.Empty <string>(), TestProjectPath, outputPath: null, rootNamespace: "E2E.Sqlite", contextName: null, useDataAnnotations: UseDataAnnotations, overwriteFiles: false, useDatabaseNames: false); var errorMessage = DesignStrings.UnableToGenerateEntityType("Alicia"); Assert.Contains("warn: " + DesignStrings.MissingPrimaryKey("Alicia"), _reporter.Messages); Assert.Contains("warn: " + errorMessage, _reporter.Messages); Assert.Contains(errorMessage, InMemoryFiles.RetrieveFileContents(TestProjectFullPath, Path.GetFileName(results.ContextFile))); } }
public SqliteDatabaseModelFactoryTest() { _testStore = SqliteTestStore.CreateScratch(); _factory = new SqliteDatabaseModelFactory(); }