public void ConfigureServices(IServiceCollection services)
{
var cfgBuilder = new ConfigurationBuilder().AddJsonFile("appsettings.json", false);
var config = cfgBuilder.Build();
var dbName = "data/internal.litedb.db";
var database = new LiteDatabase(dbName);
var repository = new LiteDbRepository(database);
services.AddSingleton <IConfiguration>(config);
services.AddSingleton <IRepository>(repository);
services.AddLogging(options => options
.AddConfiguration(config)
.AddDebug()
.AddReConsole()
.AddFile("logs/app_{Date}.log")
);
services.AddScoped(typeof(IPluginConfiguration <>), typeof(PluginConfiguration <>));
services.AddScoped(typeof(IPluginRepository <>), typeof(PluginRepository <>));
services.AddScoped <IMessageChainFormatter, HyperCodeFormatter>();
services.AddScoped <IMessageChainParser, HyperCodeParser>();
services.AddHangfire();
services.AddDistributedMemoryCache();
services.AddBots();
services.AddClients(config);
services.AddUnits();
services.AddAttachments();
services.AddAuthorization();
services.AddBlacklist();
}
public async Task <BoxViewModel> Load(string uri)
{
var box = GetBox(uri);
if (box.Loaded)
{
return(box);
}
var fi = new FileInfo(uri);
if (!fi.Exists)
{
return(box);
}
box.Loaded = true;
box.Title = fi.Name;
var repo = new LiteDbRepository(uri);
await box.Load(repo);
box.Connect(repo);
return(box);
}
private async Task Export(Box box, string fileName)
{
var kamFileName = fileName + EXT_KAM;
using (var repo = new LiteDbRepository(kamFileName))
{
foreach (var brd in box.Boards)
{
await repo.CreateOrUpdateBoard(brd);
foreach (var col in box.Columns)
{
await repo.CreateOrUpdateColumn(col);
}
foreach (var row in box.Rows)
{
await repo.CreateOrUpdateRow(row);
}
foreach (var iss in box.Cards)
{
await repo.CreateOrUpdateCard(iss);
}
}
}
}
/// <summary>
/// Start of main program.
/// </summary>
/// <returns>Task.</returns>
private static async Task Main()
{
using LiteDbRepository db = new LiteDbRepository(@"c:\code\Data.LiteDB");
var updater = new NasdaqDbUpdater(db.Stocks);
await updater.Update().ConfigureAwait(false);
}
public void ConfigureServices(IServiceCollection services)
{
IConfigurationBuilder cfgBuilder = new ConfigurationBuilder().AddJsonFile("appsettings.json", false);
IConfigurationRoot config = cfgBuilder.Build();
LiteDatabase database = new LiteDatabase("data/internal.db");
LiteDbRepository repository = new LiteDbRepository(database);
services.AddSingleton <IConfiguration>(config);
services.AddSingleton <IRepository>(repository);
services.AddLogging(options => options
.AddConfiguration(config)
.AddDebug()
.AddReConsole()
.AddFile("logs/app_{Date}.log", minimumLevel: LogLevel.Information)
.SetMinimumLevel(LogLevel.Trace)
);
services.AddScoped(typeof(IPluginConfiguration <>), typeof(PluginConfiguration <>));
services.AddScoped(typeof(IPluginRepository <>), typeof(PluginRepository <>));
services.AddScoped <IMessageChainFormatter, HyperCodeFormatter>();
services.AddScoped <IMessageChainParser, HyperCodeParser>();
services.AddDistributedMemoryCache();
services.AddBots();
services.AddClients(config);
services.AddUnits();
services.AddAttachments();
services.AddAuthorization();
services.AddBlacklist();
}
public async Task Update()
{
var name = GetCurrentMethodName();
var dbName = $"testdb-{name}-{DateTime.UtcNow.ToString("yyyy-mm-dd_hh-mm-dd-fff")}.db";
var entities = new[] {
new TestDomainEntity {
Id = "1", Value = "1"
},
new TestDomainEntity {
Id = "2", Value = "2"
},
new TestDomainEntity {
Id = "3", Value = "2"
},
};
using (var db = new LiteDatabase(dbName))
{
db.GetCollection <TestDomainEntity>().Insert(entities);
}
var lr = new LiteDbRepository <TestDomainEntity>(dbName);
var toUpdate = new TestDomainEntity {
Id = "1", Value = "new Value"
};
var e = await lr.Update(toUpdate);
e.ShouldBe(toUpdate);
using (var db = new LiteDatabase(dbName))
{
var e1 = db.GetCollection <TestDomainEntity>().FindById(toUpdate.Id.ToString());
e1.Value.ShouldBe(toUpdate.Value);
}
}
public async Task GetById()
{
var name = GetCurrentMethodName();
var dbName = $"testdb-{name}-{DateTime.UtcNow.ToString("yyyy-mm-dd_hh-mm-dd-fff")}.db";
var entities = new[] {
new TestDomainEntity {
Id = "1", Value = "1"
},
new TestDomainEntity {
Id = "2", Value = "2"
},
new TestDomainEntity {
Id = "3", Value = "2"
},
};
using (var db = new LiteDatabase(dbName))
{
db.GetCollection <TestDomainEntity>().Insert(entities);
}
var lr = new LiteDbRepository <TestDomainEntity>(dbName);
var expElem = entities.ElementAt(1);
var e = await lr.GetById(expElem.Id);
e.Value.ShouldBe(expElem.Value);
}
public async Task NotInitializedAsync()
{
var localRepository = new LiteDbRepository <string, LiteDbItem>(null, new LiteDbRepositoryOptions
{
ConnectionString = GetTempDbName()
});
localRepository.IsInitialized.Should().BeTrue();
var item = await localRepository.InsertAsync(new LiteDbItem());
item.Should().NotBeNull();
}
public async Task Insert()
{
var name = GetCurrentMethodName();
var dbName = $"testdb-{name}-{DateTime.UtcNow.ToString("yyyy-mm-dd_hh-mm-dd-fff")}.db";
var lr = new LiteDbRepository <TestDomainEntity>(dbName);
var expValue = "my special value";
var data = new TestDomainEntity
{
Value = expValue
};
var dbRes = await lr.Insert(data);
dbRes.Id.ToString().ShouldNotBeNullOrEmpty();
dbRes.Value.ShouldBe(expValue);
dbRes.ShouldBe(data);
}
public async Task GetAll()
{
var name = GetCurrentMethodName();
var dbName = $"testdb-{name}-{DateTime.UtcNow.ToString("yyyy-mm-dd_hh-mm-dd-fff")}.db";
var entities = new[] {
new TestDomainEntity {
Id = "1", Value = "1"
},
new TestDomainEntity {
Id = "2", Value = "2"
},
new TestDomainEntity {
Id = "3", Value = "2"
},
};
using (var db = new LiteDatabase(dbName))
{
db.GetCollection <TestDomainEntity>().Insert(entities);
}
var lr = new LiteDbRepository <TestDomainEntity>(dbName);
var all = await lr.GetAll(null);
all.Count().ShouldBe(entities.Length);
foreach (var e in entities)
{
all.Any(x => x.Value == e.Value).ShouldBeTrue();
}
var q = $"{nameof(TestDomainEntity.Value)} == 2";
var p = new Pagination <TestDomainEntity>(q);
var allFiltered = await lr.GetAll(p);
allFiltered.Count().ShouldBe(2);
foreach (var e in entities)
{
allFiltered.All(x => x.Value == "2").ShouldBeTrue();
}
}
public ProfilesController(LiteDbRepository repository)
{
this.repository = repository;
}
