blob: 4d4cc3606b7900b4274d371005b7238cf0943b95 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
namespace CrupestApi.Commons.Crud.Tests;
public class TableInfoTest
{
private static TableInfoFactory TableInfoFactory = new TableInfoFactory(new ColumnTypeProvider());
private TableInfo _tableInfo;
public TableInfoTest()
{
_tableInfo = TableInfoFactory.Get(typeof(TestEntity));
}
[Fact]
public void TestColumnCount()
{
Assert.Equal(4, _tableInfo.ColumnInfos.Count);
Assert.Equal(3, _tableInfo.ColumnProperties.Count);
Assert.Equal(1, _tableInfo.NonColumnProperties.Count);
}
[Fact]
public void GenerateSelectSqlTest()
{
var (sql, parameters) = _tableInfo.GenerateSelectSql(null, WhereClause.Create().Eq("Name", "Hello"));
var parameterName = parameters.ParameterNames.First();
// TODO: Is there a way to auto detect parameters?
SqlCompareHelper.SqlEqual($"SELECT * FROM TestEntity WHERE (Name = @{parameterName})", sql);
Assert.Equal("Hello", parameters.Get<string>(parameterName));
}
}
|
