public void AdvancedRecordsetTool_Clicking_GenerateOutputs_Creates_A_Recordset_Name()
{
ExplorerUIMap.Filter_Explorer(AdvancedRecordset);
ExplorerUIMap.Open_Explorer_First_Item_With_Double_Click();
DatabaseToolsUIMap.AdvancedRecordsetTool_ChangeView_With_DoubleClick();
var advancedRecordset = DatabaseToolsUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.WorkSurfaceContext.WorkflowDesignerView.DesignerView.ScrollViewerPane.ActivityTypeDesigner.WorkflowItemPresenter.Flowchart.AdvancedRecordset;
Assert.IsTrue(advancedRecordset.LargeView.Exists, "Advanced Recordset tool does not exist on design surface.");
advancedRecordset.LargeView.QueryComboBox.TextEdit.Text = "select name from person";
Mouse.Click(advancedRecordset.LargeView.GenerateOutputsButton);
Assert.AreEqual("TableCopy", advancedRecordset.LargeView.RecordSetTextBoxEdit.Text);
}
public void AdvancedRecordsetTool_Select_Name_With_An_Elias_From_Person_Creates_PersonAliasName_Mapping()
{
ExplorerUIMap.Filter_Explorer(AdvancedRecordset);
ExplorerUIMap.Open_Explorer_First_Item_With_Double_Click();
DatabaseToolsUIMap.AdvancedRecordsetTool_ChangeView_With_DoubleClick();
var advancedRecordset = DatabaseToolsUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.WorkSurfaceContext.WorkflowDesignerView.DesignerView.ScrollViewerPane.ActivityTypeDesigner.WorkflowItemPresenter.Flowchart.AdvancedRecordset;
Assert.IsTrue(advancedRecordset.LargeView.Exists, "Advanced Recordset tool does not exist on design surface.");
advancedRecordset.LargeView.QueryComboBox.TextEdit.Text = "select name as firstName from person";
Keyboard.SendKeys("{Escape}");
Mouse.Click(advancedRecordset.LargeView.GenerateOutputsButton);
Assert.AreEqual("[[TableCopy().firstName]]", advancedRecordset.LargeView.OutputsMappingDataGrTable.ItemRow.Row1Cell.Row1Combobox.TextEdit.Text);
}
public void AdvancedRecordsetTool_Small_And_LargeView()
{
WorkflowTabUIMap.Drag_Toolbox_AdvancedRecordset_Onto_DesignSurface();
var advancedRecordset = DatabaseToolsUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.WorkSurfaceContext.WorkflowDesignerView.DesignerView.ScrollViewerPane.ActivityTypeDesigner.WorkflowItemPresenter.Flowchart.AdvancedRecordset;
Assert.IsTrue(advancedRecordset.Exists, "Advanced Recordset tool does not exist on design surface.");
Assert.IsTrue(advancedRecordset.LargeView.Exists, "Advanced Recordset large does not exist on design surface on initial drop from Toolbox.");
//Small View
DatabaseToolsUIMap.AdvancedRecordsetTool_ChangeView_With_DoubleClick();
Assert.IsTrue(advancedRecordset.SmallView.Exists, "Advanced Recordset tool small view does not exist after collapsing large view with a double click.");
//Large View
DatabaseToolsUIMap.AdvancedRecordsetTool_ChangeView_With_DoubleClick();
Assert.IsTrue(advancedRecordset.LargeView.DeclareVariablesDataTable.Exists, "Declare Variables Data Table does not exist on Advanced Recordset connector tool large view.");
Assert.IsTrue(advancedRecordset.LargeView.QueryComboBox.Exists, "Query text box does not exist on Advanced Recordset connector tool large view.");
Assert.IsTrue(advancedRecordset.LargeView.GenerateOutputsButton.Exists, "Generate Outputs button does not exist on Advanced Recordset connector tool large view.");
}
public void AdvancedRecordsetTool_Declare_Value_Change_Debug_Should_Update()
{
ExplorerUIMap.Filter_Explorer(CopyPasteADNameChange);
ExplorerUIMap.Open_Explorer_First_Item_With_Double_Click();
DatabaseToolsUIMap.AdvancedRecordsetTool_ChangeView_With_DoubleClick();
var advancedRecordset = DatabaseToolsUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.WorkSurfaceContext.WorkflowDesignerView.DesignerView.ScrollViewerPane.ActivityTypeDesigner.WorkflowItemPresenter.Flowchart.AdvancedRecordset;
Assert.IsTrue(advancedRecordset.LargeView.Exists, "Advanced Recordset tool does not exist on design surface.");
UIMap.Press_F6();
WorkflowTabUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.ContentPane.ContentDockManager.SplitPaneRight.DebugOutput.SearchTextBox.Text = "Advanced Recordset";
string displayTextJohn = WorkflowTabUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.ContentPane.ContentDockManager.SplitPaneRight.DebugOutput.DebugOutputTree.UIAdvancedRecordsetTreeItem.UIKimText.DisplayText;
Assert.AreEqual("John", displayTextJohn);
DatabaseToolsUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.WorkSurfaceContext.WorkflowDesignerView.DesignerView.ScrollViewerPane.ActivityTypeDesigner.WorkflowItemPresenter.Flowchart.AdvancedRecordset.LargeView.DeclareVariablesDataTable.UINameRow.UIItemnameColumnDisplaCell.UIThevalueofthelocalvaComboBox.UITextEdit.Text = "Jeff";
UIMap.Press_F6();
string displayTextJeff = WorkflowTabUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.ContentPane.ContentDockManager.SplitPaneRight.DebugOutput.DebugOutputTree.UIAdvancedRecordsetTreeItem.UIKimText.DisplayText;
Assert.AreEqual("Jeff", displayTextJeff);
DatabaseToolsUIMap.AdvancedRecordsetTool_Select_With_SingleClick();
Keyboard.SendKeys("^C");
UIMap.Click_NewWorkflow_RibbonButton();
WorkflowTabUIMap.Click_Start_Node();
Keyboard.SendKeys("^V");
DatabaseToolsUIMap.Right_Click_AdvancedRecordsetTool();
UIMap.Context_Menu_Set_As_Start_Node();
Mouse.DoubleClick(advancedRecordset, new Point(182, 15));
UIMap.Press_F6();
string displayTextGeorge = WorkflowTabUIMap.MainStudioWindow.DockManager.SplitPaneMiddle.TabManSplitPane.TabMan.WorkflowTab.ContentPane.ContentDockManager.SplitPaneRight.DebugOutput.DebugOutputTree.UIAdvancedRecordsetTreeItem.UIKimText.DisplayText;
Assert.AreEqual("Jeff", displayTextGeorge);
}
