Include "Submitter" Column in Auto-Loaded Data for Local Environment

[ananyakaligal]

Problem

The local environment setup does not include the Submitter column in the auto-loaded data. This leads to errors when running queries or features that depend on this column, making local testing unreliable.

Reproducing the bug

• Set up the local environment following the project setup guide.
• Navigate to http://localhost:8080/import/batch/pending
• Observe the error about the missing column.

Context

• Browser (Chrome, Safari, Firefox, etc): CHrome
• OS (Windows, Mac, etc): Linux
• Logged in (Y/N): Y
• Environment (prod, dev, local): Dev

Breakdown

Proposed Solution:
Add the Submitter column to the database schema that is auto-loaded during local environment setup.

Temporary Workaround:
Manually add the Submitter column to the local database schema as a workaround.
ALTER TABLE <table_name> ADD COLUMN submitter VARCHAR(<length>);

Additional Notes:

• This issue has been encountered and discussed in Community Batch Imports: add links between "Pending Imports" and "New Imports" pages for easier navigation. #10154 .
• Ensuring the column is included in the schema will improve local testing reliability for all contributors.

Requirements Checklist

• Identify tables missing the submitter column
• Add the submitter column to missing tables in the database schema

Related files

Stakeholders

• @rayb

---

Instructions for Contributors

• Please run these commands to ensure your repository is up to date before creating a new branch to work on this issue and each time after pushing code to Github, because the pre-commit bot may add commits to your PRs upstream.

[jimchamp]

The import_item table was recently altered to add a submitter column in production, but not in local development environments.

Databases in local instances are initially populated by running the queries in dev_db.pg_dump. To fix this issue, update the import_item DDL, adding a new text column named submitter.

To test if this has worked, stop the application, remove the openlibrary_ol-postgres volume, bring the application back up, then visit http://localhost:8080/import/batch/pending. If the page renders without error, the submitter column was added to import_item.

[ananyakaligal]

@jimchamp can i get this assigned?

[jimchamp]

Go for it, @ananyakaligal.