public void SQLiteRegistryInstantiation_InitializesDbSuccessfully() { //Arrange var(dbFile, path, fileName) = SetupTempDb(); //Act var sqliteReg = new SQLiteRegistry(path, fileName); //Assert var result = SQLiteDbHelper.Query(dbFile, "SELECT name FROM sqlite_master WHERE type = 'table'"); Assert.Contains(result, s => s["name"].ToString() == "Sessions"); Assert.Contains(result, s => s["name"].ToString() == "ReservedPorts"); var reservedPortsResult = SQLiteDbHelper.Query(dbFile, "SELECT COUNT(*) AS cnt FROM ReservedPorts"); Assert.Contains(reservedPortsResult, s => (long)(s["cnt"]) > 0); Assert.Contains(result, s => s["name"].ToString() == "CurrencyPairs"); var currencyPairsResult = SQLiteDbHelper.Query(dbFile, "SELECT COUNT(*) AS cnt FROM CurrencyPairs"); Assert.Contains(currencyPairsResult, s => (long)(s["cnt"]) > 0); TearDownTempDb(dbFile); }
private string GetRandomCurrencyPairName(string dbFile) { var currencyPairs = SQLiteDbHelper.Query(dbFile, "SELECT currencyPairName FROM CurrencyPairs").ToArray(); return(currencyPairs[new Random().Next(0, currencyPairs.Length - 1)]["currencyPairName"].ToString()); }