private static async Task Creates_physical_database_but_not_tables_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch(createDatabase: false)) { var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); Assert.False(creator.Exists()); if (async) { await creator.CreateAsync(); } else { creator.Create(); } Assert.True(creator.Exists()); if (testDatabase.Connection.State != ConnectionState.Open) { await testDatabase.Connection.OpenAsync(); } Assert.Equal(0, (await testDatabase.QueryAsync <string>( "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'")).Count()); Assert.True( await testDatabase.ExecuteScalarAsync <bool>( string.Concat( "SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name='", testDatabase.Connection.Database, "'"))); } }
private static async Task Returns_false_when_database_exists_but_has_no_tables_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch()) { var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); Assert.False(async ? await creator.HasTablesAsyncBase() : creator.HasTablesBase()); } }
private static async Task Returns_true_when_database_exists_and_has_any_tables_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch()) { await testDatabase.ExecuteNonQueryAsync("CREATE TABLE SomeTable (Id uniqueidentifier)"); var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); Assert.True(async ? await creator.HasTablesAsyncBase() : creator.HasTablesBase()); } }
public void Throws_when_no_initial_catalog() { var connectionStringBuilder = new SqlConnectionStringBuilder(TestEnvironment.DefaultConnection); connectionStringBuilder.Remove("Initial Catalog"); var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(connectionStringBuilder.ToString()); var ex = Assert.Throws <InvalidOperationException>(() => creator.Delete()); Assert.Equal(SqlServerStrings.NoInitialCatalog, ex.Message); }
private static async Task Throws_if_database_already_exists_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch()) { var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); var ex = async ? await Assert.ThrowsAsync <SqlException>(() => creator.CreateAsync()) : Assert.Throws <SqlException>(() => creator.Create()); Assert.Equal( 1801, // Database with given name already exists ex.Number); } }
private static async Task Throws_when_database_does_not_exist_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch(createDatabase: false)) { var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); if (async) { await Assert.ThrowsAsync <SqlException>(() => creator.DeleteAsync()); } else { Assert.Throws <SqlException>(() => creator.Delete()); } } }
private static async Task Creates_schema_in_existing_database_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch()) { using (var context = new SqlServerDatabaseCreatorTest.BloggingContext(testDatabase)) { var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(context); if (async) { await creator.CreateTablesAsync(); } else { creator.CreateTables(); } if (testDatabase.Connection.State != ConnectionState.Open) { await testDatabase.Connection.OpenAsync(); } var tables = (await testDatabase.QueryAsync <string>( "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'")).ToList(); Assert.Equal(1, tables.Count); Assert.Equal("Blogs", tables.Single()); var columns = (await testDatabase.QueryAsync <string>( "SELECT TABLE_NAME + '.' + COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Blogs'")).ToList(); Assert.Equal(14, columns.Count); Assert.True(columns.Any(c => c == "Blogs.Key1")); Assert.True(columns.Any(c => c == "Blogs.Key2")); Assert.True(columns.Any(c => c == "Blogs.Cheese")); Assert.True(columns.Any(c => c == "Blogs.ErMilan")); Assert.True(columns.Any(c => c == "Blogs.George")); Assert.True(columns.Any(c => c == "Blogs.TheGu")); Assert.True(columns.Any(c => c == "Blogs.NotFigTime")); Assert.True(columns.Any(c => c == "Blogs.ToEat")); Assert.True(columns.Any(c => c == "Blogs.OrNothing")); Assert.True(columns.Any(c => c == "Blogs.Fuse")); Assert.True(columns.Any(c => c == "Blogs.WayRound")); Assert.True(columns.Any(c => c == "Blogs.On")); Assert.True(columns.Any(c => c == "Blogs.AndChew")); Assert.True(columns.Any(c => c == "Blogs.AndRow")); } } }
private static async Task Throws_if_database_does_not_exist_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch(createDatabase: false)) { var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); var errorNumber = async ? (await Assert.ThrowsAsync <SqlException>(() => creator.CreateTablesAsync())).Number : Assert.Throws <SqlException>(() => creator.CreateTables()).Number; if (errorNumber != 233) // skip if no-process transient failure { Assert.Equal( 4060, // Login failed error number errorNumber); } } }
private static async Task Deletes_database_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch()) { testDatabase.Connection.Close(); var creator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); Assert.True(async ? await creator.ExistsAsync() : creator.Exists()); if (async) { await creator.DeleteAsync(); } else { creator.Delete(); } Assert.False(async ? await creator.ExistsAsync() : creator.Exists()); } }
private static async Task Throws_when_database_does_not_exist_test(bool async) { using (var testDatabase = SqlServerTestStore.CreateScratch(createDatabase: false)) { var databaseCreator = SqlServerDatabaseCreatorTest.GetDatabaseCreator(testDatabase); await databaseCreator.ExecutionStrategyFactory.Create().ExecuteAsync( databaseCreator, async creator => { var errorNumber = async ? (await Assert.ThrowsAsync <SqlException>(() => creator.HasTablesAsyncBase())).Number : Assert.Throws <SqlException>(() => creator.HasTablesBase()).Number; if (errorNumber != 233) // skip if no-process transient failure { Assert.Equal( 4060, // Login failed error number errorNumber); } }); } }