public void DropAndReCreateCollections()
{
_liteDatabase.DropCollection(UserAuthCol);
_liteDatabase.DropCollection(UserOAuthProviderCol);
CreateMissingCollections();
}
public void CreateDB()
{
Directory.CreateDirectory(DirectoryConstants.DatabaseDirectory);
using (var db = new LiteDatabase(DirectoryConstants.DatabaseString))
{
if (db.CollectionExists(m_CreaturesCollectionName))
{
db.DropCollection(m_CreaturesCollectionName);
}
if (db.CollectionExists(m_SavedCreaturesCollectionName))
{
db.DropCollection(m_SavedCreaturesCollectionName);
}
var collection = db.GetCollection <Creature>(m_CreaturesCollectionName);
CreateCreatures(collection);
// Setup indexes
// May not need if not querying to filter
// These caused a 3GB spike in memory usage
//collection.EnsureIndex(x => x.Rank);
//collection.EnsureIndex(x => x.Abilities);
}
}
public void DropDatabase()
{
using (var testDatabase = new LiteDatabase(AppDomain.CurrentDomain.BaseDirectory + "TestStorage.db"))
{
testDatabase.DropCollection("matches");
testDatabase.DropCollection("servers");
}
}
public LiteDBTests()
{
db = new LiteDatabase(".\\SimpleTodoList.data");
db.DropCollection("items");
db.DropCollection("lists");
lists = db.GetCollection <TodoList>("lists");
}
public virtual void TearDown()
{
using (var db = new LiteDatabase("tests.db"))
{
db.DropCollection(typeof(GameServer).Name);
db.DropCollection(typeof(GameMatch).Name);
}
}
static void Main(string[] args)
{
// Produts and Customer are other collections (not embedded document)
// you can use [BsonRef("colname")] attribute
using (var db = new LiteDatabase("LiteDB"))
{
db.DropCollection("customers");
db.DropCollection("orders");
db.DropCollection("products");
//var mapper = BsonMapper.Global;
//mapper.Entity<Order>()
// .DbRef(x => x.Customer, "customers") // 1 to 1/0 reference
// .DbRef(x => x.Products, "products");
var customers = db.GetCollection <Customer>("customers");
var products = db.GetCollection <Product>("products");
var orders = db.GetCollection <Order>("orders");
var john = new Customer {
Name = "John Doe"
};
var tv = new Product {
Id = 1, Description = "TV Sony 44\"", Price = 799
};
var iphone = new Product {
Id = 2, Description = "iPhone X", Price = 999
};
List <Product> p = new List <Product>().ToList();
p.Add(tv);
var order1 = new Order {
OrderDate = new DateTime(2017, 1, 1), Customer = john, Products = p
};
var order2 = new Order {
OrderDate = new DateTime(2017, 10, 1), Customer = john
};
customers.Insert(john);
products.Insert(new Product[] { tv, iphone });
orders.Insert(order1);
// products.Delete(1);
var result = orders
.Include(x => x.Customer)
.Include(x => x.Products).FindAll();
foreach (var o in result)
{
Console.WriteLine("name:{0}", o.Customer.Name.ToString());
foreach (Product p1 in o.Products)
{
Console.WriteLine(String.Format("{0},{1:0.00}", p1.Description, p1.Price));
}
Console.ReadLine();
}
}
}
public void Delete()
{
if (!disposed)
{
connection.DropCollection(typeof(Artist).Name);
connection.DropCollection(typeof(Album).Name);
connection.DropCollection(typeof(Song).Name);
}
}
public void BeforeEachTest()
{
Database = new LiteDatabase("test.db");
Users = Database.GetCollection <IdentityUser>("users");
Roles = Database.GetCollection <IdentityRole>("roles");
Database.DropCollection("users");
Database.DropCollection("roles");
}
public void Clear()
{
using (var db = new LiteDatabase(ConnectionString))
{
db.DropCollection(GroupsCollection);
db.DropCollection(ContactsCollection);
var groups = GetGroupsCollection(db);
groups.Insert(dbDummyData.CreateDefaultGroup());
}
}
/// <summary>
/// Retrieve the wallet contract according to transaction ID from the local data store. If not found, retrieve through the blockchain API.
/// </summary>
/// <param name="txid">Bitcoin-compatible transaction ID</param>
/// <returns>Return a wallet contract if found. Return null object if not found.</returns>
public async Task <WalletContract> FindContract(string txid)
{
WalletContract existing = null;
existing = collection.Find(c => c.ID == txid).FirstOrDefault();
if (existing != null)
{
return(existing);
}
else
{
try
{
var transaction = await insightAPI.GetTransactionInfo(txid);
var detectedWallet = new WalletContract();
detectedWallet.ID = txid;
detectedWallet.OwnerPublicAddress = transaction.GetOwnerAddress();
var op_return = transaction.GetOP_RETURN();
if (!op_return.StartsWith(DomainHex))
{
return(null);
}
var startBit = 32;
detectedWallet.NameHex = op_return.Substring(startBit, 16);
startBit += 16;
detectedWallet.TokenHex = op_return.Substring(startBit, 16);
startBit += 16;
detectedWallet.TotalSupply = BitConverterExtension.ToDecimal(op_return.Substring(startBit, 32));
startBit += 32;
detectedWallet.NoOfDecimal = ushort.Parse(op_return.Substring(startBit, 4), System.Globalization.NumberStyles.HexNumber);
startBit += 4;
detectedWallet.Conditions = op_return.Substring(startBit, 16).StringToByteArray();
startBit += 16;
detectedWallet.StartingBlock = transaction.blockheight;
detectedWallet.LastSyncedBlock = transaction.blockheight;
byte[] myByte = Encoding.ASCII.GetBytes(detectedWallet.ID);
var encrypted = NBitcoin.Crypto.Hashes.RIPEMD160(myByte, myByte.Length);
var hashID = encrypted.ByteArrayToString();
db.DropCollection($"Ledger-{hashID}");
db.DropCollection($"Account-{hashID}");
UpdateContract(detectedWallet, true);
return(detectedWallet);
}
catch (Exception)
{
return(null);
}
}
}
public override void Clear()
{
using (var db = new LiteDatabase(DatabaseName))
{
db.DropCollection(CollectionName);
}
}
public void RemoveAll()
{
using (var db = new LiteDatabase(_storageProvider.CacheDatabase))
{
db.DropCollection("tracks");
}
}
protected override void Init()
{
try {
using (LiteDatabase db = new LiteDatabase(ConnString)) {
var col = db.GetCollection <LocalMessageData>();
foreach (var item in col.FindAll().OrderBy(a => a.Timestamp))
{
if (_records.Count < NTKeyword.LocalMessageSetCapacity)
{
_records.AddFirst(item);
}
else
{
col.Delete(item.Id);
}
}
}
}
catch (Exception e) {
Logger.ErrorDebugLine(e);
try {
using (LiteDatabase db = new LiteDatabase(ConnString)) {
db.DropCollection(nameof(LocalMessageData));
}
}
catch {
}
}
foreach (var item in _records.Take(50).Reverse())
{
LocalMessageDtoSet.Add(item.ToDto());
}
}
public void ResetCollection()
{
using (var db = new LiteDatabase(Path))
{
db.DropCollection(Collection);
}
}
public void Setup()
{
var collections = _db.GetCollectionNames().ToList();
foreach (var collection in collections)
{
_db.DropCollection(collection);
}
var data = new List <BsonDocument>
{
new BsonDocument {
["_id"] = "language", ["Value"] = "C#"
},
new BsonDocument {
["_id"] = "cloud", ["Value"] = "Amazon"
},
new BsonDocument {
["_id"] = "sql", ["Value"] = "Postgres"
}
};
var dataCollection = _db.GetCollection(DataCollectionName);
dataCollection.InsertBulk(data);
dataCollection.EnsureIndex("_id", true);
}
public void Drop()
{
using (LiteDatabase _liteDb = new LiteDatabase(LiteDBLocation))
{
_liteDb.DropCollection(CollectionName);
}
}
public static void DeleteUser()
{
LiteDatabase db = new LiteDatabase(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "local_workin.db"));
db.DropCollection("user");
SecureStorageHelper.DeleteKey();
}
//Use this with caution!
//Kind of only suitable on reboot of the server
public static void clearActiveUsers()
{
if (theDB.CollectionExists(AlbotDBDatatypes.ACTIVEUSERCOLECTION))
{
theDB.DropCollection(AlbotDBDatatypes.ACTIVEUSERCOLECTION);
}
}
public void ClearAllHistory()
{
using (var db = new LiteDatabase(_path))
{
db.DropCollection("histories");
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
alarmManager = (AlarmManager)Application.Context.GetSystemService(Context.AlarmService);
// Set our view from the "main" layout resource
SetContentView(Resource.Layout.Main);
Toast.MakeText(this, "Long-press the homescreen to add the widget", ToastLength.Long).Show();
var documentspath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);
var dbpath = Path.Combine(documentspath, "pet.db");
Constant.dbpath = dbpath;
using (var db = new LiteDatabase(dbpath)) {
db.DropCollection("pet");
var data = db.GetCollection <Pet>("pet");
var pet = new Pet()
{
Name = "lala",
Status = (int)PetAction.Idle,
Hunger = 100,
Thirst = 100,
Happyness = 100,
Sickness = 100,
Sleepyness = 100,
Filthyness = 100
};
data.Insert(pet);
}
Finish();
}
public void Clear(AppSettingsType type)
{
using (var db = new LiteDatabase(_database))
{
db.DropCollection(GetTableNameFromType(type));
}
}
public static void DropTodos()
{
using (var db = new LiteDatabase(connectionString))
{
db.DropCollection("todos");
}
}
public void Cleanup()
{
using (var database = new LiteDatabase(ConfigurationProvider.DatabaseAddress))
{
database.DropCollection("Customers");
}
}
private void Form1_Load(object sender, EventArgs e)
{
_liteDatabase = new LiteDatabase(@"../../AdemOlgunerNoSQL.db");
_liteDatabase.DropCollection("Personels");
_personalList = GetlistPersonels(_liteDatabase);
PersonListBindDataGrid(_personalList);
}
public void deleteCollection(CustomCollection collection)
{
var col = db.GetCollection <CustomCollection>("customCollections");
col.Delete(Query.EQ("name", collection.name));
db.DropCollection(collection.name);
}
public void ClearAllMusic()
{
using (var db = new LiteDatabase(_path))
{
db.DropCollection("musics");
}
}
private void LoadData()
{
var filePath = HttpContext.Current.Server.MapPath(string.Format("~/Data/{0}", ConfigurationHelper.DataFile));
var list = ReadDataHelper.Read(filePath);
var sanityList = list.Where(x => !string.IsNullOrEmpty(x.Documento)).ToList();
var distinctItems = sanityList.Distinct(new DistinctItemComparer()).ToList();
var databasePath = HttpContext.Current.Server.MapPath(string.Format("~/Data/{0}", ConfigurationHelper.DatabaseFile));
// Open database (or create if not exits)
using (var db = new LiteDatabase(databasePath))
{
// Get customer collection
var customers = db.GetCollection <AfiliadoModel>("customers");
if (customers.Count() > 0)
{
db.DropCollection("customers");
customers.DropIndex("Documento");
}
// Inserting a high volume of documents (Id will be auto-incremented)
customers.InsertBulk(distinctItems);
// Index document using a document property
customers.EnsureIndex(x => x.Documento);
}
}
public void NewGame()
{
var settings = new EngineSettings {
Password = "", Filename = "./Database.db"
};
var db = new LiteEngine(settings);
if (db != null && liteDB == null)
{
liteDB = new LiteDatabase(db);
}
Systems = new List <SolarSystem>
{
NewSystem()
};
try
{
liteDB.DropCollection("systems");
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
liteDB.GetCollection <SolarSystem>("systems").Insert(Systems);
//LoadGame();
//col.EnsureIndex(x => x.Id); //sets ID to track
}
public void CleanCollection(string collectionName)
{
using (var db = new LiteDatabase(_dbPath))
{
db.DropCollection(collectionName);
}
}
public void SeedDB()
{
using (var db = new LiteDatabase(Constants.DB_NAME))
{
//clean up
IEnumerable <string> collectionNames = db.GetCollectionNames().ToList();
foreach (string collectionName in collectionNames)
{
db.DropCollection(collectionName);
}
}
//setup test data
Employee nextMgr = new Employee()
{
Id = Guid.Empty
};
for (int i = 0; i < 99; i++)
{
FakeName fname = GetAName();
DateTime onboardDate = DateTime.Now.AddMonths(random.Next(-100, -12));
DateTime recentPerfReviewDate = new DateTime(DateTime.Now.Year - 1, onboardDate.Month, 1);
Employee theNextMgr = EmployeeFactory.CreateEmployee(fname.FirstName, fname.LastName, (Gender)GetValue(genders), fname.Email, nextMgr, (Title)GetValue(titles), (Level)GetValue(levels), random.Next(50000, 200000), random.Next(0, 10000), onboardDate);
HistoryFactory.CreateHistory(theNextMgr, nextMgr, (Title)GetValue(titles), (Level)GetValue(levels), random.Next(50000, 200000), random.Next(0, 10000), ActionType.ANNUAL_PERFORMANCE_REVIEW, recentPerfReviewDate);
nextMgr = theNextMgr;
}
}
public void DropCollection_Test()
{
using (var db = new LiteDatabase(new MemoryStream()))
{
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 void ShrinkDatabaseTest_Test()
{
using (var file = new TempFile())
using (var db = new LiteDatabase(file.Filename))
{
var col = db.GetCollection<LargeDoc>("col");
col.Insert(GetDocs(1, 10000));
db.DropCollection("col");
// full disk usage
var size = file.Size;
var r = db.Shrink();
// only header page
Assert.AreEqual(BasePage.PAGE_SIZE, size - r);
}
}
private void Setup()
{
using (var db = new LiteDatabase(_filename))
{
db.DropCollection("targets");
for (var i = 0; i < 1000; i++)
{
db.GetCollection<Target>("targets").Insert(this.CreateTarget());
}
}
}
