Dan Delany

Revisit Postgres DB user permissions, roles and groups

1

## Background Per [discussion](https://jpl.slack.com/archives/CJ07FGRPH/p1727977827739709?thread_ts=1727974827.413089&cid=CJ07FGRPH) with @Mythicaeda - our Postgres DB service doesn't really have proper user role/group access permissions. Currently each user or service that accesses the DB is given...

Better support for downgrading Aerie & running down-migrations

1

## Background The Aerie DB migration script supports running down (ie. backward) migrations, for downgrading the database to older versions of Aerie - this is mostly used for troubleshooting, or...

## Background The "Generator Constraint" is a utility wrapper provided with the procedural constraints library to make it easier to generate constraint violations, described in the docs here: https://nasa-ammos.github.io/aerie-docs/scheduling-and-constraints/procedural/constraints/#generator-constraints ###...

Activity auto-deletion/"easy idempotence" in Procedural Scheduling

2

## Background Proposed new feature for the Java Procedural Scheduling library. Procedural scheduling goals are essentially Java programs that can make arbitrary changes to the Plan, such as adding, editing...

## Background Low-priority follow-up to https://github.com/NASA-AMMOS/aerie-gateway/pull/109 - this PR includes a “faux transaction” ie. _our_ code rolls back DB state if anything goes wrong during import to avoid corruption. This...

Support bulk file operations in Workspace Service

2

## Background We plan to implement https://github.com/NASA-AMMOS/aerie-ui/issues/1791 to support selecting **multiple files** in the Sequence Editor workspace. The context menu items **move**, **copy**, **delete**, and **move to workspace** must work...

WIP Updates to action server to allow accessing JWT token. More info & testing procedure to come.

Action runs should have access to running user's JWT token

1

## Summary Propagate the user’s JWT to the Action Server so actions can authenticate against other services under the same identity provider. ## Background As discussed with @parkerabercrombie and @mattdailis...

## Summary Allow `aerie-actions` to retrieve the workspace's JS sequence adaptation (from the Parcel) and call exported functions from it at runtime. ## Background Users would like to be able...

Implement common HTTP error message formats for all Aerie services

1

## Background @AaronPlave @duranb and I have been working on improving error messaging across Aerie. One major impediment to this is the fact that there is no common standard format/structure...