public void DbSetup() { string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), "expensemanager.db3"); if (File.Exists(dbPath)) { File.Delete(dbPath); } _repository = new RepositoryCore(new LogService()); _db = _repository.CreateDataBase(dbPath, new SQLitePlatformIOS(), true); }
public void CreateDataBase_IfDbDoesNotExist_CheckDb() { if (File.Exists(_dbPath)) { File.Delete(_dbPath); } var core = new RepositoryCore(new LogService()); core.CreateDataBase(_dbPath, new SQLitePlatformIOS(), true); Assert.IsTrue(File.Exists(_dbPath)); }
public void CreateDataBase_IfDbDoesNotExist_CheckCategoryTable() { if (File.Exists(_dbPath)) { File.Delete(_dbPath); } var core = new RepositoryCore(new LogService()); core.CreateDataBase(_dbPath, new SQLitePlatformIOS(), true); var db = new SQLiteConnection(new SQLitePlatformIOS(), _dbPath); var categories = db.Table <Category>(); Assert.IsTrue(categories.Count() > 0, "Category table hasn't been created."); }
public static void SetUpDatabase(bool deleteIfExist, bool withSeeding) { string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Personal), "expensemanager.db3"); if (File.Exists(dbPath) && deleteIfExist) { File.Delete(dbPath); } var repositoryCore = new RepositoryCore(GetLogService()); if (File.Exists(dbPath)) { repositoryCore.SetUpDataBaseConnection(dbPath, new SQLitePlatformIOS()); } else { repositoryCore.CreateDataBase(dbPath, new SQLitePlatformIOS(), withSeeding); } }