Narrating Prophetic Monks

    azure-odata-sql

    0.2.0 • Public • Published

    azure-odata-sql

    This library contains functionality to convert OData queries into SQL statements.

    The library uses types from the mssql npm package to represent parameter types. The query object is in the format produced by azure-query-js.

    Installation

    npm i azure-odata-sql
    

    Usage

    The library currently exports a single function:

    require('azure-odata-sql').format(query, tableConfig)
    

    The query parameter is an object with any of the following properties:

    Property Description
    skip Number of rows to skip
    take Number of rows to take
    inlineCount Set to allpages to include a total count query
    resultLimit Number of rows to limit the query to
    selections Columns to select
    filters Filters to apply
    ordering Columns to sort by
    id Record identifier
    includeDeleted Include soft deleted columns

    The tableConfig is an object with any of the following properties:

    Property Description
    name The name of the table being queried
    schema The database schema name for the table
    flavor Either mssql or sqlite
    softDelete True if the table supports soft delete with a column called deleted

    Keywords

    none

    Install

    npm i azure-odata-sql

    DownloadsWeekly Downloads

    206

    Version

    0.2.0

    License

    MIT

    Last publish

    Collaborators

    • danderson00
    • windowsazure