mcp-google-sheets

import { apId, CreateTemplateRequestBody, PlatformPlan, PlatformRole, PrincipalType, TemplateType, } from '@activepieces/shared' import { FastifyInstance } from 'fastify' import { StatusCodes } from 'http-status-codes' import { initializeDatabase } from '../../../../src/app/database' import { databaseConnection } from '../../../../src/app/database/database-connection' import { setupServer } from '../../../../src/app/server' import { generateMockToken } from '../../../helpers/auth' import { CLOUD_PLATFORM_ID, createMockTemplate, mockAndSaveBasicSetup, mockBasicUser, } from '../../../helpers/mocks' let app: FastifyInstance | null = null beforeAll(async () => { await initializeDatabase({ runMigrations: false }) app = await setupServer() }) afterAll(async () => { await databaseConnection().destroy() await app?.close() }) describe('Templates', () => { describe('List Templates', () => { it('should list platform templates only', async () => { // arrange const { mockPlatform, mockUser, mockProject, mockPlatformTemplate } = await createMockPlatformTemplate({ platformId: apId(), plan: { manageTemplatesEnabled: true } }) const testToken = await generateMockToken({ type: PrincipalType.USER, id: mockUser.id, projectId: mockProject.id, platform: { id: mockPlatform.id }, }) const response = await app?.inject({ method: 'GET', url: '/v1/templates', headers: { authorization: `Bearer ${testToken}`, }, query: { type: TemplateType.CUSTOM, }, }) // assert const responseBody = response?.json() expect(response?.statusCode).toBe(StatusCodes.OK) expect(responseBody.data).toHaveLength(1) expect(responseBody.data[0].id).toBe(mockPlatformTemplate.id) }) it('should list cloud platform template for anonymous users', async () => { const response = await app?.inject({ method: 'GET', url: '/v1/templates', query: { type: TemplateType.OFFICIAL, }, }) expect(response?.statusCode).toBe(StatusCodes.OK) }) }) describe('Create Template', () => { it('should create a flow template', async () => { // arrange const { mockPlatform, mockOwner, mockProject } = await mockAndSaveBasicSetup({ platform: { }, plan: { manageTemplatesEnabled: true, }, }) const testToken = await generateMockToken({ type: PrincipalType.USER, id: mockOwner.id, projectId: mockProject.id, platform: { id: mockPlatform.id }, }) const mockTemplate = createMockTemplate({ platformId: mockPlatform.id, type: TemplateType.CUSTOM, }) const createTemplateRequest: CreateTemplateRequestBody = { name: mockTemplate.name, description: mockTemplate.description, summary: mockTemplate.summary, flows: mockTemplate.flows, blogUrl: mockTemplate.blogUrl ?? undefined, type: TemplateType.CUSTOM, author: mockTemplate.author, categories: mockTemplate.categories, tags: mockTemplate.tags, metadata: { foo: 'bar', }, } // act const response = await app?.inject({ method: 'POST', url: '/v1/templates', headers: { authorization: `Bearer ${testToken}`, }, body: createTemplateRequest, }) // assert expect(response?.statusCode).toBe(StatusCodes.CREATED) const responseBody = response?.json() expect(responseBody.metadata).toEqual({ foo: 'bar' }) }) }) describe('Delete Template', () => { it('should not be able delete platform template as member', async () => { // arrange const { mockUser, mockPlatform, mockProject, mockPlatformTemplate } = await createMockPlatformTemplate({ platformId: apId() }) const testToken = await generateMockToken({ id: mockUser.id, type: PrincipalType.USER, projectId: mockProject.id, platform: { id: mockPlatform.id }, }) const response = await app?.inject({ method: 'DELETE', url: `/v1/templates/${mockPlatformTemplate.id}`, headers: { authorization: `Bearer ${testToken}`, }, }) // assert expect(response?.statusCode).toBe(StatusCodes.FORBIDDEN) }) it('should be able delete platform template as owner', async () => { // arrange const { mockPlatform, mockOwner, mockProject, mockPlatformTemplate } = await createMockPlatformTemplate({ platformId: apId() }) const testToken = await generateMockToken({ type: PrincipalType.USER, id: mockOwner.id, projectId: mockProject.id, platform: { id: mockPlatform.id }, }) const response = await app?.inject({ method: 'DELETE', url: `/v1/templates/${mockPlatformTemplate.id}`, headers: { authorization: `Bearer ${testToken}`, }, }) // assert expect(response?.statusCode).toBe(StatusCodes.NO_CONTENT) }) it('should not delete platform template when not authenticated', async () => { // arrange const { mockPlatformTemplate } = await createMockPlatformTemplate({ platformId: CLOUD_PLATFORM_ID, }) const response = await app?.inject({ method: 'DELETE', url: `/v1/templates/${mockPlatformTemplate.id}`, }) // assert expect(response?.statusCode).toBe(StatusCodes.FORBIDDEN) }) }) }) async function createMockPlatformTemplate({ platformId, plan, type }: { platformId: string, plan?: Partial<PlatformPlan>, type?: TemplateType }) { const { mockOwner, mockPlatform, mockProject } = await mockAndSaveBasicSetup({ platform: { id: platformId, }, plan: { manageTemplatesEnabled: true, ...plan, }, }) const mockPlatformTemplate = createMockTemplate({ platformId: mockPlatform.id, type: type ?? TemplateType.CUSTOM, }) await databaseConnection() .getRepository('template') .save(mockPlatformTemplate) const { mockUser } = await mockBasicUser({ user: { platformId: mockPlatform.id, platformRole: PlatformRole.MEMBER, }, }) return { mockOwner, mockUser, mockPlatform, mockProject, mockPlatformTemplate } }