Bug: When an IN/NOT IN predicate is not the first to be added, the statements.js:buildOperator function includes the whole outValues array as values. How to reproduce: See the tests added. These will fail before this fix. Fix: The utils.js:quote function now takes the value being added as third parameter. When quoting an IN/NOT IN operator, the valuePos array starts at the correct index (outValues.length - value.length + 1).
…umber for publishing to npm.
…. Merged separate integration test files into one. Moved test models into test_helper. Added many-to-many example to integration tests.
…e file. Added professor/student example setup in bootstrap for future many-to-many examples. NOTE: if you run the tests before, you should delete .fastlegs* files, drop your fastlegs_test database(s), and rerun make to (re)create the table structure, including the new professor/student tables. Also, as far as I can tell, the many-to-many relationship is just plain broken. We will resolve that it upcoming releases.
…have TRUNCATE CASCADE. CASCADE modifier is simply ignored. MySQL doesn't have OFFSET without LIMIT like PG does. So, if offset opt is present without limit, statement will return: LIMIT 100000000 OFFSET x. If both limit and offset opts are present, works as expected.
…mysql. paves the way to have different base and client files as needed. base for mysql side needs to have pg specific stuff removed. need to confirm that base for pg side matches what is currently in master - no need for mysql stuff to be mixed in.
…e FastLegS with a db param (defaults to pg). bound statements to client.
…oth postgres and mysql.
…ake. Additional message to make sure that you don't specify a database that already exists.