public void WillNotUpdateNoChanged()
{
task.Execute();
Assert.AreEqual(TaskState.Success, task.State);
task = new BxlDataProjectDataUpdateTask(dir)
{
Database = DbName
};
task.Execute();
Assert.AreEqual(TaskState.SuccessNotRun, task.State);
}
public void WillApplyChanged()
{
task.Execute();
Assert.AreEqual(TaskState.Success, task.State);
Thread.Sleep(500);
File.WriteAllText(file, @"
class a prototype = db-meta table=dbo.test
item id=10 code=X name=XX2
item id=20 code=Y name=YY
item id=30 code=Z name=ZZ2
");
task = new BxlDataProjectDataUpdateTask(dir)
{
Database = DbName
};
task.Execute();
Assert.AreEqual(TaskState.Success, task.State);
}
public void CanCreateSchemaAndLoadData()
{
var dtask = new BxlDataProjectDataUpdateTask(dir)
{
Database = DbName
};
var stask = new BxlDataProjectSchemaUpdateTask(dir)
{
Database = DbName
};
var job = new Job();
job.Tasks["dtask"] = dtask;
job.Tasks["stask"] = stask;
job.Execute();
Assert.True(job.Success);
var data = DbCommandExecutor.Default.GetResultSync(new DbCommandWrapper {
Notation = DbCallNotation.Reader,
Database = DbName,
Query = "select * from the.test order by id"
}) as object[];
Assert.AreEqual(5, data.Length);
}
public void Setup()
{
DbInstallFactory.InitTestDatabase(DbName);
dir = FileSystemHelper.ResetTemporaryDirectory();
file = Path.Combine(dir, "a.bxls");
file2 = Path.Combine(dir, "b.bxls");
file3 = Path.Combine(dir, "c.bxls");
var createtable = new ScriptTextDbUpdateTask("createtable", @"
create table dbo.test (
id int not null primary key,
code nvarchar(255) not null unique default '',
name nvarchar(255) not null default '',
version datetime not null default getdate()
)
create table dbo.test1 (
id int not null primary key,
code nvarchar(255) not null unique default '',
name nvarchar(255) not null default '',
version datetime not null default getdate(),
test2 int not null default 0
)
create table dbo.test2 (
id int not null primary key,
code nvarchar(255) not null unique default '',
name nvarchar(255) not null default '',
version datetime not null default getdate(),
test1 int not null default 0
)
GO
alter table dbo.test1 add constraint test2_fk foreign key (test2) references dbo.test2 (id)
GO
alter table dbo.test2 add constraint test1_fk foreign key (test1) references dbo.test1 (id)
")
{
Database = DbName
};
createtable.Execute();
Assert.AreEqual(TaskState.Success, createtable.State);
File.WriteAllText(file, @"
class a prototype = db-meta table=dbo.test
item id=10 code=X name=XX
item id=20 code=Y name=YY
item id=30 code=Z name=ZZ
");
File.WriteAllText(file2, @"
class b prototype = db-meta table=dbo.test1
item id=10 code=X name=XX test2=10
");
File.WriteAllText(file3, @"
class c prototype = db-meta table=dbo.test2
item id=10 code=Y name=YY test1=10
");
this.task = new BxlDataProjectDataUpdateTask(dir)
{
Database = DbName
};
}
