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 void MarkSessionAsExpired(string dbFile, string accountId, int sessionId, int currencyPairId)
{
string expirationDate = DateTime.UtcNow.Subtract(new TimeSpan(0, 0, 11)).ToString("yyyy-MM-dd HH:mm:ss");
SQLiteDbHelper.NonQueryCommand(dbFile, $"UPDATE Sessions SET lastKeptAlive = '{expirationDate}' WHERE accountId='{accountId}' AND sessionId={sessionId} AND currencyPairId={currencyPairId}");
}
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());
}