Mercurial > pub > bltoolkit

comparison UnitTests/Linq/UserTests/LetTest1.cs @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
1 //---------------------------------------------------------------------------------------------------
2 // This code was generated by BLToolkit.
3 //---------------------------------------------------------------------------------------------------
4 using System;
5 using System.Linq;
6 using System.Linq.Expressions;
7 using BLToolkit.Data.Linq;
8 using LightStation.API;
9 using LightStation.Storage.Relational;
10 using NUnit.Framework;
11
12 namespace LightStation.API
13 {
14 public interface IStationObjectID
15 {
16 }
17 }
18
19 namespace LightStation.API
20 {
21 [SerializableAttribute()]
22 public class MachineIdentifier : LightStation.API.StationObject, LightStation.Utils.Validation.IValidatable
23 {
24 public LightStation.API.StationObjectID OrganizationId { get; set; }
25
26 public string Value { get; set; }
27
28 public LightStation.API.StationObjectID SymbolId { get; set; }
29
30 public DateTime StartDate { get; set; }
31
32 public DateTime? EndDate { get; set; }
33 }
34
35 [SerializableAttribute()]
36 public struct NullableStationObjectID : IStationObjectID
37 {
38 public NullableStationObjectID(int? value)
39 {
40 throw new NotImplementedException();
41 }
42
43 public int? Value { get; set; }
44 }
45
46 [System.SerializableAttribute()]
47 public abstract class StationObject : Utils.Validation.IValidatable
48 {
49 public StationObjectID Id { get; set; }
50 }
51
52 [System.SerializableAttribute()]
53 public struct StationObjectID : IStationObjectID
54 {
55 public StationObjectID(int value)
56 {
57 }
58
59 public int Value { get; set; }
60 }
61
62 [Serializable]
63 public class Symbol : LightStation.API.StationObject, LightStation.Utils.Validation.IValidatable
64 {
65 public string UniqueId { get; set; }
66
67 public string TypeName { get; set; }
68
69 public bool IsActive { get; set; }
70
71 public DateTime StartDate { get; set; }
72
73 public DateTime? EndDate { get; set; }
74
75 public string Description { get; set; }
76
77 public string Extra { get; set; }
78
79 public LightStation.API.NullableStationObjectID DataProvenanceId { get; set; }
80
81 public LightStation.API.NullableStationObjectID CountryId { get; set; }
82
83 public LightStation.API.NullableStationObjectID CurrencyId { get; set; }
84
85 public LightStation.API.NullableStationObjectID DataProviderAccountId { get; set; }
86
87 public LightStation.API.NullableStationObjectID PrimaryExchangeId { get; set; }
88
89 public LightStation.API.NullableStationObjectID CompositeExchangeId { get; set; }
90
91 public string Name { get; set; }
92
93 public string PrimaryTicker { get; set; }
94
95 public DateTime AsOfDate { get; set; }
96 }
97 }
98
99 namespace LightStation.Storage.Relational
100 {
101 //[System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
102 //class <>c__DisplayClass3
103 //{
104 // public LightStation.Storage.Relational.IGenericQueryDataSource ds;
105 //
106 // public Nullable<DateTime> asOfDate;
107 //}
108
109 public interface IGenericQueryDataSource
110 {
111 System.Linq.IQueryable<LightStation.API.MachineIdentifier> MachineIdentifiers { get; set; }
112 }
113
114 public interface IHasDbId<I>
115 {
116 }
117
118 [BLToolkit.DataAccess.TableNameAttribute(Name = "ls_exchange")]
119 public class ls_exchange : LightStation.Storage.Relational.IHasDbId<int>
120 {
121 public int organization_id { get; set; }
122 }
123
124 [BLToolkit.DataAccess.TableNameAttribute(Name = "ls_symbol")]
125 public class ls_symbol : LightStation.Storage.Relational.IHasDbId<int>
126 {
127 [BLToolkit.DataAccess.PrimaryKeyAttribute((Int32)1)]
128 [BLToolkit.DataAccess.IdentityAttribute()]
129 public int id { get; set; }
130
131 public string unique_id { get; set; }
132
133 public bool is_active { get; set; }
134
135 [BLToolkit.Mapping.NullableAttribute()]
136 public string type_name { get; set; }
137
138 public DateTime start_date { get; set; }
139
140 [BLToolkit.Mapping.NullableAttribute()]
141 public Nullable<DateTime> end_date { get; set; }
142
143 [BLToolkit.Mapping.NullableAttribute()]
144 public Nullable<int> data_provenance_id { get; set; }
145
146 [BLToolkit.Mapping.NullableAttribute()]
147 public Nullable<int> country_id { get; set; }
148
149 [BLToolkit.Mapping.NullableAttribute()]
150 public Nullable<int> currency_id { get; set; }
151
152 [BLToolkit.Mapping.NullableAttribute()]
153 public Nullable<int> data_provider_account_id { get; set; }
154
155 [BLToolkit.Mapping.NullableAttribute()]
156 public Nullable<int> primary_exchange_id { get; set; }
157
158 [BLToolkit.Mapping.NullableAttribute()]
159 public Nullable<int> composite_exchange_id { get; set; }
160
161 [BLToolkit.Mapping.NullableAttribute()]
162 public string description { get; set; }
163
164 [BLToolkit.Mapping.NullableAttribute()]
165 public string extra { get; set; }
166
167 [BLToolkit.Mapping.AssociationAttribute(ThisKey = "primary_exchange_id", OtherKey = "id", CanBeNull = true)]
168 public LightStation.Storage.Relational.ls_exchange symbolexchangeprimary { get; set; }
169 }
170 }
171
172 namespace LightStation.Storage.Relational.Tests.IRelationalStorageTests
173 {
174 //[System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
175 //class <>c__DisplayClassa5
176 //{
177 // public LightStation.API.Symbol symbol;
178 //}
179 }
180
181 namespace LightStation.Utils.Validation
182 {
183 public interface IValidatable
184 {
185 }
186 }
187
188 namespace Data.Linq
189 {
190 [TestFixture]
191 public class UserTest : TestBase
192 {
193 [Test]
194 public void Test()
195 {
196 // Table(ls_symbol).Select(symbol => new <>f__AnonymousType1`2(symbol = symbol, ids = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).ds.MachineIdentifiers.Where(identifier => (((Convert(identifier.StartDate) <= value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).asOfDate) AndAlso ((identifier.EndDate == Convert(null)) OrElse (identifier.EndDate >= value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).asOfDate))) AndAlso (identifier.SymbolId.Value == symbol.id))))).Select(<>h__TransparentIdentifier0 => new <>f__AnonymousType2`2(<>h__TransparentIdentifier0 = <>h__TransparentIdentifier0, name = <>h__TransparentIdentifier0.ids.Where(x => (Convert(x.OrganizationId) == Convert(Organization.SelfId))).Select(x => x.Value).FirstOrDefault())).Select(<>h__TransparentIdentifier1 => new <>f__AnonymousType3`2(<>h__TransparentIdentifier1 = <>h__TransparentIdentifier1, primaryTicker = <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.ids.Where(x => (Convert(x.OrganizationId) == <>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.symbolexchangeprimary.organization_id)).Select(x => x.Value).FirstOrDefault())).Select(<>h__TransparentIdentifier2 => new Symbol() {Id = new StationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.id}, UniqueId = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.unique_id, TypeName = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.type_name, IsActive = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.is_active, StartDate = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.start_date, EndDate = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.end_date, Description = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.description, Extra = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.extra, DataProvenanceId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.data_provenance_id}, CountryId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.country_id}, CurrencyId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.currency_id}, DataProviderAccountId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.data_provider_account_id}, PrimaryExchangeId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.primary_exchange_id}, CompositeExchangeId = new NullableStationObjectID() {Value = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.<>h__TransparentIdentifier0.symbol.composite_exchange_id}, Name = <>h__TransparentIdentifier2.<>h__TransparentIdentifier1.name, PrimaryTicker = <>h__TransparentIdentifier2.primaryTicker, AsOfDate = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).asOfDate.Value}).First(x => (Convert(x.Id) == Convert(value(LightStation.Storage.Relational.Tests.IRelationalStorageTests.SymbolTests+<>c__DisplayClassa5).symbol.Id)))
197 ForEachProvider(db =>
198 db.GetTable<ls_symbol>()
199 .Select(
200 // Unknown expression.
201 symbol => new { symbol = symbol, ids = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).ds.MachineIdentifiers.Where(identifier => (((Convert(identifier.StartDate) <= value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).asOfDate) AndAlso ((identifier.EndDate == Convert(null)) OrElse (identifier.EndDate >= value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).asOfDate))) AndAlso (identifier.SymbolId.Value == symbol.id)))))
202 .Select(
203 // Unknown expression.
204 tp0 => new { tp0 = tp0, name = tp0.ids.Where(x => (Convert(x.OrganizationId) == Convert(Organization.SelfId))).Select(x => x.Value).FirstOrDefault()) }
205 .}Select(
206 // Unknown expression.
207 tp1 => new <>f__AnonymousType3`2(tp1 = tp1, primaryTicker = tp1.tp0.ids.Where(x => (Convert(x.OrganizationId) == tp1.tp0.symbol.symbolexchangeprimary.organization_id)).Select(x => x.Value).FirstOrDefault()))
208 .Select(
209 // Unknown expression.
210 tp2 => new Symbol() {Id = new StationObjectID() {Value = tp2.tp1.tp0.symbol.id}, UniqueId = tp2.tp1.tp0.symbol.unique_id, TypeName = tp2.tp1.tp0.symbol.type_name, IsActive = tp2.tp1.tp0.symbol.is_active, StartDate = tp2.tp1.tp0.symbol.start_date, EndDate = tp2.tp1.tp0.symbol.end_date, Description = tp2.tp1.tp0.symbol.description, Extra = tp2.tp1.tp0.symbol.extra, DataProvenanceId = new NullableStationObjectID() {Value = tp2.tp1.tp0.symbol.data_provenance_id}, CountryId = new NullableStationObjectID() {Value = tp2.tp1.tp0.symbol.country_id}, CurrencyId = new NullableStationObjectID() {Value = tp2.tp1.tp0.symbol.currency_id}, DataProviderAccountId = new NullableStationObjectID() {Value = tp2.tp1.tp0.symbol.data_provider_account_id}, PrimaryExchangeId = new NullableStationObjectID() {Value = tp2.tp1.tp0.symbol.primary_exchange_id}, CompositeExchangeId = new NullableStationObjectID() {Value = tp2.tp1.tp0.symbol.composite_exchange_id}, Name = tp2.tp1.name, PrimaryTicker = tp2.primaryTicker, AsOfDate = value(LightStation.Storage.Relational.RelationalDbToBusinessObjectConverterExtensions+<>c__DisplayClass3).asOfDate.Value})
211 .First<LightStation.API.Symbol>(
212 // Unknown expression.
213 x => (Convert(x.Id) == Convert(value(LightStation.Storage.Relational.Tests.IRelationalStorageTests.SymbolTests+<>c__DisplayClassa5).symbol.Id))));
214 }
215 }
216 }
217