vespertide

Category: Data & AI | Uploader: dev-five-git | Downloads: 0 | Version: v1.0（Latest）

Define database schemas in JSON and generate migration plans. Use this skill when creating or modifying database models, defining tables with columns, constraints, and ENUM types for Vespertide-based projects.

Changelog: Source: GitHub https://github.com/dev-five-git/vespertide

Directory Structure

Current level: tree/main/

📁 .changepacks/
- 📄 config.json 168 B
📁 .github/
- 📁 workflows/
  - 📄 CI.yml 2.3 KB
- 📄 FUNDING.yml 41 B
📁 crates/
- 📁 vespertide/
  - 📁 src/
    
    📄 lib.rs 222 B
    
    📄 runtime.rs 13.5 KB
  - 📄 Cargo.toml 676 B
- 📁 vespertide-cli/
  - 📁 src/
    
    📁 commands/
    
    📄 diff.rs 20.9 KB
    
    📄 export.rs 30.4 KB
    
    📄 init.rs 1.8 KB
    
    📄 log.rs 9.3 KB
    
    📄 mod.rs 320 B
    
    📄 new.rs 7.2 KB
    
    📄 revision.rs 114.9 KB
    
    📄 sql.rs 15.5 KB
    
    📄 status.rs 10.5 KB
    
    📄 main.rs 4.3 KB
    
    📄 utils.rs 9.9 KB
  - 📁 tests/
    
    📄 integration_test.rs 2.3 KB
  - 📄 .gitignore 28 B
  - 📄 AGENTS.md 2.7 KB
  - 📄 Cargo.toml 1.2 KB
  - 📄 CLAUDE.md 11 B
  - 📄 vespertide.json 250 B
- 📁 vespertide-config/
  - 📁 src/
    
    📄 config.rs 7.1 KB
    
    📄 file_format.rs 559 B
    
    📄 lib.rs 3.2 KB
    
    📄 name_case.rs 1.2 KB
  - 📄 Cargo.toml 573 B
- 📁 vespertide-core/
  - 📁 src/
    
    📁 schema/
    
    📄 column.rs 34.4 KB
    
    📄 constraint.rs 6.1 KB
    
    📄 foreign_key.rs 1.4 KB
    
    📄 index.rs 356 B
    
    📄 mod.rs 574 B
    
    📄 names.rs 88 B
    
    📄 primary_key.rs 525 B
    
    📄 reference.rs 298 B
    
    📄 str_or_bool.rs 4.9 KB
    
    📄 table.rs 62.7 KB
    
    📄 action.rs 35.9 KB
    
    📄 lib.rs 428 B
    
    📄 migration.rs 514 B
  - 📄 AGENTS.md 2.6 KB
  - 📄 Cargo.toml 564 B
  - 📄 CLAUDE.md 11 B
- 📁 vespertide-exporter/
  - 📁 src/
    
    📁 jpa/
    
    📁 snapshots/
    
    📄 vespertide_exporter__jpa__tests__basic_table.snap 582 B
    
    📄 vespertide_exporter__jpa__tests__fk_with_comment_and_auto_increment.snap 513 B
    
    📄 vespertide_exporter__jpa__tests__nullable_columns.snap 472 B
    
    📄 vespertide_exporter__jpa__tests__server_default_and_true_boolean.snap 684 B
    
    📄 vespertide_exporter__jpa__tests__table_with_all_simple_types.snap 2.0 KB
    
    📄 vespertide_exporter__jpa__tests__table_with_complex_types.snap 725 B
    
    📄 vespertide_exporter__jpa__tests__table_with_composite_constraints.snap 764 B
    
    📄 vespertide_exporter__jpa__tests__table_with_defaults.snap 605 B
    
    📄 vespertide_exporter__jpa__tests__table_with_enum.snap 486 B
    
    📄 vespertide_exporter__jpa__tests__table_with_foreign_key.snap 609 B
    
    📄 vespertide_exporter__jpa__tests__table_with_integer_enum.snap 550 B
    
    📄 vespertide_exporter__jpa__tests__unnamed_index_and_unique.snap 575 B
    
    📄 mod.rs 41.2 KB
    
    📁 seaorm/
    
    📁 snapshots/
    
    📄 vespertide_exporter__seaorm__helper_tests__render_enum_snapshots@integer_color.snap 334 B
    
    📄 vespertide_exporter__seaorm__helper_tests__render_enum_snapshots@integer_status.snap 354 B
    
    📄 vespertide_exporter__seaorm__helper_tests__render_enum_snapshots@string_numeric_prefix.snap 482 B
    
    📄 vespertide_exporter__seaorm__helper_tests__render_enum_snapshots@string_order_status.snap 498 B
    
    📄 vespertide_exporter__seaorm__tests__integer_enum_default_value_snapshots@1.snap 774 B
    
    📄 vespertide_exporter__seaorm__tests__integer_enum_default_value_snapshots@pending_status.snap 774 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_basic_single_pk.snap 438 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_composite_pk.snap 506 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_enum_multiple_columns.snap 1.4 KB
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_enum_nullable.snap 933 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_enum_shared.snap 930 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_enum_special_values.snap 973 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_enum_type.snap 887 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_enum_with_default.snap 1.0 KB
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_fk_composite.snap 613 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_fk_single.snap 553 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_inline_pk.snap 461 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_jsonb_custom_type.snap 576 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_pk_and_fk_together.snap 1.0 KB
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_table_level_pk.snap 450 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_snapshots@params_unique_and_indexed.snap 720 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_composite_fk_parent.snap 657 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_many_to_many_article.snap 599 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_many_to_many_missing_target.snap 490 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_many_to_many_multiple_junctions.snap 919 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_many_to_many_user.snap 600 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_multiple_fk_same_table.snap 752 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_multiple_has_one_relations.snap 660 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_multiple_reverse_relations.snap 669 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_not_junction_fk_not_in_pk_another.snap 490 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_not_junction_fk_not_in_pk_other.snap 486 B
    
    📄 vespertide_exporter__seaorm__tests__render_entity_with_schema_snapshots@schema_not_junction_single_pk.snap 476 B
    
    📄 mod.rs 126.1 KB
    
    📁 snapshots/
    
    📄 vespertide_exporter__orm__tests__render_entity_snapshots@jpa.snap 253 B
    
    📄 vespertide_exporter__orm__tests__render_entity_snapshots@seaorm.snap 398 B
    
    📄 vespertide_exporter__orm__tests__render_entity_snapshots@sqlalchemy.snap 338 B
    
    📄 vespertide_exporter__orm__tests__render_entity_snapshots@sqlmodel.snap 258 B
    
    📄 vespertide_exporter__orm__tests__render_entity_with_schema_snapshots@jpa.snap 253 B
    
    📄 vespertide_exporter__orm__tests__render_entity_with_schema_snapshots@seaorm.snap 398 B
    
    📄 vespertide_exporter__orm__tests__render_entity_with_schema_snapshots@sqlalchemy.snap 338 B
    
    📄 vespertide_exporter__orm__tests__render_entity_with_schema_snapshots@sqlmodel.snap 258 B
    
    📁 sqlalchemy/
    
    📁 snapshots/
    
    📄 vespertide_exporter__sqlalchemy__tests__basic_table.snap 592 B
    
    📄 vespertide_exporter__sqlalchemy__tests__table_with_enum.snap 557 B
    
    📄 vespertide_exporter__sqlalchemy__tests__table_with_foreign_key.snap 511 B
    
    📄 vespertide_exporter__sqlalchemy__tests__table_with_indexes.snap 668 B
    
    📄 vespertide_exporter__sqlalchemy__tests__table_with_integer_enum.snap 507 B
    
    📄 mod.rs 51.2 KB
    
    📁 sqlmodel/
    
    📁 snapshots/
    
    📄 vespertide_exporter__sqlmodel__tests__basic_table.snap 443 B
    
    📄 vespertide_exporter__sqlmodel__tests__table_with_default_values.snap 485 B
    
    📄 vespertide_exporter__sqlmodel__tests__table_with_enum.snap 423 B
    
    📄 vespertide_exporter__sqlmodel__tests__table_with_foreign_key.snap 337 B
    
    📄 vespertide_exporter__sqlmodel__tests__table_with_indexes.snap 376 B
    
    📄 vespertide_exporter__sqlmodel__tests__table_with_integer_enum.snap 389 B
    
    📄 mod.rs 46.2 KB
    
    📄 lib.rs 458 B
    
    📄 orm.rs 3.6 KB
  - 📄 AGENTS.md 2.3 KB
  - 📄 Cargo.toml 600 B
  - 📄 CLAUDE.md 11 B
