private void ConfigureBackend(IAppBuilder app)
{
var appDataPath = Path.Combine(AppLocalRootPath, "App_Data"); // HostingEnvironment.MapPath("~/App_Data");
var dbPath = Path.Combine(appDataPath, "Pim.db");
var database = NoteLiteDb.GetNoteDatabase($"Filename={dbPath}; Upgrade=true; Initial Size=5MB; Password=;");
AuthDatabase = database;
IdentityDatabaseContextFactory = new IdentityDatabaseContextFactory(AuthDatabase);
var storage = NoteStorage.CreateStandard(database, appDataPath, true);
storage.Open();
var languageSetting = ConfigurationManager.AppSettings[AppSettingKeyFulltextIndexLanguages];
if (string.IsNullOrWhiteSpace(languageSetting))
{
languageSetting = "English,Russian";
}
var stemmerNames = languageSetting.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToCaseInsensitiveSet();
var redundantIndexes = storage.ActiveIndexNames.Where(name => !stemmerNames.Contains(name));
foreach (var redundantIndexName in redundantIndexes)
{
Log.InfoFormat("Removing FT index {0}", redundantIndexName);
storage.RemoveIndex(redundantIndexName);
}
stemmerNames.ExceptWith(storage.ActiveIndexNames);
storage.OpenOrCreateIndexes(stemmerNames);
storage.MultiIndex.UseFuzzySearch = true;
Storage = storage;
var builder = new ContainerBuilder();
builder.RegisterControllers(typeof(Startup).Assembly);
builder.Register(context => Storage).SingleInstance();
//builder.RegisterType<HomeController>();
//builder.RegisterType<ViewEditController>();
//builder.RegisterType<SearchController>();
builder.Register(c => IdentityDatabaseContextFactory).SingleInstance();
Container = builder.Build();
app.UseAutofacMiddleware(Container);
DependencyResolver.SetResolver(new AutofacDependencyResolver(Container));
app.UseAutofacMvc();
}
public void SetUp()
{
_rootStorageDirectory = Path.Combine(TestContext.CurrentContext.WorkDirectory, "IndexedStorage");
if (Directory.Exists(_rootStorageDirectory))
{
Directory.Delete(_rootStorageDirectory, true);
}
_indexedStorage = NoteStorage.CreateStandard(_rootStorageDirectory);
_indexedStorage.Open();
_indexedStorage.OpenOrCreateIndexes(new [] { "English", "Russian" });
_testNotes = new[]
{
Note.Create("Evaluating Evernote\r\n GMBH encryption support. interface is not too bad, local supported, no symmetric encryption, no fulltext search."),
Note.Create("Evaluating OneNote\r\n interface is not too bad, local supported, no symmetric key encryption, no fulltext search, although claimed."),
Note.Create("Government is the great fiction\r\n through which everybody endeavors to live at the expense of everybody else"),
Note.Create("Stuff location: router \r\n placed into a big box in the garage near the top of the pile, box marked \"electronics\""),
Note.Create("unbalanced signal converter \r\n in a marked plastic box in laundry"),
Note.Create("blog post \r\n publishing tomorrow "),
Note.Create("Quote from Bastiat\r\nFor now, as formerly, every one is, more or less, for profiting by the labors of others. No one would dare to profess such a sentiment; he even hides it from himself; and then what is done? A medium is thought of; Government is applied to, and every class in its turn comes to it, and says, \"You, who can take justifiably and honestly, take from the public, and we will partake."),
Note.Create("Egg \r\n tolerated well, but high in cholesterol if you beleive it"),
Note.Create("Masha \r\n Maria Мария"),
Note.Create("Quote: Mises on education\r\nIt is often asserted that the poor man's failure in the competition of the market is caused by his lack of education. Equality of opportunity, it is said, could be provided only by making education at every level accessible to all. There prevails today the tendency to reduce all differences among various peoples to their education and to deny the existence of inborn inequalities in intellect, will power, and character. It is not generally realized that education can never be more than indoctrination with theories and ideas already developed. Education, whatever benefits it may confer, is transmission of traditional doctrines and valuations; it is by necessity conservative. It produces imitation and routine, not improvement and progress. Innovators and creative geniuses cannot be reared in schools. They are precisely the men who defy what the school has taught them."),
Note.Create("Испанская «Барселона» объявила о подписании контракта с новым главным тренером Эрнесто Вальверде. Об этом сообщается в клубном Twitter в понедельник, 29 мая."),
};
for (var n = 0; n < _testNotes.Length; ++n)
{
_testNotes[n].LastUpdateTime = DateTime.Now.AddHours(n - _testNotes.Length);
_testNotes[n].CreateTime = _testNotes[n].LastUpdateTime.AddDays(-1);
}
_indexedStorage.SaveOrUpdate(_testNotes);
foreach (var note in _testNotes)
{
Assert.IsNotEmpty(note.Id);
Assert.AreEqual(1, note.Version);
}
Assert.IsTrue(_indexedStorage.WaitForFulltextBackgroundWorkToComplete(1000));
}
static void RunIntegrated()
{
Console.WriteLine("Available stemmers:");
foreach (var n in LuceneIndex.GetAvailableSnowballStemmers())
{
Console.WriteLine(n);
}
var notes = new[]
{
Note.Create("Evaluating Evernote\r\n GMBH encryption support. interface is not too bad, local supported, no symmetric encryption, no fulltext search."),
Note.Create("Evaluating OneNote\r\n interface is not too bad, local supported, no symmetric key encryption, no fulltext search, although claimed."),
Note.Create("Government is the great fiction\r\n through which everybody endeavors to live at the expense of everybody else"),
Note.Create("Stuff location: router \r\n placed into a big box in the garage near the top of the pile, box marked \"electronics\""),
Note.Create("unbalanced signal converter \r\n in a marked plastic box in laundry"),
Note.Create("blog post \r\n publishing tomorrow "),
Note.Create("Quote from Bastiat\r\nFor now, as formerly, every one is, more or less, for profiting by the labors of others. No one would dare to profess such a sentiment; he even hides it from himself; and then what is done? A medium is thought of; Government is applied to, and every class in its turn comes to it, and says, \"You, who can take justifiably and honestly, take from the public, and we will partake."),
Note.Create("Egg \r\n tolerated well, but high in cholesterol if you beleive it"),
Note.Create("Masha \r\n Maria Мария"),
Note.Create("Quote: Mises on education\r\nIt is often asserted that the poor man's failure in the competition of the market is caused by his lack of education. Equality of opportunity, it is said, could be provided only by making education at every level accessible to all. There prevails today the tendency to reduce all differences among various peoples to their education and to deny the existence of inborn inequalities in intellect, will power, and character. It is not generally realized that education can never be more than indoctrination with theories and ideas already developed. Education, whatever benefits it may confer, is transmission of traditional doctrines and valuations; it is by necessity conservative. It produces imitation and routine, not improvement and progress. Innovators and creative geniuses cannot be reared in schools. They are precisely the men who defy what the school has taught them."),
Note.Create("Испанская «Барселона» объявила о подписании контракта с новым главным тренером Эрнесто Вальверде. Об этом сообщается в клубном Twitter в понедельник, 29 мая."),
};
var storage = NoteStorage.CreateStandard(@"c:\temp\MyNotes");
storage.OpenOrCreateIndexes(new[] { "English", "Russian" });
storage.SearchEngine.UseFuzzySearch = true;
if (storage.CountAll() > 0)
{
storage.Delete(storage.GetAll().ToArray());
}
storage.SaveOrUpdate(notes);
var result1 = storage.GetTopInPeriod(null, DateTime.Now.AddSeconds(-1), 4);
var result2 = storage.GetTopInPeriod(DateTime.Now.AddSeconds(-10), null, 4);
// problem in the past: did not find 'erasing' by 'erase'; but 'erasure' works
bool finish;
do
{
Console.WriteLine();
Console.Write("Your query: ");
var queryText = Console.ReadLine();
finish = string.IsNullOrEmpty(queryText);
if (!finish)
{
var result = storage.Search(queryText, 100);
Console.WriteLine($"Found {result.Count} items");
foreach (var hit in result)
{
Console.WriteLine($"\t {hit.Id} - {hit.Name};");
var loaded = storage.GetExisting(hit);
if (loaded == null)
{
Console.WriteLine($"Note {hit.Id} not found in database");
}
}
}
}while (!finish);
storage.Dispose();
}