public void TestCreateSQLiteTable() { using (IRepository sourceRepository = new SQLiteRepository(chinookSQLiteConnectionString)) { var generator = new Generator4(sourceRepository, null, false, false, true); generator.GenerateTableScript("Album"); var result = generator.GeneratedScript; var lines = Regex.Split(result, "\r\n|\r|\n"); Assert.AreEqual(10, lines.Length, result); } }
public void TestCreateSqliteUneditableTable() { using (IRepository sourceRepository = new SQLiteRepository(db21Conn)) { var generator = new Generator4(sourceRepository, null, false, false, true); var tables = sourceRepository.GetAllTableNames(); generator.GenerateTableScript("Users"); var result = generator.GeneratedScript; var lines = Regex.Split(result, "\r\n|\r|\n"); Assert.AreEqual(18, lines.Length, result); } }
public void TestServerExportUniqueIssue() { string path = @"C:\temp\E2E.sqlce"; using (IRepository sourceRepository = new ServerDBRepository4(E2EConnectionString)) { var generator = new Generator4(sourceRepository, path); generator.ExcludeTables(new List <string>()); generator.GenerateTableScript("OneToOneSeparateFKDependent"); var test = generator.GeneratedScript; } }
private void AssertMsSqlToSqliteGeneratorContains(string createTableQuery, string tableName, string expectedSql) { // connect to database server string connectionString = @"Data Source=.\sqlexpress;Integrated Security=SSPI;"; // create a new random database name string databaseName = this.RandomString(10); using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); while (sqlConnection.DatabaseExists(databaseName)) { // create a new random database name databaseName = this.RandomString(10); } using (TempDatabase tempDatabase = new TempDatabase(sqlConnection, databaseName)) { using (SqlConnection tempSqlConnection = new SqlConnection(tempDatabase.ConnectionString)) { tempSqlConnection.Open(); tempSqlConnection.Execute(createTableQuery); } string sql = null; using (var repository = new ServerDBRepository4(tempDatabase.ConnectionString, false)) { Generator4 generator = new Generator4( repository, null, false, false, true); generator.GenerateTableScript(tableName); sql = generator.GeneratedScript; } Assert.IsTrue(sql.Contains(expectedSql), sql); } } }
public void TestServerExportUniqueIssue() { string path = @"C:\temp\E2E.sqlce"; using (IRepository sourceRepository = new ServerDBRepository4(E2EConnectionString)) { var generator = new Generator4(sourceRepository, path); generator.ExcludeTables(new List<string>()); generator.GenerateTableScript("OneToOneSeparateFKDependent"); var test = generator.GeneratedScript; } }
public void TestCreateSQLiteTable() { using (IRepository sourceRepository = new SQLiteRepository(chinookSQLiteConnectionString)) { var generator = new Generator4(sourceRepository, null, false, false, true); generator.GenerateTableScript("Album"); var result = generator.GeneratedScript; var lines = Regex.Split(result, "\r\n|\r|\n"); Assert.IsTrue(lines.Length == 11); } }