public override string GenerateCreateTableFullDdl([NotNull] DatabaseConnection databaseConnection, string database, string schema, [NotNull] string tableName) { if (databaseConnection == null) { throw new ArgumentNullException("databaseConnection"); } if (tableName == null) { throw new ArgumentNullException("tableName"); } var repo = new DB4Repository(databaseConnection.ConnectionString); var generator = new Generator4(repo); generator.GenerateTableCreate(tableName); var infoProvider = databaseConnection.DatabaseServer.GetInfoProvider(); using (var connection = databaseConnection.CreateNewConnection()) { connection.OpenIfRequired(); var indexes = infoProvider.GetIndexesForTable(connection, schema, tableName); foreach (var index in indexes) { generator.GenerateIndexScript(tableName, index.Name); } } return(generator.GeneratedScript); }
public void TestServerTableGenWithGeography() { using (IRepository sourceRepository = new ServerDBRepository4(@"Data Source=.\SQL2016DEV;Initial Catalog=AW2014Geo;Integrated Security=true;")) { var generator = new Generator4(sourceRepository); generator.GenerateTableCreate("Address"); var script = generator.GeneratedScript; } }
public void TestSQLiteDataTypes() { //cloud_service_product_infos //;DateFormatString=yyyy-MM-dd HH:mm:ss zzz using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Users\erik\Downloads\spiceworks_prod.db")) { var generator = new Generator4(sourceRepository, "sw.sql"); generator.GenerateTableCreate("alerts"); } }
public void TestSQLiteDataTypes() { //cloud_service_product_infos //;DateFormatString=yyyy-MM-dd HH:mm:ss zzz using (IRepository sourceRepository = new SQLiteRepository(chinookSQLiteConnectionString)) { var generator = new Generator4(sourceRepository, "sw.sql", false, false, true); generator.GenerateTableCreate("Artist"); Assert.IsTrue(generator.GeneratedScript.Contains("INTEGER")); } }
public void TestSQLiteDataTypes() { //cloud_service_product_infos //;DateFormatString=yyyy-MM-dd HH:mm:ss zzz using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Code\SqlCeToolbox\src\API\SqlCeScripting40\Tests\chinook.db")) { var generator = new Generator4(sourceRepository, "sw.sql", false, false, true); generator.GenerateTableCreate("Artist"); Assert.IsTrue(generator.GeneratedScript.Contains("INTEGER")); } }
public override string GenerateCreateTableDdl([NotNull] DatabaseConnection databaseConnection, string database, string schema, [NotNull] string tableName) { if (databaseConnection == null) { throw new ArgumentNullException("databaseConnection"); } if (tableName == null) { throw new ArgumentNullException("tableName"); } var repo = new DB4Repository(databaseConnection.ConnectionString); var generator = new Generator4(repo); generator.GenerateTableCreate(tableName); return(generator.GeneratedScript); }
public void TestSQLiteDataTypes() { //cloud_service_product_infos //;DateFormatString=yyyy-MM-dd HH:mm:ss zzz using (IRepository sourceRepository = new SQLiteRepository(@"Data Source=C:\Users\erik\Downloads\spiceworks_prod.db")) { var generator = new Generator4(sourceRepository, "sw.sql"); generator.GenerateTableCreate("alerts"); } }