public void AdvancedRecordset_AddRecordsetAsTable_ExecuteStatement_Insert()
{
var l = new List <string>();
l.Add("name");
l.Add("age");
l.Add("address_id");
var advancedRecordset = new AdvancedRecordset();
advancedRecordset.AddRecordsetAsTable(("person", l));
const string query = "INSERT OR REPLACE INTO person VALUES (1,'testName', 10, 1);";
var statements = TSQLStatementReader.ParseStatements(query);
var results = advancedRecordset.ExecuteStatement(statements[0], query);
Assert.AreEqual(1, results.Tables[0].Rows[0]["records_affected"]);
}
public void AdvancedRecordset_AddRecordsetAsTable_ExecuteStatement_Select()
{
var l = new List <string>();
l.Add("name");
l.Add("age");
l.Add("address_id");
var advancedRecordset = new AdvancedRecordset();
advancedRecordset.AddRecordsetAsTable(("person", l));
var statements = TSQLStatementReader.ParseStatements("Select * from person");
var results = advancedRecordset.ExecuteStatement(statements[0], "Select * from person");
Assert.AreEqual("name", results.Tables[0].Columns[1].ColumnName);
Assert.AreEqual("age", results.Tables[0].Columns[2].ColumnName);
Assert.AreEqual("address_id", results.Tables[0].Columns[3].ColumnName);
}
