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

created_at index for steps table #1301

Merged
merged 1 commit into from
Dec 2, 2024
Merged

created_at index for steps table #1301

merged 1 commit into from
Dec 2, 2024

Conversation

wintonzheng
Copy link
Contributor

@wintonzheng wintonzheng commented Dec 2, 2024

Important

Add created_at_org_index to steps table for optimized querying by created_at and organization_id.

  • Database Migration:
    • Adds Alembic migration 2024_12_02_1609-db41106b9f1a_steps_db_change_add_created_at_index.py to create created_at_org_index on steps table.
  • Models:
    • Updates StepModel in models.py to include created_at_org_index on created_at and organization_id.

This description was created by Ellipsis for 5dc1bc9. It will automatically update as commits are pushed.

Copy link
Contributor

@ellipsis-dev ellipsis-dev bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

👍 Looks good to me! Reviewed everything up to 5dc1bc9 in 9 seconds

More details
  • Looked at 52 lines of code in 2 files
  • Skipped 0 files when reviewing.
  • Skipped posting 1 drafted comments based on config settings.
1. alembic/versions/2024_12_02_1609-db41106b9f1a_steps_db_change_add_created_at_index.py:22
  • Draft comment:
    Ensure that the index name 'created_at_org_index' is unique across the database to avoid conflicts.
  • Reason this comment was not posted:
    Confidence changes required: 50%
    The PR adds an index on the 'created_at' and 'organization_id' columns in the 'steps' table. This is reflected in both the Alembic migration script and the SQLAlchemy model. The changes are consistent and correctly implemented.

Workflow ID: wflow_VJ1hozeH44tIQ8v4


You can customize Ellipsis with 👍 / 👎 feedback, review rules, user-specific overrides, quiet mode, and more.

@wintonzheng wintonzheng merged commit 04d5685 into main Dec 2, 2024
2 checks passed
@wintonzheng wintonzheng deleted the shu/add_steps_index branch December 2, 2024 17:25
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants