Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

add database schema version number #253

Open
26 tasks
TatianaBurek opened this issue Dec 20, 2023 · 0 comments
Open
26 tasks

add database schema version number #253

TatianaBurek opened this issue Dec 20, 2023 · 0 comments
Assignees
Labels
alert: NEED ACCOUNT KEY Need to assign an account key to this issue METdataio: General priority: medium Medium Priority type: enhancement Improve something that it is currently doing

Comments

@TatianaBurek
Copy link
Collaborator

TatianaBurek commented Dec 20, 2023

There is no simple way to get the version of databases schema. It can be confusing for the users. It also hard to say winch updates were performed. To make it possible we need to:

  • Create a new table 'version' with one count that contains the version number
  • Update mv_mysql.sql
  • Create a script that would return a version number for the selected database
  • for each release create update_<version_number>.sql script that would in addition to schema updates change the version number in 'version' table

Time Estimate

Estimate the amount of work required here.
Issues should represent approximately 2 days of work.

Sub-Issues

Consider breaking the enhancement down into sub-issues.

  • Add a checkbox for each sub-issue here.

Relevant Deadlines

List relevant project deadlines here or state NONE.

Funding Source

Define the source of funding and account keys here or state NONE.

Define the Metadata

Assignee

  • Select engineer(s) or no engineer required
  • Select scientist(s) or no scientist required

Labels

  • Select component(s)
  • Select priority
  • Select requestor(s)

Projects and Milestone

  • Select Repository and/or Organization level Project(s) or add alert: NEED CYCLE ASSIGNMENT label
  • Select Milestone as the next official version or Future Versions

Define Related Issue(s)

Consider the impact to the other METplus components.

Enhancement Checklist

See the METplus Workflow for details.

  • Complete the issue definition above, including the Time Estimate and Funding Source.
  • Fork this repository or create a branch of develop.
    Branch name: feature_<Issue Number>_<Description>
  • Complete the development and test your changes.
  • Add/update log messages for easier debugging.
  • Add/update unit tests.
  • Add/update documentation.
  • Add any new Python packages to the METplus Components Python Requirements table.
  • Push local changes to GitHub.
  • Submit a pull request to merge into develop.
    Pull request: feature <Issue Number> <Description>
  • Define the pull request metadata, as permissions allow.
    Select: Reviewer(s) and Development issues

Select: Repository level development cycle Project for the next official release
Select: Milestone as the next official version

  • Iterate until the reviewer(s) accept and merge your changes.
  • Delete your fork or branch.
  • Close this issue.
@TatianaBurek TatianaBurek added type: enhancement Improve something that it is currently doing alert: NEED ACCOUNT KEY Need to assign an account key to this issue alert: NEED MORE DEFINITION Not yet actionable, additional definition required priority: medium Medium Priority alert: NEED CYCLE ASSIGNMENT Need to assign to a release development cycle METdataio: General labels Dec 20, 2023
@TatianaBurek TatianaBurek added this to the METdataio-3.0.0 milestone Dec 20, 2023
@TatianaBurek TatianaBurek self-assigned this Dec 20, 2023
@TatianaBurek TatianaBurek removed alert: NEED MORE DEFINITION Not yet actionable, additional definition required alert: NEED CYCLE ASSIGNMENT Need to assign to a release development cycle labels Dec 20, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
alert: NEED ACCOUNT KEY Need to assign an account key to this issue METdataio: General priority: medium Medium Priority type: enhancement Improve something that it is currently doing
Projects
None yet
Development

No branches or pull requests

1 participant