- 📁 vespertide-loader/
  - 📁 src/
    
    📄 config.rs 5.0 KB
    
    📄 lib.rs 311 B
    
    📄 migrations.rs 14.6 KB
    
    📄 models.rs 19.2 KB
  - 📄 Cargo.toml 511 B
- 📁 vespertide-macro/
  - 📁 src/
    
    📄 lib.rs 37.0 KB
  - 📄 Cargo.toml 727 B
- 📁 vespertide-naming/
  - 📁 src/
    
    📄 lib.rs 17.4 KB
  - 📄 Cargo.toml 296 B
- 📁 vespertide-planner/
  - 📁 src/
    
    📁 snapshots/
    
    📄 vespertide_planner__diff__tests__diff_tables__create_table_with_inline_index-2.snap 262 B
    
    📄 vespertide_planner__diff__tests__diff_tables__create_table_with_inline_index.snap 1.3 KB
    
    📄 vespertide_planner__diff__tests__diff_tables__diff_tables@add_index.snap 257 B
    
    📄 vespertide_planner__diff__tests__diff_tables__diff_tables@add_named_index.snap 297 B
    
    📄 vespertide_planner__diff__tests__diff_tables__diff_tables@remove_index.snap 260 B
    
    📄 vespertide_planner__diff__tests__diff_tables__diff_tables@remove_named_index.snap 300 B
    
    📄 apply.rs 52.5 KB
    
    📄 diff.rs 180.5 KB
    
    📄 error.rs 2.3 KB
    
    📄 lib.rs 452 B
    
    📄 plan.rs 3.0 KB
    
    📄 schema.rs 8.4 KB
    
    📄 validate.rs 85.6 KB
  - 📄 AGENTS.md 2.0 KB
  - 📄 Cargo.toml 490 B
  - 📄 CLAUDE.md 11 B
