public async Task TestAlterTable_AddForeignConstraint()
{
this.BeforeEach();
var dbName = "db1";
var tableName = "posts";
var columnName = "id";
var fk = "user_id";
var tableReferenced = "users";
EasyMig.AlterTable(tableName).AddForeignKeyConstraint(fk, tableReferenced, columnName);
EasyMig.ToMySql.DoMigrationsFromMemory(completeConnectionString);
// var query = EasyMig.ToMySql.GetMigrationQuery();
// EasyMig.ToMySql.ExecuteQuery(query, completeConnectionString);
await Task.Delay(200);
var table = EasyMig.Information.MySql.GetTable(dbName, tableName, connectionString);
Assert.AreEqual(true, table.IsForeignKey(fk));
}
public async Task TestAlterTable_DropColumn()
{
this.BeforeEach();
var dbName = "db1";
var tableName = "posts";
var columnName = "title";
Assert.IsTrue(EasyMig.Information.MySql.ColumnExists(dbName, tableName, columnName, connectionString));
EasyMig.AlterTable(tableName).DropColumn(columnName);
var query = EasyMig.ToMySql.GetMigrationQuery();
EasyMig.ToMySql.ExecuteQuery(query, completeConnectionString);
await Task.Delay(200);
Assert.IsFalse(EasyMig.Information.MySql.ColumnExists(dbName, tableName, columnName, connectionString));
var table = EasyMig.Information.MySql.GetTable(dbName, tableName, connectionString);
Assert.IsNotNull(table);
Assert.IsFalse(table.HasColumn(columnName));
}
public async Task TestAlterTable_AddPrimaryConstraint()
{
var tableName = "sqlfile_posts";
var columnName = "id";
EasyMig.AlterTable(tableName).AddPrimaryKeyConstraint(columnName);
EasyMig.ToSqlServer.DoMigrationsFromMemory(connectionString);
await Task.Delay(200);
var table = EasyMig.Information.SqlServerAttachedDbFile.GetTable(tableName, connectionString);
Assert.AreEqual(true, table.IsPrimaryKey(columnName));
}
public async Task TestAlterTable_ModifyColumn()
{
var tableName = "sqlfile_posts";
var columnName = "title";
Assert.IsTrue(EasyMig.Information.SqlServerAttachedDbFile.ColumnExists(tableName, columnName, connectionString));
EasyMig.AlterTable(tableName).ModifyColumn(columnName, ColumnType.VarChar(), true);
EasyMig.ToSqlServer.DoMigrationsFromMemory(connectionString);
await Task.Delay(200);
var table = EasyMig.Information.SqlServerAttachedDbFile.GetTable(tableName, connectionString);
Assert.AreEqual("YES", table.GetColumn(columnName)["IS_NULLABLE"]);
}
public async Task TestAlterTable_AddForeignConstraint()
{
var tableName = "sqlfile_posts";
var columnName = "id";
var fk = "user_id";
var tableReferenced = "sqlfile_users";
EasyMig.AlterTable(tableName).AddForeignKeyConstraint(fk, tableReferenced, columnName);
EasyMig.ToSqlServer.DoMigrationsFromMemory(connectionString);
await Task.Delay(200);
var table = EasyMig.Information.SqlServerAttachedDbFile.GetTable(tableName, connectionString);
Assert.AreEqual(true, table.IsForeignKey(fk));
}
public async Task TestAlterTable_AddPrimaryConstraint()
{
this.BeforeEach();
var dbName = "db1";
var tableName = "posts";
var columnName = "id";
EasyMig.AlterTable(tableName).AddPrimaryKeyConstraint(columnName);
var query = EasyMig.ToMySql.GetMigrationQuery();
EasyMig.ToMySql.ExecuteQuery(query, completeConnectionString);
await Task.Delay(200);
var table = EasyMig.Information.MySql.GetTable(dbName, tableName, connectionString);
Assert.AreEqual(true, table.IsPrimaryKey(columnName));
}
public async Task TestAlterTable_DropColumn()
{
var tableName = "sqlfile_posts";
var columnName = "title";
Assert.IsTrue(EasyMig.Information.SqlServerAttachedDbFile.ColumnExists(tableName, columnName, connectionString));
EasyMig.AlterTable(tableName).DropColumn(columnName);
EasyMig.ToSqlServer.DoMigrationsFromMemory(connectionString);
await Task.Delay(200);
Assert.IsFalse(EasyMig.Information.SqlServerAttachedDbFile.ColumnExists(tableName, columnName, connectionString));
var table = EasyMig.Information.SqlServerAttachedDbFile.GetTable(tableName, connectionString);
Assert.IsNotNull(table);
Assert.IsFalse(table.HasColumn(columnName));
}
public async Task TestAlterTable_AddColumn()
{
var dbName = "sql_db1";
var tableName = "sql_posts";
var columnName = "user_id";
Assert.IsFalse(EasyMig.Information.SqlServer.ColumnExists(dbName, tableName, columnName, connectionString));
EasyMig.AlterTable(tableName).AddColumn(columnName, ColumnType.Int(true));
EasyMig.ToSqlServer.DoMigrationsFromMemory(connectionString);
await Task.Delay(200);
Assert.IsTrue(EasyMig.Information.SqlServer.ColumnExists(dbName, tableName, columnName, connectionString));
var table = EasyMig.Information.SqlServer.GetTable(dbName, tableName, connectionString);
Assert.IsNotNull(table);
Assert.IsTrue(table.HasColumn(columnName));
}
public async Task TestAlterTable_ModifyColumn()
{
this.BeforeEach();
var dbName = "db1";
var tableName = "posts";
var columnName = "title";
Assert.IsTrue(EasyMig.Information.MySql.ColumnExists(dbName, tableName, columnName, connectionString));
EasyMig.AlterTable(tableName).ModifyColumn(columnName, ColumnType.VarChar(), true);
var query = EasyMig.ToMySql.GetMigrationQuery();
EasyMig.ToMySql.ExecuteQuery(query, completeConnectionString);
await Task.Delay(200);
var table = EasyMig.Information.MySql.GetTable(dbName, tableName, connectionString);
Assert.AreEqual("YES", table.GetColumn(columnName)["IS_NULLABLE"]);
}
