public void ShouldMockAllObjectDependencies()
{
var token = new CancellationTokenSource().Token;
var service = new ObjectDependencyService();
var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();
options.EachColumnInSelectOnNewRow = false;
options.EachColumnInValuesOnNewRow = false;
var meta = ObjectMetadata.FromQualifiedString("ETL.fillCountry");
var deps = service.GetDependencies(meta, GetLocalConnection(), token);
var res = TsqltManager.MockAllDependencies(token, options, GetLocalConnection(), deps);
Console.WriteLine(res.ToString());
}
public void ShouldMockHierarchialIDValues()
{
// Due to bug
var token = new CancellationTokenSource().Token;
var service = new ObjectDependencyService();
var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();
options.EachColumnInSelectOnNewRow = false;
options.EachColumnInValuesOnNewRow = false;
var meta = ObjectMetadata.FromQualifiedString("REPORT.70_getShortRiskDetailed_IRT");
var deps = service.GetDependencies(meta, GetLocalConnection(), token);
var res = TsqltManager.MockAllDependencies(token, options, GetLocalConnection(), deps);
Console.WriteLine(res.ToString());
}
public override void ExecuteCommand(System.Threading.CancellationToken token)
{
var selectedText = ShellManager.GetSelectedText();
var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();
options.EachColumnInSelectOnNewRow = false;
options.EachColumnInValuesOnNewRow = false;
var connectionString = ConnectionManager.GetConnectionStringForCurrentWindow();
var meta = ObjectMetadata.FromQualifiedString(selectedText);
var service = new ObjectDependencyService();
var dependencies = service.GetDependencies(meta, connectionString, token);
var superMockingString = TsqltManager.MockAllDependencies(token, options, connectionString, dependencies);
ShellManager.AppendToEndOfSelection(superMockingString);
}
public override void ExecuteCommand(CancellationToken token)
{
var options = new PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary();
var ok = new Action <string, PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary>((result, checkedOptions) =>
{
int numRows = 0;
if (!int.TryParse(result, out numRows))
{
ShellManager.ShowMessageBox("Please input a valid number");
return;
}
else
{
if (numRows <= 0)
{
numRows = 0;
}
else if (numRows > 1000)
{
numRows = 1000;
}
}
var selectedText = ShellManager.GetSelectedText();
StringBuilder sb = new StringBuilder();
var connectionString = ConnectionManager.GetConnectionStringForCurrentWindow();
var meta = ObjectMetadata.FromQualifiedString(selectedText);
sb.AppendLine(TsqltManager.MockTableWithRows(token, options, numRows, meta, connectionString));
ShellManager.ReplaceSelectionWith(sb.ToString());
});
var diagManager = new DialogManager.InputWithCheckboxesDialogManager <PeterHenell.SSMS.Plugins.Utils.TsqltManager.MockOptionsDictionary>();
diagManager.Show("How many rows to select? (0=max)", "1", options, ok, cancelCallback);
}
