public void SqlStringBuildersShouldBeEqual()
{
SQLiteDatabase db = new SQLiteDatabase($".\\{nameof(SqlStringBuildersShouldBeEqual)}", nameof(SqlStringBuildersShouldBeEqual));
string name = 8.RandomLetters();
TimeSpan elapsed = Timed.Execution(() =>
{
SqlStringBuilder one = TestTableQuery.Where(c => c.Name == name).ToSqlStringBuilder(db);
SqlStringBuilder two = TestTableQuery.Where(c => c.Name == name).ToSqlStringBuilder(db);
SqlStringBuilder three = TestTableQuery.Where(c => c.Name == "something else").ToSqlStringBuilder(db);
Expect.IsTrue(one.EqualTo(two, db));
Expect.IsFalse(one.EqualTo(three, db));
});
OutLineFormat("Operation took: {0}", elapsed.ToString());
}
public void ApplicationRegistryRepositoryGetOneUserShouldHaveNoOrganization()
{
TimeSpan elapsed = Timed.Execution(() =>
{
ApplicationRegistrationRepository repo = new ApplicationRegistrationRepository();
repo.Database = new SQLiteDatabase($"{nameof(ApplicationRegistryRepositoryGetOneUserShouldHaveNoOrganization)}", nameof(ApplicationRegistryRepositoryGetOneUserShouldHaveNoOrganization));
var user = repo.GetOneUserWhere(c => c.UserName == "bryan");
Expect.IsNotNull(user);
Expect.AreEqual(0, user.Organizations.Count);
Expect.IsGreaterThan(user.Id, 0);
OutLine(user.PropertiesToString(), ConsoleColor.Cyan);
repo.Delete(user);
user = repo.Retrieve <ApplicationRegistration.User>(user.Id);
Expect.IsNull(user);
});
OutLine(elapsed.ToString(), ConsoleColor.Cyan);
}