public void Init()
{
var options = new MyStaging.Metadata.StagingOptions("MySql", ConstantUtil.MYSQL_CONNECTION);
var context = new MySqlDbContext(options);
Assert.NotNull(context.User);
}
public void Transaction()
{
var options = new MyStaging.Metadata.StagingOptions("MySql", ConstantUtil.MYSQL_CONNECTION);
var context = new MySqlDbContext(options);
context.BeginTransaction();
Assert.Single(context.Trans);
context.CommitTransaction();
Assert.Equal(0, context.Trans.Keys.Count);
context.BeginTransaction();
Assert.Single(context.Trans);
context.RollBackTransaction();
Assert.Equal(0, context.Trans.Keys.Count);
}
public void Visit()
{
var options = new MyStaging.Metadata.StagingOptions("MySql", ConstantUtil.MYSQL_CONNECTION);
var context = new MySqlDbContext(options);
Expression <Func <UserModel, bool> > predicate = (f) => f.Id == 1;
DbExpressionVisitor exp = new DbExpressionVisitor
{
TypeMaster = typeof(UserModel),
AliasMaster = "a",
AliasUnion = null
};
exp.Visit(predicate);
var sql = exp.SqlText.Builder.ToString();
testOutput.WriteLine(sql);
Assert.StartsWith("(a.Id = @", sql);
var count = exp.SqlText.Parameters.Count;
Assert.Equal(1, count);
predicate = (f) => f.Id == 1 && f.IP == "127.0.0.1";
exp = new DbExpressionVisitor
{
TypeMaster = typeof(UserModel),
AliasMaster = "a",
AliasUnion = null
};
exp.Visit(predicate);
sql = exp.SqlText.Builder.ToString();
testOutput.WriteLine(sql);
Assert.StartsWith("((a.Id = @", sql);
Assert.EndsWith("))", sql);
count = exp.SqlText.Parameters.Count;
Assert.Equal(2, count);
}