- 📁 vespertide-query/
  - 📁 src/
    
    📁 snapshots/
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_index_pair@add_col_pair_fk_ix_mysql.snap 878 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_index_pair@add_col_pair_fk_ix_postgres.snap 878 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_index_pair@add_col_pair_fk_ix_sqlite.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_index_pair@add_col_pair_ix_fk_mysql.snap 878 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_index_pair@add_col_pair_ix_fk_postgres.snap 878 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_index_pair@add_col_pair_ix_fk_sqlite.snap 1.1 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_unique_pair@add_col_pair_fk_uq_mysql.snap 886 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_unique_pair@add_col_pair_fk_uq_postgres.snap 886 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_unique_pair@add_col_pair_fk_uq_sqlite.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_unique_pair@add_col_pair_uq_fk_mysql.snap 886 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_unique_pair@add_col_pair_uq_fk_postgres.snap 886 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_and_unique_pair@add_col_pair_uq_fk_sqlite.snap 1.1 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_no_duplicate_fk_in_temp_table@dup_fk_mysql.snap 916 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_no_duplicate_fk_in_temp_table@dup_fk_postgres.snap 916 B
    
    📄 vespertide_query__builder__tests__add_column_with_fk_no_duplicate_fk_in_temp_table@dup_fk_sqlite.snap 1.8 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_fk_ix_uq_mysql.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_fk_ix_uq_postgres.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_fk_ix_uq_sqlite.snap 1.2 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_fk_uq_ix_mysql.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_fk_uq_ix_postgres.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_fk_uq_ix_sqlite.snap 1.2 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_ix_fk_uq_mysql.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_ix_fk_uq_postgres.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_ix_fk_uq_sqlite.snap 1.3 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_ix_uq_fk_mysql.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_ix_uq_fk_postgres.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_ix_uq_fk_sqlite.snap 1.3 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_uq_fk_ix_mysql.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_uq_fk_ix_postgres.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_uq_fk_ix_sqlite.snap 1.3 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_uq_ix_fk_mysql.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_uq_ix_fk_postgres.snap 1.0 KB
    
    📄 vespertide_query__builder__tests__add_column_with_fk_unique_index_all_orderings@add_col_uq_ix_fk_sqlite.snap 1.3 KB
    
    📄 vespertide_query__builder__tests__delete_column_after_create_table_with_inline_index@inline_index_mysql.snap 111 B
    
    📄 vespertide_query__builder__tests__delete_column_after_create_table_with_inline_index@inline_index_postgres.snap 111 B
    
    📄 vespertide_query__builder__tests__delete_column_after_create_table_with_inline_index@inline_index_sqlite.snap 141 B
    
    📄 vespertide_query__builder__tests__delete_column_after_create_table_with_inline_unique@inline_unique_mysql.snap 114 B
    
    📄 vespertide_query__builder__tests__delete_column_after_create_table_with_inline_unique@inline_unique_postgres.snap 114 B
    
    📄 vespertide_query__builder__tests__delete_column_after_create_table_with_inline_unique@inline_unique_sqlite.snap 147 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_fk_ix_uq_mysql.snap 792 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_fk_ix_uq_postgres.snap 756 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_fk_ix_uq_sqlite.snap 1.2 KB
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_fk_uq_ix_mysql.snap 792 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_fk_uq_ix_postgres.snap 756 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_fk_uq_ix_sqlite.snap 1.3 KB
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_ix_fk_uq_mysql.snap 792 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_ix_fk_uq_postgres.snap 756 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_ix_fk_uq_sqlite.snap 1.2 KB
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_ix_uq_fk_mysql.snap 792 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_ix_uq_fk_postgres.snap 756 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_ix_uq_fk_sqlite.snap 1.2 KB
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_uq_fk_ix_mysql.snap 792 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_uq_fk_ix_postgres.snap 756 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_uq_fk_ix_sqlite.snap 1.3 KB
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_uq_ix_fk_mysql.snap 792 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_uq_ix_fk_postgres.snap 756 B
    
    📄 vespertide_query__builder__tests__remove_fk_unique_index_then_drop_column_all_orderings@rm_col_uq_ix_fk_sqlite.snap 1.2 KB
    
    📁 sql/
    
    📁 snapshots/
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_nullable_mysql.snap 199 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_nullable_postgres.snap 199 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_nullable_sqlite.snap 199 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_simple_mysql.snap 202 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_simple_postgres.snap 202 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_simple_sqlite.snap 202 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_with_backfill_mysql.snap 295 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_with_backfill_postgres.snap 328 B
    
    📄 vespertide_query__sql__add_column__tests__add_column@add_column_add_column_with_backfill_sqlite.snap 381 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_enum_non_nullable_with_default@enum_non_nullable_with_default_MySql.snap 184 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_enum_non_nullable_with_default@enum_non_nullable_with_default_Postgres.snap 237 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_enum_non_nullable_with_default@enum_non_nullable_with_default_Sqlite.snap 416 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_empty_string_default@empty_string_default_MySql.snap 145 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_empty_string_default@empty_string_default_Postgres.snap 145 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_empty_string_default@empty_string_default_Sqlite.snap 319 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_enum_type@add_column_with_enum_type_MySql.snap 147 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_enum_type@add_column_with_enum_type_Postgres.snap 200 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_enum_type@add_column_with_enum_type_Sqlite.snap 375 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_fill_with_empty_string@fill_with_empty_string_MySql.snap 221 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_fill_with_empty_string@fill_with_empty_string_Postgres.snap 254 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_fill_with_empty_string@fill_with_empty_string_Sqlite.snap 308 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_pg_type_cast_default@pg_type_cast_default_MySql.snap 166 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_pg_type_cast_default@pg_type_cast_default_Postgres.snap 158 B
    
    📄 vespertide_query__sql__add_column__tests__add_column_with_pg_type_cast_default@pg_type_cast_default_Sqlite.snap 346 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_check_named_mysql.snap 220 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_check_named_postgres.snap 220 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_check_named_sqlite.snap 394 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_foreign_key_mysql.snap 301 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_foreign_key_postgres.snap 301 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_foreign_key_sqlite.snap 459 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_primary_key_mysql.snap 202 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_primary_key_postgres.snap 202 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_primary_key_sqlite.snap 382 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_unique_named_mysql.snap 221 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_unique_named_postgres.snap 221 B
    
    📄 vespertide_query__sql__add_constraint__tests__add_constraint@add_constraint_add_constraint_unique_named_sqlite.snap 221 B
    
    📄 vespertide_query__sql__create_table__tests__create_table@create_table_create_table_mysql.snap 114 B
    
    📄 vespertide_query__sql__create_table__tests__create_table@create_table_create_table_postgres.snap 118 B
    
    📄 vespertide_query__sql__create_table__tests__create_table@create_table_create_table_sqlite.snap 118 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_auto_increment_primary_key@create_table_with_auto_increment_MySql.snap 158 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_auto_increment_primary_key@create_table_with_auto_increment_Postgres.snap 146 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_auto_increment_primary_key@create_table_with_auto_increment_Sqlite.snap 153 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_enum_column@create_table_with_enum_column_MySql.snap 219 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_enum_column@create_table_with_enum_column_Postgres.snap 276 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_enum_column@create_table_with_enum_column_Sqlite.snap 281 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_inline_auto_increment_primary_key@create_table_with_inline_auto_increment_MySql.snap 158 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_inline_auto_increment_primary_key@create_table_with_inline_auto_increment_Postgres.snap 146 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_inline_auto_increment_primary_key@create_table_with_inline_auto_increment_Sqlite.snap 153 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_inline_unique@create_table_with_inline_unique_MySql.snap 168 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_inline_unique@create_table_with_inline_unique_Postgres.snap 191 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_inline_unique@create_table_with_inline_unique_Sqlite.snap 191 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_table_level_unique@create_table_with_table_level_unique_MySql.snap 171 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_table_level_unique@create_table_with_table_level_unique_Postgres.snap 194 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_table_level_unique@create_table_with_table_level_unique_Sqlite.snap 194 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_table_level_unique_no_name@create_table_with_table_level_unique_no_name_MySql.snap 168 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_table_level_unique_no_name@create_table_with_table_level_unique_no_name_Postgres.snap 191 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_table_level_unique_no_name@create_table_with_table_level_unique_no_name_Sqlite.snap 191 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_timestamp_now_default@create_table_with_timestamp_now_default_MySql.snap 186 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_timestamp_now_default@create_table_with_timestamp_now_default_Postgres.snap 201 B
    
    📄 vespertide_query__sql__create_table__tests__create_table_with_timestamp_now_default@create_table_with_timestamp_now_default_Sqlite.snap 205 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column@delete_column_delete_column_mysql.snap 121 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column@delete_column_delete_column_postgres.snap 121 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column@delete_column_delete_column_sqlite.snap 121 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_fk_and_index_constraints@delete_column_with_fk_and_index_mysql.snap 124 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_fk_and_index_constraints@delete_column_with_fk_and_index_postgres.snap 124 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_fk_and_index_constraints@delete_column_with_fk_and_index_sqlite.snap 409 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_fk_constraint@delete_column_with_fk_mysql.snap 124 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_fk_constraint@delete_column_with_fk_postgres.snap 124 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_fk_constraint@delete_column_with_fk_sqlite.snap 287 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_index_constraint@delete_column_with_index_mysql.snap 126 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_index_constraint@delete_column_with_index_postgres.snap 126 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_index_constraint@delete_column_with_index_sqlite.snap 161 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_pk_constraint@delete_column_with_pk_mysql.snap 132 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_pk_constraint@delete_column_with_pk_postgres.snap 132 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_pk_constraint@delete_column_with_pk_sqlite.snap 344 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_unique_constraint@delete_column_with_unique_mysql.snap 121 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_unique_constraint@delete_column_with_unique_postgres.snap 121 B
    
    📄 vespertide_query__sql__delete_column__tests__delete_column_with_unique_constraint@delete_column_with_unique_sqlite.snap 151 B
    
    📄 vespertide_query__sql__delete_table__tests__delete_table@delete_table_delete_table_mysql.snap 99 B
    
    📄 vespertide_query__sql__delete_table__tests__delete_table@delete_table_delete_table_postgres.snap 99 B
    
    📄 vespertide_query__sql__delete_table__tests__delete_table@delete_table_delete_table_sqlite.snap 99 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__build_modify_column_comment@mysql_drop_comment_users.snap 136 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__build_modify_column_comment@mysql_set_comment_users.snap 165 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__build_modify_column_comment@postgres_drop_comment_users.snap 131 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__build_modify_column_comment@postgres_set_comment_users.snap 147 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__build_modify_column_comment@sqlite_drop_comment_users.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__build_modify_column_comment@sqlite_set_comment_users.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__change_comment@mysql_change_comment.snap 158 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__change_comment@postgres_change_comment.snap 140 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__change_comment@sqlite_change_comment.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@mysql_boolean_comment.snap 169 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@mysql_integer_comment.snap 171 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@mysql_timestamp_comment.snap 178 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@postgres_boolean_comment.snap 142 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@postgres_integer_comment.snap 145 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@postgres_timestamp_comment.snap 146 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@sqlite_boolean_comment.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@sqlite_integer_comment.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_different_types@sqlite_timestamp_comment.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_not_null_column@mysql_not_null_column.snap 176 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_not_null_column@postgres_not_null_column.snap 149 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_on_not_null_column@sqlite_not_null_column.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_with_quotes@mysql_comment_with_quotes.snap 168 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_with_quotes@postgres_comment_with_quotes.snap 150 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__comment_with_quotes@sqlite_comment_with_quotes.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__drop_existing_comment@mysql_drop_existing_comment.snap 136 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__drop_existing_comment@postgres_drop_existing_comment.snap 131 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__drop_existing_comment@sqlite_drop_existing_comment.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__long_comment@mysql_long_comment.snap 302 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__long_comment@postgres_long_comment.snap 284 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__long_comment@sqlite_long_comment.snap 90 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__preserves_column_properties@mysql_preserves_properties.snap 195 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__preserves_column_properties@postgres_preserves_properties.snap 147 B
    
    📄 vespertide_query__sql__modify_column_comment__tests__preserves_column_properties@sqlite_preserves_properties.snap 90 B
    
    📄 vespertide_query__sql__modify_column_default__tests__boolean_default@mysql_boolean_default.snap 162 B
    
    📄 vespertide_query__sql__modify_column_default__tests__boolean_default@postgres_boolean_default.snap 151 B
    
    📄 vespertide_query__sql__modify_column_default__tests__boolean_default@sqlite_boolean_default.snap 329 B
    
    📄 vespertide_query__sql__modify_column_default__tests__build_modify_column_default@mysql_drop_default_users.snap 136 B
    
    📄 vespertide_query__sql__modify_column_default__tests__build_modify_column_default@mysql_set_default_users.snap 154 B
    
    📄 vespertide_query__sql__modify_column_default__tests__build_modify_column_default@postgres_drop_default_users.snap 143 B
    
    📄 vespertide_query__sql__modify_column_default__tests__build_modify_column_default@postgres_set_default_users.snap 152 B
    
    📄 vespertide_query__sql__modify_column_default__tests__build_modify_column_default@sqlite_drop_default_users.snap 292 B
    
    📄 vespertide_query__sql__modify_column_default__tests__build_modify_column_default@sqlite_set_default_users.snap 310 B
    
    📄 vespertide_query__sql__modify_column_default__tests__change_default_value@mysql_change_default.snap 162 B
    
    📄 vespertide_query__sql__modify_column_default__tests__change_default_value@postgres_change_default.snap 160 B
    
    📄 vespertide_query__sql__modify_column_default__tests__change_default_value@sqlite_change_default.snap 318 B
    
    📄 vespertide_query__sql__modify_column_default__tests__drop_existing_default@mysql_drop_existing_default.snap 147 B
    
    📄 vespertide_query__sql__modify_column_default__tests__drop_existing_default@postgres_drop_existing_default.snap 145 B
    
    📄 vespertide_query__sql__modify_column_default__tests__drop_existing_default@sqlite_drop_existing_default.snap 310 B
    
    📄 vespertide_query__sql__modify_column_default__tests__function_default@mysql_function_default.snap 182 B
    
    📄 vespertide_query__sql__modify_column_default__tests__function_default@postgres_function_default.snap 154 B
    
    📄 vespertide_query__sql__modify_column_default__tests__function_default@sqlite_function_default.snap 358 B
    
    📄 vespertide_query__sql__modify_column_default__tests__integer_default@mysql_integer_default.snap 160 B
    
    📄 vespertide_query__sql__modify_column_default__tests__integer_default@postgres_integer_default.snap 150 B
    
    📄 vespertide_query__sql__modify_column_default__tests__integer_default@sqlite_integer_default.snap 341 B
    
    📄 vespertide_query__sql__modify_column_default__tests__modify_default_with_index@mysql_with_index.snap 166 B
    
    📄 vespertide_query__sql__modify_column_default__tests__modify_default_with_index@postgres_with_index.snap 164 B
    
    📄 vespertide_query__sql__modify_column_default__tests__modify_default_with_index@sqlite_with_index.snap 384 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@mysql_not_null_users.snap 146 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@mysql_not_null_users_with_fill.snap 207 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@mysql_nullable_users.snap 137 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@postgres_not_null_users.snap 144 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@postgres_not_null_users_with_fill.snap 205 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@postgres_nullable_users.snap 145 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@sqlite_not_null_users.snap 302 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@sqlite_not_null_users_with_fill.snap 363 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__build_modify_column_nullable@sqlite_nullable_users.snap 293 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__delete_null_rows@mysql_delete_null_rows.snap 193 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__delete_null_rows@postgres_delete_null_rows.snap 192 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__delete_null_rows@sqlite_delete_null_rows.snap 362 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__fill_with_now_converted_to_current_timestamp@mysql_fill_now.snap 228 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__fill_with_now_converted_to_current_timestamp@postgres_fill_now.snap 221 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__fill_with_now_converted_to_current_timestamp@sqlite_fill_now.snap 412 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__modify_nullable_with_index@mysql_with_index.snap 146 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__modify_nullable_with_index@postgres_with_index.snap 144 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__modify_nullable_with_index@sqlite_with_index.snap 358 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__with_default_value@mysql_with_default.snap 176 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__with_default_value@postgres_with_default.snap 144 B
    
    📄 vespertide_query__sql__modify_column_nullable__tests__with_default_value@sqlite_with_default.snap 332 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type@modify_column_type_modify_column_type_mysql.snap 138 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type@modify_column_type_modify_column_type_postgres.snap 142 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type@modify_column_type_modify_column_type_sqlite.snap 293 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_fill_with@modify_column_type_with_fill_with_fill_with_enum_change_mysql.snap 224 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_fill_with@modify_column_type_with_fill_with_fill_with_enum_change_postgres.snap 406 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_fill_with@modify_column_type_with_fill_with_fill_with_enum_change_sqlite.snap 408 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_index@modify_column_type_with_index_modify_column_type_with_index_mysql.snap 133 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_index@modify_column_type_with_index_modify_column_type_with_index_postgres.snap 137 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_index@modify_column_type_with_index_modify_column_type_with_index_sqlite.snap 341 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_unique_constraint@modify_column_type_with_unique_constraint_modify_column_type_with_unique_constraint_mysql.snap 141 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_unique_constraint@modify_column_type_with_unique_constraint_modify_column_type_with_unique_constraint_postgres.snap 145 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_column_type_with_unique_constraint@modify_column_type_with_unique_constraint_modify_column_type_with_unique_constraint_sqlite.snap 363 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_name_changed_mysql.snap 159 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_name_changed_postgres.snap 286 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_name_changed_sqlite.snap 340 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_same_values_mysql.snap 156 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_same_values_postgres.snap 146 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_same_values_sqlite.snap 340 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_to_text_mysql.snap 135 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_to_text_postgres.snap 169 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_to_text_sqlite.snap 260 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_values_changed_mysql.snap 167 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_values_changed_postgres.snap 349 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_enum_values_changed_sqlite.snap 351 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_text_to_enum_mysql.snap 158 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_text_to_enum_postgres.snap 215 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_types@modify_enum_types_text_to_enum_sqlite.snap 340 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_with_default_value@modify_enum_with_default_modify_enum_with_default_mysql.snap 212 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_with_default_value@modify_enum_with_default_modify_enum_with_default_postgres.snap 648 B
    
    📄 vespertide_query__sql__modify_column_type__tests__modify_enum_with_default_value@modify_enum_with_default_modify_enum_with_default_sqlite.snap 480 B
    
    📄 vespertide_query__sql__raw_sql__tests__raw_sql@raw_sql_raw_sql_action_mysql.snap 84 B
    
    📄 vespertide_query__sql__raw_sql__tests__raw_sql@raw_sql_raw_sql_action_postgres.snap 84 B
    
    📄 vespertide_query__sql__raw_sql__tests__raw_sql@raw_sql_raw_sql_action_sqlite.snap 84 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_check_named_mysql.snap 203 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_check_named_postgres.snap 208 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_check_named_sqlite.snap 362 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_foreign_key_named_mysql.snap 219 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_foreign_key_named_postgres.snap 218 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_foreign_key_named_sqlite.snap 374 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_primary_key_mysql.snap 199 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_primary_key_postgres.snap 211 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_primary_key_sqlite.snap 333 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_unique_named_mysql.snap 214 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_unique_named_postgres.snap 194 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint@remove_constraint_remove_constraint_unique_named_sqlite.snap 333 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_index@remove_check_with_index_MySql.snap 126 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_index@remove_check_with_index_Postgres.snap 131 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_index@remove_check_with_index_Sqlite.snap 337 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_other_constraints@remove_check_with_other_constraints_MySql.snap 126 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_other_constraints@remove_check_with_other_constraints_Postgres.snap 131 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_other_constraints@remove_check_with_other_constraints_Sqlite.snap 363 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_unique_constraint@remove_check_with_unique_constraint_MySql.snap 126 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_unique_constraint@remove_check_with_unique_constraint_Postgres.snap 131 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_check_with_unique_constraint@remove_check_with_unique_constraint_Sqlite.snap 343 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_index@remove_foreign_key_with_index_MySql.snap 142 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_index@remove_foreign_key_with_index_Postgres.snap 141 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_index@remove_foreign_key_with_index_Sqlite.snap 357 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_other_constraints@remove_foreign_key_with_other_constraints_MySql.snap 142 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_other_constraints@remove_foreign_key_with_other_constraints_Postgres.snap 141 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_other_constraints@remove_foreign_key_with_other_constraints_Sqlite.snap 429 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_unique_constraint@remove_foreign_key_with_unique_constraint_MySql.snap 142 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_unique_constraint@remove_foreign_key_with_unique_constraint_Postgres.snap 141 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_with_unique_constraint@remove_foreign_key_with_unique_constraint_Sqlite.snap 363 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_without_name@remove_foreign_key_without_name_MySql.snap 142 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_without_name@remove_foreign_key_without_name_Postgres.snap 141 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_foreign_key_without_name@remove_foreign_key_without_name_Sqlite.snap 297 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_index_with_custom_inline_name@remove_index_custom_name_MySql.snap 136 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_index_with_custom_inline_name@remove_index_custom_name_Postgres.snap 125 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_index_with_custom_inline_name@remove_index_custom_name_Sqlite.snap 125 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_primary_key_with_index@remove_primary_key_with_index_MySql.snap 122 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_primary_key_with_index@remove_primary_key_with_index_Postgres.snap 134 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_primary_key_with_index@remove_primary_key_with_index_Sqlite.snap 306 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_primary_key_with_unique_constraint@remove_primary_key_with_unique_constraint_MySql.snap 122 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_primary_key_with_unique_constraint@remove_primary_key_with_unique_constraint_Postgres.snap 134 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_primary_key_with_unique_constraint@remove_primary_key_with_unique_constraint_Sqlite.snap 318 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_index@remove_unique_with_index_MySql.snap 137 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_index@remove_unique_with_index_Postgres.snap 117 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_index@remove_unique_with_index_Sqlite.snap 338 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_other_constraints@remove_unique_with_other_constraints_MySql.snap 137 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_other_constraints@remove_unique_with_other_constraints_Postgres.snap 117 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_other_constraints@remove_unique_with_other_constraints_Sqlite.snap 358 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_other_unique_constraint@remove_unique_with_other_unique_constraint_MySql.snap 137 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_other_unique_constraint@remove_unique_with_other_unique_constraint_Postgres.snap 117 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_with_other_unique_constraint@remove_unique_with_other_unique_constraint_Sqlite.snap 348 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_without_name@remove_unique_without_name_MySql.snap 134 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_without_name@remove_unique_without_name_Postgres.snap 114 B
    
    📄 vespertide_query__sql__remove_constraint__tests__remove_constraint_unique_without_name@remove_unique_without_name_Sqlite.snap 288 B
    
    📄 vespertide_query__sql__rename_column__tests__rename_column@rename_column_rename_column_mysql.snap 142 B
    
    📄 vespertide_query__sql__rename_column__tests__rename_column@rename_column_rename_column_postgres.snap 142 B
    
    📄 vespertide_query__sql__rename_column__tests__rename_column@rename_column_rename_column_sqlite.snap 142 B
    
    📄 vespertide_query__sql__rename_table__tests__rename_table@rename_table_rename_table_action_mysql.snap 115 B
    
    📄 vespertide_query__sql__rename_table__tests__rename_table@rename_table_rename_table_action_postgres.snap 121 B
    
    📄 vespertide_query__sql__rename_table__tests__rename_table@rename_table_rename_table_action_sqlite.snap 121 B
    
    📄 vespertide_query__sql__tests__add_index_with_custom_name@add_index_custom_email_idx_MySql.snap 125 B
    
    📄 vespertide_query__sql__tests__add_index_with_custom_name@add_index_custom_email_idx_Postgres.snap 125 B
    
    📄 vespertide_query__sql__tests__add_index_with_custom_name@add_index_custom_email_idx_Sqlite.snap 125 B
    
    📄 vespertide_query__sql__tests__add_index_with_custom_name@add_index_custom_hello_MySql.snap 133 B
    
    📄 vespertide_query__sql__tests__add_index_with_custom_name@add_index_custom_hello_Postgres.snap 133 B
    
    📄 vespertide_query__sql__tests__add_index_with_custom_name@add_index_custom_hello_Sqlite.snap 133 B
    
    📄 vespertide_query__sql__tests__add_unique_with_custom_name@add_unique_custom_email_unique_MySql.snap 135 B
    
    📄 vespertide_query__sql__tests__add_unique_with_custom_name@add_unique_custom_email_unique_Postgres.snap 135 B
    
    📄 vespertide_query__sql__tests__add_unique_with_custom_name@add_unique_custom_email_unique_Sqlite.snap 135 B
    
    📄 vespertide_query__sql__tests__add_unnamed_index@add_unnamed_index_email_MySql.snap 121 B
    
    📄 vespertide_query__sql__tests__add_unnamed_index@add_unnamed_index_email_password_MySql.snap 142 B
    
    📄 vespertide_query__sql__tests__add_unnamed_index@add_unnamed_index_email_password_Postgres.snap 142 B
    
    📄 vespertide_query__sql__tests__add_unnamed_index@add_unnamed_index_email_password_Sqlite.snap 142 B
    
    📄 vespertide_query__sql__tests__add_unnamed_index@add_unnamed_index_email_Postgres.snap 121 B
    
    📄 vespertide_query__sql__tests__add_unnamed_index@add_unnamed_index_email_Sqlite.snap 121 B
    
    📄 vespertide_query__sql__tests__add_unnamed_unique@add_unnamed_unique_email_MySql.snap 128 B
    
    📄 vespertide_query__sql__tests__add_unnamed_unique@add_unnamed_unique_email_Postgres.snap 128 B
    
    📄 vespertide_query__sql__tests__add_unnamed_unique@add_unnamed_unique_email_Sqlite.snap 128 B
    
    📄 vespertide_query__sql__tests__add_unnamed_unique@add_unnamed_unique_email_username_MySql.snap 149 B
    
    📄 vespertide_query__sql__tests__add_unnamed_unique@add_unnamed_unique_email_username_Postgres.snap 149 B
    
    📄 vespertide_query__sql__tests__add_unnamed_unique@add_unnamed_unique_email_username_Sqlite.snap 149 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_column@add_column_MySql.snap 115 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_column@add_column_Postgres.snap 115 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_column@add_column_Sqlite.snap 115 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_constraint@add_constraint_MySql.snap 133 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_constraint@add_constraint_Postgres.snap 133 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_constraint@add_constraint_Sqlite.snap 133 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_index_constraint@add_index_constraint_MySql.snap 127 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_index_constraint@add_index_constraint_Postgres.snap 127 B
    
    📄 vespertide_query__sql__tests__build_action_queries_add_index_constraint@add_index_constraint_Sqlite.snap 127 B
    
    📄 vespertide_query__sql__tests__build_action_queries_delete_column@delete_column_MySql.snap 111 B
    
    📄 vespertide_query__sql__tests__build_action_queries_delete_column@delete_column_Postgres.snap 111 B
    
    📄 vespertide_query__sql__tests__build_action_queries_delete_column@delete_column_Sqlite.snap 111 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_comment@mysql_modify_comment.snap 147 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_comment@postgres_modify_comment.snap 129 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_comment@sqlite_modify_comment.snap 72 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_default@mysql_modify_default.snap 136 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_default@postgres_modify_default.snap 134 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_default@sqlite_modify_default.snap 259 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_nullable@mysql_modify_nullable.snap 188 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_nullable@postgres_modify_nullable.snap 186 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_nullable@sqlite_modify_nullable.snap 309 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_type@modify_column_type_MySql.snap 118 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_type@modify_column_type_Postgres.snap 122 B
    
    📄 vespertide_query__sql__tests__build_action_queries_modify_column_type@modify_column_type_Sqlite.snap 235 B
    
    📄 vespertide_query__sql__tests__build_action_queries_raw_sql@raw_sql_MySql.snap 81 B
    
    📄 vespertide_query__sql__tests__build_action_queries_raw_sql@raw_sql_Postgres.snap 81 B
    
    📄 vespertide_query__sql__tests__build_action_queries_raw_sql@raw_sql_Sqlite.snap 81 B
    
    📄 vespertide_query__sql__tests__build_action_queries_remove_constraint@remove_constraint_MySql.snap 123 B
    
    📄 vespertide_query__sql__tests__build_action_queries_remove_constraint@remove_constraint_Postgres.snap 103 B
    
    📄 vespertide_query__sql__tests__build_action_queries_remove_constraint@remove_constraint_Sqlite.snap 274 B
    
    📄 vespertide_query__sql__tests__build_action_queries_remove_index_constraint@remove_index_constraint_MySql.snap 115 B
    
    📄 vespertide_query__sql__tests__build_action_queries_remove_index_constraint@remove_index_constraint_Postgres.snap 104 B
    
    📄 vespertide_query__sql__tests__build_action_queries_remove_index_constraint@remove_index_constraint_Sqlite.snap 104 B
    
    📄 vespertide_query__sql__tests__build_action_queries_rename_column@rename_column_MySql.snap 130 B
    
    📄 vespertide_query__sql__tests__build_action_queries_rename_column@rename_column_Postgres.snap 130 B
    
    📄 vespertide_query__sql__tests__build_action_queries_rename_column@rename_column_Sqlite.snap 130 B
    
    📄 vespertide_query__sql__tests__build_action_queries_rename_table@rename_table_MySql.snap 111 B
    
    📄 vespertide_query__sql__tests__build_action_queries_rename_table@rename_table_Postgres.snap 117 B
    
    📄 vespertide_query__sql__tests__build_action_queries_rename_table@rename_table_Sqlite.snap 117 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_default_mysql.snap 204 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_default_postgres.snap 204 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_default_sqlite.snap 204 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_fk_mysql.snap 324 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_fk_postgres.snap 324 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_fk_sqlite.snap 324 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_inline_primary_key_mysql.snap 215 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_inline_primary_key_postgres.snap 215 B
    
    📄 vespertide_query__sql__tests__build_migration_action@build_migration_action_create_table_with_inline_primary_key_sqlite.snap 215 B
    
    📄 vespertide_query__sql__tests__create_table_with_function_default@create_table_func_default_MySql.snap 197 B
    
    📄 vespertide_query__sql__tests__create_table_with_function_default@create_table_func_default_Postgres.snap 215 B
    
    📄 vespertide_query__sql__tests__create_table_with_function_default@create_table_func_default_Sqlite.snap 235 B
    
    📄 vespertide_query__sql__tests__delete_column_with_enum_type@delete_enum_column_MySql.snap 114 B
    
    📄 vespertide_query__sql__tests__delete_column_with_enum_type@delete_enum_column_Postgres.snap 146 B
    
    📄 vespertide_query__sql__tests__delete_column_with_enum_type@delete_enum_column_Sqlite.snap 243 B
    
    📄 vespertide_query__sql__tests__remove_index_with_custom_name@remove_index_custom_hello_MySql.snap 109 B
    
    📄 vespertide_query__sql__tests__remove_index_with_custom_name@remove_index_custom_hello_Postgres.snap 99 B
    
    📄 vespertide_query__sql__tests__remove_index_with_custom_name@remove_index_custom_hello_Sqlite.snap 99 B
    
    📄 vespertide_query__sql__tests__remove_unique_with_custom_name@remove_unique_custom_email_unique_MySql.snap 125 B
    
    📄 vespertide_query__sql__tests__remove_unique_with_custom_name@remove_unique_custom_email_unique_Postgres.snap 106 B
    
    📄 vespertide_query__sql__tests__remove_unique_with_custom_name@remove_unique_custom_email_unique_Sqlite.snap 233 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_index@remove_unnamed_index_email_MySql.snap 109 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_index@remove_unnamed_index_email_password_MySql.snap 118 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_index@remove_unnamed_index_email_password_Postgres.snap 108 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_index@remove_unnamed_index_email_password_Sqlite.snap 108 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_index@remove_unnamed_index_email_Postgres.snap 99 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_index@remove_unnamed_index_email_Sqlite.snap 99 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_unique@remove_unnamed_unique_email_MySql.snap 118 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_unique@remove_unnamed_unique_email_Postgres.snap 99 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_unique@remove_unnamed_unique_email_Sqlite.snap 233 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_unique@remove_unnamed_unique_email_username_MySql.snap 127 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_unique@remove_unnamed_unique_email_username_Postgres.snap 108 B
    
    📄 vespertide_query__sql__tests__remove_unnamed_unique@remove_unnamed_unique_email_username_Sqlite.snap 274 B
    
    📄 add_column.rs 24.6 KB
    
    📄 add_constraint.rs 50.6 KB
    
    📄 create_table.rs 27.6 KB
    
    📄 delete_column.rs 40.2 KB
    
    📄 delete_table.rs 1.4 KB
    
    📄 helpers.rs 37.8 KB
    
    📄 mod.rs 52.6 KB
    
    📄 modify_column_comment.rs 18.8 KB
    
    📄 modify_column_default.rs 20.0 KB
    
    📄 modify_column_nullable.rs 19.1 KB
    
    📄 modify_column_type.rs 37.6 KB
    
    📄 raw_sql.rs 1.2 KB
    
    📄 remove_constraint.rs 59.7 KB
    
    📄 rename_column.rs 1.6 KB
    
    📄 rename_table.rs 1.5 KB
    
    📄 types.rs 3.3 KB
    
    📄 builder.rs 28.7 KB
    
    📄 error.rs 182 B
    
    📄 lib.rs 176 B
  - 📁 tests/
    
    📄 composite_unique_test.rs 3.6 KB
    
    📄 enum_migration_test.rs 4.3 KB
    
    📄 table_prefixed_enum_test.rs 6.0 KB
  - 📄 AGENTS.md 2.8 KB
  - 📄 Cargo.toml 498 B
  - 📄 CLAUDE.md 11 B
