View resources / tables generated by another ORM

[motor-admin]

View resources / tables generated by another ORM

[omohokcoj]

Hi @laloweb99 - motor admin should display all tables which are present in your postgresql database automatically.
If you have some custom sql view in your Gorm application then you probably need to copy that sql code into motor admin queries to display it there.

[laloweb99]

I have the "papers" table on the public schema but is not being shown on motor admin. I'm running the docker compose. Is there a way to sync the tables on moto admin?

[omohokcoj]

@laloweb99 it seems like you are using the same docker compose postgresql for motor admin configuration tables and for application data tables.
You need to make sure that motor admin is connected to the same docker compose database with papers table here (if that's what is intended):
http://localhost:3000/settings/database

But usually application data should be stored in a separate database (meaning that your papers table won't be in the same database with motor_admin_users table) - you can specify databases using this link http://localhost:3000/settings/database (might require to restart a server).

Please let me know if this solves the issue.

[laloweb99]

I moved the "papers" table to an app database but it's still not showing the "papers" resource:

DB config on motor admin

Tables on app databse

Resources shown in motor admin

[omohokcoj]

@laloweb99 apparently the table was not visible because it didn't contain a primary key.
This bug has been fixed in the latest 0.2.38 release - you can update your docker image with docker pull motoradmin/motoradmin:latest

[laloweb99]

Now it shows the table 😄 thank you so much!