added integration tests for simple queries via the client api

brianc · brianc · commit e5bcdc454205 · 2010-10-25T01:40:24.000-05:00
diff --git a/test/integration/client/simple-query-tests.js b/test/integration/client/simple-query-tests.js
@@ -0,0 +1,17 @@
+var helper = require(__dirname+"/test-helper");
+//before running this test make sure you run the script create-test-tables
+test("selects rows", function() {
+  var client = helper.client();
+  client.connect();
+  var query = client.query("select * from person");
+  var rowCount = 0;
+  query.on('row', function(row) {
+    rowCount++;
+  });
+  assert.raises(query, 'end', function() {
+    assert.equal(rowCount, 26);
+    client.end();
+  });
+
+
+});
diff --git a/test/integration/client/test-helper.js b/test/integration/client/test-helper.js
@@ -0,0 +1,12 @@
+var helper = require(__dirname+'/../test-helper');
+
+module.exports = {
+  //creates a client from cli parameters
+  client: function() {
+    return new Client({
+      database: helper.args.database,
+      user: helper.args.user,
+      password: helper.args.password
+    });
+  }
+};
