Accounts are string instead of int

[BerglundDaniel]

Summary by CodeRabbit

• Database and Model Adjustments

  • Changed the data type of account parameters and fields from integer to string for better data handling.
  • Updated database schema to modify account and cost_center fields, including the removal of the unique constraint and allowing null values for improved flexibility in data management.

• Bug Fixes

  • Adjusted foreign key constraints to prevent issues with null values and ensure database integrity.

[coderabbitai[bot]]

Walkthrough

The changes across the system involve a shift in the data type for account-related parameters from integers to strings, and a relaxation of the database schema to allow null values for certain accounting fields. This reflects a broader update to the system's handling of account and cost center identifiers, impacting both the database layer with updated field types and constraints, as well as the application layer where account parameters are processed.

Changes

File Path	Change Summary
api/src/firstrun.py	Changed account parameter from integer to string by wrapping 4000 + account_id with str().
api/src/migrations/.../account_cost_center.sql	Altered data types for account and cost_center to strings, removed NOT NULL UNIQUE constraint, allowed nulls for account_id and cost_center_id.
api/src/shop/models.py	Updated account and cost_center fields from integer to string; adjusted foreign keys to allow nulls.

Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on X ?

---

Tips

### Chat with CodeRabbit Bot (`@coderabbitai`) - You can directly reply to a review comment made by CodeRabbit. Example: - _I pushed a fix in commit ``._ - You can tag CodeRabbit on specific lines of code or entire files in the PR by tagging `@coderabbitai` in a comment. Examples: - _@coderabbitai generate unit tests for this file_ - _@coderabbitai modularize this function_ - You can tag `@coderabbitai` in a PR comment and ask questions about the PR and the codebase. Use quoted replies to pass the context for follow-up questions. Examples: - _@coderabbitai render interesting statistics about this repository as a table_. - _@coderabbitai show all the `console.log` statements in this repository_. - _@coderabbitai generate unit tests for the `src/utils.ts` file_. ### CodeRabbit Commands (invoked as PR comments) - `@coderabbitai pause` to pause the reviews on a PR. - `@coderabbitai resume` to resume the paused reviews. - `@coderabbitai review` to trigger a review. This is useful when automatic reviews are disabled for the repository. - `@coderabbitai resolve` resolve all the CodeRabbit review comments. - `@coderabbitai help` to get help. Additionally, you can add `@coderabbitai ignore` anywhere in the PR description to prevent this PR from being reviewed. ### CodeRabbit Configration File (`.coderabbit.yaml`) - You can programmatically configure CodeRabbit by adding a `.coderabbit.yaml` file to the root of your repository. - The JSON schema for the configuration file is available [here](https://coderabbit.ai/integrations/coderabbit-overrides.v2.json). - If your editor has YAML language server enabled, you can add the path at the top of this file to enable auto-completion and validation: `# yaml-language-server: $schema=https://coderabbit.ai/integrations/coderabbit-overrides.v2.json` ### CodeRabbit Discord Community Join our [Discord Community](https://discord.com/invite/GsXnASn26c) to get help, request features, and share feedback.