schema.sql not being updated with most current version/schema definitions

[nesfandi]

To reproduce:

• houseplant generate "test_users_table"
• cat test_users_table.yml:

 version: "20250311155058"
name: test_users_table
table: test_users

development: &development
  up: |
    CREATE TABLE {table} (
      id UInt64,
      name String
    ) ENGINE = MergeTree()
    ORDER BY id
    SETTINGS storage_policy='gcs_main'
  down: |
    DROP TABLE {table}

test:
  <<: *development

production:
  up: |
  down: |
    DROP TABLE {table}

• houseplant migrate:up

• Results from houseplant migrate:status

Database: default
┏━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┓
┃ Status ┃ Migration ID   ┃ Migration Name   ┃
┡━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━┩
│   up   │ 20250311155058 │ test users table │
└────────┴────────────────┴──────────────────┘

• cat schema.sql

-- version: 0

Would be nice to have a command to manually update schema.sql if need be. Other than that, really enjoy the project.

[nesfandi]

Is this project still being maintained? @vinayak-mehta

[nesfandi]

Also discovered the schema.sql file updates correctly when running houseplant migrate:up {version} but not when simply running houseplant migrate:up