forked from d4software/QueryTree
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDataTableTests.cs
More file actions
70 lines (62 loc) · 1.86 KB
/
DataTableTests.cs
File metadata and controls
70 lines (62 loc) · 1.86 KB
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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
using System;
using Xunit;
using QueryTree.Engine;
using System.Collections.Generic;
namespace QueryTree.Engine.Tests
{
public class DataTableTests
{
private string NodesJson
{
get
{
return @"[
{
""Id"": ""1"",
""Type"": ""Data Table"",
""Table"": ""employees""
}
]";
}
}
private List<ITableInfo> DatabaseInfo
{
get
{
return new List<ITableInfo>()
{
new MockTableInfo()
{
DisplayName = "employees",
Columns = new List<IColumnInfo>()
{
new MockColumnInfo() { DataType = "int", Name = "ID" },
new MockColumnInfo() { DataType = "varchar", Name = "Name" }
}
}
};
}
}
[Fact]
public void TestFromClause()
{
var query = new Query(
DatabaseType.MySQL,
NodesJson,
DatabaseInfo);
var sql = query.GetSql("1");
Assert.True(sql.Contains("FROM `employees` AS"), "SQL Value was: " + sql);
}
[Fact]
public void TestColumns()
{
var query = new Query(
DatabaseType.MySQL,
NodesJson,
DatabaseInfo);
var sql = query.GetSql("1");
Assert.True(sql.Contains("`ID` AS "), "SQL Value was: " + sql);
Assert.True(sql.Contains("`Name` AS "), "SQL Value was: " + sql);
}
}
}