public void TestRetrieveData() { var repo = new SqLiteRepository(factory); repo.SaveData(new DataEntry { Id = 101, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); repo.SaveData(new DataEntry { Id = 102, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); repo.SaveData(new DataEntry { Id = 103, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); repo.SaveData(new DataEntry { Id = 104, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); var data = repo.GetList <DataEntry>(); Assert.AreEqual(4, data.Count); var first = data.First(); Assert.AreEqual(101, first.Id); Assert.AreEqual(5, first.Password.Length); Assert.AreEqual(DateTime.Today, first.Today); Assert.AreEqual("elephant", data.Skip(2).First().Password); Assert.AreNotEqual("giraffe", data.Skip(2).First().Password); }
public void insert_with_creating_table() { ISeedRepository seedRepository = new SqLiteRepository(_connectionString); seedRepository.AddToSeedsHistory("Test", "1.0"); seedRepository.IsExistsSeedsHistory().Should().BeTrue(); seedRepository.DeleteSeedsHistory(); }
public void seeds_history_table_is_exists() { ISeedRepository seedRepository = new SqLiteRepository(_connectionString); seedRepository.CreateSeedsHistory(); seedRepository.IsExistsSeedsHistory().Should().BeTrue(); seedRepository.DeleteSeedsHistory(); }
public void get_all_seeds() { ISeedRepository seedRepository = new SqLiteRepository(_connectionString); seedRepository.AddToSeedsHistory("Test1", "1.0"); seedRepository.AddToSeedsHistory("Test2", "1.0"); seedRepository.GetSeedsHistory().Should().HaveCount(2); seedRepository.DeleteSeedsHistory(); }
static void Main(string[] args) { Console.WriteLine("OMGHAI! & Welcome to the Gilded Rose!" + Environment.NewLine); Console.WriteLine("This was today's inventory change!" + Environment.NewLine); IItemRepository repository = new SqLiteRepository(); var items = repository.GetItems(); Transaction.UpdateQuality(ref items); //TODO database.Update() --> keep separate IO & pure logic }
public void TestSaveData() { // create an instance of the repository var repo = new SqLiteRepository(factory); // save with random data repo.SaveData(new DataEntry { Id = 101, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); // recall the data var count = connection.Table <DataEntry>().Count(sc => sc.Id == 101); // perform test Assert.AreEqual(1, count); }
public void TestMultipleDataSets() { var repo = new SqLiteRepository(factory); repo.SaveData(new DataEntry { Id = 101, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); repo.SaveData(new DataEntry { Id = 102, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); var data = repo.GetList <DataEntry>(); Assert.AreEqual(2, data.Count); Assert.AreEqual(101, data.First().Id); Assert.AreEqual("paul", data.First().Username); Assert.AreEqual(102, data.Skip(1).First().Id); Assert.AreEqual("mac", data.Skip(1).First().Username); }
public void TestDeleteRecord() { var repo = new SqLiteRepository(factory); var deleteData = new DataEntry { Id = 101, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }; repo.SaveData(deleteData); repo.SaveData(new DataEntry { Id = 102, Password = "******", RandomNumber = new Random().Next(255), Today = DateTime.Today, Username = "******" }); // delete the first entry repo.Delete(deleteData); // tests var data = repo.GetList <DataEntry>(); Assert.AreEqual(1, data.Count); Assert.AreEqual("mac", data.First().Username); Assert.AreEqual(DateTime.Today, data.First().Today); }
public SqLiteRepositoryTests() { string path = Environment.GetFolderPath(Environment.SpecialFolder.Personal); var databasePath = Path.Combine(path, "MyDatabaseTest.db3"); if (File.Exists(databasePath)) { GC.Collect(); GC.WaitForPendingFinalizers(); File.Delete(databasePath); } _databaseSqLiteConnection = new SQLiteConnection(databasePath); _repository = new SqLiteRepository <User>(_databaseSqLiteConnection); var userToAdd = new Faker <User>() .StrictMode(true) .RuleFor(u => u.Id, f => f.IndexFaker) .RuleFor(u => u.Login, f => f.Person.UserName) .RuleFor(u => u.PasswordSalt, f => f.Person.UserName) .RuleFor(u => u.HashedPassword, f => f.Person.UserName) .Generate(1); _userToTest = userToAdd[0]; _repository.Add(userToAdd[0]); }
public void Run(string[] args) { for (var i = 0; i < args.Length; i++) { if (IsVersionCommand(args[i])) { CommandWasExecuted(); Console.WriteLine($"{Constants.Seeder} {Constants.Version.SeederVersion} ({Constants.SeederCore} {Constants.Version.CoreVersion})"); } if (IsProviderArgument(args[i])) { CommandWasExecuted(); Console.WriteLine($"Available providers: {string.Join(", ", Constants.Providers)}"); } // TODO: help for scripts // if(IsScriptsHelpCommand(...))... if (args[i].Equals(Constants.Command.Scripts) && (i + 1) == args.Length) { CommandWasExecuted(); Console.WriteLine("Help: TODO..."); } else if (IsScriptsCommand(args[i])) { i++; try { if (args[i++].Equals(Constants.Command.ScriptsAdd)) { CreateScript(args[i]); } } catch (IndexOutOfRangeException) { UnknownCommandInformation(); CommandWasExecuted(); } } // TODO: help for database // if(IsDatabasesHelpCommand(...))... if (args[i].Equals(Constants.Command.Database) && (i + 1) == args.Length) { CommandWasExecuted(); Console.WriteLine("Help: TODO..."); } else if (args[i++].Equals(Constants.Command.Database)) { if (args[i++].Equals(Constants.Command.DatabaseUpdate)) { if (args[i++].Equals(Constants.Command.ProviderArgument)) { var provider = args[i++]; if (provider.Equals(Constants.Provider.PostgreSql, StringComparison.InvariantCultureIgnoreCase)) { ISeedRepository seedRepository = new PostgreSqlRepository(args[i]); CommandWasExecuted(); _seeder.ExecuteChanges(seedRepository); } else if (provider.Equals(Constants.Provider.SqLite, StringComparison.InvariantCultureIgnoreCase)) { ISeedRepository seedRepository = new SqLiteRepository(args[i]); CommandWasExecuted(); _seeder.ExecuteChanges(seedRepository); } } } } } }
public void seeds_history_table_not_exists() { ISeedRepository seedRepository = new SqLiteRepository(_connectionString); seedRepository.IsExistsSeedsHistory().Should().BeFalse(); }