public void CategoryRepository_Update()
{
var dbHelper = new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath());
using (var db = dbHelper.GetSqlConnection())
{
db.DeleteAll<Category>();
}
var repository = new CategoryRepository(new CategoryDataAccess(dbHelper));
var category = new Category
{
Name = "Ausgang"
};
repository.Save(category);
Assert.AreEqual(1, repository.Data.Count);
Assert.AreSame(category, repository.Data[0]);
category.Name = "newName";
repository.Save(category);
Assert.AreEqual(1, repository.Data.Count);
Assert.AreEqual("newName", repository.Data[0].Name);
}
public void RecurringTransactionRepository_Update()
{
var dbHelper = new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath());
using (var db = dbHelper.GetSqlConnection())
{
db.DeleteAll<RecurringTransaction>();
}
var repository = new RecurringTransactionRepository(new RecurringTransactionDataAccess(dbHelper));
var account = new Account
{
Name = "TestAccount"
};
var transaction = new RecurringTransaction
{
ChargedAccount = account,
Amount = 20,
AmountWithoutExchange = 20
};
repository.Save(transaction);
Assert.AreEqual(1, repository.Data.Count);
Assert.AreSame(transaction, repository.Data[0]);
transaction.Amount = 789;
repository.Save(transaction);
Assert.AreEqual(1, repository.Data.Count);
Assert.AreEqual(789, repository.Data[0].Amount);
}
public void DatabaseLogic_CreateDatabase()
{
var dbHelper = new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath());
using (var dbConn = dbHelper.GetSqlConnection())
{
var temp1 = dbConn.Table<Account>().ToList();
var temp2 = dbConn.Table<FinancialTransaction>().ToList();
var temp3 = dbConn.Table<RecurringTransaction>().ToList();
var temp4 = dbConn.Table<Category>().ToList();
}
}
public void CategoryRepositor_LoadDataFromDbThroughRepository()
{
var dbHelper = new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath());
using (var db = dbHelper.GetSqlConnection())
{
db.DeleteAll<Category>();
db.InsertWithChildren(new Category
{
Name = "Foooo"
});
}
var repository = new CategoryRepository(new CategoryDataAccess(dbHelper));
Assert.IsTrue(repository.Data.Any());
Assert.AreEqual("Foooo", repository.Data[0].Name);
}
public void RecurringTransactionRepository_LoadDataFromDbThroughRepository()
{
var dbHelper = new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath());
using (var db = dbHelper.GetSqlConnection())
{
db.DeleteAll<RecurringTransaction>();
db.InsertWithChildren(new RecurringTransaction
{
Amount = 999,
AmountWithoutExchange = 777,
ChargedAccount = new Account
{
Name = "testAccount"
}
});
}
var repository = new RecurringTransactionRepository(new RecurringTransactionDataAccess(dbHelper));
Assert.IsTrue(repository.Data.Any());
Assert.AreEqual(999, repository.Data[0].Amount);
Assert.AreEqual(777, repository.Data[0].AmountWithoutExchange);
}
public void SqlConnectionFactory_GetSqlConnectionWithParams()
{
var connection = new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath()).GetSqlConnection();
Assert.IsInstanceOfType(connection, typeof(SQLiteConnection));
}