Create New db.json from running instance?

[GraybeardCoder]

I ran an ALTER TABLE statement in my staging DB docker container. When I refresh the full DB schema in Wappler, it doesn't show the updated table structure. I noticed that the db.json file doesn't get updated and therefore is appears Wappler does not know about this new table column. Is there a way to generate a new db.json file based on the running schema?

[Apple]

@GraybeardCoder

I ran an ALTER TABLE statement in my staging DB docker container.

Does this mean you're not using Wappler migrations/changes?

@GraybeardCoder

Is there a way to generate a new db.json file based on the running schema?

In the database manager right click your database and tables and click "Refresh Full Schema" or similar button

[GraybeardCoder]

I try to use Wappler for DB changes, but my app is at the point where I need more granular control over table schema at times.

I have performed a "refresh full" numerous times with no update reflected. What did work was a right click on the specific table I altered and selecting "refresh schema".

[Apple]

@GraybeardCoder

but my app is at the point where I need more granular control over table schema at times

You can still use Knex migrations if you hand-code

@GraybeardCoder

I have performed a "refresh full" numerous times with no update reflected. What did work was a right click on the specific table I altered and selecting "refresh schema".

True, there's a bug report for that somewhere, don't know the current status, that's why I mentioned "and tables"