@duely/db - npm Package Compare versions

Comparing version 0.0.17 to 0.0.18

dist/index.d.ts

@@ -57,3 +57,3 @@ import { ClientBase, Pool, QueryConfig } from 'pg';
     queryResourceAccess: import("@duely/core").GenericFunction<Promise<string>, [] | [client: ClientBase, id: string] | [id: string]>;
-    queryResource<K extends string, R_2 = any, F extends Record<string, any> = Record<string, any>>(id_or_resource_name: K, filter?: F | undefined): Promise<K extends "subdomain" | "agency" | "theme" | "image" | "user" ? Resources[K] : R_2>;
+    queryResource<K extends string, R_2 = any, F extends Record<string, any> = Record<string, any>>(id_or_resource_name: K, filter?: F | undefined): Promise<K extends "subdomain" | "agency" | "theme" | "image" | "user" | "sign up" | "password reset" | "product" | "markdown" | "membership" | "notification definition" | "form" | "agency thank you page setting" | "page block definition" | "product thank you page setting" | "form field" | "page block" ? Resources[K] : R_2>;
     queryResourceAll<R_3 = any, F_1 extends Record<string, any> = Record<string, any>>(resource_name: string, filter?: F_1 | undefined): Promise<R_3[]>;
@@ -60,0 +60,0 @@ createResource<R_4 = any, I_2 extends Record<string, any> = Record<string, any>>(resource_name: string, data: I_2): Promise<R_4>;

dist/types.d.ts

@@ -47,2 +47,99 @@ declare type FilteredKeys<T, U> = {
 };
