public void Constructor_existing_file_test()
        {
            var filePath = Path.Combine(TestFilesDirectory, "7wolf.cruise");

            using (var datastore = new CruiseDAL.CruiseDatastore(filePath))
            {
                ValidateDAL(datastore);
            }
        }
        public void Ctor_with_empty_path()
        {
            Action action = () =>
            {
                var db = new CruiseDAL.CruiseDatastore("");
            };

            action.Should().Throw <ArgumentException>();
        }
        private void ValidateDAL(CruiseDAL.CruiseDatastore db)
        {
            var version = db.DatabaseVersion;

            version.Should().NotBeNull();
            Version.TryParse(version, out var versionParsed).Should().BeTrue(version);

            //db.ExecuteScalar<int>("SELECT count(*) FROM MessageLog WHERE Program IS NULL or Program = '';")
            //    .Should().Be(0);

            db.ExecuteScalar <string>("SELECT Message FROM MessageLog ORDER BY RowID DESC LIMIT 1;")
            .Should().Be("File Opened");

            //var timeStamp = latestMessage.Time;
            //timeStamp.Should().NotBeNullOrWhiteSpace();
            ////assert that file opened message was within the last 30 seconds
            //DateTime.Parse(timeStamp).Subtract(DateTime.Now).TotalSeconds.Should().BeLessThan(30);
        }