- 📁 vespertide-schema-gen/
  - 📁 src/
    
    📄 main.rs 5.1 KB
  - 📁 tests/
    
    📄 integration_test.rs 1.7 KB
  - 📄 Cargo.toml 680 B
📁 examples/
- 📁 app/
  - 📁 migrations/
    
    📄 0001_init.vespertide.json 7.4 KB
  - 📁 models/
    
    📄 article.json 1.4 KB
    
    📄 article_user.json 1.2 KB
    
    📄 media.json 1.1 KB
    
    📄 user.json 1021 B
    
    📄 user_media_role.json 1.0 KB
  - 📁 src/
    
    📁 models/
    
    📄 article.rs 1.7 KB
    
    📄 article_user.rs 1.4 KB
    
    📄 media.rs 1.2 KB
    
    📄 mod.rs 93 B
    
    📄 user.rs 1.3 KB
    
    📄 user_media_role.rs 1.3 KB
    
    📁 models_sqlalchemy/
    
    📄 article.py 1.4 KB
    
    📄 article_user.py 1010 B
    
    📄 media.py 1018 B
    
    📄 user.py 986 B
    
    📄 user_media_role.py 942 B
    
    📁 models_sqlmodel/
    
    📄 article.py 925 B
    
    📄 article_user.py 654 B
    
    📄 media.py 693 B
    
    📄 user.py 652 B
    
    📄 user_media_role.py 642 B
    
    📄 main.rs 927 B
  - 📄 Cargo.toml 389 B
  - 📄 vespertide.json 121 B
