private void Import_OnClick(object sender, RoutedEventArgs e) { var openFileDialog = new OpenFileDialog { Filter = "Файлы БД программы (USD.db)|USD.db|Все файлы БД (*.db)|*.db|Все файлы (*.*)|*.*" }; if (openFileDialog.ShowDialog() == true) { using (var db = new LiteDatabase(DirectoryHelper.GetDataDirectory() + Settings.Default.LiteDbFileName)) { using (var db1 = new LiteDatabase(openFileDialog.FileName)) { if (!db1.CollectionExists("screenings")) { MessageBox.Show( "Не подходящая база данных. Используйте базу данных, только от этой программы.", "УЗД", MessageBoxButton.OK, MessageBoxImage.Error); return; } var origCol = db.GetCollection("screenings"); var newCol = db1.GetCollection("screenings"); foreach (var source in newCol.FindAll().ToList()) { source["Id"] = null; origCol.Insert(source); } } } (DataContext as ListViewModel.ListViewModel)?.LoadData(); MessageBox.Show("Данные успешно импортированны", "УЗД", MessageBoxButton.OK, MessageBoxImage.Information); } }
public void DropCollection_Test() { using (var db = new LiteDatabase(DB.Path())) { Assert.IsFalse(db.CollectionExists("customerCollection")); var collection = db.GetCollection<Customer>("customerCollection"); collection.Insert(new Customer()); Assert.IsTrue(db.CollectionExists("customerCollection")); db.DropCollection("customerCollection"); Assert.IsFalse(db.CollectionExists("customerCollection")); } }
public Task ClearAsync() { using (var db = new LiteDB.LiteDatabase(dbPath)) if (db.CollectionExists(DataStoreCollectionName)) { db.DropCollection(DataStoreCollectionName); } return(CompletedTask); }
private static void DbMigration() { using (var db = new LiteDatabase(DirectoryHelper.GetDataDirectory() + Settings.Default.LiteDbFileName)) { if (!db.CollectionExists("screenings")) return; var col = db.GetCollection("screenings"); IEnumerable<BsonDocument> items = col.FindAll().ToList(); foreach (var item in items) { var isNeedUpdate = false; var formations = item["FocalFormations"].AsArray; foreach (var form in formations) { var size = form.AsDocument["Size"]; if (!size.IsString) { form.AsDocument.Set("Size", size.AsString); isNeedUpdate = true; } if (size.IsNull) { form.AsDocument.Set("Size", string.Empty); isNeedUpdate = true; } var cdk = form.AsDocument["CDK"]; if (cdk.AsString == "Avascular") { form.AsDocument.Set("CDK", "None"); isNeedUpdate = true; } } var cysts = item["Cysts"].AsArray; if (cysts != null) { foreach (var cyst in cysts) { var cdk = cyst.AsDocument["CDK"]; if (cdk.AsString == "Avascular") { cyst.AsDocument.Set("CDK", "None"); isNeedUpdate = true; } } } if (isNeedUpdate) { col.Update(item); } } } }