Skip to content
Commits on Mar 5, 2015
  1. Merge pull request #24 from blocktrail/escapefield

    use the escapeField function when doing .insert or .update
    committed Mar 5, 2015
Commits on Jan 22, 2015
  1. Merge pull request #33 from vlucas/master

    Add support for Postgres DSN, i.e. DATABASE_URL
    committed Jan 22, 2015
Commits on Jan 21, 2015
  1. @vlucas

    Add support for Postgres DSN, i.e. DATABASE_URL

     * Fixes #32
    vlucas committed Jan 20, 2015
Commits on Apr 7, 2014
  1. @rubensayshi
Commits on Jan 14, 2014
  1. better "falsy" values management

    * falsy-but-not-Numbers-and-not-null values are converted to blank Strings
    * added a "SQL injection prevention" unit test
    * version bumped to 0.7.1
    committed Jan 14, 2014
Commits on Jan 13, 2014
  1. bump version to 0.7

    committed Jan 13, 2014
  2. Fixed #16

    * DBWrapper#close() is now documented in the README
    committed Jan 13, 2014
  3. dropped Node 0.6 support

    * seems that some of our dependencies are not compatible with Node 0.6 anymore (@see https://travis-ci.org/DrBenton/Node-DBI/jobs/16870767 )
    committed Jan 13, 2014
  4. Fixed #19

    * DBSelect : we now handle "falsy" params correctly
    * DBSelect : a "null" param is now converted to NULL in the SQL String
    * auto formatting on dbSelect.js
    committed Jan 13, 2014
  5. Fixed #20

    * more accurate String params escaping
    committed Jan 13, 2014
  6. Node-DBI 2014 modernization :-)

    * removed Vows, replaced by the Mocha&Chai duo for unit tests
    * removed Underscore, replaced by Lodash
    * added a Makefile - tribute to TJ Holowaychuck ;-)
    * added Vagrantfile & Vagrant VM init script for Ubuntu
    committed Jan 13, 2014
Commits on Aug 27, 2013
  1. @kalifg

    0.6.2

    kalifg committed Aug 27, 2013
  2. @kalifg

    Updated mysql dependency

    For some reason specifying "0.9.x" for mysql version pulled only their
    latest branch (0.9.0) and not the latest tag (0.9.6).
    
    I was receiving this error from 0.9.0:
    
    > /home/mdwyer/Desktop/src/TAMU-btsync/iris/tamu-ldap-proxy/node_modules/node-dbi/node_modules/mysql/lib/mysql/net_constan
    > ts.js:8
    > module.exports = process.binding('net');
    >                          ^
    > Error: No such module
    >     at Object.<anonymous> (/home/mdwyer/Desktop/src/TAMU-btsync/iris/tamu-ldap-proxy/node_modules/node-dbi/node_modules/
    > mysql/lib/mysql/net_constants.js:8:26)
    >     at Module._compile (module.js:449:26)
    >     at Object.Module._extensions..js (module.js:467:10)
    >     at Module.load (module.js:356:32)
    >     at Function.Module._load (module.js:312:12)
    >     at Module.require (module.js:362:17)
    >     at require (module.js:378:17)
    >     at Object.<anonymous> (/home/mdwyer/Desktop/src/TAMU-btsync/iris/tamu-ldap-proxy/node_modules/node-dbi/node_modules/
    > mysql/lib/mysql/client.js:10:20)
    >     at Module._compile (module.js:449:26)
    >     at Object.Module._extensions..js (module.js:467:10)
    >
    
    This is fixed in
    [1928c78](felixge/node-mysql@1928c78).
    kalifg committed Aug 27, 2013
