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

Single script/batch_file for multiple DB ops; procedure doc update #964

Open
grumpyinca opened this issue Nov 27, 2024 · 2 comments
Open
Assignees
Labels
Priority Hot This is a high priority item for this release
Milestone

Comments

@grumpyinca
Copy link
Contributor

grumpyinca commented Nov 27, 2024

Create a single script and parallel batch file to provide multiple ODOP-specific database operations. Isolate the database access variables in a single file.

The operations may include:

  • db_size
  • dump_db (backup)
  • dump_restore_db
  • create_db (?)
  • load_all
  • dump_db_startup_files
  • dump_restore_table (?; not yet written)

The database access variables for Development, Test, Staging and Production databases include:

  • type (development, test, staging, production)
  • user
  • password
  • host
  • database

This approach should allow a reduction of the number of files in the scripts folder and entries in the .gitignore file.

Create a client/docs/procedures entry describing use of the script/batch_file to recover from a database full situation.

@grumpyinca grumpyinca added this to the ODOP 5.1 milestone Nov 27, 2024
@grumpyinca grumpyinca self-assigned this Nov 27, 2024
@grumpyinca
Copy link
Contributor Author

Per today's conversation, evolving the approach to Script/batch_file per DB operation.

@grumpyinca grumpyinca modified the milestones: ODOP 5.1, ODOP 5.2 Dec 8, 2024
@1fifoto 1fifoto added the Priority Hot This is a high priority item for this release label Dec 29, 2024
@grumpyinca
Copy link
Contributor Author

Want to rename load_all to load_db_startup_files.
Create load_db.
Rename db_size to list_db_size.
Rename dump_restore_db to dump_load_db.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Priority Hot This is a high priority item for this release
Projects
None yet
Development

No branches or pull requests

2 participants