Skip to content

feat(evoai): add Evoai and EvoaiSetting tables with foreign key const… #1453

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.

Sign up for GitHub

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

Jump to bottom
Merged
merged 1 commit into from
May 15, 2025
Merged

feat(evoai): add Evoai and EvoaiSetting tables with foreign key const… #1453

merged 1 commit into from
May 15, 2025

Conversation

gomessguii
Copy link
Contributor

@gomessguii gomessguii commented May 15, 2025 •
edited by sourcery-ai bot
Loading

…raints

  • Created the Evoai and EvoaiSetting tables in the PostgreSQL migration.
  • Defined primary keys and added foreign key constraints to link with the Instance table.
  • Included unique index on instanceId for EvoaiSetting to ensure data integrity.

Summary by Sourcery

Add Evoai and EvoaiSetting tables with primary keys, foreign key constraints, and a uniqueness requirement for settings per instance

New Features:

  • Create Evoai table with AI configuration fields
  • Create EvoaiSetting table for per-instance settings

Enhancements:

  • Enforce unique instanceId on EvoaiSetting
  • Add foreign key constraints linking Evoai and EvoaiSetting to Instance
  • Add foreign key constraint from EvoaiSetting.evoaiIdFallback to Evoai

@gomessguii
feat(evoai): add Evoai and EvoaiSetting tables with foreign key const…
fda6b0d 
…raints

- Created the Evoai and EvoaiSetting tables in the PostgreSQL migration.
- Defined primary keys and added foreign key constraints to link with the Instance table.
- Included unique index on instanceId for EvoaiSetting to ensure data integrity.
@sourcery-ai Sourcery AI
Copy link
Contributor

sourcery-ai bot commented May 15, 2025 •
edited
Loading

Reviewer's Guide

This PR adds two new tables (Evoai and EvoaiSetting) via a PostgreSQL migration, defining their schemas with default values and timestamps, and enforces data integrity through a unique index and foreign key constraints linking to the existing Instance and Evoai tables.

File-Level Changes

Change Details Files
Create Evoai and EvoaiSetting tables with schemas
  • Define Evoai table with settings columns, defaults, and timestamps
  • Define EvoaiSetting table with fallback reference, settings columns, defaults, and timestamps
 prisma/postgresql-migrations/20250515211815_add_evoai_table/migration.sql
Add unique index to enforce one setting per instance
  • Create unique index on EvoaiSetting.instanceId
 prisma/postgresql-migrations/20250515211815_add_evoai_table/migration.sql
Establish foreign key constraints
  • Link Evoai.instanceId → Instance.id (cascade on delete/update)
  • Link EvoaiSetting.evoaiIdFallback → Evoai.id (set null on delete, cascade on update)
  • Link EvoaiSetting.instanceId → Instance.id (cascade on delete/update)
 prisma/postgresql-migrations/20250515211815_add_evoai_table/migration.sql
Tips and commands

Interacting with Sourcery

  • Trigger a new review: Comment @sourcery-ai review on the pull request.
  • Continue discussions: Reply directly to Sourcery's review comments.
  • Generate a GitHub issue from a review comment: Ask Sourcery to create an
    issue from a review comment by replying to it. You can also reply to a
    review comment with @sourcery-ai issue to create an issue from it.
  • Generate a pull request title: Write @sourcery-ai anywhere in the pull
    request title to generate a title at any time. You can also comment
    @sourcery-ai title on the pull request to (re-)generate the title at any time.
  • Generate a pull request summary: Write @sourcery-ai summary anywhere in
    the pull request body to generate a PR summary at any time exactly where you
    want it. You can also comment @sourcery-ai summary on the pull request to
    (re-)generate the summary at any time.
  • Generate reviewer's guide: Comment @sourcery-ai guide on the pull
    request to (re-)generate the reviewer's guide at any time.
  • Resolve all Sourcery comments: Comment @sourcery-ai resolve on the
    pull request to resolve all Sourcery comments. Useful if you've already
    addressed all the comments and don't want to see them anymore.
  • Dismiss all Sourcery reviews: Comment @sourcery-ai dismiss on the pull
    request to dismiss all existing Sourcery reviews. Especially useful if you
    want to start fresh with a new review - don't forget to comment
    @sourcery-ai review to trigger a new review!

Customizing Your Experience

Access your dashboard to:

  • Enable or disable review features such as the Sourcery-generated pull request
    summary, the reviewer's guide, and others.
  • Change the review language.
  • Add, remove or edit custom review instructions.
  • Adjust other review settings.

Getting Help

@DavidsonGomes DavidsonGomes merged commit 6a0b024 into EvolutionAPI:develop May 15, 2025
1 check passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
2 participants
@gomessguii @DavidsonGomes