PipeScript

0.2.8

Languages/SQL/SQL-Language.ps.ps1

                                Language function SQL {

<#

.SYNOPSIS

    SQL PipeScript Language Definition.

.DESCRIPTION

    Allows PipeScript to generate SQL.

    PipeScript can be embedded in multiline or singleline format

    In multiline format, PipeScript will be embedded within: `/*{...}*/`

    In single line format

    -- { or -- PipeScript{  begins a PipeScript block

    -- } or -- }PipeScript  ends a PipeScript block

    ```SQL    

    -- {

    Uncommented lines between these two points will be ignored

    --  # Commented lines will become PipeScript / PowerShell.

    -- param($message = 'hello world')

    -- "-- $message"

    -- }

    ```

.EXAMPLE

    Invoke-PipeScript {

        $SQLScript = '    

    -- {

    Uncommented lines between these two points will be ignored

    --  # Commented lines will become PipeScript / PowerShell.

    -- param($message = "hello world")

    -- "-- $message"

    -- }

    '

        [OutputFile('.\HelloWorld.ps1.sql')]$SQLScript

    }

    Invoke-PipeScript .\HelloWorld.ps1.sql

#>

[ValidatePattern('\.sql$')]

param()

    $FilePattern = '\.sql$'

    # We start off by declaring a number of regular expressions:

    $startComment = '(?>

        (?>

            (?<IsSingleLine>--)|

            /\*

        )\s{0,}(?:PipeScript)?\s{0,}\{)'

    $endComment   = '(?>

        --\s{0,}\}\s{0,}(?:PipeScript)?

        |

        \}\*/(?:PipeScript)?\s{0,}

    )    

    '

    $startPattern   = "(?<PSStart>${startComment})"

    $endPattern     = [Regex]::new("(?<PSEnd>${endComment})",'IgnoreCase,IgnorePatternWhitespace')

    # Create a splat containing arguments to the core inline transpiler

    # Using -LinePattern will skip any inline code not starting with --

    $LinePattern   = "^\s{0,}--\s{0,}"

}