📁 schemas/
- 📄 config.schema.json 3.0 KB
- 📄 migration.schema.json 18.8 KB
- 📄 model.schema.json 11.9 KB
📄 .gitignore 72 B
📄 AGENTS.md 5.7 KB
📄 Cargo.lock 105.5 KB
📄 Cargo.toml 1.2 KB
📄 CLAUDE.md 11 B
📄 LICENSE 11.1 KB
📄 README.md 8.3 KB
📄 SKILL.md 17.6 KB

SKILL.md

---
name: vespertide
description: Define database schemas in JSON and generate migration plans. Use this skill when creating or modifying database models, defining tables with columns, constraints, and ENUM types for Vespertide-based projects.
---

# Vespertide Database Schema Definition

Declarative database schema management. Define tables in JSON, generate typed migrations and SQL.

## Schema Validation (MANDATORY)

Every model file MUST include `$schema`. Before saving: ensure no IDE validation errors, then run `vespertide diff`.

```json
{
  "$schema": "https://raw.githubusercontent.com/dev-five-git/vespertide/refs/heads/main/schemas/model.schema.json",
  "name": "table_name",
  "columns": []
}
```

## Post-Edit Validation (MANDATORY)

After EVERY model edit, run:

```bash
vespertide diff   # Check for parsing errors and expected changes
vespertide sql    # Preview generated SQL for correctness
```

