blob: c6791c603242085ffdc803f7365d3484d8192c17 (
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
33
34
|
using Xunit.Abstractions;
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(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));
}
}
|
