Method FindProjectVariables

admin/database/postgres/postgres.go:3158–3193

(ctx context.Context, projectID string, environment *string)

}

func (c *connection) FindProjectVariables(ctx context.Context, projectID string, environment *string) ([]*database.ProjectVariable, error) {
	q := `SELECT * FROM project_variables p WHERE p.project_id = $1`
	args := []interface{}{projectID}
	if environment != nil {
		// Also include variables that are not environment specific and not set for the given environment
		q += `
			AND (
				p.environment = $2
				OR (
					p.environment = ''
					AND NOT EXISTS (
						SELECT 1
						FROM project_variables p2
						WHERE p2.project_id = p.project_id
						AND p2.environment = $2
						AND lower(p2.name) = lower(p.name)
					)
				)
			)
		`
		args = append(args, environment)
	}
	var res []*database.ProjectVariable
	err := c.getDB(ctx).SelectContext(ctx, &res, q, args...)
	if err != nil {
		return nil, parseErr("project variables", err)
	}

	// Decrypt the variables
	err = c.decryptProjectVariables(res)
	if err != nil {
		return nil, err
	}

	return res, nil
}

func (c *connection) UpsertProjectVariable(ctx context.Context, projectID, environment string, vars map[string]string, userID string) ([]*database.ProjectVariable, error) {
	var userIDPtr *string