Only proceed to `vespertide revision` after both pass cleanly.

---

## Installation

```bash
cargo install vespertide-cli
```

## CLI Commands

| Command | Description |
|---------|-------------|
| `vespertide init` | Initialize `vespertide.json` with defaults |
| `vespertide new <name>` | Create model template with `$schema` |
| `vespertide new <name> -f yaml` | Create model in specific format (`json`/`yaml`/`yml`) |
| `vespertide diff` | Show pending changes between migrations and models |
| `vespertide sql` | Preview SQL for next migration (default: postgres) |
| `vespertide sql -b mysql` | SQL for specific backend (`postgres`/`mysql`/`sqlite`) |
| `vespertide log` | Show SQL per applied migration |
| `vespertide log -b mysql` | Migration log for specific backend |
| `vespertide status` | Show config and sync overview |
| `vespertide revision -m "msg"` | Create migration file |
| `vespertide revision -m "msg" --fill-with table.col=value` | Create migration with fill values (repeatable) |
| `vespertide export --orm seaorm` | Export to ORM code (`seaorm`/`sqlalchemy`/`sqlmodel`) |
| `vespertide export --orm seaorm -d out/` | Export to custom directory |

---

## Configuration (`vespertide.json`)

```json
{
  "modelsDir": "models",
  "migrationsDir": "migrations",
  "tableNamingCase": "snake",
  "columnNamingCase": "snake",
  "modelFormat": "json",
  "migrationFormat": "json",
  "migrationFilenamePattern": "%04v_%m",
  "modelExportDir": "src/models",
  "prefix": "",
  "seaorm": {
    "extraEnumDerives": ["vespera::Schema"],
    "extraModelDerives": [],
    "enumNamingCase": "camel",
    "vesperaSchemaType": true
  }
}
```

