import crypto from 'crypto';
import { ColumnType, type AuthConfigSchema } from '@insforge/shared-schemas';

/**
 * Generates a user-friendly error message listing all password requirements
 * @param config - Authentication configuration with password requirements
 * @returns A formatted message listing all enabled password requirements
 */
export function getPasswordRequirementsMessage(config: AuthConfigSchema): string {
  const requirements: string[] = [];

  requirements.push(`at least ${config.passwordMinLength} characters long`);

  if (config.requireNumber) {
    requirements.push('at least one number');
  }

  if (config.requireLowercase) {
    requirements.push('at least one lowercase letter');
  }

  if (config.requireUppercase) {
    requirements.push('at least one uppercase letter');
  }

  if (config.requireSpecialChar) {
    requirements.push('at least one special character');
  }

  return `Password must contain ${requirements.join(', ')}`;
}

export const convertSqlTypeToColumnType = (sqlType: string): ColumnType | string => {
  switch (sqlType.toLowerCase()) {
    case 'uuid':
      return ColumnType.UUID;
    case 'timestamptz':
    case 'timestamp with time zone':
      return ColumnType.DATETIME;
    case 'date':
      return ColumnType.DATE;
    case 'integer':
    case 'bigint':
    case 'smallint':
    case 'int':
    case 'int2':
    case 'int4':
    case 'serial':
    case 'serial2':
    case 'serial4':
    case 'serial8':
    case 'smallserial':
    case 'bigserial':
      return ColumnType.INTEGER;
    case 'double precision':
    case 'real':
    case 'numeric':
    case 'float':
    case 'float4':
    case 'float8':
    case 'decimal':
      return ColumnType.FLOAT;
    case 'boolean':
    case 'bool':
      return ColumnType.BOOLEAN;
    case 'json':
    case 'jsonb':
    case 'array':
      return ColumnType.JSON;
    case 'text':
    case 'varchar':
    case 'char':
    case 'character varying':
    case 'character':
      return ColumnType.STRING;
    default:
      return sqlType.slice(0, 5);
  }
};

/**
 * Generate a UUID v4
 * @returns A UUID v4 string
 */
export function generateUUID(): string {
  return crypto.randomUUID();
}

/**
 * Generate a random numeric string of specified length
 * @param length - The length of the numeric string to generate
 * @returns A random string containing only digits (0-9)
 */
export function generateNumericCode(length: number): string {
  // Generate each digit independently
  let result = '';
  for (let i = 0; i < length; i++) {
    result += crypto.randomInt(0, 10).toString();
  }

  return result;
}

/**
 * Generate a cryptographically secure random token
 * @param bytes - Number of random bytes to generate (default: 32)
 * @returns Hex-encoded string (length = bytes * 2 characters)
 * @example
 * generateSecureToken(32) // Returns 64-character hex string (256 bits entropy)
 * generateSecureToken(16) // Returns 32-character hex string (128 bits entropy)
 */
export function generateSecureToken(bytes: number = 32): string {
  return crypto.randomBytes(bytes).toString('hex');
}