-
Notifications
You must be signed in to change notification settings - Fork 458
/
Copy pathTestProvName.cs
248 lines (218 loc) · 14.6 KB
/
TestProvName.cs
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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
using LinqToDB;
namespace Tests
{
public static class TestProvName
{
#region SQLite
public const string NorthwindSQLite = "Northwind.SQLite";
public const string NorthwindSQLiteMS = "Northwind.SQLite.MS";
public const string AllSQLiteNorthwind = $"{NorthwindSQLite},{NorthwindSQLiteMS}";
/// <summary>
/// SQLite classic provider wrapped into MiniProfiler without mappings to provider types configured.
/// Used to test general compatibility of linq2db with wrapped providers.
/// </summary>
public const string SQLiteClassicMiniProfilerUnmapped = "SQLite.Classic.MPU";
/// <summary>
/// SQLite classic provider wrapped into MiniProfiler with mappings to provider types configured.
/// Used to test general compatibility of linq2db with wrapped providers.
/// </summary>
public const string SQLiteClassicMiniProfilerMapped = "SQLite.Classic.MPM";
public const string AllSQLiteBase = $"{ProviderName.SQLiteClassic},{ProviderName.SQLiteMS}";
public const string AllSQLiteMP = "SQLite.Classic.MPU,SQLite.Classic.MPM";
public const string AllSQLite = $"{AllSQLiteBase},{AllSQLiteMP}";
public const string AllSQLiteClassic = $"{ProviderName.SQLiteClassic},{AllSQLiteMP}";
#endregion
#region MySQL/MariaDB
/// <summary>
/// MySQL 5.7 over MySqlConnector.
/// </summary>
public const string MySql57Connector = "MySqlConnector.5.7";
/// <summary>
/// MySQL 8.x over MySqlConnector.
/// </summary>
public const string MySql80Connector = "MySqlConnector.8.0";
/// <summary>
/// MySQL 8.x over MySqlConnector.
/// </summary>
public const string MariaDB11Connector = "MariaDB.11";
/// <summary>
/// All MySql.Data providers.
/// </summary>
public const string AllMySqlData = $"{ProviderName.MySql57},{ProviderName.MySql80}";
/// <summary>
/// All MySqlConnector providers.
/// </summary>
public const string AllMySqlConnector = $"{MySql57Connector},{MySql80Connector},{MariaDB11Connector}";
/// <summary>
/// All mysql/mariadb test providers.
/// </summary>
public const string AllMySql = $"{AllMySqlData},{AllMySqlConnector}";
/// <summary>
/// All mysql test providers (no mariadb).
/// </summary>
public const string AllMySqlServer = $"{ProviderName.MySql57},{MySql57Connector},{ProviderName.MySql80},{MySql80Connector}";
/// <summary>
/// All mariadb test providers.
/// </summary>
public const string AllMariaDB = MariaDB11Connector;
/// <summary>
/// MySQL 5.7.
/// </summary>
public const string AllMySql57 = $"{ProviderName.MySql57},{MySql57Connector}";
/// <summary>
/// MySQL 5.7.
/// </summary>
public const string AllMySql80 = $"{ProviderName.MySql80},{MySql80Connector}";
/// <summary>
/// MySQL 8.x and MariaDB.
/// </summary>
public const string AllMySql8Plus = $"{ProviderName.MySql80},{MySql80Connector},{MariaDB11Connector}";
/// <summary>
/// MySQL/MariaDB with CTE support.
/// </summary>
public const string AllMySqlWithCTE = AllMySql8Plus;
/// <summary>
/// MySQL/MariaDB with LATERAL support.
/// </summary>
public const string AllMySqlWithApply = AllMySql80;
#endregion
#region PostgreSQL
public const string PostgreSQL10 = "PostgreSQL.10";
public const string PostgreSQL11 = "PostgreSQL.11";
public const string PostgreSQL12 = "PostgreSQL.12";
public const string PostgreSQL13 = "PostgreSQL.13";
public const string PostgreSQL14 = "PostgreSQL.14";
public const string PostgreSQL16 = "PostgreSQL.16";
public const string PostgreSQL17 = "PostgreSQL.17";
public const string AllPostgreSQL9 = $"{ProviderName.PostgreSQL92},{ProviderName.PostgreSQL93},{ProviderName.PostgreSQL95}";
public const string AllPostgreSQL93Plus = $"{ProviderName.PostgreSQL93},{AllPostgreSQL95Plus}";
public const string AllPostgreSQL95Plus = $"{ProviderName.PostgreSQL95},{AllPostgreSQL10Plus}";
public const string AllPostgreSQL10Plus = $"{PostgreSQL10},{PostgreSQL11},{PostgreSQL12},{AllPostgreSQL13Plus}";
public const string AllPostgreSQL13Plus = $"{PostgreSQL13},{PostgreSQL14},{AllPostgreSQL15Plus}";
public const string AllPostgreSQL15Plus = $"{ProviderName.PostgreSQL15},{PostgreSQL16},{AllPostgreSQL17Plus}";
public const string AllPostgreSQL17Plus = $"{PostgreSQL17}";
public const string AllPostgreSQL = $"{AllPostgreSQL9},{AllPostgreSQL10Plus}";
public const string AllPostgreSQL14Minus = $"{AllPostgreSQL9},{PostgreSQL10},{PostgreSQL11},{PostgreSQL12},{PostgreSQL13},{PostgreSQL14}";
public const string AllPostgreSQL15Minus = $"{AllPostgreSQL14Minus},{ProviderName.PostgreSQL15}";
public const string AllPostgreSQL16Minus = $"{AllPostgreSQL15Minus},{PostgreSQL16}";
#endregion
#region Firebird
public const string AllFirebird5Plus = ProviderName.Firebird5;
public const string AllFirebird4Plus = $"{ProviderName.Firebird4},{AllFirebird5Plus}";
public const string AllFirebird3Plus = $"{ProviderName.Firebird3},{AllFirebird4Plus}";
public const string AllFirebirdLess4 = $"{ProviderName.Firebird25},{ProviderName.Firebird3}";
public const string AllFirebirdLess5 = $"{AllFirebirdLess4},{ProviderName.Firebird4}";
public const string AllFirebird = $"{AllFirebirdLess5},{ProviderName.Firebird5}";
#endregion
#region Sybase
public const string AllSybase = $"{ProviderName.Sybase},{ProviderName.SybaseManaged}";
#endregion
#region SQL Server
public const string Northwind = "SqlServer.Northwind";
public const string NorthwindMS = "SqlServer.Northwind.MS";
public const string AllNorthwind = $"{Northwind},{NorthwindMS}";
public const string SqlAzure = "SqlServer.Azure";
public const string SqlAzureMS = "SqlServer.Azure.MS";
public const string AllSqlAzure = $"{SqlAzure},{SqlAzureMS}";
public const string SqlServer2005MS = "SqlServer.2005.MS";
public const string SqlServer2008MS = "SqlServer.2008.MS";
public const string SqlServer2012MS = "SqlServer.2012.MS";
public const string SqlServer2014MS = "SqlServer.2014.MS";
public const string SqlServer2016MS = "SqlServer.2016.MS";
public const string SqlServer2017MS = "SqlServer.2017.MS";
public const string SqlServer2019MS = "SqlServer.2019.MS";
public const string SqlServer2022MS = "SqlServer.2022.MS";
public const string SqlServerSequentialAccess = "SqlServer.SA";
public const string SqlServerSequentialAccessMS = "SqlServer.SA.MS";
public const string AllSqlServerSequentialAccess = $"{SqlServerSequentialAccess},{SqlServerSequentialAccessMS}";
public const string SqlServerContained = "SqlServer.Contained";
public const string SqlServerContainedMS = "SqlServer.Contained.MS";
public const string AllSqlServerContained = $"{SqlServerContained},{SqlServerContainedMS}";
/// <summary>
/// Case-sensitive database.
/// </summary>
public const string AllSqlServerCS = $"{ProviderName.SqlServer2019},{SqlServer2019MS}";
public const string AllSqlServer2005 = $"{ProviderName.SqlServer2005},{SqlServer2005MS}";
public const string AllSqlServer2008 = $"{ProviderName.SqlServer2008},{SqlServer2008MS}";
public const string AllSqlServer2012 = $"{ProviderName.SqlServer2012},{SqlServer2012MS}";
public const string AllSqlServer2014 = $"{ProviderName.SqlServer2014},{SqlServer2014MS}";
public const string AllSqlServer2016 = $"{ProviderName.SqlServer2016},{SqlServer2016MS}";
public const string AllSqlServer2017 = $"{ProviderName.SqlServer2017},{SqlServer2017MS}";
public const string AllSqlServer2019 = $"{ProviderName.SqlServer2019},{SqlServer2019MS},{AllSqlServerSequentialAccess},{AllSqlServerContained}";
public const string AllSqlServer2022 = $"{ProviderName.SqlServer2022},{SqlServer2022MS}";
public const string AllSqlServer2008Minus = $"{AllSqlServer2005},{AllSqlServer2008}";
public const string AllSqlServer2014Minus = $"{AllSqlServer2008Minus},{AllSqlServer2012},{AllSqlServer2014}";
public const string AllSqlServer2016Minus = $"{AllSqlServer2014Minus},{AllSqlServer2016}";
public const string AllSqlServer2019Minus = $"{AllSqlServer2016Minus},{AllSqlServer2017},{AllSqlServer2019}";
public const string AllSqlServer2022Minus = $"{AllSqlServer2019Minus},{AllSqlServer2022}";
public const string AllSqlServer2022Plus = $"{AllSqlServer2022},{AllSqlAzure}";
public const string AllSqlServer2019Plus = $"{AllSqlServer2019},{AllSqlServer2022Plus}";
public const string AllSqlServer2017Plus = $"{AllSqlServer2017},{AllSqlServer2019Plus}";
public const string AllSqlServer2016Plus = $"{AllSqlServer2016},{AllSqlServer2017Plus}";
public const string AllSqlServer2012Plus = $"{AllSqlServer2012},{AllSqlServer2014},{AllSqlServer2016Plus}";
public const string AllSqlServer2008Plus = $"{AllSqlServer2008},{AllSqlServer2012Plus}";
public const string AllSqlServer2012PlusNoAzure = $"{AllSqlServer2012},{AllSqlServer2014},{AllSqlServer2016},{AllSqlServer2017},{AllSqlServer2019},{AllSqlServer2022}";
public const string AllSqlServerNoAzure = $"{AllSqlServer2005},{AllSqlServer2008},{AllSqlServer2012PlusNoAzure}";
public const string AllSqlServer = $"{AllSqlServerNoAzure},{AllSqlAzure}";
public const string AllSqlServerMS = $"{SqlServer2005MS},{SqlServer2008MS},{SqlServer2012MS},{SqlServer2014MS},{SqlServer2016MS},{SqlServer2017MS},{SqlServer2019MS},{SqlServer2022MS},{SqlServerSequentialAccessMS},{SqlServerContainedMS},{SqlAzureMS}";
public const string AllSqlServer2016PlusMS = $"{SqlServer2016MS},{SqlServer2017MS},{SqlServer2019MS},{SqlServer2022MS},{SqlServerSequentialAccessMS},{SqlServerContainedMS},{SqlAzureMS}";
#endregion
#region Access
public const string AllAccess = $"{AllAccessOleDb},{AllAccessOdbc}";
public const string AllAccessOleDb = $"{ProviderName.AccessJetOleDb},{ProviderName.AccessAceOleDb}";
public const string AllAccessOdbc = $"{ProviderName.AccessJetOdbc},{ProviderName.AccessAceOdbc}";
#endregion
#region Oracle
public const string Oracle11DevartDirect = "Oracle.11.Devart.Direct";
public const string Oracle11DevartOCI = "Oracle.11.Devart.OCI";
public const string Oracle12DevartDirect = "Oracle.12.Devart.Direct";
public const string Oracle12DevartOCI = "Oracle.12.Devart.OCI";
public const string Oracle12Managed = "Oracle.12.Managed";
public const string Oracle12Native = "Oracle.12.Native";
public const string Oracle18DevartDirect = "Oracle.18.Devart.Direct";
public const string Oracle18DevartOCI = "Oracle.18.Devart.OCI";
public const string Oracle18Managed = "Oracle.18.Managed";
public const string Oracle18Native = "Oracle.18.Native";
public const string Oracle19DevartDirect = "Oracle.19.Devart.Direct";
public const string Oracle19DevartOCI = "Oracle.19.Devart.OCI";
public const string Oracle19Managed = "Oracle.19.Managed";
public const string Oracle19Native = "Oracle.19.Native";
public const string Oracle21DevartDirect = "Oracle.21.Devart.Direct";
public const string Oracle21DevartOCI = "Oracle.21.Devart.OCI";
public const string Oracle21Managed = "Oracle.21.Managed";
public const string Oracle21Native = "Oracle.21.Native";
public const string Oracle23DevartDirect = "Oracle.23.Devart.Direct";
public const string Oracle23DevartOCI = "Oracle.23.Devart.OCI";
public const string Oracle23Managed = "Oracle.23.Managed";
public const string Oracle23Native = "Oracle.23.Native";
public const string AllOracleDevartOCI = $"{Oracle11DevartOCI},{Oracle12DevartOCI},{Oracle18DevartOCI},{Oracle19DevartOCI},{Oracle21DevartOCI},{Oracle23DevartOCI}";
public const string AllOracleDevartDirect = $"{Oracle11DevartDirect},{Oracle12DevartDirect},{Oracle18DevartDirect},{Oracle19DevartDirect},{Oracle21DevartDirect},{Oracle23DevartDirect}";
public const string AllOracleDevart = $"{AllOracleDevartOCI},{AllOracleDevartDirect}";
public const string AllOracleManaged = $"{ProviderName.Oracle11Managed},{Oracle12Managed},{Oracle18Managed},{Oracle19Managed},{Oracle21Managed},{Oracle23Managed}";
public const string AllOracleNative = $"{ProviderName.Oracle11Native},{Oracle12Native},{Oracle18Native},{Oracle19Native},{Oracle21Native},{Oracle23Native}";
public const string AllOracle11 = $"{ProviderName.Oracle11Native},{ProviderName.Oracle11Managed},{Oracle11DevartOCI},{Oracle11DevartDirect}";
public const string AllOracle12 = $"{Oracle12Native},{Oracle12Managed},{Oracle12DevartOCI},{Oracle12DevartDirect}";
public const string AllOracle18 = $"{Oracle18Native},{Oracle18Managed},{Oracle18DevartOCI},{Oracle18DevartDirect}";
public const string AllOracle19 = $"{Oracle19Native},{Oracle19Managed},{Oracle19DevartOCI},{Oracle19DevartDirect}";
public const string AllOracle21 = $"{Oracle21Native},{Oracle21Managed},{Oracle21DevartOCI},{Oracle21DevartDirect}";
public const string AllOracle23 = $"{Oracle23Native},{Oracle23Managed},{Oracle23DevartOCI},{Oracle23DevartDirect}";
public const string AllOracle12Plus = $"{AllOracle12},{AllOracle18},{AllOracle19},{AllOracle21},{AllOracle23}";
public const string AllOracle21Minus = $"{AllOracle11},{AllOracle12},{AllOracle18},{AllOracle19},{AllOracle21}";
public const string AllOracle = $"{AllOracle11},{AllOracle12Plus}";
#endregion
#region DB2
public const string AllDB2 = $"{ProviderName.DB2},{ProviderName.DB2LUW},{ProviderName.DB2zOS}";
#endregion
/// <summary>
/// Fake provider, which doesn't execute any real queries. Could be used for tests, that shouldn't be affected
/// by real database access.
/// </summary>
public const string NoopProvider = "TestNoopProvider";
public const string AllSapHana = $"{ProviderName.SapHanaNative},{ProviderName.SapHanaOdbc}";
public const string AllInformix = $"{ProviderName.Informix},{ProviderName.InformixDB2}";
public const string AllClickHouse = $"{ProviderName.ClickHouseClient},{ProviderName.ClickHouseOctonica},{ProviderName.ClickHouseMySql}";
#region By Feature
public const string WithApplyJoin = $"{AllFirebird4Plus},{AllMySql80},{AllOracle12Plus},{AllPostgreSQL93Plus},{AllSapHana},{ProviderName.SqlCe},{AllSqlServer}";
#endregion By Feature
}
}