public void ExportImportTest() { EFDbConnect EFDbConnectDemoBase = CreateDemoBase("Save_test.db"); ILogger ILoggerMock = Mock.Of<ILogger>(); // Export DiskOperation ExportIO = new DiskOperation(ILoggerMock,new SQLitePlatformWin32(),EFDbConnectDemoBase); string exportpath = PathToDb("export.db"); ExportIO.ExportLearningItem(exportpath, EFDbConnectDemoBase.Table<LearningItem>().Where(x=>x.Name == "First").First().id , false); EFDbConnect dbConnect = new EFDbConnect(new SQLitePlatformWin32(), exportpath,false); QuantityTest(dbConnect); dbConnect.Close(); EFDbConnectDemoBase.Close(); // Import to empty db EFDbConnect DestConnect = RecreateDB("dest.db"); DiskOperation ImportIO = new DiskOperation(ILoggerMock,new SQLitePlatformWin32(),DestConnect); ImportIO.ImportLearningItem(exportpath, false); QuantityTest(DestConnect); // Update DestConnect.Delete(DestConnect.Table<Subtitles>().First()); DestConnect.Delete(DestConnect.Table<AudioTrack>().First()); DestConnect.Delete(DestConnect.Table<TranslationOfWord>().First()); Assert.IsTrue(DestConnect.Table<Subtitles>().Count() == 1); Assert.IsTrue(DestConnect.Table<AudioTrack>().Count() == 1); Assert.IsTrue(DestConnect.Table<TranslationOfWord>().Count() == 1); ImportIO.ImportLearningItem(exportpath, false); QuantityTest(DestConnect); DestConnect.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { DiskOperation diskop = new DiskOperation(Mvx.Resolve<ILogger>(),new SQLitePlatformWin32(),Mvx.Resolve<EFDbConnect>()); diskop.ExportLearningItem(Path.Combine(FileService.GetPathToApplicationDataFolder(), "upload.db"), new UUID("9a0d3d5b-2600-d043-baa8-bfe8cece6afb"), true); //Disk_Operations io = new Disk_Operations(); // io.Backup(@"C:\tmp\backup\bkp.xml"); /* Assembly asm = Assembly.GetExecutingAssembly(); foreach(Type type in asm.GetTypes()) { int i = 9; } var lst = asm.GetTypes().Where(x => x.CustomAttributes.Any(m => m.AttributeType == typeof(System.ComponentModel.DataAnnotations.Schema.TableAttribute))); */ //System.Type[] types = GetTypesInNamespace(Assembly.Get) //string url = @"http://www.youtube.com/watch?v=wyx6JDQCslE&list=PLirAqAtl_h2pRAtj2DgTa3uWIZ3-0LKTA&index=127"; //string url = @"http://www.youtube.com/watch?v=3Q2bkCYjrHk"; //string url = @"http://www.youtube.com/watch?v=FG1NrQYXjLU"; //var lst = API.YoutubeDownloader.GetVideoInfo(url); //bool isExternalAudio; //string ExternalAudioPath; //System.Threading.Tasks.Task.Run(() => // API.YoutubeDownloader.Download(lst, lst.OrderByDescending(x=>x.Resolution).First(), @"C:\tmp\1\video.mp4",out isExternalAudio,out ExternalAudioPath) //); //Model.Language en = ViewModelLocator.Instance.Languages.First(x => x.Code == "en"); //Model.Language ru = ViewModelLocator.Instance.Languages.First(x => x.Code == "ru"); //var lst = API.LanguageServices.GetServices(en,ru); }
public void ExportTest() { EFDbConnect EFDbConnectDemoBase = CreateDemoBase("Save_test.db"); ILogger ILoggerMock = Mock.Of<ILogger>(); DiskOperation diskop = new DiskOperation(ILoggerMock,new SQLitePlatformWin32(),EFDbConnectDemoBase); string path = PathToDb("upload.db"); diskop.ExportLearningItem(path, EFDbConnectDemoBase.Table<LearningItem>().Where(x=>x.Name == "First").First().id , true); EFDbConnect dbConnect = new EFDbConnect(new SQLitePlatformWin32(), path,false); Assert.IsTrue(dbConnect.Table<LearningItem>().Count() == 1); Assert.IsTrue(dbConnect.Table<Subtitles>().Count() == 2); Assert.IsTrue(dbConnect.Table<SubtitleItem>().Count() == 4); Assert.IsTrue(dbConnect.Table<SubtitleItem.Word>().Count() == 2); Assert.IsTrue(dbConnect.Table<WordOfDictionary>().Count() == 2); Assert.IsTrue(dbConnect.Table<TranslationOfWord>().Count() == 2); Assert.IsTrue(dbConnect.Table<Dictionary>().Count() == 1); Assert.IsTrue(dbConnect.Table<AudioTrack>().Count() == 2); Assert.IsTrue(dbConnect.Table<FrequencyDictionary>().Count() == 1); Assert.IsTrue(dbConnect.Table<FrequencyDictionary.Item>().Count() == 2); dbConnect.Close(); }