NASA-AMMOS / NASA-AMMOS/anms

adding columns to data_model table

Open
#199 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

sustainment
Dominant language
JavaScript
Stars
3
Forks
2
Avg merge
2d 23h
Merged PRs (30d)
2

Description

The ADM listing should include an "organization name" and "org. enum." column as well as a "model name" and "model enum." Which together are the unique namespace IDs. This could be a follow on PR if it's too big for this edit.

Originally posted by @BrianSipos in https://github.com/NASA-AMMOS/anms/pull/198#pullrequestreview-3003143189

in 10-refdb_core_create_database.sql need to add the new columns in the data_model table

in agent.pgsql.jinja need to update data_model inserts to add org enum and organization name

"model name" should be name column and "model enum" should be enumeration column

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with refdb-sql/postgres/Database_Scripts/Tables/10-refdb_core_create_database.sql and inspect the data_model table definition. Then review src/camp/generators/data/agent.pgsql.jinja and its data_model inserts. Done means the table includes organization name, org. enum, name, and enumeration, and generated inserts populate the new organization fields.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.