Changeset 2525 for trunk/sources
- Timestamp:
- 11/23/09 16:23:44 (15 years ago)
- Location:
- trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs
r2452 r2525 160 160 161 161 public void PersistModel(IModel model) { 162 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 163 Model m = (Model)model; 164 //check if model has to be updated or inserted 165 if (ctx.Models.Any(x => x.Id == model.Id)) { 166 Model orginal = ctx.Models.GetOriginalEntityState(m); 167 if (orginal == null) 168 ctx.Models.Attach(m); 169 ctx.Refresh(RefreshMode.KeepCurrentValues, m); 170 } else 171 ctx.Models.InsertOnSubmit(m); 172 ctx.SubmitChanges(); 173 } 162 Model m = (Model)model; 163 //check if model has to be updated or inserted 164 if (ctx.Models.Any(x => x.Id == model.Id)) { 165 Model orginal = ctx.Models.GetOriginalEntityState(m); 166 if (orginal == null) 167 ctx.Models.Attach(m); 168 ctx.Refresh(RefreshMode.KeepCurrentValues, m); 169 } else 170 ctx.Models.InsertOnSubmit(m); 171 ctx.SubmitChanges(); 174 172 } 175 173 … … 198 196 public void PersistProblem(Dataset dataset) { 199 197 Problem problem; 200 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 201 if (ctx.Problems.Count() != 0) 202 throw new InvalidOperationException("Could not persist dataset. A dataset is already saved in the database."); 203 problem = new Problem(dataset); 204 ctx.Problems.InsertOnSubmit(problem); 205 foreach (string variable in dataset.VariableNames) { 206 ctx.Variables.InsertOnSubmit(new Variable(variable)); 207 } 208 ctx.SubmitChanges(); 209 } 198 if (ctx.Problems.Count() != 0) 199 throw new InvalidOperationException("Could not persist dataset. A dataset is already saved in the database."); 200 problem = new Problem(dataset); 201 ctx.Problems.InsertOnSubmit(problem); 202 foreach (string variable in dataset.VariableNames) { 203 ctx.Variables.InsertOnSubmit(new Variable(variable)); 204 } 205 ctx.SubmitChanges(); 210 206 } 211 207 … … 227 223 228 224 public void PersistPredictor(IModel model, IPredictor predictor) { 229 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 230 Model m = (Model)model; 231 ctx.ModelData.DeleteAllOnSubmit(ctx.ModelData.Where(x => x.Model == m)); 232 ctx.ModelResults.DeleteAllOnSubmit(ctx.ModelResults.Where(x => x.Model == m)); 233 ctx.InputVariableResults.DeleteAllOnSubmit(ctx.InputVariableResults.Where(x => x.Model == m)); 234 ctx.InputVariables.DeleteAllOnSubmit(ctx.InputVariables.Where(x => x.Model == m)); 235 236 ctx.ModelData.InsertOnSubmit(new ModelData(m, PersistenceManager.SaveToGZip(predictor))); 237 foreach (string variableName in predictor.GetInputVariables()) 238 ctx.InputVariables.InsertOnSubmit(new InputVariable(m, (Variable)GetVariable(variableName))); 239 240 ctx.SubmitChanges(); 241 } 225 Model m = (Model)model; 226 ctx.ModelData.DeleteAllOnSubmit(ctx.ModelData.Where(x => x.Model == m)); 227 ctx.ModelResults.DeleteAllOnSubmit(ctx.ModelResults.Where(x => x.Model == m)); 228 ctx.InputVariableResults.DeleteAllOnSubmit(ctx.InputVariableResults.Where(x => x.Model == m)); 229 ctx.InputVariables.DeleteAllOnSubmit(ctx.InputVariables.Where(x => x.Model == m)); 230 231 ctx.ModelData.InsertOnSubmit(new ModelData(m, PersistenceManager.SaveToGZip(predictor))); 232 foreach (string variableName in predictor.GetInputVariables()) 233 ctx.InputVariables.InsertOnSubmit(new InputVariable(m, (Variable)GetVariable(variableName))); 234 235 ctx.SubmitChanges(); 242 236 } 243 237 … … 255 249 public IAlgorithm GetOrPersistAlgorithm(string algorithmName) { 256 250 Algorithm algorithm; 257 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 258 var algorithms = ctx.Algorithms.Where(algo => algo.Name == algorithmName); 259 if (algorithms.Count() == 0) { 260 algorithm = new Algorithm(algorithmName, ""); 261 ctx.Algorithms.InsertOnSubmit(algorithm); 262 ctx.SubmitChanges(); 263 } else if (algorithms.Count() == 1) 264 algorithm = algorithms.Single(); 265 else 266 throw new ArgumentException("Could not get Algorithm. More than one algorithm with the name " + algorithmName + " are saved in database."); 267 } 251 var algorithms = ctx.Algorithms.Where(algo => algo.Name == algorithmName); 252 if (algorithms.Count() == 0) { 253 algorithm = new Algorithm(algorithmName, ""); 254 ctx.Algorithms.InsertOnSubmit(algorithm); 255 ctx.SubmitChanges(); 256 } else if (algorithms.Count() == 1) 257 algorithm = algorithms.Single(); 258 else 259 throw new ArgumentException("Could not get Algorithm. More than one algorithm with the name " + algorithmName + " are saved in database."); 268 260 return algorithm; 269 261 } … … 271 263 public IResult GetOrPersistResult(string resultName) { 272 264 Result result; 273 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 274 var results = ctx.Results.Where(r => r.Name == resultName); 275 if (results.Count() == 0) { 276 result = new Result(resultName); 277 ctx.Results.InsertOnSubmit(result); 278 ctx.SubmitChanges(); 279 } else if (results.Count() == 1) 280 result = results.Single(); 281 else 282 throw new ArgumentException("Could not get result. More than one result with the name " + resultName + " are saved in database."); 283 } 265 var results = ctx.Results.Where(r => r.Name == resultName); 266 if (results.Count() == 0) { 267 result = new Result(resultName); 268 ctx.Results.InsertOnSubmit(result); 269 ctx.SubmitChanges(); 270 } else if (results.Count() == 1) 271 result = results.Single(); 272 else 273 throw new ArgumentException("Could not get result. More than one result with the name " + resultName + " are saved in database."); 284 274 return result; 285 275 } … … 287 277 public IMetaData GetOrPersistMetaData(string metaDataName) { 288 278 MetaData metadata; 289 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 290 var md = ctx.MetaData.Where(r => r.Name == metaDataName); 291 if (md.Count() == 0) { 292 metadata = new MetaData(metaDataName); 293 ctx.MetaData.InsertOnSubmit(metadata); 294 ctx.SubmitChanges(); 295 } else if (md.Count() == 1) 296 metadata = md.Single(); 297 else 298 throw new ArgumentException("Could not get metadata. More than one metadata with the name " + metaDataName + " are saved in database."); 299 } 279 var md = ctx.MetaData.Where(r => r.Name == metaDataName); 280 if (md.Count() == 0) { 281 metadata = new MetaData(metaDataName); 282 ctx.MetaData.InsertOnSubmit(metadata); 283 ctx.SubmitChanges(); 284 } else if (md.Count() == 1) 285 metadata = md.Single(); 286 else 287 throw new ArgumentException("Could not get metadata. More than one metadata with the name " + metaDataName + " are saved in database."); 300 288 return metadata; 301 289 } … … 318 306 319 307 public void PersistModelResults(IModel model, IEnumerable<IModelResult> modelResults) { 320 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 321 ctx.ModelResults.DeleteAllOnSubmit(GetModelResults(model).Cast<ModelResult>()); 322 ctx.ModelResults.InsertAllOnSubmit(modelResults.Cast<ModelResult>()); 323 ctx.SubmitChanges(); 324 } 308 ctx.ModelResults.DeleteAllOnSubmit(GetModelResults(model).Cast<ModelResult>()); 309 ctx.ModelResults.InsertAllOnSubmit(modelResults.Cast<ModelResult>()); 310 ctx.SubmitChanges(); 325 311 } 326 312 … … 337 323 338 324 public void PersistInputVariableResults(IModel model, IEnumerable<IInputVariableResult> inputVariableResults) { 339 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 340 ctx.InputVariableResults.DeleteAllOnSubmit(GetInputVariableResults(model).Cast<InputVariableResult>()); 341 ctx.InputVariableResults.InsertAllOnSubmit(inputVariableResults.Cast<InputVariableResult>()); 342 ctx.SubmitChanges(); 343 } 325 ctx.InputVariableResults.DeleteAllOnSubmit(GetInputVariableResults(model).Cast<InputVariableResult>()); 326 ctx.InputVariableResults.InsertAllOnSubmit(inputVariableResults.Cast<InputVariableResult>()); 327 ctx.SubmitChanges(); 344 328 } 345 329 … … 351 335 352 336 public void PersistModelMetaData(IModel model, IEnumerable<IModelMetaData> modelMetaData) { 353 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 354 ctx.ModelMetaData.DeleteAllOnSubmit(GetModelMetaData(model).Cast<ModelMetaData>()); 355 ctx.ModelMetaData.InsertAllOnSubmit(modelMetaData.Cast<ModelMetaData>()); 356 ctx.SubmitChanges(); 357 } 337 ctx.ModelMetaData.DeleteAllOnSubmit(GetModelMetaData(model).Cast<ModelMetaData>()); 338 ctx.ModelMetaData.InsertAllOnSubmit(modelMetaData.Cast<ModelMetaData>()); 339 ctx.SubmitChanges(); 358 340 } 359 341 … … 366 348 public IModel Persist(HeuristicLab.Modeling.IAnalyzerModel model, string algorithmName, string algorithmDescription) { 367 349 Algorithm algorithm = (Algorithm)GetOrPersistAlgorithm(algorithmName); 368 Variable targetVariable = (Variable) GetVariable(model.TargetVariable);350 Variable targetVariable = (Variable) GetVariable(model.TargetVariable); 369 351 Model m = (Model)CreateModel(null, model.Type, algorithm, targetVariable, model.TrainingSamplesStart, model.TrainingSamplesEnd, 370 352 model.ValidationSamplesStart, model.ValidationSamplesEnd, model.TestSamplesStart, model.TestSamplesEnd); 371 372 using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) { 373 ctx.Models.InsertOnSubmit(m); 374 ctx.SubmitChanges(); 375 ctx.ModelData.InsertOnSubmit(new ModelData(m, PersistenceManager.SaveToGZip(model.Predictor))); 376 foreach (string variableName in model.Predictor.GetInputVariables()) 377 ctx.InputVariables.InsertOnSubmit(new InputVariable(m, (Variable)GetVariable(variableName))); 378 379 foreach (KeyValuePair<string, double> pair in model.MetaData) { 380 MetaData metaData = (MetaData)GetOrPersistMetaData(pair.Key); 381 ctx.ModelMetaData.InsertOnSubmit(new ModelMetaData(m, metaData, pair.Value)); 353 ctx.Models.InsertOnSubmit(m); 354 ctx.SubmitChanges(); 355 ctx.ModelData.InsertOnSubmit(new ModelData(m, PersistenceManager.SaveToGZip(model.Predictor))); 356 357 foreach (string variableName in model.Predictor.GetInputVariables()) 358 ctx.InputVariables.InsertOnSubmit(new InputVariable(m, (Variable)GetVariable(variableName))); 359 360 foreach (KeyValuePair<string, double> pair in model.MetaData) { 361 MetaData metaData = (MetaData)GetOrPersistMetaData(pair.Key); 362 ctx.ModelMetaData.InsertOnSubmit(new ModelMetaData(m, metaData, pair.Value)); 363 } 364 365 foreach (KeyValuePair<ModelingResult, double> pair in model.Results) { 366 Result result = (Result)GetOrPersistResult(pair.Key.ToString()); 367 ctx.ModelResults.InsertOnSubmit(new ModelResult(m, result, pair.Value)); 368 } 369 370 foreach (InputVariable variable in ctx.InputVariables.Where(iv => iv.Model == m)) { 371 foreach (KeyValuePair<ModelingResult, double> variableResult in model.GetVariableResults(variable.Variable.Name)) { 372 Result result = (Result)GetOrPersistResult(variableResult.Key.ToString()); 373 ctx.InputVariableResults.InsertOnSubmit(new InputVariableResult(variable, result, variableResult.Value)); 382 374 } 383 384 foreach (KeyValuePair<ModelingResult, double> pair in model.Results) { 385 Result result = (Result)GetOrPersistResult(pair.Key.ToString()); 386 ctx.ModelResults.InsertOnSubmit(new ModelResult(m, result, pair.Value)); 387 } 388 389 foreach (InputVariable variable in ctx.InputVariables.Where(iv => iv.Model == m)) { 390 foreach (KeyValuePair<ModelingResult, double> variableResult in model.GetVariableResults(variable.Variable.Name)) { 391 Result result = (Result)GetOrPersistResult(variableResult.Key.ToString()); 392 ctx.InputVariableResults.InsertOnSubmit(new InputVariableResult(variable, result, variableResult.Value)); 393 } 394 } 395 396 ctx.SubmitChanges(); 397 } 375 } 376 ctx.SubmitChanges(); 398 377 399 378 //if connected to database return inserted model -
trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/PredictorPersister.cs
r2482 r2525 37 37 DatabaseService db = new DatabaseService(database); 38 38 db.Connect(); 39 if (db.GetDataset() == null) 40 db.PersistProblem(ds); 39 Dataset temp = db.GetDataset(); 40 if(temp == null) 41 db.PersistProblem(ds); 41 42 42 IAnalyzerModel model = new AnalyzerModel(); 43 IAnalyzerModel model = new AnalyzerModel(); 43 44 DefaultModelAnalyzerOperators.PopulateAnalyzerModel(scope, model, modelType); 44 45 45 db.Persist(model, algorithm, algorithm); 46 46 db.Disconnect(); 47 47 48 48 49 return null;
Note: See TracChangeset
for help on using the changeset viewer.