Exemplo n.º 1
0
 public void MigrationGenerateCreateTablesSql()
 {
     Migration m = new MigrationTest001();
     string sql = m.BuildSqlStatement(Migration.MigrationDirection.Up);
     Assert.AreEqual(
         "CREATE TABLE [Distribution] (\r\n  [Id] int NOT NULL PRIMARY KEY IDENTITY(1,1),\r\n  [Name] nvarchar(20) NULL,\r\n  [Capacity] int NULL \r\n);\r\nCREATE TABLE [ShipStatus] (\r\n  [ShipStatusId] int NOT NULL PRIMARY KEY IDENTITY(1,1),\r\n  [Status] nvarchar(50) NULL,\r\n  [Code] nvarchar(4) NULL,\r\n  [CreatedOn] datetime NOT NULL CONSTRAINT DF_ShipStatus_CreatedOn DEFAULT (getdate()),\r\n  [ModifiedOn] datetime NOT NULL CONSTRAINT DF_ShipStatus_ModifiedOn DEFAULT (getdate()),\r\n  [CreatedBy] nvarchar(64) NULL,\r\n  [ModifiedBy] nvarchar(64) NULL \r\n);\r\n",
         sql);
 }
Exemplo n.º 2
0
        public void MigrationGenerateCreateTablesSql()
        {
            Migration m   = new MigrationTest001();
            string    sql = m.BuildSqlStatement(Migration.MigrationDirection.Up);

            Assert.AreEqual(
                "CREATE TABLE [Distribution] (\r\n  [Id] int NOT NULL PRIMARY KEY IDENTITY(1,1),\r\n  [Name] nvarchar(20) NULL,\r\n  [Capacity] int NULL \r\n);\r\nCREATE TABLE [ShipStatus] (\r\n  [ShipStatusId] int NOT NULL PRIMARY KEY IDENTITY(1,1),\r\n  [Status] nvarchar(50) NULL,\r\n  [Code] nvarchar(4) NULL,\r\n  [CreatedOn] datetime NOT NULL CONSTRAINT DF_ShipStatus_CreatedOn DEFAULT (getdate()),\r\n  [ModifiedOn] datetime NOT NULL CONSTRAINT DF_ShipStatus_ModifiedOn DEFAULT (getdate()),\r\n  [CreatedBy] nvarchar(64) NULL,\r\n  [ModifiedBy] nvarchar(64) NULL \r\n);\r\n",
                sql);
        }
Exemplo n.º 3
0
        public void MigrationGenerateDropTablesSql()
        {
            //get a table in there to drop
            Migration m = new MigrationTest001();
            m.Migrate("Northwind", Migration.MigrationDirection.Up);
            DataService.ClearSchemaCache("Northwind");

            string sql = m.BuildSqlStatement(Migration.MigrationDirection.Down);
            Assert.AreEqual("DROP TABLE [dbo].[Distribution];\r\nDROP TABLE [dbo].[ShipStatus];\r\n", sql);
        }
Exemplo n.º 4
0
 public void MigrationGenerateDropTablesSql()
 {   // Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
     //get a table in there to drop         // SQLite error near "AUTOINCREMENT": syntax error
     Migration m = new MigrationTest001();
     m.Migrate("Northwind", Migration.MigrationDirection.Up);
     // The database file is locked
     DataService.ClearSchemaCache("Northwind");
     
     string sql = m.BuildSqlStatement(Migration.MigrationDirection.Down);
     Assert.AreEqual("DROP TABLE `main`.`Distribution`;\r\nDROP TABLE `main`.`ShipStatus`;\r\n", sql);
 }
Exemplo n.º 5
0
        public void MigrationGenerateDropTablesSql()
        {
            //get a table in there to drop
            Migration m = new MigrationTest001();

            m.Migrate("Northwind", Migration.MigrationDirection.Up);
            DataService.ClearSchemaCache("Northwind");

            string sql = m.BuildSqlStatement(Migration.MigrationDirection.Down);

            Assert.AreEqual("DROP TABLE [dbo].[Distribution];\r\nDROP TABLE [dbo].[ShipStatus];\r\n", sql);
        }
Exemplo n.º 6
0
        public void MigrationMySql()
        {
            Migration m = new MigrationTest001();

            //test the up
            m.Migrate("Southwind", Migration.MigrationDirection.Up);
            Assert.IsTrue(DataService.TableExists("Southwind", "Distribution"));
            Assert.IsTrue(DataService.TableExists("Southwind", "ShipStatus"));

            //needed to clear schema cache for the DropTable call
            //in the Down() method of the migration.  Not needed
            //for the above TableExists because that always
            //goes to the DB to check
            DataService.ClearSchemaCache("Southwind");

            //test the down
            m.Migrate("Southwind", Migration.MigrationDirection.Down);
            Assert.IsFalse(DataService.TableExists("Southwind", "Distribution"));
            Assert.IsFalse(DataService.TableExists("Southwind", "ShipStatus"));
        }
Exemplo n.º 7
0
        public void MigrationGenerateCreateTablesSql()
        {
            Migration m = new MigrationTest001();
            string sql = m.BuildSqlStatement(Migration.MigrationDirection.Up);

            string expected =
                "CREATE TABLE `Distribution` (\r\n" +
                "  `Id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,\r\n" +
                "  `Name` nvarchar(20) NULL,\r\n" +
                "  `Capacity` INTEGER NULL \r\n" + 
                ");\r\n" +
                "CREATE TABLE `ShipStatus` (\r\n" +
                "  `ShipStatusId` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,\r\n" +
                "  `Status` nvarchar(50) NULL,\r\n" +
                "  `Code` nvarchar(4) NULL,\r\n" +
                "  `CreatedOn` datetime ,\r\n" +
                "  `ModifiedOn` datetime ,\r\n" +
                "  `CreatedBy` nvarchar(64) NULL,\r\n" +
                "  `ModifiedBy` nvarchar(64) NULL \r\n" + 
                ");\r\n";
            
            Assert.AreEqual(expected, sql);

        }
Exemplo n.º 8
0
        public void MigrationUpDown()
        {
            Migration m = new MigrationTest001();

            //test the up
            m.Migrate("Northwind", Migration.MigrationDirection.Up);
            Assert.IsTrue(DataService.TableExists("Northwind", "Distribution"));
            Assert.IsTrue(DataService.TableExists("Northwind", "ShipStatus"));

            //needed to clear schema cache for the DropTable call
            //in the Down() method of the migration.  Not needed
            //for the above TableExists because that always
            //goes to the DB to check
            DataService.ClearSchemaCache("Northwind");

            //test the down
            m.Migrate("Northwind", Migration.MigrationDirection.Down);
            Assert.IsFalse(DataService.TableExists("Northwind", "Distribution"));
            Assert.IsFalse(DataService.TableExists("Northwind", "ShipStatus"));
        }