Nicely Pointed Mandibles
    Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »

    js-sqlpublic

    js-sql Build Status

    Write SQL in your JavaScript

    Under development

    Example .jss file

    function foo(table) {
      var x = <sql>
        SELECT * FROM {table}
        WHERE name = $1 AND id = {getId()}
      </sql>;
     
      return x;
    };
     
    function getId() {
      return 4;
    }
     
    console.log(foo("user")); // SELECT * FROM user WHERE name = $1 AND id = 4

    JSS command usage

    Usage: jss [options] <source directory> <output directory> [<module ID> [<module ID> ...]]
    
    Options:
    
      -h, --help                               output usage information
      -V, --version                            output the version number
      -c, --config [file]                      JSON configuration file (no file means STDIN)
      -w, --watch                              Continually rebuild
      -x, --extension <js | coffee | ...>      File extension to assume when resolving module identifiers
      --relativize                             Rewrite all module identifiers to be relative
      --follow-requires                        Scan modules for required dependencies
      --cache-dir <directory>                  Alternate directory to use for disk cache
      --no-cache-dir                           Disable the disk cache
      --source-charset <utf8 | win1252 | ...>  Charset of source (default: utf8)
      --output-charset <utf8 | win1252 | ...>  Charset of output (default: utf8)
      --harmony                                Turns on JS transformations such as ES6 Classes etc.
    

    Transpiling example

    jss -x jss src/ build/ # this will transpile all .jss files in the src directory into the build directory 

    vim plugin support is here: vim-js-sql

    Click to view video

    install

    npm i js-sql

    Downloadsweekly downloads

    17

    version

    0.0.3

    license

    MIT

    repository

    githubgithub

    last publish

    collaborators

    • avatar