private async Task CreateAndPopulateTableWithSimpleDataTypes()
{
var query = "CREATE OR REPLACE TABLE DEMO_DB.PUBLIC.DATATYPES_SIMPLE " +
"(ID INT, SomeInt INT, SomeFloat FLOAT, SomeVarchar VARCHAR, SomeBoolean BOOLEAN, SomeBinary BINARY);";
var result = await _snowflakeClient.ExecuteScalarAsync(query);
var insertQuery1 = "INSERT INTO DEMO_DB.PUBLIC.DATATYPES_SIMPLE (ID, SomeInt, SomeFloat, SomeVarchar, SomeBoolean, SomeBinary) " +
"SELECT 1, 1, 2.5, 'some-text', true, to_binary(hex_encode('wow'));";
var insertQuery2 = "INSERT INTO DEMO_DB.PUBLIC.DATATYPES_SIMPLE (ID, SomeInt, SomeFloat, SomeVarchar, SomeBoolean, SomeBinary) " +
"SELECT 2, 0, 777.0, '', false, null;";
var insertQuery3 = "INSERT INTO DEMO_DB.PUBLIC.DATATYPES_SIMPLE (ID, SomeInt, SomeFloat, SomeVarchar, SomeBoolean, SomeBinary) " +
"SELECT 3, -1, -2.5, 'some-text\r\n with rn', null, to_binary(hex_encode('wow'), 'UTF-8');";
var insertQuery4 = "INSERT INTO DEMO_DB.PUBLIC.DATATYPES_SIMPLE (ID, SomeInt, SomeFloat, SomeVarchar, SomeBoolean, SomeBinary) " +
"SELECT 4, null, null, null, null, null;";
var insertion1 = await _snowflakeClient.ExecuteAsync(insertQuery1);
var insertion2 = await _snowflakeClient.ExecuteAsync(insertQuery2);
var insertion3 = await _snowflakeClient.ExecuteAsync(insertQuery3);
var insertion4 = await _snowflakeClient.ExecuteAsync(insertQuery4);
}
public async Task Execute()
{
// todo: do temporary insert to get affected rows > 0
long result = await _snowflakeClient.ExecuteAsync("SELECT 1;");
Assert.IsTrue(result == -1);
}
