graphql backend

1. **Use Nest.js and Nest.js Query**:The backend for the CRM app is built using Nest.js and the Nest.js Query package. You can start by setting up a Nest.js project and then integrate Nest.js Query.
   • Nest.js Query Documentation: Nest.js Query Getting Started (https://doug-martin.github.io/nestjs-query/docs/introduction/getting-started)
2. **GraphQL Schema**:You can access the GraphQL schema and documentation from the public GraphQL server provided by Refine. This will help you understand the data structure and queries used in the CRM app.
   • GraphQL Server: <https://api.crm.refine.dev/graphql> (https://api.crm.refine.dev/graphql)
3. **Backend Configuration**:The backend configuration involves defining resolvers and setting up the necessary entities and DTOs. Here is an example configuration snippet:

   {
     pagingStrategy: PagingStrategies.OFFSET,
     enableTotalCount: true,
     EntityClass: CompanyEntity,
     DTOClass: CompanyModel,
     CreateDTOClass: CompanyCreateInput,
     UpdateDTOClass: CompanyUpdateInput,
     enableSubscriptions: true,
     enableAggregate: true,
   }

   {
     pagingStrategy: PagingStrategies.OFFSET,
     enableTotalCount: true,
     EntityClass: CompanyEntity,
     DTOClass: CompanyModel,
     CreateDTOClass: CompanyCreateInput,
     UpdateDTOClass: CompanyUpdateInput,
     enableSubscriptions: true,
     enableAggregate: true,
   }

1. Database Design:
   The backend uses TypeORM for database interactions. You can define your entities and use TypeORM's subscribers to handle events like audit logs.

• **Example Subscriber**:```javascript import { DataSource, EntitySubscriberInterface, EventSubscriber, InsertEvent, Repository, UpdateEvent, } from 'typeorm'; import { ContactEntity } from '../entities/contact.entity'; import { InjectRepository } from '@nestjs/typeorm'; import { AuditEntity } from '../entities/audit.entity'; import { AuditAction } from '../enums'; import { InjectPubSub } from '@ptc-org/nestjs-query-graphql'; import { PubSub } from 'graphql-subscriptions'; import { faker } from '@faker-js/faker';```
• **Additional Resources**:
  • Backend Configuration Details: Refine Backend Configuration (https://refine.dev/docs/data/packages/nestjs-query/#backend-configuration)

1. **Nest.js and Nest.js Query**:
   • The backend is built using Nest.js, a progressive Node.js framework for building efficient and scalable server-side applications.
   • Nest.js Query is used for handling GraphQL queries and mutations.
2. **GraphQL Schema**:
   • The GraphQL schema and documentation can be accessed from the public GraphQL server provided by Refine: <https://api.crm.refine.dev/graphql> (https://api.crm.refine.dev/graphql).
3. **Database and ORM**:
   • TypeORM is used for database interactions, and entities are defined using TypeORM decorators.
4. **Example Configuration**:Here is an example configuration snippet for setting up the backend:

   {{
     pagingStrategy: PagingStrategies.OFFSET,
     enableTotalCount: true,
     EntityClass: CompanyEntity,
     DTOClass: CompanyModel,
     CreateDTOClass: CompanyCreateInput,
     UpdateDTOClass: CompanyUpdateInput,
     enableSubscriptions: true,
     enableAggregate: true,
   }}

   {{
     pagingStrategy: PagingStrategies.OFFSET,
     enableTotalCount: true,
     EntityClass: CompanyEntity,
     DTOClass: CompanyModel,
     CreateDTOClass: CompanyCreateInput,
     UpdateDTOClass: CompanyUpdateInput,
     enableSubscriptions: true,
     enableAggregate: true,
   }}

1. Example Subscriber:
   An example of a TypeORM subscriber for handling events like audit logs:

   import {
     DataSource,
     EntitySubscriberInterface,
     EventSubscriber,
     InsertEvent,
     Repository,
     UpdateEvent,
   } from 'typeorm';
   import { ContactEntity } from '../entities/contact.entity';
   import { InjectRepository } from '@nestjs/typeorm';
   import { AuditEntity } from '../entities/audit.entity';
   import { AuditAction } from '../enums';
   import { InjectPubSub } from '@ptc-org/nestjs-query-graphql';
   import { PubSub } from 'graphql-subscriptions';
   import { faker } from '@faker-js/faker';

   import {
     DataSource,
     EntitySubscriberInterface,
     EventSubscriber,
     InsertEvent,
     Repository,
     UpdateEvent,
   } from 'typeorm';
   import { ContactEntity } from '../entities/contact.entity';
   import { InjectRepository } from '@nestjs/typeorm';
   import { AuditEntity } from '../entities/audit.entity';
   import { AuditAction } from '../enums';
   import { InjectPubSub } from '@ptc-org/nestjs-query-graphql';
   import { PubSub } from 'graphql-subscriptions';
   import { faker } from '@faker-js/faker';

Step 1: Export GraphQL Schema from Hasura

1. **Install Apollo Rover CLI**:```bashnpm install --save-dev @apollo/rover```
2. **Generate GraphQL Schema**:```bashnpx rover graph introspect <http://localhost:8080/v1/graphql> -H "X-Hasura-Admin-Secret:adminsecretkey" | out-file schema.graphql -encoding utf8```

1. **Create `codegen.yml`**:Create a file named `codegen.yml` at the same level as your `package.json` file with the following content:```yamlschema: schema.graphqlgenerates: ./src/generated.ts: plugins:
   • typescript
   • typescript-operations
   • typed-document-node
     ```
2. **Install Required Packages**:```bashnpm install --save-dev @graphql-codegen/cli @graphql-codegen/typed-document-node @graphql-codegen/typescript @graphql-codegen/typescript-operations```
3. **Run Codegen**:```bashnpx graphql-codegen```

1. **Example SQL for Creating Tables**:```sqlCREATE TABLE companies ( id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL, address TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);CREATE TABLE contacts ( id SERIAL PRIMARY KEY, company_id INT REFERENCES companies(id), name VARCHAR(255) NOT NULL, email VARCHAR(255) UNIQUE NOT NULL, phone VARCHAR(20), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);CREATE TABLE audits ( id SERIAL PRIMARY KEY, action VARCHAR(50) NOT NULL, entity VARCHAR(50) NOT NULL, entity_id INT NOT NULL, timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP);```

1. **Example Refine Configuration**:```javascriptimport { Refine } from "@pankod/refine";import routerProvider from "@refinedev/react-router-v6";import dataProvider, { GraphQLClient } from "@refinedev/graphql";const client = new GraphQLClient("<http://localhost:8080/v1/graphql">);const App: React.FC = () => { return ( <Refine routerProvider={routerProvider} dataProvider={dataProvider(client)} /> );};export default App;```
2. **Example Usage in a Component**:```javascriptimport { useTable, useSelect, List, Table, Space, EditButton, ShowButton, Delete----------------------Note: you can ask me a follow up question by @ mentioning me again ----------------------