public void Get()
{
AllPrimitive insertEntity = InsertReturnIdImpl(out long id);
var entity = SqlMapper.GetById <AllPrimitive, long>(id);
Assert.NotNull(entity);
}
public void Insert_Return_Id()
{
AllPrimitive insertEntity = InsertReturnIdImpl(out long id);
Assert.NotEqual(0, id);
Assert.Equal(id, insertEntity.Id);
}
public int Update(AllPrimitive entity)
{
using (var dbSession = _dbSessionFactory.Open())
{
return(dbSession.Update <AllPrimitive>(entity));
}
}
public long Insert(AllPrimitive entity)
{
using (var dbSession = _dbSessionFactory.Open())
{
return(dbSession.Insert <AllPrimitive, long>(entity));
}
}
public void DeleteById()
{
AllPrimitive insertEntity = InsertReturnIdImpl(out long id);
var recordsAffected = SqlMapper.DeleteById <AllPrimitive, long>(id);
Assert.NotEqual(0, recordsAffected);
}
public void DyUpdate()
{
AllPrimitive insertEntity = InsertReturnIdImpl(out long id);
var recordsAffected = SqlMapper.DyUpdate <AllPrimitive>(new { Id = id, Boolean = true });
Assert.NotEqual(0, recordsAffected);
}
public void DyUpdate_Dic()
{
AllPrimitive insertEntity = InsertReturnIdImpl(out long id);
var recordsAffected = SqlMapper.DyUpdate<AllPrimitive>(new Dictionary<String, object>
{
{"Id", id},
{"Boolean", true}
});
Assert.NotEqual(0, recordsAffected);
}
public void Insert()
{
var insertEntity = new AllPrimitive
{
String = "Insert",
DateTime = DateTime.Now
};
var recordsAffected = SqlMapper.Insert<AllPrimitive>(insertEntity);
Assert.NotEqual(0, recordsAffected);
}
public void Get_Int32()
{
var obj = new AllPrimitive {
};
EmitGetAccessorFactory getAccessorFactory = new EmitGetAccessorFactory();
var get_Id = getAccessorFactory.Create(typeof(AllPrimitive), nameof(AllPrimitive.Int32));
var id = get_Id(obj);
Assert.Equal(id, obj.Int32);
}
private AllPrimitive InsertReturnIdImpl(out long id)
{
var insertEntity = new AllPrimitive
{
String = "Insert",
DateTime = DateTime.Now
};
id = SqlMapper.Insert<AllPrimitive, long>(insertEntity);
return insertEntity;
}
public void Set_Int32()
{
var obj = new AllPrimitive {
};
ISetAccessorFactory setAccessorFactory = EmitSetAccessorFactory.Instance;
var set_Int32 = setAccessorFactory.Create(typeof(AllPrimitive), nameof(AllPrimitive.Int32));
set_Int32(obj, 1);
Assert.Equal(1, obj.Int32);
}
public void Set_Id()
{
var obj = new AllPrimitive {
};
EmitSetAccessorFactory setAccessorFactory = new EmitSetAccessorFactory();
var set_Id = setAccessorFactory.Create(typeof(AllPrimitive), nameof(AllPrimitive.Id));
set_Id(obj, 1L);
Assert.Equal(1L, obj.Id);
}
public void Get_Int32()
{
var obj = new AllPrimitive {
};
IGetAccessorFactory getAccessorFactory = EmitGetAccessorFactory.Instance;
getAccessorFactory.TryCreate(typeof(AllPrimitive), nameof(AllPrimitive.Int32), out var get_Id);
var id = get_Id(obj);
Assert.Equal(id, obj.Int32);
}
private AllPrimitive InsertReturnIdImpl(out long id)
{
var insertEntity = new AllPrimitive
{
String = "Insert",
DateTime = DateTime.Now
};
id = DbSession.Insert <AllPrimitive, long>(insertEntity);
return(insertEntity);
}
public void Get_String()
{
var obj = new AllPrimitive {
String = "SmartSql"
};
EmitGetAccessorFactory getAccessorFactory = new EmitGetAccessorFactory();
var get_String = getAccessorFactory.Create(typeof(AllPrimitive), nameof(AllPrimitive.String));
var str = get_String(obj);
Assert.Equal(str, obj.String);
}
public void Get_String()
{
var obj = new AllPrimitive {
String = "SmartSql"
};
IGetAccessorFactory getAccessorFactory = EmitGetAccessorFactory.Instance;
getAccessorFactory.TryCreate(typeof(AllPrimitive), nameof(AllPrimitive.String), out var get_String);
var str = get_String(obj);
Assert.Equal(str, obj.String);
}
public void Update()
{
AllPrimitive insertEntity = InsertReturnIdImpl(out long id);
var recordsAffected = SqlMapper.Update<AllPrimitive>(new AllPrimitive
{
Id = id,
String = "Update",
Boolean = true,
DateTime = DateTime.Now
});
Assert.NotEqual(0, recordsAffected);
}
public void Test1()
{
DateTime.TryParse("12 31 2018 11:42AM", out var dateTime);
var yes = new AllPrimitive() as dynamic;
var id = yes.Id;
IList <dynamic> list = new List <dynamic>();
IDictionary <string, object> exObj = new ExpandoObject();
exObj.Add("1", 2);
list.Add(exObj);
var type = typeof(ITypeHandler <,>);
var typeStr = Assembly.Load("SmartSql").GetType("SmartSql.TypeHandlers.ITypeHandler`1");
}
public void InsertByIdGen()
{
var entity = new AllPrimitive
{
DateTime = DateTime.Now,
String = "SmartSql",
};
var id = SqlMapper.ExecuteScalar <long>(new RequestContext
{
Scope = nameof(AllPrimitive),
SqlId = "InsertByIdGen",
Request = entity
});
}
public void InsertByIdGenAssignId()
{
var entity = new AllPrimitive
{
DateTime = DateTime.Now,
String = "SmartSql",
};
var affected = SqlMapper.Execute(new RequestContext
{
Scope = nameof(AllPrimitive),
SqlId = "InsertByIdGenAssignId",
Request = entity
});
Assert.True(entity.Int64 > 0);
}
public int Update(AllPrimitive entity)
{
return(_sqlMapper.Update <AllPrimitive>(entity));
}
public long Insert(AllPrimitive entity)
{
return(_sqlMapper.Insert <AllPrimitive, long>(entity));
}