Commits on Sep 16, 2012
  1. Travis CI tests passed successfully

     * misc Unit tests fixes & optimizations
     * add Travis CI build status in README.md
    committed Sep 16, 2012
  2. PostgreSQL driver now returns JS dates

    * README update
    * Unit tests fixes
    committed Sep 16, 2012
  3. README & .travis.yml update

    * DB setup must follow Travis CI requirements
    * added Node.js 0.6 to .travis.yml
    committed Sep 16, 2012
  4. Add Travis.ci hook

    committed Sep 16, 2012
Commits on Sep 6, 2012
  1. Merge pull request #9 from mlaccetti/master

    Updated the README to include connect() info
    committed Sep 6, 2012
  2. @mlaccetti

    Tweak to the README

    Not sure if this is necessary, but it seems that calling
    DbWrapper.connect() is the magic that really makes things happen.
    Tweaked the README to show where that might take place and included the
    info in the list of API functions.
    mlaccetti committed Sep 5, 2012
Commits on Aug 17, 2012
  1. Merge pull request #5 from kalifg/where-parenthesis

    Version bump for new SQL queries parentheses better management features.
    committed Aug 17, 2012
Commits on Aug 14, 2012
  1. @kalifg

    Version bump for new features.

    kalifg committed Aug 14, 2012
  2. Merge pull request #4 from kalifg/where-parenthesis

    Where parenthesis
    committed Aug 14, 2012
  3. @kalifg

    Added new test dealing with compound where clauses and array values.

    Updated README with information about supplying array values to
    .where().
    
    Fixed bug in .where() so that array values are treated as they are in
    ZendDb, with the possible exception that we are not restricting what
    clauses they can be supplied to.
    
    Tests pass.
    kalifg committed Aug 14, 2012
  4. @kalifg
  5. @kalifg

    This update will cause all where clauses to be parenthesized, allowing

    one to group compound statements such as .where('id=? OR name=?) which
    the same grouping expectations as they would have with ZendDb.
    
    Updated tests and README for proposed changes.
    kalifg committed Aug 14, 2012
  6. Merge pull request #3 from kalifg/orWhere

    DBSelect.orWhere
    committed Aug 14, 2012
Commits on Aug 9, 2012
  1. @kalifg

    Fixed bug in DBSelect.where().

    kalifg committed Aug 9, 2012
  2. @kalifg
Commits on Aug 8, 2012
  1. @kalifg

    Added documentation about new where features.

    Added name to package.json under authors section.
    kalifg committed Aug 8, 2012
Commits on Aug 3, 2012
  1. @kalifg

    Added new functions DBSelect.whereGroup(groups) and

    DBSelect.whereGroupClose(groups).
    
    These function will allow the creation of arbitrary parenthetical
    expressions in the WHERE clause.  Each has a parameter specifying how
    many groups to open or close.  It's smart enough to not close groups
    that aren't open and to automatically close open groups even if you
    forget to.
    
    As an example, this:
    
    dbWrapper.getSelect()
              .from('user')
              .whereGroupClose() // Erroneous whereGroupClose to be handled
              .whereGroup(3)     // Multiple group start
              .where('enabled=1')
              .where( 'id=?', 10 )
              .whereGroupClose()
              .where( 'first_name=?', 'Dr.')
              .whereGroup()
              .where( 'last_name LIKE ?', '%Benton%' )
              .orWhere( 'nickname=?', 'dude' )
              .whereGroupClose(2);
              // Automatic closing of leftover groups
    
    Generates this:
    
    "SELECT user.* FROM user WHERE (((enabled=1 AND id=10) AND
    first_name='Dr.' AND (last_name LIKE '%Benton%' OR nickname='dude')))"
    kalifg committed Aug 3, 2012
  2. @kalifg
Commits on Aug 2, 2012
  1. @kalifg

    The function DBSelect.where now has an optional third parameter that

    specifies whether to use OR instead of AND for the current clause.
    
    Added the function DBSelect.orWhere to give it parity with ZendDB.
    
    Modified the function DBSelect.assemble to take advantage of this
    feature.
    kalifg committed Aug 2, 2012
Something went wrong with that request. Please try again.