sql - npm Package Compare versions

Comparing version 0.29.0 to 0.30.0

lib/table.js

@@ -124,3 +124,10 @@ 'use strict';
 
-Table.prototype.star = function() {
+Table.prototype.star = function(options) {
+  options = options || {};
+  if (options.prefix) {
+    return this.columns.map(function(column) {
+      return this[column.name].as(options.prefix + column.name);
+    }.bind(this));
+  }
+
   return new Column({table: this, star: true});
@@ -127,0 +134,0 @@ };

package.json

@@ -5,3 +5,3 @@ {
   "description": "sql builder",
-  "version": "0.29.0",
+  "version": "0.30.0",
   "homepage": "https://github.com/brianc/node-sql",
@@ -8,0 +8,0 @@ "repository": {

test/dialects/table-tests.js

@@ -58,2 +58,19 @@ 'use strict';
 Harness.test({
+  query: user.select(user.star({ prefix: 'foo_' })).from(user),
+  pg: {
+    text: 'SELECT "user"."id" AS "foo_id", "user"."name" AS "foo_name" FROM "user"',
+    string: 'SELECT "user"."id" AS "foo_id", "user"."name" AS "foo_name" FROM "user"'
+  },
+  sqlite: {
+    text: 'SELECT "user"."id" AS "foo_id", "user"."name" AS "foo_name" FROM "user"',
+    string: 'SELECT "user"."id" AS "foo_id", "user"."name" AS "foo_name" FROM "user"'
+  },
+  mysql: {
+    text: 'SELECT `user`.`id` AS `foo_id`, `user`.`name` AS `foo_name` FROM `user`',
+    string: 'SELECT `user`.`id` AS `foo_id`, `user`.`name` AS `foo_name` FROM `user`'
+  },
+  params: []
+});
+
+Harness.test({
   query: user.select(user.id).from(user).where(user.name.equals('foo')),
@@ -60,0 +77,0 @@ pg: {

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

245867

increased by0.35%

Lines of code

6565

increased by0.34%

No dependency changes