Hacktoberfest 2026:維護者為十月標記出來的 issue,仍然開放、適合新手。 瀏覽 Hacktoberfest issue

Give the Simulation Entrypoint its own simulation schema, migration chain and database connection

未關閉
#897 0 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視

維護者通常 1 天內回覆

@anth-volk 已經在處理了。

開始於 2026年10月22日。

  • #898 來自 @anth-volk —— 未關閉

評估

難度
5/5
預估耗時
一週以上
新手友好度
15/100
Issue 類型
功能
描述清晰度
描述清楚
活躍度
停滯
技術堆疊
postgresql, python, sqlalchemy

研究方向

Start by reading the Simulation Entrypoint deployment and readiness checks, the repository's migration ownership rules, and existing Alembic and PostgreSQL CI configuration. The issue names migrations/ as the chain location and SIMULATION_DATABASE_URL as the runtime setting; first confirm the staging and production roles, URLs, and grants have been created. Done means the entrypoint deploys with an empty simulation schema at its first revision, readiness reports that revision, the candidate check matches it to the image, and CI completes the upgrade, check, downgrade, and upgrade cycle.

由索引模型根據 Issue 內容生成。

描述

The Simulation Entrypoint will record simulations, reports, their runs and their results in its own Postgres schema, simulation, in the database that holds the Public API's v2 tables. Before any table can be added, the service needs the foundation:

  • a persistence library for that schema, with its own Alembic migration chain;
  • a migration job that applies the chain before each entrypoint deploy, using a separate migrator role;
  • the runtime role's database URL (SIMULATION_DATABASE_URL) mounted on the entrypoint as a pinned Secret Manager version;
  • the schema's applied revision reported by the readiness check, and required by the candidate check to match the image;
  • ownership rules in place of the rule that forbade any migration chain in this repository: one chain at migrations/, its version table in the simulation schema, the Modal executor and gateway independent of the library, and no database URL in Modal except the Stage 12 comparison path's own;
  • a CI job that runs the chain's upgrade, check, downgrade and upgrade cycle on PostgreSQL.

Once deployed, the entrypoint has a database connection and an empty simulation schema at its first revision; nothing reads or writes it yet. The database roles, URLs and grants must be created by an operator in staging and production first.

主要語言
Python
星號
1
分支
1
平均合併
1 天 17 小時
30 天內合併 PR
60

環境準備

從這裡開始

  1. 先讀完整個 Issue,再讀專案的貢獻指南。
  2. 在 Issue 下留言說明你要接手 —— 這能避免兩個人做同樣的事。
  3. Fork 儲存庫,在一個分支上完成修改。
  4. 送出 Pull Request,並在描述裡引用這個 Issue 編號。

PolicyEngine/policyengine-sim-api 的其他 Issue

查看 PolicyEngine/policyengine-sim-api 的全部 Issue

相似的 Issue

更多 Python Issue

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。