public void ParseQuery()
{
var tt = @"/*use his*/
select * from t1 where time between '{Start}' and '{End}'
";
var section = new SqlSection();
section.Parse(tt);
Assert.Equal("his", section.ConnName);
Assert.Equal(SqlActions.Query, section.Action);
Assert.Equal("select * from t1 where time between '{Start}' and '{End}'", section.Sql);
}
public void ParseDelete()
{
var tt = @"/*use his*/
delete from t2 where time between '{Start}' and '{End}';
";
var section = new SqlSection();
section.Parse(tt);
Assert.Equal("his", section.ConnName);
Assert.Equal(SqlActions.Execute, section.Action);
Assert.Equal("delete from t2 where time between '{Start}' and '{End}'", section.Sql);
}
public void ParseUpdate()
{
var tt = @"/*use his*/
update t1 set c1=v1, c2=v2 where id=123;
";
var section = new SqlSection();
section.Parse(tt);
Assert.Equal("his", section.ConnName);
Assert.Equal(SqlActions.Execute, section.Action);
Assert.Equal("update t1 set c1=v1, c2=v2 where id=123", section.Sql);
}
public void ParseInsert()
{
var tt = @"/*use his*/
insert into t1 (c1, c2) values(v1, v2);
";
var section = new SqlSection();
section.Parse(tt);
Assert.Equal("his", section.ConnName);
Assert.Equal(SqlActions.Execute, section.Action);
Assert.Equal("insert into t1 (c1, c2) values(v1, v2)", section.Sql);
}
public void ParseBatchInsert()
{
var tt = @"/*use his_bak*/
insert t2;
";
var section = new SqlSection();
section.Parse(tt);
Assert.Equal("his_bak", section.ConnName);
Assert.Equal(SqlActions.Insert, section.Action);
Assert.Equal("insert t2", section.Sql);
}