| Field | Type | Default | Description |
|-------|------|---------|-------------|
| `modelsDir` | string | `"models"` | Model JSON files directory |
| `migrationsDir` | string | `"migrations"` | Migration files directory |
| `tableNamingCase` | string | `"snake"` | `snake` / `camel` / `pascal` |
| `columnNamingCase` | string | `"snake"` | `snake` / `camel` / `pascal` |
| `modelFormat` | string | `"json"` | `json` / `yaml` / `yml` |
| `migrationFormat` | string | `"json"` | `json` / `yaml` / `yml` |
| `migrationFilenamePattern` | string | `"%04v_%m"` | `%v`=version, `%m`=message |
| `modelExportDir` | string | `"src/models"` | ORM export output directory |
| `prefix` | string | `""` | Prefix for all table names |

**SeaORM Config** (`seaorm` nested object):

| Field | Type | Default | Description |
|-------|------|---------|-------------|
| `extraEnumDerives` | string[] | `["vespera::Schema"]` | Extra derives for generated enums |
| `extraModelDerives` | string[] | `[]` | Extra derives for entity models |
| `enumNamingCase` | string | `"camel"` | Serde `rename_all` for enums |
| `vesperaSchemaType` | bool | `true` | Generate `vespera::schema_type!` calls |

---

## Exported ORM Files (DO NOT EDIT)

> **CRITICAL**: Files in `src/models/` (e.g. `src/models/*.rs`, `src/models/*.py`) are AUTO-GENERATED by `vespertide export`. **NEVER manually create or edit these files.** Always edit source models in `models/*.json`, then regenerate:

```bash
# Edit models/*.json -> regenerate
vespertide export --orm seaorm
```

## Migration / Revision Files (DO NOT EDIT)

> **CRITICAL**: Migration files in the `migrations/` directory are AUTO-GENERATED by `vespertide revision`. **NEVER manually create, edit, or modify revision files.** Always edit source models in `models/*.json`, then create a new revision:

```bash
# Edit models/*.json -> create revision
vespertide revision -m "describe your change"
```

**Only exception**: Adding `fill_with` values when prompted (NOT NULL columns without defaults).

```json
{
  "type": "add_column",
  "table": "user",
  "column": {
    "name": "status",
    "type": "text",
    "nullable": false
  },
  "fill_with": "'active'"
}
```

---

## Model Structure

```json
{
  "$schema": "https://raw.githubusercontent.com/dev-five-git/vespertide/refs/heads/main/schemas/model.schema.json",
  "name": "table_name",
  "description": "Optional table description",
  "columns": [ /* ColumnDef[] */ ],
  "constraints": [ /* Optional: CHECK constraints only */ ]
}
```

| Field | Required | Type | Description |
|-------|----------|------|-------------|
| `name` | yes | string | Table name (snake_case) |
| `columns` | yes | array | Column definitions |
| `description` | no | string | Table documentation |
| `constraints` | no | array | Table-level constraints (CHECK only) |

---

## Column Definition

### Required Fields

```json
{ "name": "column_name", "type": "ColumnType", "nullable": false }
```

### Optional Fields

| Field | Type | Description |
|-------|------|-------------|
| `default` | string \| boolean \| number | Default value |
| `comment` | string | Column documentation |
| `primary_key` | boolean \| object | Inline primary key |
| `unique` | boolean \| string \| string[] | Inline unique constraint |
| `index` | boolean \| string \| string[] | Inline index |
| `foreign_key` | string \| object | Inline foreign key |

---

## Column Types

### Simple Types (string values)

| Type | SQL | Type | SQL |
|------|-----|------|-----|
| `"small_int"` | SMALLINT | `"text"` | TEXT |
| `"integer"` | INTEGER | `"boolean"` | BOOLEAN |
| `"big_int"` | BIGINT | `"uuid"` | UUID |
| `"real"` | REAL | `"json"` | JSON |
| `"double_precision"` | DOUBLE PRECISION | `"bytea"` | BYTEA |
| `"date"` | DATE | `"inet"` | INET |
| `"time"` | TIME | `"cidr"` | CIDR |
| `"timestamp"` | TIMESTAMP | `"macaddr"` | MACADDR |
| `"timestamptz"` | TIMESTAMPTZ | `"xml"` | XML |
| `"interval"` | INTERVAL | | |

### Complex Types (object values)

```json
{ "kind": "varchar", "length": 255 }
{ "kind": "char", "length": 2 }
{ "kind": "numeric", "precision": 10, "scale": 2 }
{ "kind": "enum", "name": "...", "values": [...] }
{ "kind": "custom", "custom_type": "..." }
```

### Enum Types (RECOMMENDED for status/category fields)

**String Enum** (PostgreSQL native enum):
```json
{
  "name": "status",
  "type": {
    "kind": "enum",
    "name": "article_status",
    "values": ["draft", "review", "published", "archived"]
  },
  "nullable": false,
  "default": "'draft'"
}
```

**Integer Enum** (stored as INTEGER -- no DB migration needed for new values):
```json
{
  "name": "role",
  "type": {
    "kind": "enum",
    "name": "user_role",
    "values": [
      { "name": "guest", "value": 0 },
      { "name": "user", "value": 10 },
      { "name": "moderator", "value": 50 },
      { "name": "admin", "value": 100 }
    ]
  },
  "nullable": false,
  "default": 0
}
```

> **Tip**: Leave gaps in integer values (0, 10, 50, 100) to allow inserting new values without renumbering.

| Scenario | Recommended Type |
|----------|------------------|
| Status fields (order_status, user_status) | String or Integer enum |
| Categories with fixed values | String enum |
| Priority/severity levels | Integer enum |
| Roles with potential expansion | Integer enum |

---

## Inline Constraints (PREFERRED)

> Always define constraints on columns. Use table-level `constraints` ONLY for CHECK expressions.

### Primary Key

```json
{ "name": "id", "type": "integer", "nullable": false, "primary_key": true }
{ "name": "id", "type": "integer", "nullable": false, "primary_key": { "auto_increment": true } }
```

### Unique

```json
{ "name": "email", "type": "text", "nullable": false, "unique": true }
```

Named composite unique:
```json
{ "name": "tenant_id", "type": "integer", "nullable": false, "unique": ["uq_tenant_user"] },
{ "name": "username", "type": "text", "nullable": false, "unique": ["uq_tenant_user"] }
```

### Index

```json
{ "name": "email", "type": "text", "nullable": false, "index": true }
```

Composite index:
```json
{ "name": "user_id", "type": "integer", "nullable": false, "index": ["idx_user_created"] },
{ "name": "created_at", "type": "timestamptz", "nullable": false, "index": ["idx_user_created"] }
```

### Foreign Key

Object syntax (recommended):
```json
{
  "name": "user_id",
  "type": "integer",
  "nullable": false,
  "foreign_key": {
    "ref_table": "user",
    "ref_columns": ["id"],
    "on_delete": "cascade",
    "on_update": null
  },
  "index": true
}
```

Shorthand syntax:
```json
{ "name": "user_id", "type": "integer", "nullable": false, "foreign_key": "user.id", "index": true }
```

**Reference Actions** (snake_case): `"cascade"`, `"restrict"`, `"set_null"`, `"set_default"`, `"no_action"`

> Always add `"index": true` on foreign key columns for query performance.

### Composite Primary Key (Inline)

Both columns with `"primary_key": true` create a single composite primary key:
```json
{
  "columns": [
    { "name": "user_id", "type": "integer", "nullable": false, "primary_key": true },
    { "name": "role_id", "type": "integer", "nullable": false, "primary_key": true }
  ]
}
```

---

## Table-Level Constraints (CHECK only)

> Use inline constraints for everything else (PK, unique, index, FK).

