- Timestamp:
- 06/12/15 17:04:39 (9 years ago)
- Location:
- branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.dbml
r9665 r12441 1 <?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.Hive " Class="HiveDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">2 <Connection Mode="AppSettings" ConnectionString="Data Source= localhost;Initial Catalog=HeuristicLab.Hive-3.3;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.Hive.DataAccess.Settings" SettingsPropertyName="HeuristicLab_Hive_LinqConnectionString" Provider="System.Data.SqlClient" />1 <?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.Hive-3.3" Class="HiveDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007"> 2 <Connection Mode="AppSettings" ConnectionString="Data Source=.\SQLEXPRESS;Initial Catalog=HeuristicLab.Hive-3.3;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.Hive.DataAccess.Settings" SettingsPropertyName="HeuristicLab_Hive_LinqConnectionString" Provider="System.Data.SqlClient" /> 3 3 <Table Name="dbo.AssignedResources" Member="AssignedResources"> 4 4 <Type Name="AssignedResource"> … … 210 210 </Type> 211 211 </Table> 212 <Table Name="[statistics].DimClient" Member="DimClients"> 213 <Type Name="DimClient"> 214 <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" /> 215 <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" /> 216 <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" /> 217 <Column Name="ExpirationTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" /> 218 <Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" /> 219 <Column Name="ResourceGroup2Id" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" /> 220 <Association Name="DimClient_FactTask" Member="FactTasks" ThisKey="Id" OtherKey="LastClientId" Type="FactTask" /> 221 <Association Name="DimClient_FactClientInfo" Member="FactClientInfos" ThisKey="Id" OtherKey="ClientId" Type="FactClientInfo" /> 222 </Type> 223 </Table> 224 <Table Name="[statistics].FactTask" Member="FactTasks"> 225 <Type Name="FactTask"> 226 <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 227 <Column Name="TotalRuntime" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 228 <Column Name="TotalWaitingTime" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 229 <Column Name="TotalTransferTime" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 230 <Column Name="NumCalculationRuns" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 231 <Column Name="NumRetries" Storage="_NumFails" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 232 <Column Name="CoresRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 233 <Column Name="MemoryRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 234 <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 235 <Column Name="LastClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" /> 236 <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" /> 237 <Column Name="StartTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" /> 238 <Column Name="EndTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="true" /> 239 <Column Name="TaskState" Type="global::HeuristicLab.Services.Hive.DataAccess.TaskState" DbType="varchar(30)" CanBeNull="false" /> 240 <Column Name="Exception" Type="System.String" DbType="varchar(MAX)" CanBeNull="true" /> 241 <Association Name="DimClient_FactTask" Member="DimClient" ThisKey="LastClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" /> 242 <Association Name="DimJob_FactTask" Member="DimJob" ThisKey="JobId" OtherKey="JobId" Type="DimJob" IsForeignKey="true" /> 243 <Association Name="DimTime_FactTask" Member="DimTimeEnd" Storage="_DimTime" ThisKey="EndTime" OtherKey="Time" Type="DimTime" IsForeignKey="true" /> 244 <Association Name="DimTime_FactTask1" Member="DimTimeStart" Storage="_DimTime1" ThisKey="StartTime" OtherKey="Time" Type="DimTime" IsForeignKey="true" /> 245 </Type> 246 </Table> 247 <Table Name="[statistics].DimJob" Member="DimJobs"> 248 <Type Name="DimJob"> 249 <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 250 <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" /> 251 <Column Name="JobName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" /> 252 <Column Name="UserName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" /> 253 <Association Name="DimJob_FactTask" Member="FactTasks" ThisKey="JobId" OtherKey="JobId" Type="FactTask" /> 254 </Type> 255 </Table> 256 <Table Name="[statistics].DimTime" Member="DimTimes"> 257 <Type Name="DimTime"> 258 <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 259 <Column Name="Hour" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" /> 260 <Column Name="Day" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" /> 261 <Column Name="Month" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" /> 262 <Column Name="Year" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" /> 263 <Association Name="DimTime_FactTask" Member="FactTasks" ThisKey="Time" OtherKey="EndTime" Type="FactTask" /> 264 <Association Name="DimTime_FactTask1" Member="FactTasks1" ThisKey="Time" OtherKey="StartTime" Type="FactTask" /> 265 <Association Name="DimTime_FactClientInfo" Member="FactClientInfos" ThisKey="Time" OtherKey="Time" Type="FactClientInfo" /> 266 </Type> 267 </Table> 268 <Table Name="[statistics].DimUser" Member="DimUsers"> 269 <Type Name="DimUser"> 270 <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 271 <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" /> 272 <Association Name="DimUser_FactClientInfo" Member="FactClientInfos" ThisKey="UserId" OtherKey="UserId" Type="FactClientInfo" /> 273 </Type> 274 </Table> 275 <Table Name="[statistics].FactClientInfo" Member="FactClientInfos"> 276 <Type Name="FactClientInfo"> 277 <Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 278 <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 279 <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NULL" IsPrimaryKey="true" CanBeNull="false" /> 280 <Column Name="NumUsedCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 281 <Column Name="NumTotalCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 282 <Column Name="UsedMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 283 <Column Name="TotalMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" /> 284 <Column Name="CpuUtilization" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 285 <Column Name="TotalTimeIdle" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 286 <Column Name="TotalTimeCalculating" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 287 <Column Name="TotalTimeTransferring" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 288 <Column Name="TotalTimeOffline" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 289 <Column Name="TotalTimeUnavailable" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" /> 290 <Column Name="SlaveState" Type="global::HeuristicLab.Services.Hive.DataAccess.SlaveState" DbType="VarChar(15)" CanBeNull="false" /> 291 <Association Name="DimClient_FactClientInfo" Member="DimClient" ThisKey="ClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" /> 292 <Association Name="DimTime_FactClientInfo" Member="DimTime" ThisKey="Time" OtherKey="Time" Type="DimTime" IsForeignKey="true" /> 293 <Association Name="DimUser_FactClientInfo" Member="DimUser" ThisKey="UserId" OtherKey="UserId" Type="DimUser" IsForeignKey="true" /> 294 </Type> 295 </Table> 212 296 </Database> -
branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.dbml.layout
r9665 r12441 1 1 <?xml version="1.0" encoding="utf-8"?> 2 <ordesignerObjectsDiagram dslVersion="1.0.0.0" absoluteBounds="0, 0, 24.25, 8.5" name="HiveDataContext">2 <ordesignerObjectsDiagram dslVersion="1.0.0.0" absoluteBounds="0, 0, 24.25, 17.5" name="HiveDataContext"> 3 3 <DataContextMoniker Name="/HiveDataContext" /> 4 4 <nestedChildShapes> 5 <classShape Id="a929c9dc-69f4-4488-ba1c-a2342bf81d89" absoluteBounds="8.875, 4.5, 2, 1. 0961531575520827">5 <classShape Id="a929c9dc-69f4-4488-ba1c-a2342bf81d89" absoluteBounds="8.875, 4.5, 2, 1.1939925130208327"> 6 6 <DataClassMoniker Name="/HiveDataContext/AssignedResource" /> 7 7 <nestedChildShapes> 8 <elementListCompartment Id="8b005775-f0ee-41b0-ae10-6d1151003708" absoluteBounds="8.89, 4.9600000000000009, 1.9700000000000002, 0. 53615315755208326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />9 </nestedChildShapes> 10 </classShape> 11 <classShape Id="7d998e56-4fba-41ca-a1a8-1dcdb9068edf" absoluteBounds="8.875, 5.875, 2, 1. 7535424804687496">8 <elementListCompartment Id="8b005775-f0ee-41b0-ae10-6d1151003708" absoluteBounds="8.89, 4.9600000000000009, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 9 </nestedChildShapes> 10 </classShape> 11 <classShape Id="7d998e56-4fba-41ca-a1a8-1dcdb9068edf" absoluteBounds="8.875, 5.875, 2, 1.9631982421874996"> 12 12 <DataClassMoniker Name="/HiveDataContext/Plugin" /> 13 13 <nestedChildShapes> 14 <elementListCompartment Id="ec4ba325-6dff-4418-baad-59af81ae2024" absoluteBounds="8.89, 6.3350000000000009, 1.9700000000000002, 1. 19354248046875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />15 </nestedChildShapes> 16 </classShape> 17 <classShape Id="97b00810-fa30-457e-b484-b4e80b22f91b" absoluteBounds="6.5, 5.875, 2, 1. 2605004882812496">14 <elementListCompartment Id="ec4ba325-6dff-4418-baad-59af81ae2024" absoluteBounds="8.89, 6.3350000000000009, 1.9700000000000002, 1.4031982421875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 15 </nestedChildShapes> 16 </classShape> 17 <classShape Id="97b00810-fa30-457e-b484-b4e80b22f91b" absoluteBounds="6.5, 5.875, 2, 1.3862939453124996"> 18 18 <DataClassMoniker Name="/HiveDataContext/RequiredPlugin" /> 19 19 <nestedChildShapes> 20 <elementListCompartment Id="df6451e5-069e-4ca0-a909-61b8213b5047" absoluteBounds="6.5150000000000006, 6.3350000000000009, 1.9700000000000002, 0. 70050048828125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />21 </nestedChildShapes> 22 </classShape> 23 <classShape Id="706a4581-6daf-4e71-ae2a-87d50b27a051" absoluteBounds="11.25, 1, 2, 1. 75354248046875">20 <elementListCompartment Id="df6451e5-069e-4ca0-a909-61b8213b5047" absoluteBounds="6.5150000000000006, 6.3350000000000009, 1.9700000000000002, 0.8262939453125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 21 </nestedChildShapes> 22 </classShape> 23 <classShape Id="706a4581-6daf-4e71-ae2a-87d50b27a051" absoluteBounds="11.25, 1, 2, 1.9631982421875"> 24 24 <DataClassMoniker Name="/HiveDataContext/Resource" /> 25 25 <nestedChildShapes> 26 <elementListCompartment Id="8c24f5bf-2164-4d0f-832e-1730eb0066df" absoluteBounds="11.265, 1.46, 1.9700000000000002, 1. 19354248046875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />27 </nestedChildShapes> 28 </classShape> 29 <classShape Id="695bfc39-59f3-4e60-8644-f847964bf62c" absoluteBounds="6.5, 1, 2, 2.9039737955729166">26 <elementListCompartment Id="8c24f5bf-2164-4d0f-832e-1730eb0066df" absoluteBounds="11.265, 1.46, 1.9700000000000002, 1.4031982421875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 27 </nestedChildShapes> 28 </classShape> 29 <classShape Id="695bfc39-59f3-4e60-8644-f847964bf62c" absoluteBounds="6.5, 1, 2, 3.3093082682291666"> 30 30 <DataClassMoniker Name="/HiveDataContext/Task" /> 31 31 <nestedChildShapes> 32 <elementListCompartment Id="a6a30e11-03d1-4869-82e6-b733f4ef9974" absoluteBounds="6.5150000000000006, 1.46, 1.9700000000000002, 2. 3439737955729165" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />33 </nestedChildShapes> 34 </classShape> 35 <classShape Id="8d5712f7-7a1a-4a89-bd4d-fd60200d3306" absoluteBounds="13.5, 2.5, 2, 2. 0822371419270826">32 <elementListCompartment Id="a6a30e11-03d1-4869-82e6-b733f4ef9974" absoluteBounds="6.5150000000000006, 1.46, 1.9700000000000002, 2.7493082682291665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 33 </nestedChildShapes> 34 </classShape> 35 <classShape Id="8d5712f7-7a1a-4a89-bd4d-fd60200d3306" absoluteBounds="13.5, 2.5, 2, 2.3478011067708326"> 36 36 <DataClassMoniker Name="/HiveDataContext/Downtime" /> 37 37 <nestedChildShapes> 38 <elementListCompartment Id="7d8f121b-35bb-4753-a25f-3fac1562e68e" absoluteBounds="13.515, 2.9600000000000009, 1.9700000000000002, 1. 5222371419270833" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />39 </nestedChildShapes> 40 </classShape> 41 <classShape Id="e6f840cc-2968-4be1-b234-eef624ccacbb" absoluteBounds="4.125, 2.625, 2, 1. 7535424804687496">38 <elementListCompartment Id="7d8f121b-35bb-4753-a25f-3fac1562e68e" absoluteBounds="13.515, 2.9600000000000009, 1.9700000000000002, 1.7878011067708333" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 39 </nestedChildShapes> 40 </classShape> 41 <classShape Id="e6f840cc-2968-4be1-b234-eef624ccacbb" absoluteBounds="4.125, 2.625, 2, 1.9631982421874996"> 42 42 <DataClassMoniker Name="/HiveDataContext/Job" /> 43 43 <nestedChildShapes> 44 <elementListCompartment Id="0c65d4e1-256a-4a91-9a57-392f25e4de7f" absoluteBounds="4.1400000000000006, 3.0850000000000009, 1.9700000000000002, 1. 19354248046875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />45 </nestedChildShapes> 46 </classShape> 47 <classShape Id="26f4edfa-91dd-4941-a058-359f89e567a8" absoluteBounds="8.875, 0.75, 2, 2.9039737955729166">44 <elementListCompartment Id="0c65d4e1-256a-4a91-9a57-392f25e4de7f" absoluteBounds="4.1400000000000006, 3.0850000000000009, 1.9700000000000002, 1.4031982421875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 45 </nestedChildShapes> 46 </classShape> 47 <classShape Id="26f4edfa-91dd-4941-a058-359f89e567a8" absoluteBounds="8.875, 0.75, 2, 3.3093082682291666"> 48 48 <DataClassMoniker Name="/HiveDataContext/Slave" /> 49 49 <nestedChildShapes> 50 <elementListCompartment Id="1e61f36b-08dc-4df7-8594-c9dcd95c0791" absoluteBounds="8.89, 1.21, 1.9700000000000002, 2. 3439737955729165" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />51 </nestedChildShapes> 52 </classShape> 53 <classShape Id="bbd91675-92f2-4a69-8429-0950008fc8a4" absoluteBounds="13.5, 1, 2, 0. 76745849609375">50 <elementListCompartment Id="1e61f36b-08dc-4df7-8594-c9dcd95c0791" absoluteBounds="8.89, 1.21, 1.9700000000000002, 2.7493082682291665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 51 </nestedChildShapes> 52 </classShape> 53 <classShape Id="bbd91675-92f2-4a69-8429-0950008fc8a4" absoluteBounds="13.5, 1, 2, 0.8093896484375"> 54 54 <DataClassMoniker Name="/HiveDataContext/SlaveGroup" /> 55 55 <nestedChildShapes> 56 <elementListCompartment Id="5a790e8f-6e2e-4bf5-bd2b-f8a82224d9d7" absoluteBounds="13.5, 1, 0.125, 0.2 0745849609375" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />56 <elementListCompartment Id="5a790e8f-6e2e-4bf5-bd2b-f8a82224d9d7" absoluteBounds="13.5, 1, 0.125, 0.2493896484375" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 57 57 </nestedChildShapes> 58 58 </classShape> … … 69 69 </nodes> 70 70 </inheritanceConnector> 71 <associationConnector edgePoints="[(11.8134963640734 : 2. 75354248046875); (11.8134963640734 : 3.56770833333333); (11.1119791666667 : 3.56770833333333); (11.1119791666667 : 5.09699625651042); (10.875 : 5.09699625651042)]" manuallyRouted="true" fixedFrom="Algorithm" fixedTo="Algorithm">71 <associationConnector edgePoints="[(11.8134963640734 : 2.9631982421875); (11.8134963640734 : 3.56770833333333); (11.1119791666667 : 3.56770833333333); (11.1119791666667 : 5.09699625651042); (10.875 : 5.09699625651042)]" manuallyRouted="true" fixedFrom="NotFixed" fixedTo="NotFixed"> 72 72 <AssociationMoniker Name="/HiveDataContext/Resource/Resource_AssignedResource" /> 73 73 <nodes> … … 76 76 </nodes> 77 77 </associationConnector> 78 <classShape Id="6bc13f26-f9a8-4597-b054-35be34190d12" absoluteBounds="4.125, 1, 2, 1. 26050048828125">78 <classShape Id="6bc13f26-f9a8-4597-b054-35be34190d12" absoluteBounds="4.125, 1, 2, 1.3862939453125"> 79 79 <DataClassMoniker Name="/HiveDataContext/TaskData" /> 80 80 <nestedChildShapes> 81 <elementListCompartment Id="a068522c-7974-4679-b356-e33c941c465b" absoluteBounds="4.14, 1.46, 1.9700000000000002, 0. 70050048828125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />82 </nestedChildShapes> 83 </classShape> 84 <classShape Id="ad25bd0f-80e8-4a06-abd8-190eb678eec7" absoluteBounds="11.25, 5.875, 2, 1. 4248478190104166">81 <elementListCompartment Id="a068522c-7974-4679-b356-e33c941c465b" absoluteBounds="4.14, 1.46, 1.9700000000000002, 0.8262939453125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 82 </nestedChildShapes> 83 </classShape> 84 <classShape Id="ad25bd0f-80e8-4a06-abd8-190eb678eec7" absoluteBounds="11.25, 5.875, 2, 1.5785953776041666"> 85 85 <DataClassMoniker Name="/HiveDataContext/PluginData" /> 86 86 <nestedChildShapes> 87 <elementListCompartment Id="acddb513-7de6-4bb4-8335-d6982fb2ef35" absoluteBounds="11.265, 6.3350000000000009, 1.9700000000000002, 0.86484781901041663" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />87 <elementListCompartment Id="acddb513-7de6-4bb4-8335-d6982fb2ef35" absoluteBounds="11.265, 6.3350000000000009, 1.9700000000000002, 1.0185953776041665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 88 88 </nestedChildShapes> 89 89 </classShape> … … 109 109 </nodes> 110 110 </associationConnector> 111 <classShape Id="00352397-340e-449a-8e23-6ddd216e8617" absoluteBounds="1.75, 1, 2, 1.9178898111979166">111 <classShape Id="00352397-340e-449a-8e23-6ddd216e8617" absoluteBounds="1.75, 1, 2, 2.1554996744791666"> 112 112 <DataClassMoniker Name="/HiveDataContext/StateLog" /> 113 113 <nestedChildShapes> 114 <elementListCompartment Id="9a003897-deef-4bb5-b180-4c4bcdb7fadc" absoluteBounds="1.765, 1.46, 1.9700000000000002, 1. 3578898111979165" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />115 </nestedChildShapes> 116 </classShape> 117 <classShape Id="4d800dc9-1b18-469f-b02c-d4554757c5e1" absoluteBounds="1.75, 3.625, 2, 1. 4248478190104166">114 <elementListCompartment Id="9a003897-deef-4bb5-b180-4c4bcdb7fadc" absoluteBounds="1.765, 1.46, 1.9700000000000002, 1.5954996744791665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 115 </nestedChildShapes> 116 </classShape> 117 <classShape Id="4d800dc9-1b18-469f-b02c-d4554757c5e1" absoluteBounds="1.75, 3.625, 2, 1.5785953776041666"> 118 118 <DataClassMoniker Name="/HiveDataContext/JobPermission" /> 119 119 <nestedChildShapes> 120 <elementListCompartment Id="dedd97d3-a9a2-45a2-9b95-d7366fb65a7f" absoluteBounds="1.765, 4.085, 1.9700000000000002, 0.86484781901041663" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />121 </nestedChildShapes> 122 </classShape> 123 <associationConnector edgePoints="[(11.25 : 1. 98159912109375); (10.9375 : 1.98159912109375); (10.9375 : 0.6875); (2.75 : 0.6875); (2.75 : 1)]" fixedFrom="NotFixed" fixedTo="NotFixed">120 <elementListCompartment Id="dedd97d3-a9a2-45a2-9b95-d7366fb65a7f" absoluteBounds="1.765, 4.085, 1.9700000000000002, 1.0185953776041665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 121 </nestedChildShapes> 122 </classShape> 123 <associationConnector edgePoints="[(11.25 : 1.44547136382195); (11.0260416666667 : 1.44547136382195); (11.0260416666667 : 0.5625); (2.75 : 0.5625); (2.75 : 1)]" manuallyRouted="true" fixedFrom="NotFixed" fixedTo="NotFixed"> 124 124 <AssociationMoniker Name="/HiveDataContext/Resource/Resource_StateLog" /> 125 125 <nodes> … … 128 128 </nodes> 129 129 </associationConnector> 130 <classShape Id="b4e7aaa8-a382-4560-a1fd-498de77e9340" absoluteBounds="1.75, 5.5, 2, 1. 0961531575520827">130 <classShape Id="b4e7aaa8-a382-4560-a1fd-498de77e9340" absoluteBounds="1.75, 5.5, 2, 1.1939925130208327"> 131 131 <DataClassMoniker Name="/HiveDataContext/Lifecycle" /> 132 132 <nestedChildShapes> 133 <elementListCompartment Id="03597a2c-5c5d-4c2c-b741-c49ab5aa34d5" absoluteBounds="1.7650000000000001, 5.96, 1.9700000000000002, 0. 53615315755208326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />134 </nestedChildShapes> 135 </classShape> 136 <classShape Id="cdddf4da-eaef-46a1-9cfd-987bb6b3d03e" absoluteBounds="17, 3.125, 2.5, 1. 5891951497395827">133 <elementListCompartment Id="03597a2c-5c5d-4c2c-b741-c49ab5aa34d5" absoluteBounds="1.7650000000000001, 5.96, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 134 </nestedChildShapes> 135 </classShape> 136 <classShape Id="cdddf4da-eaef-46a1-9cfd-987bb6b3d03e" absoluteBounds="17, 3.125, 2.5, 1.7708968098958327"> 137 137 <DataClassMoniker Name="/HiveDataContext/DeletedJobStatistics" /> 138 138 <nestedChildShapes> 139 <elementListCompartment Id="b8738381-f696-4dba-a517-47e9cd96a9a6" absoluteBounds="17.015, 3.585, 2.4699999999999998, 1. 0291951497395833" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />140 </nestedChildShapes> 141 </classShape> 142 <classShape Id="25442617-ff41-49a0-b5d5-4cbe0b2f0f45" absoluteBounds="22, 4.5, 2, 1. 7535424804687496">139 <elementListCompartment Id="b8738381-f696-4dba-a517-47e9cd96a9a6" absoluteBounds="17.015, 3.585, 2.4699999999999998, 1.2108968098958333" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 140 </nestedChildShapes> 141 </classShape> 142 <classShape Id="25442617-ff41-49a0-b5d5-4cbe0b2f0f45" absoluteBounds="22, 4.5, 2, 1.9631982421874996"> 143 143 <DataClassMoniker Name="/HiveDataContext/UserStatistics" /> 144 144 <nestedChildShapes> 145 <elementListCompartment Id="6edf08e7-054a-4253-8d4f-5bf2dfec2d29" absoluteBounds="22.015, 4.96, 1.9700000000000002, 1. 19354248046875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />146 </nestedChildShapes> 147 </classShape> 148 <classShape Id="f78ec989-4862-4bac-87e3-9b0aad4bc037" absoluteBounds="19.875, 4.5, 2, 1.9178898111979166">145 <elementListCompartment Id="6edf08e7-054a-4253-8d4f-5bf2dfec2d29" absoluteBounds="22.015, 4.96, 1.9700000000000002, 1.4031982421875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 146 </nestedChildShapes> 147 </classShape> 148 <classShape Id="f78ec989-4862-4bac-87e3-9b0aad4bc037" absoluteBounds="19.875, 4.5, 2, 2.1554996744791666"> 149 149 <DataClassMoniker Name="/HiveDataContext/SlaveStatistics" /> 150 150 <nestedChildShapes> 151 <elementListCompartment Id="98cb46fe-820e-4041-aee8-04e8bed3df23" absoluteBounds="19.89, 4.96, 1.9700000000000002, 1. 3578898111979165" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />152 </nestedChildShapes> 153 </classShape> 154 <classShape Id="4d9f0606-b7ee-4dae-a8ac-aff88d25a941" absoluteBounds="21, 3, 2, 1. 0961531575520827">151 <elementListCompartment Id="98cb46fe-820e-4041-aee8-04e8bed3df23" absoluteBounds="19.89, 4.96, 1.9700000000000002, 1.5954996744791665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 152 </nestedChildShapes> 153 </classShape> 154 <classShape Id="4d9f0606-b7ee-4dae-a8ac-aff88d25a941" absoluteBounds="21, 3, 2, 1.1939925130208327"> 155 155 <DataClassMoniker Name="/HiveDataContext/Statistics" /> 156 156 <nestedChildShapes> 157 <elementListCompartment Id="17821282-8edf-40b7-9065-84f53391d5c1" absoluteBounds="21.015, 3.46, 1.9700000000000002, 0. 53615315755208326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />157 <elementListCompartment Id="17821282-8edf-40b7-9065-84f53391d5c1" absoluteBounds="21.015, 3.46, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 158 158 </nestedChildShapes> 159 159 </classShape> … … 179 179 </nodes> 180 180 </associationConnector> 181 <associationConnector edgePoints="[( 7.96163946463664 : 4.30930826822917); (7.96163946463664 : 5.09699625651042); (8.875 : 5.09699625651042)]" fixedFrom="NotFixed" fixedTo="NotFixed">181 <associationConnector edgePoints="[(8.0192961430407 : 3.90397379557292); (8.0192961430407 : 5.04807657877604); (8.875 : 5.04807657877604)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 182 182 <AssociationMoniker Name="/HiveDataContext/Task/Task_AssignedResource" /> 183 183 <nodes> … … 186 186 </nodes> 187 187 </associationConnector> 188 <associationConnector edgePoints="[(7. 16831973231832 : 4.30930826822917); (7.16831973231832 : 5.875)]" fixedFrom="NotFixed" fixedTo="NotFixed">188 <associationConnector edgePoints="[(7.20145120722822 : 3.90397379557292); (7.20145120722822 : 5.875)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 189 189 <AssociationMoniker Name="/HiveDataContext/Task/Task_RequiredPlugin" /> 190 190 <nodes> … … 193 193 </nodes> 194 194 </associationConnector> 195 <associationConnector edgePoints="[(7.20923076923077 : 1); (7.20923076923077 : 0. 875); (7.80461538461539 : 0.875); (7.80461538461539 : 1)]" fixedFrom="NotFixed" fixedTo="NotFixed">195 <associationConnector edgePoints="[(7.20923076923077 : 1); (7.20923076923077 : 0.770833333333333); (7.80461538461539 : 0.770833333333333); (7.80461538461539 : 1)]" manuallyRouted="true" fixedFrom="NotFixed" fixedTo="NotFixed"> 196 196 <AssociationMoniker Name="/HiveDataContext/Task/Task_Task" /> 197 197 <nodes> … … 228 228 </nodes> 229 229 </associationConnector> 230 <classShape Id="a3f352be-9f15-4e73-8d44-3e8ac02fb4cf" absoluteBounds="11.25, 3.875, 2, 1. 2605004882812496">230 <classShape Id="a3f352be-9f15-4e73-8d44-3e8ac02fb4cf" absoluteBounds="11.25, 3.875, 2, 1.3862939453124996"> 231 231 <DataClassMoniker Name="/HiveDataContext/ResourcePermission" /> 232 232 <nestedChildShapes> 233 <elementListCompartment Id="45e2f1a8-8a1e-4647-b649-10ec55976ab4" absoluteBounds="11.265, 4.335, 1.9700000000000002, 0. 70050048828125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />233 <elementListCompartment Id="45e2f1a8-8a1e-4647-b649-10ec55976ab4" absoluteBounds="11.265, 4.335, 1.9700000000000002, 0.8262939453125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 234 234 </nestedChildShapes> 235 235 </classShape> … … 241 241 </nodes> 242 242 </associationConnector> 243 <classShape Id="f9e8867f-fd15-4a72-8ca4-4f02cd3f141f" absoluteBounds="4.125, 5.5, 2, 1. 0961531575520827">243 <classShape Id="f9e8867f-fd15-4a72-8ca4-4f02cd3f141f" absoluteBounds="4.125, 5.5, 2, 1.1939925130208327"> 244 244 <DataClassMoniker Name="/HiveDataContext/UserPriority" /> 245 245 <nestedChildShapes> 246 <elementListCompartment Id="ee41f516-7d9c-4a1d-a1b8-bbe00a6ffea8" absoluteBounds="4.14, 5.96, 1.9700000000000002, 0.53615315755208326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 247 </nestedChildShapes> 248 </classShape> 246 <elementListCompartment Id="ee41f516-7d9c-4a1d-a1b8-bbe00a6ffea8" absoluteBounds="4.14, 5.96, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 247 </nestedChildShapes> 248 </classShape> 249 <classShape Id="b5b919c2-4efc-4f09-8f52-9d541a11e961" absoluteBounds="4.625, 15.25, 2, 1.9631982421875023"> 250 <DataClassMoniker Name="/HiveDataContext/DimClient" /> 251 <nestedChildShapes> 252 <elementListCompartment Id="30f62a7b-0b16-404e-b972-fb12bfe978dd" absoluteBounds="4.6400000000000006, 15.71, 1.9700000000000002, 1.4031982421875" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 253 </nestedChildShapes> 254 </classShape> 255 <classShape Id="04f52807-ce17-4d65-bd23-cc38c6dfbd7a" absoluteBounds="6.875, 11.25, 2, 3.6939111328125005"> 256 <DataClassMoniker Name="/HiveDataContext/FactTask" /> 257 <nestedChildShapes> 258 <elementListCompartment Id="63e3ddcb-a6fe-48e0-a674-e650a55a9f2c" absoluteBounds="6.8900000000000006, 11.71, 1.9700000000000002, 3.1339111328125" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 259 </nestedChildShapes> 260 </classShape> 261 <classShape Id="e0cb8641-a75e-4b9f-beda-3218c56938b1" absoluteBounds="8.125, 9.125, 2, 1.5785953776041666"> 262 <DataClassMoniker Name="/HiveDataContext/DimJob" /> 263 <nestedChildShapes> 264 <elementListCompartment Id="6b9e8260-7e4b-4357-9c26-eebebfd69504" absoluteBounds="8.14, 9.585, 1.9700000000000002, 1.0185953776041665" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 265 </nestedChildShapes> 266 </classShape> 267 <classShape Id="a769f2ac-c8e3-4860-baa5-c46f46c38ed8" absoluteBounds="3.625, 8.5, 2, 1.7708968098958344"> 268 <DataClassMoniker Name="/HiveDataContext/DimTime" /> 269 <nestedChildShapes> 270 <elementListCompartment Id="694c4a5a-20fb-43a9-bc9a-7b59d794a7fb" absoluteBounds="3.6399999999999997, 8.96, 1.9700000000000002, 1.2108968098958333" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 271 </nestedChildShapes> 272 </classShape> 273 <classShape Id="66c34ced-4fdb-4a1d-b8dd-fe094679b7fb" absoluteBounds="0.625, 8.875, 2, 1.1939925130208344"> 274 <DataClassMoniker Name="/HiveDataContext/DimUser" /> 275 <nestedChildShapes> 276 <elementListCompartment Id="6181c560-fc74-4d43-b064-a90032bf17a5" absoluteBounds="0.64000000000000012, 9.335, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 277 </nestedChildShapes> 278 </classShape> 279 <classShape Id="053a5cff-b18a-4ee5-8d43-48ed5c5dcfad" absoluteBounds="2.625, 11, 2, 3.5016097005208326"> 280 <DataClassMoniker Name="/HiveDataContext/FactClientInfo" /> 281 <nestedChildShapes> 282 <elementListCompartment Id="0a1cc913-6636-455c-95b3-302f533527db" absoluteBounds="2.6399999999999997, 11.46, 1.9700000000000002, 2.941609700520833" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" /> 283 </nestedChildShapes> 284 </classShape> 285 <associationConnector edgePoints="[(6.625 : 15.25); (6.875 : 14.9439111328125)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 286 <AssociationMoniker Name="/HiveDataContext/DimClient/DimClient_FactTask" /> 287 <nodes> 288 <classShapeMoniker Id="b5b919c2-4efc-4f09-8f52-9d541a11e961" /> 289 <classShapeMoniker Id="04f52807-ce17-4d65-bd23-cc38c6dfbd7a" /> 290 </nodes> 291 </associationConnector> 292 <associationConnector edgePoints="[(8.5 : 10.7035953776042); (8.5 : 11.25)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 293 <AssociationMoniker Name="/HiveDataContext/DimJob/DimJob_FactTask" /> 294 <nodes> 295 <classShapeMoniker Id="e0cb8641-a75e-4b9f-beda-3218c56938b1" /> 296 <classShapeMoniker Id="04f52807-ce17-4d65-bd23-cc38c6dfbd7a" /> 297 </nodes> 298 </associationConnector> 299 <associationConnector edgePoints="[(5.02343625 : 10.2708968098958); (5.02343625 : 14.7227579166667); (6.875 : 14.7227579166667)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 300 <AssociationMoniker Name="/HiveDataContext/DimTime/DimTime_FactTask" /> 301 <nodes> 302 <classShapeMoniker Id="a769f2ac-c8e3-4860-baa5-c46f46c38ed8" /> 303 <classShapeMoniker Id="04f52807-ce17-4d65-bd23-cc38c6dfbd7a" /> 304 </nodes> 305 </associationConnector> 306 <associationConnector edgePoints="[(5.4218775 : 10.2708968098958); (5.4218775 : 13.3576659570313); (5.90885291666667 : 13.3576659570313 : JumpStart); (6.07551958333333 : 13.3576659570313 : JumpEnd); (6.71675495975 : 13.3576659570313); (6.71675495975 : 13.3568567264325); (6.875 : 13.3568567264325)]" manuallyRouted="true" fixedFrom="NotFixed" fixedTo="NotFixed"> 307 <AssociationMoniker Name="/HiveDataContext/DimTime/DimTime_FactTask1" /> 308 <nodes> 309 <classShapeMoniker Id="a769f2ac-c8e3-4860-baa5-c46f46c38ed8" /> 310 <classShapeMoniker Id="04f52807-ce17-4d65-bd23-cc38c6dfbd7a" /> 311 </nodes> 312 </associationConnector> 313 <associationConnector edgePoints="[(5.99218625 : 15.25); (5.99218625 : 12.1788329785157); (5.50521083333333 : 12.1788329785157 : JumpStart); (5.33854416666667 : 12.1788329785157 : JumpEnd); (5.10676958333333 : 12.1788329785157 : JumpStart); (4.94010291666667 : 12.1788329785157 : JumpEnd); (4.625 : 12.1788329785157)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 314 <AssociationMoniker Name="/HiveDataContext/DimClient/DimClient_FactClientInfo" /> 315 <nodes> 316 <classShapeMoniker Id="b5b919c2-4efc-4f09-8f52-9d541a11e961" /> 317 <classShapeMoniker Id="053a5cff-b18a-4ee5-8d43-48ed5c5dcfad" /> 318 </nodes> 319 </associationConnector> 320 <associationConnector edgePoints="[(4.125 : 10.2708968098958); (4.125 : 11)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 321 <AssociationMoniker Name="/HiveDataContext/DimTime/DimTime_FactClientInfo" /> 322 <nodes> 323 <classShapeMoniker Id="a769f2ac-c8e3-4860-baa5-c46f46c38ed8" /> 324 <classShapeMoniker Id="053a5cff-b18a-4ee5-8d43-48ed5c5dcfad" /> 325 </nodes> 326 </associationConnector> 327 <associationConnector edgePoints="[(1.59375 : 10.0689925130208); (1.59375 : 12.7508048502604); (2.625 : 12.7508048502604)]" fixedFrom="NotFixed" fixedTo="NotFixed"> 328 <AssociationMoniker Name="/HiveDataContext/DimUser/DimUser_FactClientInfo" /> 329 <nodes> 330 <classShapeMoniker Id="66c34ced-4fdb-4a1d-b8dd-fe094679b7fb" /> 331 <classShapeMoniker Id="053a5cff-b18a-4ee5-8d43-48ed5c5dcfad" /> 332 </nodes> 333 </associationConnector> 249 334 </nestedChildShapes> 250 335 </ordesignerObjectsDiagram> -
branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.designer.cs
r11623 r12441 23 23 24 24 25 [global::System.Data.Linq.Mapping.DatabaseAttribute(Name="HeuristicLab.Hive ")]25 [global::System.Data.Linq.Mapping.DatabaseAttribute(Name="HeuristicLab.Hive-3.3")] 26 26 public partial class HiveDataContext : System.Data.Linq.DataContext 27 27 { … … 85 85 partial void UpdateUserPriority(UserPriority instance); 86 86 partial void DeleteUserPriority(UserPriority instance); 87 partial void InsertDimClient(DimClient instance); 88 partial void UpdateDimClient(DimClient instance); 89 partial void DeleteDimClient(DimClient instance); 90 partial void InsertFactTask(FactTask instance); 91 partial void UpdateFactTask(FactTask instance); 92 partial void DeleteFactTask(FactTask instance); 93 partial void InsertDimJob(DimJob instance); 94 partial void UpdateDimJob(DimJob instance); 95 partial void DeleteDimJob(DimJob instance); 96 partial void InsertDimTime(DimTime instance); 97 partial void UpdateDimTime(DimTime instance); 98 partial void DeleteDimTime(DimTime instance); 99 partial void InsertDimUser(DimUser instance); 100 partial void UpdateDimUser(DimUser instance); 101 partial void DeleteDimUser(DimUser instance); 102 partial void InsertFactClientInfo(FactClientInfo instance); 103 partial void UpdateFactClientInfo(FactClientInfo instance); 104 partial void DeleteFactClientInfo(FactClientInfo instance); 87 105 #endregion 88 106 … … 258 276 { 259 277 return this.GetTable<UserPriority>(); 278 } 279 } 280 281 public System.Data.Linq.Table<DimClient> DimClients 282 { 283 get 284 { 285 return this.GetTable<DimClient>(); 286 } 287 } 288 289 public System.Data.Linq.Table<FactTask> FactTasks 290 { 291 get 292 { 293 return this.GetTable<FactTask>(); 294 } 295 } 296 297 public System.Data.Linq.Table<DimJob> DimJobs 298 { 299 get 300 { 301 return this.GetTable<DimJob>(); 302 } 303 } 304 305 public System.Data.Linq.Table<DimTime> DimTimes 306 { 307 get 308 { 309 return this.GetTable<DimTime>(); 310 } 311 } 312 313 public System.Data.Linq.Table<DimUser> DimUsers 314 { 315 get 316 { 317 return this.GetTable<DimUser>(); 318 } 319 } 320 321 public System.Data.Linq.Table<FactClientInfo> FactClientInfos 322 { 323 get 324 { 325 return this.GetTable<FactClientInfo>(); 260 326 } 261 327 } … … 4534 4600 } 4535 4601 } 4602 4603 [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].DimClient")] 4604 public partial class DimClient : INotifyPropertyChanging, INotifyPropertyChanged 4605 { 4606 4607 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty); 4608 4609 private System.Guid _Id; 4610 4611 private string _Name; 4612 4613 private System.Guid _ResourceId; 4614 4615 private System.Nullable<System.DateTime> _ExpirationTime; 4616 4617 private System.Nullable<System.Guid> _ResourceGroupId; 4618 4619 private System.Nullable<System.Guid> _ResourceGroup2Id; 4620 4621 private EntitySet<FactTask> _FactTasks; 4622 4623 private EntitySet<FactClientInfo> _FactClientInfos; 4624 4625 #region Extensibility Method Definitions 4626 partial void OnLoaded(); 4627 partial void OnValidate(System.Data.Linq.ChangeAction action); 4628 partial void OnCreated(); 4629 partial void OnIdChanging(System.Guid value); 4630 partial void OnIdChanged(); 4631 partial void OnNameChanging(string value); 4632 partial void OnNameChanged(); 4633 partial void OnResourceIdChanging(System.Guid value); 4634 partial void OnResourceIdChanged(); 4635 partial void OnExpirationTimeChanging(System.Nullable<System.DateTime> value); 4636 partial void OnExpirationTimeChanged(); 4637 partial void OnResourceGroupIdChanging(System.Nullable<System.Guid> value); 4638 partial void OnResourceGroupIdChanged(); 4639 partial void OnResourceGroup2IdChanging(System.Nullable<System.Guid> value); 4640 partial void OnResourceGroup2IdChanged(); 4641 #endregion 4642 4643 public DimClient() 4644 { 4645 this._FactTasks = new EntitySet<FactTask>(new Action<FactTask>(this.attach_FactTasks), new Action<FactTask>(this.detach_FactTasks)); 4646 this._FactClientInfos = new EntitySet<FactClientInfo>(new Action<FactClientInfo>(this.attach_FactClientInfos), new Action<FactClientInfo>(this.detach_FactClientInfos)); 4647 OnCreated(); 4648 } 4649 4650 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Id", AutoSync=AutoSync.OnInsert, DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true, IsDbGenerated=true)] 4651 public System.Guid Id 4652 { 4653 get 4654 { 4655 return this._Id; 4656 } 4657 set 4658 { 4659 if ((this._Id != value)) 4660 { 4661 this.OnIdChanging(value); 4662 this.SendPropertyChanging(); 4663 this._Id = value; 4664 this.SendPropertyChanged("Id"); 4665 this.OnIdChanged(); 4666 } 4667 } 4668 } 4669 4670 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Name", DbType="VarChar(MAX) NOT NULL", CanBeNull=false)] 4671 public string Name 4672 { 4673 get 4674 { 4675 return this._Name; 4676 } 4677 set 4678 { 4679 if ((this._Name != value)) 4680 { 4681 this.OnNameChanging(value); 4682 this.SendPropertyChanging(); 4683 this._Name = value; 4684 this.SendPropertyChanged("Name"); 4685 this.OnNameChanged(); 4686 } 4687 } 4688 } 4689 4690 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ResourceId", DbType="UniqueIdentifier NOT NULL")] 4691 public System.Guid ResourceId 4692 { 4693 get 4694 { 4695 return this._ResourceId; 4696 } 4697 set 4698 { 4699 if ((this._ResourceId != value)) 4700 { 4701 this.OnResourceIdChanging(value); 4702 this.SendPropertyChanging(); 4703 this._ResourceId = value; 4704 this.SendPropertyChanged("ResourceId"); 4705 this.OnResourceIdChanged(); 4706 } 4707 } 4708 } 4709 4710 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ExpirationTime", DbType="DateTime")] 4711 public System.Nullable<System.DateTime> ExpirationTime 4712 { 4713 get 4714 { 4715 return this._ExpirationTime; 4716 } 4717 set 4718 { 4719 if ((this._ExpirationTime != value)) 4720 { 4721 this.OnExpirationTimeChanging(value); 4722 this.SendPropertyChanging(); 4723 this._ExpirationTime = value; 4724 this.SendPropertyChanged("ExpirationTime"); 4725 this.OnExpirationTimeChanged(); 4726 } 4727 } 4728 } 4729 4730 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ResourceGroupId", DbType="UniqueIdentifier")] 4731 public System.Nullable<System.Guid> ResourceGroupId 4732 { 4733 get 4734 { 4735 return this._ResourceGroupId; 4736 } 4737 set 4738 { 4739 if ((this._ResourceGroupId != value)) 4740 { 4741 this.OnResourceGroupIdChanging(value); 4742 this.SendPropertyChanging(); 4743 this._ResourceGroupId = value; 4744 this.SendPropertyChanged("ResourceGroupId"); 4745 this.OnResourceGroupIdChanged(); 4746 } 4747 } 4748 } 4749 4750 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ResourceGroup2Id", DbType="UniqueIdentifier")] 4751 public System.Nullable<System.Guid> ResourceGroup2Id 4752 { 4753 get 4754 { 4755 return this._ResourceGroup2Id; 4756 } 4757 set 4758 { 4759 if ((this._ResourceGroup2Id != value)) 4760 { 4761 this.OnResourceGroup2IdChanging(value); 4762 this.SendPropertyChanging(); 4763 this._ResourceGroup2Id = value; 4764 this.SendPropertyChanged("ResourceGroup2Id"); 4765 this.OnResourceGroup2IdChanged(); 4766 } 4767 } 4768 } 4769 4770 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimClient_FactTask", Storage="_FactTasks", ThisKey="Id", OtherKey="LastClientId")] 4771 public EntitySet<FactTask> FactTasks 4772 { 4773 get 4774 { 4775 return this._FactTasks; 4776 } 4777 set 4778 { 4779 this._FactTasks.Assign(value); 4780 } 4781 } 4782 4783 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimClient_FactClientInfo", Storage="_FactClientInfos", ThisKey="Id", OtherKey="ClientId")] 4784 public EntitySet<FactClientInfo> FactClientInfos 4785 { 4786 get 4787 { 4788 return this._FactClientInfos; 4789 } 4790 set 4791 { 4792 this._FactClientInfos.Assign(value); 4793 } 4794 } 4795 4796 public event PropertyChangingEventHandler PropertyChanging; 4797 4798 public event PropertyChangedEventHandler PropertyChanged; 4799 4800 protected virtual void SendPropertyChanging() 4801 { 4802 if ((this.PropertyChanging != null)) 4803 { 4804 this.PropertyChanging(this, emptyChangingEventArgs); 4805 } 4806 } 4807 4808 protected virtual void SendPropertyChanged(String propertyName) 4809 { 4810 if ((this.PropertyChanged != null)) 4811 { 4812 this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); 4813 } 4814 } 4815 4816 private void attach_FactTasks(FactTask entity) 4817 { 4818 this.SendPropertyChanging(); 4819 entity.DimClient = this; 4820 } 4821 4822 private void detach_FactTasks(FactTask entity) 4823 { 4824 this.SendPropertyChanging(); 4825 entity.DimClient = null; 4826 } 4827 4828 private void attach_FactClientInfos(FactClientInfo entity) 4829 { 4830 this.SendPropertyChanging(); 4831 entity.DimClient = this; 4832 } 4833 4834 private void detach_FactClientInfos(FactClientInfo entity) 4835 { 4836 this.SendPropertyChanging(); 4837 entity.DimClient = null; 4838 } 4839 } 4840 4841 [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].FactTask")] 4842 public partial class FactTask : INotifyPropertyChanging, INotifyPropertyChanged 4843 { 4844 4845 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty); 4846 4847 private System.Guid _TaskId; 4848 4849 private double _TotalRuntime; 4850 4851 private double _TotalWaitingTime; 4852 4853 private double _TotalTransferTime; 4854 4855 private int _NumCalculationRuns; 4856 4857 private int _NumFails; 4858 4859 private int _CoresRequired; 4860 4861 private int _MemoryRequired; 4862 4863 private int _Priority; 4864 4865 private System.Guid _LastClientId; 4866 4867 private System.Guid _JobId; 4868 4869 private System.DateTime _StartTime; 4870 4871 private System.Nullable<System.DateTime> _EndTime; 4872 4873 private global::HeuristicLab.Services.Hive.DataAccess.TaskState _TaskState; 4874 4875 private string _Exception; 4876 4877 private EntityRef<DimClient> _DimClient; 4878 4879 private EntityRef<DimJob> _DimJob; 4880 4881 private EntityRef<DimTime> _DimTime; 4882 4883 private EntityRef<DimTime> _DimTime1; 4884 4885 #region Extensibility Method Definitions 4886 partial void OnLoaded(); 4887 partial void OnValidate(System.Data.Linq.ChangeAction action); 4888 partial void OnCreated(); 4889 partial void OnTaskIdChanging(System.Guid value); 4890 partial void OnTaskIdChanged(); 4891 partial void OnTotalRuntimeChanging(double value); 4892 partial void OnTotalRuntimeChanged(); 4893 partial void OnTotalWaitingTimeChanging(double value); 4894 partial void OnTotalWaitingTimeChanged(); 4895 partial void OnTotalTransferTimeChanging(double value); 4896 partial void OnTotalTransferTimeChanged(); 4897 partial void OnNumCalculationRunsChanging(int value); 4898 partial void OnNumCalculationRunsChanged(); 4899 partial void OnNumRetriesChanging(int value); 4900 partial void OnNumRetriesChanged(); 4901 partial void OnCoresRequiredChanging(int value); 4902 partial void OnCoresRequiredChanged(); 4903 partial void OnMemoryRequiredChanging(int value); 4904 partial void OnMemoryRequiredChanged(); 4905 partial void OnPriorityChanging(int value); 4906 partial void OnPriorityChanged(); 4907 partial void OnLastClientIdChanging(System.Guid value); 4908 partial void OnLastClientIdChanged(); 4909 partial void OnJobIdChanging(System.Guid value); 4910 partial void OnJobIdChanged(); 4911 partial void OnStartTimeChanging(System.DateTime value); 4912 partial void OnStartTimeChanged(); 4913 partial void OnEndTimeChanging(System.Nullable<System.DateTime> value); 4914 partial void OnEndTimeChanged(); 4915 partial void OnTaskStateChanging(global::HeuristicLab.Services.Hive.DataAccess.TaskState value); 4916 partial void OnTaskStateChanged(); 4917 partial void OnExceptionChanging(string value); 4918 partial void OnExceptionChanged(); 4919 #endregion 4920 4921 public FactTask() 4922 { 4923 this._DimClient = default(EntityRef<DimClient>); 4924 this._DimJob = default(EntityRef<DimJob>); 4925 this._DimTime = default(EntityRef<DimTime>); 4926 this._DimTime1 = default(EntityRef<DimTime>); 4927 OnCreated(); 4928 } 4929 4930 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TaskId", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)] 4931 public System.Guid TaskId 4932 { 4933 get 4934 { 4935 return this._TaskId; 4936 } 4937 set 4938 { 4939 if ((this._TaskId != value)) 4940 { 4941 this.OnTaskIdChanging(value); 4942 this.SendPropertyChanging(); 4943 this._TaskId = value; 4944 this.SendPropertyChanged("TaskId"); 4945 this.OnTaskIdChanged(); 4946 } 4947 } 4948 } 4949 4950 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalRuntime", DbType="Float NOT NULL")] 4951 public double TotalRuntime 4952 { 4953 get 4954 { 4955 return this._TotalRuntime; 4956 } 4957 set 4958 { 4959 if ((this._TotalRuntime != value)) 4960 { 4961 this.OnTotalRuntimeChanging(value); 4962 this.SendPropertyChanging(); 4963 this._TotalRuntime = value; 4964 this.SendPropertyChanged("TotalRuntime"); 4965 this.OnTotalRuntimeChanged(); 4966 } 4967 } 4968 } 4969 4970 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalWaitingTime", DbType="Float NOT NULL")] 4971 public double TotalWaitingTime 4972 { 4973 get 4974 { 4975 return this._TotalWaitingTime; 4976 } 4977 set 4978 { 4979 if ((this._TotalWaitingTime != value)) 4980 { 4981 this.OnTotalWaitingTimeChanging(value); 4982 this.SendPropertyChanging(); 4983 this._TotalWaitingTime = value; 4984 this.SendPropertyChanged("TotalWaitingTime"); 4985 this.OnTotalWaitingTimeChanged(); 4986 } 4987 } 4988 } 4989 4990 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalTransferTime", DbType="Float NOT NULL")] 4991 public double TotalTransferTime 4992 { 4993 get 4994 { 4995 return this._TotalTransferTime; 4996 } 4997 set 4998 { 4999 if ((this._TotalTransferTime != value)) 5000 { 5001 this.OnTotalTransferTimeChanging(value); 5002 this.SendPropertyChanging(); 5003 this._TotalTransferTime = value; 5004 this.SendPropertyChanged("TotalTransferTime"); 5005 this.OnTotalTransferTimeChanged(); 5006 } 5007 } 5008 } 5009 5010 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_NumCalculationRuns", DbType="Int NOT NULL")] 5011 public int NumCalculationRuns 5012 { 5013 get 5014 { 5015 return this._NumCalculationRuns; 5016 } 5017 set 5018 { 5019 if ((this._NumCalculationRuns != value)) 5020 { 5021 this.OnNumCalculationRunsChanging(value); 5022 this.SendPropertyChanging(); 5023 this._NumCalculationRuns = value; 5024 this.SendPropertyChanged("NumCalculationRuns"); 5025 this.OnNumCalculationRunsChanged(); 5026 } 5027 } 5028 } 5029 5030 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_NumFails", DbType="Int NOT NULL")] 5031 public int NumRetries 5032 { 5033 get 5034 { 5035 return this._NumFails; 5036 } 5037 set 5038 { 5039 if ((this._NumFails != value)) 5040 { 5041 this.OnNumRetriesChanging(value); 5042 this.SendPropertyChanging(); 5043 this._NumFails = value; 5044 this.SendPropertyChanged("NumRetries"); 5045 this.OnNumRetriesChanged(); 5046 } 5047 } 5048 } 5049 5050 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CoresRequired", DbType="Int NOT NULL")] 5051 public int CoresRequired 5052 { 5053 get 5054 { 5055 return this._CoresRequired; 5056 } 5057 set 5058 { 5059 if ((this._CoresRequired != value)) 5060 { 5061 this.OnCoresRequiredChanging(value); 5062 this.SendPropertyChanging(); 5063 this._CoresRequired = value; 5064 this.SendPropertyChanged("CoresRequired"); 5065 this.OnCoresRequiredChanged(); 5066 } 5067 } 5068 } 5069 5070 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_MemoryRequired", DbType="Int NOT NULL")] 5071 public int MemoryRequired 5072 { 5073 get 5074 { 5075 return this._MemoryRequired; 5076 } 5077 set 5078 { 5079 if ((this._MemoryRequired != value)) 5080 { 5081 this.OnMemoryRequiredChanging(value); 5082 this.SendPropertyChanging(); 5083 this._MemoryRequired = value; 5084 this.SendPropertyChanged("MemoryRequired"); 5085 this.OnMemoryRequiredChanged(); 5086 } 5087 } 5088 } 5089 5090 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Priority", DbType="Int NOT NULL")] 5091 public int Priority 5092 { 5093 get 5094 { 5095 return this._Priority; 5096 } 5097 set 5098 { 5099 if ((this._Priority != value)) 5100 { 5101 this.OnPriorityChanging(value); 5102 this.SendPropertyChanging(); 5103 this._Priority = value; 5104 this.SendPropertyChanged("Priority"); 5105 this.OnPriorityChanged(); 5106 } 5107 } 5108 } 5109 5110 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_LastClientId", DbType="UniqueIdentifier NOT NULL")] 5111 public System.Guid LastClientId 5112 { 5113 get 5114 { 5115 return this._LastClientId; 5116 } 5117 set 5118 { 5119 if ((this._LastClientId != value)) 5120 { 5121 if (this._DimClient.HasLoadedOrAssignedValue) 5122 { 5123 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 5124 } 5125 this.OnLastClientIdChanging(value); 5126 this.SendPropertyChanging(); 5127 this._LastClientId = value; 5128 this.SendPropertyChanged("LastClientId"); 5129 this.OnLastClientIdChanged(); 5130 } 5131 } 5132 } 5133 5134 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_JobId", DbType="UniqueIdentifier NOT NULL")] 5135 public System.Guid JobId 5136 { 5137 get 5138 { 5139 return this._JobId; 5140 } 5141 set 5142 { 5143 if ((this._JobId != value)) 5144 { 5145 if (this._DimJob.HasLoadedOrAssignedValue) 5146 { 5147 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 5148 } 5149 this.OnJobIdChanging(value); 5150 this.SendPropertyChanging(); 5151 this._JobId = value; 5152 this.SendPropertyChanged("JobId"); 5153 this.OnJobIdChanged(); 5154 } 5155 } 5156 } 5157 5158 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_StartTime", DbType="DateTime NOT NULL")] 5159 public System.DateTime StartTime 5160 { 5161 get 5162 { 5163 return this._StartTime; 5164 } 5165 set 5166 { 5167 if ((this._StartTime != value)) 5168 { 5169 if (this._DimTime1.HasLoadedOrAssignedValue) 5170 { 5171 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 5172 } 5173 this.OnStartTimeChanging(value); 5174 this.SendPropertyChanging(); 5175 this._StartTime = value; 5176 this.SendPropertyChanged("StartTime"); 5177 this.OnStartTimeChanged(); 5178 } 5179 } 5180 } 5181 5182 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_EndTime", DbType="DateTime NOT NULL")] 5183 public System.Nullable<System.DateTime> EndTime 5184 { 5185 get 5186 { 5187 return this._EndTime; 5188 } 5189 set 5190 { 5191 if ((this._EndTime != value)) 5192 { 5193 if (this._DimTime.HasLoadedOrAssignedValue) 5194 { 5195 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 5196 } 5197 this.OnEndTimeChanging(value); 5198 this.SendPropertyChanging(); 5199 this._EndTime = value; 5200 this.SendPropertyChanged("EndTime"); 5201 this.OnEndTimeChanged(); 5202 } 5203 } 5204 } 5205 5206 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TaskState", DbType="varchar(30)", CanBeNull=false)] 5207 public global::HeuristicLab.Services.Hive.DataAccess.TaskState TaskState 5208 { 5209 get 5210 { 5211 return this._TaskState; 5212 } 5213 set 5214 { 5215 if ((this._TaskState != value)) 5216 { 5217 this.OnTaskStateChanging(value); 5218 this.SendPropertyChanging(); 5219 this._TaskState = value; 5220 this.SendPropertyChanged("TaskState"); 5221 this.OnTaskStateChanged(); 5222 } 5223 } 5224 } 5225 5226 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Exception", DbType="varchar(MAX)")] 5227 public string Exception 5228 { 5229 get 5230 { 5231 return this._Exception; 5232 } 5233 set 5234 { 5235 if ((this._Exception != value)) 5236 { 5237 this.OnExceptionChanging(value); 5238 this.SendPropertyChanging(); 5239 this._Exception = value; 5240 this.SendPropertyChanged("Exception"); 5241 this.OnExceptionChanged(); 5242 } 5243 } 5244 } 5245 5246 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimClient_FactTask", Storage="_DimClient", ThisKey="LastClientId", OtherKey="Id", IsForeignKey=true)] 5247 public DimClient DimClient 5248 { 5249 get 5250 { 5251 return this._DimClient.Entity; 5252 } 5253 set 5254 { 5255 DimClient previousValue = this._DimClient.Entity; 5256 if (((previousValue != value) 5257 || (this._DimClient.HasLoadedOrAssignedValue == false))) 5258 { 5259 this.SendPropertyChanging(); 5260 if ((previousValue != null)) 5261 { 5262 this._DimClient.Entity = null; 5263 previousValue.FactTasks.Remove(this); 5264 } 5265 this._DimClient.Entity = value; 5266 if ((value != null)) 5267 { 5268 value.FactTasks.Add(this); 5269 this._LastClientId = value.Id; 5270 } 5271 else 5272 { 5273 this._LastClientId = default(System.Guid); 5274 } 5275 this.SendPropertyChanged("DimClient"); 5276 } 5277 } 5278 } 5279 5280 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimJob_FactTask", Storage="_DimJob", ThisKey="JobId", OtherKey="JobId", IsForeignKey=true)] 5281 public DimJob DimJob 5282 { 5283 get 5284 { 5285 return this._DimJob.Entity; 5286 } 5287 set 5288 { 5289 DimJob previousValue = this._DimJob.Entity; 5290 if (((previousValue != value) 5291 || (this._DimJob.HasLoadedOrAssignedValue == false))) 5292 { 5293 this.SendPropertyChanging(); 5294 if ((previousValue != null)) 5295 { 5296 this._DimJob.Entity = null; 5297 previousValue.FactTasks.Remove(this); 5298 } 5299 this._DimJob.Entity = value; 5300 if ((value != null)) 5301 { 5302 value.FactTasks.Add(this); 5303 this._JobId = value.JobId; 5304 } 5305 else 5306 { 5307 this._JobId = default(System.Guid); 5308 } 5309 this.SendPropertyChanged("DimJob"); 5310 } 5311 } 5312 } 5313 5314 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimTime_FactTask", Storage="_DimTime", ThisKey="EndTime", OtherKey="Time", IsForeignKey=true)] 5315 public DimTime DimTimeEnd 5316 { 5317 get 5318 { 5319 return this._DimTime.Entity; 5320 } 5321 set 5322 { 5323 DimTime previousValue = this._DimTime.Entity; 5324 if (((previousValue != value) 5325 || (this._DimTime.HasLoadedOrAssignedValue == false))) 5326 { 5327 this.SendPropertyChanging(); 5328 if ((previousValue != null)) 5329 { 5330 this._DimTime.Entity = null; 5331 previousValue.FactTasks.Remove(this); 5332 } 5333 this._DimTime.Entity = value; 5334 if ((value != null)) 5335 { 5336 value.FactTasks.Add(this); 5337 this._EndTime = value.Time; 5338 } 5339 else 5340 { 5341 this._EndTime = default(Nullable<System.DateTime>); 5342 } 5343 this.SendPropertyChanged("DimTimeEnd"); 5344 } 5345 } 5346 } 5347 5348 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimTime_FactTask1", Storage="_DimTime1", ThisKey="StartTime", OtherKey="Time", IsForeignKey=true)] 5349 public DimTime DimTimeStart 5350 { 5351 get 5352 { 5353 return this._DimTime1.Entity; 5354 } 5355 set 5356 { 5357 DimTime previousValue = this._DimTime1.Entity; 5358 if (((previousValue != value) 5359 || (this._DimTime1.HasLoadedOrAssignedValue == false))) 5360 { 5361 this.SendPropertyChanging(); 5362 if ((previousValue != null)) 5363 { 5364 this._DimTime1.Entity = null; 5365 previousValue.FactTasks1.Remove(this); 5366 } 5367 this._DimTime1.Entity = value; 5368 if ((value != null)) 5369 { 5370 value.FactTasks1.Add(this); 5371 this._StartTime = value.Time; 5372 } 5373 else 5374 { 5375 this._StartTime = default(System.DateTime); 5376 } 5377 this.SendPropertyChanged("DimTimeStart"); 5378 } 5379 } 5380 } 5381 5382 public event PropertyChangingEventHandler PropertyChanging; 5383 5384 public event PropertyChangedEventHandler PropertyChanged; 5385 5386 protected virtual void SendPropertyChanging() 5387 { 5388 if ((this.PropertyChanging != null)) 5389 { 5390 this.PropertyChanging(this, emptyChangingEventArgs); 5391 } 5392 } 5393 5394 protected virtual void SendPropertyChanged(String propertyName) 5395 { 5396 if ((this.PropertyChanged != null)) 5397 { 5398 this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); 5399 } 5400 } 5401 } 5402 5403 [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].DimJob")] 5404 public partial class DimJob : INotifyPropertyChanging, INotifyPropertyChanged 5405 { 5406 5407 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty); 5408 5409 private System.Guid _JobId; 5410 5411 private System.Guid _UserId; 5412 5413 private string _JobName; 5414 5415 private string _UserName; 5416 5417 private EntitySet<FactTask> _FactTasks; 5418 5419 #region Extensibility Method Definitions 5420 partial void OnLoaded(); 5421 partial void OnValidate(System.Data.Linq.ChangeAction action); 5422 partial void OnCreated(); 5423 partial void OnJobIdChanging(System.Guid value); 5424 partial void OnJobIdChanged(); 5425 partial void OnUserIdChanging(System.Guid value); 5426 partial void OnUserIdChanged(); 5427 partial void OnJobNameChanging(string value); 5428 partial void OnJobNameChanged(); 5429 partial void OnUserNameChanging(string value); 5430 partial void OnUserNameChanged(); 5431 #endregion 5432 5433 public DimJob() 5434 { 5435 this._FactTasks = new EntitySet<FactTask>(new Action<FactTask>(this.attach_FactTasks), new Action<FactTask>(this.detach_FactTasks)); 5436 OnCreated(); 5437 } 5438 5439 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_JobId", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)] 5440 public System.Guid JobId 5441 { 5442 get 5443 { 5444 return this._JobId; 5445 } 5446 set 5447 { 5448 if ((this._JobId != value)) 5449 { 5450 this.OnJobIdChanging(value); 5451 this.SendPropertyChanging(); 5452 this._JobId = value; 5453 this.SendPropertyChanged("JobId"); 5454 this.OnJobIdChanged(); 5455 } 5456 } 5457 } 5458 5459 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_UserId", DbType="UniqueIdentifier NOT NULL")] 5460 public System.Guid UserId 5461 { 5462 get 5463 { 5464 return this._UserId; 5465 } 5466 set 5467 { 5468 if ((this._UserId != value)) 5469 { 5470 this.OnUserIdChanging(value); 5471 this.SendPropertyChanging(); 5472 this._UserId = value; 5473 this.SendPropertyChanged("UserId"); 5474 this.OnUserIdChanged(); 5475 } 5476 } 5477 } 5478 5479 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_JobName", DbType="VarChar(MAX) NOT NULL", CanBeNull=false)] 5480 public string JobName 5481 { 5482 get 5483 { 5484 return this._JobName; 5485 } 5486 set 5487 { 5488 if ((this._JobName != value)) 5489 { 5490 this.OnJobNameChanging(value); 5491 this.SendPropertyChanging(); 5492 this._JobName = value; 5493 this.SendPropertyChanged("JobName"); 5494 this.OnJobNameChanged(); 5495 } 5496 } 5497 } 5498 5499 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_UserName", DbType="VarChar(MAX) NOT NULL", CanBeNull=false)] 5500 public string UserName 5501 { 5502 get 5503 { 5504 return this._UserName; 5505 } 5506 set 5507 { 5508 if ((this._UserName != value)) 5509 { 5510 this.OnUserNameChanging(value); 5511 this.SendPropertyChanging(); 5512 this._UserName = value; 5513 this.SendPropertyChanged("UserName"); 5514 this.OnUserNameChanged(); 5515 } 5516 } 5517 } 5518 5519 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimJob_FactTask", Storage="_FactTasks", ThisKey="JobId", OtherKey="JobId")] 5520 public EntitySet<FactTask> FactTasks 5521 { 5522 get 5523 { 5524 return this._FactTasks; 5525 } 5526 set 5527 { 5528 this._FactTasks.Assign(value); 5529 } 5530 } 5531 5532 public event PropertyChangingEventHandler PropertyChanging; 5533 5534 public event PropertyChangedEventHandler PropertyChanged; 5535 5536 protected virtual void SendPropertyChanging() 5537 { 5538 if ((this.PropertyChanging != null)) 5539 { 5540 this.PropertyChanging(this, emptyChangingEventArgs); 5541 } 5542 } 5543 5544 protected virtual void SendPropertyChanged(String propertyName) 5545 { 5546 if ((this.PropertyChanged != null)) 5547 { 5548 this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); 5549 } 5550 } 5551 5552 private void attach_FactTasks(FactTask entity) 5553 { 5554 this.SendPropertyChanging(); 5555 entity.DimJob = this; 5556 } 5557 5558 private void detach_FactTasks(FactTask entity) 5559 { 5560 this.SendPropertyChanging(); 5561 entity.DimJob = null; 5562 } 5563 } 5564 5565 [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].DimTime")] 5566 public partial class DimTime : INotifyPropertyChanging, INotifyPropertyChanged 5567 { 5568 5569 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty); 5570 5571 private System.DateTime _Time; 5572 5573 private System.DateTime _Hour; 5574 5575 private System.DateTime _Day; 5576 5577 private System.DateTime _Month; 5578 5579 private System.DateTime _Year; 5580 5581 private EntitySet<FactTask> _FactTasks; 5582 5583 private EntitySet<FactTask> _FactTasks1; 5584 5585 private EntitySet<FactClientInfo> _FactClientInfos; 5586 5587 #region Extensibility Method Definitions 5588 partial void OnLoaded(); 5589 partial void OnValidate(System.Data.Linq.ChangeAction action); 5590 partial void OnCreated(); 5591 partial void OnTimeChanging(System.DateTime value); 5592 partial void OnTimeChanged(); 5593 partial void OnHourChanging(System.DateTime value); 5594 partial void OnHourChanged(); 5595 partial void OnDayChanging(System.DateTime value); 5596 partial void OnDayChanged(); 5597 partial void OnMonthChanging(System.DateTime value); 5598 partial void OnMonthChanged(); 5599 partial void OnYearChanging(System.DateTime value); 5600 partial void OnYearChanged(); 5601 #endregion 5602 5603 public DimTime() 5604 { 5605 this._FactTasks = new EntitySet<FactTask>(new Action<FactTask>(this.attach_FactTasks), new Action<FactTask>(this.detach_FactTasks)); 5606 this._FactTasks1 = new EntitySet<FactTask>(new Action<FactTask>(this.attach_FactTasks1), new Action<FactTask>(this.detach_FactTasks1)); 5607 this._FactClientInfos = new EntitySet<FactClientInfo>(new Action<FactClientInfo>(this.attach_FactClientInfos), new Action<FactClientInfo>(this.detach_FactClientInfos)); 5608 OnCreated(); 5609 } 5610 5611 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Time", DbType="DateTime NOT NULL", IsPrimaryKey=true)] 5612 public System.DateTime Time 5613 { 5614 get 5615 { 5616 return this._Time; 5617 } 5618 set 5619 { 5620 if ((this._Time != value)) 5621 { 5622 this.OnTimeChanging(value); 5623 this.SendPropertyChanging(); 5624 this._Time = value; 5625 this.SendPropertyChanged("Time"); 5626 this.OnTimeChanged(); 5627 } 5628 } 5629 } 5630 5631 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Hour", DbType="DateTime NOT NULL")] 5632 public System.DateTime Hour 5633 { 5634 get 5635 { 5636 return this._Hour; 5637 } 5638 set 5639 { 5640 if ((this._Hour != value)) 5641 { 5642 this.OnHourChanging(value); 5643 this.SendPropertyChanging(); 5644 this._Hour = value; 5645 this.SendPropertyChanged("Hour"); 5646 this.OnHourChanged(); 5647 } 5648 } 5649 } 5650 5651 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Day", DbType="Date NOT NULL")] 5652 public System.DateTime Day 5653 { 5654 get 5655 { 5656 return this._Day; 5657 } 5658 set 5659 { 5660 if ((this._Day != value)) 5661 { 5662 this.OnDayChanging(value); 5663 this.SendPropertyChanging(); 5664 this._Day = value; 5665 this.SendPropertyChanged("Day"); 5666 this.OnDayChanged(); 5667 } 5668 } 5669 } 5670 5671 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Month", DbType="Date NOT NULL")] 5672 public System.DateTime Month 5673 { 5674 get 5675 { 5676 return this._Month; 5677 } 5678 set 5679 { 5680 if ((this._Month != value)) 5681 { 5682 this.OnMonthChanging(value); 5683 this.SendPropertyChanging(); 5684 this._Month = value; 5685 this.SendPropertyChanged("Month"); 5686 this.OnMonthChanged(); 5687 } 5688 } 5689 } 5690 5691 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Year", DbType="Date NOT NULL")] 5692 public System.DateTime Year 5693 { 5694 get 5695 { 5696 return this._Year; 5697 } 5698 set 5699 { 5700 if ((this._Year != value)) 5701 { 5702 this.OnYearChanging(value); 5703 this.SendPropertyChanging(); 5704 this._Year = value; 5705 this.SendPropertyChanged("Year"); 5706 this.OnYearChanged(); 5707 } 5708 } 5709 } 5710 5711 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimTime_FactTask", Storage="_FactTasks", ThisKey="Time", OtherKey="EndTime")] 5712 public EntitySet<FactTask> FactTasks 5713 { 5714 get 5715 { 5716 return this._FactTasks; 5717 } 5718 set 5719 { 5720 this._FactTasks.Assign(value); 5721 } 5722 } 5723 5724 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimTime_FactTask1", Storage="_FactTasks1", ThisKey="Time", OtherKey="StartTime")] 5725 public EntitySet<FactTask> FactTasks1 5726 { 5727 get 5728 { 5729 return this._FactTasks1; 5730 } 5731 set 5732 { 5733 this._FactTasks1.Assign(value); 5734 } 5735 } 5736 5737 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimTime_FactClientInfo", Storage="_FactClientInfos", ThisKey="Time", OtherKey="Time")] 5738 public EntitySet<FactClientInfo> FactClientInfos 5739 { 5740 get 5741 { 5742 return this._FactClientInfos; 5743 } 5744 set 5745 { 5746 this._FactClientInfos.Assign(value); 5747 } 5748 } 5749 5750 public event PropertyChangingEventHandler PropertyChanging; 5751 5752 public event PropertyChangedEventHandler PropertyChanged; 5753 5754 protected virtual void SendPropertyChanging() 5755 { 5756 if ((this.PropertyChanging != null)) 5757 { 5758 this.PropertyChanging(this, emptyChangingEventArgs); 5759 } 5760 } 5761 5762 protected virtual void SendPropertyChanged(String propertyName) 5763 { 5764 if ((this.PropertyChanged != null)) 5765 { 5766 this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); 5767 } 5768 } 5769 5770 private void attach_FactTasks(FactTask entity) 5771 { 5772 this.SendPropertyChanging(); 5773 entity.DimTimeEnd = this; 5774 } 5775 5776 private void detach_FactTasks(FactTask entity) 5777 { 5778 this.SendPropertyChanging(); 5779 entity.DimTimeEnd = null; 5780 } 5781 5782 private void attach_FactTasks1(FactTask entity) 5783 { 5784 this.SendPropertyChanging(); 5785 entity.DimTimeStart = this; 5786 } 5787 5788 private void detach_FactTasks1(FactTask entity) 5789 { 5790 this.SendPropertyChanging(); 5791 entity.DimTimeStart = null; 5792 } 5793 5794 private void attach_FactClientInfos(FactClientInfo entity) 5795 { 5796 this.SendPropertyChanging(); 5797 entity.DimTime = this; 5798 } 5799 5800 private void detach_FactClientInfos(FactClientInfo entity) 5801 { 5802 this.SendPropertyChanging(); 5803 entity.DimTime = null; 5804 } 5805 } 5806 5807 [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].DimUser")] 5808 public partial class DimUser : INotifyPropertyChanging, INotifyPropertyChanged 5809 { 5810 5811 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty); 5812 5813 private System.Guid _UserId; 5814 5815 private string _Name; 5816 5817 private EntitySet<FactClientInfo> _FactClientInfos; 5818 5819 #region Extensibility Method Definitions 5820 partial void OnLoaded(); 5821 partial void OnValidate(System.Data.Linq.ChangeAction action); 5822 partial void OnCreated(); 5823 partial void OnUserIdChanging(System.Guid value); 5824 partial void OnUserIdChanged(); 5825 partial void OnNameChanging(string value); 5826 partial void OnNameChanged(); 5827 #endregion 5828 5829 public DimUser() 5830 { 5831 this._FactClientInfos = new EntitySet<FactClientInfo>(new Action<FactClientInfo>(this.attach_FactClientInfos), new Action<FactClientInfo>(this.detach_FactClientInfos)); 5832 OnCreated(); 5833 } 5834 5835 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_UserId", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)] 5836 public System.Guid UserId 5837 { 5838 get 5839 { 5840 return this._UserId; 5841 } 5842 set 5843 { 5844 if ((this._UserId != value)) 5845 { 5846 this.OnUserIdChanging(value); 5847 this.SendPropertyChanging(); 5848 this._UserId = value; 5849 this.SendPropertyChanged("UserId"); 5850 this.OnUserIdChanged(); 5851 } 5852 } 5853 } 5854 5855 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Name", DbType="VarChar(MAX) NOT NULL", CanBeNull=false)] 5856 public string Name 5857 { 5858 get 5859 { 5860 return this._Name; 5861 } 5862 set 5863 { 5864 if ((this._Name != value)) 5865 { 5866 this.OnNameChanging(value); 5867 this.SendPropertyChanging(); 5868 this._Name = value; 5869 this.SendPropertyChanged("Name"); 5870 this.OnNameChanged(); 5871 } 5872 } 5873 } 5874 5875 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimUser_FactClientInfo", Storage="_FactClientInfos", ThisKey="UserId", OtherKey="UserId")] 5876 public EntitySet<FactClientInfo> FactClientInfos 5877 { 5878 get 5879 { 5880 return this._FactClientInfos; 5881 } 5882 set 5883 { 5884 this._FactClientInfos.Assign(value); 5885 } 5886 } 5887 5888 public event PropertyChangingEventHandler PropertyChanging; 5889 5890 public event PropertyChangedEventHandler PropertyChanged; 5891 5892 protected virtual void SendPropertyChanging() 5893 { 5894 if ((this.PropertyChanging != null)) 5895 { 5896 this.PropertyChanging(this, emptyChangingEventArgs); 5897 } 5898 } 5899 5900 protected virtual void SendPropertyChanged(String propertyName) 5901 { 5902 if ((this.PropertyChanged != null)) 5903 { 5904 this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); 5905 } 5906 } 5907 5908 private void attach_FactClientInfos(FactClientInfo entity) 5909 { 5910 this.SendPropertyChanging(); 5911 entity.DimUser = this; 5912 } 5913 5914 private void detach_FactClientInfos(FactClientInfo entity) 5915 { 5916 this.SendPropertyChanging(); 5917 entity.DimUser = null; 5918 } 5919 } 5920 5921 [global::System.Data.Linq.Mapping.TableAttribute(Name="[statistics].FactClientInfo")] 5922 public partial class FactClientInfo : INotifyPropertyChanging, INotifyPropertyChanged 5923 { 5924 5925 private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty); 5926 5927 private System.Guid _ClientId; 5928 5929 private System.DateTime _Time; 5930 5931 private System.Guid _UserId; 5932 5933 private int _NumUsedCores; 5934 5935 private int _NumTotalCores; 5936 5937 private int _UsedMemory; 5938 5939 private int _TotalMemory; 5940 5941 private double _CpuUtilization; 5942 5943 private double _TotalTimeIdle; 5944 5945 private double _TotalTimeCalculating; 5946 5947 private double _TotalTimeTransferring; 5948 5949 private double _TotalTimeOffline; 5950 5951 private double _TotalTimeUnavailable; 5952 5953 private global::HeuristicLab.Services.Hive.DataAccess.SlaveState _SlaveState; 5954 5955 private EntityRef<DimClient> _DimClient; 5956 5957 private EntityRef<DimTime> _DimTime; 5958 5959 private EntityRef<DimUser> _DimUser; 5960 5961 #region Extensibility Method Definitions 5962 partial void OnLoaded(); 5963 partial void OnValidate(System.Data.Linq.ChangeAction action); 5964 partial void OnCreated(); 5965 partial void OnClientIdChanging(System.Guid value); 5966 partial void OnClientIdChanged(); 5967 partial void OnTimeChanging(System.DateTime value); 5968 partial void OnTimeChanged(); 5969 partial void OnUserIdChanging(System.Guid value); 5970 partial void OnUserIdChanged(); 5971 partial void OnNumUsedCoresChanging(int value); 5972 partial void OnNumUsedCoresChanged(); 5973 partial void OnNumTotalCoresChanging(int value); 5974 partial void OnNumTotalCoresChanged(); 5975 partial void OnUsedMemoryChanging(int value); 5976 partial void OnUsedMemoryChanged(); 5977 partial void OnTotalMemoryChanging(int value); 5978 partial void OnTotalMemoryChanged(); 5979 partial void OnCpuUtilizationChanging(double value); 5980 partial void OnCpuUtilizationChanged(); 5981 partial void OnTotalTimeIdleChanging(double value); 5982 partial void OnTotalTimeIdleChanged(); 5983 partial void OnTotalTimeCalculatingChanging(double value); 5984 partial void OnTotalTimeCalculatingChanged(); 5985 partial void OnTotalTimeTransferringChanging(double value); 5986 partial void OnTotalTimeTransferringChanged(); 5987 partial void OnTotalTimeOfflineChanging(double value); 5988 partial void OnTotalTimeOfflineChanged(); 5989 partial void OnTotalTimeUnavailableChanging(double value); 5990 partial void OnTotalTimeUnavailableChanged(); 5991 partial void OnSlaveStateChanging(global::HeuristicLab.Services.Hive.DataAccess.SlaveState value); 5992 partial void OnSlaveStateChanged(); 5993 #endregion 5994 5995 public FactClientInfo() 5996 { 5997 this._DimClient = default(EntityRef<DimClient>); 5998 this._DimTime = default(EntityRef<DimTime>); 5999 this._DimUser = default(EntityRef<DimUser>); 6000 OnCreated(); 6001 } 6002 6003 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ClientId", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)] 6004 public System.Guid ClientId 6005 { 6006 get 6007 { 6008 return this._ClientId; 6009 } 6010 set 6011 { 6012 if ((this._ClientId != value)) 6013 { 6014 if (this._DimClient.HasLoadedOrAssignedValue) 6015 { 6016 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 6017 } 6018 this.OnClientIdChanging(value); 6019 this.SendPropertyChanging(); 6020 this._ClientId = value; 6021 this.SendPropertyChanged("ClientId"); 6022 this.OnClientIdChanged(); 6023 } 6024 } 6025 } 6026 6027 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Time", DbType="DateTime NOT NULL", IsPrimaryKey=true)] 6028 public System.DateTime Time 6029 { 6030 get 6031 { 6032 return this._Time; 6033 } 6034 set 6035 { 6036 if ((this._Time != value)) 6037 { 6038 if (this._DimTime.HasLoadedOrAssignedValue) 6039 { 6040 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 6041 } 6042 this.OnTimeChanging(value); 6043 this.SendPropertyChanging(); 6044 this._Time = value; 6045 this.SendPropertyChanged("Time"); 6046 this.OnTimeChanged(); 6047 } 6048 } 6049 } 6050 6051 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_UserId", DbType="UniqueIdentifier NULL", IsPrimaryKey=true)] 6052 public System.Guid UserId 6053 { 6054 get 6055 { 6056 return this._UserId; 6057 } 6058 set 6059 { 6060 if ((this._UserId != value)) 6061 { 6062 if (this._DimUser.HasLoadedOrAssignedValue) 6063 { 6064 throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); 6065 } 6066 this.OnUserIdChanging(value); 6067 this.SendPropertyChanging(); 6068 this._UserId = value; 6069 this.SendPropertyChanged("UserId"); 6070 this.OnUserIdChanged(); 6071 } 6072 } 6073 } 6074 6075 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_NumUsedCores", DbType="Int NOT NULL")] 6076 public int NumUsedCores 6077 { 6078 get 6079 { 6080 return this._NumUsedCores; 6081 } 6082 set 6083 { 6084 if ((this._NumUsedCores != value)) 6085 { 6086 this.OnNumUsedCoresChanging(value); 6087 this.SendPropertyChanging(); 6088 this._NumUsedCores = value; 6089 this.SendPropertyChanged("NumUsedCores"); 6090 this.OnNumUsedCoresChanged(); 6091 } 6092 } 6093 } 6094 6095 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_NumTotalCores", DbType="Int NOT NULL")] 6096 public int NumTotalCores 6097 { 6098 get 6099 { 6100 return this._NumTotalCores; 6101 } 6102 set 6103 { 6104 if ((this._NumTotalCores != value)) 6105 { 6106 this.OnNumTotalCoresChanging(value); 6107 this.SendPropertyChanging(); 6108 this._NumTotalCores = value; 6109 this.SendPropertyChanged("NumTotalCores"); 6110 this.OnNumTotalCoresChanged(); 6111 } 6112 } 6113 } 6114 6115 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_UsedMemory", DbType="Int NOT NULL")] 6116 public int UsedMemory 6117 { 6118 get 6119 { 6120 return this._UsedMemory; 6121 } 6122 set 6123 { 6124 if ((this._UsedMemory != value)) 6125 { 6126 this.OnUsedMemoryChanging(value); 6127 this.SendPropertyChanging(); 6128 this._UsedMemory = value; 6129 this.SendPropertyChanged("UsedMemory"); 6130 this.OnUsedMemoryChanged(); 6131 } 6132 } 6133 } 6134 6135 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalMemory", DbType="Int NOT NULL")] 6136 public int TotalMemory 6137 { 6138 get 6139 { 6140 return this._TotalMemory; 6141 } 6142 set 6143 { 6144 if ((this._TotalMemory != value)) 6145 { 6146 this.OnTotalMemoryChanging(value); 6147 this.SendPropertyChanging(); 6148 this._TotalMemory = value; 6149 this.SendPropertyChanged("TotalMemory"); 6150 this.OnTotalMemoryChanged(); 6151 } 6152 } 6153 } 6154 6155 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_CpuUtilization", DbType="Float NOT NULL")] 6156 public double CpuUtilization 6157 { 6158 get 6159 { 6160 return this._CpuUtilization; 6161 } 6162 set 6163 { 6164 if ((this._CpuUtilization != value)) 6165 { 6166 this.OnCpuUtilizationChanging(value); 6167 this.SendPropertyChanging(); 6168 this._CpuUtilization = value; 6169 this.SendPropertyChanged("CpuUtilization"); 6170 this.OnCpuUtilizationChanged(); 6171 } 6172 } 6173 } 6174 6175 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalTimeIdle", DbType="Float NOT NULL")] 6176 public double TotalTimeIdle 6177 { 6178 get 6179 { 6180 return this._TotalTimeIdle; 6181 } 6182 set 6183 { 6184 if ((this._TotalTimeIdle != value)) 6185 { 6186 this.OnTotalTimeIdleChanging(value); 6187 this.SendPropertyChanging(); 6188 this._TotalTimeIdle = value; 6189 this.SendPropertyChanged("TotalTimeIdle"); 6190 this.OnTotalTimeIdleChanged(); 6191 } 6192 } 6193 } 6194 6195 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalTimeCalculating", DbType="Float NOT NULL")] 6196 public double TotalTimeCalculating 6197 { 6198 get 6199 { 6200 return this._TotalTimeCalculating; 6201 } 6202 set 6203 { 6204 if ((this._TotalTimeCalculating != value)) 6205 { 6206 this.OnTotalTimeCalculatingChanging(value); 6207 this.SendPropertyChanging(); 6208 this._TotalTimeCalculating = value; 6209 this.SendPropertyChanged("TotalTimeCalculating"); 6210 this.OnTotalTimeCalculatingChanged(); 6211 } 6212 } 6213 } 6214 6215 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalTimeTransferring", DbType="Float NOT NULL")] 6216 public double TotalTimeTransferring 6217 { 6218 get 6219 { 6220 return this._TotalTimeTransferring; 6221 } 6222 set 6223 { 6224 if ((this._TotalTimeTransferring != value)) 6225 { 6226 this.OnTotalTimeTransferringChanging(value); 6227 this.SendPropertyChanging(); 6228 this._TotalTimeTransferring = value; 6229 this.SendPropertyChanged("TotalTimeTransferring"); 6230 this.OnTotalTimeTransferringChanged(); 6231 } 6232 } 6233 } 6234 6235 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalTimeOffline", DbType="Float NOT NULL")] 6236 public double TotalTimeOffline 6237 { 6238 get 6239 { 6240 return this._TotalTimeOffline; 6241 } 6242 set 6243 { 6244 if ((this._TotalTimeOffline != value)) 6245 { 6246 this.OnTotalTimeOfflineChanging(value); 6247 this.SendPropertyChanging(); 6248 this._TotalTimeOffline = value; 6249 this.SendPropertyChanged("TotalTimeOffline"); 6250 this.OnTotalTimeOfflineChanged(); 6251 } 6252 } 6253 } 6254 6255 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_TotalTimeUnavailable", DbType="Float NOT NULL")] 6256 public double TotalTimeUnavailable 6257 { 6258 get 6259 { 6260 return this._TotalTimeUnavailable; 6261 } 6262 set 6263 { 6264 if ((this._TotalTimeUnavailable != value)) 6265 { 6266 this.OnTotalTimeUnavailableChanging(value); 6267 this.SendPropertyChanging(); 6268 this._TotalTimeUnavailable = value; 6269 this.SendPropertyChanged("TotalTimeUnavailable"); 6270 this.OnTotalTimeUnavailableChanged(); 6271 } 6272 } 6273 } 6274 6275 [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_SlaveState", DbType="VarChar(15)", CanBeNull=false)] 6276 public global::HeuristicLab.Services.Hive.DataAccess.SlaveState SlaveState 6277 { 6278 get 6279 { 6280 return this._SlaveState; 6281 } 6282 set 6283 { 6284 if ((this._SlaveState != value)) 6285 { 6286 this.OnSlaveStateChanging(value); 6287 this.SendPropertyChanging(); 6288 this._SlaveState = value; 6289 this.SendPropertyChanged("SlaveState"); 6290 this.OnSlaveStateChanged(); 6291 } 6292 } 6293 } 6294 6295 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimClient_FactClientInfo", Storage="_DimClient", ThisKey="ClientId", OtherKey="Id", IsForeignKey=true)] 6296 public DimClient DimClient 6297 { 6298 get 6299 { 6300 return this._DimClient.Entity; 6301 } 6302 set 6303 { 6304 DimClient previousValue = this._DimClient.Entity; 6305 if (((previousValue != value) 6306 || (this._DimClient.HasLoadedOrAssignedValue == false))) 6307 { 6308 this.SendPropertyChanging(); 6309 if ((previousValue != null)) 6310 { 6311 this._DimClient.Entity = null; 6312 previousValue.FactClientInfos.Remove(this); 6313 } 6314 this._DimClient.Entity = value; 6315 if ((value != null)) 6316 { 6317 value.FactClientInfos.Add(this); 6318 this._ClientId = value.Id; 6319 } 6320 else 6321 { 6322 this._ClientId = default(System.Guid); 6323 } 6324 this.SendPropertyChanged("DimClient"); 6325 } 6326 } 6327 } 6328 6329 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimTime_FactClientInfo", Storage="_DimTime", ThisKey="Time", OtherKey="Time", IsForeignKey=true)] 6330 public DimTime DimTime 6331 { 6332 get 6333 { 6334 return this._DimTime.Entity; 6335 } 6336 set 6337 { 6338 DimTime previousValue = this._DimTime.Entity; 6339 if (((previousValue != value) 6340 || (this._DimTime.HasLoadedOrAssignedValue == false))) 6341 { 6342 this.SendPropertyChanging(); 6343 if ((previousValue != null)) 6344 { 6345 this._DimTime.Entity = null; 6346 previousValue.FactClientInfos.Remove(this); 6347 } 6348 this._DimTime.Entity = value; 6349 if ((value != null)) 6350 { 6351 value.FactClientInfos.Add(this); 6352 this._Time = value.Time; 6353 } 6354 else 6355 { 6356 this._Time = default(System.DateTime); 6357 } 6358 this.SendPropertyChanged("DimTime"); 6359 } 6360 } 6361 } 6362 6363 [global::System.Data.Linq.Mapping.AssociationAttribute(Name="DimUser_FactClientInfo", Storage="_DimUser", ThisKey="UserId", OtherKey="UserId", IsForeignKey=true)] 6364 public DimUser DimUser 6365 { 6366 get 6367 { 6368 return this._DimUser.Entity; 6369 } 6370 set 6371 { 6372 DimUser previousValue = this._DimUser.Entity; 6373 if (((previousValue != value) 6374 || (this._DimUser.HasLoadedOrAssignedValue == false))) 6375 { 6376 this.SendPropertyChanging(); 6377 if ((previousValue != null)) 6378 { 6379 this._DimUser.Entity = null; 6380 previousValue.FactClientInfos.Remove(this); 6381 } 6382 this._DimUser.Entity = value; 6383 if ((value != null)) 6384 { 6385 value.FactClientInfos.Add(this); 6386 this._UserId = value.UserId; 6387 } 6388 else 6389 { 6390 this._UserId = default(System.Guid); 6391 } 6392 this.SendPropertyChanged("DimUser"); 6393 } 6394 } 6395 } 6396 6397 public event PropertyChangingEventHandler PropertyChanging; 6398 6399 public event PropertyChangedEventHandler PropertyChanged; 6400 6401 protected virtual void SendPropertyChanging() 6402 { 6403 if ((this.PropertyChanging != null)) 6404 { 6405 this.PropertyChanging(this, emptyChangingEventArgs); 6406 } 6407 } 6408 6409 protected virtual void SendPropertyChanged(String propertyName) 6410 { 6411 if ((this.PropertyChanged != null)) 6412 { 6413 this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); 6414 } 6415 } 6416 } 4536 6417 } 4537 6418 #pragma warning restore 1591 -
branches/HiveStatistics/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql
r9665 r12441 196 196 ALTER TABLE [SlaveStatistics] 197 197 ADD CONSTRAINT [Statistics_SlaveStatistics] FOREIGN KEY ([StatisticsId]) REFERENCES [Statistics]([StatisticsId]) 198 199 GO 200 CREATE SCHEMA [statistics] 201 GO 202 203 CREATE TABLE [statistics].[DimTime] ( 204 [Time] DATETIME NOT NULL, 205 [Hour] DATETIME NOT NULL, 206 [Day] DATE NOT NULL, 207 [Month] DATE NOT NULL, 208 [Year] DATE NOT NULL, 209 CONSTRAINT [PK_DimTime] PRIMARY KEY CLUSTERED ([Time] ASC) 210 ); 211 CREATE TABLE [statistics].[DimClient] ( 212 [Id] UNIQUEIDENTIFIER CONSTRAINT [DF_DimClient_Id] DEFAULT (newsequentialid()) NOT NULL, 213 [Name] VARCHAR (MAX) NOT NULL, 214 [ResourceId] UNIQUEIDENTIFIER NOT NULL, 215 [ExpirationTime] DATETIME NULL, 216 [ResourceGroupId] UNIQUEIDENTIFIER NULL, 217 [ResourceGroup2Id] UNIQUEIDENTIFIER NULL, 218 CONSTRAINT [PK_DimClient] PRIMARY KEY CLUSTERED ([Id] ASC) 219 ); 220 CREATE TABLE [statistics].[DimJob] ( 221 [JobId] UNIQUEIDENTIFIER NOT NULL, 222 [UserId] UNIQUEIDENTIFIER NOT NULL, 223 [JobName] VARCHAR (MAX) NOT NULL, 224 [UserName] VARCHAR (MAX) NOT NULL, 225 CONSTRAINT [PK_DimJob] PRIMARY KEY CLUSTERED ([JobId] ASC) 226 ); 227 CREATE TABLE [statistics].[DimUser] ( 228 [UserId] UNIQUEIDENTIFIER NOT NULL, 229 [Name] VARCHAR (MAX) NOT NULL, 230 CONSTRAINT [PK_DimUser] PRIMARY KEY CLUSTERED ([UserId] ASC) 231 ); 232 CREATE TABLE [statistics].[FactClientInfo] ( 233 [ClientId] UNIQUEIDENTIFIER NOT NULL, 234 [Time] DATETIME NOT NULL, 235 [UserId] UNIQUEIDENTIFIER NOT NULL, 236 [NumUsedCores] INT NOT NULL, 237 [NumTotalCores] INT NOT NULL, 238 [UsedMemory] INT NOT NULL, 239 [TotalMemory] INT NOT NULL, 240 [CpuUtilization] FLOAT (53) NOT NULL, 241 [SlaveState] VarChar(15) NOT NULL, 242 [TotalTimeIdle] FLOAT (53) NOT NULL, 243 [TotalTimeCalculating] FLOAT (53) NOT NULL, 244 [TotalTimeTransferring] FLOAT (53) NOT NULL, 245 [TotalTimeOffline] FLOAT (53) NOT NULL, 246 [TotalTimeUnavailable] FLOAT (53) NOT NULL, 247 CONSTRAINT [PK_FactClientInfo] PRIMARY KEY CLUSTERED ([ClientId] ASC, [Time] ASC, [UserId] ASC), 248 CONSTRAINT [FK_FactClientInfo_DimTime] FOREIGN KEY ([Time]) REFERENCES [statistics].[DimTime] ([Time]), 249 CONSTRAINT [FK_FactClientInfo_DimClient] FOREIGN KEY ([ClientId]) REFERENCES [statistics].[DimClient] ([Id]), 250 CONSTRAINT [FK_FactClientInfo_DimUser] FOREIGN KEY ([UserId]) REFERENCES [statistics].[DimUser] ([UserId]) 251 ); 252 CREATE TABLE [statistics].[FactTask] ( 253 [TaskId] UNIQUEIDENTIFIER NOT NULL, 254 [TotalRuntime] FLOAT (53) NOT NULL, 255 [TotalWaitingTime] FLOAT (53) NOT NULL, 256 [TotalTransferTime] FLOAT (53) NOT NULL, 257 [NumCalculationRuns] INT NOT NULL, 258 [NumRetries] INT NOT NULL, 259 [CoresRequired] INT NOT NULL, 260 [MemoryRequired] INT NOT NULL, 261 [Priority] INT NOT NULL, 262 [LastClientId] UNIQUEIDENTIFIER NOT NULL, 263 [JobId] UNIQUEIDENTIFIER NOT NULL, 264 [StartTime] DATETIME NOT NULL, 265 [EndTime] DATETIME NULL, 266 [TaskState] VARCHAR (30) NOT NULL, 267 [Exception] VARCHAR (MAX) NULL, 268 CONSTRAINT [PK_FactTask] PRIMARY KEY CLUSTERED ([TaskId] ASC), 269 CONSTRAINT [FK_FactTask_DimClient] FOREIGN KEY ([LastClientId]) REFERENCES [statistics].[DimClient] ([Id]), 270 CONSTRAINT [FK_FactTask_DimJob] FOREIGN KEY ([JobId]) REFERENCES [statistics].[DimJob] ([JobId]), 271 CONSTRAINT [FK_FactTask_DimTimeStart] FOREIGN KEY ([StartTime]) REFERENCES [statistics].[DimTime] ([Time]), 272 CONSTRAINT [FK_FactTask_DimTimeEnd] FOREIGN KEY ([EndTime]) REFERENCES [statistics].[DimTime] ([Time]) 273 ); 274 275 INSERT INTO [HeuristicLab.Hive-3.3].[statistics].[DimClient] ([Id] ,[Name] ,[ResourceId]) 276 VALUES ('00000000-0000-0000-0000-000000000000' ,'NULL' ,'00000000-0000-0000-0000-000000000000')
Note: See TracChangeset
for help on using the changeset viewer.