chore: Add businessId to Instance model

dgcode-tec · dgcode-tec · commit a145935366ba · 2024-07-12T11:52:29.000-03:00
Updated the Instance model to include a new optional string property called businessId. This change affects the following files:

- prisma/postgresql-schema.prisma
- src/api/controllers/instance.controller.ts
- src/api/dto/instance.dto.ts
- src/api/services/monitor.service.ts
- src/validate/instance.schema.ts

A new untracked migration folder has been created to manage database schema updates:

- prisma/migrations/20240712144948_add_business_id_column_to_instances/

This change allows for storing a business identifier alongside the instance, enhancing the ability to categorize and manage instances more effectively.
diff --git a/prisma/migrations/20240712144948_add_business_id_column_to_instances/migration.sql b/prisma/migrations/20240712144948_add_business_id_column_to_instances/migration.sql
@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "Instance" ADD COLUMN     "businessId" VARCHAR(100);
diff --git a/prisma/postgresql-schema.prisma b/prisma/postgresql-schema.prisma
@@ -54,6 +54,7 @@ model Instance {
   profilePicUrl    String?                  @db.VarChar(500)
   integration      String?                  @db.VarChar(100)
   number           String?                  @db.VarChar(100)
+  businessId       String?                  @db.VarChar(100)
   token            String?                  @unique @db.VarChar(255)
   clientName       String?                  @db.VarChar(100)
   createdAt        DateTime?                @default(now()) @db.Timestamp
diff --git a/src/api/controllers/instance.controller.ts b/src/api/controllers/instance.controller.ts
@@ -87,6 +87,7 @@ export class InstanceController {
     chatwootDaysLimitImportMessages,
     chatwootOrganization,
     chatwootLogo,
+    businessId,
   }: InstanceDto) {
     try {
       if (token) await this.authService.checkDuplicateToken(token);
@@ -125,7 +126,7 @@ export class InstanceController {
       if (!token) hash = v4().toUpperCase();
       else hash = token;
 
-      await this.waMonitor.saveInstance({ instanceId, integration, instanceName, hash, number });
+      await this.waMonitor.saveInstance({ instanceId, integration, instanceName, hash, number, businessId });
 
       instance.setInstance({
         instanceName,
diff --git a/src/api/dto/instance.dto.ts b/src/api/dto/instance.dto.ts
@@ -42,6 +42,7 @@ export class InstanceDto {
   proxyProtocol?: string;
   proxyUsername?: string;
   proxyPassword?: string;
+  businessId?: string;
 }
 
 export class SetPresenceDto {
diff --git a/src/api/services/monitor.service.ts b/src/api/services/monitor.service.ts
@@ -192,6 +192,7 @@ export class WAMonitoringService {
             integration: data.integration || Integration.WHATSAPP_BAILEYS,
             token: data.hash,
             clientName: clientName,
+            businessId: data.businessId,
           },
         });
       }
diff --git a/src/validate/instance.schema.ts b/src/validate/instance.schema.ts
@@ -30,6 +30,7 @@ export const instanceSchema: JSONSchema7 = {
     instanceName: { type: 'string' },
     token: { type: 'string' },
     number: { type: 'string', pattern: '^\\d+[\\.@\\w-]+' },
+    businessId: { type: 'string' },
     qrcode: { type: 'boolean' },
     Integration: {
       type: 'string',

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- AlterTable`
	`2`	`+ALTER TABLE "Instance" ADD COLUMN "businessId" VARCHAR(100);`
Original file line number	Diff line number	Diff line change
`@@ -42,6 +42,7 @@ export class InstanceDto {`
`42`	`42`	`proxyProtocol?: string;`
`43`	`43`	`proxyUsername?: string;`
`44`	`44`	`proxyPassword?: string;`
	`45`	`+ businessId?: string;`
`45`	`46`	`}`
`46`	`47`
`47`	`48`	`export class SetPresenceDto {`
Original file line number	Diff line number	Diff line change
`@@ -192,6 +192,7 @@ export class WAMonitoringService {`
`192`	`192`	`integration: data.integration \|\| Integration.WHATSAPP_BAILEYS,`
`193`	`193`	`token: data.hash,`
`194`	`194`	`clientName: clientName,`
	`195`	`+ businessId: data.businessId,`
`195`	`196`	`},`
`196`	`197`	`});`
`197`	`198`	`}`