Using "dataExplorer.scriptAsAlter" command

[MikhailProfile]

Good day,

I'm trying to use vscode.commands.executeCommand("dataExplorer.scriptAsAlter",...) in my custom extension. But I can't find any info how to run it properly. I tried to pass azdata.ObjectExplorerContext with no luck.

Can somebody help with this command? How to use it properly?

[Charles-Gagnon]

What exactly are you trying to do? That's an internal command so isn't recommended to use itself - it will likely be difficult to get the correct context and is also something that can change at any point since we don't promise a contract around internal commands.

Here's the code for the command if you're interested :

azuredatastudio/src/sql/workbench/contrib/scripting/browser/scriptingActions.ts

Line 159 in 0831172

const baseContext: BaseActionContext = {

But you should be able to get the ScriptingProvider directly by calling azdata.dataprotocol.getProvider<azdata.ScriptingProvider>('MSSQL', azdata.DataProviderType.ScriptingProvider); and then calling scriptAsOperation on it (you'll need to fill in the info about the object being scripted, which if you have the node context should be contained in that)

Note - be careful not to use the registerOnScriptingComplete function or you'll break the core ADS functionality due to microsoft/sqlops-dataprotocolclient#62

[MikhailProfile]

Good day Charles,

Thanks for your reply!

My idea is to have a QuickPick where I can search for all objects in my MSSQL including source codes of SP,Functions etc(Done). On pressing enter I want to open in a new editor "ALTER script" if it's SP or Function or "Select top 1000" if it's a Table or View.

For now I can open editor and put code of procedure there but it's a "create" code. And to "not reinvent the bicycle" I want to use existing ScriptAsAlter. I believe your code should do the job.

Thanks a lot!