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); }