public void AdvancedRecordset_SetRecordsetName()
{
var advancedRecordset = new AdvancedRecordset {
RecordsetName = "TestRecordsetName"
};
Assert.AreEqual("TestRecordsetName", advancedRecordset.RecordsetName);
}
public AdvancedRecordset CreatePersonAddressWorkers()
{
var personRecordsetName = "person";
var addressRecordsetName = "address";
var env = new ExecutionEnvironment();
/*
* Person
| Name | Age | address_id |
| Address
| id | Addr | Postcode |
|
| bob | 21 | 1 |
| sue | 22 | 2 | # unique address
| jef | 24 | 1 | # matching address
| zak | 19 | 9 | # fail finding address
|
| 1 | 11 test lane | 3421 |
| 2 | 16 test lane | 3422 |
* */
var l = new List <AssignValue>();
l.Add(new AssignValue("[[person().name]]", "bob"));
l.Add(new AssignValue("[[person().age]]", "21"));
l.Add(new AssignValue("[[person().address_id]]", "1"));
l.Add(new AssignValue("[[person().name]]", "sue"));
l.Add(new AssignValue("[[person().age]]", "22"));
l.Add(new AssignValue("[[person().address_id]]", "2"));
l.Add(new AssignValue("[[person().name]]", "jef"));
l.Add(new AssignValue("[[person().age]]", "24"));
l.Add(new AssignValue("[[person().address_id]]", "1"));
l.Add(new AssignValue("[[person().name]]", "zak"));
l.Add(new AssignValue("[[person().age]]", "19"));
l.Add(new AssignValue("[[person().address_id]]", "9"));
l.Add(new AssignValue("[[address().id]]", "1"));
l.Add(new AssignValue("[[address().addr]]", "11 test lane"));
l.Add(new AssignValue("[[address().postcode]]", "3421"));
l.Add(new AssignValue("[[address().id]]", "2"));
l.Add(new AssignValue("[[address().addr]]", "16 test lane"));
l.Add(new AssignValue("[[address().postcode]]", "3422"));
env.AssignWithFrame(l, 0);
env.CommitAssign();
var Worker = new AdvancedRecordset(env);
Worker.LoadRecordsetAsTable(personRecordsetName);
Worker.LoadRecordsetAsTable(addressRecordsetName);
return(Worker);
}
public void AdvancedRecordset_Environment()
{
var env = CreateExecutionEnvironment();
var advancedRecordset = new AdvancedRecordset
{
Environment = env
};
Assert.AreEqual(env, advancedRecordset.Environment);
}
public void AdvancedRecordsetActivity_ExecuteRecordset_GIVEN_JsonObject_ShouldSuccess()
{
var started = false;
var personRecordsetName = "personRec";
var env = CreateExecutionEnvironment();
var personObject = new List <AssignValue> {
new AssignValue("[[@person()]]", "{'name':'bob', 'age':21, 'address_id':'1'}")
};
env.AssignWithFrame(personObject, 0);
env.CommitAssign();
var personRec = new List <AssignValue> {
new AssignValue("[[personRec().name]]", "[[@person(*).name]]")
};
env.AssignWithFrame(personRec, 0);
env.CommitAssign();
var recordset = new AdvancedRecordset(env);
recordset.LoadRecordsetAsTable(personRecordsetName);
var activity = new AdvancedRecordsetActivity()
{
SqlQuery = "Select * from personRec",
Outputs = new List <IServiceOutputMapping>
{
new ServiceOutputMapping
{
MappedFrom = "name",
MappedTo = "[[TableCopy().name]]",
}
}
};
var worker = new AdvancedRecordsetActivityWorker(activity, recordset);
var dataObject = new Mock <IDSFDataObject>();
dataObject.Setup(o => o.IsDebugMode()).Returns(true);
dataObject.Setup(o => o.Environment).Returns(env);
dataObject.Object.Environment = env;
worker.ExecuteRecordset(dataObject.Object, 0);
var result = env.Eval("[[TableCopy(1).name]]", 0);
Assert.AreEqual("bob", ExecutionEnvironment.WarewolfEvalResultToString(result));
}
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);
}
public void AdvancedRecordset_LoadRecordsetAsTable_LoadIntoSqliteDb_BuildInsertStatement_colTypeTests()
{
var personRecordsetName = "person";
var l = new List <AssignValue>();
l.Add(new AssignValue("[[person().datatypesFloat]]", "4.5f"));
l.Add(new AssignValue("[[person().testNothing]]", ""));
l.Add(new AssignValue("[[person().testWarewolfAtom]]", "1"));
var env = CreateExecutionEnvironment();
env.AssignWithFrame(l, 0);
env.CommitAssign();
var advancedRecordset = new AdvancedRecordset(env);
advancedRecordset.LoadRecordsetAsTable(personRecordsetName);
Assert.IsNotNull(advancedRecordset);
}
public void AdvancedRecordsetActivity_ExecuteRecordset()
{
var started = false;
var personRecordsetName = "person";
var l = new List <AssignValue>();
l.Add(new AssignValue("[[person().name]]", "bob"));
l.Add(new AssignValue("[[person().age]]", "21"));
l.Add(new AssignValue("[[person().address_id]]", "1"));
var env = CreateExecutionEnvironment();
env.AssignWithFrame(l, 0);
env.CommitAssign();
var recordset = new AdvancedRecordset(env);
recordset.LoadRecordsetAsTable(personRecordsetName);
recordset.ApplyResultToEnvironment(personRecordsetName, new List <IServiceOutputMapping>(), new List <DataRow>(), false, 0, ref started);
recordset.CreateVariableTable();
recordset.InsertIntoVariableTable("TestVariable", "testdata");
var activity = new AdvancedRecordsetActivity()
{
SqlQuery = "Select * from person",
};
var worker = new AdvancedRecordsetActivityWorker(activity, recordset);
var dataObject = new Mock <IDSFDataObject>();
dataObject.Setup(o => o.IsDebugMode()).Returns(true);
dataObject.Setup(o => o.Environment).Returns(env);
dataObject.Object.Environment = env;
//TODO: this is failing as it needs a mock of the recorset
// worker.ExecuteRecordset(dataObject.Object, 0)
}
