@aws-appsync/utils - npm Package Compare versions

Comparing version 1.11.0 to 1.12.0

CHANGELOG.md

@@ -6,2 +6,13 @@ # Change Log
 
+# [1.12.0](https://github.com/aws/aws-appsync-toolkit/compare/v1.11.0...v1.12.0) (2024-12-17)
+
+
+### Features
+
+* add new rds utilities ([cc7fbc5](https://github.com/aws/aws-appsync-toolkit/commit/cc7fbc5beb9151a85eef7f585b69ce71cf7117bd))
+
+
+
+
+
 # [1.11.0](https://github.com/aws/aws-appsync-toolkit/compare/v1.10.1...v1.11.0) (2024-11-21)
@@ -8,0 +19,0 @@

lib/rds-helpers.d.ts

@@ -24,2 +24,17 @@ import { Prettify } from './type-utils';
 export declare const typeHint: RDSTypeHintHelper;
+interface RDSAggregate {
+}
+export declare type RDSAggregatesHelper = {
+    max(column: string): RDSAggregate;
+    maxDistinct(column: string): RDSAggregate;
+    min(column: string): RDSAggregate;
+    minDistinct(column: string): RDSAggregate;
+    count(column: string): RDSAggregate;
+    countDistinct(column: string): RDSAggregate;
+    avg(column: string): RDSAggregate;
+    avgDistinct(column: string): RDSAggregate;
+    sum(column: string): RDSAggregate;
+    sumDistinct(column: string): RDSAggregate;
+};
+export declare const agg: RDSAggregatesHelper;
 type RDSEqualityOperator<T> = {
@@ -42,2 +57,12 @@ ne?: T | null;
     size?: RDSNumberOperator<number>;
+    max?: RDSNumberOperator<number>;
+    min?: RDSNumberOperator<number>;
+    avg?: RDSNumberOperator<number>;
+    sum?: RDSNumberOperator<number>;
+    count?: RDSNumberOperator<number>;
+    maxDistinct?: RDSNumberOperator<number>;
+    minDistinct?: RDSNumberOperator<number>;
+    avgDistinct?: RDSNumberOperator<number>;
+    sumDistinct?: RDSNumberOperator<number>;
+    countDistinct?: RDSNumberOperator<number>;
 }>;
@@ -65,2 +90,11 @@ type RDSAttributeExistsOperator = {
 };
+type RDSJoinStatementWithUsing = RDSBasePayload & {
+    using?: Array<string | RDSAliasObject>;
+    on?: never;
+};
+type RDSJoinStatementWithOn<T> = RDSBasePayload & {
+    using?: never;
+    on?: RDSConditionObject<T> | SQLStatement;
+};
+type RDSJoinStatement<T> = RDSJoinStatementWithUsing | RDSJoinStatementWithOn<T>;
 type RDSBasePayloadWithTable = {
@@ -71,3 +105,3 @@ /**
      */
-    table: string;
+    table: string | RDSAliasObject;
     from?: never;
@@ -80,3 +114,3 @@ };
      */
-    from: string | RDSAliasObject;
+    from: string | RDSAliasObject | SQLStatement | SelectStatement;
     table?: never;
@@ -114,3 +148,3 @@ };
      */
-    where?: RDSConditionObject<T>;
+    where?: SQLStatement | RDSConditionObject<T>;
 }>;
@@ -121,3 +155,3 @@ export type SelectPayload<T = unknown> = Prettify<RDSBaseConditionalPayload<T> & {
      */
-    columns?: ColumnName<T>[] | '*';
+    columns?: Array<ColumnName<T> | RDSAliasObject | RDSAggregate> | '*';
     /**
@@ -135,2 +169,28 @@ * Specifies the order by which the results should be sorted.
     offset?: number;
+    /**
+     * Specify how to group rows based on one or more specified columns
+     */
+    groupBy?: Array<string | number>;
+    /**
+     * Specifies the filter the results of the GROUP BY clause
+     */
+    having?: RDSConditionObject<T>;
+    /**
+     * Specifies the type of JOIN statement and it's parameters
+     */
+    join?: RDSJoinStatement<T>[];
+    innerJoin?: RDSJoinStatement<T>[];
+    leftJoin?: RDSJoinStatement<T>[];
+    leftOuterJoin?: RDSJoinStatement<T>[];
+    rightJoin?: RDSJoinStatement<T>[];
+    rightOuterJoin?: RDSJoinStatement<T>[];
+    fullOuterJoin?: RDSJoinStatement<T>[];
+    crossJoin?: RDSJoinStatement<T>[];
+    joinNatural?: RDSJoinStatement<T>[];
+    innerJoinNatural?: RDSJoinStatement<T>[];
+    leftJoinNatural?: RDSJoinStatement<T>[];
+    leftOuterJoinNatural?: RDSJoinStatement<T>[];
+    rightJoinNatural?: RDSJoinStatement<T>[];
+    rightOuterJoinNatural?: RDSJoinStatement<T>[];
+    fullOuterJoinNatural?: RDSJoinStatement<T>[];
 }>;
@@ -155,3 +215,3 @@ export type InsertPayload<T = unknown> = Prettify<RDSBasePayload & Partial<PGReturningPayload<T>> & {
      */
-    returning: ColumnName<T>[] | '*';
+    returning: Array<ColumnName<T> | RDSAliasObject> | '*';
 };
@@ -158,0 +218,0 @@ export interface SQLStatement {

package.json

 {
   "name": "@aws-appsync/utils",
-  "version": "1.11.0",
+  "version": "1.12.0",
   "description": "This project contains type definitions for AppSync resolver types.",
@@ -30,3 +30,3 @@ "main": "lib/index.js",
   },
-  "gitHead": "384ab4d41b8fafbe2d0d55a5551694ec9a24843d"
+  "gitHead": "a760890122d70af176c79b456a6cc1818534929a"
 }

No alert changes

Improved metrics

Total package byte prevSize

146952

increased by1.82%

Lines of code

3396

increased by1.8%

No dependency changes