C# Class Microsoft.VisualStudio.R.Package.Sql.Publish.SProcScriptGenerator

Mostra file Open project: Microsoft/RTVS Class Usage Examples

Public Methods

Method Description
CreatePostDeploymentScript ( SqlSProcPublishSettings settings, SProcMap sprocMap ) : string

Generates SQL post deployment script that pushes R code into a table as well as

CreateRCodeTableScript ( SqlSProcPublishSettings settings ) : string
CreateStoredProcedureScripts ( SqlSProcPublishSettings settings, IEnumerable sprocFiles ) : SProcMap

Creates code for stored procedures

SProcScriptGenerator ( IFileSystem fs ) : System

Private Methods

Method Description
FillSprocInlineTemplate ( string rFilePath, string sprocName ) : string

Replaces procedure name, R Code and the SQL query placeholders with actual values

FillSprocTableTemplate ( string rFilePath, string sprocName, string codeTableName, SqlQuoteType quoteType ) : string
GetRFileContent ( string filePath ) : string
GetSqlFileContent ( string filePath ) : string

Method Details

CreatePostDeploymentScript() public method

Generates SQL post deployment script that pushes R code into a table as well as
public CreatePostDeploymentScript ( SqlSProcPublishSettings settings, SProcMap sprocMap ) : string
settings SqlSProcPublishSettings
sprocMap SProcMap
return string

CreateRCodeTableScript() public method

public CreateRCodeTableScript ( SqlSProcPublishSettings settings ) : string
settings SqlSProcPublishSettings
return string

CreateStoredProcedureScripts() public method

Creates code for stored procedures
public CreateStoredProcedureScripts ( SqlSProcPublishSettings settings, IEnumerable sprocFiles ) : SProcMap
settings SqlSProcPublishSettings
sprocFiles IEnumerable
return SProcMap

SProcScriptGenerator() public method

public SProcScriptGenerator ( IFileSystem fs ) : System
fs IFileSystem
return System