```json
"constraints": [
  { "type": "check", "name": "check_positive_amount", "expr": "amount > 0" },
  { "type": "check", "name": "check_dates", "expr": "end_date > start_date" }
]
```

---

## Default Values

| Type | Example | Notes |
|------|---------|-------|
| String literal | `"'pending'"` | Single quotes inside string |
| Boolean | `true` / `false` | Native JSON boolean |
| Integer | `0` | Native JSON number |
| Float | `0.0` | Native JSON number |
| SQL function | `"NOW()"` | No quotes around function |
| UUID generation | `"gen_random_uuid()"` | PostgreSQL |

---

## Runtime Migration Macro

Use `vespertide_migration!` to run migrations at application startup:

```toml
[dependencies]
vespertide = "0.1"
sea-orm = { version = "2.0.0-rc", features = ["sqlx-postgres", "runtime-tokio-native-tls", "macros"] }
```

```rust
use sea_orm::Database;

#[tokio::main]
async fn main() -> anyhow::Result<()> {
    let db = Database::connect("postgres://user:pass@localhost/mydb").await?;
    vespertide::vespertide_migration!(db).await?;
    Ok(())
}
```

The macro generates database-specific SQL at compile time for zero-runtime overhead.

---

## Complete Examples

### User Table with Enum Status

```json
{
  "$schema": "https://raw.githubusercontent.com/dev-five-git/vespertide/refs/heads/main/schemas/model.schema.json",
  "name": "user",
  "columns": [
    { "name": "id", "type": "integer", "nullable": false, "primary_key": { "auto_increment": true } },
    { "name": "email", "type": "text", "nullable": false, "unique": true, "index": true },
    { "name": "name", "type": { "kind": "varchar", "length": 100 }, "nullable": false },
    {
      "name": "status",
      "type": { "kind": "enum", "name": "user_status", "values": ["pending", "active", "suspended", "deleted"] },
      "nullable": false,
      "default": "'pending'"
    },
    { "name": "metadata", "type": "json", "nullable": true },
    { "name": "created_at", "type": "timestamptz", "nullable": false, "default": "NOW()" },
    { "name": "updated_at", "type": "timestamptz", "nullable": true }
  ]
}
```

### Order Table with Integer Enum and CHECK

```json
{
  "$schema": "https://raw.githubusercontent.com/dev-five-git/vespertide/refs/heads/main/schemas/model.schema.json",
  "name": "order",
  "columns": [
    { "name": "id", "type": "uuid", "nullable": false, "primary_key": true, "default": "gen_random_uuid()" },
    {
      "name": "customer_id",
      "type": "integer",
      "nullable": false,
      "foreign_key": { "ref_table": "customer", "ref_columns": ["id"], "on_delete": "restrict" },
      "index": true
    },
    { "name": "total", "type": { "kind": "numeric", "precision": 10, "scale": 2 }, "nullable": false },
    {
      "name": "priority",
      "type": {
        "kind": "enum",
        "name": "order_priority",
        "values": [
          { "name": "low", "value": 0 },
          { "name": "normal", "value": 10 },
          { "name": "high", "value": 20 },
          { "name": "urgent", "value": 30 }
        ]
      },
      "nullable": false,
      "default": 10
    },
    {
      "name": "status",
      "type": { "kind": "enum", "name": "order_status", "values": ["pending", "confirmed", "shipped", "delivered", "cancelled"] },
      "nullable": false,
      "default": "'pending'"
    },
    { "name": "notes", "type": "text", "nullable": true },
    { "name": "created_at", "type": "timestamptz", "nullable": false, "default": "NOW()" }
  ],
  "constraints": [
    { "type": "check", "name": "check_total_positive", "expr": "total >= 0" }
  ]
}
```

### Many-to-Many Join Table

```json
{
  "$schema": "https://raw.githubusercontent.com/dev-five-git/vespertide/refs/heads/main/schemas/model.schema.json",
  "name": "user_role",
  "columns": [
    {
      "name": "user_id",
      "type": "integer",
      "nullable": false,
      "primary_key": true,
      "foreign_key": { "ref_table": "user", "ref_columns": ["id"], "on_delete": "cascade" }
    },
    {
      "name": "role_id",
      "type": "integer",
      "nullable": false,
      "primary_key": true,
      "foreign_key": { "ref_table": "role", "ref_columns": ["id"], "on_delete": "cascade" },
      "index": true
    },
    { "name": "granted_at", "type": "timestamptz", "nullable": false, "default": "NOW()" },
    { "name": "granted_by", "type": "integer", "nullable": true, "foreign_key": "user.id" }
  ]
}
```

---

## Workflow Summary

```bash
# 1. Create model
vespertide new user

# 2. Edit models/user.json

# 3. Validate
vespertide diff          # Check changes
vespertide sql           # Preview SQL

# 4. Create migration
vespertide revision -m "create user table"

# 5. Export ORM code (if needed)
vespertide export --orm seaorm
```

---

## Guidelines Summary

### MUST DO

1. Always include `$schema` in every model file
2. Always specify `nullable` on every column
3. Run `vespertide diff` + `vespertide sql` after every model edit
4. Index foreign key columns (`"index": true`)
5. Use inline constraints (`primary_key`, `unique`, `index`, `foreign_key` on columns)

### SHOULD DO

1. Use enums for status/category fields (prefer over text + CHECK)
2. Use integer enums for expandable value sets (no migration needed)
3. Use `timestamptz` over `timestamp` (timezone-aware)
4. Use `json` type for JSON data (cross-backend compatible)

### MUST NOT DO

1. **Manually create/edit/modify revision (migration) files** -- use `vespertide revision` only
2. **Manually create/edit `src/models/*.rs` (or `*.py`) files** -- use `vespertide export` to regenerate
3. Use PascalCase for reference actions -- use `"cascade"` not `"Cascade"`
4. Skip schema validation
5. Add NOT NULL columns without `default` or `fill_with`
6. Use table-level constraints for anything except CHECK
7. Use `jsonb` type -- use `json` instead (not supported cross-backend)
8. Use `custom` types -- breaks cross-database compatibility
9. Use array types -- use a join table instead

---

## Naming Conventions

| Item | Convention | Example |
|------|------------|---------|
| Tables | snake_case | `user_role` |
| Columns | snake_case | `created_at` |
| Indexes | `ix_{table}__{columns}` | `ix_user__email` |
| Unique | `uq_{table}__{columns}` | `uq_user__email` |
| Foreign Key | `fk_{table}__{columns}` | `fk_post__author_id` |
| Check | `check_{description}` | `check_positive_amount` |
| Enums | snake_case | `order_status` |

> **Note**: Auto-generated constraint names use double underscore `__` as separator.

---

## Quick Reference

```
SIMPLE TYPES                              COMPLEX TYPES
----------------------------------------  ----------------------------------------
integer, big_int, small_int   Numbers     { "kind": "varchar", "length": N }
real, double_precision        Floats      { "kind": "char", "length": N }
text                          Strings     { "kind": "numeric", "precision": P, "scale": S }
boolean                       Flags       { "kind": "enum", "name": "...", "values": [...] }
date, time, timestamp         Time        { "kind": "custom", "custom_type": "..." }
timestamptz, interval         Time+
uuid                          UUIDs       REFERENCE ACTIONS (snake_case!)
json                          JSON        ----------------------------------------
bytea                         Binary      cascade, restrict, set_null,
inet, cidr, macaddr           Network     set_default, no_action
xml                           XML

CONSTRAINT TYPES (inline preferred)       DATABASE BACKENDS
----------------------------------------  ----------------------------------------
primary_key, unique, index,               postgres (default), mysql, sqlite
foreign_key, check
```

---

## Troubleshooting

| Error | Cause | Fix |
|-------|-------|-----|
| Invalid enum in `on_delete` | PascalCase used | Use `"cascade"` not `"Cascade"` |
| Missing required property | `nullable` omitted | Add `"nullable": true/false` |
| Unknown column type | Typo in type name | Check column types table above |
| FK validation failed | Referenced table missing | Create referenced table first |
| NOT NULL without default | Adding column to existing table | Add `default` or use `fill_with` in revision |

Comments 0

Latest | Hot

Please login before commenting.

No comments yet. Be the first one!

vespertide

Directory Structure

SKILL.md

Report

Notice