Exemplo n.º 1
0
        public Scalar()
        {
            cli = new JarvisClient(Configurations.TestDbLocation);

            //Because this is highly dependant on checking string validity, we're going to go ahead and truncate the test table here
            cli.ExecuteNonQuery("delete from ScalarTester").GetAwaiter().GetResult();

            //We're going to put known test data into the table
            cli.ExecuteNonQuery("insert into ScalarTester (TextColumn, IntegerColumn, DateColumn, FloatColumn) values ('testData', 123, '1/1/2021', 12.23)").GetAwaiter().GetResult();
        }
        public async Task NQ_Returns_Neg1_On_Single_Record_Select()
        {
            var result = await cli.ExecuteNonQuery("select * from scalartester limit 1");

            Assert.IsTrue(result == -1);
        }