public void SaveNewExperiment(string dbFile, string url, string CpuName, string CpuMHz, string FPU, string Memory, string OS, string Compiler, string ProgramName, decimal BaseRefTime, decimal BaseRunTime) { using (var db = new SPECCPUDB_Mine(new LinqToDB.DataProvider.SQLite.SQLiteDataProvider(), String.Format(@"Data Source={0}", dbFile))) { long EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); if (EnvID < 0) { var newEnv = new DataModel.Environment(); newEnv.Compiler = Compiler; newEnv.CpuMHz = CpuMHz; newEnv.CpuName = CpuName; newEnv.FPU = FPU; newEnv.Memory = Memory; newEnv.OS = OS; db.Insert(newEnv); EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); } long ProgID = getProg(db, ProgramName); if (ProgID<0) { var p = new DataModel.Program(); p.Name = ProgramName; db.Insert(p); ProgID = getProg(db, ProgramName); } var expID = getExp(db, url, EnvID, ProgID, BaseRefTime, BaseRunTime); if (expID < 0) { var exp = new DataModel.Experiment(); exp.url = url; exp.EnvID = EnvID; exp.ProgID = ProgID; exp.BaseRefTime = BaseRefTime; exp.BaseRunTime = BaseRunTime; db.Insert(exp); } } }
public void SaveNewExperiment(string dbFile, string url, string CpuName, string CpuMHz, string FPU, string Memory, string OS, string Compiler, string ProgramName, decimal BaseRefTime, decimal BaseRunTime) { using (var db = new SPECCPUDB_Mine(new LinqToDB.DataProvider.SQLite.SQLiteDataProvider(), String.Format(@"Data Source={0}", dbFile))) { long EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); if (EnvID < 0) { var newEnv = new DataModel.Environment(); newEnv.Compiler = Compiler; newEnv.CpuMHz = CpuMHz; newEnv.CpuName = CpuName; newEnv.FPU = FPU; newEnv.Memory = Memory; newEnv.OS = OS; db.Insert(newEnv); EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); } long ProgID = getProg(db, ProgramName); if (ProgID < 0) { var p = new DataModel.Program(); p.Name = ProgramName; db.Insert(p); ProgID = getProg(db, ProgramName); } var expID = getExp(db, url, EnvID, ProgID, BaseRefTime, BaseRunTime); if (expID < 0) { var exp = new DataModel.Experiment(); exp.url = url; exp.EnvID = EnvID; exp.ProgID = ProgID; exp.BaseRefTime = BaseRefTime; exp.BaseRunTime = BaseRunTime; db.Insert(exp); } } }