enhancement: Improve environnement management

[HugoRCD]

Overview

Improve environment management by transforming environment storage from concatenated strings to a proper array structure, enabling better environment handling and future custom environment support.

Current Behavior

• Environments stored as concatenated strings ('production|preview' or 'production')
• Limited flexibility for environment management
• No support for custom environments
• Complex string manipulation for multiple environments

Proposed Behavior

• Store environments as proper arrays
• Link environments to team settings
• Support base environments (production, development, preview)
• Foundation for custom environments
• Cleaner environment management

Implementation Details

Database Schema Changes

// Current Schema
export const variables = pgTable('variables', {
  id: serial('id').primaryKey(),
  environment: text('environment').notNull(), // Currently: 'production|preview'
  // ... other fields
})

// New Schema
export const environments = pgTable('environments', {
  id: serial('id').primaryKey(),
  teamId: integer('team_id').references(() => teams.id),
  name: text('name').notNull(),
  type: text('type').notNull(), // 'base' or 'custom'
  createdAt: timestamp('created_at').defaultNow(),
})

export const variableEnvironments = pgTable('variable_environments', {
  id: serial('id').primaryKey(),
  variableId: integer('variable_id').references(() => variables.id),
  environmentId: integer('environment_id').references(() => environments.id),
})

Base Implementation

// Environment Types
export enum BaseEnvironment {
  PRODUCTION = 'production',
  DEVELOPMENT = 'development',
  PREVIEW = 'preview'
}

// Team Creation with Base Environments
export class TeamService {
  async createTeam(createTeamInput: CreateTeamInput): Promise<Team> {
    const team = await createTeam(createTeamInput)
    
    // Initialize base environments
    await Promise.all(
      Object.values(BaseEnvironment).map(env =>
        createEnvironment({
          teamId: team.id,
          name: env,
          type: 'base'
        })
      )
    )
    
    return team
  }
}

export class VariableService {
  async createVariable(input: CreateVariableInput): Promise<Variable> {
    const variable = await createVariable(input)
    
    // Link environments
    await Promise.all(
      input.environments.map(envId =>
        createVariableEnvironment({
          variableId: variable.id,
          environmentId: envId
        })
      )
    )
    
    return variable
  }
}

Future Possibilities

1. Custom Environments

• Team-specific environments
• Environment templates
• Environment hierarchies

2. Enhanced Features

• Environment-specific permissions
• Environment cloning
• Environment variables inheritance
• Environment health monitoring

3. Team Management

• Environment access control
• Environment sharing between teams
• Environment audit logs

This is merely a proposal for implementation; the code may not be suitable for the project. This is intended solely to provide a clearer understanding of how the implementation might appear.