Skip to content
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
Commits on Aug 1, 2012
  1. Update README.md

    committed Aug 1, 2012
Commits on Jul 27, 2012
  1. package.json fix

    committed Jul 27, 2012
  2. @neerolyte
  3. @neerolyte
  4. @neerolyte
  5. @neerolyte
  6. @neerolyte
  7. @neerolyte
  8. @neerolyte

    adding vim modeline

    neerolyte committed Jul 27, 2012
Commits on Jul 26, 2012
  1. @neerolyte

    pulled in changes for postgres - some tests fail

    Fabian Bornhofen ( https://github.com/fbornhofen/Node-DBI ) made some
    additions to get postgresql working. I've pulled those changes in and
    reversed the removal of the MySQL testing, added some doco for getting
    PostgreSQL tests running.
    
    Some PostgreSQL tests are currently failing but most appear to work -
    needs further investigation.
    neerolyte committed Jul 27, 2012
  2. @neerolyte
  3. @neerolyte

    Adding doco and metadata to get tests working

    Adding doco explaining how to set up MySQL for the test suite to run and
    adding deps to package.json that are required for tests to run.
    
    Tests now pass under node v0.8.3.
    neerolyte committed Jul 27, 2012
  4. @neerolyte

    adding vim modeline

    neerolyte committed Jul 27, 2012
  5. @neerolyte

    adding missing dependencies

    neerolyte committed Jul 27, 2012
  6. @neerolyte

    ignoring common data files

    neerolyte committed Jul 27, 2012
Commits on May 6, 2012
  1. @sstur
Commits on Dec 17, 2011
  1. @pronebird
Commits on Dec 15, 2011
  1. @pronebird
Something went wrong with that request. Please try again.