Skip to content

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

4.1 KB
Raw Blame
import {
  PieceAuth,
  Property,
  StaticPropsValue,
} from '@activepieces/pieces-framework';
import { OracleRunnerError, runnerPool } from './runner-pool';
import type { RunnerAuth } from './runner-protocol';

export const oracleDbAuth = PieceAuth.CustomAuth({
  description: `Connect to Oracle Database using either Service Name (host/port/service) or a full connection string.`,
  required: true,
  props: {
    connectionType: Property.StaticDropdown({
      displayName: 'Connection Type',
      description: 'How you want to connect',
      required: true,
      options: {
        options: [
          { label: 'Service Name', value: 'serviceName' },
          { label: 'Connection String', value: 'connectionString' },
        ],
      },
      defaultValue: 'serviceName',
    }),
    host: Property.ShortText({
      displayName: 'Host',
      description: 'Database server hostname or IP',
      required: false,
    }),
    port: Property.Number({
      displayName: 'Port',
      description: 'Database port',
      required: false,
      defaultValue: 1521,
    }),
    serviceName: Property.ShortText({
      displayName: 'Service Name',
      description: 'Oracle service name',
      required: false,
    }),
    connectionString: Property.LongText({
      displayName: 'Connection String',
      description: 'Full connection string (e.g., host:port/serviceName)',
      required: false,
    }),
    user: Property.ShortText({
      displayName: 'Username',
      required: true,
    }),
    password: PieceAuth.SecretText({
      displayName: 'Password',
      required: true,
    }),
    thickMode: Property.Checkbox({
      displayName: 'Thick Mode',
      description:
        'Enable to support older Oracle Database versions (11g, 10g password verifiers). ' +
        'Oracle Instant Client will be downloaded and installed automatically if not already present.',
      required: false,
      defaultValue: false,
    }),
  },

  validate: async ({ auth }) => {
    const typedAuth = auth as StaticPropsValue<(typeof oracleDbAuth)['props']>;
    const logs: string[] = [];

    if (typedAuth.connectionType === 'serviceName') {
      if (!typedAuth.host || !typedAuth.port || !typedAuth.serviceName) {
        return {
          valid: false,
          error:
            'Host, Port, and Service Name are required for this connection type.',
        };
      }
      logs.push(
        `[oracle] Connection type: serviceName → ${typedAuth.host}:${typedAuth.port}/${typedAuth.serviceName}`
      );
    } else {
      if (!typedAuth.connectionString) {
        return {
          valid: false,
          error: 'Connection String is required for this connection type.',
        };
      }
      logs.push(
        `[oracle] Connection type: connectionString → ${typedAuth.connectionString.replace(
          /\/\/[^:]+:[^@]+@/,
          '//***:***@'
        )}`
      );
    }

    const runnerAuth: RunnerAuth = {
      connectionType: typedAuth.connectionType,
      host: typedAuth.host,
      port: typedAuth.port,
      serviceName: typedAuth.serviceName,
      connectionString: typedAuth.connectionString,
      user: typedAuth.user,
      password: typedAuth.password,
      thickMode: typedAuth.thickMode === true,
    };

    logs.push(`[oracle] Thick mode: ${runnerAuth.thickMode}`);

    try {
      const { runner, initLogs } = await runnerPool.acquire(
        runnerAuth.thickMode ? 'thick' : 'thin'
      );
      logs.push(...initLogs);
      const { logs: invokeLogs } = await runner.invoke<{ valid: boolean }>({
        cmd: 'validate',
        auth: runnerAuth,
      });
      if (invokeLogs) logs.push(...invokeLogs);
      logs.push('[oracle] Connection established successfully.');
      console.log(logs.join('\n'));
      return { valid: true };
    } catch (e) {
      if (e instanceof OracleRunnerError && e.logs) logs.push(...e.logs);
      logs.push(
        `[oracle] Error: ${(e as Error)?.message ?? 'Unknown error'}`
      );
      return {
        valid: false,
        error: `Connection failed. Debug log:\n${logs.join('\n')}`,
      };
    }
  },
});

export type OracleDbAuth = StaticPropsValue<typeof oracleDbAuth.props>;