@byu-oit/node-mysql-query-builder - npm Package Compare versions

Comparing version 0.1.2 to 0.2.0

dist/lib/core.js

 "use strict";
 Object.defineProperty(exports, "__esModule", { value: true });
+const mysql_1 = require("mysql");
 const errors_1 = require("../errors");
 const util_1 = require("./util");
-const mysql_1 = require("mysql");
 function where(protect, pub, expression) {
@@ -7,0 +7,0 @@ if (!expression) {

dist/lib/util.d.ts

@@ -1,26 +0,26 @@
-import { ProtectedVariables, PublicBuilder, Resource } from '../types';
+import { AsBuilder, AscBuilder, DeleteBuilder, DescBuilder, FromBuilder, IgnoreBuilder, InsertBuilder, IntoBuilder, LikeBuilder, LimitBuilder, OrderByBuilder, ProtectedVariables, PublicBuilder, Resource, SelectBuilder, SetBuilder, UpdateBuilder, WhereBuilder } from '../types';
 export declare function compile(protect: ProtectedVariables, pub: PublicBuilder): void;
 export declare function setup(protect: ProtectedVariables, pub: PublicBuilder): void;
 export declare function getBindMain(protect: ProtectedVariables, pub: PublicBuilder): {
-    select: (expression: string | string[] | Resource) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").SelectBuilder;
-    insert: (tableName: string | undefined) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").InsertBuilder;
-    update: (tableName: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").UpdateBuilder;
-    delete: (tableName: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").DeleteBuilder;
+    select: (expression: string | string[] | Resource) => SelectBuilder;
+    insert: (tableName: string | undefined) => InsertBuilder;
+    update: (tableName: string) => UpdateBuilder;
+    delete: (tableName: string) => DeleteBuilder;
 };
-export declare function bindSelect(protect: ProtectedVariables, pub: PublicBuilder): (expression: string | string[] | Resource) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").SelectBuilder;
-export declare function bindFrom(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").FromBuilder;
-export declare function bindAs(protect: ProtectedVariables, pub: PublicBuilder): (alias: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").AsBuilder;
-export declare function bindUpdate(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").UpdateBuilder;
-export declare function bindSet(protect: ProtectedVariables, pub: PublicBuilder): (newResource: Resource) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").SetBuilder;
-export declare function bindInsert(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string | undefined) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").InsertBuilder;
-export declare function bindIgnore(protect: ProtectedVariables, pub: PublicBuilder): () => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").IgnoreBuilder;
-export declare function bindInto(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").IntoBuilder;
+export declare function bindSelect(protect: ProtectedVariables, pub: PublicBuilder): (expression: string | string[] | Resource) => SelectBuilder;
+export declare function bindFrom(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => FromBuilder;
+export declare function bindAs(protect: ProtectedVariables, pub: PublicBuilder): (alias: string) => AsBuilder;
+export declare function bindUpdate(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => UpdateBuilder;
+export declare function bindSet(protect: ProtectedVariables, pub: PublicBuilder): (newResource: Resource) => SetBuilder;
+export declare function bindInsert(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string | undefined) => InsertBuilder;
+export declare function bindIgnore(protect: ProtectedVariables, pub: PublicBuilder): () => IgnoreBuilder;
+export declare function bindInto(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => IntoBuilder;
 export declare function bindValues(protect: ProtectedVariables, pub: PublicBuilder): (newResource: Resource) => PublicBuilder;
-export declare function bindDelete(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").DeleteBuilder;
-export declare function bindWhere(protect: ProtectedVariables, pub: PublicBuilder): (expression: string | Resource) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").WhereBuilder;
-export declare function bindLike(protect: ProtectedVariables, pub: PublicBuilder): (expression: string) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").LikeBuilder;
-export declare function bindOrderBy(protect: ProtectedVariables, pub: PublicBuilder): (...colNames: string[]) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").OrderByBuilder;
-export declare function bindAsc(protect: ProtectedVariables, pub: PublicBuilder): () => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").AscBuilder;
-export declare function bindDesc(protect: ProtectedVariables, pub: PublicBuilder): () => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").DescBuilder;
-export declare function bindLimit(protect: ProtectedVariables, pub: PublicBuilder): (rowCount: number) => import("../../../../../../Users/stuft2/Projects/node-mysql-query-builder/src/types").LimitBuilder;
+export declare function bindDelete(protect: ProtectedVariables, pub: PublicBuilder): (tableName: string) => DeleteBuilder;
+export declare function bindWhere(protect: ProtectedVariables, pub: PublicBuilder): (expression: string | Resource) => WhereBuilder;
+export declare function bindLike(protect: ProtectedVariables, pub: PublicBuilder): (expression: string) => LikeBuilder;
+export declare function bindOrderBy(protect: ProtectedVariables, pub: PublicBuilder): (...colNames: string[]) => OrderByBuilder;
+export declare function bindAsc(protect: ProtectedVariables, pub: PublicBuilder): () => AscBuilder;
+export declare function bindDesc(protect: ProtectedVariables, pub: PublicBuilder): () => DescBuilder;
+export declare function bindLimit(protect: ProtectedVariables, pub: PublicBuilder): (rowCount: number) => LimitBuilder;
 export declare function bindOffset(protect: ProtectedVariables, pub: PublicBuilder): (offSet: number) => PublicBuilder;

package.json

 {
   "name": "@byu-oit/node-mysql-query-builder",
-  "version": "0.1.2",
+  "version": "0.2.0",
   "description": "Quickly build MySQL queries",
@@ -5,0 +5,0 @@ "main": "dist/index.js",

src/lib/core.ts

@@ -0,1 +1,2 @@
+import {escapeId} from 'mysql';
 import {EInvalidParam, EMissingParam} from '../errors';
@@ -14,3 +15,2 @@ import {
 import {bindAsc, bindDesc, bindLike, bindLimit, bindOffset, bindOrderBy, compile, getBindMain} from './util';
-import {escapeId} from 'mysql';
 
@@ -17,0 +17,0 @@ export function where(protect: ProtectedVariables, pub: PublicBuilder, expression: string | Resource): WhereBuilder {

src/lib/util.ts

@@ -1,2 +0,21 @@
-import {ProtectedVariables, PublicBuilder, Resource} from '../types';
+import {
+    AsBuilder,
+    AscBuilder,
+    DeleteBuilder,
+    DescBuilder,
+    FromBuilder,
+    IgnoreBuilder,
+    InsertBuilder,
+    IntoBuilder,
+    LikeBuilder,
+    LimitBuilder,
+    OrderByBuilder,
+    ProtectedVariables,
+    PublicBuilder,
+    Resource,
+    SelectBuilder,
+    SetBuilder,
+    UpdateBuilder,
+    WhereBuilder
+} from '../types';
 import {asc, desc, like, limit, offset, orderBy, where} from './core';
@@ -32,3 +51,3 @@ import {del} from './delete';
 export function bindSelect(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (expression: string | string[] | Resource) => {
+    return (expression: string | string[] | Resource): SelectBuilder => {
         return select(protect, pub, expression);
@@ -39,3 +58,3 @@ };
 export function bindFrom(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (tableName: string) => {
+    return (tableName: string): FromBuilder => {
         return from(protect, pub, tableName);
@@ -46,3 +65,3 @@ };
 export function bindAs(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (alias: string) => {
+    return (alias: string): AsBuilder => {
         return as(protect, pub, alias);
@@ -53,3 +72,3 @@ };
 export function bindUpdate(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (tableName: string) => {
+    return (tableName: string): UpdateBuilder => {
         return update(protect, pub, tableName);
@@ -60,3 +79,3 @@ };
 export function bindSet(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (newResource: Resource) => {
+    return (newResource: Resource): SetBuilder => {
         return set(protect, pub, newResource);
@@ -67,3 +86,3 @@ };
 export function bindInsert(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (tableName: string | undefined) => {
+    return (tableName: string | undefined): InsertBuilder => {
         return insert(protect, pub, tableName);
@@ -74,3 +93,3 @@ };
 export function bindIgnore(protect: ProtectedVariables, pub: PublicBuilder) {
-    return () => {
+    return (): IgnoreBuilder => {
         return ignore(protect, pub);
@@ -81,3 +100,3 @@ };
 export function bindInto(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (tableName: string) => {
+    return (tableName: string): IntoBuilder => {
         return into(protect, pub, tableName);
@@ -88,3 +107,3 @@ };
 export function bindValues(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (newResource: Resource) => {
+    return (newResource: Resource): PublicBuilder => {
         return values(protect, pub, newResource);
@@ -95,3 +114,3 @@ };
 export function bindDelete(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (tableName: string) => {
+    return (tableName: string): DeleteBuilder => {
         return del(protect, pub, tableName);
@@ -102,3 +121,3 @@ };
 export function bindWhere(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (expression: string | Resource) => {
+    return (expression: string | Resource): WhereBuilder => {
         return where(protect, pub, expression);
@@ -109,3 +128,3 @@ };
 export function bindLike(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (expression: string) => {
+    return (expression: string): LikeBuilder => {
         return like(protect, pub, expression);
@@ -116,3 +135,3 @@ };
 export function bindOrderBy(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (...colNames: string[]) => {
+    return (...colNames: string[]): OrderByBuilder => {
         return orderBy(protect, pub, ...colNames);
@@ -123,3 +142,3 @@ };
 export function bindAsc(protect: ProtectedVariables, pub: PublicBuilder) {
-    return () => {
+    return (): AscBuilder => {
         return asc(protect, pub);
@@ -130,3 +149,3 @@ };
 export function bindDesc(protect: ProtectedVariables, pub: PublicBuilder) {
-    return () => {
+    return (): DescBuilder => {
         return desc(protect, pub);
@@ -137,3 +156,3 @@ };
 export function bindLimit(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (rowCount: number) => {
+    return (rowCount: number): LimitBuilder => {
         return limit(protect, pub, rowCount);
@@ -144,5 +163,5 @@ };
 export function bindOffset(protect: ProtectedVariables, pub: PublicBuilder) {
-    return (offSet: number) => {
+    return (offSet: number): PublicBuilder => {
         return offset(protect, pub, offSet);
     };
 }

No alert changes

Improved metrics

Lines of code

1546

increased by1.24%

Worsened metrics

Total package byte prevSize

88556

decreased by-0.98%

No dependency changes