+export declare type SignUpResource = {
+    id: ResourceId<'sign up'>;
+    user_id: ResourceId<'user'>;
+    name: string;
+    data: object;
+    email_address: string;
+};
+export declare type PasswordResetResource = {
+    id: ResourceId<'password reset'>;
+    user_id: ResourceId<'user'>;
+    name: string;
+    data: object;
+    email_address: string;
+};
+export declare type ProductResource = {
+    id: ResourceId<'product'>;
+    agency_id: ResourceId<'agency'>;
+    name: string;
+    url_name: string;
+    description: string;
+    duration: string;
+    image_logo_id: ResourceId<'image'>;
+    image_hero_id: ResourceId<'image'>;
+    default_price_id: ResourceId<'price'>;
+    markdown_description_id: ResourceId<'markdown'>;
+    stripe_prod_id_ext_live: string;
+    stripe_prod_id_ext_test: string;
+    integration_id: ResourceId<'integration'>;
+};
+export declare type MarkdownResource = {
+    id: ResourceId<'markdown'>;
+    agency_id: ResourceId<'agency'>;
+    name: string;
+    data: string;
+    access: AccessLevel;
+};
+export declare type MembershipResource = {
+    id: ResourceId<'membership'>;
+    subdomain_id: ResourceId<'subdomain'>;
+    user_id: ResourceId<'user'>;
+    access: AccessLevel;
+};
+export declare type NotificationDefinitionResource = {
+    id: ResourceId<'notification definition'>;
+    name: string;
+    description: string;
+    stripe_event: string;
+    feed_template: string;
+    feed_notification_enabled: boolean;
+    feed_notification_default: boolean;
+    email_template: string;
+    email_notifications_enabled: boolean;
+    email_notifications_default: boolean;
+};
+export declare type UserNotificationSettingResource = {
+    id: ResourceId<'user notification setting'>;
+    user_id: ResourceId<'user'>;
+    subdomain_id: ResourceId<'subdomain'>;
+    notification_definition_id: ResourceId<'notification definition'>;
+    feed_notification: boolean;
+    email_notification: boolean;
+};
+export declare type AgencyThankYouPageSettingResource = {
+    id: ResourceId<'agency thank you page setting'>;
+    agency_id: ResourceId<'agency'>;
+    url: string;
+};
+export declare type PageBlockDefinitionResource = {
+    id: ResourceId<'page block definition'>;
+    page_definition_id: ResourceId<'page definition'>;
+    form_id: ResourceId<'form'>;
+    name: string;
+};
+export declare type ProductThankYouPageSettingResource = {
+    id: ResourceId<'product thank you page setting'>;
+    product_id: ResourceId<'product'>;
+    url: string;
+};
+export declare type FormFieldResource = {
+    id: ResourceId<'form field'>;
+    form_id: ResourceId<'form'>;
+    name: string;
+    type: string;
+    label: string;
+    default: object;
+    sort_key: number;
+};
+export declare type PageBlockResource = {
+    id: ResourceId<'page block'>;
+    page_block_definition_id: ResourceId<'page block definition'>;
+    page_id: ResourceId<'page'>;
+    data: object;
+    after_id: ResourceId<'page block'>;
+};
+export declare type FormResource = {
+    id: ResourceId<'form'>;
+};
 export declare type ResourceDefinitions = {
@@ -83,2 +180,3 @@ subdomain: {
         table_name: 'sign_up';
+        resource: SignUpResource;
     };
@@ -89,2 +187,3 @@ 'password reset': {
         table_name: 'password_reset';
+        resource: PasswordResetResource;
     };
@@ -95,2 +194,3 @@ product: {
         table_name: 'product';
+        resource: ProductResource;
     };
@@ -101,2 +201,3 @@ markdown: {
         table_name: 'markdown';
+        resource: MarkdownResource;
     };
@@ -107,2 +208,3 @@ membership: {
         table_name: 'membership';
+        resource: MembershipResource;
     };
@@ -113,2 +215,3 @@ 'notification definition': {
         table_name: 'notification_definition';
+        resource: NotificationDefinitionResource;
     };
@@ -119,2 +222,3 @@ 'user notification setting': {
         table_name: 'user_notification_setting';
+        resoruce: UserNotificationSettingResource;
     };
@@ -125,2 +229,3 @@ form: {
         table_name: 'form';
+        resource: FormResource;
     };
@@ -131,2 +236,3 @@ 'agency thank you page setting': {
         table_name: 'agency_thank_you_page_setting';
+        resource: AgencyThankYouPageSettingResource;
     };
@@ -137,2 +243,3 @@ 'page block definition': {
         table_name: 'page_block_definition';
+        resource: PageBlockDefinitionResource;
     };
@@ -143,2 +250,3 @@ 'product thank you page setting': {
         table_name: 'product_thank_you_page_setting';
+        resource: ProductThankYouPageSettingResource;
     };
@@ -149,2 +257,3 @@ 'form field': {
         table_name: 'form_field';
+        resource: FormFieldResource;
     };
@@ -155,2 +264,3 @@ 'page block': {
         table_name: 'page_block';
+        resource: PageBlockResource;
     };
@@ -157,0 +267,0 @@ 'transaction fee': {

package.json

 {
   "name": "@duely/db",
-  "version": "0.0.17",
+  "version": "0.0.18",
   "description": "Client for querying duely-postgres database.",
@@ -5,0 +5,0 @@ "repository": "github:uoleevi/duely",

src/types.ts

@@ -59,2 +59,112 @@ type FilteredKeys<T, U> = { [P in keyof T]: T[P] extends U ? P : never }[keyof T];
 
+export type SignUpResource = {
+  id: ResourceId<'sign up'>;
+  user_id: ResourceId<'user'>;
+  name: string;
+  data: object;
+  email_address: string;
+};
+
+export type PasswordResetResource = {
+  id: ResourceId<'password reset'>;
+  user_id: ResourceId<'user'>;
+  name: string;
+  data: object;
+  email_address: string;
+};
+
+export type ProductResource = {
+  id: ResourceId<'product'>;
+  agency_id: ResourceId<'agency'>;
+  name: string;
+  url_name: string;
+  description: string;
+  duration: string;
+  image_logo_id: ResourceId<'image'>;
+  image_hero_id: ResourceId<'image'>;
+  default_price_id: ResourceId<'price'>;
+  markdown_description_id: ResourceId<'markdown'>;
+  stripe_prod_id_ext_live: string;
+  stripe_prod_id_ext_test: string;
+  integration_id: ResourceId<'integration'>;
+};
+
+export type MarkdownResource = {
+  id: ResourceId<'markdown'>;
+  agency_id: ResourceId<'agency'>;
+  name: string;
+  data: string;
+  access: AccessLevel;
+};
+
+export type MembershipResource = {
+  id: ResourceId<'membership'>;
+  subdomain_id: ResourceId<'subdomain'>;
+  user_id: ResourceId<'user'>;
+  access: AccessLevel;
+};
+
+export type NotificationDefinitionResource = {
+  id: ResourceId<'notification definition'>;
+  name: string;
+  description: string;
+  stripe_event: string;
+  feed_template: string;
+  feed_notification_enabled: boolean;
+  feed_notification_default: boolean;
+  email_template: string;
+  email_notifications_enabled: boolean;
+  email_notifications_default: boolean;
+};
+
+export type UserNotificationSettingResource = {
+  id: ResourceId<'user notification setting'>;
+  user_id: ResourceId<'user'>;
+  subdomain_id: ResourceId<'subdomain'>;
+  notification_definition_id: ResourceId<'notification definition'>;
+  feed_notification: boolean;
+  email_notification: boolean;
+};
+
+export type AgencyThankYouPageSettingResource = {
+  id: ResourceId<'agency thank you page setting'>;
+  agency_id: ResourceId<'agency'>;
+  url: string;
+};
+
+export type PageBlockDefinitionResource = {
+  id: ResourceId<'page block definition'>;
+  page_definition_id: ResourceId<'page definition'>;
+  form_id: ResourceId<'form'>;
+  name: string;
+};
+
+export type ProductThankYouPageSettingResource = {
+  id: ResourceId<'product thank you page setting'>;
+  product_id: ResourceId<'product'>;
+  url: string;
+};
+
+export type FormFieldResource = {
+  id: ResourceId<'form field'>;
+  form_id: ResourceId<'form'>;
+  name: string;
+  type: string;
+  label: string;
+  default: object;
+  sort_key: number;
+};
+
+export type PageBlockResource = {
+  id: ResourceId<'page block'>;
+  page_block_definition_id: ResourceId<'page block definition'>;
+  page_id: ResourceId<'page'>;
+  data: object;
+  after_id: ResourceId<'page block'>;
+};
+
+export type FormResource = {
+  id: ResourceId<'form'>;
+};
+
 export type ResourceDefinitions = {
@@ -67,7 +177,32 @@ subdomain: {
   };
-  agency: { name: 'agency'; prefix: 'agcy'; table_name: 'agency'; resource: AgencyResource };
-  theme: { name: 'theme'; prefix: 'theme'; table_name: 'theme'; resource: ThemeResource };
-  image: { name: 'image'; prefix: 'img'; table_name: 'image'; resource: ImageResource };
-  user: { name: 'user'; prefix: 'user'; table_name: 'user'; resource: UserResource };
-  'sign up': { name: 'sign up'; prefix: 'su'; table_name: 'sign_up' };
+  agency: {
+    name: 'agency';
+    prefix: 'agcy';
+    table_name: 'agency';
+    resource: AgencyResource;
+  };
+  theme: {
+    name: 'theme';
+    prefix: 'theme';
+    table_name: 'theme';
+    resource: ThemeResource;
+  };
+  image: {
+    name: 'image';
+    prefix: 'img';
+    table_name: 'image';
+    resource: ImageResource;
+  };
+  user: {
+    name: 'user';
+    prefix: 'user';
+    table_name: 'user';
+    resource: UserResource;
+  };
+  'sign up': {
+    name: 'sign up';
+    prefix: 'su';
+    table_name: 'sign_up';
+    resource: SignUpResource;
+  };
   'password reset': {
@@ -77,6 +212,22 @@ name: 'password reset';
     table_name: 'password_reset';
+    resource: PasswordResetResource;
   };
-  product: { name: 'product'; prefix: 'prod'; table_name: 'product' };
-  markdown: { name: 'markdown'; prefix: 'md'; table_name: 'markdown' };
-  membership: { name: 'membership'; prefix: 'member'; table_name: 'membership' };
+  product: {
+    name: 'product';
+    prefix: 'prod';
+    table_name: 'product';
+    resource: ProductResource;
+  };
+  markdown: {
+    name: 'markdown';
+    prefix: 'md';
+    table_name: 'markdown';
+    resource: MarkdownResource;
+  };
+  membership: {
+    name: 'membership';
+    prefix: 'member';
+    table_name: 'membership';
+    resource: MembershipResource;
+  };
   'notification definition': {
@@ -86,2 +237,3 @@ name: 'notification definition';
     table_name: 'notification_definition';
+    resource: NotificationDefinitionResource;
   };
@@ -92,4 +244,10 @@ 'user notification setting': {
     table_name: 'user_notification_setting';
+    resoruce: UserNotificationSettingResource;
   };
-  form: { name: 'form'; prefix: 'form'; table_name: 'form' };
+  form: {
+    name: 'form';
+    prefix: 'form';
+    table_name: 'form';
+    resource: FormResource;
+  };
   'agency thank you page setting': {
@@ -99,2 +257,3 @@ name: 'agency thank you page setting';
     table_name: 'agency_thank_you_page_setting';
+    resource: AgencyThankYouPageSettingResource
   };
@@ -105,2 +264,3 @@ 'page block definition': {
     table_name: 'page_block_definition';
+    resource: PageBlockDefinitionResource;
   };
@@ -111,5 +271,16 @@ 'product thank you page setting': {
     table_name: 'product_thank_you_page_setting';
+    resource: ProductThankYouPageSettingResource;
   };
-  'form field': { name: 'form field'; prefix: 'formfld'; table_name: 'form_field' };
-  'page block': { name: 'page block'; prefix: 'pblk'; table_name: 'page_block' };
+  'form field': {
+    name: 'form field';
+    prefix: 'formfld';
+    table_name: 'form_field';
+    resource: FormFieldResource;
+  };
+  'page block': {
+    name: 'page block';
+    prefix: 'pblk';
+    table_name: 'page_block';
+    resource: PageBlockResource;
+  };
   'transaction fee': {
@@ -125,3 +296,7 @@ name: 'transaction fee';
   };
-  page: { name: 'page'; prefix: 'page'; table_name: 'page' };
+  page: {
+    name: 'page';
+    prefix: 'page';
+    table_name: 'page';
+  };
   'stripe account': {
@@ -137,3 +312,7 @@ name: 'stripe account';
   };
-  customer: { name: 'customer'; prefix: 'cus'; table_name: 'customer' };
+  customer: {
+    name: 'customer';
+    prefix: 'cus';
+    table_name: 'customer';
+  };
   'webhook event': {
@@ -144,7 +323,27 @@ name: 'webhook event';
   };
-  price: { name: 'price'; prefix: 'price'; table_name: 'price' };
-  order: { name: 'order'; prefix: 'ord'; table_name: 'order' };
-  credential: { name: 'credential'; prefix: 'cred'; table_name: 'credential' };
-  integration: { name: 'integration'; prefix: 'inte'; table_name: 'integration' };
-  'order item': { name: 'order item'; prefix: 'orditm'; table_name: 'order_item' };
+  price: {
+    name: 'price';
+    prefix: 'price';
+    table_name: 'price';
+  };
+  order: {
+    name: 'order';
+    prefix: 'ord';
+    table_name: 'order';
+  };
+  credential: {
+    name: 'credential';
+    prefix: 'cred';
+    table_name: 'credential';
+  };
+  integration: {
+    name: 'integration';
+    prefix: 'inte';
+    table_name: 'integration';
+  };
+  'order item': {
+    name: 'order item';
+    prefix: 'orditm';
+    table_name: 'order_item';
+  };
 };
@@ -151,0 +350,0 @@

No alert changes

Improved metrics

Total package byte prevSize

1101682

increased by0.67%

Lines of code

11787

increased by2.58%

No dependency changes